/* Navicat Premium Data Transfer Source Server : anjabbawah Source Server Type : PostgreSQL Source Server Version : 150003 (150003) Source Host : localhost:5432 Source Catalog : sppai Source Schema : public Target Server Type : PostgreSQL Target Server Version : 150003 (150003) File Encoding : 65001 Date: 02/05/2026 20:00:35 */ -- ---------------------------- -- Sequence structure for abc_activities_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."abc_activities_id_seq"; CREATE SEQUENCE "public"."abc_activities_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for abc_activity_allocations_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."abc_activity_allocations_id_seq"; CREATE SEQUENCE "public"."abc_activity_allocations_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for abc_cost_categories_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."abc_cost_categories_id_seq"; CREATE SEQUENCE "public"."abc_cost_categories_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for abc_cost_types_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."abc_cost_types_id_seq"; CREATE SEQUENCE "public"."abc_cost_types_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for abc_drivers_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."abc_drivers_id_seq"; CREATE SEQUENCE "public"."abc_drivers_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for abc_resource_assignments_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."abc_resource_assignments_id_seq"; CREATE SEQUENCE "public"."abc_resource_assignments_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for activity_components_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."activity_components_id_seq"; CREATE SEQUENCE "public"."activity_components_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for akademik_jadwal_kuliah_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."akademik_jadwal_kuliah_id_seq"; CREATE SEQUENCE "public"."akademik_jadwal_kuliah_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for akademik_matakuliah_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."akademik_matakuliah_id_seq"; CREATE SEQUENCE "public"."akademik_matakuliah_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for indirect_budgets_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."indirect_budgets_id_seq"; CREATE SEQUENCE "public"."indirect_budgets_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for migrations_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."migrations_id_seq"; CREATE SEQUENCE "public"."migrations_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ms_academic_years_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ms_academic_years_id_seq"; CREATE SEQUENCE "public"."ms_academic_years_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ms_departments_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ms_departments_id_seq"; CREATE SEQUENCE "public"."ms_departments_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ms_faculties_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ms_faculties_id_seq"; CREATE SEQUENCE "public"."ms_faculties_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ms_honor_rates_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ms_honor_rates_id_seq"; CREATE SEQUENCE "public"."ms_honor_rates_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ms_labor_config_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ms_labor_config_id_seq"; CREATE SEQUENCE "public"."ms_labor_config_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ms_labor_rates_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ms_labor_rates_id_seq"; CREATE SEQUENCE "public"."ms_labor_rates_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ms_menus_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ms_menus_id_seq"; CREATE SEQUENCE "public"."ms_menus_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ms_prodi_revenue_config_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ms_prodi_revenue_config_id_seq"; CREATE SEQUENCE "public"."ms_prodi_revenue_config_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ms_ssbopt_config_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ms_ssbopt_config_id_seq"; CREATE SEQUENCE "public"."ms_ssbopt_config_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ms_study_programs_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ms_study_programs_id_seq"; CREATE SEQUENCE "public"."ms_study_programs_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ms_unit_config_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ms_unit_config_id_seq"; CREATE SEQUENCE "public"."ms_unit_config_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ms_user_levels_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ms_user_levels_id_seq"; CREATE SEQUENCE "public"."ms_user_levels_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ref_ssbopt_clusters_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ref_ssbopt_clusters_id_seq"; CREATE SEQUENCE "public"."ref_ssbopt_clusters_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for ref_ssbopt_components_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."ref_ssbopt_components_id_seq"; CREATE SEQUENCE "public"."ref_ssbopt_components_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for report_unit_costs_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."report_unit_costs_id_seq"; CREATE SEQUENCE "public"."report_unit_costs_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for rpt_unit_costs_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."rpt_unit_costs_id_seq"; CREATE SEQUENCE "public"."rpt_unit_costs_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for service_groups_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."service_groups_id_seq"; CREATE SEQUENCE "public"."service_groups_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for trans_driver_values_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."trans_driver_values_id_seq"; CREATE SEQUENCE "public"."trans_driver_values_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for trans_resources_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."trans_resources_id_seq"; CREATE SEQUENCE "public"."trans_resources_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for users_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."users_id_seq"; CREATE SEQUENCE "public"."users_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1; -- ---------------------------- -- Table structure for abc_activities -- ---------------------------- DROP TABLE IF EXISTS "public"."abc_activities"; CREATE TABLE "public"."abc_activities" ( "id" int4 NOT NULL DEFAULT nextval('abc_activities_id_seq'::regclass), "activity_name" varchar(150) COLLATE "pg_catalog"."default" NOT NULL, "description" text COLLATE "pg_catalog"."default", "level_scope" varchar(20) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'PRODI'::character varying, "created_at" timestamp(6), "updated_at" timestamp(6), "activity_code" varchar(150) COLLATE "pg_catalog"."default", "ssbopt_component_id" int4 ) ; -- ---------------------------- -- Records of abc_activities -- ---------------------------- INSERT INTO "public"."abc_activities" VALUES (1, 'Perkuliahan Teori', NULL, 'PRODI', NULL, NULL, 'AKT-01', NULL); INSERT INTO "public"."abc_activities" VALUES (2, 'Praktikum Lab', NULL, 'PRODI', NULL, NULL, 'AKT-02', NULL); INSERT INTO "public"."abc_activities" VALUES (3, 'Administrasi Umum', NULL, 'FACULTY', NULL, NULL, 'AKT-03', NULL); -- ---------------------------- -- Table structure for abc_activity_allocations -- ---------------------------- DROP TABLE IF EXISTS "public"."abc_activity_allocations"; CREATE TABLE "public"."abc_activity_allocations" ( "id" int8 NOT NULL DEFAULT nextval('abc_activity_allocations_id_seq'::regclass), "year_id" int4 NOT NULL, "activity_id" int4 NOT NULL, "driver_id" int4 NOT NULL, "study_program_id" int4 NOT NULL, "driver_value" numeric(10,2) NOT NULL DEFAULT 0, "cost_amount" numeric(15,2) NOT NULL DEFAULT 0, "created_at" timestamp(6), "updated_at" timestamp(6) ) ; -- ---------------------------- -- Records of abc_activity_allocations -- ---------------------------- -- ---------------------------- -- Table structure for abc_cost_categories -- ---------------------------- DROP TABLE IF EXISTS "public"."abc_cost_categories"; CREATE TABLE "public"."abc_cost_categories" ( "id" int8 NOT NULL DEFAULT nextval('abc_cost_categories_id_seq'::regclass), "category_code" varchar(20) COLLATE "pg_catalog"."default", "category_name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "description" text COLLATE "pg_catalog"."default", "created_at" timestamp(6), "updated_at" timestamp(6), "deleted_at" timestamp(6), "cost_type_id" int8, "allowed_level_ids" varchar(255) COLLATE "pg_catalog"."default", "scope_level" varchar(50) COLLATE "pg_catalog"."default" DEFAULT 'ALL'::character varying, "report_group" varchar(50) COLLATE "pg_catalog"."default", "parent_id" int8 ) ; -- ---------------------------- -- Records of abc_cost_categories -- ---------------------------- INSERT INTO "public"."abc_cost_categories" VALUES (6, 'HR-005', 'Honor Guru Besar/Pakar Tamu', 'Dosen tamu atau expert.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, NULL, NULL, 'ALL', NULL, 1); INSERT INTO "public"."abc_cost_categories" VALUES (8, 'BHP-001', 'BHP Praktikum & Laboratorium', 'Zat kimia, spesimen, bahan praktek bengkel.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, NULL, NULL, 'ALL', NULL, 7); INSERT INTO "public"."abc_cost_categories" VALUES (9, 'BHP-002', 'ATK Pembelajaran & Kelas', 'Spidol, kertas ujian, tinta kelas.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, NULL, NULL, 'ALL', NULL, 7); INSERT INTO "public"."abc_cost_categories" VALUES (4, 'HR-003', 'Honorarium Kelebihan Jam Mengajar', 'Bayaran untuk SKS berlebih.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 1, NULL, 'PRODI', NULL, 1); INSERT INTO "public"."abc_cost_categories" VALUES (5, 'HR-004', 'Honor Pembimbingan & Pengujian', 'Skripsi, Tesis, Disertasi, PKL.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 1, NULL, 'PRODI', NULL, 1); INSERT INTO "public"."abc_cost_categories" VALUES (20, 'TRP-001', 'Perjalanan Dinas Akademik', 'Seminar, Konferensi Dosen.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 1, NULL, 'PRODI', NULL, 19); INSERT INTO "public"."abc_cost_categories" VALUES (25, 'MNT-002', 'Pemeliharaan Alat Lab & Pembelajaran', 'Service mikroskop, mesin, komputer lab.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, NULL, NULL, 'ALL', NULL, 23); INSERT INTO "public"."abc_cost_categories" VALUES (32, 'SUP-004', 'Pengembangan Kurikulum & Workshop', 'Review kurikulum, FGD.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, NULL, NULL, 'ALL', NULL, 28); INSERT INTO "public"."abc_cost_categories" VALUES (14, 'UTL-001', 'Listrik (PLN)', 'Tagihan listrik gedung.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 13); INSERT INTO "public"."abc_cost_categories" VALUES (16, 'UTL-003', 'Internet & Bandwidth', 'Langganan internet pusat/fakultas.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 13); INSERT INTO "public"."abc_cost_categories" VALUES (1, 'GRP-01', 'Belanja Personil (Gaji & Honor)', 'Gaji pokok, tunjangan, dan honorarium dosen serta tendik.', NULL, NULL, NULL, NULL, NULL, 'GROUP', NULL, NULL); INSERT INTO "public"."abc_cost_categories" VALUES (7, 'GRP-02', 'Bahan Habis Pakai (BHP) & ATK', 'Bahan operasional pengajaran dan kantor.', NULL, NULL, NULL, NULL, NULL, 'GROUP', NULL, NULL); INSERT INTO "public"."abc_cost_categories" VALUES (13, 'GRP-03', 'Jasa, Utilitas & Langganan', 'Listrik, Air, Internet, dan Jasa Pihak Ketiga.', NULL, NULL, NULL, NULL, NULL, 'GROUP', NULL, NULL); INSERT INTO "public"."abc_cost_categories" VALUES (19, 'GRP-04', 'Perjalanan Dinas', 'Transportasi dan akomodasi kegiatan dinas.', NULL, NULL, NULL, NULL, NULL, 'GROUP', NULL, NULL); INSERT INTO "public"."abc_cost_categories" VALUES (23, 'GRP-05', 'Pemeliharaan & Aset', 'Service dan perbaikan aset.', NULL, NULL, NULL, NULL, NULL, 'GROUP', NULL, NULL); INSERT INTO "public"."abc_cost_categories" VALUES (28, 'GRP-06', 'Riset, Mutu & Kemahasiswaan', 'Biaya pendukung Tridharma dan kemahasiswaan (DRPM/Direktorat).', NULL, NULL, NULL, NULL, NULL, 'GROUP', NULL, NULL); INSERT INTO "public"."abc_cost_categories" VALUES (31, 'SUP-003', 'Akreditasi & Penjaminan Mutu', 'Biaya visitasi asesor LAM/BAN-PT.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 1, NULL, 'PRODI', NULL, 28); INSERT INTO "public"."abc_cost_categories" VALUES (33, 'HON-001', 'Biaya Pengajaran & Honorarium', NULL, NULL, NULL, NULL, 1, NULL, 'PRODI', NULL, 1); INSERT INTO "public"."abc_cost_categories" VALUES (22, 'TRP-003', 'Transport Lokal', 'Transport dalam kota.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'FACULTY', NULL, 19); INSERT INTO "public"."abc_cost_categories" VALUES (10, 'BHP-003', 'ATK Perkantoran', 'Kertas surat, map, toner printer kantor.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'FACULTY', NULL, 7); INSERT INTO "public"."abc_cost_categories" VALUES (12, 'BHP-005', 'Konsumsi Rapat & Tamu', 'Snack dan makan rapat dinas.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'FACULTY', NULL, 7); INSERT INTO "public"."abc_cost_categories" VALUES (11, 'BHP-004', 'Bahan Kebersihan & Rumah Tangga', 'Sabun, tisu, perlengkapan pantry.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 7); INSERT INTO "public"."abc_cost_categories" VALUES (18, 'UTL-005', 'Langganan Jurnal & E-Library', 'Akses jurnal internasional.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 13); INSERT INTO "public"."abc_cost_categories" VALUES (21, 'TRP-002', 'Perjalanan Dinas Manajemen', 'Rapat pimpinan, koordinasi pusat.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 19); INSERT INTO "public"."abc_cost_categories" VALUES (24, 'MNT-001', 'Pemeliharaan Gedung & Bangunan', 'Renovasi ringan, cat, atap.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 23); INSERT INTO "public"."abc_cost_categories" VALUES (26, 'MNT-003', 'Pemeliharaan Kendaraan Dinas', 'Service mobil/motor operasional.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 23); INSERT INTO "public"."abc_cost_categories" VALUES (27, 'MNT-004', 'Pemeliharaan Software & Server', 'Lisensi Cpanel, Zoom, Google Workspace.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 23); INSERT INTO "public"."abc_cost_categories" VALUES (29, 'SUP-001', 'Hibah Penelitian & Pengabdian (DRPM)', 'Dana riset internal dosen.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 28); INSERT INTO "public"."abc_cost_categories" VALUES (30, 'SUP-002', 'Kegiatan Ormawa & Lomba', 'Pendanaan BEM/DPM/UKM.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 28); INSERT INTO "public"."abc_cost_categories" VALUES (17, 'UTL-004', 'Keamanan & Kebersihan (Outsourcing)', 'Kontrak pihak ketiga satpam/CS.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 13); INSERT INTO "public"."abc_cost_categories" VALUES (36, 'SUP-005', 'Layanan Wisuda, Ijazah & Alumni', 'Biaya penyelenggaraan wisuda, pencetakan ijazah/transkrip, dan pelacakan alumni (Tracer Study).', NULL, NULL, NULL, NULL, NULL, 'ALL', NULL, 28); INSERT INTO "public"."abc_cost_categories" VALUES (2, 'HR-001', 'Gaji & Tunjangan Dosen (PNS/Tetap)', 'Gaji melekat pada dosen.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 1); INSERT INTO "public"."abc_cost_categories" VALUES (3, 'HR-002', 'Gaji & Tunjangan Tendik (Admin)', 'Gaji staf administrasi fakultas/pusat.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 1); INSERT INTO "public"."abc_cost_categories" VALUES (15, 'UTL-002', 'Air & PDAM', 'Tagihan air.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 13); INSERT INTO "public"."abc_cost_categories" VALUES (37, 'AST-001', 'Beban Penyusutan Gedung & Bangunan', 'Alokasi nilai ekonomis tahunan dari aset fisik (Gedung, Ruang Kelas). Bukan pengeluaran uang tunai.', NULL, NULL, NULL, 2, NULL, 'UNIVERSITY', NULL, 23); INSERT INTO "public"."abc_cost_categories" VALUES (38, 'AST-002', 'Beban Penyusutan Peralatan, Mesin & Lab', 'Alokasi nilai ekonomis tahunan dari Alat Berat Laboratorium, Mesin Praktikum, dan Perangkat IT/Server.', NULL, NULL, NULL, NULL, NULL, 'ALL', NULL, 23); -- ---------------------------- -- Table structure for abc_cost_types -- ---------------------------- DROP TABLE IF EXISTS "public"."abc_cost_types"; CREATE TABLE "public"."abc_cost_types" ( "id" int8 NOT NULL DEFAULT nextval('abc_cost_types_id_seq'::regclass), "type_code" varchar(10) COLLATE "pg_catalog"."default" NOT NULL, "type_name" varchar(100) COLLATE "pg_catalog"."default" NOT NULL, "description" text COLLATE "pg_catalog"."default" ) ; -- ---------------------------- -- Records of abc_cost_types -- ---------------------------- INSERT INTO "public"."abc_cost_types" VALUES (1, 'BL', 'Biaya Langsung (Direct Cost)', 'Biaya yang dapat dibebankan langsung ke objek biaya (Prodi/Mhs).'); INSERT INTO "public"."abc_cost_types" VALUES (2, 'BTL', 'Biaya Tidak Langsung (Indirect Cost)', 'Biaya bersama yang memerlukan alokasi bertahap.'); -- ---------------------------- -- Table structure for abc_drivers -- ---------------------------- DROP TABLE IF EXISTS "public"."abc_drivers"; CREATE TABLE "public"."abc_drivers" ( "id" int4 NOT NULL DEFAULT nextval('abc_drivers_id_seq'::regclass), "driver_name" varchar(150) COLLATE "pg_catalog"."default" NOT NULL, "unit" varchar(50) COLLATE "pg_catalog"."default" NOT NULL, "driver_type" varchar(20) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'ACTIVITY_DRIVER'::character varying, "description" text COLLATE "pg_catalog"."default", "created_at" timestamp(6), "updated_at" timestamp(6), "driver_level" varchar(20) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'PRODI'::character varying ) ; -- ---------------------------- -- Records of abc_drivers -- ---------------------------- INSERT INTO "public"."abc_drivers" VALUES (8, 'Jumlah SKS Ditawarkan', 'SKS', 'ACTIVITY_DRIVER', 'Digunakan sebagai basis perhitungan biaya honor mengajar dosen, penyusunan silabus, dan pembuatan modul pembelajaran.', '2026-03-27 02:46:21', '2026-03-27 02:58:15', 'PRODI'); INSERT INTO "public"."abc_drivers" VALUES (9, 'Jumlah Kelas / Rombongan Belajar', 'Kelas', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi biaya penjadwalan akademik, penggunaan ATK kelas, dan bahan habis pakai (BHP) pengajaran tingkat fakultas.', '2026-03-27 02:47:17', NULL, 'PRODI'); INSERT INTO "public"."abc_drivers" VALUES (10, 'Jam Penggunaan Lab', 'Jam', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi presisi pada tagihan utilitas dan depresiasi aset laboratorium/studio praktikum.', '2026-03-27 02:50:18', '2026-03-27 02:58:48', 'DEPARTEMEN'); INSERT INTO "public"."abc_drivers" VALUES (2, 'Jumlah Mahasiswa Aktif', 'Orang', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi biaya layanan kemahasiswaan dan administrasi akademik.', NULL, NULL, 'PRODI'); INSERT INTO "public"."abc_drivers" VALUES (11, 'Total Nominal Pendanaan Tri Dharma', 'Rupiah', 'ACTIVITY_DRIVER', 'Digunakan untuk mengalokasikan beban operasional LPPM/Direktorat Riset ke Prodi secara proporsional berdasarkan besaran dana yang dikelola.', '2026-03-27 02:51:29', '2026-03-27 02:59:13', 'PRODI'); INSERT INTO "public"."abc_drivers" VALUES (12, 'Jumlah Tenaga Kependidikan / Tendik', 'orang', 'ACTIVITY_DRIVER', 'Digunakan untuk membebankan biaya HRD staf pendukung (seragam, BPJS, pelatihan tendik) di tiap entitas.', '2026-03-27 02:52:18', NULL, 'FAKULTAS'); INSERT INTO "public"."abc_drivers" VALUES (3, 'Jumlah Dosen Homebase Prodi', 'Orang', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi biaya pengembangan SDM dan administrasi kepegawaian.', NULL, '2026-03-27 02:38:31', 'PRODI'); INSERT INTO "public"."abc_drivers" VALUES (13, 'Total Mahasiswa Aktif Institusi', 'Orang', 'RESOURCE_DRIVER', 'Digunakan sebagai basis alokasi tingkat makro untuk menyerap biaya layanan akademik, kemahasiswaan, dan keuangan dari universitas ke fakultas.', NULL, NULL, 'UNIVERSITAS'); INSERT INTO "public"."abc_drivers" VALUES (14, 'Total Nominal Pendanaan Institusi', 'Rupiah', 'RESOURCE_DRIVER', 'Basis alokasi tingkat makro untuk menyerap biaya overhead penelitian dan pengabdian dari universitas ke fakultas.', NULL, NULL, 'UNIVERSITAS'); INSERT INTO "public"."abc_drivers" VALUES (15, 'Total Anggaran/Belanja Dikelola', 'Rupiah', 'ACTIVITY_DRIVER', 'Pemicu paling akurat untuk mengalokasikan biaya overhead manajerial, audit, dan administrasi keuangan dari Universitas/Fakultas ke Prodi.', NULL, NULL, 'PRODI'); INSERT INTO "public"."abc_drivers" VALUES (16, 'Total Anggaran Fakultas', 'Rupiah', 'RESOURCE_DRIVER', 'Digunakan untuk menarik biaya operasional Rektorat ke masing-masing Fakultas berdasarkan bobot anggaran/belanja fakultas tersebut.', NULL, NULL, 'UNIVERSITAS'); INSERT INTO "public"."abc_drivers" VALUES (17, 'Total SKS Ditempuh (KRS)', 'SKS', 'ACTIVITY_DRIVER', 'Jumlah kumulatif SKS yang diambil oleh seluruh mahasiswa di prodi. Sangat akurat untuk membagi biaya variabel pengajaran (BHP, Server Kuliah Online, Kertas Ujian).', NULL, NULL, 'PRODI'); INSERT INTO "public"."abc_drivers" VALUES (1, 'Luas Fasilitas Aktual & Proporsional', 'm2', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi biaya kebersihan, listrik, dan pemeliharaan. Harus mencakup luas ruangan spesifik prodi ditambah persentase luas ruang bersama (selasar, lobi).', NULL, '2026-03-27 02:36:42', 'PRODI'); INSERT INTO "public"."abc_drivers" VALUES (4, 'Jumlah Komputer Lab', 'Unit', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi biaya maintenance IT, langganan internet prodi, dan lisensi software komputer.', NULL, NULL, 'DEPARTEMEN'); INSERT INTO "public"."abc_drivers" VALUES (5, 'Luas Gedung Institusi', 'm2', 'RESOURCE_DRIVER', 'Luas total ruang kelas, lab, dan kantor prodi. Digunakan untuk alokasi biaya kebersihan dan listrik, Ini dipakai saat mendistribusikan total tagihan listrik kampus ke masing-masing kelompok aktivitas', NULL, '2026-03-27 02:37:16', 'UNIVERSITAS'); INSERT INTO "public"."abc_drivers" VALUES (6, 'Total Dosen Tetap Institusi', 'Orang', 'RESOURCE_DRIVER', 'Digunakan sebagai basis alokasi awal untuk biaya pengembangan SDM dan administrasi kepegawaian tingkat institusi.', NULL, '2026-03-27 02:38:53', 'UNIVERSITAS'); INSERT INTO "public"."abc_drivers" VALUES (7, 'Jumlah Lulusan', 'Orang', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi biaya wisuda dan pencetakan ijazah.', NULL, NULL, 'PRODI'); -- ---------------------------- -- Table structure for abc_resource_assignments -- ---------------------------- DROP TABLE IF EXISTS "public"."abc_resource_assignments"; CREATE TABLE "public"."abc_resource_assignments" ( "id" int8 NOT NULL DEFAULT nextval('abc_resource_assignments_id_seq'::regclass), "resource_id" int8 NOT NULL, "activity_id" int4 NOT NULL, "driver_id" int4, "percentage" numeric(5,2) NOT NULL DEFAULT 0, "allocated_amount" numeric(15,2) NOT NULL DEFAULT 0, "created_at" timestamp(6), "updated_at" timestamp(6) ) ; -- ---------------------------- -- Records of abc_resource_assignments -- ---------------------------- -- ---------------------------- -- Table structure for activity_components -- ---------------------------- DROP TABLE IF EXISTS "public"."activity_components"; CREATE TABLE "public"."activity_components" ( "id" int8 NOT NULL DEFAULT nextval('activity_components_id_seq'::regclass), "service_group_id" int8 NOT NULL, "nama_modul" varchar(255) COLLATE "pg_catalog"."default", "nama_aktivitas" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "kode_klasifikasi" varchar(50) COLLATE "pg_catalog"."default", "kode_kategori" varchar(50) COLLATE "pg_catalog"."default", "created_at" timestamp(6), "updated_at" timestamp(6) ) ; -- ---------------------------- -- Records of activity_components -- ---------------------------- -- ---------------------------- -- Table structure for akademik_jadwal_kuliah -- ---------------------------- DROP TABLE IF EXISTS "public"."akademik_jadwal_kuliah"; CREATE TABLE "public"."akademik_jadwal_kuliah" ( "id" int8 NOT NULL DEFAULT nextval('akademik_jadwal_kuliah_id_seq'::regclass), "year_id" int8 NOT NULL, "mk_id" int8 NOT NULL, "nama_kelas" varchar(50) COLLATE "pg_catalog"."default" NOT NULL, "program_kelas" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'REGULER'::character varying, "dosen_id" int8, "nama_dosen" varchar(255) COLLATE "pg_catalog"."default", "jabatan_fungsional_snapshot" varchar(50) COLLATE "pg_catalog"."default", "jumlah_mahasiswa" int4 NOT NULL DEFAULT 0, "jumlah_tatap_muka_realisasi" int4 NOT NULL DEFAULT 0, "total_honorarium" numeric(15,2) NOT NULL DEFAULT 0, "created_at" timestamp(6), "updated_at" timestamp(6) ) ; -- ---------------------------- -- Records of akademik_jadwal_kuliah -- ---------------------------- INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (38, 1, 71, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor', 30, 16, 5120000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (41, 1, 74, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Guru Besar', 30, 16, 6320000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (43, 1, 76, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor Kepala', 30, 16, 3200000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (52, 1, 85, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor', 30, 16, 6720000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (55, 1, 88, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor Kepala', 30, 16, 8320000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (48, 1, 81, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 4800000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (49, 1, 82, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 4800000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (54, 1, 87, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 9920000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (57, 1, 90, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 10240000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (56, 1, 89, 'B2', 'REGULER', NULL, 'Dr. Tri Ani Hastuti S.Pd., M.Pd.', 'Lektor Kepala', 30, 16, 346500000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (53, 1, 86, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor Kepala', 30, 16, 12960000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (51, 1, 84, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor', 30, 16, 4800000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (32, 1, 65, 'A', 'REGULER', NULL, 'Prof. Dr. Drs. Subagyo M.Pd.', 'Guru Besar', 30, 16, 4000000.00, '2025-12-27 06:10:37', '2026-01-20 12:16:26'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (40, 1, 73, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor', 30, 16, 6640000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (47, 1, 80, 'A', 'REGULER', NULL, 'Prof. Dr. Hari Yuliarto S.Pd., M.Kes.', 'Guru Besar', 30, 16, 138525000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (42, 1, 75, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor Kepala', 30, 16, 8640000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (44, 1, 77, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor', 30, 16, 2400000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (37, 1, 70, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Guru Besar', 30, 16, 8320000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (46, 1, 79, 'A', 'REGULER', NULL, 'Prof. Dr. Hari Yuliarto S.Pd., M.Kes.', 'Guru Besar', 30, 16, 8640000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (34, 1, 67, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Guru Besar', 30, 16, 8320000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (35, 1, 68, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor Kepala', 30, 16, 3200000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (45, 1, 78, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor', 30, 16, 3920000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (39, 1, 72, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor Kepala', 30, 16, 3200000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5091, 1, 129, 'KELAS B', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5092, 1, 129, 'KELAS C', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5093, 1, 129, 'KELAS D', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5094, 1, 129, 'KELAS E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5095, 1, 130, 'KELAS A', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5096, 1, 130, 'KELAS B', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5097, 1, 130, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5098, 1, 130, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5099, 1, 130, 'KELAS E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5100, 1, 131, 'KELAS A', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5101, 1, 131, 'KELAS B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5102, 1, 131, 'KELAS C', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5103, 1, 131, 'KELAS D', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5104, 1, 131, 'KELAS E', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5105, 1, 132, 'KELAS A', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5106, 1, 132, 'KELAS B', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5107, 1, 132, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5108, 1, 132, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5109, 1, 132, 'KELAS E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5110, 1, 133, 'KELAS A', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5111, 1, 133, 'KELAS B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5112, 1, 133, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5113, 1, 133, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5114, 1, 133, 'KELAS E', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5115, 1, 134, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5116, 1, 134, 'TEORI B', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5117, 1, 134, 'TEORI C', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5118, 1, 134, 'TEORI D', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5119, 1, 134, 'TEORI E', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5090, 1, 129, 'KELAS A', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5120, 1, 134, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5275, 1, 149, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5346, 1, 155, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (63, 1, 96, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 346500000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5122, 1, 134, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5123, 1, 134, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5124, 1, 134, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5125, 1, 134, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5126, 1, 134, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5127, 1, 134, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5128, 1, 134, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5129, 1, 134, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5130, 1, 135, 'TEORI A', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5131, 1, 135, 'TEORI B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (59, 1, 92, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor Kepala', 30, 16, 17280000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (33, 1, 66, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Guru Besar', 30, 16, 4000000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (36, 1, 69, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Guru Besar', 30, 16, 4000000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5132, 1, 135, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (60, 1, 93, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 20480000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (50, 1, 83, 'A', 'REGULER', NULL, 'Dr. Drs. Amat Komari M.Si.', 'Lektor Kepala', 30, 16, 6000000.00, '2025-12-27 06:10:37', '2026-01-20 04:58:01'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5121, 1, 134, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5133, 1, 135, 'TEORI D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (64, 1, 97, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 346500000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (61, 1, 94, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor Kepala', 30, 16, 12960000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (62, 1, 95, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor', 30, 16, 346500000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (58, 1, 91, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 10240000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5134, 1, 135, 'TEORI E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5135, 1, 135, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5136, 1, 135, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5137, 1, 135, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5138, 1, 135, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5139, 1, 135, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5140, 1, 135, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 5120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5141, 1, 135, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5143, 1, 135, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5142, 1, 135, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5144, 1, 135, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5145, 1, 136, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5146, 1, 136, 'TEORI B', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5147, 1, 136, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5148, 1, 136, 'TEORI D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5149, 1, 136, 'TEORI E', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5150, 1, 136, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5151, 1, 136, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5152, 1, 136, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5153, 1, 136, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5154, 1, 136, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5156, 1, 136, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5157, 1, 136, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5158, 1, 136, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5159, 1, 136, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5160, 1, 137, 'KELAS A', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5161, 1, 137, 'KELAS B', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5162, 1, 137, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5163, 1, 137, 'KELAS D', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5164, 1, 137, 'KELAS E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5165, 1, 138, 'KELAS A', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5166, 1, 138, 'KELAS B', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5167, 1, 138, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5168, 1, 138, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5169, 1, 138, 'KELAS E', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5170, 1, 139, 'KELAS A', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5171, 1, 139, 'KELAS B', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5172, 1, 139, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5173, 1, 139, 'KELAS D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5174, 1, 139, 'KELAS E', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5175, 1, 140, 'TEORI A', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5176, 1, 140, 'TEORI B', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5177, 1, 140, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5178, 1, 140, 'TEORI D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5179, 1, 140, 'TEORI E', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5180, 1, 140, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5181, 1, 140, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5182, 1, 140, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5183, 1, 140, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5184, 1, 140, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5185, 1, 140, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5186, 1, 140, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5187, 1, 140, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5188, 1, 140, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5189, 1, 140, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5190, 1, 141, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5191, 1, 141, 'TEORI B', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5192, 1, 141, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5193, 1, 141, 'TEORI D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5194, 1, 141, 'TEORI E', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5195, 1, 141, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5196, 1, 141, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5197, 1, 141, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5198, 1, 141, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5199, 1, 141, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5200, 1, 141, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5201, 1, 141, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5202, 1, 141, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5203, 1, 141, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5204, 1, 141, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5205, 1, 142, 'TEORI A', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5207, 1, 142, 'TEORI C', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5208, 1, 142, 'TEORI D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5209, 1, 142, 'TEORI E', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5210, 1, 142, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5211, 1, 142, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5212, 1, 142, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5213, 1, 142, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5214, 1, 142, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5215, 1, 142, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5216, 1, 142, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5217, 1, 142, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5218, 1, 142, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5219, 1, 142, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5221, 1, 143, 'TEORI B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5222, 1, 143, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5223, 1, 143, 'TEORI D', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5224, 1, 143, 'TEORI E', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5225, 1, 143, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5226, 1, 143, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5227, 1, 143, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 5120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5228, 1, 143, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5229, 1, 143, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5230, 1, 143, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5231, 1, 143, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5232, 1, 143, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5233, 1, 143, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5234, 1, 143, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5235, 1, 144, 'KELAS A', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5236, 1, 144, 'KELAS B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5237, 1, 144, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5238, 1, 144, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5240, 1, 145, 'KELAS A', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5241, 1, 145, 'KELAS B', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5242, 1, 145, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5243, 1, 145, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5244, 1, 145, 'KELAS E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5245, 1, 146, 'KELAS A', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5246, 1, 146, 'KELAS B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5247, 1, 146, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5248, 1, 146, 'KELAS D', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5249, 1, 146, 'KELAS E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5250, 1, 147, 'TEORI A', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5251, 1, 147, 'TEORI B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5252, 1, 147, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5253, 1, 147, 'TEORI D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5254, 1, 147, 'TEORI E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5255, 1, 147, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5256, 1, 147, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5257, 1, 147, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5259, 1, 147, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5260, 1, 147, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5261, 1, 147, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5262, 1, 147, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5263, 1, 147, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5264, 1, 147, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5265, 1, 148, 'KELAS A', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5266, 1, 148, 'KELAS B', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5267, 1, 148, 'KELAS C', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5268, 1, 148, 'KELAS D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5269, 1, 148, 'KELAS E', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5270, 1, 149, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5271, 1, 149, 'TEORI B', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5272, 1, 149, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5274, 1, 149, 'TEORI E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5276, 1, 149, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5277, 1, 149, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5278, 1, 149, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5279, 1, 149, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5280, 1, 149, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5281, 1, 149, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5282, 1, 149, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5283, 1, 149, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5284, 1, 149, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5286, 1, 150, 'TEORI B', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5287, 1, 150, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5288, 1, 150, 'TEORI D', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5289, 1, 150, 'TEORI E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5290, 1, 150, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5291, 1, 150, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5292, 1, 150, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5293, 1, 150, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5294, 1, 150, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5295, 1, 150, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5296, 1, 150, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5297, 1, 150, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5298, 1, 150, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5299, 1, 150, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5300, 1, 151, 'TEORI A', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5301, 1, 151, 'TEORI B', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5303, 1, 151, 'TEORI D', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5304, 1, 151, 'TEORI E', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5305, 1, 151, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5306, 1, 151, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5307, 1, 151, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5308, 1, 151, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5309, 1, 151, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5310, 1, 151, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5311, 1, 151, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5312, 1, 151, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5313, 1, 151, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5314, 1, 151, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5315, 1, 152, 'TEORI A', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5316, 1, 152, 'TEORI B', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5317, 1, 152, 'TEORI C', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5318, 1, 152, 'TEORI D', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5319, 1, 152, 'TEORI E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5320, 1, 152, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5321, 1, 152, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5322, 1, 152, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5324, 1, 152, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5325, 1, 152, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5326, 1, 152, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5327, 1, 152, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5328, 1, 152, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5329, 1, 152, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5330, 1, 153, 'KELAS A', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5331, 1, 153, 'KELAS B', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5332, 1, 153, 'KELAS C', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5333, 1, 153, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5334, 1, 153, 'KELAS E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5335, 1, 154, 'KELAS A', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5336, 1, 154, 'KELAS B', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5337, 1, 154, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5338, 1, 154, 'KELAS D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5339, 1, 154, 'KELAS E', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5341, 1, 155, 'TEORI B', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5342, 1, 155, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5343, 1, 155, 'TEORI D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5344, 1, 155, 'TEORI E', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5345, 1, 155, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5347, 1, 155, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5349, 1, 155, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5350, 1, 155, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5351, 1, 155, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5352, 1, 155, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5353, 1, 155, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5354, 1, 155, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5355, 1, 156, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5356, 1, 156, 'TEORI B', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5357, 1, 156, 'TEORI C', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5358, 1, 156, 'TEORI D', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5359, 1, 156, 'TEORI E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5360, 1, 156, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5361, 1, 156, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5362, 1, 156, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5363, 1, 156, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5364, 1, 156, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5366, 1, 156, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5367, 1, 156, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5368, 1, 156, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5369, 1, 156, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5370, 1, 157, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5371, 1, 157, 'TEORI B', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5372, 1, 157, 'TEORI C', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5373, 1, 157, 'TEORI D', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5374, 1, 157, 'TEORI E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5375, 1, 157, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5376, 1, 157, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5377, 1, 157, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5378, 1, 157, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5379, 1, 157, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5380, 1, 157, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 5120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5381, 1, 157, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5382, 1, 157, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5383, 1, 157, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5385, 1, 158, 'KELAS A', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5386, 1, 158, 'KELAS B', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5387, 1, 158, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5388, 1, 158, 'KELAS D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5389, 1, 158, 'KELAS E', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5390, 1, 159, 'KELAS A', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 800000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5391, 1, 159, 'KELAS B', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5392, 1, 159, 'KELAS C', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5393, 1, 159, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5394, 1, 159, 'KELAS E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5395, 1, 160, 'KELAS A', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 2160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5396, 1, 160, 'KELAS B', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 2160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5397, 1, 160, 'KELAS C', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1680000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5398, 1, 160, 'KELAS D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1680000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5399, 1, 160, 'KELAS E', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1680000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5400, 1, 161, 'TEORI A', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5401, 1, 161, 'TEORI B', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5402, 1, 161, 'TEORI C', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5403, 1, 161, 'TEORI D', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5404, 1, 161, 'TEORI E', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5405, 1, 161, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5406, 1, 161, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5408, 1, 161, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5409, 1, 161, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5410, 1, 161, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5411, 1, 161, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5412, 1, 161, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5413, 1, 161, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5414, 1, 161, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5415, 1, 162, 'KELAS A', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5416, 1, 162, 'KELAS B', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5417, 1, 162, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5418, 1, 162, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5419, 1, 162, 'KELAS E', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 5120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5420, 1, 162, 'KELAS F', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5422, 1, 162, 'KELAS H', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5423, 1, 162, 'KELAS I', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5424, 1, 162, 'KELAS J', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5425, 1, 163, 'TEORI A', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5426, 1, 163, 'TEORI B', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5427, 1, 163, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5428, 1, 163, 'TEORI D', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5429, 1, 163, 'TEORI E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5430, 1, 163, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5431, 1, 163, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5432, 1, 163, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5433, 1, 163, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5434, 1, 163, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5435, 1, 163, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5436, 1, 163, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5437, 1, 163, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5439, 1, 163, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5440, 1, 164, 'KELAS A', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5441, 1, 164, 'KELAS B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5442, 1, 164, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5443, 1, 164, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5444, 1, 164, 'KELAS E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5445, 1, 165, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5446, 1, 165, 'TEORI B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5447, 1, 165, 'TEORI C', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5448, 1, 165, 'TEORI D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5449, 1, 165, 'TEORI E', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5450, 1, 165, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5451, 1, 165, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5452, 1, 165, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5453, 1, 165, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5454, 1, 165, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5455, 1, 165, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5456, 1, 165, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5458, 1, 165, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5459, 1, 165, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5460, 1, 166, 'KELAS A', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5461, 1, 166, 'KELAS B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5462, 1, 166, 'KELAS C', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5463, 1, 166, 'KELAS D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5464, 1, 166, 'KELAS E', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5465, 1, 167, 'KELAS A', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5466, 1, 167, 'KELAS B', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5467, 1, 167, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5468, 1, 167, 'KELAS D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5469, 1, 167, 'KELAS E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5470, 1, 168, 'TEORI A', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5471, 1, 168, 'TEORI B', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5472, 1, 168, 'TEORI C', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5473, 1, 168, 'TEORI D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5475, 1, 168, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 5120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5476, 1, 168, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5477, 1, 168, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5478, 1, 168, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5479, 1, 168, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5480, 1, 168, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5481, 1, 168, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5482, 1, 168, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5483, 1, 168, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 5120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5484, 1, 168, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5485, 1, 169, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5486, 1, 169, 'TEORI B', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5488, 1, 169, 'TEORI D', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5489, 1, 169, 'TEORI E', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5490, 1, 169, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5491, 1, 169, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5492, 1, 169, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5493, 1, 169, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5494, 1, 169, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5495, 1, 169, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5496, 1, 169, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5497, 1, 169, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5498, 1, 169, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5500, 1, 170, 'KELAS A', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5501, 1, 170, 'KELAS B', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5502, 1, 170, 'KELAS C', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5503, 1, 170, 'KELAS D', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 5120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5504, 1, 170, 'KELAS E', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 5120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5505, 1, 170, 'KELAS F', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5506, 1, 170, 'KELAS G', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5507, 1, 170, 'KELAS H', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5508, 1, 170, 'KELAS I', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5509, 1, 170, 'KELAS J', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5510, 1, 171, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5511, 1, 171, 'TEORI B', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5512, 1, 171, 'TEORI C', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5513, 1, 171, 'TEORI D', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5514, 1, 171, 'TEORI E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5515, 1, 171, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5516, 1, 171, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5517, 1, 171, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5518, 1, 171, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5520, 1, 171, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5521, 1, 171, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5522, 1, 171, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5523, 1, 171, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5524, 1, 171, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5525, 1, 172, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5526, 1, 172, 'TEORI B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5527, 1, 172, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5528, 1, 172, 'TEORI D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5529, 1, 172, 'TEORI E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5530, 1, 172, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5531, 1, 172, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5532, 1, 172, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5533, 1, 172, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5534, 1, 172, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5535, 1, 172, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5536, 1, 172, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5537, 1, 172, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5538, 1, 172, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5540, 1, 173, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5542, 1, 173, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5543, 1, 173, 'TEORI D', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5544, 1, 173, 'TEORI E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5545, 1, 173, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5546, 1, 173, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5547, 1, 173, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5548, 1, 173, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5549, 1, 173, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5550, 1, 173, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5551, 1, 173, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5552, 1, 173, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5554, 1, 173, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5555, 1, 174, 'GABUNGAN', 'REGULER', NULL, NULL, 'Lektor Kepala', 200, 16, 35000000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5556, 1, 175, 'GABUNGAN', 'REGULER', NULL, NULL, 'Lektor', 200, 16, 35000000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5557, 1, 176, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5558, 1, 176, 'TEORI B', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5559, 1, 176, 'TEORI C', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5560, 1, 176, 'TEORI D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5561, 1, 176, 'TEORI E', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5562, 1, 176, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5563, 1, 176, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5564, 1, 176, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5565, 1, 176, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5566, 1, 176, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5567, 1, 176, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5568, 1, 176, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5569, 1, 176, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5570, 1, 176, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5572, 1, 177, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5573, 1, 177, 'TEORI B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5574, 1, 177, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5575, 1, 177, 'TEORI D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5576, 1, 177, 'TEORI E', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5577, 1, 177, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5578, 1, 177, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5579, 1, 177, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5580, 1, 177, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5581, 1, 177, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5582, 1, 177, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5583, 1, 177, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5584, 1, 177, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5585, 1, 177, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5586, 1, 177, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5587, 1, 178, 'KELAS A', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5588, 1, 178, 'KELAS B', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5589, 1, 178, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5590, 1, 178, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5592, 1, 178, 'KELAS F', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5593, 1, 178, 'KELAS G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5594, 1, 178, 'KELAS H', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5595, 1, 178, 'KELAS I', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5596, 1, 178, 'KELAS J', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5597, 1, 179, 'KELAS A', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 5120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5598, 1, 179, 'KELAS B', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5599, 1, 179, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5600, 1, 179, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5601, 1, 179, 'KELAS E', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5602, 1, 179, 'KELAS F', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 5120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5603, 1, 179, 'KELAS G', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5604, 1, 179, 'KELAS H', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5605, 1, 179, 'KELAS I', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5606, 1, 179, 'KELAS J', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5607, 1, 180, 'KELAS A', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5609, 1, 180, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5610, 1, 180, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5611, 1, 180, 'KELAS E', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5612, 1, 180, 'KELAS F', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5613, 1, 180, 'KELAS G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5614, 1, 180, 'KELAS H', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5615, 1, 180, 'KELAS I', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5617, 1, 181, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5618, 1, 181, 'TEORI B', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5619, 1, 181, 'TEORI C', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5620, 1, 181, 'TEORI D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5621, 1, 181, 'TEORI E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 40, 16, 400000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5622, 1, 181, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5623, 1, 181, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5624, 1, 181, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 5120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5625, 1, 181, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5626, 1, 181, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5627, 1, 181, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5628, 1, 181, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5629, 1, 181, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5630, 1, 181, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5631, 1, 181, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5632, 1, 182, 'GABUNGAN', 'REGULER', NULL, NULL, 'Lektor Kepala', 200, 16, 35000000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5633, 1, 183, 'GABUNGAN', 'REGULER', NULL, NULL, 'Asisten Ahli', 200, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5634, 1, 184, 'TEORI A', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5636, 1, 184, 'TEORI C', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5637, 1, 184, 'TEORI D', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5638, 1, 184, 'TEORI E', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5639, 1, 184, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5640, 1, 184, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5641, 1, 184, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5642, 1, 184, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5643, 1, 184, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5644, 1, 184, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5645, 1, 184, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5646, 1, 184, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5647, 1, 184, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5648, 1, 184, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5649, 1, 185, 'KELAS A', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5650, 1, 185, 'KELAS B', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5651, 1, 185, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5652, 1, 185, 'KELAS D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5653, 1, 185, 'KELAS E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5654, 1, 186, 'TEORI A', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5655, 1, 186, 'TEORI B', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5656, 1, 186, 'TEORI C', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5658, 1, 186, 'TEORI E', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 720000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5659, 1, 186, 'PRAKTIK A', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5660, 1, 186, 'PRAKTIK B', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5661, 1, 186, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5662, 1, 186, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5663, 1, 186, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5664, 1, 186, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5665, 1, 186, 'PRAKTIK G', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5666, 1, 186, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5667, 1, 186, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5668, 1, 186, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5669, 1, 187, 'KELAS A', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5670, 1, 187, 'KELAS B', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5671, 1, 187, 'KELAS C', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5672, 1, 187, 'KELAS D', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5673, 1, 187, 'KELAS E', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5674, 1, 187, 'KELAS F', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5635, 1, 184, 'TEORI B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5657, 1, 186, 'TEORI D', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5675, 1, 187, 'KELAS G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5676, 1, 187, 'KELAS H', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5677, 1, 187, 'KELAS I', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5678, 1, 187, 'KELAS J', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5679, 1, 188, 'GABUNGAN', 'REGULER', NULL, NULL, 'Asisten Ahli', 200, 16, 180000000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5155, 1, 136, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5206, 1, 142, 'TEORI B', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5220, 1, 143, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5239, 1, 144, 'KELAS E', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5258, 1, 147, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5273, 1, 149, 'TEORI D', 'REGULER', NULL, NULL, 'Lektor', 40, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5285, 1, 150, 'TEORI A', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5302, 1, 151, 'TEORI C', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5323, 1, 152, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5340, 1, 155, 'TEORI A', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5348, 1, 155, 'PRAKTIK D', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5365, 1, 156, 'PRAKTIK F', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5384, 1, 157, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 4160000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5407, 1, 161, 'PRAKTIK C', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5421, 1, 162, 'KELAS G', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5438, 1, 163, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5457, 1, 165, 'PRAKTIK H', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5474, 1, 168, 'TEORI E', 'REGULER', NULL, NULL, 'Asisten Ahli', 40, 16, 560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5487, 1, 169, 'TEORI C', 'REGULER', NULL, NULL, 'Guru Besar', 40, 16, 1120000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5499, 1, 169, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Lektor Kepala', 20, 16, 2080000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5519, 1, 171, 'PRAKTIK E', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 1760000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5539, 1, 172, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 1440000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5541, 1, 173, 'TEORI B', 'REGULER', NULL, NULL, 'Lektor Kepala', 40, 16, 880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5553, 1, 173, 'PRAKTIK I', 'REGULER', NULL, NULL, 'Lektor', 20, 16, 3520000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5571, 1, 176, 'PRAKTIK J', 'REGULER', NULL, NULL, 'Guru Besar', 20, 16, 2560000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5591, 1, 178, 'KELAS E', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5608, 1, 180, 'KELAS B', 'REGULER', NULL, NULL, 'Tenaga Pengajar', 20, 16, 2240000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5616, 1, 180, 'KELAS J', 'REGULER', NULL, NULL, 'Asisten Ahli', 20, 16, 2880000.00, '2026-05-02 09:33:52', '2026-05-02 09:33:52'); -- ---------------------------- -- Table structure for akademik_matakuliah -- ---------------------------- DROP TABLE IF EXISTS "public"."akademik_matakuliah"; CREATE TABLE "public"."akademik_matakuliah" ( "id" int8 NOT NULL DEFAULT nextval('akademik_matakuliah_id_seq'::regclass), "prodi_id" int8 NOT NULL, "kode_mk" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "nama_mk" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "sks_total" int4 NOT NULL DEFAULT 0, "sks_teori" int4 NOT NULL DEFAULT 0, "sks_praktik" int4 NOT NULL DEFAULT 0, "sks_lapangan" int4 NOT NULL DEFAULT 0, "jenis_mk" varchar(20) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'KULIAH'::character varying, "semester_paket" int4, "created_at" timestamp(6), "updated_at" timestamp(6) ) ; -- ---------------------------- -- Records of akademik_matakuliah -- ---------------------------- INSERT INTO "public"."akademik_matakuliah" VALUES (65, 5, 'MAT501', 'Filsafat Ilmu & Pendidikan Jasmani', 2, 2, 0, 0, 'KULIAH', 0, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (66, 5, 'MAT502', 'Statistik Terapan Lanjut', 2, 2, 0, 0, 'KULIAH', 0, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (67, 5, 'MKP601', 'Metodologi Penelitian Pendidikan Olahraga', 3, 2, 1, 0, 'KULIAH', 1, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (68, 5, 'MKP602', 'Pedagogi Olahraga Sekolah Dasar', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (69, 5, 'MKP603', 'Psikologi Pendidikan Jasmani SD', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (70, 5, 'MKK604', 'Model & Desain Pembelajaran Penjas SD', 3, 2, 1, 0, 'KULIAH', 1, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (71, 5, 'MKK605', 'Asesmen & Evaluasi Pembelajaran Penjas', 3, 2, 1, 0, 'KULIAH', 1, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (72, 5, 'MKK606', 'Pengembangan Kurikulum Penjas SD', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (73, 5, 'MKK701', 'Analisis Gerak & Biomekanika SD', 3, 1, 2, 0, 'KULIAH', 2, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (74, 5, 'MKK702', 'Pendidikan Jasmani Adaptif Lanjut', 2, 1, 1, 0, 'KULIAH', 2, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (75, 5, 'MKK703', 'Teknologi Informasi dalam Penjas', 3, 1, 2, 0, 'KULIAH', 2, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (76, 5, 'MKK704', 'Manajemen Penjas & Olahraga Sekolah', 2, 2, 0, 0, 'KULIAH', 2, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (78, 5, 'MKT801', 'Penulisan Karya Ilmiah Internasional', 2, 1, 1, 0, 'KULIAH', 3, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (80, 5, 'MKK901', 'Tesis (Penelitian & Ujian)', 6, 0, 0, 6, 'BIMBINGAN_UJI', 4, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (81, 6, 'MAT901', 'Filsafat Ilmu Keolahragaan Lanjut', 2, 2, 0, 0, 'KULIAH', 0, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (82, 6, 'MAT902', 'Metodologi Riset Kuantitatif & Kualitatif', 2, 2, 0, 0, 'KULIAH', 0, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (83, 6, 'DOK101', 'Filsafat Pendidikan Jasmani & Olahraga', 3, 3, 0, 0, 'KULIAH', 1, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (85, 6, 'DOK103', 'Desain & Analisis Statistik Lanjut', 3, 2, 1, 0, 'KULIAH', 1, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (87, 6, 'DOK201', 'Pengembangan Model Kurikulum Penjas SD', 3, 2, 1, 0, 'KULIAH', 2, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (88, 6, 'DOK202', 'Evaluasi Program & Kebijakan Penjas', 3, 2, 1, 0, 'KULIAH', 2, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (89, 6, 'DOK203', 'Seminar Proposal Disertasi (Pra-Kualifikasi)', 2, 0, 2, 0, 'BIMBINGAN_UJI', 2, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (95, 6, 'DOK501', 'Ujian Kelayakan Naskah Disertasi', 2, 0, 0, 2, 'BIMBINGAN_UJI', 5, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (96, 6, 'DOK601', 'Ujian Tertutup Disertasi', 3, 0, 0, 3, 'BIMBINGAN_UJI', 6, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (97, 6, 'DOK602', 'Promosi Doktor (Ujian Terbuka)', 4, 0, 0, 4, 'BIMBINGAN_UJI', 6, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (84, 6, 'DOK102', 'Teori & Isu Kritis Penjas SD', 3, 3, 0, 0, 'KULIAH', 1, '2025-12-27 02:15:45', '2025-12-27 22:07:35'); INSERT INTO "public"."akademik_matakuliah" VALUES (79, 5, 'MKK802', 'Seminar Proposal Tesis', 2, 0, 2, 0, 'KULIAH', 3, '2025-12-27 02:15:28', '2025-12-28 07:09:22'); INSERT INTO "public"."akademik_matakuliah" VALUES (92, 6, 'DOK302', 'Validasi Instrumen & Pengumpulan Data', 4, 0, 4, 0, 'KULIAH', 3, '2025-12-27 02:15:45', '2025-12-27 22:08:26'); INSERT INTO "public"."akademik_matakuliah" VALUES (93, 6, 'DOK401', 'Analisis Data & Penulisan Disertasi', 4, 0, 4, 0, 'KULIAH', 4, '2025-12-27 02:15:45', '2025-12-27 22:08:43'); INSERT INTO "public"."akademik_matakuliah" VALUES (94, 6, 'DOK402', 'Publikasi Ilmiah Internasional 2', 3, 0, 3, 0, 'KULIAH', 4, '2025-12-27 02:15:45', '2025-12-27 22:08:53'); INSERT INTO "public"."akademik_matakuliah" VALUES (77, 5, 'MKK705', 'Isu-isu Kontemporer Penjas SD', 2, 2, 0, 0, 'KULIAH', 2, '2025-12-27 02:15:28', '2025-12-27 22:10:13'); INSERT INTO "public"."akademik_matakuliah" VALUES (91, 6, 'DOK301', 'Ujian Kualifikasi (Komprehensif)', 2, 0, 2, 0, 'KULIAH', 3, '2025-12-27 02:15:45', '2025-12-28 01:04:06'); INSERT INTO "public"."akademik_matakuliah" VALUES (90, 6, 'DOK204', 'Publikasi Ilmiah Internasional 1', 2, 0, 2, 0, 'KULIAH', 2, '2025-12-27 02:15:45', '2025-12-27 14:37:47'); INSERT INTO "public"."akademik_matakuliah" VALUES (86, 6, 'DOK104', 'Studi Mandiri (Independent Study)', 3, 0, 3, 0, 'KULIAH', 1, '2025-12-27 02:15:45', '2025-12-27 22:07:48'); INSERT INTO "public"."akademik_matakuliah" VALUES (129, 4, 'UNY101', 'Pendidikan Agama', 2, 2, 0, 0, 'KULIAH', 1, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (130, 4, 'UNY102', 'Pancasila', 2, 2, 0, 0, 'KULIAH', 1, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (131, 4, 'UNY103', 'Pendidikan Kewarganegaraan', 2, 2, 0, 0, 'KULIAH', 1, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (132, 4, 'UNY201', 'Bahasa Indonesia', 2, 2, 0, 0, 'KULIAH', 1, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (133, 4, 'PJD101', 'Landasan Pendidikan Jasmani', 2, 2, 0, 0, 'KULIAH', 1, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (134, 4, 'PJD102', 'Anatomi Manusia', 3, 2, 1, 0, 'KULIAH', 1, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (135, 4, 'PJD104', 'Atletik Dasar (Lari & Lompat)', 3, 1, 2, 0, 'KULIAH', 1, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (136, 4, 'PJD105', 'Senam Dasar & Ritmik', 3, 1, 2, 0, 'KULIAH', 1, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (137, 4, 'PJD106', 'Pengantar Pendidikan', 2, 2, 0, 0, 'KULIAH', 1, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (138, 4, 'PJD103', 'Fisiologi Dasar', 2, 2, 0, 0, 'KULIAH', 2, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (139, 4, 'PJD201', 'Perkembangan Peserta Didik SD', 2, 2, 0, 0, 'KULIAH', 2, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (140, 4, 'PJD202', 'Belajar Gerak (Motor Learning)', 3, 2, 1, 0, 'KULIAH', 2, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (141, 4, 'PJD203', 'Renang Dasar & Penyelamatan Air', 3, 1, 2, 0, 'KULIAH', 2, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (142, 4, 'PJD204', 'Permainan Bola Kecil', 2, 1, 1, 0, 'KULIAH', 2, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (143, 4, 'PJD205', 'Permainan Bola Besar', 3, 1, 2, 0, 'KULIAH', 2, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (144, 4, 'PJD206', 'Psikologi Pendidikan', 2, 2, 0, 0, 'KULIAH', 2, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (145, 4, 'PJD207', 'Sosiologi Olahraga', 2, 2, 0, 0, 'KULIAH', 2, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (146, 4, 'PJD208', 'Ilmu Gizi Olahraga', 2, 2, 0, 0, 'KULIAH', 2, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (147, 4, 'PJD301', 'Strategi Pembelajaran Penjas SD', 3, 2, 1, 0, 'KULIAH', 3, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (148, 4, 'PJD302', 'Kurikulum Penjas SD (Merdeka)', 2, 2, 0, 0, 'KULIAH', 3, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (149, 4, 'PJD303', 'Pendidikan Jasmani Adaptif', 3, 2, 1, 0, 'KULIAH', 3, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (150, 4, 'PJD304', 'Aktivitas Luar Kelas', 3, 1, 2, 0, 'KULIAH', 3, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (151, 4, 'PJD305', 'Pencak Silat & Beladiri SD', 2, 1, 1, 0, 'KULIAH', 3, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (152, 4, 'PJD306', 'Biomekanika Olahraga', 2, 1, 1, 0, 'KULIAH', 3, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (153, 4, 'PJD307', 'Filsafat Olahraga', 2, 2, 0, 0, 'KULIAH', 3, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (154, 4, 'PJD308', 'Pendidikan Inklusi', 2, 2, 0, 0, 'KULIAH', 3, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (155, 4, 'PJD309', 'Dasar-dasar Kepelatihan', 2, 1, 1, 0, 'KULIAH', 3, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (156, 4, 'PJD401', 'Evaluasi Pembelajaran Penjas', 3, 2, 1, 0, 'KULIAH', 4, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (157, 4, 'PJD402', 'Teknologi & Media Pembelajaran', 3, 1, 2, 0, 'KULIAH', 4, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (158, 4, 'PJD403', 'Manajemen Pendidikan Jasmani', 2, 2, 0, 0, 'KULIAH', 4, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (159, 4, 'PJD404', 'Gizi Olahraga & Kesehatan Sekolah', 2, 2, 0, 0, 'KULIAH', 4, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (160, 4, 'PJD405', 'Metodologi Penelitian Pendidikan', 3, 3, 0, 0, 'KULIAH', 4, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (161, 4, 'PJD406', 'Permainan Tradisional SD', 2, 1, 1, 0, 'KULIAH', 4, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (162, 4, 'PJD407', 'Pembelajaran Senam Lanjut', 2, 0, 2, 0, 'KULIAH', 4, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (163, 4, 'PJD408', 'Pencegahan & Perawatan Cedera Olahraga', 2, 1, 1, 0, 'KULIAH', 4, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (164, 4, 'UNY401', 'Bahasa Inggris Profesi', 2, 2, 0, 0, 'KULIAH', 4, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (165, 4, 'PJD501', 'Micro Teaching', 3, 1, 2, 0, 'KULIAH', 5, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (166, 4, 'PJD502', 'Statistika Pendidikan', 2, 2, 0, 0, 'KULIAH', 5, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (167, 4, 'PJD503', 'K3 Olahraga', 2, 2, 0, 0, 'KULIAH', 5, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (168, 4, 'PJD504', 'Tes & Pengukuran Penjas', 3, 1, 2, 0, 'KULIAH', 5, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (169, 4, 'PJD505', 'Pembinaan Olahraga Usia Dini', 2, 1, 1, 0, 'KULIAH', 5, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (170, 4, 'PJD506', 'Senam Kebugaran Jasmani (SKJ)', 2, 0, 2, 0, 'KULIAH', 5, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (171, 4, 'PJD507', 'Kewirausahaan Olahraga', 2, 1, 1, 0, 'KULIAH', 5, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (172, 4, 'PJD508', 'Modifikasi Olahraga SD', 2, 1, 1, 0, 'KULIAH', 5, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (173, 4, 'PJD509', 'Olahraga Pilihan A (Tenis Meja / Bulutangkis)', 3, 1, 2, 0, 'KULIAH', 5, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (174, 4, 'PJD601', 'PLP / Magang Kependidikan 1', 2, 0, 0, 2, 'BIMBINGAN', 6, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (175, 4, 'UNY601', 'Kuliah Kerja Nyata (KKN)', 4, 0, 0, 4, 'BIMBINGAN', 6, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (176, 4, 'PJD602', 'Penulisan Karya Ilmiah', 2, 1, 1, 0, 'KULIAH', 6, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (177, 4, 'PJD603', 'Manajemen Pertandingan Olahraga', 2, 1, 1, 0, 'KULIAH', 6, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (178, 4, 'PJD604', 'Pembelajaran Renang Lanjut', 2, 0, 2, 0, 'KULIAH', 6, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (179, 4, 'PJD605', 'Kepramukaan & Outbound', 2, 0, 2, 0, 'KULIAH', 6, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (180, 4, 'PJD606', 'Pembelajaran Atletik Lanjut', 2, 0, 2, 0, 'KULIAH', 6, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (181, 4, 'PJD607', 'Olahraga Pilihan B (Futsal / Bola Voli)', 3, 1, 2, 0, 'KULIAH', 6, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (182, 4, 'PJD701', 'PLP / Magang Kependidikan 2', 4, 0, 0, 4, 'BIMBINGAN', 7, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (183, 4, 'PJD702', 'Seminar Proposal Skripsi', 2, 0, 2, 0, 'KULIAH', 7, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (184, 4, 'PJD703', 'Fisiologi Olahraga Lanjut', 2, 1, 1, 0, 'KULIAH', 7, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (185, 4, 'PJD704', 'Promosi Kesehatan Sekolah', 2, 2, 0, 0, 'KULIAH', 7, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (186, 4, 'PJD705', 'Pedagogi Olahraga Terapan', 2, 1, 1, 0, 'KULIAH', 7, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (187, 4, 'PJD706', 'Pijat Olahraga / Masase', 2, 0, 2, 0, 'KULIAH', 7, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); INSERT INTO "public"."akademik_matakuliah" VALUES (188, 4, 'PJD801', 'Skripsi / Tugas Akhir', 6, 0, 0, 6, 'BIMBINGAN_UJI', 8, '2026-05-01 06:57:46.875841', '2026-05-01 06:57:46.875841'); -- ---------------------------- -- Table structure for indirect_budgets -- ---------------------------- DROP TABLE IF EXISTS "public"."indirect_budgets"; CREATE TABLE "public"."indirect_budgets" ( "id" int8 NOT NULL DEFAULT nextval('indirect_budgets_id_seq'::regclass), "activity_component_id" int8 NOT NULL, "tahun_anggaran" int4 NOT NULL, "sumber_data" varchar(255) COLLATE "pg_catalog"."default", "waktu_jam" numeric(10,2), "jumlah_mhs" int4, "total_driver_volume" numeric(15,2) NOT NULL DEFAULT 0, "nilai_btl" numeric(15,2) NOT NULL DEFAULT 0, "rate_per_unit" numeric(15,2) NOT NULL DEFAULT 0, "created_at" timestamp(6), "updated_at" timestamp(6) ) ; -- ---------------------------- -- Records of indirect_budgets -- ---------------------------- -- ---------------------------- -- Table structure for migrations -- ---------------------------- DROP TABLE IF EXISTS "public"."migrations"; CREATE TABLE "public"."migrations" ( "id" int8 NOT NULL DEFAULT nextval('migrations_id_seq'::regclass), "version" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "class" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "group" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "namespace" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "time" int4 NOT NULL, "batch" int4 NOT NULL ) ; -- ---------------------------- -- Records of migrations -- ---------------------------- INSERT INTO "public"."migrations" VALUES (35, '2024-01-01-000001', 'App\Database\Migrations\CreateIndirectCostStructure', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (36, '20240101000001', 'App\Database\Migrations\Users', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (37, '20240101000002', 'App\Database\Migrations\Menus', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (38, '20240101000003', 'App\Database\Migrations\Faculties', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (39, '20240101000004', 'App\Database\Migrations\Departemens', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (40, '20240101000005', 'App\Database\Migrations\StudyPrograms', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (41, '20240101000006', 'App\Database\Migrations\AddUserRelations', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (42, '20240101000006', 'App\Database\Migrations\CostCategories', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (43, '20240101000008', 'App\Database\Migrations\Activities', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (44, '20240101000009', 'App\Database\Migrations\Drivers', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (45, '20240101000010', 'App\Database\Migrations\AcademicYears', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (46, '20240101000011', 'App\Database\Migrations\TransResources', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (47, '20240101000012', 'App\Database\Migrations\TransDriverValues', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (48, '20240101000013', 'App\Database\Migrations\ResourceAssignments', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (49, '20240101000014', 'App\Database\Migrations\ActivityAllocations', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (50, '20240101000015', 'App\Database\Migrations\ReportUnitCosts', 'default', 'App', 1765003988, 1); INSERT INTO "public"."migrations" VALUES (51, '2024-01-01-000099', 'App\Database\Migrations\CompleteTransactionTables', 'default', 'App', 1765071728, 2); INSERT INTO "public"."migrations" VALUES (52, '2024-01-01-000100', 'App\Database\Migrations\AddCostTypeToCategories', 'default', 'App', 1765155380, 3); INSERT INTO "public"."migrations" VALUES (53, '2024-01-01-000101', 'App\Database\Migrations\AddScopeToCostCategories', 'default', 'App', 1765159020, 4); INSERT INTO "public"."migrations" VALUES (54, '2024-01-01-000102', 'App\Database\Migrations\RefactorCostTypesAndLevels', 'default', 'App', 1765163352, 5); INSERT INTO "public"."migrations" VALUES (55, '2024-01-01-000103', 'App\Database\Migrations\AddRelations', 'default', 'App', 1765167915, 6); INSERT INTO "public"."migrations" VALUES (56, '2024-01-01-000104', 'App\Database\Migrations\AddIsActiveToUsers', 'default', 'App', 1765170023, 7); INSERT INTO "public"."migrations" VALUES (57, '2024-01-01-000104', 'App\Database\Migrations\CreateLaborRatesTable', 'default', 'App', 1765177979, 8); INSERT INTO "public"."migrations" VALUES (58, '2024-01-01-000105', 'App\Database\Migrations\CreateUnitConfigTable', 'default', 'App', 1765185172, 9); INSERT INTO "public"."migrations" VALUES (59, '2024-01-01-000105', 'App\Database\Migrations\CreateLaborConfig', 'default', 'App', 1765268397, 10); INSERT INTO "public"."migrations" VALUES (60, '2025-01-01-000200', 'App\Database\Migrations\UpdateSchemaSsbopt', 'default', 'App', 1766650556, 11); INSERT INTO "public"."migrations" VALUES (61, '2024-01-01-000101', 'App\Database\Migrations\FixCostCategoriesScope', 'default', 'App', 1766707184, 12); INSERT INTO "public"."migrations" VALUES (62, '2025-01-01-000203', 'App\Database\Migrations\AddDetailsToResources', 'default', 'App', 1766729308, 13); INSERT INTO "public"."migrations" VALUES (63, '2025-01-01-000300', 'App\Database\Migrations\CreateCurriculumTables', 'default', 'App', 1766732650, 14); INSERT INTO "public"."migrations" VALUES (64, '2025-01-01-000205', 'App\Database\Migrations\AddFullnameToUsers', 'default', 'App', 1766746764, 15); INSERT INTO "public"."migrations" VALUES (65, '2025-01-01-000206', 'App\Database\Migrations\AddResourceName', 'default', 'App', 1766819223, 16); -- ---------------------------- -- Table structure for ms_academic_years -- ---------------------------- DROP TABLE IF EXISTS "public"."ms_academic_years"; CREATE TABLE "public"."ms_academic_years" ( "id" int4 NOT NULL DEFAULT nextval('ms_academic_years_id_seq'::regclass), "year_name" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "is_active" bool NOT NULL DEFAULT false, "description" text COLLATE "pg_catalog"."default", "created_at" timestamp(6), "updated_at" timestamp(6) ) ; -- ---------------------------- -- Records of ms_academic_years -- ---------------------------- INSERT INTO "public"."ms_academic_years" VALUES (2, '2025/2026', 'f', '', '2025-12-07 23:46:46', '2026-01-27 04:25:11'); INSERT INTO "public"."ms_academic_years" VALUES (1, '2024/2025', 't', '', NULL, '2026-01-27 04:25:15'); -- ---------------------------- -- Table structure for ms_departments -- ---------------------------- DROP TABLE IF EXISTS "public"."ms_departments"; CREATE TABLE "public"."ms_departments" ( "id" int8 NOT NULL DEFAULT nextval('ms_departments_id_seq'::regclass), "department_code" varchar(20) COLLATE "pg_catalog"."default", "department_name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "faculty_id" int8, "created_at" timestamp(6), "updated_at" timestamp(6), "deleted_at" timestamp(6) ) ; -- ---------------------------- -- Records of ms_departments -- ---------------------------- INSERT INTO "public"."ms_departments" VALUES (1, 'DEPT-PJSD', 'Departemen Pendidikan Jasmani Sekolah Dasar', 1, NULL, NULL, NULL); INSERT INTO "public"."ms_departments" VALUES (2, 'DEPT-PO', 'Departemen Pendidikan Olahraga', 1, NULL, NULL, NULL); -- ---------------------------- -- Table structure for ms_faculties -- ---------------------------- DROP TABLE IF EXISTS "public"."ms_faculties"; CREATE TABLE "public"."ms_faculties" ( "id" int8 NOT NULL DEFAULT nextval('ms_faculties_id_seq'::regclass), "faculty_code" varchar(20) COLLATE "pg_catalog"."default", "faculty_name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "created_at" timestamp(6), "updated_at" timestamp(6), "deleted_at" timestamp(6) ) ; -- ---------------------------- -- Records of ms_faculties -- ---------------------------- INSERT INTO "public"."ms_faculties" VALUES (1, 'FIKK', 'Fakultas Ilmu Keolahragaan dan Kesehatan', NULL, NULL, NULL); INSERT INTO "public"."ms_faculties" VALUES (2, 'FV', 'Fakultas Vokasi', '2025-12-27 00:46:50', '2025-12-27 00:46:50', NULL); -- ---------------------------- -- Table structure for ms_honor_rates -- ---------------------------- DROP TABLE IF EXISTS "public"."ms_honor_rates"; CREATE TABLE "public"."ms_honor_rates" ( "id" int8 NOT NULL DEFAULT nextval('ms_honor_rates_id_seq'::regclass), "year_id" int8 NOT NULL, "kategori_kegiatan" varchar(50) COLLATE "pg_catalog"."default" NOT NULL, "jabatan_fungsional" varchar(50) COLLATE "pg_catalog"."default" NOT NULL, "jenjang_prodi" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "program_kelas" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'REGULER'::character varying, "tipe_mk" varchar(5) COLLATE "pg_catalog"."default", "peran_bimbingan" varchar(100) COLLATE "pg_catalog"."default", "tarif_per_satuan" numeric(15,2) NOT NULL DEFAULT 0, "satuan_hitung" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'PER_SKS_TM'::character varying, "deskripsi" text COLLATE "pg_catalog"."default" ) ; -- ---------------------------- -- Records of ms_honor_rates -- ---------------------------- INSERT INTO "public"."ms_honor_rates" VALUES (133, 1, 'MEMBIMBING', 'Guru Besar', 'S3', 'REGULER', NULL, 'Promotor', 5175000.00, 'PER_MAHASISWA', 'Tarif Promotor S3 (Guru Besar)'); INSERT INTO "public"."ms_honor_rates" VALUES (134, 1, 'MEMBIMBING', 'Lektor Kepala', 'S3', 'REGULER', NULL, 'Promotor', 4620000.00, 'PER_MAHASISWA', 'Tarif Promotor S3 (Lektor Kepala)'); INSERT INTO "public"."ms_honor_rates" VALUES (135, 1, 'MEMBIMBING', 'Lektor', 'S3', 'REGULER', NULL, 'Promotor', 4300000.00, 'PER_MAHASISWA', 'Tarif Promotor S3 (Lektor)'); INSERT INTO "public"."ms_honor_rates" VALUES (136, 1, 'MEMBIMBING', 'Guru Besar', 'S3', 'REGULER', NULL, 'Co-Promotor', 4025000.00, 'PER_MAHASISWA', 'Tarif Co-Promotor S3 (Guru Besar)'); INSERT INTO "public"."ms_honor_rates" VALUES (137, 1, 'MEMBIMBING', 'Lektor Kepala', 'S3', 'REGULER', NULL, 'Co-Promotor', 3570000.00, 'PER_MAHASISWA', 'Tarif Co-Promotor S3 (Lektor Kepala)'); INSERT INTO "public"."ms_honor_rates" VALUES (138, 1, 'MEMBIMBING', 'Lektor', 'S3', 'REGULER', NULL, 'Co-Promotor', 3300000.00, 'PER_MAHASISWA', 'Tarif Co-Promotor S3 (Lektor)'); INSERT INTO "public"."ms_honor_rates" VALUES (139, 1, 'MENGUJI', 'Guru Besar', 'S3', 'REGULER', NULL, 'Ketua Penguji', 750000.00, 'PER_MAHASISWA', 'Tarif Ketua Penguji S3 (Guru Besar)'); INSERT INTO "public"."ms_honor_rates" VALUES (140, 1, 'MENGUJI', 'Guru Besar', 'S3', 'REGULER', NULL, 'Sekretaris Penguji', 600000.00, 'PER_MAHASISWA', 'Tarif Sekretaris Penguji S3 (Guru Besar)'); INSERT INTO "public"."ms_honor_rates" VALUES (141, 1, 'MENGUJI', 'Guru Besar', 'S3', 'REGULER', NULL, 'Anggota Penguji', 500000.00, 'PER_MAHASISWA', 'Tarif Anggota Penguji S3 (Guru Besar)'); INSERT INTO "public"."ms_honor_rates" VALUES (142, 1, 'MEMBIMBING', 'Guru Besar', 'S2', 'REGULER', NULL, 'Pembimbing Utama', 2817500.00, 'PER_MAHASISWA', 'Tarif Pembimbing Utama S2 (Guru Besar)'); INSERT INTO "public"."ms_honor_rates" VALUES (5, 1, 'MENGAJAR', 'Tenaga Pengajar', 'S1', 'REGULER', 'T', NULL, 25000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (T) - Tenaga Pengajar'); INSERT INTO "public"."ms_honor_rates" VALUES (6, 1, 'MENGAJAR', 'Asisten Ahli', 'S1', 'REGULER', 'P', NULL, 45000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (P) - Asisten Ahli'); INSERT INTO "public"."ms_honor_rates" VALUES (7, 1, 'MENGAJAR', 'Lektor', 'S1', 'REGULER', 'P', NULL, 55000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (P) - Lektor'); INSERT INTO "public"."ms_honor_rates" VALUES (8, 1, 'MENGAJAR', 'Lektor Kepala', 'S1', 'REGULER', 'P', NULL, 65000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (P) - Lektor Kepala'); INSERT INTO "public"."ms_honor_rates" VALUES (143, 1, 'MEMBIMBING', 'Lektor Kepala', 'S2', 'REGULER', NULL, 'Pembimbing Utama', 2546250.00, 'PER_MAHASISWA', 'Tarif Pembimbing Utama S2 (Lektor Kepala)'); INSERT INTO "public"."ms_honor_rates" VALUES (144, 1, 'MEMBIMBING', 'Lektor', 'S2', 'REGULER', NULL, 'Pembimbing Utama', 2400000.00, 'PER_MAHASISWA', 'Tarif Pembimbing Utama S2 (Lektor)'); INSERT INTO "public"."ms_honor_rates" VALUES (33, 1, 'MENGAJAR', 'Lektor', 'S3', 'REGULER', 'T', NULL, 100000.00, 'PER_SKS_TM', 'Tarif Tambahan MENGAJAR S3 - Lektor'); INSERT INTO "public"."ms_honor_rates" VALUES (34, 1, 'MENGAJAR', 'Lektor', 'S3', 'REGULER', 'P', NULL, 110000.00, 'PER_SKS_TM', 'Tarif Tambahan MENGAJAR S3 - Lektor'); INSERT INTO "public"."ms_honor_rates" VALUES (35, 1, 'MENGAJAR', 'Lektor Kepala', 'S3', 'REGULER', 'T', NULL, 125000.00, 'PER_SKS_TM', 'Tarif Tambahan MENGAJAR S3 - Lektor Kepala'); INSERT INTO "public"."ms_honor_rates" VALUES (36, 1, 'MENGAJAR', 'Lektor Kepala', 'S3', 'REGULER', 'P', NULL, 135000.00, 'PER_SKS_TM', 'Tarif Tambahan MENGAJAR S3 - Lektor Kepala'); INSERT INTO "public"."ms_honor_rates" VALUES (37, 1, 'MENGAJAR', 'Guru Besar', 'S3', 'REGULER', 'P', NULL, 160000.00, 'PER_SKS_TM', 'Tarif Tambahan MENGAJAR S3 - Guru Besar'); INSERT INTO "public"."ms_honor_rates" VALUES (145, 1, 'MEMBIMBING', 'Asisten Ahli', 'S2', 'REGULER', NULL, 'Pembimbing Utama', 2375000.00, 'PER_MAHASISWA', 'Tarif Pembimbing Utama S2 (Asisten Ahli)'); INSERT INTO "public"."ms_honor_rates" VALUES (146, 1, 'MENGUJI', 'Guru Besar', 'S2', 'REGULER', NULL, 'Ketua Penguji', 450000.00, 'PER_MAHASISWA', 'Tarif Ketua Penguji S2 (Guru Besar)'); INSERT INTO "public"."ms_honor_rates" VALUES (147, 1, 'MENGUJI', 'Lektor Kepala', 'S2', 'REGULER', NULL, 'Ketua Penguji', 425000.00, 'PER_MAHASISWA', 'Tarif Ketua Penguji S2 (Lektor Kepala)'); INSERT INTO "public"."ms_honor_rates" VALUES (148, 1, 'MENGUJI', 'Lektor', 'S2', 'REGULER', NULL, 'Ketua Penguji', 400000.00, 'PER_MAHASISWA', 'Tarif Ketua Penguji S2 (Lektor)'); INSERT INTO "public"."ms_honor_rates" VALUES (149, 1, 'MENGUJI', 'Guru Besar', 'S2', 'REGULER', NULL, 'Sekretaris Penguji', 450000.00, 'PER_MAHASISWA', 'Tarif Sekretaris Penguji S2 (Guru Besar)'); INSERT INTO "public"."ms_honor_rates" VALUES (150, 1, 'MENGUJI', 'Lektor Kepala', 'S2', 'REGULER', NULL, 'Sekretaris Penguji', 425000.00, 'PER_MAHASISWA', 'Tarif Sekretaris Penguji S2 (Lektor Kepala)'); INSERT INTO "public"."ms_honor_rates" VALUES (151, 1, 'MENGUJI', 'Guru Besar', 'S2', 'REGULER', NULL, 'Anggota Penguji', 450000.00, 'PER_MAHASISWA', 'Tarif Anggota Penguji S2 (Guru Besar)'); INSERT INTO "public"."ms_honor_rates" VALUES (152, 1, 'MENGUJI', 'Lektor Kepala', 'S2', 'REGULER', NULL, 'Anggota Penguji', 425000.00, 'PER_MAHASISWA', 'Tarif Anggota Penguji S2 (Lektor Kepala)'); INSERT INTO "public"."ms_honor_rates" VALUES (153, 1, 'MENGUJI', 'Lektor', 'S2', 'REGULER', NULL, 'Anggota Penguji', 400000.00, 'PER_MAHASISWA', 'Tarif Anggota Penguji S2 (Lektor)'); INSERT INTO "public"."ms_honor_rates" VALUES (154, 1, 'MEMBIMBING', 'Lektor Kepala', 'S1', 'REGULER', NULL, 'Pembimbing Utama', 750000.00, 'PER_MAHASISWA', 'Tarif Pembimbing Utama S1 (Lektor Kepala)'); INSERT INTO "public"."ms_honor_rates" VALUES (155, 1, 'MEMBIMBING', 'Lektor', 'S1', 'REGULER', NULL, 'Pembimbing Utama', 600000.00, 'PER_MAHASISWA', 'Tarif Pembimbing Utama S1 (Lektor)'); INSERT INTO "public"."ms_honor_rates" VALUES (156, 1, 'MEMBIMBING', 'Asisten Ahli', 'S1', 'REGULER', NULL, 'Pembimbing Utama', 500000.00, 'PER_MAHASISWA', 'Tarif Pembimbing Utama S1 (Asisten Ahli)'); INSERT INTO "public"."ms_honor_rates" VALUES (157, 1, 'MENGUJI', 'Lektor Kepala', 'S1', 'REGULER', NULL, 'Ketua Penguji', 150000.00, 'PER_MAHASISWA', 'Tarif Ketua Penguji S1 (Lektor Kepala)'); INSERT INTO "public"."ms_honor_rates" VALUES (158, 1, 'MENGUJI', 'Lektor', 'S1', 'REGULER', NULL, 'Ketua Penguji', 125000.00, 'PER_MAHASISWA', 'Tarif Ketua Penguji S1 (Lektor)'); INSERT INTO "public"."ms_honor_rates" VALUES (1, 1, 'MENGAJAR', 'Asisten Ahli', 'S1', 'REGULER', 'T', NULL, 35000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (T) - Asisten Ahli'); INSERT INTO "public"."ms_honor_rates" VALUES (2, 1, 'MENGAJAR', 'Lektor', 'S1', 'REGULER', 'T', NULL, 45000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (T) - Lektor'); INSERT INTO "public"."ms_honor_rates" VALUES (3, 1, 'MENGAJAR', 'Lektor Kepala', 'S1', 'REGULER', 'T', NULL, 55000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (T) - Lektor Kepala'); INSERT INTO "public"."ms_honor_rates" VALUES (4, 1, 'MENGAJAR', 'Guru Besar', 'S1', 'REGULER', 'T', NULL, 70000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (T) - Guru Besar'); INSERT INTO "public"."ms_honor_rates" VALUES (9, 1, 'MENGAJAR', 'Guru Besar', 'S1', 'REGULER', 'P', NULL, 80000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (P) - Guru Besar'); INSERT INTO "public"."ms_honor_rates" VALUES (10, 1, 'MENGAJAR', 'Lektor', 'S2', 'REGULER', 'T', NULL, 75000.00, 'PER_SKS_TM', 'Honor Mengajar S2 (T) - Lektor'); INSERT INTO "public"."ms_honor_rates" VALUES (11, 1, 'MENGAJAR', 'Lektor Kepala', 'S2', 'REGULER', 'T', NULL, 100000.00, 'PER_SKS_TM', 'Honor Mengajar S2 (T) - Lektor Kepala'); INSERT INTO "public"."ms_honor_rates" VALUES (12, 1, 'MENGAJAR', 'Guru Besar', 'S2', 'REGULER', 'T', NULL, 125000.00, 'PER_SKS_TM', 'Honor Mengajar S2 (T) - Guru Besar'); INSERT INTO "public"."ms_honor_rates" VALUES (13, 1, 'MENGAJAR', 'Guru Besar', 'S3', 'REGULER', 'T', NULL, 150000.00, 'PER_SKS_TM', 'Honor Mengajar S3 (T) - Guru Besar'); INSERT INTO "public"."ms_honor_rates" VALUES (159, 1, 'MENGUJI', 'Lektor Kepala', 'S1', 'REGULER', NULL, 'Anggota Penguji', 150000.00, 'PER_MAHASISWA', 'Tarif Anggota Penguji S1 (Lektor Kepala)'); INSERT INTO "public"."ms_honor_rates" VALUES (160, 1, 'MENGUJI', 'Lektor', 'S1', 'REGULER', NULL, 'Anggota Penguji', 125000.00, 'PER_MAHASISWA', 'Tarif Anggota Penguji S1 (Lektor)'); INSERT INTO "public"."ms_honor_rates" VALUES (161, 1, 'MEMBIMBING', 'SEMUA', 'S1', 'REGULER', NULL, 'Pembimbing KKN', 175000.00, 'PER_MAHASISWA', 'Tarif Pembimbing KKN S1 (SEMUA)'); INSERT INTO "public"."ms_honor_rates" VALUES (162, 1, 'MEMBIMBING', 'SEMUA', 'S1', 'REGULER', NULL, 'Pembimbing PK', 175000.00, 'PER_MAHASISWA', 'Tarif Pembimbing PK S1 (SEMUA)'); INSERT INTO "public"."ms_honor_rates" VALUES (26, 1, 'MENGAJAR', 'Tenaga Pengajar', 'S1', 'REGULER', 'P', NULL, 35000.00, 'PER_SKS_TM', 'Tarif Tambahan MENGAJAR S1 - Tenaga Pengajar'); INSERT INTO "public"."ms_honor_rates" VALUES (27, 1, 'MENGAJAR', 'Lektor', 'S2', 'REGULER', 'P', NULL, 85000.00, 'PER_SKS_TM', 'Tarif Tambahan MENGAJAR S2 - Lektor'); INSERT INTO "public"."ms_honor_rates" VALUES (28, 1, 'MENGAJAR', 'Guru Besar', 'S2', 'REGULER', 'P', NULL, 135000.00, 'PER_SKS_TM', 'Tarif Tambahan MENGAJAR S2 - Guru Besar'); INSERT INTO "public"."ms_honor_rates" VALUES (29, 1, 'MENGAJAR', 'Lektor Kepala', 'S2', 'REGULER', 'P', NULL, 110000.00, 'PER_SKS_TM', 'Tarif Tambahan MENGAJAR S2 - Lektor Kepala'); -- ---------------------------- -- Table structure for ms_labor_config -- ---------------------------- DROP TABLE IF EXISTS "public"."ms_labor_config"; CREATE TABLE "public"."ms_labor_config" ( "id" int8 NOT NULL DEFAULT nextval('ms_labor_config_id_seq'::regclass), "year_id" int8 NOT NULL, "base_rate_pns_per_jam" numeric(15,4) NOT NULL DEFAULT 0, "description" varchar(255) COLLATE "pg_catalog"."default", "created_at" timestamp(6), "updated_at" timestamp(6) ) ; -- ---------------------------- -- Records of ms_labor_config -- ---------------------------- -- ---------------------------- -- Table structure for ms_labor_rates -- ---------------------------- DROP TABLE IF EXISTS "public"."ms_labor_rates"; CREATE TABLE "public"."ms_labor_rates" ( "id" int8 NOT NULL DEFAULT nextval('ms_labor_rates_id_seq'::regclass), "year_id" int8 NOT NULL, "jenis_kegiatan" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "tarif_honor_per_jam_input" numeric(15,2) NOT NULL DEFAULT 0, "jumlah_staff_per_kelas_input" numeric(5,2) NOT NULL DEFAULT 1, "kapasitas_mhs_per_kelas_input" int4 NOT NULL DEFAULT 0, "rate_gaji_pns_per_jam" numeric(15,2) NOT NULL DEFAULT 0, "total_rate_per_jam_output" numeric(15,2) NOT NULL DEFAULT 0, "unit_cost_sdm_per_mhs_output" numeric(15,4) NOT NULL DEFAULT 0, "created_at" timestamp(6), "updated_at" timestamp(6), "study_program_id" int4 ) ; -- ---------------------------- -- Records of ms_labor_rates -- ---------------------------- -- ---------------------------- -- Table structure for ms_menus -- ---------------------------- DROP TABLE IF EXISTS "public"."ms_menus"; CREATE TABLE "public"."ms_menus" ( "id" int4 NOT NULL DEFAULT nextval('ms_menus_id_seq'::regclass), "parent_id" int4 DEFAULT 0, "title" varchar(100) COLLATE "pg_catalog"."default" NOT NULL, "url" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "icon" varchar(50) COLLATE "pg_catalog"."default" NOT NULL, "sequence" int4 NOT NULL DEFAULT 0, "is_active" bool NOT NULL DEFAULT true, "allowed_roles" text COLLATE "pg_catalog"."default" ) ; -- ---------------------------- -- Records of ms_menus -- ---------------------------- INSERT INTO "public"."ms_menus" VALUES (1, 0, 'Dashboard', 'dashboard', 'fas fa-tachometer-alt', 1, 't', NULL); INSERT INTO "public"."ms_menus" VALUES (2, 0, 'Data Master', '#', 'fas fa-database', 2, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (3, 2, 'Tahun Anggaran', 'master/tahun', 'far fa-calendar-alt', 1, 't', 'superuser,admin_univ'); INSERT INTO "public"."ms_menus" VALUES (4, 2, 'Fakultas', 'master/fakultas', 'far fa-building', 2, 't', 'superuser,admin_univ,admin_fakultas'); INSERT INTO "public"."ms_menus" VALUES (5, 2, 'Departemen', 'master/departemen', 'far fa-building', 3, 't', 'superuser,admin_univ,admin_dept'); INSERT INTO "public"."ms_menus" VALUES (6, 2, 'Program Studi', 'master/prodi', 'fas fa-graduation-cap', 4, 't', 'superuser,admin_univ,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (7, 2, 'Kurikulum / MK', 'master/kurikulum', 'fas fa-book', 5, 't', 'superuser,admin_univ,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (9, 2, 'Kategori Biaya', 'master/biaya', 'fas fa-tags', 7, 't', 'superuser,admin_univ'); INSERT INTO "public"."ms_menus" VALUES (10, 2, 'Driver / Pemicu', 'master/driver', 'fas fa-sort-amount-up', 8, 't', 'superuser,admin_univ'); INSERT INTO "public"."ms_menus" VALUES (11, 2, 'Konfigurasi SSBOPT', 'master/config-ssbopt', 'fas fa-cogs', 9, 't', 'superuser,admin_univ'); INSERT INTO "public"."ms_menus" VALUES (12, 2, 'Standar Tarif Honor', 'master/labor-rate', 'fas fa-money-bill-wave', 10, 't', 'superuser,admin_univ'); INSERT INTO "public"."ms_menus" VALUES (13, 0, 'Transaksi', '#', 'fas fa-exchange-alt', 3, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (21, 0, 'Laporan', '#', 'fas fa-file-alt', 4, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (22, 21, 'Laporan Unit Cost', 'laporan/unit-cost', 'fas fa-file-contract', 1, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (26, 23, 'Audit Database', 'system/database', 'fas fa-server', 3, 't', 'superuser'); INSERT INTO "public"."ms_menus" VALUES (15, 13, 'Input Sumber Daya', 'transaksi/resources', 'fas fa-file-invoice-dollar', 4, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (28, 13, 'Target Pendapatan', 'transaksi/revenue', 'fas fa-bullseye', 6, 't', 'superuser,admin_univ,admin_fakultas,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (30, 21, 'Rekap Kategori Biaya', 'laporan/rekap-kategori', 'fas fa-chart-pie', 3, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (29, 21, 'Analisis Gap (SPK)', 'laporan/gap-analysis', 'fas fa-chart-area', 2, 't', 'superuser,admin_univ,admin_fakultas,admin_departemen,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (24, 23, 'Manajemen User', 'system/users', 'fas fa-users', 1, 't', 'superuser,admin_univ'); INSERT INTO "public"."ms_menus" VALUES (25, 23, 'Manajemen Menu', 'system/menu', 'fas fa-list', 2, 't', 'superuser,admin_univ'); INSERT INTO "public"."ms_menus" VALUES (23, 0, 'System Admin', '#', 'fas fa-user-shield', 99, 't', 'superuser,admin_univ'); INSERT INTO "public"."ms_menus" VALUES (14, 13, 'Jadwal Kuliah', 'akademik/jadwal', 'fas fa-calendar-alt', 2, 't', 'superuser,admin_univ,admin_fakultas,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (17, 13, 'Kalkulasi Honor Mengajar', 'transaksi/teaching-cost', 'fas fa-calculator', 3, 't', 'superuser,admin_univ,admin_fakultas,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (16, 13, 'Kuantitas Pemicu Biaya (Cost Driver Volume)', 'transaksi/driver-values', 'fas fa-chart-bar', 1, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (27, 13, 'Proses Alokasi Biaya', 'transaksi/alokasi', 'fas fa-network-wired', 7, 'f', 'superuser,admin_univ'); INSERT INTO "public"."ms_menus" VALUES (31, 13, 'Rekap Rincian Kategori', 'transaksi/rinciankategori', 'fas fa-file-invoice-dollar', 5, 'f', 'superuser,admin_univ,admin_fakultas,admin_prodi'); -- ---------------------------- -- Table structure for ms_prodi_revenue_config -- ---------------------------- DROP TABLE IF EXISTS "public"."ms_prodi_revenue_config"; CREATE TABLE "public"."ms_prodi_revenue_config" ( "id" int4 NOT NULL DEFAULT nextval('ms_prodi_revenue_config_id_seq'::regclass), "year_id" int4 NOT NULL, "study_program_id" int4 NOT NULL, "ukt_standar" numeric(15,2) NOT NULL DEFAULT 0, "target_mhs_baru" int4 NOT NULL DEFAULT 0, "target_mhs_aktif" int4 NOT NULL DEFAULT 0, "realisasi_struktur" jsonb, "description" text COLLATE "pg_catalog"."default", "created_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP, "updated_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP ) ; -- ---------------------------- -- Records of ms_prodi_revenue_config -- ---------------------------- INSERT INTO "public"."ms_prodi_revenue_config" VALUES (2, 1, 5, 8500000.00, 20, 0, '[{"qty": 10, "diskon_persen": 50}]', NULL, '2026-01-06 01:25:25', '2026-01-06 01:25:25'); INSERT INTO "public"."ms_prodi_revenue_config" VALUES (3, 1, 6, 10500000.00, 10, 0, '[{"qty": 4, "diskon_persen": 50}]', NULL, '2026-01-06 01:25:46', '2026-01-06 01:25:46'); INSERT INTO "public"."ms_prodi_revenue_config" VALUES (1, 1, 4, 50000000.00, 30, 0, '[{"qty": 100, "diskon_persen": 0}]', NULL, '2026-01-06 01:24:57', '2026-01-06 02:32:41'); -- ---------------------------- -- Table structure for ms_ssbopt_config -- ---------------------------- DROP TABLE IF EXISTS "public"."ms_ssbopt_config"; CREATE TABLE "public"."ms_ssbopt_config" ( "id" int4 NOT NULL DEFAULT nextval('ms_ssbopt_config_id_seq'::regclass), "year_id" int4, "nilai_akreditasi_pt" numeric(4,2) NOT NULL DEFAULT 1, "kikbopt" numeric(5,3) NOT NULL DEFAULT 1, "keterangan" text COLLATE "pg_catalog"."default", "is_active" bool NOT NULL DEFAULT true, "base_cost" numeric(10,2) ) ; -- ---------------------------- -- Records of ms_ssbopt_config -- ---------------------------- INSERT INTO "public"."ms_ssbopt_config" VALUES (1, 2, 0.10, 1.000, '', 't', NULL); INSERT INTO "public"."ms_ssbopt_config" VALUES (2, 1, 0.10, 1.000, '', 't', 2000000.00); -- ---------------------------- -- Table structure for ms_study_programs -- ---------------------------- DROP TABLE IF EXISTS "public"."ms_study_programs"; CREATE TABLE "public"."ms_study_programs" ( "id" int8 NOT NULL DEFAULT nextval('ms_study_programs_id_seq'::regclass), "study_program_code" varchar(20) COLLATE "pg_catalog"."default", "study_program_name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "department_id" int8, "created_at" timestamp(6), "updated_at" timestamp(6), "deleted_at" timestamp(6), "ssbopt_cluster_id" int4, "nilai_akreditasi_prodi" numeric(4,2) DEFAULT 0, "status_akreditasi" varchar(50) COLLATE "pg_catalog"."default", "is_international" bool DEFAULT false, "jenjang" varchar(255) COLLATE "pg_catalog"."default" ) ; -- ---------------------------- -- Records of ms_study_programs -- ---------------------------- INSERT INTO "public"."ms_study_programs" VALUES (5, 'PJSD-S2', 'S2 Pendidikan Jasmani Sekolah Dasar', 1, NULL, NULL, NULL, NULL, 0.00, 'Unggul', 'f', 'S2'); INSERT INTO "public"."ms_study_programs" VALUES (6, 'PJSD-S3', 'S3 Pendidikan Jasmani Sekolah Dasar', 1, NULL, NULL, NULL, NULL, 0.00, 'Unggul', 'f', 'S3'); INSERT INTO "public"."ms_study_programs" VALUES (4, 'PJSD-S1', 'S1 Pendidikan Jasmani Sekolah Dasar', 1, NULL, '2026-01-09 05:38:17', NULL, 2, 0.03, 'Unggul', 'f', 'S1'); -- ---------------------------- -- Table structure for ms_unit_config -- ---------------------------- DROP TABLE IF EXISTS "public"."ms_unit_config"; CREATE TABLE "public"."ms_unit_config" ( "id" int8 NOT NULL DEFAULT nextval('ms_unit_config_id_seq'::regclass), "year_id" int8 NOT NULL, "config_key" varchar(100) COLLATE "pg_catalog"."default" NOT NULL, "config_value" numeric(20,8) NOT NULL, "description" text COLLATE "pg_catalog"."default" ) ; -- ---------------------------- -- Records of ms_unit_config -- ---------------------------- -- ---------------------------- -- Table structure for ms_user_levels -- ---------------------------- DROP TABLE IF EXISTS "public"."ms_user_levels"; CREATE TABLE "public"."ms_user_levels" ( "id" int8 NOT NULL DEFAULT nextval('ms_user_levels_id_seq'::regclass), "level_code" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "level_name" varchar(100) COLLATE "pg_catalog"."default" NOT NULL, "hierarchy_order" int4 NOT NULL DEFAULT 0 ) ; -- ---------------------------- -- Records of ms_user_levels -- ---------------------------- INSERT INTO "public"."ms_user_levels" VALUES (1, 'UNIV', 'Universitas', 1); INSERT INTO "public"."ms_user_levels" VALUES (2, 'FACULTY', 'Fakultas', 2); INSERT INTO "public"."ms_user_levels" VALUES (3, 'DEPT', 'Departemen', 3); INSERT INTO "public"."ms_user_levels" VALUES (4, 'PRODI', 'Program Studi', 4); INSERT INTO "public"."ms_user_levels" VALUES (5, 'ALL', 'Semua Level', 0); -- ---------------------------- -- Table structure for ref_ssbopt_clusters -- ---------------------------- DROP TABLE IF EXISTS "public"."ref_ssbopt_clusters"; CREATE TABLE "public"."ref_ssbopt_clusters" ( "id" int4 NOT NULL DEFAULT nextval('ref_ssbopt_clusters_id_seq'::regclass), "kode_kelompok" varchar(5) COLLATE "pg_catalog"."default" NOT NULL, "kategori_prodi" varchar(50) COLLATE "pg_catalog"."default", "deskripsi" text COLLATE "pg_catalog"."default", "bobot_dasar" numeric(5,2) NOT NULL DEFAULT 1 ) ; -- ---------------------------- -- Records of ref_ssbopt_clusters -- ---------------------------- INSERT INTO "public"."ref_ssbopt_clusters" VALUES (1, 'A', 'FPK', 'Fokus Pengembangan Keilmuan (Ruang Kelas/Studio)', 1.00); INSERT INTO "public"."ref_ssbopt_clusters" VALUES (2, 'B', 'KSK', 'Keterampilan Sebagai Komplemen (Kelas, Lab)', 1.00); INSERT INTO "public"."ref_ssbopt_clusters" VALUES (3, 'C', 'PPI', 'Pengalaman Praktik Intensif (Lab, Bengkel)', 1.00); INSERT INTO "public"."ref_ssbopt_clusters" VALUES (4, 'D', 'PPI-Khusus', 'Kompleksitas Tinggi (Kesehatan/Kedokteran)', 1.00); -- ---------------------------- -- Table structure for ref_ssbopt_components -- ---------------------------- DROP TABLE IF EXISTS "public"."ref_ssbopt_components"; CREATE TABLE "public"."ref_ssbopt_components" ( "id" int4 NOT NULL DEFAULT nextval('ref_ssbopt_components_id_seq'::regclass), "kode_komponen" varchar(10) COLLATE "pg_catalog"."default" NOT NULL, "nama_komponen" varchar(100) COLLATE "pg_catalog"."default" NOT NULL, "jenis_biaya" varchar(10) COLLATE "pg_catalog"."default" NOT NULL, "deskripsi" text COLLATE "pg_catalog"."default" ) ; -- ---------------------------- -- Records of ref_ssbopt_components -- ---------------------------- INSERT INTO "public"."ref_ssbopt_components" VALUES (1, 'BL-1', 'Kegiatan Kelas', 'BL', 'Kuliah tatap muka, UTS, UAS'); INSERT INTO "public"."ref_ssbopt_components" VALUES (2, 'BL-2', 'Kegiatan Lab/Praktek', 'BL', 'Praktikum, Bengkel, Kuliah Lapangan'); INSERT INTO "public"."ref_ssbopt_components" VALUES (3, 'BL-3', 'Kegiatan Mandiri/TA', 'BL', 'Skripsi, Wisuda, Seminar'); INSERT INTO "public"."ref_ssbopt_components" VALUES (4, 'BL-4', 'Kemahasiswaan', 'BL', 'Bimbingan Akademik, Konseling'); INSERT INTO "public"."ref_ssbopt_components" VALUES (5, 'BTL-1', 'Administrasi Umum', 'BTL', 'Gaji Tendik, Pejabat Struktural'); INSERT INTO "public"."ref_ssbopt_components" VALUES (6, 'BTL-2', 'Operasional & Pemeliharaan', 'BTL', 'Listrik, Air, Internet'); INSERT INTO "public"."ref_ssbopt_components" VALUES (7, 'BTL-3', 'Pengembangan Institusi', 'BTL', 'Renstra, Akreditasi'); INSERT INTO "public"."ref_ssbopt_components" VALUES (8, 'BTL-4', 'Operasional Lainnya', 'BTL', 'Pelatihan SDM'); -- ---------------------------- -- Table structure for report_unit_costs -- ---------------------------- DROP TABLE IF EXISTS "public"."report_unit_costs"; CREATE TABLE "public"."report_unit_costs" ( "id" int4 NOT NULL DEFAULT nextval('report_unit_costs_id_seq'::regclass), "year_id" int4 NOT NULL, "faculty_id" int4, "study_program_id" int4 NOT NULL, "total_cost" numeric(20,2) DEFAULT 0, "student_count" int4 DEFAULT 0, "unit_cost" numeric(20,2) DEFAULT 0, "created_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP ) ; -- ---------------------------- -- Records of report_unit_costs -- ---------------------------- INSERT INTO "public"."report_unit_costs" VALUES (7, 1, 1, 4, 695060000.00, 90, 7722888.89, '2026-04-24 09:15:11'); INSERT INTO "public"."report_unit_costs" VALUES (8, 1, 1, 5, 468445000.00, 40, 11711125.00, '2026-04-24 09:15:11'); INSERT INTO "public"."report_unit_costs" VALUES (9, 1, 1, 6, 1703020000.00, 30, 56767333.33, '2026-04-24 09:15:11'); -- ---------------------------- -- Table structure for rpt_unit_costs -- ---------------------------- DROP TABLE IF EXISTS "public"."rpt_unit_costs"; CREATE TABLE "public"."rpt_unit_costs" ( "id" int8 NOT NULL DEFAULT nextval('rpt_unit_costs_id_seq'::regclass), "year_id" int4 NOT NULL, "study_program_id" int4 NOT NULL, "total_cost" numeric(20,2) NOT NULL DEFAULT 0, "total_students" int4 NOT NULL DEFAULT 0, "unit_cost" numeric(20,2) NOT NULL DEFAULT 0, "calculated_at" timestamp(6) ) ; -- ---------------------------- -- Records of rpt_unit_costs -- ---------------------------- -- ---------------------------- -- Table structure for service_groups -- ---------------------------- DROP TABLE IF EXISTS "public"."service_groups"; CREATE TABLE "public"."service_groups" ( "id" int8 NOT NULL DEFAULT nextval('service_groups_id_seq'::regclass), "nama_layanan" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "kategori" varchar(100) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'Akademik'::character varying, "created_at" timestamp(6), "updated_at" timestamp(6) ) ; -- ---------------------------- -- Records of service_groups -- ---------------------------- -- ---------------------------- -- Table structure for trans_driver_values -- ---------------------------- DROP TABLE IF EXISTS "public"."trans_driver_values"; CREATE TABLE "public"."trans_driver_values" ( "id" int8 NOT NULL DEFAULT nextval('trans_driver_values_id_seq'::regclass), "year_id" int4 NOT NULL, "driver_id" int4 NOT NULL, "study_program_id" int4, "value_amount" numeric(18,2) NOT NULL DEFAULT 0, "description" text COLLATE "pg_catalog"."default", "created_at" timestamp(6), "updated_at" timestamp(6), "faculty_code" varchar(20) COLLATE "pg_catalog"."default", "department_id" int4 ) ; -- ---------------------------- -- Records of trans_driver_values -- ---------------------------- INSERT INTO "public"."trans_driver_values" VALUES (13, 1, 16, NULL, 35000.00, 'Total Mahasiswa Aktif UNY 2024 (S1, S2, S3, D4)', '2026-05-02 19:52:36.790897', NULL, NULL, NULL); INSERT INTO "public"."trans_driver_values" VALUES (14, 1, 7, NULL, 250000.00, 'Luas Gedung Total Kampus UNY (m2)', '2026-05-02 19:52:36.790897', NULL, NULL, NULL); INSERT INTO "public"."trans_driver_values" VALUES (15, 1, 8, NULL, 1500.00, 'Total Dosen Tetap PNS/PTNBH UNY', '2026-05-02 19:52:36.790897', NULL, NULL, NULL); INSERT INTO "public"."trans_driver_values" VALUES (16, 1, 15, NULL, 1200.00, 'Total Tenaga Kependidikan/Admin UNY', '2026-05-02 19:52:36.790897', NULL, NULL, NULL); INSERT INTO "public"."trans_driver_values" VALUES (17, 1, 18, NULL, 15000000000.00, 'Total Pagu Anggaran FIKK (Rp 15 Miliar)', '2026-05-02 19:58:22.375129', NULL, 'FIKK', NULL); -- ---------------------------- -- Table structure for trans_resources -- ---------------------------- DROP TABLE IF EXISTS "public"."trans_resources"; CREATE TABLE "public"."trans_resources" ( "id" int8 NOT NULL DEFAULT nextval('trans_resources_id_seq'::regclass), "year_id" int4 NOT NULL, "cost_category_id" int4 NOT NULL, "amount" numeric(18,2) NOT NULL DEFAULT 0, "level_scope" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "faculty_id" int4, "department_id" int4, "study_program_id" int4, "description" text COLLATE "pg_catalog"."default", "created_by" int4, "created_at" timestamp(6), "updated_at" timestamp(6), "details" jsonb, "resource_name" varchar(255) COLLATE "pg_catalog"."default", "default_driver_id" int4, "Name Type Object Type Object Type Schema Key Length Decimals Di" float8, "driver_id" int4 ) ; -- ---------------------------- -- Records of trans_resources -- ---------------------------- -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS "public"."users"; CREATE TABLE "public"."users" ( "id" int4 NOT NULL DEFAULT nextval('users_id_seq'::regclass), "username" varchar(100) COLLATE "pg_catalog"."default" NOT NULL, "password_hash" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "full_name" varchar(100) COLLATE "pg_catalog"."default" NOT NULL, "email" varchar(100) COLLATE "pg_catalog"."default" NOT NULL, "role" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "scope_ref_id" int4 NOT NULL DEFAULT 0, "created_at" timestamp(6), "updated_at" timestamp(6), "faculty_id" int4, "department_id" int4, "study_program_id" int4, "user_level_id" int8, "is_active" bool DEFAULT true, "fullname" varchar(150) COLLATE "pg_catalog"."default" ) ; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO "public"."users" VALUES (7, 'superuser', '$2y$10$Av6DnyfzGkw1.GBEmt6JjelxruY5VQkoA.Jn4UJFJpOwn.pDiqs4.', 'Super Administrator', 'superuser@spp.ac.id', 'superuser', 0, NULL, NULL, NULL, NULL, NULL, NULL, 't', NULL); INSERT INTO "public"."users" VALUES (8, 'admin_fikk', '$2y$10$Av6DnyfzGkw1.GBEmt6JjelxruY5VQkoA.Jn4UJFJpOwn.pDiqs4.', 'Admin Fakultas FIKK', 'admin_fikk@spp.ac.id', 'admin_fakultas', 0, NULL, NULL, 1, NULL, NULL, NULL, 't', NULL); INSERT INTO "public"."users" VALUES (16, 'admin_pjsd_s1', '$2y$10$Av6DnyfzGkw1.GBEmt6JjelxruY5VQkoA.Jn4UJFJpOwn.pDiqs4.', 'Admin Prodi PJSD S1', 'admin_pjsd_s1@uny.ac.id', 'admin_prodi', 0, '2025-12-27 02:14:43', NULL, 1, 2, 4, NULL, 't', NULL); INSERT INTO "public"."users" VALUES (17, 'admin_pjsd_s2', '$2y$10$Av6DnyfzGkw1.GBEmt6JjelxruY5VQkoA.Jn4UJFJpOwn.pDiqs4.', 'Admin Prodi PJSD S2', 'admin_pjsd_s2@uny.ac.id', 'admin_prodi', 0, '2025-12-27 02:14:43', NULL, 1, 2, 5, NULL, 't', NULL); INSERT INTO "public"."users" VALUES (18, 'admin_pjsd_s3', '$2y$10$Av6DnyfzGkw1.GBEmt6JjelxruY5VQkoA.Jn4UJFJpOwn.pDiqs4.', 'Admin Prodi PJSD S3', 'admin_pjsd_s3@uny.ac.id', 'admin_prodi', 0, '2025-12-27 02:14:43', NULL, 1, 2, 6, NULL, 't', NULL); INSERT INTO "public"."users" VALUES (4, 'admin_dept_pjsd', '$2y$10$Av6DnyfzGkw1.GBEmt6JjelxruY5VQkoA.Jn4UJFJpOwn.pDiqs4.', 'Admin Dept PJSD', 'if@univ.ac.id', 'admin_dept', 1, NULL, NULL, NULL, 2, NULL, NULL, 't', NULL); INSERT INTO "public"."users" VALUES (2, 'admin_univ', '$2y$10$Av6DnyfzGkw1.GBEmt6JjelxruY5VQkoA.Jn4UJFJpOwn.pDiqs4.', 'Admin Universitas', 'univ@univ.ac.id', 'admin_univ', 0, NULL, NULL, NULL, NULL, NULL, NULL, 't', NULL); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."abc_activities_id_seq" OWNED BY "public"."abc_activities"."id"; SELECT setval('"public"."abc_activities_id_seq"', 3, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."abc_activity_allocations_id_seq" OWNED BY "public"."abc_activity_allocations"."id"; SELECT setval('"public"."abc_activity_allocations_id_seq"', 1, false); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."abc_cost_categories_id_seq" OWNED BY "public"."abc_cost_categories"."id"; SELECT setval('"public"."abc_cost_categories_id_seq"', 38, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."abc_cost_types_id_seq" OWNED BY "public"."abc_cost_types"."id"; SELECT setval('"public"."abc_cost_types_id_seq"', 2, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- SELECT setval('"public"."abc_drivers_id_seq"', 20, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."abc_resource_assignments_id_seq" OWNED BY "public"."abc_resource_assignments"."id"; SELECT setval('"public"."abc_resource_assignments_id_seq"', 1, false); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."activity_components_id_seq" OWNED BY "public"."activity_components"."id"; SELECT setval('"public"."activity_components_id_seq"', 1, false); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."akademik_jadwal_kuliah_id_seq" OWNED BY "public"."akademik_jadwal_kuliah"."id"; SELECT setval('"public"."akademik_jadwal_kuliah_id_seq"', 5679, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."akademik_matakuliah_id_seq" OWNED BY "public"."akademik_matakuliah"."id"; SELECT setval('"public"."akademik_matakuliah_id_seq"', 188, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."indirect_budgets_id_seq" OWNED BY "public"."indirect_budgets"."id"; SELECT setval('"public"."indirect_budgets_id_seq"', 1, false); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."migrations_id_seq" OWNED BY "public"."migrations"."id"; SELECT setval('"public"."migrations_id_seq"', 65, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ms_academic_years_id_seq" OWNED BY "public"."ms_academic_years"."id"; SELECT setval('"public"."ms_academic_years_id_seq"', 2, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ms_departments_id_seq" OWNED BY "public"."ms_departments"."id"; SELECT setval('"public"."ms_departments_id_seq"', 2, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ms_faculties_id_seq" OWNED BY "public"."ms_faculties"."id"; SELECT setval('"public"."ms_faculties_id_seq"', 2, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ms_honor_rates_id_seq" OWNED BY "public"."ms_honor_rates"."id"; SELECT setval('"public"."ms_honor_rates_id_seq"', 162, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ms_labor_config_id_seq" OWNED BY "public"."ms_labor_config"."id"; SELECT setval('"public"."ms_labor_config_id_seq"', 1, false); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ms_labor_rates_id_seq" OWNED BY "public"."ms_labor_rates"."id"; SELECT setval('"public"."ms_labor_rates_id_seq"', 1, false); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ms_menus_id_seq" OWNED BY "public"."ms_menus"."id"; SELECT setval('"public"."ms_menus_id_seq"', 30, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ms_prodi_revenue_config_id_seq" OWNED BY "public"."ms_prodi_revenue_config"."id"; SELECT setval('"public"."ms_prodi_revenue_config_id_seq"', 3, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ms_ssbopt_config_id_seq" OWNED BY "public"."ms_ssbopt_config"."id"; SELECT setval('"public"."ms_ssbopt_config_id_seq"', 2, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ms_study_programs_id_seq" OWNED BY "public"."ms_study_programs"."id"; SELECT setval('"public"."ms_study_programs_id_seq"', 6, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ms_unit_config_id_seq" OWNED BY "public"."ms_unit_config"."id"; SELECT setval('"public"."ms_unit_config_id_seq"', 1, false); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ms_user_levels_id_seq" OWNED BY "public"."ms_user_levels"."id"; SELECT setval('"public"."ms_user_levels_id_seq"', 5, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ref_ssbopt_clusters_id_seq" OWNED BY "public"."ref_ssbopt_clusters"."id"; SELECT setval('"public"."ref_ssbopt_clusters_id_seq"', 4, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."ref_ssbopt_components_id_seq" OWNED BY "public"."ref_ssbopt_components"."id"; SELECT setval('"public"."ref_ssbopt_components_id_seq"', 8, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."report_unit_costs_id_seq" OWNED BY "public"."report_unit_costs"."id"; SELECT setval('"public"."report_unit_costs_id_seq"', 9, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."rpt_unit_costs_id_seq" OWNED BY "public"."rpt_unit_costs"."id"; SELECT setval('"public"."rpt_unit_costs_id_seq"', 1, false); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."service_groups_id_seq" OWNED BY "public"."service_groups"."id"; SELECT setval('"public"."service_groups_id_seq"', 1, false); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."trans_driver_values_id_seq" OWNED BY "public"."trans_driver_values"."id"; SELECT setval('"public"."trans_driver_values_id_seq"', 17, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."trans_resources_id_seq" OWNED BY "public"."trans_resources"."id"; SELECT setval('"public"."trans_resources_id_seq"', 8552, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."users_id_seq" OWNED BY "public"."users"."id"; SELECT setval('"public"."users_id_seq"', 18, true); -- ---------------------------- -- Primary Key structure for table abc_activities -- ---------------------------- ALTER TABLE "public"."abc_activities" ADD CONSTRAINT "pk_abc_activities" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table abc_activity_allocations -- ---------------------------- ALTER TABLE "public"."abc_activity_allocations" ADD CONSTRAINT "pk_abc_activity_allocations" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table abc_cost_categories -- ---------------------------- ALTER TABLE "public"."abc_cost_categories" ADD CONSTRAINT "pk_abc_cost_categories" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table abc_cost_types -- ---------------------------- ALTER TABLE "public"."abc_cost_types" ADD CONSTRAINT "pk_abc_cost_types" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table abc_drivers -- ---------------------------- ALTER TABLE "public"."abc_drivers" ADD CONSTRAINT "abc_drivers_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table abc_resource_assignments -- ---------------------------- ALTER TABLE "public"."abc_resource_assignments" ADD CONSTRAINT "pk_abc_resource_assignments" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table activity_components -- ---------------------------- ALTER TABLE "public"."activity_components" ADD CONSTRAINT "pk_activity_components" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table akademik_jadwal_kuliah -- ---------------------------- ALTER TABLE "public"."akademik_jadwal_kuliah" ADD CONSTRAINT "pk_akademik_jadwal_kuliah" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table akademik_matakuliah -- ---------------------------- ALTER TABLE "public"."akademik_matakuliah" ADD CONSTRAINT "pk_akademik_matakuliah" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table indirect_budgets -- ---------------------------- ALTER TABLE "public"."indirect_budgets" ADD CONSTRAINT "pk_indirect_budgets" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table migrations -- ---------------------------- ALTER TABLE "public"."migrations" ADD CONSTRAINT "pk_migrations" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ms_academic_years -- ---------------------------- ALTER TABLE "public"."ms_academic_years" ADD CONSTRAINT "pk_ms_academic_years" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ms_departments -- ---------------------------- ALTER TABLE "public"."ms_departments" ADD CONSTRAINT "pk_ms_departments" PRIMARY KEY ("id"); -- ---------------------------- -- Uniques structure for table ms_faculties -- ---------------------------- ALTER TABLE "public"."ms_faculties" ADD CONSTRAINT "unique_faculty_code" UNIQUE ("faculty_code"); -- ---------------------------- -- Primary Key structure for table ms_faculties -- ---------------------------- ALTER TABLE "public"."ms_faculties" ADD CONSTRAINT "pk_ms_faculties" PRIMARY KEY ("id"); -- ---------------------------- -- Indexes structure for table ms_honor_rates -- ---------------------------- CREATE INDEX "ms_honor_rates_year_id_kategori_kegiatan_jabatan_fungsional_jen" ON "public"."ms_honor_rates" USING btree ( "year_id" "pg_catalog"."int8_ops" ASC NULLS LAST, "kategori_kegiatan" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST, "jabatan_fungsional" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST, "jenjang_prodi" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST ); -- ---------------------------- -- Primary Key structure for table ms_honor_rates -- ---------------------------- ALTER TABLE "public"."ms_honor_rates" ADD CONSTRAINT "pk_ms_honor_rates" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ms_labor_config -- ---------------------------- ALTER TABLE "public"."ms_labor_config" ADD CONSTRAINT "pk_ms_labor_config" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ms_labor_rates -- ---------------------------- ALTER TABLE "public"."ms_labor_rates" ADD CONSTRAINT "pk_ms_labor_rates" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ms_menus -- ---------------------------- ALTER TABLE "public"."ms_menus" ADD CONSTRAINT "pk_ms_menus" PRIMARY KEY ("id"); -- ---------------------------- -- Indexes structure for table ms_prodi_revenue_config -- ---------------------------- CREATE INDEX "idx_revenue_year_prodi" ON "public"."ms_prodi_revenue_config" USING btree ( "year_id" "pg_catalog"."int4_ops" ASC NULLS LAST, "study_program_id" "pg_catalog"."int4_ops" ASC NULLS LAST ); -- ---------------------------- -- Uniques structure for table ms_prodi_revenue_config -- ---------------------------- ALTER TABLE "public"."ms_prodi_revenue_config" ADD CONSTRAINT "uq_revenue_prodi_year" UNIQUE ("year_id", "study_program_id"); -- ---------------------------- -- Primary Key structure for table ms_prodi_revenue_config -- ---------------------------- ALTER TABLE "public"."ms_prodi_revenue_config" ADD CONSTRAINT "ms_prodi_revenue_config_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ms_ssbopt_config -- ---------------------------- ALTER TABLE "public"."ms_ssbopt_config" ADD CONSTRAINT "pk_ms_ssbopt_config" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ms_study_programs -- ---------------------------- ALTER TABLE "public"."ms_study_programs" ADD CONSTRAINT "pk_ms_study_programs" PRIMARY KEY ("id"); -- ---------------------------- -- Uniques structure for table ms_unit_config -- ---------------------------- ALTER TABLE "public"."ms_unit_config" ADD CONSTRAINT "ms_unit_config_year_id_config_key" UNIQUE ("year_id", "config_key"); -- ---------------------------- -- Primary Key structure for table ms_unit_config -- ---------------------------- ALTER TABLE "public"."ms_unit_config" ADD CONSTRAINT "pk_ms_unit_config" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ms_user_levels -- ---------------------------- ALTER TABLE "public"."ms_user_levels" ADD CONSTRAINT "pk_ms_user_levels" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ref_ssbopt_clusters -- ---------------------------- ALTER TABLE "public"."ref_ssbopt_clusters" ADD CONSTRAINT "pk_ref_ssbopt_clusters" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ref_ssbopt_components -- ---------------------------- ALTER TABLE "public"."ref_ssbopt_components" ADD CONSTRAINT "pk_ref_ssbopt_components" PRIMARY KEY ("id"); -- ---------------------------- -- Indexes structure for table report_unit_costs -- ---------------------------- CREATE INDEX "idx_report_prodi" ON "public"."report_unit_costs" USING btree ( "study_program_id" "pg_catalog"."int4_ops" ASC NULLS LAST ); CREATE INDEX "idx_report_year" ON "public"."report_unit_costs" USING btree ( "year_id" "pg_catalog"."int4_ops" ASC NULLS LAST ); -- ---------------------------- -- Primary Key structure for table report_unit_costs -- ---------------------------- ALTER TABLE "public"."report_unit_costs" ADD CONSTRAINT "report_unit_costs_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table rpt_unit_costs -- ---------------------------- ALTER TABLE "public"."rpt_unit_costs" ADD CONSTRAINT "pk_rpt_unit_costs" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table service_groups -- ---------------------------- ALTER TABLE "public"."service_groups" ADD CONSTRAINT "pk_service_groups" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table trans_driver_values -- ---------------------------- ALTER TABLE "public"."trans_driver_values" ADD CONSTRAINT "pk_trans_driver_values" PRIMARY KEY ("id"); -- ---------------------------- -- Indexes structure for table trans_resources -- ---------------------------- CREATE INDEX "idx_trans_resources_scope" ON "public"."trans_resources" USING btree ( "level_scope" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST ); -- ---------------------------- -- Primary Key structure for table trans_resources -- ---------------------------- ALTER TABLE "public"."trans_resources" ADD CONSTRAINT "pk_trans_resources" PRIMARY KEY ("id"); -- ---------------------------- -- Uniques structure for table users -- ---------------------------- ALTER TABLE "public"."users" ADD CONSTRAINT "users_username" UNIQUE ("username"); ALTER TABLE "public"."users" ADD CONSTRAINT "users_email" UNIQUE ("email"); -- ---------------------------- -- Primary Key structure for table users -- ---------------------------- ALTER TABLE "public"."users" ADD CONSTRAINT "pk_users" PRIMARY KEY ("id"); -- ---------------------------- -- Foreign Keys structure for table abc_activities -- ---------------------------- ALTER TABLE "public"."abc_activities" ADD CONSTRAINT "fk_activity_ssbopt_comp" FOREIGN KEY ("ssbopt_component_id") REFERENCES "public"."ref_ssbopt_components" ("id") ON DELETE SET NULL ON UPDATE NO ACTION; -- ---------------------------- -- Foreign Keys structure for table abc_activity_allocations -- ---------------------------- ALTER TABLE "public"."abc_activity_allocations" ADD CONSTRAINT "abc_activity_allocations_activity_id_foreign" FOREIGN KEY ("activity_id") REFERENCES "public"."abc_activities" ("id") ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE "public"."abc_activity_allocations" ADD CONSTRAINT "abc_activity_allocations_study_program_id_foreign" FOREIGN KEY ("study_program_id") REFERENCES "public"."ms_study_programs" ("id") ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE "public"."abc_activity_allocations" ADD CONSTRAINT "abc_activity_allocations_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table abc_cost_categories -- ---------------------------- ALTER TABLE "public"."abc_cost_categories" ADD CONSTRAINT "fk_cost_type" FOREIGN KEY ("cost_type_id") REFERENCES "public"."abc_cost_types" ("id") ON DELETE SET NULL ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table abc_resource_assignments -- ---------------------------- ALTER TABLE "public"."abc_resource_assignments" ADD CONSTRAINT "abc_resource_assignments_activity_id_foreign" FOREIGN KEY ("activity_id") REFERENCES "public"."abc_activities" ("id") ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE "public"."abc_resource_assignments" ADD CONSTRAINT "abc_resource_assignments_resource_id_foreign" FOREIGN KEY ("resource_id") REFERENCES "public"."trans_resources" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table activity_components -- ---------------------------- ALTER TABLE "public"."activity_components" ADD CONSTRAINT "fk_activity_service_group_v2" FOREIGN KEY ("service_group_id") REFERENCES "public"."service_groups" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table akademik_jadwal_kuliah -- ---------------------------- ALTER TABLE "public"."akademik_jadwal_kuliah" ADD CONSTRAINT "akademik_jadwal_kuliah_mk_id_foreign" FOREIGN KEY ("mk_id") REFERENCES "public"."akademik_matakuliah" ("id") ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE "public"."akademik_jadwal_kuliah" ADD CONSTRAINT "akademik_jadwal_kuliah_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table akademik_matakuliah -- ---------------------------- ALTER TABLE "public"."akademik_matakuliah" ADD CONSTRAINT "akademik_matakuliah_prodi_id_foreign" FOREIGN KEY ("prodi_id") REFERENCES "public"."ms_study_programs" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table indirect_budgets -- ---------------------------- ALTER TABLE "public"."indirect_budgets" ADD CONSTRAINT "fk_budget_activity_component_v2" FOREIGN KEY ("activity_component_id") REFERENCES "public"."activity_components" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table ms_honor_rates -- ---------------------------- ALTER TABLE "public"."ms_honor_rates" ADD CONSTRAINT "ms_honor_rates_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table ms_labor_config -- ---------------------------- ALTER TABLE "public"."ms_labor_config" ADD CONSTRAINT "ms_labor_config_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table ms_labor_rates -- ---------------------------- ALTER TABLE "public"."ms_labor_rates" ADD CONSTRAINT "ms_labor_rates_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table ms_prodi_revenue_config -- ---------------------------- ALTER TABLE "public"."ms_prodi_revenue_config" ADD CONSTRAINT "fk_revenue_prodi" FOREIGN KEY ("study_program_id") REFERENCES "public"."ms_study_programs" ("id") ON DELETE CASCADE ON UPDATE NO ACTION; ALTER TABLE "public"."ms_prodi_revenue_config" ADD CONSTRAINT "fk_revenue_year" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE NO ACTION; -- ---------------------------- -- Foreign Keys structure for table ms_ssbopt_config -- ---------------------------- ALTER TABLE "public"."ms_ssbopt_config" ADD CONSTRAINT "ms_ssbopt_config_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table ms_study_programs -- ---------------------------- ALTER TABLE "public"."ms_study_programs" ADD CONSTRAINT "fk_prodi_ssbopt_cluster" FOREIGN KEY ("ssbopt_cluster_id") REFERENCES "public"."ref_ssbopt_clusters" ("id") ON DELETE SET NULL ON UPDATE NO ACTION; ALTER TABLE "public"."ms_study_programs" ADD CONSTRAINT "fk_study_program_department_v2" FOREIGN KEY ("department_id") REFERENCES "public"."ms_departments" ("id") ON DELETE SET NULL ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table ms_unit_config -- ---------------------------- ALTER TABLE "public"."ms_unit_config" ADD CONSTRAINT "ms_unit_config_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table report_unit_costs -- ---------------------------- ALTER TABLE "public"."report_unit_costs" ADD CONSTRAINT "fk_report_prodi" FOREIGN KEY ("study_program_id") REFERENCES "public"."ms_study_programs" ("id") ON DELETE CASCADE ON UPDATE NO ACTION; ALTER TABLE "public"."report_unit_costs" ADD CONSTRAINT "fk_report_year" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE NO ACTION; -- ---------------------------- -- Foreign Keys structure for table rpt_unit_costs -- ---------------------------- ALTER TABLE "public"."rpt_unit_costs" ADD CONSTRAINT "rpt_unit_costs_study_program_id_foreign" FOREIGN KEY ("study_program_id") REFERENCES "public"."ms_study_programs" ("id") ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE "public"."rpt_unit_costs" ADD CONSTRAINT "rpt_unit_costs_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table trans_driver_values -- ---------------------------- ALTER TABLE "public"."trans_driver_values" ADD CONSTRAINT "fk_trans_driver_faculty_code" FOREIGN KEY ("faculty_code") REFERENCES "public"."ms_faculties" ("faculty_code") ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE "public"."trans_driver_values" ADD CONSTRAINT "trans_driver_values_study_program_id_foreign" FOREIGN KEY ("study_program_id") REFERENCES "public"."ms_study_programs" ("id") ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE "public"."trans_driver_values" ADD CONSTRAINT "trans_driver_values_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table trans_resources -- ---------------------------- ALTER TABLE "public"."trans_resources" ADD CONSTRAINT "trans_resources_cost_category_id_foreign" FOREIGN KEY ("cost_category_id") REFERENCES "public"."abc_cost_categories" ("id") ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE "public"."trans_resources" ADD CONSTRAINT "trans_resources_default_driver_id_fkey" FOREIGN KEY ("default_driver_id") REFERENCES "public"."abc_drivers" ("id") ON DELETE SET NULL ON UPDATE NO ACTION; ALTER TABLE "public"."trans_resources" ADD CONSTRAINT "trans_resources_department_id_foreign" FOREIGN KEY ("department_id") REFERENCES "public"."ms_departments" ("id") ON DELETE CASCADE ON UPDATE SET NULL; ALTER TABLE "public"."trans_resources" ADD CONSTRAINT "trans_resources_faculty_id_foreign" FOREIGN KEY ("faculty_id") REFERENCES "public"."ms_faculties" ("id") ON DELETE CASCADE ON UPDATE SET NULL; ALTER TABLE "public"."trans_resources" ADD CONSTRAINT "trans_resources_study_program_id_foreign" FOREIGN KEY ("study_program_id") REFERENCES "public"."ms_study_programs" ("id") ON DELETE CASCADE ON UPDATE SET NULL; ALTER TABLE "public"."trans_resources" ADD CONSTRAINT "trans_resources_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table users -- ---------------------------- ALTER TABLE "public"."users" ADD CONSTRAINT "fk_user_level" FOREIGN KEY ("user_level_id") REFERENCES "public"."ms_user_levels" ("id") ON DELETE SET NULL ON UPDATE CASCADE; ALTER TABLE "public"."users" ADD CONSTRAINT "users_department_id_foreign" FOREIGN KEY ("department_id") REFERENCES "public"."ms_departments" ("id") ON DELETE CASCADE ON UPDATE SET NULL; ALTER TABLE "public"."users" ADD CONSTRAINT "users_faculty_id_foreign" FOREIGN KEY ("faculty_id") REFERENCES "public"."ms_faculties" ("id") ON DELETE CASCADE ON UPDATE SET NULL; ALTER TABLE "public"."users" ADD CONSTRAINT "users_study_program_id_foreign" FOREIGN KEY ("study_program_id") REFERENCES "public"."ms_study_programs" ("id") ON DELETE CASCADE ON UPDATE SET NULL;