UVdr9kQ5

1
2CREATE TABLE IF NOT EXISTS `error_nasabah` (
3  `error_id` int(20) NOT NULL AUTO_INCREMENT,
4  `jenis_error` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
5  `total` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
6  `no_proposal` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
7  PRIMARY KEY (`error_id`)
8) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
9
10--
11-- Dumping data for table `error_nasabah`
12--
13
14
15-- --------------------------------------------------------
16
17--
18-- Table structure for table `mtb_agama`
19--
20
21CREATE TABLE IF NOT EXISTS `mtb_agama` (
22  `agama_id` int(2) NOT NULL AUTO_INCREMENT,
23  `nama` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
24  PRIMARY KEY (`agama_id`)
25) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;
26
27--
28-- Dumping data for table `mtb_agama`
29--
30
31INSERT INTO `mtb_agama` (`agama_id`, `nama`) VALUES
32(1, 'Islam'),
33(2, 'Katholik'),
34(3, 'Protestan'),
35(4, 'Hindu'),
36(5, 'Budha'),
37(6, 'Konghuchu');
38
39-- --------------------------------------------------------
40
41--
42-- Table structure for table `mtb_email_notif`
43--
44
45CREATE TABLE IF NOT EXISTS `mtb_email_notif` (
46  `email_notif_id` int(2) NOT NULL,
47  `nama` text COLLATE utf8_unicode_ci NOT NULL,
48  PRIMARY KEY (`email_notif_id`)
49) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
50
51--
52-- Dumping data for table `mtb_email_notif`
53--
54
55INSERT INTO `mtb_email_notif` (`email_notif_id`, `nama`) VALUES
56(1, 'Semua (Email notifikasi saat input proposal, nasabah ditolak dan approval)'),
57(2, 'Proposal (Email notifikasi saat input proposal)'),
58(3, 'Approval (Email notifikasi saat proses approval)'),
59(4, 'Nasabah Tolak (Email notifikasi saat input nasabah di tolak)'),
60(5, 'Tidak Aktif');
61
62-- --------------------------------------------------------
63
64--
65-- Table structure for table `mtb_hak_akses`
66--
67
68CREATE TABLE IF NOT EXISTS `mtb_hak_akses` (
69  `id_hak_akses` int(3) NOT NULL,
70  `nama_hak_akses` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
71  PRIMARY KEY (`id_hak_akses`)
72) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
73
74--
75-- Dumping data for table `mtb_hak_akses`
76--
77
78INSERT INTO `mtb_hak_akses` (`id_hak_akses`, `nama_hak_akses`) VALUES
79(1, 'Admin'),
80(2, 'Approval'),
81(3, 'Inputer'),
82(4, 'User');
83
84-- --------------------------------------------------------
85
86--
87-- Table structure for table `mtb_jabatan`
88--
89
90CREATE TABLE IF NOT EXISTS `mtb_jabatan` (
91  `id_jabatan` int(3) NOT NULL AUTO_INCREMENT,
92  `nama_jabatan` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
93  PRIMARY KEY (`id_jabatan`)
94) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=23 ;
95
96--
97-- Dumping data for table `mtb_jabatan`
98--
99
100INSERT INTO `mtb_jabatan` (`id_jabatan`, `nama_jabatan`) VALUES
101(8, 'Branch Manager'),
102(9, 'Sub Branch Manager'),
103(13, 'Manager Marketing (MM)'),
104(14, 'Area Sales Manager (ASM)'),
105(15, 'Kepala Warung Mikro (KWM)'),
106(16, 'Retail Banking Officer (RBO)'),
107(19, 'Officer Gadai (OG)'),
108(20, 'Sales Assistant (SA)'),
109(21, 'Asisten Analis Mikro (AAM)'),
110(22, 'Pelaksana Penaksir Gadai (PPG)');
111
112-- --------------------------------------------------------
113
114--
115-- Table structure for table `mtb_jenis_identitas`
116--
117
118CREATE TABLE IF NOT EXISTS `mtb_jenis_identitas` (
119  `identitas_id` int(2) NOT NULL,
120  `nama` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
121  PRIMARY KEY (`identitas_id`)
122) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
123
124--
125-- Dumping data for table `mtb_jenis_identitas`
126--
127
128INSERT INTO `mtb_jenis_identitas` (`identitas_id`, `nama`) VALUES
129(1, 'KTP'),
130(2, 'SIM'),
131(3, 'Passport');
132
133-- --------------------------------------------------------
134
135--
136-- Table structure for table `mtb_kolektabilitas`
137--
138
139CREATE TABLE IF NOT EXISTS `mtb_kolektabilitas` (
140  `kolektabilitas_id` int(11) NOT NULL AUTO_INCREMENT,
141  `nama` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
142  PRIMARY KEY (`kolektabilitas_id`)
143) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;
144
145--
146-- Dumping data for table `mtb_kolektabilitas`
147--
148
149INSERT INTO `mtb_kolektabilitas` (`kolektabilitas_id`, `nama`) VALUES
150(1, 'Lancar'),
151(5, 'Dalam Perhatian Khusus'),
152(6, 'Kurang Lancar'),
153(7, 'Diragukan'),
154(8, 'Macet');
155
156-- --------------------------------------------------------
157
158--
159-- Table structure for table `mtb_level_jabatan`
160--
161
162CREATE TABLE IF NOT EXISTS `mtb_level_jabatan` (
163  `level_jabatan_id` int(3) NOT NULL AUTO_INCREMENT,
164  `nama_jabatan` varchar(50) COLLATE utf8_bin DEFAULT NULL,
165  PRIMARY KEY (`level_jabatan_id`)
166) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;
167
168--
169-- Dumping data for table `mtb_level_jabatan`
170--
171
172INSERT INTO `mtb_level_jabatan` (`level_jabatan_id`, `nama_jabatan`) VALUES
173(1, 'Supervisor'),
174(2, 'Officer'),
175(3, 'Pelaksana');
176
177-- --------------------------------------------------------
178
179--
180-- Table structure for table `mtb_list_email`
181--
182
183CREATE TABLE IF NOT EXISTS `mtb_list_email` (
184  `id_list_email` int(10) NOT NULL AUTO_INCREMENT,
185  `email_address` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
186  `nama_pengguna` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
187  `jabatan_id` int(3) DEFAULT NULL,
188  `status` tinyint(2) NOT NULL,
189  `NIP` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
190  PRIMARY KEY (`id_list_email`)
191) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
192
193--
194-- Dumping data for table `mtb_list_email`
195--
196
197INSERT INTO `mtb_list_email` (`id_list_email`, `email_address`, `nama_pengguna`, `jabatan_id`, `status`, `NIP`) VALUES
198(4, 'rnur1780@bsm.co.id', 'Ridwan Nur', 9, 1, '047871780');
199
200-- --------------------------------------------------------
201
202--
203-- Table structure for table `mtb_mailer`
204--
205
206CREATE TABLE IF NOT EXISTS `mtb_mailer` (
207  `mail_id` int(1) NOT NULL,
208  `host` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
209  `nama` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
210  `password` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
211  `port` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
212  `proposal_baru` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
213  `nasabah_tolak` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
214  `approval` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
215  PRIMARY KEY (`mail_id`)
216) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
217
218--
219-- Dumping data for table `mtb_mailer`
220--
221
222INSERT INTO `mtb_mailer` (`mail_id`, `host`, `nama`, `password`, `port`, `proposal_baru`, `nasabah_tolak`, `approval`) VALUES
223(1, 'mail.syariahmandiri.co.id', 'rnur1780@syariahmandiri.co.id', 'hasbunallah01', '443', '0', '0', '0');
224
225-- --------------------------------------------------------
226
227--
228-- Table structure for table `mtb_pegawai`
229--
230
231CREATE TABLE IF NOT EXISTS `mtb_pegawai` (
232  `pegawai_id` int(4) NOT NULL AUTO_INCREMENT,
233  `no_urut` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
234  `nama` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
235  `NIP` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
236  `jabatan` int(3) DEFAULT NULL,
237  `no_handphone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
238  `email` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
239  `unit_kerja` int(2) DEFAULT NULL,
240  `email_atasan` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
241  `level_jabatan` int(3) DEFAULT NULL,
242  PRIMARY KEY (`pegawai_id`)
243) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=17 ;
244
245--
246-- Dumping data for table `mtb_pegawai`
247--
248
249INSERT INTO `mtb_pegawai` (`pegawai_id`, `no_urut`, `nama`, `NIP`, `jabatan`, `no_handphone`, `email`, `unit_kerja`, `email_atasan`, `level_jabatan`) VALUES
250(16, '032', 'Maria Gunarti', '108676080', 21, '0813-74190906', 'mgunarti@bsm.co.id', 3, 'rnur1780@bsm.co.id', 3),
251(15, '031', 'Nicko Gemayel', '148713908', 20, '0852-71589848', 'ngemayel@bsm.co.id', 3, 'rnur1780@bsm.co.id', 3),
252(14, '030', 'Silvany Riza', '118278205', 20, '0812-6524091', 'sriza@bsm.co.id', 3, 'rnur1780@bsm.co.id', 3),
253(13, '011', 'Ridwan Nur', '047871780', 9, '0852-76102270', 'rnur1780@bsm.co.id', 3, 'alhuda@bsm.co.id', 2),
254(12, '010', 'Alhuda Djannis', '007270489', 8, '0816-1368853', 'alhuda@bsm.co.id', 2, 'ddurachman@bsm.co.id', 2),
255(9, '1', 'Ulil', '123', 11, '', '', NULL, '', 1),
256(11, '001', 'Administrator', '76102270', 9, '0853-76102270', 'drankoto25@gmail.com', 3, 'rnur1780@bsm.co.id', 1);
257
258-- --------------------------------------------------------
259
260--
261-- Table structure for table `mtb_segmen`
262--
263
264CREATE TABLE IF NOT EXISTS `mtb_segmen` (
265  `segmen_id` int(2) NOT NULL AUTO_INCREMENT,
266  `nama` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
267  PRIMARY KEY (`segmen_id`)
268) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;
269
270--
271-- Dumping data for table `mtb_segmen`
272--
273
274INSERT INTO `mtb_segmen` (`segmen_id`, `nama`) VALUES
275(1, 'Komersial'),
276(4, 'Konsumer'),
277(5, 'Small'),
278(6, 'Mikro'),
279(7, 'Gadai');
280
281-- --------------------------------------------------------
282
283--
284-- Table structure for table `mtb_status_nasabah`
285--
286
287CREATE TABLE IF NOT EXISTS `mtb_status_nasabah` (
288  `id_status` int(2) NOT NULL AUTO_INCREMENT,
289  `nama_status` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
290  PRIMARY KEY (`id_status`)
291) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
292
293--
294-- Dumping data for table `mtb_status_nasabah`
295--
296
297INSERT INTO `mtb_status_nasabah` (`id_status`, `nama_status`) VALUES
298(1, 'Baru'),
299(2, 'Ditolak'),
300(3, 'Diterima'),
301(4, 'Applied');
302
303-- --------------------------------------------------------
304
305--
306-- Table structure for table `mtb_status_proposal`
307--
308
309CREATE TABLE IF NOT EXISTS `mtb_status_proposal` (
310  `status_id` int(3) NOT NULL AUTO_INCREMENT,
311  `nama` varchar(30) COLLATE utf8_bin DEFAULT NULL,
312  PRIMARY KEY (`status_id`)
313) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;
314
315--
316-- Dumping data for table `mtb_status_proposal`
317--
318
319INSERT INTO `mtb_status_proposal` (`status_id`, `nama`) VALUES
320(1, 'Proposal'),
321(2, 'Pengajuan Tolak'),
322(3, 'Tolak');
323
324-- --------------------------------------------------------
325
326--
327-- Table structure for table `mtb_unit_kerja`
328--
329
330CREATE TABLE IF NOT EXISTS `mtb_unit_kerja` (
331  `unit_kerja_id` int(3) NOT NULL AUTO_INCREMENT,
332  `nama` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
333  PRIMARY KEY (`unit_kerja_id`)
334) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;
335
336--
337-- Dumping data for table `mtb_unit_kerja`
338--
339
340INSERT INTO `mtb_unit_kerja` (`unit_kerja_id`, `nama`) VALUES
341(2, 'KC Bukittinggi'),
342(3, 'KCP Lubuk Sikaping'),
343(4, 'KCP Padang Panjang'),
344(5, 'KCP Pasaman Barat'),
345(6, 'KCP Lubuk Basung'),
346(7, 'KCP Batusangkar'),
347(8, 'KCP Pasar Aur'),
348(9, 'KCP Sawahlunto');
349
350-- --------------------------------------------------------
351
352--
353-- Table structure for table `mtb_user`
354--
355
356CREATE TABLE IF NOT EXISTS `mtb_user` (
357  `user_id` int(10) NOT NULL AUTO_INCREMENT,
358  `user_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
359  `email_address` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
360  `jabatan_id` int(2) NOT NULL DEFAULT '0',
361  `password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
362  `hak_akses` int(2) NOT NULL DEFAULT '0',
363  `NIP` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
364  `id_pegawai` int(5) DEFAULT NULL,
365  PRIMARY KEY (`user_id`)
366) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=31 ;
367
368--
369-- Dumping data for table `mtb_user`
370--
371
372INSERT INTO `mtb_user` (`user_id`, `user_name`, `email_address`, `jabatan_id`, `password`, `hak_akses`, `NIP`, `id_pegawai`) VALUES
373(25, 'Silvany Riza', 'sriza@bsm.co.id', 20, '$2a$13$ZpEVPaz3OV2ks3AbHHQHvujkmxnroRMsFM9r0gDGewjIvFJaLyFSq', 3, '118278205', 14),
374(26, 'Nicko Gemayel', 'ngemayel@bsm.co.id', 20, '$2a$13$ce.cboX9jbVNd2T2fv8pbOSa2cuY6jM8Gzd45DYU2JjVu49ZEi60G', 3, '148713908', 15),
375(27, 'Maria Gunarti', 'mgunarti@bsm.co.id', 21, '$2a$13$rrSQT8Io7Oee4Nf81Y2v0.qAe2uVT97Rs//mn/nM9zV2w0Z8hF6Ce', 3, '108676080', 16),
376(28, 'Alhuda Djannis', 'alhuda@bsm.co.id', 8, '$2a$13$lzu2Wrp84b3mBpbt884jpOXnPv5egkZIUWACjz6bf3F8vH9RWQ.Vu', 2, '007270489', 12),
377(29, 'Ridwan Nur', 'rnur1780@bsm.co.id', 9, '$2a$13$ItTVNFqT8IMemrgSITnnIuqo4SZovc9wleKxuRoi3hB2skCYsiH8K', 2, '047871780', 13),
378(30, 'Administrator', 'drankoto25@gmail.com', 9, '$2a$13$QxQ/Tw4kdL8XlFVyqsU8BuXnSUCnlv4931JJdHxx.nLlmZceYefZ.', 1, '76102270', 11);
379
380-- --------------------------------------------------------
381
382--
383-- Table structure for table `pelunasan`
384--
385
386CREATE TABLE IF NOT EXISTS `pelunasan` (
387  `pelunasan_id` int(10) NOT NULL AUTO_INCREMENT,
388  `tanggal_pelunasan` date DEFAULT NULL,
389  `penyebab` text COLLATE utf8_bin,
390  `segmen` int(2) DEFAULT NULL,
391  `jenis_usaha` varchar(50) COLLATE utf8_bin DEFAULT NULL,
392  `nama_nasabah` varchar(100) COLLATE utf8_bin DEFAULT NULL,
393  `no_CIF` varchar(50) COLLATE utf8_bin DEFAULT NULL,
394  `no_rekening` varchar(50) COLLATE utf8_bin DEFAULT NULL,
395  `plafon_awal` varchar(20) COLLATE utf8_bin DEFAULT NULL,
396  `OS_pokok_terakhir` varchar(20) COLLATE utf8_bin DEFAULT NULL,
397  `angsuran` varchar(20) COLLATE utf8_bin DEFAULT NULL,
398  `kolektibilitas_terakhir` varchar(20) COLLATE utf8_bin DEFAULT NULL,
399  `alamat_nasabah` text COLLATE utf8_bin,
400  `jenis_pembiayaan` int(2) DEFAULT NULL,
401  `margin` varchar(8) COLLATE utf8_bin DEFAULT NULL,
402  `tunggakan_terakhir` varchar(20) COLLATE utf8_bin DEFAULT NULL,
403  `status_pelunasan` varchar(2) COLLATE utf8_bin DEFAULT '1',
404  `marketing` varchar(5) COLLATE utf8_bin DEFAULT '10',
405  PRIMARY KEY (`pelunasan_id`)
406) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
407
408--
409-- Dumping data for table `pelunasan`
410--
411
412INSERT INTO `pelunasan` (`pelunasan_id`, `tanggal_pelunasan`, `penyebab`, `segmen`, `jenis_usaha`, `nama_nasabah`, `no_CIF`, `no_rekening`, `plafon_awal`, `OS_pokok_terakhir`, `angsuran`, `kolektibilitas_terakhir`, `alamat_nasabah`, `jenis_pembiayaan`, `margin`, `tunggakan_terakhir`, `status_pelunasan`, `marketing`) VALUES
413(1, '2014-10-27', 'Pasca Restrukturisasi', 6, 'Furniture', 'Basrun', '76756155', '76756155', '100000000', '55000000', '1570000', '5', 'Lubuk Sikaping', 1, '14', '15000000', '3', '14');
414
415-- --------------------------------------------------------
416
417--
418-- Table structure for table `pelunasan_jenis_pembiayaan`
419--
420
421CREATE TABLE IF NOT EXISTS `pelunasan_jenis_pembiayaan` (
422  `pembiayaan_id` int(2) NOT NULL AUTO_INCREMENT,
423  `nama` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
424  PRIMARY KEY (`pembiayaan_id`)
425) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;
426
427--
428-- Dumping data for table `pelunasan_jenis_pembiayaan`
429--
430
431INSERT INTO `pelunasan_jenis_pembiayaan` (`pembiayaan_id`, `nama`) VALUES
432(1, 'Murabahah'),
433(2, 'Salam'),
434(3, 'Istishna'),
435(4, 'Qardh'),
436(5, 'Musyarakah'),
437(6, 'Mudharabah'),
438(7, 'Ijarah');
439
440-- --------------------------------------------------------
441
442--
443-- Table structure for table `pelunasan_sebab`
444--
445
446CREATE TABLE IF NOT EXISTS `pelunasan_sebab` (
447  `id_sebab` int(2) NOT NULL AUTO_INCREMENT,
448  `nama` varchar(50) COLLATE utf8_bin DEFAULT NULL,
449  PRIMARY KEY (`id_sebab`)
450) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ;
451
452--
453-- Dumping data for table `pelunasan_sebab`
454--
455
456INSERT INTO `pelunasan_sebab` (`id_sebab`, `nama`) VALUES
457(1, 'Write Off'),
458(2, 'Pasca Restrukturisasi'),
459(3, 'Penjualan Agunan'),
460(4, 'Lelang Agunan'),
461(5, 'Litigasi'),
462(6, 'Lain-lain');
463
464-- --------------------------------------------------------
465
466--
467-- Table structure for table `proposal`
468--
469
470CREATE TABLE IF NOT EXISTS `proposal` (
471  `proposal_id` int(10) NOT NULL AUTO_INCREMENT,
472  `plafon` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
473  `tanggal_pengajuan` date DEFAULT NULL,
474  `segmen` int(2) NOT NULL,
475  `jenis_usaha` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
476  `marketing` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
477  `no_kartu_keluarga` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
478  `no_buku_nikah` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
479  `no_ktp` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
480  `no_proposal` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
481  `status_pengajuan` varchar(3) COLLATE utf8_unicode_ci DEFAULT '1',
482  `jenis_nasabah` int(2) DEFAULT NULL,
483  `existing_plafon` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
484  `existing_os` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
485  `existing_angsuran` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
486  `existing_kolektabilitas` int(2) DEFAULT NULL,
487  `referal_nama` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
488  `referal_alamat` text COLLATE utf8_unicode_ci,
489  `referal_telp` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
490  `referal_sektor_usaha` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
491  `referal_fasilitas` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
492  `referal_kolektabilitas` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
493  `del_flag` int(11) DEFAULT '0',
494  `nama_nasabah` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
495  `jenis_identitas` int(2) DEFAULT NULL,
496  `tanggal_kartu_keluarga` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
497  PRIMARY KEY (`proposal_id`)
498) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
499
500--
501-- Dumping data for table `proposal`
502--
503
504INSERT INTO `proposal` (`proposal_id`, `plafon`, `tanggal_pengajuan`, `segmen`, `jenis_usaha`, `marketing`, `no_kartu_keluarga`, `no_buku_nikah`, `no_ktp`, `no_proposal`, `status_pengajuan`, `jenis_nasabah`, `existing_plafon`, `existing_os`, `existing_angsuran`, `existing_kolektabilitas`, `referal_nama`, `referal_alamat`, `referal_telp`, `referal_sektor_usaha`, `referal_fasilitas`, `referal_kolektabilitas`, `del_flag`, `nama_nasabah`, `jenis_identitas`, `tanggal_kartu_keluarga`) VALUES
505(1, '750000000', '2014-10-02', 5, 'Developer', '14', 'AAAAAA-KK', 'AAAAAA-BN', 'AAAAAA-KTP', '0001/10/2014', '3', 1, '', '', '', NULL, '', '', '', '', '', '', 0, 'Tuan A', 1, '1980-11-07'),
506(2, '250000000', '2014-10-09', 4, 'PNS', '14', 'BBBBBB-KK', '', 'BBBBBB-KTP', '0002/10/2014', '3', 2, '250000000', '200000000', '1500000', 1, '', '', '', '', '', '', 0, 'Tuan B', 1, '2014-10-19'),
507(3, '85000000', '2014-10-20', 6, 'Toko Kelontong', '16', 'CCCCCC-KK', 'CCCCCC=BN', 'CCCCCC-KTP', '0003/10/2014', '1', 3, '', '', '', NULL, 'Happy ', 'Dua Koto', '0853-888888', 'Pedagang Emas', '150000000', '1', 0, 'Tuan C', 2, '2000-11-31'),
508(4, '1000000000', '2014-10-09', 5, 'P & D', '15', 'DDDDDD-KK', 'DDDDDD-BN', 'DDDDDD-KTP', '0004/10/2014', '1', 1, '', '', '', NULL, '', '', '', '', '', '', 0, 'Tuan D', 1, '1979-11-22');
509
510-- --------------------------------------------------------
511
512--
513-- Table structure for table `proposal_buku_nikah`
514--
515
516CREATE TABLE IF NOT EXISTS `proposal_buku_nikah` (
517  `proposal_id` int(5) DEFAULT NULL,
518  `no_buku_nikah` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
519  `tgl_buku_nikah` date DEFAULT NULL
520) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
521
522--
523-- Dumping data for table `proposal_buku_nikah`
524--
525
526INSERT INTO `proposal_buku_nikah` (`proposal_id`, `no_buku_nikah`, `tgl_buku_nikah`) VALUES
527(1, 'AAAAAA-BN', '1980-10-07'),
528(3, 'CCCCCC=BN', '2000-10-31'),
529(4, 'DDDDDD-BN', '1979-10-22');
530
531-- --------------------------------------------------------
532
533--
534-- Table structure for table `proposal_kartu_keluarga`
535--
536
537CREATE TABLE IF NOT EXISTS `proposal_kartu_keluarga` (
538  `no_kartu_keluarga` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
539  `nama` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
540  `tanggal_lahir` date DEFAULT NULL,
541  `no_ktp` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
542  `proposal_id` int(5) DEFAULT NULL,
543  `tempat_lahir` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
544) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
545
546--
547-- Dumping data for table `proposal_kartu_keluarga`
548--
549
550INSERT INTO `proposal_kartu_keluarga` (`no_kartu_keluarga`, `nama`, `tanggal_lahir`, `no_ktp`, `proposal_id`, `tempat_lahir`) VALUES
551('AAAAAA-KK', 'Istri Tuan A', '1981-10-07', 'AAAAAA-Istri', 1, 'Rao'),
552('AAAAAA-KK', 'Anak Tuan A', '1982-10-07', 'AAAAAA-Anak', 1, 'Rao'),
553('CCCCCC-KK', 'Istri Tuan C', '2001-10-31', 'CCCCCC-Istri', 3, 'Duo Koto'),
554('CCCCCC-KK', 'Anak Tuan C', '2002-10-31', 'CCCCCC-Anak', 3, 'Duo Koto'),
555('DDDDDD-KK', 'Istri Tuan D', '1960-10-22', 'DDDDDD-Istri', 4, 'Tapus');
556
557-- --------------------------------------------------------
558
559--
560-- Table structure for table `proposal_ktp`
561--
562
563CREATE TABLE IF NOT EXISTS `proposal_ktp` (
564  `proposal_ktp_id` int(50) NOT NULL AUTO_INCREMENT,
565  `no_ktp` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
566  `tempat_lahir` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
567  `tanggal_lahir` date DEFAULT NULL,
568  `alamat` text COLLATE utf8_unicode_ci,
569  `agama` int(2) DEFAULT NULL,
570  `status_perkawinan` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
571  `pekerjaan` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
572  `kewarganegaraan` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
573  `masa_berlaku` date DEFAULT NULL,
574  `proposal_id` int(5) DEFAULT NULL,
575  `desa` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
576  PRIMARY KEY (`proposal_ktp_id`)
577) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
578
579--
580-- Dumping data for table `proposal_ktp`
581--
582
583INSERT INTO `proposal_ktp` (`proposal_ktp_id`, `no_ktp`, `tempat_lahir`, `tanggal_lahir`, `alamat`, `agama`, `status_perkawinan`, `pekerjaan`, `kewarganegaraan`, `masa_berlaku`, `proposal_id`, `desa`) VALUES
584(1, 'AAAAAA-KTP', 'Rao', '1960-10-07', 'Rao', 1, 'Kawin', 'Kontraktor', 'Indonesia', '2015-10-07', 1, 'Rao'),
585(2, 'BBBBBB-KTP', 'Panti', '1950-10-19', 'Panti', 1, 'Tidak Kawin', 'PNS', 'Indonesia', '2017-10-19', 2, 'Panti'),
586(3, 'CCCCCC-KTP', 'Duo Koto', '1990-10-31', 'Duo Koto', 1, 'Kawin', 'Pedagang', 'Indonesia', '2018-10-31', 3, 'Duo Koto'),
587(4, 'DDDDDD-KTP', 'Tapus', '1959-10-22', 'Tapus', 1, 'Kawin', 'Pedagang', 'Indonesia', '2018-10-22', 4, 'Tapus');
588
589-- --------------------------------------------------------
590
591--
592-- Table structure for table `tolak`
593--
594
595CREATE TABLE IF NOT EXISTS `tolak` (
596  `tolak_id` int(20) NOT NULL AUTO_INCREMENT,
597  `proposal_id` int(5) DEFAULT NULL,
598  `tanggal_tolak` date DEFAULT NULL,
599  `alasan_ditolak` text COLLATE utf8_unicode_ci,
600  `tahap_penolakan` text COLLATE utf8_unicode_ci,
601  PRIMARY KEY (`tolak_id`)
602) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
603
604--
605-- Dumping data for table `tolak`
606--
607
608INSERT INTO `tolak` (`tolak_id`, `proposal_id`, `tanggal_tolak`, `alasan_ditolak`, `tahap_penolakan`) VALUES
609(1, 2, '2014-10-27', 'Kol.5 di BRI', 'BI Checking'),
610(2, 1, '2014-10-22', 'Usaha tidak dapat diyakini', 'Informasi diragukan');
611
612-- --------------------------------------------------------
613
614--
615-- Table structure for table `tolak_tahapan`
616--
617
618CREATE TABLE IF NOT EXISTS `tolak_tahapan` (
619  `tahapan_id` int(3) NOT NULL AUTO_INCREMENT,
620  `nama` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
621  PRIMARY KEY (`tahapan_id`)
622) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;
623
624--
625-- Dumping data for table `tolak_tahapan`
626--
627
628INSERT INTO `tolak_tahapan` (`tahapan_id`, `nama`) VALUES
629(1, 'BI Checking'),
630(2, 'DHN BI'),
631(3, 'Blacklist PPATK'),
632(4, 'OTS Usaha'),
633(5, 'OTS Agunan'),
634(6, 'Komite'),
635(7, 'Lain-lain');
636
637-- --------------------------------------------------------
638
639--
640-- Table structure for table `vote_jawab`
641--
642
643CREATE TABLE IF NOT EXISTS `vote_jawab` (
644  `id_jawab` int(5) NOT NULL AUTO_INCREMENT,
645  `soal_id` int(3) DEFAULT NULL,
646  `jawaban` varchar(20) COLLATE utf8_bin DEFAULT NULL,
647  `id_pegawai` varchar(50) COLLATE utf8_bin DEFAULT NULL,
648  `tanggal_vote` date DEFAULT NULL,
649  PRIMARY KEY (`id_jawab`)
650) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=37 ;
651
652--
653-- Dumping data for table `vote_jawab`
654--
655
656INSERT INTO `vote_jawab` (`id_jawab`, `soal_id`, `jawaban`, `id_pegawai`, `tanggal_vote`) VALUES
657(1, 1, 'Penting', '16', '2014-10-27'),
658(2, 2, 'Sangat Penting', '16', '2014-10-27'),
659(3, 3, 'Penting', '16', '2014-10-27'),
660(4, 4, 'Penting', '16', '2014-10-27'),
661(5, 5, 'Sangat Penting', '16', '2014-10-27'),
662(6, 6, 'Sangat Penting', '16', '2014-10-27'),
663(7, 1, 'Penting', '14', '2014-10-27'),
664(8, 2, 'Sangat Penting', '14', '2014-10-27'),
665(9, 3, 'Sangat Penting', '14', '2014-10-27'),
666(10, 4, 'Sangat Penting', '14', '2014-10-27'),
667(11, 5, 'Sangat Penting', '14', '2014-10-27'),
668(12, 6, 'Sangat Penting', '14', '2014-10-27'),
669(13, 1, 'Sangat Penting', '15', '2014-10-27'),
670(14, 2, 'Sangat Penting', '15', '2014-10-27'),
671(15, 3, 'Penting', '15', '2014-10-27'),
672(16, 4, 'Cukup Penting', '15', '2014-10-27'),
673(17, 5, 'Sangat Penting', '15', '2014-10-27'),
674(18, 6, 'Sangat Penting', '15', '2014-10-27'),
675(19, 1, 'Sangat Penting', '13', '2014-10-27'),
676(20, 2, 'Sangat Penting', '13', '2014-10-27'),
677(21, 3, 'Sangat Penting', '13', '2014-10-27'),
678(22, 4, 'Sangat Penting', '13', '2014-10-27'),
679(23, 5, 'Sangat Penting', '13', '2014-10-27'),
680(24, 6, 'Sangat Penting', '13', '2014-10-27'),
681(25, 1, 'Sangat Penting', '14', '2014-10-27'),
682(26, 2, 'Sangat Penting', '14', '2014-10-27'),
683(27, 3, 'Sangat Penting', '14', '2014-10-27'),
684(28, 4, 'Sangat Penting', '14', '2014-10-27'),
685(29, 5, 'Sangat Penting', '14', '2014-10-27'),
686(30, 6, 'Sangat Penting', '14', '2014-10-27'),
687(31, 1, 'Sangat Penting', '15', '2014-10-27'),
688(32, 2, 'Sangat Penting', '15', '2014-10-27'),
689(33, 3, 'Sangat Penting', '15', '2014-10-27'),
690(34, 4, 'Sangat Penting', '15', '2014-10-27'),
691(35, 5, 'Sangat Penting', '15', '2014-10-27'),
692(36, 6, 'Penting', '15', '2014-10-27');
693
694-- --------------------------------------------------------
695
696--
697-- Table structure for table `vote_soal`
698--
699
700CREATE TABLE IF NOT EXISTS `vote_soal` (
701  `id_soal` int(3) NOT NULL AUTO_INCREMENT,
702  `soal` text COLLATE utf8_bin,
703  `group_soal` int(3) DEFAULT NULL,
704  `rank` int(3) DEFAULT NULL,
705  `pilihan_jawaban` text COLLATE utf8_bin,
706  PRIMARY KEY (`id_soal`)
707) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ;
708
709--
710-- Dumping data for table `vote_soal`
711--
712
713INSERT INTO `vote_soal` (`id_soal`, `soal`, `group_soal`, `rank`, `pilihan_jawaban`) VALUES
714(1, 'Apakah Aplikasi membantu dalam melaksanakan proses pembiayaan sesuai ketentuan di BSM?', 1, 1, 'Sangat Penting,Penting,Cukup Penting,Tidak Penting'),
715(2, 'Apakah Aplikasi membantu dalam proses pemeriksaan internal di tahap investigasi pembiayaan?', 1, 2, 'Sangat Penting,Penting,Cukup Penting,Tidak Penting'),
716(3, 'Apakah aplikasi membantu Ka.Unit dalam pengambilan keputusan pembiayaan?\r\n', 1, 3, 'Sangat Penting,Penting,Cukup Penting,Tidak Penting'),
717(4, 'Apakah Aplikasi membantu dalam menghindari potensi pembiayaan bermasalah?', 1, 4, 'Sangat Penting,Penting,Cukup Penting,Tidak Penting'),
718(5, 'Apakah Aplikasi membantu Ka.Unit dalam mereview produktivitas marketing?', 1, 5, 'Sangat Penting,Penting,Cukup Penting,Tidak Penting'),
719(6, 'Apakah Aplikasi PENTING dalam memitigasi resiko dan penerapan prudensial banking?\r\n', 1, 6, 'Sangat Penting,Penting,Cukup Penting,Tidak Penting');
720
721-- --------------------------------------------------------
722
723--
724-- Table structure for table `watchlist`
725--
726
727CREATE TABLE IF NOT EXISTS `watchlist` (
728  `watchlist_id` int(10) NOT NULL AUTO_INCREMENT,
729  `no_loan` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
730  `nama_nasabah` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
731  `total_tunggakan` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
732  `kolektibilitas` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
733  `jenis_produk` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
734  `no_CIF` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
735  `no_rekening_angsuran` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
736  `plafon` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
737  `os_pokok` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
738  `angsuran_bulanan` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
739  `persentase_bagi_hasil` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
740  `usaha_nasabah` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
741  `tujuan_pembiayaan` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
742  PRIMARY KEY (`watchlist_id`)
743) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=125 ;
744
745--
746-- Dumping data for table `watchlist`
747--
748
749INSERT INTO `watchlist` (`watchlist_id`, `no_loan`, `nama_nasabah`, `total_tunggakan`, `kolektibilitas`, `jenis_produk`, `no_CIF`, `no_rekening_angsuran`, `plafon`, `os_pokok`, `angsuran_bulanan`, `persentase_bagi_hasil`, `usaha_nasabah`, `tujuan_pembiayaan`) VALUES
750(1, 'LD1314238362', 'DINA RYANI', '1045639.87', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
751(2, 'LD1314249872', 'DEDE ROMEIZON', '761824.24', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
752(3, 'LD1314251867', 'SUCI HARTINI', '436549.22', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
753(4, 'LD1314255716', 'ZULHASMI', '2365774.85', '2C', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
754(5, 'LD1314256570', 'HENDRI HIDAYAT', '1601058.70', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
755(6, 'LD1314256928', 'MULHASBUANDI HSB', '110926973.79', '5', 'Murabahah', NULL, NULL, '', '', '', NULL, NULL, NULL),
756(7, 'LD1314257155', 'ARMIYANTO', '767670.23', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
757(8, 'LD1314260020', 'YUSRIZAL M', '1634311.56', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
758(9, 'LD1314264716', 'JONAFFERI', '1864012.05', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
759(10, 'LD1314264999', 'SYAFRI MUNIR', '2873352.82', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
760(11, 'LD1314265080', 'IRFAN', '2311036.22', '2A', 'WM UTAMA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
761(12, 'LD1314271678', 'AMRI MASTA', '1643045.20', '2A', 'WM UTAMA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
762(13, 'LD1314274493', 'JASMAN AHMADI', '2090304.47', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
763(14, 'LD1314276280', 'ZUBAIDAH', '16330558.24', '5', 'WM UTAMA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
764(15, 'LD1314280851', 'NONO HARYADI', '1660415.60', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
765(16, 'LD1314281442', 'ARMEN NASIR', '2090304.47', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
766(17, 'LD1314282192', 'SERENTAK TARIGAN', '1416863.26', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
767(18, 'LD1314292434', 'SYOFIAR', '1656686.62', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
768(19, 'LD1314294824', 'WIRA NOVALDI', '1932320.98', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
769(20, 'LD1314296714', 'HENDRA FITNARDI', '260568.79', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
770(21, 'LD1314296781', 'SYAFRIL', '3073434.85', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
771(22, 'LD1314311902', 'ANGGI MUCHTAR', '1826092.34', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
772(23, 'LD1314312095', 'YUNALDI', '3333917.88', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
773(24, 'LD1314312767', 'NUR AINI', '1011653.15', '2A', 'WM UTAMA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
774(25, 'LD1314313821', 'SATRIA EMALDI', '1754927.71', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
775(26, 'LD1314321070', 'JUMADI YASSER', '170876.23', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
776(27, 'LD1314327610', 'ASLAN LUBIS', '2330015.06', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
777(28, 'LD1314361046', 'RENI GUSPITA', '27444100.13', '3A', 'KECIL KOMERSIAL NON WM', NULL, NULL, '', '', '', NULL, NULL, NULL),
778(29, 'LD1314374795', 'YULISMAN R', '2748968.52', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
779(30, 'LD1314376068', 'AMRIL', '750631.91', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
780(31, 'LD1314376164', 'SRINARMI', '6598737.24', '2A', 'KECIL KOMERSIAL NON WM', NULL, NULL, '', '', '', NULL, NULL, NULL),
781(32, 'LD1314376170', 'ZULHERMANSYAH', '2990308.78', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
782(33, 'LD1314376212', 'ARIEF BUDIMAN', '1932320.98', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
783(34, 'LD1314376223', 'GUSMAL HARIS', '2691277.90', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
784(35, 'LD1314378940', 'EDWARMAN', '1491688.55', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
785(36, 'LD1314379908', 'HALIJAR', '16494934.36', '2B', 'CONSUMER MURABAHAH IRREGU', NULL, NULL, '', '', '', NULL, NULL, NULL),
786(37, 'LD1314380409', 'RIO ALATAS PUTRA', '1739088.88', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
787(38, 'LD1314380436', 'HENDY HAMULIA', '2709588.74', '2A', 'CONSUMER KENDARAAN OTOMOT', NULL, NULL, '', '', '', NULL, NULL, NULL),
788(39, 'LD1314400562', 'ZULKARNAINI', '3597743.32', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
789(40, 'LD1314400567', 'AAN ERFANI', '2584858.42', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
790(41, 'LD1314403880', 'JONWIR IBRA', '1747511.31', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
791(42, 'LD1314403882', 'HEFIAL MEIYARDI', '1589191.83', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
792(43, 'LD1314403888', 'JASMIWARDI', '1932320.98', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
793(44, 'LD1314404634', 'DESSY ASFRI YENTIE', '951578.89', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
794(45, 'LD1314404637', 'YULFAIZAL', '10282.19', '1', 'KECIL KOMERSIAL NON WM', NULL, NULL, '', '', '', NULL, NULL, NULL),
795(46, 'LD1314414185', 'HAIRUL SALEH HASIBUAN', '1826092.34', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
796(47, 'LD1314414188', 'ASHADI', '1826092.34', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
797(48, 'LD1314414190', 'YENTI', '1732156.77', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
798(49, 'LD1314414192', 'YUSMAR', '665164.00', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
799(50, 'LD1314416418', 'RUDI', '2090304.47', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
800(51, 'LD1314416474', 'WEFRIZAL', '2541762.46', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
801(52, 'LD1314416814', 'EKO SAPUTRA', '2904896.11', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
802(53, 'LD1314416817', 'IDE PEBRIA SANDI', '1754927.71', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
803(54, 'LD1314416820', 'MIRIS', '2755061.99', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
804(55, 'LD1314417613', 'HASNIAL KHATIMA', '1827229.25', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
805(56, 'LD1314417621', 'MASNIZAR', '5506102.99', '2B', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
806(57, 'LD1314418097', 'YETTI SAPUTRI', '956623.62', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
807(58, 'LD1314418220', 'YULHADI', '2090304.47', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
808(59, 'LD1314418227', 'ALI SYAHBANA', '2090304.47', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
809(60, 'LD1314418778', 'AFRIAL DATUAK GAMPO', '3386085.20', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
810(61, 'LD1314418779', 'ILHAM NUR', '2723852.59', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
811(62, 'LD1314418780', 'RAHMAD FIRDAUS', '1398009.04', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
812(63, 'LD1314418982', 'WAHYUDA', '1826092.34', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
813(64, 'LD1314420671', 'ARNIZAL', '3200561.15', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
814(65, 'LD1314420854', 'YUSLINA', '1242514.97', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
815(66, 'LD1314452011', 'YONNI ZUHARMEN', '8763095.40', '4A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
816(67, 'LD1314454725', 'BURHANUDDIN PASARIBU', '19561088.68', '3A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
817(68, 'LD1314457516', 'BURHANUDDIN PASARIBU', '47432699.94', '3A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
818(69, 'LD1314462645', 'RAHMAT KARI HUSIN', '44524.14', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
819(70, 'LD1314463705', 'BENI SATRIA', '817155.77', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
820(71, 'LD1314466226', 'HENDRI YANTO', '7088082.99', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
821(72, 'LD1314466259', 'RAHMAT RETA', '3591691.03', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
822(73, 'LD1314473101', 'MEFDIA INDRA', '1754927.71', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
823(74, 'LD1314478348', 'MAYONIS', '3447978.33', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
824(75, 'LD1314478909', 'ZULKIFLI', '2651540.10', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
825(76, 'LD1314480004', 'AZWARDI', '3167441.90', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
826(77, 'LD1314481277', 'IVO OKTAVER', '4793234.70', '2B', 'WM UTAMA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
827(78, 'LD1314483377', 'EFRIJON', '1826092.34', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
828(79, 'LD1314484272', 'MADONG LUBIS', '41265103.08', '5', 'WM UTAMA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
829(80, 'LD1314484520', 'MUHAMMAD DIAR', '3072761.06', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
830(81, 'LD1314484830', 'SUWARDI', '4419233.49', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
831(82, 'LD1314486152', 'ASMA HALIM', '2160162.07', '2A', 'CONSUMER PENSIUNAN', NULL, NULL, '', '', '', NULL, NULL, NULL),
832(83, 'LD1314486153', 'ZULDESMAN', '1522829.60', '2A', 'CONSUMER PENSIUNAN', NULL, NULL, '', '', '', NULL, NULL, NULL),
833(84, 'LD1314487454', 'MUSPANDI', '424826.59', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
834(85, 'LD1314489519', 'NURMIATI', '485497.26', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
835(86, 'LD1314490986', 'HERI FADLI', '1739088.88', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
836(87, 'LD1314491675', 'RAHMAD BAYU BERMANA SAPUTRA', '1281508.29', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, '', '', '', NULL, NULL, NULL),
837(88, 'LD1314492527', 'YUNEDI', '1601058.70', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
838(89, 'LD1314496962', 'ELSA HARSIDA', '505380.12', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
839(90, 'LD1314497956', 'LAYLA NUZLIATI', '1674904.58', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
840(91, 'LD1314992706', 'RICI ALKENDRO', '1826092.35', '2A', 'MIKRO KOMERSIAL NON WM', NULL, NULL, '', '', '', NULL, NULL, NULL),
841(92, 'LD1316270897', 'FAZLY UMAR PURBA', '3857019.99', '2A', 'KECIL KOMERSIAL NON WM', NULL, NULL, '', '', '', NULL, NULL, NULL),
842(93, 'LD1317094350', 'YOKIE NOVRISA YULLANDA', '1864012.06', '2A', 'Murabahah Warung Mikro', NULL, NULL, '', '', '', NULL, NULL, NULL),
843(94, 'LD1317103708', 'YANNI ALISONDA', '2685395.37', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
844(95, 'LD1317193737', 'HENDRI KID RATRIONO', '3167441.91', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, '', '', '', NULL, NULL, NULL),
845(96, 'LD1317608596', 'SYOFIA ELIDA', '808972.38', '2A', 'Murabahah Warung Mikro', NULL, NULL, '', '', '', NULL, NULL, NULL),
846(97, 'LD1319809181', 'DEKKY PRIBADI', '105015181.42', '4C', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
847(98, 'LD1320328039', 'SUHENDRI NOER', '765656.38', '2A', 'Murabahah Warung Mikro', NULL, NULL, '', '', '', NULL, NULL, NULL),
848(99, 'LD1321441101', 'MILA DARNILA', '2681701.25', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
849(100, 'LD1321493073', 'RIZAL EFENDI', '3887231.60', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
850(101, 'LD1322428579', 'SYAMSUL KHIAR', '2966222.82', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
851(102, 'LD1324231213', 'IVO OKTAVER', '1673824.15', '2A', 'WM TUNAS PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
852(103, 'LD1324245290', 'ITA YUNI', '2172288.25', '2A', 'WM UTAMA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
853(104, 'LD1326849478', 'DARMALINDA', '1704402.03', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
854(105, 'LD1327321159', 'ROMI MARLISKHA', '390845.97', '2A', 'WM TUNAS GOLBERTAP', NULL, NULL, '', '', '', NULL, NULL, NULL),
855(106, 'LD1327632198', 'IRWAN', '3167441.91', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
856(107, 'LD1329455988', 'RAHMAT HIDAYAT', '1419405.99', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
857(108, 'LD1329461303', 'YONESHI WAHYUNI', '997260.36', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
858(109, 'LD1329504597', 'NOVA DESMITA', '771402.10', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
859(110, 'LD1331693483', 'ZULKARNAINI', '620639.47', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
860(111, 'LD1331870486', 'DONI DESVIA', '249706.57', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
861(112, 'LD1332326706', 'GUSMAL HARIS', '1067381.35', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
862(113, 'LD1334685611', 'ZULHERMANSYAH', '855579.34', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
863(114, 'LD1335386361', 'ERWAN', '285045.30', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, '', '', '', NULL, NULL, NULL),
864(115, 'LD1335396059', 'ASWIR EFENDI', '2446998.70', '2A', 'WM UTAMA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
865(116, 'LD1335837439', 'CHAIDIR LUBIS', '8384932.48', '2A', 'CONSUMER KENDARAAN OTOMOT', NULL, NULL, '', '', '', NULL, NULL, NULL),
866(117, 'LD1405255025', 'PONIMAN', '1517512.32', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
867(118, 'LD1405761266', 'EDI SISWANTO', '105694.79', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
868(119, 'LD1405768957', 'TONY SETIA', '320821.70', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
869(120, 'LD1411516160', 'WENDA EMAFRI', '386354.92', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
870(121, 'LD1414866048', 'HENDRA', '560053.99', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
871(122, 'LD1416114040', 'EDDY CHANDRA', '462884.65', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, '', '', '', NULL, NULL, NULL),
872(123, 'LD1416830949', 'RADINAL', '425077.78', '2A', 'WM TUNAS PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL),
873(124, 'LD1420473891', 'DODI', '3641022.10', '2A', 'WM UTAMA PRODUKTIF', NULL, NULL, '', '', '', NULL, NULL, NULL);
874
875-- --------------------------------------------------------
876
877--
878-- Table structure for table `watchlist_temp`
879--
880
881CREATE TABLE IF NOT EXISTS `watchlist_temp` (
882  `watchlist_id` int(10) NOT NULL AUTO_INCREMENT,
883  `no_loan` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
884  `nama_nasabah` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
885  `total_tunggakan` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
886  `kolektibilitas` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
887  `jenis_produk` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
888  `no_CIF` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
889  `no_rekening_angsuran` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
890  `plafon` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
891  `os_pokok` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
892  `angsuran_bulanan` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
893  `persentase_bagi_hasil` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
894  `usaha_nasabah` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
895  `tujuan_pembiayaan` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
896  PRIMARY KEY (`watchlist_id`)
897) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=96 ;
898
899--
900-- Dumping data for table `watchlist_temp`
901--
902
903INSERT INTO `watchlist_temp` (`watchlist_id`, `no_loan`, `nama_nasabah`, `total_tunggakan`, `kolektibilitas`, `jenis_produk`, `no_CIF`, `no_rekening_angsuran`, `plafon`, `os_pokok`, `angsuran_bulanan`, `persentase_bagi_hasil`, `usaha_nasabah`, `tujuan_pembiayaan`) VALUES
904(1, 'LD1314236296', 'ZENDA MARWATI', '2,037,776.25', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
905(2, 'LD1314238362', 'DINA RYANI', '1,040,697.06', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
906(3, 'LD1314249872', 'DEDE ROMEIZON', '758,210.85', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
907(4, 'LD1314251512', 'DONI ARDINAL', '215,230.88', '2B', 'CONSUMER IMPLAN SWASTA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
908(5, 'LD1314251867', 'SUCI HARTINI', '434,478.63', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
909(6, 'LD1314255716', 'ZULHASMI', '2,354,779.76', '2C', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
910(7, 'LD1314256570', 'HENDRI HIDAYAT', '1,593,490.39', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
911(8, 'LD1314256928', 'MULHASBUANDI HSB', '110,465,644.70', '5', 'Murabahah', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
912(9, 'LD1314257155', 'ARMIYANTO', '764,029.11', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
913(10, 'LD1314258486', 'HUSNAN HARAHAP', '6,526,099.97', '1', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
914(11, 'LD1314259513', 'ROSDAWATI HARMAINI', '204.39', '1', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
915(12, 'LD1314265080', 'IRFAN', '2,300,000.00', '1', 'WM UTAMA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
916(13, 'LD1314271678', 'AMRI MASTA', '1,635,252.10', '2A', 'WM UTAMA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
917(14, 'LD1314272201', 'JUFRIAL', '508,068.40', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
918(15, 'LD1314276280', 'ZUBAIDAH', '16,259,633.94', '5', 'WM UTAMA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
919(16, 'LD1314280851', 'NONO HARYADI', '1,652,540.11', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
920(17, 'LD1314292434', 'SYOFIAR', '1,648,855.35', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
921(18, 'LD1314296714', 'HENDRA FITNARDI', '259,332.89', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
922(19, 'LD1314312767', 'NUR AINI', '1,006,854.79', '2A', 'WM UTAMA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
923(20, 'LD1314315730', 'BUDI HERIYANTO', '1,509,736.51', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
924(21, 'LD1314327379', 'ANDOMI ROZA PUTRA', '1,044,675.42', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
925(22, 'LD1314361046', 'RENI GUSPITA', '27,319,485.40', '3A', 'KECIL KOMERSIAL NON WM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
926(23, 'LD1314374797', 'ARSENIUS MANIK', '3,948,706.44', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
927(24, 'LD1314376068', 'AMRIL', '747,071.60', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
928(25, 'LD1314376164', 'SRINARMI', '6,567,438.87', '2A', 'KECIL KOMERSIAL NON WM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
929(26, 'LD1314378954', 'MISLAINA', '745,709.75', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
930(27, 'LD1314379908', 'HALIJAR', '16,417,745.50', '2B', 'CONSUMER MURABAHAH IRREGU', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
931(28, 'LD1314380436', 'HENDY HAMULIA', '2,696,780.32', '2A', 'CONSUMER KENDARAAN OTOMOT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
932(29, 'LD1314393286', 'SUKMA RIYANDHA', '6,022,254.33', '1', 'KECIL KOMERSIAL NON WM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
933(30, 'LD1314403882', 'HEFIAL MEIYARDI', '1,581,679.61', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
934(31, 'LD1314404018', 'EMMA HAYATI', '441,693.31', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
935(32, 'LD1314404634', 'DESSY ASFRI YENTIE', '947,047.04', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
936(33, 'LD1314404637', 'YULFAIZAL', '10,282.19', '1', 'KECIL KOMERSIAL NON WM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
937(34, 'LD1314414190', 'YENTI', '1,723,968.75', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
938(35, 'LD1314414192', 'YUSMAR', '662,009.07', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
939(36, 'LD1314416820', 'MIRIS', '4,241,021.27', '2B', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
940(37, 'LD1314417613', 'HASNIAL KHATIMA', '1,818,591.81', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
941(38, 'LD1314417621', 'MASNIZAR', '5,815,135.19', '2B', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
942(39, 'LD1314417627', 'JUNAIDI LUBIS', '458,974.85', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
943(40, 'LD1314418097', 'YETTI SAPUTRI', '1,231,522.30', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
944(41, 'LD1314420854', 'YUSLINA', '1,236,641.51', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
945(42, 'LD1314452011', 'YONNI ZUHARMEN', '7,551,199.43', '3C', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
946(43, 'LD1314454725', 'BURHANUDDIN PASARIBU', '19,470,685.04', '2C', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
947(44, 'LD1314457516', 'BURHANUDDIN PASARIBU', '36,135,122.82', '2C', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
948(45, 'LD1314462645', 'RAHMAT KARI HUSIN', '1,043,663.24', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
949(46, 'LD1314468133', 'ROSTIAN', '2,691,586.74', '2A', 'KECIL KOMERSIAL NON WM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
950(47, 'LD1314477765', 'DESNIARI', '2,718,251.78', '2A', 'WM UTAMA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
951(48, 'LD1314478340', 'YULNASRI', '762,085.22', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
952(49, 'LD1314478348', 'MAYONIS', '3,431,624.28', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
953(50, 'LD1314481277', 'IVO OKTAVER', '4,770,755.23', '2B', 'WM UTAMA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
954(51, 'LD1314483887', 'JUNAIDI', '594,542.76', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
955(52, 'LD1314484272', 'MADONG LUBIS', '41,087,629.02', '5', 'WM UTAMA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
956(53, 'LD1314485581', 'GUNAWAN', '384,522.41', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
957(54, 'LD1314486152', 'ASMA HALIM', '2,149,950.83', '2A', 'CONSUMER PENSIUNAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
958(55, 'LD1314486153', 'ZULDESMAN', '1,515,631.08', '2A', 'CONSUMER PENSIUNAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
959(56, 'LD1314487454', 'MUSPANDI', '422,811.60', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
960(57, 'LD1314489519', 'NURMIATI', '483,202.28', '2A', 'CONSUMER PKPA TNI POLRI C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
961(58, 'LD1314492527', 'YUNEDI', '1,593,490.39', '2A', 'CONSUMER IMPLAN SWASTA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
962(59, 'LD1314495099', 'BASRUN', '834,378.19', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
963(60, 'LD1314496962', 'ELSA HARSIDA', '502,983.06', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
964(61, 'LD1314497956', 'LAYLA NUZLIATI', '1,666,960.37', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
965(62, 'LD1315610959', 'RAFLIS', '1,810,022.12', '2A', 'CONSUMER PKPA SWASTA CHAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
966(63, 'LD1316270897', 'FAZLY UMAR PURBA', '3,838,725.82', '2A', 'KECIL KOMERSIAL NON WM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
967(64, 'LD1317608596', 'SYOFIA ELIDA', '805,135.35', '2A', 'Murabahah Warung Mikro', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
968(65, 'LD1319809181', 'DEKKY PRIBADI', '104,552,068.06', '4B', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
969(66, 'LD1320328039', 'SUHENDRI NOER', '762,024.81', '2A', 'Murabahah Warung Mikro', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
970(67, 'LD1322428579', 'SYAMSUL KHIAR', '2,952,259.33', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
971(68, 'LD1324231213', 'IVO OKTAVER', '1,665,885.07', '2A', 'WM TUNAS PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
972(69, 'LD1324245290', 'ITA YUNI', '2,161,984.91', '2A', 'WM UTAMA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
973(70, 'LD1326849478', 'DARMALINDA', '1,696,317.91', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
974(71, 'LD1327321159', 'ROMI MARLISKHA', '388,979.51', '1', 'WM TUNAS GOLBERTAP', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
975(72, 'LD1329455988', 'RAHMAT HIDAYAT', '1,412,673.63', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
976(73, 'LD1329461303', 'YONESHI WAHYUNI', '992,530.27', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
977(74, 'LD1329504597', 'NOVA DESMITA', '767,743.27', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
978(75, 'LD1331870486', 'DONI DESVIA', '647,443.63', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
979(76, 'LD1334653588', 'SUARDI', '403,606.95', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
980(77, 'LD1335370665', 'NOVI ISWANDI', '699,782.57', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
981(78, 'LD1335386361', 'ERWAN', '283,693.31', '2A', 'CONSUMER PERUMAHAN GRIYA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
982(79, 'LD1335396059', 'ASWIR EFENDI', '2,435,392.38', '2A', 'WM UTAMA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
983(80, 'LD1335837439', 'CHAIDIR LUBIS', '8,345,162.04', '2A', 'CONSUMER KENDARAAN OTOMOT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
984(81, 'LD1405255025', 'PONIMAN', '1,510,314.63', '2A', 'WM MADYA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
985(82, 'LD1405761266', 'EDI SISWANTO', '105,193.47', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
986(83, 'LD1405768957', 'TONY SETIA', '319,300.01', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
987(84, 'LD1408449091', 'NAIMI', '932,656.91', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
988(85, 'LD1410693370', 'ZULFAJRI PRIMA PUTRA', '647,752.01', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
989(86, 'LD1411293010', 'HUSTINA JUSTIA', '727,948.50', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
990(87, 'LD1411516160', 'WENDA EMAFRI', '384,522.41', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
991(88, 'LD1414179486', 'SITI HAIRIAH', '311,633.46', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
992(89, 'LD1414866048', 'HENDRA', '557,397.60', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
993(90, 'LD1416114040', 'EDDY CHANDRA', '460,689.15', '2A', 'KUR MIKRO JAMKRINDO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
994(91, 'LD1416830949', 'RADINAL', '423,061.60', '2A', 'WM TUNAS PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
995(92, 'LD1418573107', 'AHMAD ZUKRI', '339,828.28', '2A', 'WM TUNAS GOLBERTAP', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
996(93, 'LD1420473891', 'DODI', '3,623,752.42', '2A', 'WM UTAMA PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
997(94, 'LD1422659750', 'DODI YASMAI', '434,371.31', '1', 'WM TUNAS PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
998(95, 'LD1426693795', 'SRILISRIATI', '530,371.23', '1', 'WM TUNAS PRODUKTIF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
999