id
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nik
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nama
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
jk
enum('Pria', 'Wanita')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Pria
Wanita
jbtn
varchar(25)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
jnj_jabatan
varchar(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - 01 - 01 APJB - APJB DIRB - DIRB DIRU - DIRU KASI - KASI KORB - KORB PJBd - PJBd PjBid - PjBid PJBP - PJBP PJBU - PJBU PJSB - PJSB PLSN - PLSN WDU - WDU - - - 01 - 01 APJB - APJB DIRB - DIRB DIRU - DIRU KASI - KASI KORB - KORB PJBd - PJBd PjBid - PjBid PJBP - PJBP PJBU - PJBU PJSB - PJSB PLSN - PLSN WDU - WDU
kode_kelompok
varchar(3)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - AP - AP KP - KP KTA - KTA SDB - SDB SKP - SKP WKT - WKT - - - AP - AP KP - KP KTA - KTA SDB - SDB SKP - SKP WKT - WKT
kode_resiko
varchar(3)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - I - I II - II III - III IV - IV SB - SB - - - I - I II - II III - III IV - IV SB - SB
kode_emergency
varchar(3)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - I - I II - II III - III - - - I - I II - II III - III
departemen
char(4)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - DIR - DIR DOK - DOK IGD - IGD IT - IT MEN - MEN OK - OK PNM - PNM RJ - RJ RNAP - RNAP - - - DIR - DIR DOK - DOK IGD - IGD IT - IT MEN - MEN OK - OK PNM - PNM RJ - RJ RNAP - RNAP
bidang
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - Crew Operasi - Crew Operasi Direksi - Direksi Dokter Umum - Dokter Umum Manajemen - Manajemen MEDIK & KEPERAW - MEDIK & KEPERAW Medis - Medis Non Medis - Non Medis - - - Crew Operasi - Crew Operasi Direksi - Direksi Dokter Umum - Dokter Umum Manajemen - Manajemen MEDIK & KEPERAW - MEDIK & KEPERAW Medis - Medis Non Medis - Non Medis
stts_wp
char(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - K/0 - K/0 K/1 - K/1 K/2 - K/2 K/3 - K/3 mum - mum TK/0 - TK/0 TK/1 - TK/1 TK/2 - TK/2 TK/3 - TK/3 - - - K/0 - K/0 K/1 - K/1 K/2 - K/2 K/3 - K/3 mum - mum TK/0 - TK/0 TK/1 - TK/1 TK/2 - TK/2 TK/3 - TK/3
stts_kerja
char(3)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - CK - CK FT - FT PI - PI PT - PT T - T - - - CK - CK FT - FT PI - PI PT - PT T - T
npwp
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
pendidikan
varchar(80)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - D3 IT - D3 IT D3 PERAWAT - D3 PERAWAT S1 DIREKTUR UTAMA - S1 DIREKTUR UTAMA S1 KEDOKTERAN - S1 KEDOKTERAN S1 PEMERINTAHAN - S1 PEMERINTAHAN S1 PERAWAT - S1 PERAWAT S1 PERAWAT KONTRAK - S1 PERAWAT KONTRAK S2 PERAWAT - S2 PERAWAT - - - D3 IT - D3 IT D3 PERAWAT - D3 PERAWAT S1 DIREKTUR UTAMA - S1 DIREKTUR UTAMA S1 KEDOKTERAN - S1 KEDOKTERAN S1 PEMERINTAHAN - S1 PEMERINTAHAN S1 PERAWAT - S1 PERAWAT S1 PERAWAT KONTRAK - S1 PERAWAT KONTRAK S2 PERAWAT - S2 PERAWAT
gapok
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tmp_lahir
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tgl_lahir
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
alamat
varchar(60)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kota
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
mulai_kerja
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ms_kerja
enum('<1', 'PT', 'FT>1')
latin1_swedish_ci
= != IS NULL IS NOT NULL
<1
PT
FT>1
indexins
char(4)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - DIR - DIR DOK - DOK IGD - IGD IT - IT MEN - MEN OK - OK PNM - PNM RJ - RJ RNAP - RNAP - - - DIR - DIR DOK - DOK IGD - IGD IT - IT MEN - MEN OK - OK PNM - PNM RJ - RJ RNAP - RNAP
bpd
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
BPD - BPD MANDIRI - MANDIRI Muamalat - Muamalat T - T BPD - BPD MANDIRI - MANDIRI Muamalat - Muamalat T - T
rekening
varchar(25)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
stts_aktif
enum('AKTIF', 'CUTI', 'KELUAR', 'TENAGA LUAR', 'NON AKTIF')
latin1_swedish_ci
= != IS NULL IS NOT NULL
AKTIF
CUTI
KELUAR
TENAGA LUAR
NON AKTIF
wajibmasuk
tinyint(2)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
pengurang
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
indek
tinyint(4)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
mulai_kontrak
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
cuti_diambil
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
dankes
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
photo
varchar(500)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
no_ktp
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
