|
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')
|
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
|
|
|
