no_sjp
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
001 - 2025/09/11/000002 001 - 2025/05/27/000001 001 - 2025/08/26/000001 001 - 2025/08/25/000002 001 - 2025/08/25/000001 001 - 2025/06/30/000004 001 - 2025/08/11/000001 001 - 2025/05/15/000001 001 - 2025/05/26/000001 001 - 2025/05/22/000001 001 - 2025/06/11/000001 001 - 2025/06/18/000001 001 - 2025/06/04/000001 001 - 2025/09/02/000001 001 - 2025/06/19/000001 001 - 2025/06/20/000001 001 - 2025/06/09/000001 001 - 2025/08/11/000004 001 - 2025/06/28/000001 001 - 2025/04/25/000001 001 - 2025/06/25/000001 001 - 2025/06/23/000001 001 - 2025/04/26/000001 001 - 2025/04/27/000001 001 - 2025/06/03/000001 001 - 2025/08/27/000001 001 - 2025/06/30/000001 001 - 2025/09/03/000001 001 - 2025/07/04/000001 001 - 2025/09/04/000001 001 - 2025/08/04/000001 001 - 2025/07/29/000001 001 - 2025/07/23/000001 001 - 2025/07/21/000001 001 - 2025/07/16/000001 001 - 2025/07/14/000001 001 - 2025/07/08/000001 001 - 2025/07/07/000001 001 - 2025/07/05/000001 001 - 2025/07/08/000004 001 - 2025/07/03/000001 001 - 2025/09/08/000001 001 - 2025/08/13/000001 001 - 2025/08/19/000001 001 - 2025/08/21/000001 001 - 2025/09/11/000001 001 - 2025/09/10/000006 001 - 2025/09/10/000004 001 - 2025/09/10/000001 001 - 2025/09/08/000003 001 - 2025/09/15/000001 001 - 2025/06/30/000005 002 - 2025/06/20/000002 002 - 2025/07/07/000002 002 - 2025/06/20/000003 002 - 2025/07/03/000002 002 - 2025/08/11/000002 002 - 2025/06/30/000002 002 - 2025/06/09/000002 002 - 2025/07/29/000002 002 - 2025/05/27/000002 002 - 2025/06/03/000002 002 - 2025/06/18/000002 002 - 2025/07/08/000002 002 - 2025/09/10/000002 002 - 2025/07/16/000002 002 - 2025/09/12/000001 002 - 2025/07/23/000002 002 - 2025/05/26/000002 002 - 2025/08/21/000002 002 - 2025/09/02/000002 002 - 2025/09/02/000003 002 - 2025/04/28/000001 002 - 2025/09/08/000002 002 - 2025/04/27/000002 002 - 2025/08/19/000003 002 - 2025/08/19/000002 003 - 2025/08/26/000002 003 - 2025/09/10/000003 003 - 2025/05/26/000003 003 - 2025/04/28/000002 003 - 2025/09/08/000004 003 - 2025/07/29/000003 003 - 2025/08/11/000003 003 - 2025/06/30/000003 003 - 2025/05/27/000003 003 - 2025/08/21/000003 003 - 2025/06/03/000003 004 - 2025/04/28/000003 2025/04/25/000001 - 001 2025/04/26/000001 - 001 2025/04/27/000001 - 001 2025/04/27/000002 - 002 2025/04/28/000001 - 002 2025/04/28/000002 - 003 2025/04/28/000003 - 004 2025/05/15/000001 - 001 2025/05/22/000001 - 001 2025/05/26/000001 - 001 2025/05/26/000002 - 002 2025/05/26/000003 - 003 2025/05/27/000001 - 001 2025/05/27/000002 - 002 2025/05/27/000003 - 003 2025/06/03/000001 - 001 2025/06/03/000002 - 002 2025/06/03/000003 - 003 2025/06/04/000001 - 001 2025/06/09/000001 - 001 2025/06/09/000002 - 002 2025/06/11/000001 - 001 2025/06/18/000001 - 001 2025/06/18/000002 - 002 2025/06/19/000001 - 001 2025/06/20/000001 - 001 2025/06/20/000002 - 002 2025/06/20/000003 - 002 2025/06/23/000001 - 001 2025/06/25/000001 - 001 2025/06/28/000001 - 001 2025/06/30/000001 - 001 2025/06/30/000002 - 002 2025/06/30/000003 - 003 2025/06/30/000004 - 001 2025/06/30/000005 - 001 2025/07/03/000001 - 001 2025/07/03/000002 - 002 2025/07/04/000001 - 001 2025/07/05/000001 - 001 2025/07/07/000001 - 001 2025/07/07/000002 - 002 2025/07/08/000001 - 001 2025/07/08/000002 - 002 2025/07/08/000004 - 001 2025/07/14/000001 - 001 2025/07/16/000001 - 001 2025/07/16/000002 - 002 2025/07/21/000001 - 001 2025/07/23/000001 - 001 2025/07/23/000002 - 002 2025/07/29/000001 - 001 2025/07/29/000002 - 002 2025/07/29/000003 - 003 2025/08/04/000001 - 001 2025/08/11/000001 - 001 2025/08/11/000002 - 002 2025/08/11/000003 - 003 2025/08/11/000004 - 001 2025/08/13/000001 - 001 2025/08/19/000001 - 001 2025/08/19/000002 - 002 2025/08/19/000003 - 002 2025/08/21/000001 - 001 2025/08/21/000002 - 002 2025/08/21/000003 - 003 2025/08/25/000001 - 001 2025/08/25/000002 - 001 2025/08/26/000001 - 001 2025/08/26/000002 - 003 2025/08/27/000001 - 001 2025/09/02/000001 - 001 2025/09/02/000002 - 002 2025/09/02/000003 - 002 2025/09/03/000001 - 001 2025/09/04/000001 - 001 2025/09/08/000001 - 001 2025/09/08/000002 - 002 2025/09/08/000003 - 001 2025/09/08/000004 - 003 2025/09/10/000001 - 001 2025/09/10/000002 - 002 2025/09/10/000003 - 003 2025/09/10/000004 - 001 2025/09/10/000006 - 001 2025/09/11/000001 - 001 2025/09/11/000002 - 001 2025/09/12/000001 - 002 2025/09/15/000001 - 001
tglsep
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tglrujukan
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
no_rujukan
varchar(30)
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', '3', '4')
latin1_swedish_ci
= != IS NULL IS NOT NULL
1
2
3
4
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(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
diagawal2
varchar(10)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nmdiagnosaawal2
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kdpolitujuan
varchar(5)
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('000', '100', '101', '102', '103', '104', '110', '200', '201', '202', '203', '204', '210', '300', '301', '302', '303', '304', '310', '311', '312', '400', '401', '402', '403', '404', '410', '411', '412', '413', '500', '510', '511', '512', '610', '611', '612', '613', '710', '711', '712', '713', '910', '911', '912', '913')
latin1_swedish_ci
= != IS NULL IS NOT NULL
000
100
101
102
103
104
110
200
201
202
203
204
210
300
301
302
303
304
310
311
312
400
401
402
403
404
410
411
412
413
500
510
511
512
610
611
612
613
710
711
712
713
910
911
912
913
klsdesc
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kdbu
varchar(12)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nmbu
varchar(200)
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')
latin1_swedish_ci
= != IS NULL IS NOT NULL
0
1
2
lokasilaka
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
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
jkel
enum('LAKI-LAKI', 'PEREMPUAN')
latin1_swedish_ci
= != IS NULL IS NOT NULL
LAKI-LAKI
PEREMPUAN
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
plan
varchar(35)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
plandesc
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
idakomodasi
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tipesjp
varchar(35)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tipecob
varchar(35)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL