USE [AJK]


UPDATE
	[dbo].[custport_m_claim_type]
SET
	[is_need_account] = 0
WHERE
	[claim_type_code] = 'tpd'

INSERT INTO [dbo].[custport_m_document]
           ([document_code]
           ,[description]
           ,[id_item_dokumen_core]
           ,[created_by]
           ,[created_date]
           ,[modified_by]
           ,[modified_date]
           ,[is_active])
     VALUES
           ('99'
           ,'Dokumen Lainnya'
           ,'9999'
           ,'SYS'
           ,GETDATE()
           ,'SYS'
           ,GETDATE()
           ,1)

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
           ('MM0028'
           ,'acc'
           ,'99'
           ,0
           ,'SYS'
           ,GETDATE()
           ,'SYS'
           ,GETDATE()
           ,1)
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
           ('MM0029'
           ,'death'
           ,'99'
           ,0
           ,'SYS'
           ,GETDATE()
           ,'SYS'
           ,GETDATE()
           ,1)
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
           ('MM0030'
           ,'hcp'
           ,'99'
           ,0
           ,'SYS'
           ,GETDATE()
           ,'SYS'
           ,GETDATE()
           ,1)
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
           ('MM0031'
           ,'tpd'
           ,'99'
           ,0
           ,'SYS'
           ,GETDATE()
           ,'SYS'
           ,GETDATE()
           ,1)