/*
 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: 26/04/2026 09:07:29
*/


-- ----------------------------
-- Table structure for abc_cost_categories
-- ----------------------------
DROP TABLE IF EXISTS "public"."abc_cost_categories";
CREATE TABLE "public"."abc_cost_categories" (
  "id" int8 NOT NULL DEFAULT nextval('abc_cost_categories_id_seq'::regclass),
  "category_code" varchar(20) COLLATE "pg_catalog"."default",
  "category_name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "description" text COLLATE "pg_catalog"."default",
  "created_at" timestamp(6),
  "updated_at" timestamp(6),
  "deleted_at" timestamp(6),
  "cost_type_id" int8,
  "allowed_level_ids" varchar(255) COLLATE "pg_catalog"."default",
  "scope_level" varchar(50) COLLATE "pg_catalog"."default" DEFAULT 'ALL'::character varying,
  "report_group" varchar(50) COLLATE "pg_catalog"."default",
  "parent_id" int8
)
;

-- ----------------------------
-- Records of abc_cost_categories
-- ----------------------------
INSERT INTO "public"."abc_cost_categories" VALUES (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 (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 (20, 'TRP-001', 'Perjalanan Dinas Akademik', 'Seminar, Konferensi Dosen.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 1, NULL, 'PRODI', NULL, 19);
INSERT INTO "public"."abc_cost_categories" VALUES (25, 'MNT-002', 'Pemeliharaan Alat Lab & Pembelajaran', 'Service mikroskop, mesin, komputer lab.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 1, NULL, 'PRODI', NULL, 23);
INSERT INTO "public"."abc_cost_categories" VALUES (1, 'GRP-01', 'Belanja Personil (Gaji & Honor)', 'Gaji pokok, tunjangan, dan honorarium dosen serta tendik.', NULL, NULL, NULL, NULL, NULL, 'GROUP', NULL, NULL);
INSERT INTO "public"."abc_cost_categories" VALUES (7, 'GRP-02', 'Bahan Habis Pakai (BHP) & ATK', 'Bahan operasional pengajaran dan kantor.', NULL, NULL, NULL, NULL, NULL, 'GROUP', NULL, NULL);
INSERT INTO "public"."abc_cost_categories" VALUES (13, 'GRP-03', 'Jasa, Utilitas & Langganan', 'Listrik, Air, Internet, dan Jasa Pihak Ketiga.', NULL, NULL, NULL, NULL, NULL, 'GROUP', NULL, NULL);
INSERT INTO "public"."abc_cost_categories" VALUES (19, 'GRP-04', 'Perjalanan Dinas', 'Transportasi dan akomodasi kegiatan dinas.', NULL, NULL, NULL, NULL, NULL, 'GROUP', NULL, NULL);
INSERT INTO "public"."abc_cost_categories" VALUES (23, 'GRP-05', 'Pemeliharaan & Aset', 'Service dan perbaikan aset.', NULL, NULL, NULL, NULL, NULL, 'GROUP', NULL, NULL);
INSERT INTO "public"."abc_cost_categories" VALUES (28, 'GRP-06', 'Riset, Mutu & Kemahasiswaan', 'Biaya pendukung Tridharma dan kemahasiswaan (DRPM/Direktorat).', NULL, NULL, NULL, NULL, NULL, 'GROUP', NULL, NULL);
INSERT INTO "public"."abc_cost_categories" VALUES (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 (31, 'SUP-003', 'Akreditasi & Penjaminan Mutu', 'Biaya visitasi asesor LAM/BAN-PT.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 1, NULL, 'PRODI', NULL, 28);
INSERT INTO "public"."abc_cost_categories" VALUES (33, 'HON-001', 'Biaya Pengajaran & Honorarium', NULL, NULL, NULL, NULL, 1, NULL, 'PRODI', NULL, 1);
INSERT INTO "public"."abc_cost_categories" VALUES (22, 'TRP-003', 'Transport Lokal', 'Transport dalam kota.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'FACULTY', NULL, 19);
INSERT INTO "public"."abc_cost_categories" VALUES (10, 'BHP-003', 'ATK Perkantoran', 'Kertas surat, map, toner printer kantor.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'FACULTY', NULL, 7);
INSERT INTO "public"."abc_cost_categories" VALUES (12, 'BHP-005', 'Konsumsi Rapat & Tamu', 'Snack dan makan rapat dinas.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'FACULTY', NULL, 7);
INSERT INTO "public"."abc_cost_categories" VALUES (11, 'BHP-004', 'Bahan Kebersihan & Rumah Tangga', 'Sabun, tisu, perlengkapan pantry.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 7);
INSERT INTO "public"."abc_cost_categories" VALUES (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 (18, 'UTL-005', 'Langganan Jurnal & E-Library', 'Akses jurnal internasional.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 13);
INSERT INTO "public"."abc_cost_categories" VALUES (21, 'TRP-002', 'Perjalanan Dinas Manajemen', 'Rapat pimpinan, koordinasi pusat.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 19);
INSERT INTO "public"."abc_cost_categories" VALUES (24, 'MNT-001', 'Pemeliharaan Gedung & Bangunan', 'Renovasi ringan, cat, atap.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 23);
INSERT INTO "public"."abc_cost_categories" VALUES (26, 'MNT-003', 'Pemeliharaan Kendaraan Dinas', 'Service mobil/motor operasional.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 23);
INSERT INTO "public"."abc_cost_categories" VALUES (27, 'MNT-004', 'Pemeliharaan Software & Server', 'Lisensi Cpanel, Zoom, Google Workspace.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 23);
INSERT INTO "public"."abc_cost_categories" VALUES (29, 'SUP-001', 'Hibah Penelitian & Pengabdian (DRPM)', 'Dana riset internal dosen.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 28);
INSERT INTO "public"."abc_cost_categories" VALUES (30, 'SUP-002', 'Kegiatan Ormawa & Lomba', 'Pendanaan BEM/DPM/UKM.', '2026-01-14 08:55:24', '2026-01-14 08:55:24', NULL, 2, NULL, 'UNIVERSITY', NULL, 28);
INSERT INTO "public"."abc_cost_categories" VALUES (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 (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);

-- ----------------------------
-- Primary Key structure for table abc_cost_categories
-- ----------------------------
ALTER TABLE "public"."abc_cost_categories" ADD CONSTRAINT "pk_abc_cost_categories" PRIMARY KEY ("id");

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