insert

INSERT INTO "simpati_mst_jabatan_pegawai" ("jabatan_absensi", "jabatan_monitoring", "jabatan_order", "jabatan_sts", "create_by", "create_date", "update_by", "update_date") VALUES
    ('INSPEKTUR', NULL, 1, 1, NULL, NULL, NULL, NULL),
    ('AUDITOR', NULL, 2, 1, NULL, NULL, NULL, NULL),
    ('KASUBAG TU', NULL, 3, 1, NULL, NULL, NULL, NULL),
    ('STAFF', NULL, 5, 1, NULL, NULL, NULL, NULL),
    ('PPK', NULL, 4, 1, NULL, NULL, NULL, NULL);



INSERT INTO "daftar_pegawai" ("daftar_pegawai_nip", "daftar_pegawai_jabatan_id", "daftar_pegawai_sts", "create_by", "create_date", "update_by", "update_date") VALUES
    ('195708251986031001', 1, 1, NULL, NULL, NULL, NULL),
    ('196209121989032001', 1, 1, NULL, NULL, NULL, NULL),
    ('197010301992031001', 2, 1, NULL, NULL, NULL, NULL),
    ('198105092006051001', 2, 1, NULL, NULL, NULL, NULL),
    ('198010182006051001', 2, 1, NULL, NULL, NULL, NULL),
    ('196805181992031001', 2, 1, NULL, NULL, NULL, NULL),
    ('196205051988031001', 2, 1, NULL, NULL, NULL, NULL),
    ('196212311984031001', 2, 1, NULL, NULL, NULL, NULL),
    ('198401212009122003', 2, 1, NULL, NULL, NULL, NULL),
    ('196206111986031002', 2, 1, NULL, NULL, NULL, NULL),
    ('196405151984031001', 2, 1, NULL, NULL, NULL, NULL),
    ('198102202011011005', 2, 1, NULL, NULL, NULL, NULL),
    ('198009192009022002', 2, 1, NULL, NULL, NULL, NULL),
    ('196408241986031001', 2, 1, NULL, NULL, NULL, NULL),
    ('195812301984031001', 2, 1, NULL, NULL, NULL, NULL),
    ('196103061986031001', 2, 1, NULL, NULL, NULL, NULL),
    ('198706222009122004', 2, 1, NULL, NULL, NULL, NULL),
    ('196607122000031001', 2, 1, NULL, NULL, NULL, NULL),
    ('196103201984031001', 2, 1, NULL, NULL, NULL, NULL),
    ('196512131994032001', 2, 1, NULL, NULL, NULL, NULL);



INSERT INTO "simpati_mst_menu" ("menu_id", "menu_desc", "menu_parent_id", "menu_urut", "menu_sts", "menu_icon", "create_by", "create_date", "update_by", "update_date", "menu_controller") VALUES (182, 'Monitoring Absensi', 94, 'R9', 1, 'list-alt', NULL, NULL, NULL, NULL, 'monitoring_absensi');



INSERT INTO "simpati_mst_sequence_code" ("sequence_table", "sequence_number", "sequence_prefix", "max_prefix", "create_by", "create_date", "update_by", "update_date", "is_month", "is_year", "is_active", "sequence_code_id", "current_month") VALUES ('absensi_head', 1, 'ABS', 6, NULL, NULL, '12345678B', '2018-06-06 02:22:18', 'true', 'true', 'true', 49, NULL);
INSERT INTO "simpati_mst_sequence_code" ("sequence_table", "sequence_number", "sequence_prefix", "max_prefix", "create_by", "create_date", "update_by", "update_date", "is_month", "is_year", "is_active", "sequence_code_id", "current_month") VALUES ('absensi_pic', 19, 'ABSPIC', 6, NULL, NULL, '12345678B', '2018-06-06 02:22:19', 'true', 'true', 'true', 50, NULL);