USE [AJK]
GO

INSERT INTO [dbo].[klaim]
           ([id_klaim]
           ,[tgl_pengajuan]
           ,[tgl_kejadian]
           ,[id_peserta]
           ,[id_diagnosa]
           ,[jml_uang_pertanggungan]
           ,[jml_bayar]
           ,[jml_tolakan]
           ,[jml_penyesuaian]
           ,[total_dibayar]
           ,[catatan]
           ,[status]
           ,[create_date]
           ,[create_by]
           ,[change_date]
           ,[change_by]
           ,[id_jenis_klaim]
           ,[id_status_klaim]
           ,[id_kelompok_kota]
           ,[keterangan]
           ,[jml_diajukan]
           ,[no_polis]
           ,[coverage_installment]
           ,[id_rejected_klaim_hci])
     VALUES
           (<id_klaim, varchar(12),>
           ,<tgl_pengajuan, datetime,>
           ,<tgl_kejadian, datetime,>
           ,<id_peserta, varchar(12),>
           ,'99'
           ,<jml_uang_pertanggungan, float,>
           ,<jml_bayar, float,>
           ,0
           ,0
           ,<total_dibayar, float,>
           ,<catatan, varchar(100),>
           ,'G'
           ,@p_curr_date
           ,<create_by, varchar(4),>
           ,@p_curr_date
           ,<change_by, varchar(4),>
           ,<id_jenis_klaim, varchar(1),>
           ,'01'	-- Draft
           ,'9'
           ,<keterangan, varchar(100),>
           ,<jml_diajukan, float,>
           ,<no_polis, varchar(13),>
           ,0
           ,'00')
GO


