FEEDER PDDIKTI
PDPT adalah kependekan dari Pangkalan Data Perguruan Tinggi, adalah Kumpulan Data penyelenggaraan pendidikan tinggi seluruh perguruan tinggi yang terintegrasi secara nasional. Setiap PT mengirimkan laporan per Semester melalui FEEDER PDDIKTI. Ada 2 cara untuk memasukkan data ke FEEDER PDDIKTI, yaitu:
- Manual melalui web FEEDER PDDIKTI
- Impor dari basis data yang sudah ada di Institusi melalui web service FEEDER PDDIKTI
Apabila institusi sudah memiliki SIAKAD (Sistem Informasi Akademik) atau SIMPTT (Sistem Informasi Manajemen Perguruan Tinggi Terpadu), maka cara kedua adalah cara yang paling mudah dan masuk akal untuk digunakan. Namun, diperlukan sebuah tools untuk melakukan hal tersebut karena FEEDER PDDIKTI tidak menyediakan fasilitas untuk keperluan tersebut.
Struktur Data
Struktur data yang ditampilkan pada tulisan ini adalah hasil eksekusi web service yang disediakan oleh FEEDER PDDIKTI itu sendiri. Data yang ditampilkan merupakan hasil eksekusi dari fungsi $ws->GetDictionaryAllTable(); yang merupakan bagian dari Injector Feeder PDDIKTI SAY.
Update
http://pdsi.unisayogya.ac.id/struktur-data-feeder-pddikti-20160521
Daftar Tabel
| table | jenis | keterangan |
| agama | Ref | Agama |
| bentuk_pendidikan | Ref | Bentuk Pendidikan |
| ikatan_kerja_dosen | Ref | Ikatan Kerja Dosen |
| jabfung | Ref | Jabatan Fungsional |
| jenis_evaluasi | Ref | Jenis Evaluasi |
| jenis_keluar | Ref | Jenis Keluar |
| jenis_pendaftaran | Ref | Jenis Pendaftaran Mahasiswa |
| jenis_sert | Ref | Jenis Sertifikasi |
| jenis_sms | Ref | Jenis Program Studi |
| jenis_subst | Ref | Jenis Substansi |
| jenjang_pendidikan | Ref | Jejang Pendidikan |
| jurusan | Ref | Jurusan |
| kebutuhan_khusus | Ref | Kebutuhan Khusus |
| lembaga_pengangkat | Ref | Lembaga Pengangkat |
| level_wilayah | Ref | Level Wilayah |
| negara | Ref | Negara |
| pangkat_golongan | Ref | Pangkat Golongan |
| pekerjaan | Ref | Pekerjaan |
| penghasilan | Ref | Penghasilan |
| semester | Ref | Semester |
| status_keaktifan_pegawai | Ref | Status Keaktifan Pegawai |
| status_kepegawaian | Ref | Status Kepegawaian |
| status_mahasiswa | Ref | Status Mahasiswa |
| tahun_ajaran | Ref | Tahun Ajaran |
| wilayah | Ref | Wilayah |
| ajar_dosen | Data | Dosen Mengajar |
| bobot_nilai | Data | Bobot Nilai |
| daya_tampung | Data | Kapasitas mahasiswa baru |
| dosen | Data | Data dosen nasional. Tidak boleh menambah dan menghapus. Hanya dari Forlap |
| dosen_pt | Data | Dosen perguruan tinggi. Penambahan dan Perubahan data hanya dari Forlap |
| kelas_kuliah | Data | Kelas Perkuliahan. Menyimpan jadwal perkuliahan yang di buka, dosen pengajar, serta peserta kelas / KRS mahasiswa setiap periode |
| kuliah_mahasiswa | Data | Aktivitas perkuliahan mahasiswa |
| kurikulum | Data | Kurikulum per prodi |
| mahasiswa | Data | Data mahasiswa nasional |
| mahasiswa_pt | Data | Mahasiswa perguruan tinggi |
| mata_kuliah | Data | Mata kuliah per program studi |
| mata_kuliah_kurikulum | Data | Mata kuliah per kurikulum |
| satuan_pendidikan | Data | Perguruan Tinggi. Perubahan data hanya dari Forlap |
| sms | Data | Program Studi. Perubahan data hanya dari Forlap |
| substansi_kuliah | Data | Substansi kuliah |
| nilai | Data | Nilai mahasiswa per kelas per periode |
| nilai_transfer | Data | Nilai Transfer |
Terdapat 42 baris
Deskripsi Tabel agama
| column_name | pk | type | not_null | desc |
| id_agama | 1 | smallint | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_agama | character varying(25) | 1 | Nama Agama |
Terdapat 2 baris
Deskripsi Tabel bentuk_pendidikan
| column_name | pk | type | not_null | desc |
| id_bp | 1 | smallint | 1 | |
| nm_bp | character varying(50) | 1 | ||
| a_jenj_paud | numeric(1,0) | 1 | ||
| a_jenj_tk | numeric(1,0) | 1 | ||
| a_jenj_sd | numeric(1,0) | 1 | ||
| a_jenj_smp | numeric(1,0) | 1 | ||
| a_jenj_sma | numeric(1,0) | 1 | ||
| a_jenj_tinggi | numeric(1,0) | 1 | ||
| dir_bina | character varying(40) | |||
| a_aktif | numeric(1,0) | 1 |
Terdapat 10 baris
Deskripsi Tabel ikatan_kerja_dosen
| column_name | pk | type | not_null | desc |
| id_ikatan_kerja | 1 | character(1) | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_ikatan_kerja | character varying(50) | 1 | ||
| ket_ikatan_kerja | character varying(150) | 1 |
Terdapat 3 baris
Deskripsi Tabel jabfung
| column_name | pk | type | not_null | desc |
| id_jabfung | 1 | numeric(2,0) | 1 | |
| nm_jabfung | character varying(30) | 1 |
Terdapat 2 baris
Deskripsi Tabel jenis_evaluasi
| column_name | pk | type | not_null | desc |
| id_jns_eval | 1 | smallint | 1 | |
| nm_jns_eval | character varying(25) | 1 | ||
| ket_jns_eval | character varying(100) |
Terdapat 3 baris
Deskripsi Tabel jenis_keluar
| column_name | pk | type | not_null | desc |
| id_jns_keluar | 1 | character(1) | 1 | Primary Key, kosongkan ketika mode Tambah |
| ket_keluar | character varying(40) | 1 | ||
| a_pd | numeric(1,0) | 1 | ||
| a_ptk | numeric(1,0) | 1 |
Terdapat 4 baris
Deskripsi Tabel jenis_pendaftaran
| column_name | pk | type | not_null | desc |
| id_jns_daftar | 1 | numeric(1,0) | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_jns_daftar | character varying(20) | 1 | ||
| u_daftar_sekolah | numeric(1,0) | 1 | ||
| u_daftar_rombel | numeric(1,0) | 1 |
Terdapat 4 baris
Deskripsi Tabel jenis_sert
| column_name | pk | type | not_null | desc |
| id_jns_sert | 1 | numeric(3,0) | 1 | |
| id_kk | integer | 1 | Primary Key, kosongkan ketika mode Tambah | |
| nm_jns_sert | character varying(30) | 1 | ||
| u_prof_guru | numeric(1,0) | 1 | ||
| u_kepsek | numeric(1,0) | 1 | ||
| u_laboran | numeric(1,0) | 1 | ||
| u_prof_dosen | numeric(1,0) | 1 |
Terdapat 7 baris
Deskripsi Tabel jenis_sms
| column_name | pk | type | not_null | desc |
| id_jns_sms | 1 | numeric(2,0) | 1 | |
| nm_jns_sms | character varying(40) | 1 |
Terdapat 2 baris
Deskripsi Tabel jenis_subst
| column_name | pk | type | not_null | desc |
| id_jns_subst | 1 | character(5) | 1 | |
| nm_jns_subst | character varying(50) | 1 |
Terdapat 2 baris
Deskripsi Tabel jenjang_pendidikan
| column_name | pk | type | not_null | desc |
| id_jenj_didik | 1 | numeric(2,0) | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_jenj_didik | character varying(25) | 1 | ||
| u_jenj_lemb | numeric(1,0) | 1 | ||
| u_jenj_org | numeric(1,0) | 1 |
Terdapat 4 baris
Deskripsi Tabel jurusan
| column_name | pk | type | not_null | desc |
| id_jur | 1 | character(10) | 1 | |
| nm_jur | character varying(60) | 1 | ||
| nm_intl_jur | character varying(60) | |||
| u_sma | numeric(1,0) | 1 | ||
| u_smk | numeric(1,0) | 1 | ||
| u_pt | numeric(1,0) | 1 | ||
| u_slb | numeric(1,0) | 1 | ||
| id_jenj_didik | numeric(2,0) | 1 | Primary Key, kosongkan ketika mode Tambah | |
| id_induk_jurusan | character(10) | |||
| id_kel_bidang | character varying(20) | 1 |
Terdapat 10 baris
Deskripsi Tabel kebutuhan_khusus
| column_name | pk | type | not_null | desc | default |
| id_kk | 1 | integer | 1 | Primary Key, kosongkan ketika mode Tambah | |
| nm_kk | character varying(40) | 1 | |||
| a_kk_a | numeric(1,0) | 1 | |||
| a_kk_b | numeric(1,0) | 1 | |||
| a_kk_c | numeric(1,0) | 1 | |||
| a_kk_c1 | numeric(1,0) | 1 | |||
| a_kk_d | numeric(1,0) | 1 | |||
| a_kk_d1 | numeric(1,0) | 1 | |||
| a_kk_e | numeric(1,0) | 1 | |||
| a_kk_f | numeric(1,0) | 1 | |||
| a_kk_h | numeric(1,0) | 1 | |||
| a_kk_i | numeric(1,0) | 1 | |||
| a_kk_j | numeric(1,0) | 1 | |||
| a_kk_k | numeric(1,0) | 1 | |||
| a_kk_n | numeric(1,0) | 1 | |||
| a_kk_o | numeric(1,0) | 1 | |||
| a_kk_p | numeric(1,0) | 1 | |||
| a_kk_q | numeric(1,0) | 1 | |||
| u_lemb | numeric(1,0) | 1 | 1 | ||
| u_ptk | numeric(1,0) | 1 | 1 | ||
| u_pd | numeric(1,0) | 1 | 1 |
Terdapat 21 baris
Deskripsi Tabel lembaga_pengangkat
| column_name | pk | type | not_null | desc |
| id_lemb_angkat | 1 | numeric(2,0) | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_lemb_angkat | character varying(80) | 1 |
Terdapat 2 baris
Deskripsi Tabel level_wilayah
| column_name | pk | type | not_null | desc |
| id_level_wil | 1 | smallint | 1 | |
| nm_level_wilayah | character varying(15) |
Terdapat 2 baris
Deskripsi Tabel negara
| column_name | pk | type | not_null | desc |
| id_negara | 1 | character(2) | 1 | |
| nm_negara | character varying(45) | 1 | ||
| a_ln | numeric(1,0) | 1 |
Terdapat 3 baris
Deskripsi Tabel pangkat_golongan
| column_name | pk | type | not_null | desc |
| id_pangkat_gol | 1 | numeric(2,0) | 1 | Primary Key, kosongkan ketika mode Tambah |
| kode_gol | character varying(5) | 1 | ||
| nm_pangkat | character varying(20) | 1 |
Terdapat 3 baris
Deskripsi Tabel pekerjaan
| column_name | pk | type | not_null | desc |
| id_pekerjaan | 1 | integer | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_pekerjaan | character varying(25) |
Terdapat 2 baris
Deskripsi Tabel penghasilan
| column_name | pk | type | not_null | desc |
| id_penghasilan | 1 | integer | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_penghasilan | character varying(40) | 1 | ||
| batas_bawah | integer | 1 | ||
| batas_atas | integer | 1 |
Terdapat 4 baris
Deskripsi Tabel semester
| column_name | pk | type | not_null | desc |
| id_smt | 1 | character(5) | 1 | Primary Key, kosongkan ketika mode Tambah |
| id_thn_ajaran | numeric(4,0) | 1 | Primary Key, kosongkan ketika mode Tambah | |
| nm_smt | character varying(20) | 1 | ||
| smt | numeric(1,0) | 1 | 1: Ganjil, 2: Genap | |
| a_periode_aktif | numeric(1,0) | 1 | ||
| tgl_mulai | date | 1 | yyyy-mm-dd | |
| tgl_selesai | date | 1 | yyyy-mm-dd |
Terdapat 7 baris
Deskripsi Tabel status_keaktifan_pegawai
| column_name | pk | type | not_null | desc |
| id_stat_aktif | 1 | numeric(2,0) | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_stat_aktif | character varying(30) | 1 |
Terdapat 2 baris
Deskripsi Tabel status_kepegawaian
| column_name | pk | type | not_null | desc |
| id_stat_pegawai | 1 | smallint | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_stat_pegawai | character varying(30) | 1 |
Terdapat 2 baris
Deskripsi Tabel status_mahasiswa
| column_name | pk | type | not_null | desc |
| id_stat_mhs | 1 | character(1) | 1 | |
| nm_stat_mhs | character varying(50) | 1 | ||
| ket_stat_mhs | character varying(50) |
Terdapat 3 baris
Deskripsi Tabel tahun_ajaran
| column_name | pk | type | not_null | desc |
| id_thn_ajaran | 1 | numeric(4,0) | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_thn_ajaran | character varying(10) | 1 | ||
| a_periode_aktif | numeric(1,0) | 1 | ||
| tgl_mulai | date | 1 | yyyy-mm-dd | |
| tgl_selesai | date | 1 | yyyy-mm-dd |
Terdapat 5 baris
Deskripsi Tabel wilayah
| column_name | pk | type | not_null | desc |
| id_wil | 1 | character(8) | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_wil | character varying(50) | |||
| asal_wil | character(8) | |||
| kode_bps | character(7) | |||
| kode_dagri | character(7) | |||
| kode_keu | character varying(10) | |||
| id_induk_wilayah | character(8) | |||
| id_level_wil | smallint | 1 | ||
| id_negara | character(2) | 1 |
Terdapat 9 baris
Deskripsi Tabel ajar_dosen
| column_name | pk | type | not_null | desc |
| id_ajar | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah |
| id_reg_ptk | uuid | 1 | ID Dosen. Web Service: GetRecordset:dosen_pt | |
| id_subst | uuid | ID Substansi Kuliah. Web Service: GetRecordset:substansi_kuliah | ||
| id_kls | uuid | 1 | ID Kelas. Web Service: GetRecordset:kelas_kuliah | |
| sks_subst_tot | numeric(5,2) | 1 | ||
| sks_tm_subst | numeric(5,2) | 1 | ||
| sks_prak_subst | numeric(5,2) | 1 | ||
| sks_prak_lap_subst | numeric(5,2) | 1 | ||
| sks_sim_subst | numeric(5,2) | 1 | ||
| jml_tm_renc | numeric(2,0) | 1 | ||
| jml_tm_real | numeric(2,0) | |||
| id_jns_eval | smallint | 1 | Web Service: GetRecordset:jenis_evaluasi |
Terdapat 12 baris
Deskripsi Tabel bobot_nilai
| column_name | pk | type | not_null | desc |
| kode_bobot_nilai | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah |
| id_sms | uuid | 1 | ID SMS (Satuan Manajemen Sumberdaya). Web Service: GetRecordset:sms | |
| nilai_huruf | character(3) | 1 | ||
| bobot_nilai_min | numeric(5,2) | 1 | ||
| bobot_nilai_maks | numeric(5,2) | 1 | ||
| nilai_indeks | numeric(4,2) | |||
| tgl_mulai_efektif | date | 1 | yyyy-mm-dd | |
| tgl_akhir_efektif | date | yyyy-mm-dd |
Terdapat 8 baris
Deskripsi Tabel daya_tampung
| column_name | pk | type | not_null | desc |
| id_smt | 1 | character(5) | 1 | ID Semester. Web Service: GetRecordset:semester |
| id_sms | 1 | uuid | 1 | ID SMS (Satuan Manajemen Sumberdaya). Web Service: GetRecordset:sms |
| target_mhs_baru | numeric(6,0) | |||
| calon_ikut_seleksi | numeric(6,0) | |||
| calon_lulus_seleksi | numeric(6,0) | |||
| daftar_sbg_mhs | numeric(6,0) | |||
| pst_undur_diri | numeric(5,0) | |||
| tgl_awal_kul | date | yyyy-mm-dd | ||
| tgl_akhir_kul | date | yyyy-mm-dd | ||
| jml_mgu_kul | numeric(2,0) | |||
| metode_kul | character(1) | |||
| metode_kul_eks | character(1) |
Terdapat 12 baris
Deskripsi Tabel dosen
| column_name | pk | type | not_null | desc |
| id_ptk | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah |
| id_blob | uuid | |||
| id_ikatan_kerja | character(1) | 1 | Web Service: GetRecordset:ikatan_kerja_dosen | |
| nm_ptk | character varying(60) | 1 | Nama Pengajar | |
| nidn | character(10) | |||
| nip | character varying(18) | |||
| jk | character(1) | 1 | L: Laki-laki, P: Perempuan, *: Belum ada informasi | |
| tmpt_lahir | character varying(32) | 1 | ||
| tgl_lahir | date | 1 | yyyy-mm-dd | |
| nik | character(16) | 1 | Nomor Induk Kependudukan | |
| niy_nigk | character varying(30) | |||
| nuptk | character(16) | |||
| id_stat_pegawai | smallint | 1 | Web Service: GetRecordset:status_kepegawaian | |
| id_jns_ptk | numeric(2,0) | 1 | Web Service: GetRecordset:jenis_ptk | |
| id_bid_pengawas | integer | – | ||
| id_agama | smallint | 1 | Web Service: GetRecordset:agama | |
| jln | character varying(80) | Jalan | ||
| rt | numeric(2,0) | |||
| rw | numeric(2,0) | |||
| nm_dsn | character varying(50) | Nama Dusun | ||
| ds_kel | character varying(50) | 1 | ||
| id_wil | character(8) | 1 | ID Wilayah. Web Service: GetRecordset:wilayah | |
| kode_pos | character(5) | |||
| no_tel_rmh | character varying(20) | |||
| no_hp | character varying(20) | |||
| character varying(50) | ||||
| id_sp | uuid | 1 | ID Perguruan Tinggi. Web Service: GetRecordset:satuan_pendidikan | |
| id_stat_aktif | numeric(2,0) | 1 | Web Service: GetRecordset:status_keaktifan_pegawai | |
| sk_cpns | character varying(40) | |||
| tgl_sk_cpns | date | yyyy-mm-dd | ||
| sk_angkat | character varying(40) | |||
| tmt_sk_angkat | date | yyyy-mm-dd | ||
| id_lemb_angkat | numeric(2,0) | 1 | Web Service: GetRecordset:lembaga_pengangkat | |
| id_pangkat_gol | numeric(2,0) | Web Service: GetRecordset:pangkat_golongan | ||
| id_keahlian_lab | smallint | Web Service: GetRecordset:keahlian_lab | ||
| id_sumber_gaji | numeric(2,0) | 1 | Web Service: GetRecordset:sumber_gaji | |
| nm_ibu_kandung | character varying(60) | 1 | ||
| stat_kawin | numeric(1,0) | 1 | 0: Belum Menikah, 1: Sudah Menikah | |
| nm_suami_istri | character varying(60) | |||
| nip_suami_istri | character(18) | |||
| id_pekerjaan_suami_istri | integer | 1 | Web Service: GetRecordset:pekerjaan | |
| tmt_pns | date | yyyy-mm-dd | ||
| a_lisensi_kepsek | numeric(1,0) | |||
| jml_sekolah_binaan | smallint | |||
| a_diklat_awas | numeric(1,0) | |||
| akta_ijin_ajar | character(1) | |||
| nira | character(30) | |||
| stat_data | integer | |||
| mampu_handle_kk | integer | 1 | ||
| a_braille | numeric(1,0) | Mampu Menghandle Braile ?. 0: Tidak, 1: Ya | ||
| a_bhs_isyarat | numeric(1,0) | Mampu Menghandle Bahasa Isyarat ?. 0: Tidak, 1: Ya | ||
| npwp | character(15) | Nomor Pokok Wajib Pajak | ||
| kewarganegaraan | character(2) | 1 |
Terdapat 53 baris
Deskripsi Tabel dosen_pt
| column_name | pk | type | not_null | desc |
| id_reg_ptk | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah |
| id_ptk | uuid | 1 | ID Dosen. Web Service: GetRecordset:dosen | |
| id_sp | uuid | 1 | ID Perguruan Tinggi. Web Service: GetRecordset:satuan_pendidikan | |
| id_thn_ajaran | numeric(4,0) | 1 | Web Service: GetRecordset:tahun_ajaran | |
| id_sms | uuid | ID SMS (Satuan Manajemen Sumberdaya). Web Service: GetRecordset:sms | ||
| no_srt_tgs | character varying(40) | 1 | ||
| tgl_srt_tgs | date | 1 | yyyy-mm-dd | |
| tmt_srt_tgs | date | 1 | yyyy-mm-dd | |
| a_sp_homebase | numeric(1,0) | 1 | ||
| a_aktif_bln_1 | numeric(1,0) | 1 | ||
| a_aktif_bln_2 | numeric(1,0) | 1 | ||
| a_aktif_bln_3 | numeric(1,0) | 1 | ||
| a_aktif_bln_4 | numeric(1,0) | 1 | ||
| a_aktif_bln_5 | numeric(1,0) | 1 | ||
| a_aktif_bln_6 | numeric(1,0) | 1 | ||
| a_aktif_bln_7 | numeric(1,0) | 1 | ||
| a_aktif_bln_8 | numeric(1,0) | 1 | ||
| a_aktif_bln_9 | numeric(1,0) | 1 | ||
| a_aktif_bln_10 | numeric(1,0) | 1 | ||
| a_aktif_bln_11 | numeric(1,0) | 1 | ||
| a_aktif_bln_12 | numeric(1,0) | 1 | ||
| id_jns_keluar | character(1) | Web Service: GetRecordset:jenis_keluar | ||
| tgl_ptk_keluar | date | yyyy-mm-dd |
Terdapat 23 baris
Deskripsi Tabel kelas_kuliah
| column_name | pk | type | not_null | desc |
| id_kls | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah |
| id_sms | uuid | 1 | ID SMS (Satuan Manajemen Sumberdaya). Web Service: GetRecordset:sms | |
| id_smt | character(5) | 1 | ID Semester. Web Service: GetRecordset:semester | |
| id_mk | uuid | 1 | ID Mata Kuliah. Web Service: GetRecordset:mata_kuliah | |
| nm_kls | character varying(5) | 1 | ||
| sks_mk | numeric(2,0) | |||
| sks_tm | numeric(2,0) | |||
| sks_prak | numeric(2,0) | |||
| sks_prak_lap | numeric(2,0) | |||
| sks_sim | numeric(2,0) | |||
| bahasan_case | character varying(200) | |||
| tgl_mulai_koas | date | yyyy-mm-dd | ||
| tgl_selesai_koas | date | yyyy-mm-dd | ||
| id_mou | uuid | ID Mou. Web Service: GetRecordset:mou | ||
| a_selenggara_pditt | numeric(1,0) | 1 | ||
| kuota_pditt | numeric(4,0) | 1 | ||
| a_pengguna_pditt | numeric(1,0) | 1 | ||
| id_kls_pditt | uuid |
Terdapat 18 baris
Deskripsi Tabel kuliah_mahasiswa
| column_name | pk | type | not_null | desc |
| id_smt | 1 | character(5) | 1 | ID Semester. Web Service: GetRecordset:semester |
| id_reg_pd | 1 | uuid | 1 | Web Service: GetRecordset:mahasiswa_pt |
| ips | double precision | |||
| sks_smt | numeric(3,0) | |||
| ipk | double precision | Indeks Prestasi Kumulatif | ||
| sks_total | numeric(3,0) | |||
| id_stat_mhs | character(1) | 1 |
Terdapat 7 baris
Deskripsi Tabel kurikulum
| column_name | pk | type | not_null | desc | default |
| id_kurikulum_sp | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah | |
| nm_kurikulum_sp | character varying(60) | 1 | |||
| jml_sem_normal | numeric(2,0) | 1 | 8 | ||
| jml_sks_lulus | numeric(3,0) | 1 | |||
| jml_sks_wajib | numeric(3,0) | 1 | |||
| jml_sks_pilihan | numeric(3,0) | 1 | |||
| id_sms | uuid | 1 | ID SMS (Satuan Manajemen Sumberdaya). Web Service: GetRecordset:sms | ||
| id_jenj_didik | numeric(2,0) | 1 | ID jenjang pendidikan. Web Service: GetRecordset:jenjang_pendidikan | ||
| id_smt_berlaku | character(5) | 1 | ID Semester. Web Service: GetRecordset:semester |
Terdapat 9 baris
Deskripsi Tabel mahasiswa
| column_name | pk | type | not_null | desc |
| id_pd | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_pd | character varying(60) | Nama Mahasiswa | ||
| jk | character(1) | 1 | L: Laki-laki, P: Perempuan, *: Belum ada informasi | |
| nisn | character(10) | Nomor Induk Siswa Nasional | ||
| nik | character(16) | Nomor Induk Kependudukan | ||
| tmpt_lahir | character varying(32) | |||
| tgl_lahir | date | 1 | yyyy-mm-dd | |
| id_agama | smallint | 1 | Web Service: GetRecordset:agama | |
| id_kk | integer | 1 | Default 0 | |
| id_sp | uuid | 1 | ID Perguruan Tinggi. Web Service: GetRecordset:satuan_pendidikan | |
| jln | character varying(80) | Jalan | ||
| rt | numeric(2,0) | |||
| rw | numeric(2,0) | |||
| nm_dsn | character varying(50) | Nama Dusun | ||
| ds_kel | character varying(50) | 1 | ||
| id_wil | character(8) | 1 | ID Wilayah. Web Service: GetRecordset:wilayah | |
| kode_pos | character(5) | |||
| id_jns_tinggal | numeric(2,0) | Web Service: GetRecordset:jenis_tinggal | ||
| id_alat_transport | numeric(2,0) | Web Service: GetRecordset:alat_transport | ||
| telepon_rumah | character varying(20) | |||
| telepon_seluler | character varying(20) | |||
| character varying(50) | ||||
| a_terima_kps | numeric(1,0) | 1 | 0: Bukan penerima KPS, 1: Penerima KPS | |
| no_kps | character varying(40) | Nomor KPS (KARTU PERLINDUNGAN SOSIAL) | ||
| stat_pd | character(1) | 1 | A: , C: , D: , L: , P: , K: , N: , G: , X: | |
| nm_ayah | character varying(60) | |||
| tgl_lahir_ayah | date | yyyy-mm-dd | ||
| id_jenjang_pendidikan_ayah | numeric(2,0) | Web Service: GetRecordset:jenjang_pendidikan | ||
| id_pekerjaan_ayah | integer | Web Service: GetRecordset:pekerjaan | ||
| id_penghasilan_ayah | integer | Web Service: GetRecordset:penghasilan | ||
| id_kebutuhan_khusus_ayah | integer | 1 | Default 0 | |
| nm_ibu_kandung | character varying(60) | 1 | ||
| tgl_lahir_ibu | date | yyyy-mm-dd | ||
| id_jenjang_pendidikan_ibu | numeric(2,0) | Web Service: GetRecordset:jenjang_pendidikan | ||
| id_penghasilan_ibu | integer | Web Service: GetRecordset:penghasilan | ||
| id_pekerjaan_ibu | integer | Web Service: GetRecordset:pekerjaan | ||
| id_kebutuhan_khusus_ibu | integer | 1 | Default 0 | |
| nm_wali | character varying(30) | |||
| tgl_lahir_wali | date | yyyy-mm-dd | ||
| id_jenjang_pendidikan_wali | numeric(2,0) | Web Service: GetRecordset:jenjang_pendidikan | ||
| id_pekerjaan_wali | integer | Web Service: GetRecordset:pekerjaan | ||
| id_penghasilan_wali | integer | Web Service: GetRecordset:penghasilan | ||
| kewarganegaraan | character(2) | 1 |
Terdapat 43 baris
Deskripsi Tabel mahasiswa_pt
| column_name | pk | type | not_null | desc |
| id_reg_pd | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah |
| id_sms | uuid | 1 | ID SMS (Satuan Manajemen Sumberdaya). Web Service: GetRecordse:sms | |
| id_pd | uuid | 1 | ID_PD Mahasiswa. Web Service: GetRecordset:mahasiswa | |
| id_sp | uuid | 1 | ID Perguruan Tinggi. Web Service: GetRecordset:satuan_pendidikan | |
| id_jns_daftar | numeric(1,0) | 1 | Web Service: GetRecordset:jenis_pendaftaran | |
| nipd | character varying(18) | NIM/NRP Mahasiswa | ||
| tgl_masuk_sp | date | 1 | yyyy-mm-dd | |
| id_jns_keluar | character(1) | Web Service: GetRecordset:jenis_keluar | ||
| tgl_keluar | date | yyyy-mm-dd | ||
| ket | character varying(128) | Keterangan | ||
| skhun | character(20) | |||
| a_pernah_paud | numeric(1,0) | 1 | 0: Tidak pernah PAUD, 1: Pernah PAUD | |
| a_pernah_tk | numeric(1,0) | 1 | 0: Tidak pernah TK, 1: Pernah TK | |
| mulai_smt | character varying(5) | ID Mulai Semester. Web Service: GetRecordset:semester | ||
| sks_diakui | numeric(3,0) | |||
| jalur_skripsi | numeric(1,0) | |||
| judul_skripsi | character varying(250) | |||
| bln_awal_bimbingan | date | yyyy-mm-dd | ||
| bln_akhir_bimbingan | date | yyyy-mm-dd | ||
| sk_yudisium | character varying(40) | |||
| tgl_sk_yudisium | date | yyyy-mm-dd | ||
| ipk | double precision | Indeks Prestasi Kumulatif | ||
| no_seri_ijazah | character varying(40) | |||
| sert_prof | character varying(40) | |||
| a_pindah_mhs_asing | numeric(1,0) | |||
| nm_pt_asal | character varying(50) | Nama Perguruan Tinggi Asal | ||
| nm_prodi_asal | character varying(50) | Nama Program Studi Asal |
Terdapat 27 baris
Deskripsi Tabel mata_kuliah
| column_name | pk | type | not_null | desc |
| id_mk | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah |
| id_sms | uuid | 1 | ID SMS (Satuan Manajemen Sumberdaya). Web Service: GetRecordset:sms | |
| id_jenj_didik | numeric(2,0) | 1 | ID jenjang pendidikan. Web Service: GetRecordset:jenjang_pendidikan | |
| kode_mk | character varying(20) | 1 | Kode Matakuliah | |
| nm_mk | character varying(200) | Nama Matakuliah | ||
| jns_mk | character(1) | |||
| kel_mk | character(1) | |||
| sks_mk | numeric(2,0) | |||
| sks_tm | numeric(2,0) | |||
| sks_prak | numeric(2,0) | |||
| sks_prak_lap | numeric(2,0) | |||
| sks_sim | numeric(2,0) | |||
| metode_pelaksanaan_kuliah | character varying(50) | |||
| a_sap | numeric(1,0) | |||
| a_silabus | numeric(1,0) | |||
| a_bahan_ajar | numeric(1,0) | |||
| acara_prak | numeric(1,0) | |||
| a_diktat | numeric(1,0) | |||
| tgl_mulai_efektif | date | yyyy-mm-dd | ||
| tgl_akhir_efektif | date | yyyy-mm-dd |
Terdapat 20 baris
Deskripsi Tabel mata_kuliah_kurikulum
| column_name | pk | type | not_null | desc | default |
| id_kurikulum_sp | 1 | uuid | 1 | ID Kurikulum SP. Web Service: GetRecordset:kurikulum | |
| id_mk | 1 | uuid | 1 | ID Mata Kuliah. Web Service: GetRecordset:mata_kuliah | |
| smt | numeric(2,0) | 1 | 1: Ganjil, 2: Genap | ||
| sks_mk | numeric(2,0) | ||||
| sks_tm | numeric(2,0) | ||||
| sks_prak | numeric(2,0) | ||||
| sks_prak_lap | numeric(2,0) | ||||
| sks_sim | numeric(2,0) | ||||
| a_wajib | numeric(1,0) | 1 | 1 |
Terdapat 9 baris
Deskripsi Tabel satuan_pendidikan
| column_name | pk | type | not_null | desc |
| id_sp | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_lemb | character varying(80) | 1 | ||
| nss | character(12) | |||
| npsn | character(8) | |||
| nm_singkat | character varying(20) | |||
| id_bp | smallint | 1 | ||
| jln | character varying(80) | Jalan | ||
| rt | numeric(2,0) | |||
| rw | numeric(2,0) | |||
| nm_dsn | character varying(50) | Nama Dusun | ||
| ds_kel | character varying(50) | 1 | ||
| id_wil | character(8) | 1 | Primary Key, kosongkan ketika mode Tambah | |
| kode_pos | character(5) | |||
| lintang | numeric(10,6) | |||
| bujur | numeric(10,6) | |||
| no_tel | character varying(20) | |||
| no_fax | character varying(20) | |||
| character varying(50) | ||||
| website | character varying(100) | |||
| id_kk | integer | 1 | Primary Key, kosongkan ketika mode Tambah | |
| stat_sp | character(1) | 1 | ||
| sk_pendirian_sp | character varying(40) | |||
| tgl_sk_pendirian_sp | date | yyyy-mm-dd | ||
| tgl_berdiri | date | yyyy-mm-dd | ||
| id_stat_milik | numeric(1,0) | 1 | ||
| sk_izin_operasi | character varying(40) | |||
| tgl_sk_izin_operasi | date | yyyy-mm-dd | ||
| no_rek | character varying(20) | |||
| nm_bank | character varying(20) | |||
| unit_cabang | character varying(50) | |||
| nm_rek | character varying(50) | |||
| a_mbs | numeric(1,0) | 1 | ||
| luas_tanah_milik | numeric(7,0) | 1 | ||
| luas_tanah_bukan_milik | numeric(7,0) | 1 | ||
| a_lptk | numeric(1,0) | 1 | ||
| id_pembina | uuid | |||
| id_blob | uuid | |||
| id_pic | uuid | |||
| kode_reg | bigint | |||
| flag | character(1) |
Terdapat 40 baris
Deskripsi Tabel sms
| column_name | pk | type | not_null | desc | default |
| id_sms | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah | |
| nm_lemb | character varying(80) | 1 | |||
| smt_mulai | character(5) | ||||
| kode_prodi | character varying(10) | ||||
| id_sp | uuid | 1 | Satuan Pendidikan per Jurusan | ||
| id_jenj_didik | numeric(2,0) | 1 | ID Jenjang Pendidikan. Web Service: GetRecordset:jenjang_pendidikan | ||
| id_jns_sms | numeric(2,0) | 1 | Web Service: GetRecordset:jenis_sms | ||
| id_pengguna | uuid | Web Service: GetRecordset:pengguna | |||
| id_fungsi_lab | character(1) | 1 | Web Service: GetRecordset:fungsi_lab | ||
| id_kel_usaha | character(8) | 1 | Web Service: GetRecordset:kel_usaha | ||
| id_blob | uuid | ||||
| id_wil | character(8) | 1 | ID Wilayah. Web Service: GetRecordset:wilayah | ||
| id_jur | character(10) | 1 | ID Jurusan. Web Service: GetRecordset:jurusan | ||
| id_induk_sms | uuid | Web Service: GetRecordset:sms | |||
| jln | character varying(80) | Jalan | |||
| rt | numeric(2,0) | ||||
| rw | numeric(2,0) | ||||
| nm_dsn | character varying(50) | Nama Dusun | |||
| ds_kel | character varying(50) | 1 | |||
| kode_pos | character(5) | ||||
| lintang | numeric(10,6) | ||||
| bujur | numeric(10,6) | ||||
| no_tel | character varying(20) | ||||
| no_fax | character varying(20) | ||||
| character varying(50) | |||||
| website | character varying(100) | ||||
| singkatan | character varying(50) | ||||
| tgl_berdiri | date | yyyy-mm-dd | |||
| sk_selenggara | character varying(40) | ||||
| tgl_sk_selenggara | date | yyyy-mm-dd | |||
| tmt_sk_selenggara | date | yyyy-mm-dd | |||
| tst_sk_selenggara | date | yyyy-mm-dd | |||
| kpst_pd | numeric(5,0) | ||||
| sks_lulus | numeric(3,0) | ||||
| gelar_lulusan | character varying(10) | ||||
| stat_prodi | character(1) | ‘A’::bpchar | |||
| polesei_nilai | character(1) | ‘B’::bpchar | |||
| luas_lab | numeric(5,0) | ||||
| kapasitas_prak_satu_shift | numeric(4,0) | ||||
| jml_mhs_pengguna | numeric(6,0) | ||||
| jml_jam_penggunaan | numeric(5,1) | ||||
| jml_prodi_pengguna | numeric(3,0) | ||||
| jml_modul_prak_sendiri | numeric(4,0) | ||||
| jml_modul_prak_lain | numeric(4,0) | ||||
| fungsi_selain_prak | character(1) | ||||
| penggunaan_lab | character(1) |
Terdapat 46 baris
Deskripsi Tabel substansi_kuliah
| column_name | pk | type | not_null | desc |
| id_subst | 1 | uuid | 1 | |
| id_sms | uuid | 1 | ID SMS (Satuan Manajemen Sumberdaya). Web Service: GetRecordset:sms | |
| nm_subst | character varying(40) | 1 | ||
| id_jns_subst | character(5) | 1 | Jenis Substansi. Web Service: GetRecordset:jenis_subst | |
| sks_mk | numeric(3,1) | |||
| sks_tm | numeric(2,0) | |||
| sks_prak | numeric(2,0) | |||
| sks_prak_lap | numeric(2,0) | |||
| sks_sim | numeric(2,0) |
Terdapat 9 baris
Deskripsi Tabel nilai
| column_name | pk | type | not_null | desc | default |
| id_kls | 1 | uuid | 1 | ID Kelas Kuliah. Web Service: GetRecordset:kelas_kuliah | |
| id_reg_pd | 1 | uuid | 1 | Web Service: GetRecordset:mahasiswa_pt | |
| asal_data | character(1) | 1 | ‘9’::bpchar | ||
| nilai_angka | numeric(4,1) | ||||
| nilai_huruf | character(3) | ||||
| nilai_indeks | numeric(4,2) |
Terdapat 6 baris
Deskripsi Tabel nilai_transfer
| column_name | pk | type | not_null | desc |
| id_ekuivalensi | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah |
| id_reg_pd | uuid | 1 | Web Service: GetRecordset:mahasiswa_pt | |
| id_mk | uuid | 1 | Web Service: GetRecordset:mata_kuliah | |
| kode_mk_asal | character varying(20) | 1 | ||
| nm_mk_asal | character varying(200) | 1 | ||
| sks_asal | numeric(2,0) | 1 | ||
| sks_diakui | numeric(2,0) | 1 | ||
| nilai_huruf_asal | character varying(3) | 1 | ||
| nilai_huruf_diakui | character varying(3) | 1 | ||
| nilai_angka_diakui | numeric(5,2) | 1 |
Terdapat 10 baris
