/*
 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: 08/02/2026 12:45:20
*/


-- ----------------------------
-- 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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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 (1, 'Luas Lantai Bangunan', 'm2', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi biaya kebersihan, listrik, dan pemeliharaan gedung.', NULL, NULL);
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 (3, 'Jumlah Dosen Tetap', 'Orang', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi biaya pengembangan SDM dan administrasi kepegawaian.', NULL, NULL);
INSERT INTO "public"."abc_drivers" VALUES (4, 'Jumlah Mata Kuliah Ditawarkan', 'MK', 'ACTIVITY_DRIVER', 'Pemicu beban kerja administrasi penjadwalan.', NULL, NULL);
INSERT INTO "public"."abc_drivers" VALUES (5, 'Jumlah Komputer Lab', 'Unit', 'ACTIVITY_DRIVER', 'Alokasi biaya maintenance IT dan lisensi software.', NULL, NULL);
INSERT INTO "public"."abc_drivers" VALUES (6, 'Luas Lahan Taman', 'm2', 'ACTIVITY_DRIVER', 'Alokasi biaya perawatan taman/lingkungan.', NULL, NULL);
INSERT INTO "public"."abc_drivers" VALUES (7, 'Luas Lantai & Fasilitas', 'm2', 'RESOURCE_DRIVER', 'Luas total ruang kelas, lab, dan kantor prodi. Digunakan untuk alokasi biaya kebersihan dan listrik.', NULL, NULL);
INSERT INTO "public"."abc_drivers" VALUES (8, 'Jumlah Dosen Homebase', 'Orang', 'RESOURCE_DRIVER', 'Jumlah dosen tetap. Pemicu biaya pengembangan SDM dan administrasi kepegawaian.', NULL, NULL);
INSERT INTO "public"."abc_drivers" VALUES (9, 'Jumlah Mata Kuliah Praktik', 'MK', 'ACTIVITY_DRIVER', 'Jumlah MK yang menggunakan Lab/GOR. Pemicu biaya perawatan alat olahraga.', NULL, NULL);
INSERT INTO "public"."abc_drivers" VALUES (10, 'Jumlah Lulusan', 'Orang', 'ACTIVITY_DRIVER', 'Digunakan untuk alokasi biaya wisuda dan pencetakan ijazah.', NULL, NULL);

-- ----------------------------
-- Table structure for 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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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');

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."abc_activities_id_seq"
OWNED BY "public"."abc_activities"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."abc_activity_allocations_id_seq"
OWNED BY "public"."abc_activity_allocations"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."abc_cost_categories_id_seq"
OWNED BY "public"."abc_cost_categories"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."abc_cost_types_id_seq"
OWNED BY "public"."abc_cost_types"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."abc_resource_assignments_id_seq"
OWNED BY "public"."abc_resource_assignments"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."activity_components_id_seq"
OWNED BY "public"."activity_components"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."akademik_jadwal_kuliah_id_seq"
OWNED BY "public"."akademik_jadwal_kuliah"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."akademik_jadwal_tim_teaching_id_seq"
OWNED BY "public"."akademik_jadwal_tim_teaching"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."akademik_matakuliah_id_seq"
OWNED BY "public"."akademik_matakuliah"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."indirect_budgets_id_seq"
OWNED BY "public"."indirect_budgets"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."migrations_id_seq"
OWNED BY "public"."migrations"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ms_academic_years_id_seq"
OWNED BY "public"."ms_academic_years"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ms_departments_id_seq"
OWNED BY "public"."ms_departments"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ms_faculties_id_seq"
OWNED BY "public"."ms_faculties"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ms_honor_rates_id_seq"
OWNED BY "public"."ms_honor_rates"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ms_labor_config_id_seq"
OWNED BY "public"."ms_labor_config"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ms_labor_rates_id_seq"
OWNED BY "public"."ms_labor_rates"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ms_menus_id_seq"
OWNED BY "public"."ms_menus"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ms_prodi_revenue_config_id_seq"
OWNED BY "public"."ms_prodi_revenue_config"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ms_ssbopt_config_id_seq"
OWNED BY "public"."ms_ssbopt_config"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ms_study_programs_id_seq"
OWNED BY "public"."ms_study_programs"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ms_unit_config_id_seq"
OWNED BY "public"."ms_unit_config"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ms_user_levels_id_seq"
OWNED BY "public"."ms_user_levels"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ref_ssbopt_clusters_id_seq"
OWNED BY "public"."ref_ssbopt_clusters"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."ref_ssbopt_components_id_seq"
OWNED BY "public"."ref_ssbopt_components"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."report_unit_costs_id_seq"
OWNED BY "public"."report_unit_costs"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."rpt_unit_costs_id_seq"
OWNED BY "public"."rpt_unit_costs"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."service_groups_id_seq"
OWNED BY "public"."service_groups"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."trans_driver_values_id_seq"
OWNED BY "public"."trans_driver_values"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."trans_resources_id_seq"
OWNED BY "public"."trans_resources"."id";

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."users_id_seq"
OWNED BY "public"."users"."id";

-- ----------------------------
-- 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");

-- ----------------------------
-- 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;
