USE [AJK]
GO

INSERT INTO [dbo].[custport_m_document]
           ([document_code]
           ,[description]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('04'
           ,'Kartu Identitas seperti KTP/SIM/Paspor/Kitas (salinan berlegalisir)'
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_document]
           ([document_code]
           ,[description]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('05'
           ,'Surat Keterangan Meninggal dari Rumah Sakit (asli/salinan berlegalisir)'
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_document]
           ([document_code]
           ,[description]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('06'
           ,'Resume medis dari Rumah Sakit'
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_document]
           ([document_code]
           ,[description]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('07'
           ,'Surat Keterangan Kepolisian (jika meninggal karena kecelakaan)'
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_document]
           ([document_code]
           ,[description]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('08'
           ,'Surat Keterangan Kremasi (jika diperlukan)'
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_document]
           ([document_code]
           ,[description]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('09'
           ,'Semua dokumen yang tidak dikeluarkan di Indonesia wajib dilegalisir oleh Kedutaan Besar Republik Indonesia (jika dibutuhkan, untuk kasus tertentu)'
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_document]
           ([document_code]
           ,[description]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('10'
           ,'Surat keterangan keluar dari Rumah Sakit'
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_document]
           ([document_code]
           ,[description]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('11'
           ,'Kuitansi pembayaran selama perawatan di Rumah Sakit (Asli)'
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_document]
           ([document_code]
           ,[description]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('12'
           ,'Hasil pemeriksaan diagnostic, rincian obat-obatan, dan biaya (salinan berlegalisir)'
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_document]
           ([document_code]
           ,[description]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('13'
           ,'Surat Nikah / Kartu Keluarga (untuk klaim atas nama pasangan)'
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_document]
           ([document_code]
           ,[description]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('14'
           ,'Surat Keterangan dokter atas cacat fisik / tidak berfungsinya organ tubuh ditandatangai oleh dokter (salinan berlegalisir)'
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_document]
           ([document_code]
           ,[description]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('15'
           ,'Foto rontgen lokasi cacat dan foto jelas (close up) beserta foto seluruh tubuh'
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO



DELETE FROM [dbo].[custport_m_claim_document] WHERE [claim_type_code] IN ('death','hcp','tpd')
GO

INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0013'
           ,'death'
           ,'04'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0014'
           ,'death'
           ,'05'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0015'
           ,'death'
           ,'06'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0016'
           ,'death'
           ,'07'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0017'
           ,'death'
           ,'08'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0018'
           ,'death'
           ,'09'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0019'
           ,'hcp'
           ,'04'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0020'
           ,'hcp'
           ,'10'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0021'
           ,'hcp'
           ,'11'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0022'
           ,'hcp'
           ,'12'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0023'
           ,'hcp'
           ,'13'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0024'
           ,'tpd'
           ,'04'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0025'
           ,'tpd'
           ,'14'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0026'
           ,'tpd'
           ,'15'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO
INSERT INTO [dbo].[custport_m_claim_document]
           ([claim_document_code]
           ,[claim_type_code]
           ,[document_code]
           ,[is_mandatory]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('M0027'
           ,'tpd'
           ,'13'
           ,0
           ,'SYS'
           ,'2018-08-30'
           ,'SYS'
           ,'2018-08-30'
           ,1)
GO




