| id |
int(11)
|
|
|
|
| nik |
varchar(20)
|
latin1_swedish_ci
|
|
|
| nama |
varchar(50)
|
latin1_swedish_ci
|
|
|
| jk |
enum('Pria', 'Wanita')
|
latin1_swedish_ci
|
|
|
| jbtn |
varchar(25)
|
latin1_swedish_ci
|
|
|
| jnj_jabatan |
varchar(5)
|
latin1_swedish_ci
|
|
|
| kode_kelompok |
varchar(3)
|
latin1_swedish_ci
|
|
|
| kode_resiko |
varchar(3)
|
latin1_swedish_ci
|
|
|
| kode_emergency |
varchar(3)
|
latin1_swedish_ci
|
|
|
| departemen |
char(4)
|
latin1_swedish_ci
|
|
|
| bidang |
varchar(15)
|
latin1_swedish_ci
|
|
|
| stts_wp |
char(5)
|
latin1_swedish_ci
|
|
|
| stts_kerja |
char(3)
|
latin1_swedish_ci
|
|
|
| npwp |
varchar(15)
|
latin1_swedish_ci
|
|
|
| pendidikan |
varchar(80)
|
latin1_swedish_ci
|
|
|
| gapok |
double
|
|
|
|
| tmp_lahir |
varchar(20)
|
latin1_swedish_ci
|
|
|
| tgl_lahir |
date
|
|
|
|
| alamat |
varchar(60)
|
latin1_swedish_ci
|
|
|
| kota |
varchar(20)
|
latin1_swedish_ci
|
|
|
| mulai_kerja |
date
|
|
|
|
| ms_kerja |
enum('<1', 'PT', 'FT>1')
|
latin1_swedish_ci
|
|
|
| indexins |
char(4)
|
latin1_swedish_ci
|
|
|
| bpd |
varchar(50)
|
latin1_swedish_ci
|
|
|
| rekening |
varchar(25)
|
latin1_swedish_ci
|
|
|
| stts_aktif |
enum('AKTIF', 'CUTI', 'KELUAR', 'TENAGA LUAR', 'NON AKTIF')
|
latin1_swedish_ci
|
|
|
| wajibmasuk |
tinyint(2)
|
|
|
|
| pengurang |
double
|
|
|
|
| indek |
tinyint(4)
|
|
|
|
| mulai_kontrak |
date
|
|
|
|
| cuti_diambil |
int(11)
|
|
|
|
| dankes |
double
|
|
|
|
| photo |
varchar(500)
|
latin1_swedish_ci
|
|
|
| no_ktp |
varchar(20)
|
latin1_swedish_ci
|
|
|
