| id | int(11) |
|
|
|
| nik | varchar(20) |
|
|
|
| nama | varchar(50) |
|
|
|
| jk | enum | -- |
|
|
| jbtn | varchar(25) |
|
|
|
| jnj_jabatan | varchar(5) |
|
|
|
| kode_kelompok | varchar(3) |
|
|
|
| kode_resiko | varchar(3) |
|
|
|
| kode_emergency | varchar(3) |
|
|
|
| departemen | char(4) |
|
|
|
| bidang | varchar(15) |
|
|
|
| stts_wp | char(5) |
|
|
|
| stts_kerja | char(3) |
|
|
|
| npwp | varchar(15) |
|
|
|
| pendidikan | varchar(80) |
|
|
|
| gapok | double |
|
|
|
| tmp_lahir | varchar(20) |
|
|
|
| tgl_lahir | date |
|
|
|
| alamat | varchar(60) |
|
|
|
| kota | varchar(20) |
|
|
|
| mulai_kerja | date |
|
|
|
| ms_kerja | enum | -- |
|
|
| indexins | char(4) |
|
|
|
| bpd | varchar(50) |
|
|
|
| rekening | varchar(25) |
|
|
|
| stts_aktif | enum | -- |
|
|
| wajibmasuk | tinyint(2) |
|
|
|
| pengurang | double |
|
|
|
| indek | tinyint(4) |
|
|
|
| mulai_kontrak | date |
|
|
|
| cuti_diambil | int(11) |
|
|
|
| dankes | double |
|
|
|
| photo | varchar(500) |
|
|
|
| no_ktp | varchar(20) |
|
|
|