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.
Daftar Tabel
| table | jenis | keterangan |
| agama | Ref | Agama |
| bentuk_pendidikan | Ref | Bentuk Pendidikan |
| ikatan_kerja_dosen | Ref | Ikatan Kerja Dosen |
| jabfung | Ref | Jabatan Fungsional |
| jalur_masuk | Ref | Jalur Masuk |
| 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 |
| jenis_tinggal | Ref | Jenis Tinggal |
| 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 |
| dosen_pembimbing | Data | Dosen Pembimbing |
| 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 |
| nilai | Data | Nilai mahasiswa per kelas per periode |
| nilai_transfer | Data | Nilai Transfer |
| satuan_pendidikan | Data | Perguruan Tinggi. Perubahan data hanya dari Forlap |
| sms | Data | Program Studi. Perubahan data hanya dari Forlap |
| substansi_kuliah | Data | Substansi kuliah |
Terdapat 45 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(50) | 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
Terdapat 0 baris
Deskripsi Tabel jabfung
| column_name | pk | type | not_null | desc |
| id_jabfung | 1 | numeric(2,0) | 1 | |
| id_kel_prof | numeric(5,0) | 1 | ||
| nm_jabfung | character varying(50) | 1 | ||
| angka_kredit | numeric(7,2) |
Terdapat 4 baris
Deskripsi Tabel jalur_masuk
| column_name | pk | type | not_null | desc |
| id_jalur_masuk | 1 | numeric(4,0) | 1 | Web Service: GetRecordset:jalur_masuk |
| id_jenj_didik | numeric(2,0) | Primary Key, kosongkan ketika mode Tambah | ||
| nm_jalur_masuk | character varying(60) | 1 | ||
| ket_jalur_masuk | character varying(200) |
Terdapat 4 baris
Deskripsi Tabel jenis_evaluasi
| column_name | pk | type | not_null | desc |
| id_jns_eval | 1 | smallint | 1 | |
| nm_jns_eval | character varying(50) | 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 | ||
| a_sdm_iptek | numeric(1,0) | 1 |
Terdapat 5 baris
Deskripsi Tabel jenis_pendaftaran
| column_name | pk | type | not_null | desc |
| id_jns_daftar | 1 | numeric(2,0) | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_jns_daftar | character varying(50) | 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(50) | 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(50) | 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 jenis_tinggal
| column_name | pk | type | not_null | desc |
| id_jns_tinggal | 1 | numeric(2,0) | 1 | Primary Key, kosongkan ketika mode Tambah |
| nm_jns_tinggal | 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(50) | 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 varying(25) | 1 | |
| nm_jur | character varying(100) | 1 | ||
| nm_intl_jur | character varying(100) | |||
| 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_kel_bidang | uuid | 1 | ||
| id_induk_jurusan | character varying(25) | |||
| id_jenj_didik | numeric(2,0) | 1 | Primary Key, kosongkan ketika mode Tambah |
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(50) | 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(100) | 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(50) |
Terdapat 2 baris
Deskripsi Tabel negara
| column_name | pk | type | not_null | desc | default |
| id_negara | 1 | character(2) | 1 | ||
| nm_negara | character varying(50) | 1 | |||
| a_ln | numeric(1,0) | 1 | |||
| benua | numeric(1,0) | 1 | 1 |
Terdapat 4 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(50) | 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(50) |
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(50) | 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(50) | 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(50) | 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(50) | 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(50) | 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 |
| id_negara | character(2) | 1 | ||
| nm_wil | character varying(60) | |||
| 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 |
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_subst | uuid | ID Substansi Kuliah. Web Service: GetRecordset:substansi_kuliah | ||
| id_jns_eval | smallint | 1 | Web Service: GetRecordset:jenis_evaluasi | |
| id_reg_ptk | uuid | 1 | ID Dosen. Web Service: GetRecordset:dosen_pt | |
| id_kls | uuid | 1 | ID Kelas. Web Service: GetRecordset:kelas_kuliah | |
| sks_subst_tot | numeric(5,2) | 1 | jumlah sks dosen pengajar | |
| 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) |
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_sdm | 1 | uuid | 1 | |
| nm_sdm | character varying(100) | 1 | ||
| 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 | |
| nm_ibu_kandung | character varying(100) | 1 | ||
| stat_kawin | numeric(1,0) | 1 | 0: Belum Menikah, 1: Sudah Menikah | |
| nik | character(16) | 1 | Nomor Induk Kependudukan, wajib di isi | |
| nip | character varying(18) | |||
| niy_nigk | character varying(30) | |||
| nuptk | character(16) | |||
| nidn | character(10) | |||
| nsdmi | character(12) | |||
| jln | character varying(80) | Jalan | ||
| rt | numeric(2,0) | |||
| rw | numeric(2,0) | |||
| nm_dsn | character varying(60) | Nama Dusun | ||
| ds_kel | character varying(60) | 1 | ||
| kode_pos | character(5) | |||
| no_tel_rmh | character varying(20) | |||
| no_hp | character varying(20) | |||
| character varying(60) | ||||
| tmt_pns | date | yyyy-mm-dd | ||
| nm_suami_istri | character varying(100) | |||
| nip_suami_istri | character(18) | |||
| sk_cpns | character varying(80) | |||
| tgl_sk_cpns | date | yyyy-mm-dd | ||
| sk_angkat | character varying(80) | |||
| tmt_sk_angkat | date | yyyy-mm-dd | ||
| npwp | character(15) | Nomor Pokok Wajib Pajak | ||
| nm_wp | character varying(100) | |||
| stat_data | integer | |||
| a_lisensi_kepsek | numeric(1,0) | |||
| 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 | ||
| jml_sekolah_binaan | smallint | |||
| a_diklat_awas | numeric(1,0) | |||
| akta_ijin_ajar | character(1) | |||
| nira | character(30) | |||
| kewarganegaraan | character(2) | 1 | Web Service: GetRecordset:negara | |
| id_jns_sdm | numeric(2,0) | 1 | ||
| id_wil | character(8) | 1 | Primary Key, kosongkan ketika mode Tambah | |
| id_stat_aktif | numeric(2,0) | 1 | Primary Key, kosongkan ketika mode Tambah | |
| id_blob | uuid | |||
| id_agama | smallint | 1 | Primary Key, kosongkan ketika mode Tambah | |
| id_keahlian_lab | smallint | Primary Key, kosongkan ketika mode Tambah | ||
| id_pekerjaan_suami_istri | integer | 1 | ||
| id_sumber_gaji | numeric(2,0) | 1 | Primary Key, kosongkan ketika mode Tambah | |
| id_lemb_angkat | numeric(2,0) | 1 | Primary Key, kosongkan ketika mode Tambah | |
| id_pangkat_gol | numeric(2,0) | Primary Key, kosongkan ketika mode Tambah | ||
| mampu_handle_kk | integer | 1 | ||
| id_bid_pengawas | integer | Primary Key, kosongkan ketika mode Tambah |
Terdapat 52 baris
Deskripsi Tabel dosen_pt
| column_name | pk | type | not_null | desc | default |
| id_reg_ptk | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah | |
| no_srt_tgs | character varying(80) | 1 | |||
| tgl_srt_tgs | date | 1 | yyyy-mm-dd | ||
| tmt_srt_tgs | date | 1 | yyyy-mm-dd | ||
| tgl_ptk_keluar | date | yyyy-mm-dd | |||
| tgl_create | timestamp without time zone | 1 | ‘1970-01-01 00:00:00’::timestamp without time zone | ||
| id_stat_pegawai | smallint | 1 | Primary Key, kosongkan ketika mode Tambah | ||
| id_sdm | uuid | 1 | |||
| id_sp | uuid | 1 | ID Perguruan Tinggi. Web Service: GetRecordset:satuan_pendidikan | ||
| id_jns_keluar | character(1) | Web Service: GetRecordset:jenis_keluar | |||
| id_ikatan_kerja | character(1) | 1 | Primary Key, kosongkan ketika mode Tambah | ||
| id_sms | uuid | ID SMS (Satuan Manajemen Sumberdaya). Web Service: GetRecordset:sms |
Terdapat 12 baris
Deskripsi Tabel dosen_pembimbing
| column_name | pk | type | not_null | desc |
| id_sdm | 1 | uuid | 1 | ID Dosen. Web Service: GetRecordset:dosen |
| id_reg_pd | 1 | uuid | 1 | ID Mahasiswa PT. Web Service: GetRecordset:mahasiswa_pt |
| urutan_promotor | numeric(1,0) | 1 |
Terdapat 3 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 | |
| nm_kls | character varying(5) | 1 | ||
| sks_mk | numeric(5,2) | |||
| sks_tm | numeric(5,2) | |||
| sks_prak | numeric(5,2) | |||
| sks_prak_lap | numeric(5,2) | |||
| sks_sim | numeric(5,2) | |||
| bahasan_case | character varying(200) | |||
| a_selenggara_pditt | numeric(1,0) | 1 | ||
| a_pengguna_pditt | numeric(1,0) | 1 | ||
| kuota_pditt | numeric(4,0) | 1 | ||
| tgl_mulai_koas | date | yyyy-mm-dd | ||
| tgl_selesai_koas | date | yyyy-mm-dd | ||
| id_mou | uuid | ID Mou. Web Service: GetRecordset:mou | ||
| id_mk | uuid | 1 | ID Mata Kuliah. Web Service: GetRecordset:mata_kuliah | |
| 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 |
| id_stat_mhs | character(1) | 1 | Web Service: GetRecordset:status_mahasiswa | |
| ips | double precision | |||
| sks_smt | numeric(3,0) | |||
| ipk | double precision | Indeks Prestasi Kumulatif | ||
| sks_total | numeric(3,0) |
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 | |
| 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 | character(5) | 1 | Semester mulai berlaku. Web Service: GetRecordset:semester | ||
| 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 |
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(100) | Nama Mahasiswa | ||
| jk | character(1) | 1 | L: Laki-laki, P: Perempuan, *: Belum ada informasi | |
| jln | character varying(80) | Jalan | ||
| rt | numeric(2,0) | |||
| rw | numeric(2,0) | |||
| nm_dsn | character varying(60) | Nama Dusun | ||
| ds_kel | character varying(60) | 1 | ||
| kode_pos | character(5) | |||
| nisn | character(10) | Nomor Induk Siswa Nasional | ||
| nik | character(16) | Nomor Induk Kependudukan, wajib di isi | ||
| tmpt_lahir | character varying(32) | |||
| tgl_lahir | date | 1 | yyyy-mm-dd | |
| nm_ayah | character varying(100) | |||
| tgl_lahir_ayah | date | yyyy-mm-dd | ||
| nik_ayah | character(16) | |||
| 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(100) | 1 | ||
| tgl_lahir_ibu | date | yyyy-mm-dd | ||
| nik_ibu | character(16) | |||
| id_jenjang_pendidikan_ibu | numeric(2,0) | Web Service: GetRecordset:jenjang_pendidikan | ||
| id_pekerjaan_ibu | integer | Web Service: GetRecordset:pekerjaan | ||
| id_penghasilan_ibu | integer | Web Service: GetRecordset:penghasilan | ||
| id_kebutuhan_khusus_ibu | integer | 1 | Default 0 | |
| nm_wali | character varying(100) | |||
| 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 | ||
| id_kk | integer | 1 | Default 0 | |
| no_tel_rmh | character varying(20) | |||
| no_hp | character varying(20) | |||
| character varying(60) | ||||
| a_terima_kps | numeric(1,0) | 1 | 0: Bukan penerima KPS, 1: Penerima KPS | |
| no_kps | character varying(80) | Nomor KPS (KARTU PERLINDUNGAN SOSIAL) | ||
| npwp | character(15) | Nomor Pokok Wajib Pajak | ||
| id_wil | character(8) | 1 | ID Wilayah. Web Service: GetRecordset:wilayah | |
| id_jns_tinggal | numeric(2,0) | Web Service: GetRecordset:jenis_tinggal | ||
| id_agama | smallint | 1 | Web Service: GetRecordset:agama | |
| id_alat_transport | numeric(2,0) | Web Service: GetRecordset:alat_transport | ||
| kewarganegaraan | character(2) | 1 | Web Service: GetRecordset:negara |
Terdapat 44 baris
Deskripsi Tabel mahasiswa_pt
| column_name | pk | type | not_null | desc | default |
| id_reg_pd | 1 | uuid | 1 | Primary Key, kosongkan ketika mode Tambah | |
| id_pd | uuid | 1 | ID_PD Mahasiswa. Web Service: GetRecordset:mahasiswa | ||
| id_sp | uuid | 1 | ID Perguruan Tinggi. Web Service: GetRecordset:satuan_pendidikan | ||
| id_sms | uuid | 1 | ID SMS (Satuan Manajemen Sumberdaya). Web Service: GetRecordset:sms | ||
| nipd | character varying(24) | NIM/NRP Mahasiswa | |||
| tgl_masuk_sp | date | 1 | yyyy-mm-dd | ||
| tgl_keluar | date | yyyy-mm-dd | |||
| ket | character varying(128) | Keterangan | |||
| skhun | character(20) | ||||
| no_peserta_ujian | character(20) | ||||
| no_seri_ijazah | character varying(80) | ||||
| 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 | ||
| tgl_create | timestamp without time zone | 1 | ‘1970-01-01 00:00:00’::timestamp without time zone | ||
| mulai_smt | character varying(5) | 1 | ID Mulai Semester. Web Service: GetRecordset:semester | ||
| sks_diakui | numeric(3,0) | ||||
| jalur_skripsi | numeric(1,0) | ||||
| judul_skripsi | character varying(500) | ||||
| bln_awal_bimbingan | date | yyyy-mm-dd | |||
| bln_akhir_bimbingan | date | yyyy-mm-dd | |||
| sk_yudisium | character varying(80) | ||||
| tgl_sk_yudisium | date | yyyy-mm-dd | |||
| ipk | double precision | Indeks Prestasi Kumulatif | |||
| sert_prof | character varying(80) | ||||
| a_pindah_mhs_asing | numeric(1,0) | ||||
| id_pt_asal | uuid | ||||
| id_prodi_asal | uuid | ||||
| nm_pt_asal | character varying(100) | ID Perguruan Tinggi. Web Service: GetRecordset:satuan_pendidikan | |||
| nm_prodi_asal | character varying(100) | ID SMS (Satuan Manajemen Sumberdaya). Web Service: GetRecordset:sms | |||
| id_jns_daftar | numeric(2,0) | 1 | Web Service: GetRecordset:jenis_pendaftaran | ||
| id_jns_keluar | character(1) | Web Service: GetRecordset:jenis_keluar | |||
| id_jalur_masuk | numeric(4,0) | Web Service: GetRecordset:jalur_masuk |
Terdapat 32 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) | A=Wajib, B=Pilihan, C=Wajib Peminatan, D=Pilihan Peminatan, S=Tugas akhir/Skripsi/Tesis/Disertasi | ||
| kel_mk | character(1) | A=MPK, B=MKK, C=MKB, D=MPB, E=MBB, F=MKU/MKDU, G=MKDK, H=MKK | ||
| sks_mk | numeric(5,2) | |||
| sks_tm | numeric(5,2) | |||
| sks_prak | numeric(5,2) | |||
| sks_prak_lap | numeric(5,2) | |||
| sks_sim | numeric(5,2) | |||
| 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 | semester matakuliah (1,2,3…8) | ||
| sks_mk | numeric(5,2) | ||||
| sks_tm | numeric(5,2) | ||||
| sks_prak | numeric(5,2) | ||||
| sks_prak_lap | numeric(5,2) | ||||
| sks_sim | numeric(5,2) | ||||
| a_wajib | numeric(1,0) | 1 | 1 |
Terdapat 9 baris
Deskripsi Tabel nilai
| column_name | pk | type | not_null | desc |
| id_kls | 1 | uuid | 1 | ID Kelas Kuliah. Web Service: GetRecordset:kelas_kuliah |
| id_reg_pd | 1 | uuid | 1 | Web Service: GetRecordset:mahasiswa_pt |
| nilai_angka | numeric(4,1) | |||
| nilai_huruf | character(3) | |||
| nilai_indeks | numeric(4,2) |
Terdapat 5 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
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(100) | 1 | ||
| nss | character(12) | |||
| npsn | character(8) | |||
| nm_singkat | character varying(20) | |||
| jln | character varying(80) | Jalan | ||
| rt | numeric(2,0) | |||
| rw | numeric(2,0) | |||
| nm_dsn | character varying(60) | Nama Dusun | ||
| ds_kel | character varying(60) | 1 | ||
| kode_pos | character(5) | |||
| lintang | numeric(11,7) | |||
| bujur | numeric(11,7) | |||
| no_tel | character varying(20) | |||
| no_fax | character varying(20) | |||
| character varying(60) | ||||
| website | character varying(256) | |||
| stat_sp | character(1) | 1 | ||
| sk_pendirian_sp | character varying(80) | |||
| tgl_sk_pendirian_sp | date | yyyy-mm-dd | ||
| tgl_berdiri | date | yyyy-mm-dd | ||
| sk_izin_operasi | character varying(80) | |||
| tgl_sk_izin_operasi | date | yyyy-mm-dd | ||
| no_rek | character varying(20) | |||
| nm_bank | character varying(50) | |||
| unit_cabang | character varying(60) | |||
| 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 | ||
| kode_reg | bigint | |||
| npwp | character(15) | Nomor Pokok Wajib Pajak | ||
| nm_wp | character varying(100) | |||
| flag | character(1) | |||
| id_pembina | uuid | |||
| id_blob | uuid | |||
| id_stat_milik | numeric(1,0) | 1 | ||
| id_wil | character(8) | 1 | Primary Key, kosongkan ketika mode Tambah | |
| id_kk | integer | 1 | Primary Key, kosongkan ketika mode Tambah | |
| id_bp | smallint | 1 |
Terdapat 41 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(100) | 1 | |||
| smt_mulai | character(5) | ||||
| kode_prodi | character varying(10) | ||||
| nm_prodi_english | character varying(100) | ||||
| jln | character varying(80) | Jalan | |||
| rt | numeric(2,0) | ||||
| rw | numeric(2,0) | ||||
| nm_dsn | character varying(60) | Nama Dusun | |||
| ds_kel | character varying(60) | 1 | |||
| kode_pos | character(5) | ||||
| lintang | numeric(11,7) | ||||
| bujur | numeric(11,7) | ||||
| no_tel | character varying(20) | ||||
| no_fax | character varying(20) | ||||
| character varying(60) | |||||
| website | character varying(256) | ||||
| singkatan | character varying(50) | ||||
| tgl_berdiri | date | yyyy-mm-dd | |||
| sk_selenggara | character varying(80) | ||||
| 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 | |||
| a_kependidikan | numeric(1,0) | ||||
| sistem_ajar | numeric(1,0) | ||||
| 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) | ||||
| 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_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 varying(25) | 1 | ID Jurusan. Web Service: GetRecordset:jurusan | ||
| id_induk_sms | uuid | Web Service: GetRecordset:sms |
Terdapat 48 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(50) | 1 | ||
| sks_mk | numeric(5,2) | |||
| sks_tm | numeric(5,2) | |||
| sks_prak | numeric(5,2) | |||
| sks_prak_lap | numeric(5,2) | |||
| sks_sim | numeric(5,2) | |||
| id_jns_subst | character(5) | 1 | Jenis Substansi. Web Service: GetRecordset:jenis_subst |
Terdapat 9 baris
