/* 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: 28/03/2026 21:03:06 */ -- ---------------------------- -- 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_jadwal_tim_teaching_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "public"."akademik_jadwal_tim_teaching_id_seq"; CREATE SEQUENCE "public"."akademik_jadwal_tim_teaching_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 (1, 'GRP-01', 'Belanja Personil (Gaji & Honor)', 'Gaji pokok, tunjangan, dan honorarium dosen serta tendik.', NULL, NULL, NULL, NULL, NULL, 'UNIVERSITY', NULL, NULL); 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 (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, 1, NULL, 'PRODI', NULL, 1); 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, 'FACULTY', NULL, NULL); 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, 1, NULL, 'PRODI', 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, 1, NULL, 'PRODI', NULL, 7); 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 (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 (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 (13, 'GRP-03', 'Jasa, Utilitas & Langganan', 'Listrik, Air, Internet, dan Jasa Pihak Ketiga.', NULL, NULL, NULL, 2, NULL, 'UNIVERSITY', NULL, NULL); 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 (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 (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 (19, 'GRP-04', 'Perjalanan Dinas', 'Transportasi dan akomodasi kegiatan dinas.', NULL, NULL, NULL, NULL, NULL, 'UNIVERSITY', NULL, NULL); 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 (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 (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 (23, 'GRP-05', 'Pemeliharaan & Aset', 'Service dan perbaikan aset.', NULL, NULL, NULL, 2, NULL, 'UNIVERSITY', NULL, NULL); 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 (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, 1, NULL, 'PRODI', 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 (28, 'GRP-06', 'Riset, Mutu & Kemahasiswaan', 'Biaya pendukung Tridharma dan kemahasiswaan (DRPM/Direktorat).', NULL, NULL, NULL, NULL, NULL, 'UNIVERSITY', NULL, NULL); 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 (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 (32, 'SUP-004', 'Pengembangan Kurikulum & Workshop', 'Review kurikulum, FGD.', '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 (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 (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 (33, 'HON-001', 'Biaya Pengajaran & Honorarium', NULL, NULL, NULL, NULL, 1, NULL, 'PRODI', NULL, NULL); -- ---------------------------- -- 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) ) ; -- ---------------------------- -- Records of abc_drivers -- ---------------------------- INSERT INTO "public"."abc_drivers" VALUES (2, 'Jumlah Mahasiswa Aktif', 'Orang', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi biaya layanan kemahasiswaan dan administrasi akademik.', NULL, NULL); INSERT INTO "public"."abc_drivers" VALUES (10, 'Jumlah Lulusan', 'Orang', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi biaya wisuda dan pencetakan ijazah.', NULL, NULL); INSERT INTO "public"."abc_drivers" VALUES (1, 'Luas Fasilitas Prodi', 'm2', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi biaya kebersihan, listrik, dan pemeliharaan gedung, Ini dipakai saat membebankan biaya dari aktivitas ke masing-masing Program Studi', NULL, '2026-03-27 02:36:42'); INSERT INTO "public"."abc_drivers" VALUES (7, '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'); 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'); INSERT INTO "public"."abc_drivers" VALUES (12, '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); INSERT INTO "public"."abc_drivers" VALUES (13, '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'); INSERT INTO "public"."abc_drivers" VALUES (15, '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); INSERT INTO "public"."abc_drivers" VALUES (8, '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'); INSERT INTO "public"."abc_drivers" VALUES (11, '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'); INSERT INTO "public"."abc_drivers" VALUES (5, 'Jumlah Komputer Lab', 'Unit', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi biaya maintenance IT, langganan internet prodi, dan lisensi software komputer.', NULL, NULL); INSERT INTO "public"."abc_drivers" VALUES (14, 'Jumlah Kegiatan Tri Dharma', 'Kegiatan', 'ACTIVITY_DRIVER', 'Digunakan untuk mengalokasikan beban dana operasional Penelitian dan Pengabdian Masyarakat (PKM) dari lembaga riset ke program studi.', '2026-03-27 02:51:29', '2026-03-27 02:59:13'); INSERT INTO "public"."abc_drivers" VALUES (16, '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); INSERT INTO "public"."abc_drivers" VALUES (17, 'Total Kegiatan Tri Dharma Institusi', 'Kegiatan', 'RESOURCE_DRIVER', 'Digunakan sebagai basis alokasi tingkat makro untuk menyerap biaya overhead penelitian dan pengabdian dari universitas ke fakultas.', NULL, NULL); -- ---------------------------- -- 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 (17, 1, 114, 'A', 'REGULER', NULL, '198005072023211014', 'Guru Besar', 30, 16, 6240000.00, '2025-12-27 06:10:37', '2026-01-27 01:32:49'); 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 (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 (18, 1, 115, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor', 30, 16, 2480000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5, 1, 102, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor', 30, 16, 4240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:17'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (2, 1, 99, 'A', 'REGULER', NULL, 'Abdul Mahfudin Alim S.Pd.Kor., M.Pd.', 'Lektor', 30, 16, 3200000.00, '2025-12-27 06:10:37', '2026-01-27 06:08:36'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (4, 1, 101, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor', 30, 16, 4240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:17'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (13, 1, 110, 'B', 'REGULER', NULL, '1199902122023091093', 'Guru Besar', 30, 16, 2240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (9, 1, 106, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor Kepala', 30, 16, 3840000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (19, 1, 116, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor Kepala', 30, 16, 3840000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (3, 1, 100, 'A', 'REGULER', NULL, 'Riky Dwihandaka S.Pd.Kor., M.Or.', 'Lektor', 30, 16, 1440000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:17'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (22, 1, 119, 'RPL', 'REGULER', NULL, 'Dr. Putri Prastiwi Wulandari S.Pd., M.Pd.', 'Guru Besar', 30, 16, 2240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (26, 1, 123, 'B', 'REGULER', NULL, '1199902122023091093', 'Guru Besar', 30, 16, 2240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); 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 (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 (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 (28, 1, 125, 'B', 'REGULER', NULL, '1199902122023091093', 'Asisten Ahli', 30, 16, 5250000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (15, 1, 112, 'B', 'REGULER', NULL, '1199902122023091093', 'Guru Besar', 30, 16, 2240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (1, 1, 98, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor', 30, 16, 1440000.00, '2025-12-27 06:10:37', '2026-01-21 06:55:23'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (21, 1, 118, 'B', 'REGULER', NULL, '199204152023211021', 'Lektor', 30, 16, 1440000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (23, 1, 120, 'A', 'REGULER', NULL, 'Dr. Dennis Dwi Kurniawan S.Pd., M.Pd.', 'Lektor', 30, 16, 2160000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (24, 1, 121, 'B', 'REGULER', NULL, '1199902122023091093', 'Asisten Ahli', 30, 16, 3440000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (7, 1, 104, 'A', 'REGULER', NULL, '1199611012023091048', 'Guru Besar', 30, 16, 2240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (6, 1, 103, 'C', 'REGULER', NULL, 'Sulthon Abdul Aziz M.S.I.', 'Lektor Kepala', 30, 16, 1760000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (16, 1, 113, 'A', 'REGULER', NULL, 'Riesti Cahyaningrum M.Pd.', 'Guru Besar', 30, 16, 4800000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (8, 1, 105, 'B', 'REGULER', NULL, '1199902122023091093', 'Asisten Ahli', 30, 16, 1120000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (12, 1, 109, 'B', 'REGULER', NULL, '1199902122023091093', 'Guru Besar', 30, 16, 6240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (11, 1, 108, 'B', 'REGULER', NULL, '1199902122023091093', 'Asisten Ahli', 30, 16, 2000000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (27, 1, 124, 'B', 'REGULER', NULL, '1199902122023091093', 'Asisten Ahli', 30, 16, 5250000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (29, 1, 126, 'B', 'REGULER', NULL, '1199902122023091093', 'Guru Besar', 30, 16, 5250000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (10, 1, 107, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor Kepala', 30, 16, 5040000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (30, 1, 127, 'B', 'REGULER', NULL, '1199902122023091093', 'Guru Besar', 30, 16, 5120000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (31, 1, 128, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor', 30, 16, 29250000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (25, 1, 122, 'B', 'REGULER', NULL, '1199902122023091093', 'Asisten Ahli', 30, 16, 1120000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (14, 1, 111, 'C', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Tenaga Pengajar', 30, 16, 1920000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (20, 1, 117, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor', 30, 16, 4240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); -- ---------------------------- -- Table structure for akademik_jadwal_tim_teaching -- ---------------------------- DROP TABLE IF EXISTS "public"."akademik_jadwal_tim_teaching"; CREATE TABLE "public"."akademik_jadwal_tim_teaching" ( "id" int8 NOT NULL DEFAULT nextval('akademik_jadwal_tim_teaching_id_seq'::regclass), "jadwal_id" int8 NOT NULL, "dosen_id" int8, "nama_dosen" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "jabatan_fungsional" varchar(50) COLLATE "pg_catalog"."default" NOT NULL, "jumlah_tatap_muka" int4 NOT NULL DEFAULT 0, "sks_beban" numeric(5,2) NOT NULL DEFAULT 0, "honor_diterima" numeric(15,2) NOT NULL DEFAULT 0 ) ; -- ---------------------------- -- Records of akademik_jadwal_tim_teaching -- ---------------------------- -- ---------------------------- -- 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 (98, 4, 'PJD101', 'Landasan Pendidikan Jasmani', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (99, 4, 'PJD102', 'Anatomi Manusia', 3, 2, 1, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (100, 4, 'PJD103', 'Fisiologi Dasar', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (101, 4, 'PJD104', 'Atletik Dasar (Lari & Lompat)', 3, 1, 2, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (102, 4, 'PJD105', 'Senam Dasar & Ritmik', 3, 1, 2, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (103, 4, 'UNY101', 'Pendidikan Agama', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (104, 4, 'UNY102', 'Pancasila', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (105, 4, 'PJD201', 'Perkembangan Peserta Didik SD', 2, 2, 0, 0, 'KULIAH', 2, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (106, 4, 'PJD202', 'Belajar Gerak (Motor Learning)', 3, 2, 1, 0, 'KULIAH', 2, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (107, 4, 'PJD203', 'Renang Dasar & Penyelamatan Air', 3, 1, 2, 0, 'KULIAH', 2, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (108, 4, 'PJD204', 'Permainan Bola Kecil', 2, 1, 1, 0, 'KULIAH', 2, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (109, 4, 'PJD205', 'Permainan Bola Besar', 3, 1, 2, 0, 'KULIAH', 2, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (110, 4, 'UNY201', 'Bahasa Indonesia', 2, 2, 0, 0, 'KULIAH', 2, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (111, 4, 'PJD301', 'Strategi Pembelajaran Penjas SD', 3, 2, 1, 0, 'KULIAH', 3, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (112, 4, 'PJD302', 'Kurikulum Penjas SD (Merdeka)', 2, 2, 0, 0, 'KULIAH', 3, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (113, 4, 'PJD303', 'Pendidikan Jasmani Adaptif', 3, 2, 1, 0, 'KULIAH', 3, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (114, 4, 'PJD304', 'Aktivitas Luar Kelas', 3, 1, 2, 0, 'KULIAH', 3, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (115, 4, 'PJD305', 'Pencak Silat & Beladiri SD', 2, 1, 1, 0, 'KULIAH', 3, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (116, 4, 'PJD401', 'Evaluasi Pembelajaran Penjas', 3, 2, 1, 0, 'KULIAH', 4, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (117, 4, 'PJD402', 'Teknologi & Media Pembelajaran', 3, 1, 2, 0, 'KULIAH', 4, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (118, 4, 'PJD403', 'Manajemen Pendidikan Jasmani', 2, 2, 0, 0, 'KULIAH', 4, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (119, 4, 'PJD404', 'Gizi Olahraga & Kesehatan Sekolah', 2, 2, 0, 0, 'KULIAH', 4, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (120, 4, 'PJD405', 'Metodologi Penelitian Pendidikan', 3, 3, 0, 0, 'KULIAH', 4, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (121, 4, 'PJD501', 'Micro Teaching', 3, 1, 2, 0, 'KULIAH', 5, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (122, 4, 'PJD502', 'Statistika Pendidikan', 2, 2, 0, 0, 'KULIAH', 5, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (123, 4, 'PJD503', 'K3 Olahraga', 2, 2, 0, 0, 'KULIAH', 5, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (124, 4, 'PJD601', 'PLP / Magang Kependidikan 1', 2, 0, 0, 2, 'BIMBINGAN', 6, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (125, 4, 'UNY601', 'Kuliah Kerja Nyata (KKN)', 4, 0, 0, 4, 'BIMBINGAN', 6, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (126, 4, 'PJD701', 'PLP / Magang Kependidikan 2', 4, 0, 0, 4, 'BIMBINGAN', 7, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); 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 (127, 4, 'PJD702', 'Seminar Proposal Skripsi', 2, 0, 2, 0, 'KULIAH', 7, '2025-12-27 02:16:03', '2025-12-27 22:18:30'); 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 (128, 4, 'PJD801', 'Skripsi / Tugas Akhir', 6, 0, 0, 6, 'BIMBINGAN_UJI', 8, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); 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'); -- ---------------------------- -- 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 (14, 13, 'Jadwal Kuliah', 'akademik/jadwal', 'fas fa-calendar-alt', 1, 't', 'superuser,admin_univ,admin_fakultas,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 (23, 0, 'System Admin', '#', 'fas fa-user-shield', 99, 't', 'superuser'); INSERT INTO "public"."ms_menus" VALUES (25, 23, 'Manajemen Menu', 'system/menu', 'fas fa-list', 2, 't', 'superuser'); INSERT INTO "public"."ms_menus" VALUES (26, 23, 'Audit Database', 'system/database', 'fas fa-server', 3, 't', 'superuser'); INSERT INTO "public"."ms_menus" VALUES (27, 13, 'Proses Alokasi Biaya', 'transaksi/alokasi', 'fas fa-network-wired', 5, 't', 'superuser,admin_univ'); INSERT INTO "public"."ms_menus" VALUES (28, 13, 'Target Pendapatan', 'transaksi/revenue', 'fas fa-bullseye', 8, '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', 2, 't', 'superuser,admin_univ,admin_fakultas,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (16, 13, 'Nilai Statistik (Driver)', 'transaksi/driver-values', 'fas fa-chart-bar', 4, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi'); INSERT INTO "public"."ms_menus" VALUES (15, 13, 'Input Sumber Daya', 'transaksi/resources', 'fas fa-file-invoice-dollar', 3, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,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 (31, 13, 'Input Rincian Kategori', 'transaksi/rinciankategori', 'fas fa-file-invoice-dollar', 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'); -- ---------------------------- -- 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 (4, 1, 1, 4, 779435000.00, 90, 8660388.89, '2026-01-29 04:47:13'); INSERT INTO "public"."report_unit_costs" VALUES (5, 1, 1, 5, 505945000.00, 40, 12648625.00, '2026-01-29 04:47:13'); INSERT INTO "public"."report_unit_costs" VALUES (6, 1, 1, 6, 1731145000.00, 30, 57704833.33, '2026-01-29 04:47:13'); -- ---------------------------- -- 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 NOT NULL, "value_amount" numeric(10,2) NOT NULL DEFAULT 0, "description" text COLLATE "pg_catalog"."default", "created_at" timestamp(6), "updated_at" timestamp(6) ) ; -- ---------------------------- -- Records of trans_driver_values -- ---------------------------- INSERT INTO "public"."trans_driver_values" VALUES (4, 1, 7, 4, 1500.00, 'Gedung A Lt 1-2 + GOR Basket', '2026-01-02 09:37:22', NULL); INSERT INTO "public"."trans_driver_values" VALUES (5, 1, 7, 5, 400.00, 'Gedung Pasca Lt 3', '2026-01-02 09:37:22', NULL); INSERT INTO "public"."trans_driver_values" VALUES (6, 1, 7, 6, 200.00, 'Gedung Pasca Lt 4', '2026-01-02 09:37:22', NULL); INSERT INTO "public"."trans_driver_values" VALUES (10, 1, 9, 4, 25.00, 'MK Praktik Lapangan', '2026-01-02 09:37:22', NULL); INSERT INTO "public"."trans_driver_values" VALUES (11, 1, 9, 5, 5.00, 'MK Tes & Pengukuran Fisik', '2026-01-02 09:37:22', NULL); INSERT INTO "public"."trans_driver_values" VALUES (1, 1, 2, 4, 90.00, 'Data Registrasi Semester Ganjil 2024', '2026-01-02 09:37:22', '2026-01-06 01:32:58'); INSERT INTO "public"."trans_driver_values" VALUES (7, 1, 8, 4, 6.00, 'Dosen pengampu mata kuliah dasar & praktik', '2026-01-02 09:37:22', '2026-01-06 01:33:29'); INSERT INTO "public"."trans_driver_values" VALUES (3, 1, 2, 6, 30.00, 'Data Registrasi Semester Ganjil 2024', '2026-01-02 09:37:22', '2026-01-06 01:33:52'); INSERT INTO "public"."trans_driver_values" VALUES (2, 1, 2, 5, 40.00, 'Data Registrasi Semester Ganjil 2024', '2026-01-02 09:37:22', '2026-01-06 01:34:04'); INSERT INTO "public"."trans_driver_values" VALUES (8, 1, 8, 5, 6.00, 'Dosen kualifikasi Doktor/Lektor Kepala', '2026-01-02 09:37:22', '2026-01-06 01:34:22'); INSERT INTO "public"."trans_driver_values" VALUES (9, 1, 8, 6, 6.00, 'Guru Besar (Profesor)', '2026-01-02 09:37:22', '2026-01-06 01:34:35'); -- ---------------------------- -- 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(15,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" ) ; -- ---------------------------- -- Records of trans_resources -- ---------------------------- INSERT INTO "public"."trans_resources" VALUES (167, 1, 6, 5000000.00, 'PRODI', 1, 1, 4, '', 16, '2026-01-28 07:48:40', '2026-01-28 07:48:40', '{}', 'Visiting Profesor'); INSERT INTO "public"."trans_resources" VALUES (86, 1, 4, 4000000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 32', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 4000000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "125000.00"}]', 'Honorarium: Filsafat Ilmu & Pendidikan Jasmani'); INSERT INTO "public"."trans_resources" VALUES (87, 1, 4, 6640000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 40', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 1200000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "75000.00"}, {"sub": 5440000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "85000.00"}]', 'Honorarium: Analisis Gerak & Biomekanika SD'); INSERT INTO "public"."trans_resources" VALUES (88, 1, 5, 138525000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 47', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 84525000, "vol": "30 Mhs", "item": "Pembimbing (Guru Besar)", "rate": "2817500.00"}, {"sub": 13500000, "vol": "30 Mhs", "item": "Ketua Penguji", "rate": "450000.00"}, {"sub": 13500000, "vol": "30 Mhs", "item": "Sekretaris Penguji", "rate": "450000.00"}, {"sub": 27000000, "vol": "30 Mhs", "item": "Anggota Penguji (2 org)", "rate": "450000.00"}]', 'Honorarium: Tesis (Penelitian & Ujian)'); INSERT INTO "public"."trans_resources" VALUES (89, 1, 4, 8640000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 42', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 1600000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "100000.00"}, {"sub": 7040000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor Kepala)", "rate": "110000.00"}]', 'Honorarium: Teknologi Informasi dalam Penjas'); INSERT INTO "public"."trans_resources" VALUES (90, 1, 4, 2400000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 44', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 2400000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "75000.00"}]', 'Honorarium: Isu-isu Kontemporer Penjas SD'); INSERT INTO "public"."trans_resources" VALUES (92, 1, 4, 8640000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 46', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 8640000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "135000.00"}]', 'Honorarium: Seminar Proposal Tesis'); INSERT INTO "public"."trans_resources" VALUES (91, 1, 4, 8320000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 37', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 4000000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "125000.00"}, {"sub": 4320000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "135000.00"}]', 'Honorarium: Model & Desain Pembelajaran Penjas SD'); INSERT INTO "public"."trans_resources" VALUES (93, 1, 4, 8320000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 34', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 4000000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "125000.00"}, {"sub": 4320000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "135000.00"}]', 'Honorarium: Metodologi Penelitian Pendidikan Olahraga'); INSERT INTO "public"."trans_resources" VALUES (94, 1, 4, 3200000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 35', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 3200000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "100000.00"}]', 'Honorarium: Pedagogi Olahraga Sekolah Dasar'); INSERT INTO "public"."trans_resources" VALUES (95, 1, 4, 3920000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 45', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 1200000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "75000.00"}, {"sub": 2720000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "85000.00"}]', 'Honorarium: Penulisan Karya Ilmiah Internasional'); INSERT INTO "public"."trans_resources" VALUES (96, 1, 4, 3200000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 39', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 3200000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "100000.00"}]', 'Honorarium: Pengembangan Kurikulum Penjas SD'); INSERT INTO "public"."trans_resources" VALUES (97, 1, 4, 5120000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 38', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 2400000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "75000.00"}, {"sub": 2720000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "85000.00"}]', 'Honorarium: Asesmen & Evaluasi Pembelajaran Penjas'); INSERT INTO "public"."trans_resources" VALUES (98, 1, 4, 6320000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 41', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 2000000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "125000.00"}, {"sub": 4320000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "135000.00"}]', 'Honorarium: Pendidikan Jasmani Adaptif Lanjut'); INSERT INTO "public"."trans_resources" VALUES (99, 1, 4, 3200000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 43', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 3200000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "100000.00"}]', 'Honorarium: Manajemen Penjas & Olahraga Sekolah'); INSERT INTO "public"."trans_resources" VALUES (100, 1, 4, 4000000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 33', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 4000000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "125000.00"}]', 'Honorarium: Statistik Terapan Lanjut'); INSERT INTO "public"."trans_resources" VALUES (101, 1, 4, 4000000.00, 'PRODI', 1, 1, 5, 'Otomatis dari Jadwal ID: 36', 17, NULL, '2026-01-28 07:52:59', '[{"sub": 4000000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "125000.00"}]', 'Honorarium: Psikologi Pendidikan Jasmani SD'); INSERT INTO "public"."trans_resources" VALUES (455, 1, 3, 84375000.00, 'PRODI', 1, 1, 4, 'Hasil Alokasi ABC. Driver: Jumlah Mahasiswa Aktif (Vol: 90.00)', NULL, NULL, '2026-01-29 04:47:13', '[]', 'Alokasi BTL - Gaji & Tunjangan Tendik (Admin)'); INSERT INTO "public"."trans_resources" VALUES (456, 1, 3, 28125000.00, 'PRODI', 1, 1, 6, 'Hasil Alokasi ABC. Driver: Jumlah Mahasiswa Aktif (Vol: 30.00)', NULL, NULL, '2026-01-29 04:47:13', '[]', 'Alokasi BTL - Gaji & Tunjangan Tendik (Admin)'); INSERT INTO "public"."trans_resources" VALUES (457, 1, 3, 37500000.00, 'PRODI', 1, 1, 5, 'Hasil Alokasi ABC. Driver: Jumlah Mahasiswa Aktif (Vol: 40.00)', NULL, NULL, '2026-01-29 04:47:13', '[]', 'Alokasi BTL - Gaji & Tunjangan Tendik (Admin)'); INSERT INTO "public"."trans_resources" VALUES (458, 1, 16, 562500000.00, 'PRODI', 1, 1, 4, 'Hasil Alokasi ABC. Driver: Jumlah Mahasiswa Aktif (Vol: 90.00)', NULL, NULL, '2026-01-29 04:47:13', '[]', 'Alokasi BTL - Internet & Bandwidth'); INSERT INTO "public"."trans_resources" VALUES (459, 1, 16, 187500000.00, 'PRODI', 1, 1, 6, 'Hasil Alokasi ABC. Driver: Jumlah Mahasiswa Aktif (Vol: 30.00)', NULL, NULL, '2026-01-29 04:47:13', '[]', 'Alokasi BTL - Internet & Bandwidth'); INSERT INTO "public"."trans_resources" VALUES (460, 1, 16, 250000000.00, 'PRODI', 1, 1, 5, 'Hasil Alokasi ABC. Driver: Jumlah Mahasiswa Aktif (Vol: 40.00)', NULL, NULL, '2026-01-29 04:47:13', '[]', 'Alokasi BTL - Internet & Bandwidth'); INSERT INTO "public"."trans_resources" VALUES (166, 1, 6, 900000.00, 'PRODI', NULL, NULL, NULL, '', NULL, '2026-01-28 05:32:42', '2026-01-28 07:07:49', '{"qty": "2", "type": "honor", "tarif": "450000", "penerima": "Dosen Tamu"}', 'Honor: D'); INSERT INTO "public"."trans_resources" VALUES (168, 1, 3, 150000000.00, 'UNIVERSITY', NULL, NULL, NULL, '', 7, '2026-01-28 09:08:28', '2026-01-28 09:08:28', '{}', 'Gaji Pegawai'); INSERT INTO "public"."trans_resources" VALUES (169, 1, 16, 1000000000.00, 'UNIVERSITY', NULL, NULL, NULL, '', 7, '2026-01-28 09:31:31', '2026-01-28 09:31:31', '{}', 'Langganan Internet & Bandwidth '); INSERT INTO "public"."trans_resources" VALUES (69, 1, 4, 6720000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 52', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 3200000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "100000.00"}, {"sub": 3520000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "110000.00"}]', 'Honorarium: Desain & Analisis Statistik Lanjut'); INSERT INTO "public"."trans_resources" VALUES (70, 1, 4, 8320000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 55', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 4000000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "125000.00"}, {"sub": 4320000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor Kepala)", "rate": "135000.00"}]', 'Honorarium: Evaluasi Program & Kebijakan Penjas'); INSERT INTO "public"."trans_resources" VALUES (71, 1, 4, 4800000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 48', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 4800000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "150000.00"}]', 'Honorarium: Filsafat Ilmu Keolahragaan Lanjut'); INSERT INTO "public"."trans_resources" VALUES (135, 1, 4, 6240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 17', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 1120000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}, {"sub": 5120000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "80000.00"}]', 'Honorarium: Aktivitas Luar Kelas'); INSERT INTO "public"."trans_resources" VALUES (136, 1, 5, 5250000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 28', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 5250000, "vol": "30 Mhs", "item": "Honor Pembimbing Lapangan", "rate": "175000.00"}]', 'Honorarium: Kuliah Kerja Nyata (KKN)'); INSERT INTO "public"."trans_resources" VALUES (137, 1, 4, 2240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 15', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 2240000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}]', 'Honorarium: Kurikulum Penjas SD (Merdeka)'); INSERT INTO "public"."trans_resources" VALUES (138, 1, 4, 1440000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 1', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 1440000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}]', 'Honorarium: Landasan Pendidikan Jasmani'); INSERT INTO "public"."trans_resources" VALUES (139, 1, 4, 1440000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 21', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 1440000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}]', 'Honorarium: Manajemen Pendidikan Jasmani'); INSERT INTO "public"."trans_resources" VALUES (140, 1, 4, 2160000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 23', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 2160000, "vol": "3 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}]', 'Honorarium: Metodologi Penelitian Pendidikan'); INSERT INTO "public"."trans_resources" VALUES (141, 1, 4, 3440000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 24', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 560000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Asisten Ahli)", "rate": "35000.00"}, {"sub": 2880000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Asisten Ahli)", "rate": "45000.00"}]', 'Honorarium: Micro Teaching'); INSERT INTO "public"."trans_resources" VALUES (142, 1, 4, 2240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 7', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 2240000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}]', 'Honorarium: Pancasila'); INSERT INTO "public"."trans_resources" VALUES (143, 1, 4, 2480000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 18', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 720000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}, {"sub": 1760000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "55000.00"}]', 'Honorarium: Pencak Silat & Beladiri SD'); INSERT INTO "public"."trans_resources" VALUES (144, 1, 4, 4240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 5', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 720000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}, {"sub": 3520000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "55000.00"}]', 'Honorarium: Senam Dasar & Ritmik'); INSERT INTO "public"."trans_resources" VALUES (145, 1, 4, 3200000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 2', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 1440000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}, {"sub": 1760000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "55000.00"}]', 'Honorarium: Anatomi Manusia'); INSERT INTO "public"."trans_resources" VALUES (146, 1, 4, 4240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 4', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 720000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}, {"sub": 3520000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "55000.00"}]', 'Honorarium: Atletik Dasar (Lari & Lompat)'); INSERT INTO "public"."trans_resources" VALUES (147, 1, 4, 2240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 13', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 2240000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}]', 'Honorarium: Bahasa Indonesia'); INSERT INTO "public"."trans_resources" VALUES (148, 1, 4, 3840000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 9', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 1760000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "55000.00"}, {"sub": 2080000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor Kepala)", "rate": "65000.00"}]', 'Honorarium: Belajar Gerak (Motor Learning)'); INSERT INTO "public"."trans_resources" VALUES (149, 1, 4, 3840000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 19', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 1760000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "55000.00"}, {"sub": 2080000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor Kepala)", "rate": "65000.00"}]', 'Honorarium: Evaluasi Pembelajaran Penjas'); INSERT INTO "public"."trans_resources" VALUES (150, 1, 4, 1440000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 3', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 1440000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}]', 'Honorarium: Fisiologi Dasar'); INSERT INTO "public"."trans_resources" VALUES (151, 1, 4, 2240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 22', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 2240000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}]', 'Honorarium: Gizi Olahraga & Kesehatan Sekolah'); INSERT INTO "public"."trans_resources" VALUES (152, 1, 4, 2240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 26', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 2240000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}]', 'Honorarium: K3 Olahraga'); INSERT INTO "public"."trans_resources" VALUES (153, 1, 4, 1760000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 6', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 1760000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "55000.00"}]', 'Honorarium: Pendidikan Agama'); INSERT INTO "public"."trans_resources" VALUES (154, 1, 4, 4800000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 16', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 2240000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}, {"sub": 2560000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "80000.00"}]', 'Honorarium: Pendidikan Jasmani Adaptif'); INSERT INTO "public"."trans_resources" VALUES (155, 1, 4, 1120000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 8', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 1120000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Asisten Ahli)", "rate": "35000.00"}]', 'Honorarium: Perkembangan Peserta Didik SD'); INSERT INTO "public"."trans_resources" VALUES (156, 1, 4, 6240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 12', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 1120000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}, {"sub": 5120000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "80000.00"}]', 'Honorarium: Permainan Bola Besar'); INSERT INTO "public"."trans_resources" VALUES (157, 1, 4, 2000000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 11', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 560000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Asisten Ahli)", "rate": "35000.00"}, {"sub": 1440000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Asisten Ahli)", "rate": "45000.00"}]', 'Honorarium: Permainan Bola Kecil'); INSERT INTO "public"."trans_resources" VALUES (158, 1, 5, 5250000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 27', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 5250000, "vol": "30 Mhs", "item": "Honor Pembimbing Lapangan", "rate": "175000.00"}]', 'Honorarium: PLP / Magang Kependidikan 1'); INSERT INTO "public"."trans_resources" VALUES (159, 1, 5, 5250000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 29', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 5250000, "vol": "30 Mhs", "item": "Honor Pembimbing Lapangan", "rate": "175000.00"}]', 'Honorarium: PLP / Magang Kependidikan 2'); INSERT INTO "public"."trans_resources" VALUES (160, 1, 4, 5040000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 10', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 880000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "55000.00"}, {"sub": 4160000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor Kepala)", "rate": "65000.00"}]', 'Honorarium: Renang Dasar & Penyelamatan Air'); INSERT INTO "public"."trans_resources" VALUES (161, 1, 4, 5120000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 30', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 5120000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "80000.00"}]', 'Honorarium: Seminar Proposal Skripsi'); INSERT INTO "public"."trans_resources" VALUES (162, 1, 5, 29250000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 31', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 18000000, "vol": "30 Mhs", "item": "Pembimbing (Lektor)", "rate": "600000.00"}, {"sub": 3750000, "vol": "30 Mhs", "item": "Ketua Penguji", "rate": "125000.00"}, {"sub": 3750000, "vol": "30 Mhs", "item": "Sekretaris Penguji", "rate": "125000.00"}, {"sub": 3750000, "vol": "30 Mhs", "item": "Anggota Penguji (1 org)", "rate": "125000.00"}]', 'Honorarium: Skripsi / Tugas Akhir'); INSERT INTO "public"."trans_resources" VALUES (163, 1, 4, 1120000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 25', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 1120000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Asisten Ahli)", "rate": "35000.00"}]', 'Honorarium: Statistika Pendidikan'); INSERT INTO "public"."trans_resources" VALUES (164, 1, 4, 1920000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 14', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 800000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Tenaga Pengajar)", "rate": "25000.00"}, {"sub": 1120000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Tenaga Pengajar)", "rate": "35000.00"}]', 'Honorarium: Strategi Pembelajaran Penjas SD'); INSERT INTO "public"."trans_resources" VALUES (165, 1, 4, 4240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 20', 16, NULL, '2026-01-28 05:31:00', '[{"sub": 720000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}, {"sub": 3520000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "55000.00"}]', 'Honorarium: Teknologi & Media Pembelajaran'); INSERT INTO "public"."trans_resources" VALUES (72, 1, 4, 4800000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 49', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 4800000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "150000.00"}]', 'Honorarium: Metodologi Riset Kuantitatif & Kualitatif'); INSERT INTO "public"."trans_resources" VALUES (73, 1, 4, 9920000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 54', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 4800000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "150000.00"}, {"sub": 5120000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "160000.00"}]', 'Honorarium: Pengembangan Model Kurikulum Penjas SD'); INSERT INTO "public"."trans_resources" VALUES (74, 1, 4, 10240000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 57', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 10240000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "160000.00"}]', 'Honorarium: Publikasi Ilmiah Internasional 1'); INSERT INTO "public"."trans_resources" VALUES (75, 1, 5, 346500000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 56', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 155250000, "vol": "30 Mhs", "item": "Promotor (Guru Besar)", "rate": "5175000.00"}, {"sub": 120750000, "vol": "30 Mhs", "item": "Co-Promotor (Guru Besar)", "rate": "4025000.00"}, {"sub": 22500000, "vol": "30 Mhs", "item": "Ketua Penguji", "rate": "750000.00"}, {"sub": 18000000, "vol": "30 Mhs", "item": "Sekretaris Penguji", "rate": "600000.00"}, {"sub": 30000000, "vol": "30 Mhs", "item": "Anggota Penguji (2 org)", "rate": "500000.00"}]', 'Honorarium: Seminar Proposal Disertasi (Pra-Kualifikasi)'); INSERT INTO "public"."trans_resources" VALUES (76, 1, 4, 12960000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 53', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 12960000, "vol": "3 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor Kepala)", "rate": "135000.00"}]', 'Honorarium: Studi Mandiri (Independent Study)'); INSERT INTO "public"."trans_resources" VALUES (77, 1, 4, 4800000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 51', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 4800000, "vol": "3 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "100000.00"}]', 'Honorarium: Teori & Isu Kritis Penjas SD'); INSERT INTO "public"."trans_resources" VALUES (78, 1, 4, 17280000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 59', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 17280000, "vol": "4 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor Kepala)", "rate": "135000.00"}]', 'Honorarium: Validasi Instrumen & Pengumpulan Data'); INSERT INTO "public"."trans_resources" VALUES (79, 1, 4, 20480000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 60', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 20480000, "vol": "4 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "160000.00"}]', 'Honorarium: Analisis Data & Penulisan Disertasi'); INSERT INTO "public"."trans_resources" VALUES (80, 1, 4, 6000000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 50', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 6000000, "vol": "3 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "125000.00"}]', 'Honorarium: Filsafat Pendidikan Jasmani & Olahraga'); INSERT INTO "public"."trans_resources" VALUES (81, 1, 5, 346500000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 64', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 155250000, "vol": "30 Mhs", "item": "Promotor (Guru Besar)", "rate": "5175000.00"}, {"sub": 120750000, "vol": "30 Mhs", "item": "Co-Promotor (Guru Besar)", "rate": "4025000.00"}, {"sub": 22500000, "vol": "30 Mhs", "item": "Ketua Penguji", "rate": "750000.00"}, {"sub": 18000000, "vol": "30 Mhs", "item": "Sekretaris Penguji", "rate": "600000.00"}, {"sub": 30000000, "vol": "30 Mhs", "item": "Anggota Penguji (2 org)", "rate": "500000.00"}]', 'Honorarium: Promosi Doktor (Ujian Terbuka)'); INSERT INTO "public"."trans_resources" VALUES (82, 1, 4, 12960000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 61', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 12960000, "vol": "3 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor Kepala)", "rate": "135000.00"}]', 'Honorarium: Publikasi Ilmiah Internasional 2'); INSERT INTO "public"."trans_resources" VALUES (83, 1, 5, 346500000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 62', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 155250000, "vol": "30 Mhs", "item": "Promotor (Guru Besar)", "rate": "5175000.00"}, {"sub": 120750000, "vol": "30 Mhs", "item": "Co-Promotor (Guru Besar)", "rate": "4025000.00"}, {"sub": 22500000, "vol": "30 Mhs", "item": "Ketua Penguji", "rate": "750000.00"}, {"sub": 18000000, "vol": "30 Mhs", "item": "Sekretaris Penguji", "rate": "600000.00"}, {"sub": 30000000, "vol": "30 Mhs", "item": "Anggota Penguji (2 org)", "rate": "500000.00"}]', 'Honorarium: Ujian Kelayakan Naskah Disertasi'); INSERT INTO "public"."trans_resources" VALUES (84, 1, 4, 10240000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 58', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 10240000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "160000.00"}]', 'Honorarium: Ujian Kualifikasi (Komprehensif)'); INSERT INTO "public"."trans_resources" VALUES (85, 1, 5, 346500000.00, 'PRODI', 1, 1, 6, 'Otomatis dari Jadwal ID: 63', 18, NULL, '2026-01-28 07:13:35', '[{"sub": 155250000, "vol": "30 Mhs", "item": "Promotor (Guru Besar)", "rate": "5175000.00"}, {"sub": 120750000, "vol": "30 Mhs", "item": "Co-Promotor (Guru Besar)", "rate": "4025000.00"}, {"sub": 22500000, "vol": "30 Mhs", "item": "Ketua Penguji", "rate": "750000.00"}, {"sub": 18000000, "vol": "30 Mhs", "item": "Sekretaris Penguji", "rate": "600000.00"}, {"sub": 30000000, "vol": "30 Mhs", "item": "Anggota Penguji (2 org)", "rate": "500000.00"}]', 'Honorarium: Ujian Tertutup Disertasi'); -- ---------------------------- -- 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"', 35, 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"', 15, 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"', 64, true); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."akademik_jadwal_tim_teaching_id_seq" OWNED BY "public"."akademik_jadwal_tim_teaching"."id"; SELECT setval('"public"."akademik_jadwal_tim_teaching_id_seq"', 1, false); -- ---------------------------- -- Alter sequences owned by -- ---------------------------- ALTER SEQUENCE "public"."akademik_matakuliah_id_seq" OWNED BY "public"."akademik_matakuliah"."id"; SELECT setval('"public"."akademik_matakuliah_id_seq"', 128, 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"', 6, 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"', 11, 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"', 460, 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_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_jadwal_tim_teaching -- ---------------------------- ALTER TABLE "public"."akademik_jadwal_tim_teaching" ADD CONSTRAINT "pk_akademik_jadwal_tim_teaching" 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"); -- ---------------------------- -- 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_jadwal_tim_teaching -- ---------------------------- ALTER TABLE "public"."akademik_jadwal_tim_teaching" ADD CONSTRAINT "akademik_jadwal_tim_teaching_jadwal_id_foreign" FOREIGN KEY ("jadwal_id") REFERENCES "public"."akademik_jadwal_kuliah" ("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 "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_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;