[2026-01-21 01:27:16] ======== START PROCESS ========
[2026-01-21 01:27:16] Last tabtrans_id: 1535482
[2026-01-21 01:27:16] Query:
[2026-01-21 01:27:16] SELECT 
TRIM(nasabah.nasabah_id) AS cif
,CASE
    WHEN nasabah.TGL_BUKA = '0000-00-00' THEN NULL
    ELSE nasabah.TGL_BUKA
END AS tgl_registrasi_cif
,TRIM(nasabah.NAMA_NASABAH) AS nama_nasabah
,TRIM(nasabah.NO_HP) AS no_handphone
,TRIM(nasabah.no_id) AS nik
,TRIM(tabung.NO_REKENING) AS no_rekening
,CONCAT('8545',TRIM(tabung.no_va)) AS no_rekening_va
,kodejenistabungan.KODE_JENIS_TABUNGAN AS kode_jenis_tabungan
,kodejenistabungan.DESKRIPSI_JENIS_TABUNGAN AS jenis_tabungan
,tabung.TGL_REGISTRASI AS tgl_registrasi
,kodegroup1tabung.KODE_GROUP1 AS kode_marketing
,kodegroup1tabung.DESKRIPSI_GROUP1 AS marketing
,tabung.SETORAN_MINIMUM AS setoran_minimum
,tabung.SETORAN_PER_BLN AS setoran_per_bulan
,tabung.SALDO_NOMINATIF AS saldo_nominatif
,tabung.SALDO_BLOKIR AS saldo_blokir
,tabung.SALDO_AKHIR AS saldo_akhir
,tabung.STATUS_AKTIF AS status_aktif
,tabung.NO_REK_KREDIT AS rekening_autodebet
,tabung.and_or AS and_or_flag
,tabung.JKW AS jangka_waktu
,CASE
	WHEN tabung.TGL_JT = '0000-00-00' THEN '9999-12-31'
    ELSE tabung.TGL_JT
END AS tgl_jatuh_tempo
,kodegroup2tabung.DESKRIPSI_GROUP2 AS deskripsi_kodegroup2
,kodegroup3tabung.DESKRIPSI_GROUP3 AS deskripsi_kodegroup3
,kodegroup4tabung.DESKRIPSI_GROUP4 AS deskripsi_kodegroup4
,kodegroup5tabung.DESKRIPSI_GROUP5 AS deskripsi_kodegroup5
,tabtrans.TABTRANS_ID AS tabtrans_id
FROM tabung
JOIN tabtrans ON tabung.NO_REKENING = tabtrans.NO_REKENING AND tabtrans.TGL_TRANS >= CURDATE() - INTERVAL 2 DAY
LEFT JOIN kodejenistabungan ON tabung.JENIS_TABUNGAN = kodejenistabungan.KODE_JENIS_TABUNGAN
LEFT JOIN nasabah ON tabung.NASABAH_ID = nasabah.nasabah_id
LEFT JOIN kodegroup1tabung ON tabung.KODE_GROUP1 = kodegroup1tabung.KODE_GROUP1
LEFT JOIN kodegroup2tabung ON tabung.KODE_GROUP2 = kodegroup2tabung.KODE_GROUP2
LEFT JOIN kodegroup3tabung ON tabung.KODE_GROUP3 = kodegroup3tabung.KODE_GROUP3
LEFT JOIN kodegroup4tabung ON tabung.KODE_GROUP4 = kodegroup4tabung.KODE_GROUP4
LEFT JOIN kodegroup5tabung ON tabung.KODE_GROUP5 = kodegroup5tabung.KODE_GROUP5
WHERE tabtrans.TABTRANS_ID > 1535482 ORDER BY tabtrans.TABTRANS_ID
;

[2026-01-21 01:27:16] Tidak ada data terbaru
[2026-01-21 01:27:16] ========  END PROCESS  ========