Advertisement
alam93

Untitled

Apr 2nd, 2020
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.08 KB | None | 0 0
  1. INSERT INTO "log"."table_setting" VALUES ('16', 'akademik.ak_transkrip', 'Transkrip', 'idmk,nim', null, 'medium', null);
  2. INSERT INTO "log"."table_setting" VALUES ('17', 'master.settingsim', 'Setting SIM', 'idsetting', null, 'medium', null);
  3. INSERT INTO "log"."table_setting" VALUES ('45', 'akademik.ak_mahasiswa', 'Mahasiswa', 'nim', null, 'large', null);
  4. INSERT INTO "log"."table_setting" VALUES ('46', 'akademik.ak_matakuliah', 'Mata Kuliah', 'idkurikulum,idmk', null, 'medium', null);
  5. INSERT INTO "log"."table_setting" VALUES ('47', 'akademik.ak_kurikulum', 'Kurikulum', 'idkurikulum,idmk,idunit', null, 'small', null);
  6. INSERT INTO "log"."table_setting" VALUES ('48', 'akademik.ak_kelas', 'Kelas Kuliah', 'idperiode,idunit,idkurikulum,idmk', null, 'medium', null);
  7. INSERT INTO "log"."table_setting" VALUES ('49', 'akademik.ak_perwalian', 'Perwalian (Status Mahasiswa)', 'idperiode,nim', null, 'medium', null);
  8. INSERT INTO "log"."table_setting" VALUES ('50', 'akademik.ak_krs', 'KRS Mahasiswa', 'idkelas,nim', 'm.nama, k.idperiode,u.namaunit,r.idkurikulum,r.idmk,r.namamk,k.namakelas', 'small', 'left join akademik.ak_kelas k on k.idkelas::text = l.pk_value1
  9. left join akademik.ak_kurikulum r using(idmk,idkurikulum,idunit)
  10. left join ref.ms_unit u on u.idunit = k.idunit
  11. left join akademik.ak_mahasiswa m on m.nim = l.pk_value2');
  12. INSERT INTO "log"."table_setting" VALUES ('51', 'ref.ms_unit', 'Unit Kerja', 'idunit', null, 'large', null);
  13. INSERT INTO "log"."table_setting" VALUES ('52', 'gate.sc_unit', 'Unit Kerja Sistem', 'idsatker', null, 'small', null);
  14. INSERT INTO "log"."table_setting" VALUES ('53', 'gate.sc_user', 'Pengguna', 'userid,username', null, 'small', null);
  15. INSERT INTO "log"."table_setting" VALUES ('55', 'spmb.pd_prodipendaftar', 'Prodi Pilihan Pendaftar', 'idprodipendaftar,idpendaftar,idsebaranprodi', null, 'small', null);
  16. INSERT INTO "log"."table_setting" VALUES ('56', 'spmb.pd_periodedaftar', 'Periode Pendaftaran', 'idperiodedaftar,idperiode,idgelombang,idjalurpendaftaran,idsistemkuliah', null, 'medium', null);
  17. INSERT INTO "log"."table_setting" VALUES ('57', 'spmb.pd_pendaftar', 'Pendaftar', 'idpendaftar,kodependaftar', null, 'large', null);
  18. INSERT INTO "log"."table_setting" VALUES ('60', 'keuangan.tg_tagihan', 'Tagihan', 'idtagihan,idtransaksi', null, 'small', null);
  19. INSERT INTO "log"."table_setting" VALUES ('61', 'keuangan.tg_tarif', 'Tarif Tagihan', 'idtarif,idjenisakun,idperiode,idgelombang,idjalurpendaftaran,idsistemkuliah,idunit', null, 'small', null);
  20. INSERT INTO "log"."table_setting" VALUES ('62', 'keuangan.va_transaksi', 'VA Transaksi', 'idva,kodeva', null, 'small', null);
  21. INSERT INTO "log"."table_setting" VALUES ('63', 'keuangan.va_tagihan', 'Tagihan VA', 'idva,idtagihan', null, 'small', null);
  22. INSERT INTO "log"."table_setting" VALUES ('64', 'keuangan.va_pembayaran', 'Pembayaran VA', 'idvapembayaran,idva', null, 'small', null);
  23. INSERT INTO "log"."table_setting" VALUES ('65', 'keuangan.pm_pembayaran', 'Pembayaran', 'idpembayaran,idtransaksi,idtagihan', null, 'small', null);
  24. INSERT INTO "log"."table_setting" VALUES ('66', 'keuangan.tr_transaksi', 'Transaksi', 'idtransaksi,kodetransaksi,nim,idpendaftar', null, 'small', null);
  25. INSERT INTO "log"."table_setting" VALUES ('67', 'keuangan.st_aturan', 'Aturan Akademik', 'idaturan,idjenisakun', null, 'small', null);
  26. INSERT INTO "log"."table_setting" VALUES ('69', 'gate.sc_userrole', 'ROLE USER', 'idrole,userid', null, 'small', null);
  27. INSERT INTO "log"."table_setting" VALUES ('70', 'spmb.pd_nilaipendaftar', 'Nilai Pendaftar', 'idpendaftar', null, 'small', null);
  28. INSERT INTO "log"."table_setting" VALUES ('72', 'spmb.pd_sebaranprodi', 'Sebaran Prodi Pendaftaran', 'idperiodedaftar', null, 'small', null);
  29. INSERT INTO "log"."table_setting" VALUES ('74', 'spmb.pd_syaratpendaftar', 'Syarat pendaftar', 'idpendaftar,idsyarat', null, 'small', null);
  30. INSERT INTO "log"."table_setting" VALUES ('75', 'spmb.pd_seleksipendaftar', 'Seleksi Pendaftar', 'idpendaftar,idjenisseleksi,nilaiseleksi', null, 'small', null);
  31. INSERT INTO "log"."table_setting" VALUES ('76', 'keuangan.tr_log', 'Transaksi Log', 'idtranslog,jenistagihan', null, 'small', null);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement