no_sep
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
no_rawat
varchar(17)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
Mostrar los valores foráneos
tglsep
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tglrujukan
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
no_rujukan
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kdppkrujukan
varchar(12)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nmppkrujukan
varchar(200)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kdppkpelayanan
varchar(12)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nmppkpelayanan
varchar(200)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
jnspelayanan
enum('1', '2')
latin1_swedish_ci
= != IS NULL IS NOT NULL
1
2
catatan
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
diagawal
varchar(10)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nmdiagnosaawal
varchar(400)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kdpolitujuan
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nmpolitujuan
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
klsrawat
enum('1', '2', '3')
latin1_swedish_ci
= != IS NULL IS NOT NULL
1
2
3
klsnaik
enum('', '1', '2', '3', '4', '5', '6', '7', '8')
latin1_swedish_ci
= != IS NULL IS NOT NULL
1
2
3
4
5
6
7
8
pembiayaan
enum('', '1', '2', '3')
latin1_swedish_ci
= != IS NULL IS NOT NULL
1
2
3
pjnaikkelas
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
lakalantas
enum('0', '1', '2', '3')
latin1_swedish_ci
= != IS NULL IS NOT NULL
0
1
2
3
user
varchar(25)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nomr
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nama_pasien
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tanggal_lahir
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
peserta
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
jkel
enum('L', 'P')
latin1_swedish_ci
= != IS NULL IS NOT NULL
L
P
no_kartu
varchar(25)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tglpulang
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
asal_rujukan
enum('1. Faskes 1', '2. Faskes 2(RS)')
latin1_swedish_ci
= != IS NULL IS NOT NULL
1. Faskes 1
2. Faskes 2(RS)
eksekutif
enum('0. Tidak', '1.Ya')
latin1_swedish_ci
= != IS NULL IS NOT NULL
0. Tidak
1.Ya
cob
enum('0. Tidak', '1.Ya')
latin1_swedish_ci
= != IS NULL IS NOT NULL
0. Tidak
1.Ya
notelep
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
katarak
enum('0. Tidak', '1.Ya')
latin1_swedish_ci
= != IS NULL IS NOT NULL
0. Tidak
1.Ya
tglkkl
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
keterangankkl
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
suplesi
enum('0. Tidak', '1.Ya')
latin1_swedish_ci
= != IS NULL IS NOT NULL
0. Tidak
1.Ya
no_sep_suplesi
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kdprop
varchar(10)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nmprop
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kdkab
varchar(10)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nmkab
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kdkec
varchar(10)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nmkec
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
noskdp
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kddpjp
varchar(10)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nmdpdjp
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tujuankunjungan
enum('0', '1', '2')
latin1_swedish_ci
= != IS NULL IS NOT NULL
0
1
2
flagprosedur
enum('', '0', '1')
latin1_swedish_ci
= != IS NULL IS NOT NULL
0
1
penunjang
enum('', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12')
latin1_swedish_ci
= != IS NULL IS NOT NULL
1
2
3
4
5
6
7
8
9
10
11
12
asesmenpelayanan
enum('', '1', '2', '3', '4', '5')
latin1_swedish_ci
= != IS NULL IS NOT NULL
1
2
3
4
5
kddpjplayanan
varchar(10)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nmdpjplayanan
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL