---
# System prepended metadata

title: Pelaporan Data FDC OJK.
tags: [List Project, documentation, reportojk]

---

![](https://i.imgur.com/GQQ0Ear.png)
###### tags: `List Project` `reportojk` `documentation`

# Pelaporan Data FDC OJK.
[TOC]
## Alur Proses.
``` sequence
UangTeman->DB CRO: Query data \ntransaksional\n(Exp,Outstanding & WriteOff)
DB CRO-->UangTeman: CSV Format \nZIP with encrypt 'inipunyauangteman'
UangTeman->FDC OJK: Send ZIP File via SFTP
FDC OJK-->UangTeman: Report Result
```

***Keterangan*** :
- *Database CRO* : 
    ```Config
    IP :116.206.196.7
    Port :3309
    User : reza_cro
    Passoword : Rezacro@123
    Db : cro_reports
    ```
- *Query Data* Transaksional : 
    ```Mysql
    SELECT * FROM cro_reports.upload_to_sik 
    WHERE tgl_pelaporan_data=DATE_FORMAT(NOW()-INTERVAL 1 DAY,'%Y%m%d')
    ```
- Data sudah tersedia pukul 02.15 pagi.
- Format CSV : 


    | ID Penyelenggara | Tgl pelaporan data| Version|
    | -------- | -------- | -------- |
    | 820012     | 20200121     | SIK01|
    *Result* : **82001220200121SIK01.CSV**

- Konversi ke ZIP File dan Enkripsi.
    ```Password
    Password: inipunyauangteman
    ```
- Kirim ZIP File via SFTP.
    ```ConfigSFTP
    Host : pusdafil.afpi.or.id
    Username : 820012
    Password :6@Ni$&5266SvR}$s
    Location : folder /in
    sent file : 2.30 Pagi
    ```
- Hasil pelaporan terdapat di folder /out.

