INSERT INTO leave_type (             type_id,            code,             description,             quota,             quota_period,             period_start_date,             period_end_date,             requisite_func,             submit_func,             compensated,             direct_compensated,             start_date,             end_date,             setting_approval_id,             color_code,             document_required,             optional_only,             optional_type_id,             created_dtm,             include_holiday         ) values (             '101',             'ALP',             'Absent',             '0',             'M',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             'ff8080',             'N',             'N',             NULL,             '2020-11-20 14:31:35.371277',             'N'         ),(             '100',             'KMH',             'Kemah (Kerja di rumah)',             '0',             'Y',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             'ffff80',             'N',             'N',             NULL,             '2020-11-20 14:31:35.371277',             'N'         ),(             '99',             'OFF',             'Libur (Off)',             '0',             'M',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             'ff8080',             'N',             'N',             NULL,             '2020-11-20 14:31:35.371277',             'N'         ),(             '21',             'CHSHIFT',             'Change Shift',             '0',             'Y',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '#999ae6',             'N',             'N',             NULL,             '2020-11-20 14:31:35.371277',             'N'         ),(             '20',             'TLV',             'Take A Leave ( Kematian suami/ isteri, orang tua/ mertua atau anak/ menantu )',             '3',             'Y',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '#db99e6',             'N',             'N',             NULL,             '2020-11-20 14:31:35.371277',             'N'         ),(             '19',             'CTIM',             'Cuti Istri Melahirkan',             '3',             'Y',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '8080ff',             'N',             'N',             NULL,             '2020-11-20 14:31:35.371277',             'N'         ),(             '18',             'CTL',             'Cuti Melahirkan',             '90',             'Y',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '8080ff',             'N',             'N',             NULL,             '2020-11-20 14:31:35.371277',             'N'         ),(             '17',             'CTMR',             'Cuti Kawin',             '5',             'Y',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '8080ff',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         ),(             '13',             'NOIF',             'No Information',             '0',             'M',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             'ffd480',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         ),(             '12',             'CTMNS',             'Cuti Haid',             '24',             'Y',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '#e69999',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         ),(             '11',             'IJP',             'Ijin Sementara',             '0',             'M',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '8080ff',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         ),(             '10',             'OVH',             'Lembur Hari Libur',             '0',             'M',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             'ff9999',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         ),(             '9',             'PERMIT',             'Permittance (not important)',             '0',             'M',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '#999ae6',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         ),(             '8',             'SKT',             'Sakit',             '0',             'M',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '8080ff',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         ),(             '7',             'OVD',             'Lembur Hari Kerja',             '0',             'M',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             'ff80aa',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         ),(             '6',             'SPJT',             'SPJ transport',             '0',             'M',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '#4b0082',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         ),(             '5',             'SPJOUT',             'SPJ Luar Kota',             '0',             'M',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '8080ff',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         ),(             '4',             'SPJIN',             'SPJ Dalam Kota',             '0',             'M',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '8080ff',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         ),(             '3',             'CUTI',             'Cuti',             '12',             'Y',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             'e6ff99',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         ),(             '2',             'IZN',             'Izin',             '0',             'M',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '8080ff',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         ),(             '1',             'ATTD',             'Masuk',             '0',             'M',             '0101',             NULL,             NULL,             NULL,             'N',             'N',             '2020-01-01',             NULL,             '1',             '99e699',             'N',             'N',             NULL,             '2020-11-20 14:31:35.370271',             'N'         )