no_surat
varchar(20)
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
tanggal
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nama_pj
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
umur_pj
varchar(3)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
no_ktppj
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
alamatpj
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
no_telppj
varchar(30)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
hubungan
enum('Suami', 'Istri', 'Anak', 'Ayah', 'Ibu', 'Saudara', 'Keponakan', 'Diri Sendiri')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Suami
Istri
Anak
Ayah
Ibu
Saudara
Keponakan
Diri Sendiri
ruang
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
dokter_pengirim
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
pelayanan_dilakukan
varchar(120)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ditunda_karena
enum('Kerusakan Alat', 'Kondisi Umum Pasien', 'Penundaan Penjadwalan', 'Pemadaman Instalasi Listrik', 'Lain-lain')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Kerusakan Alat
Kondisi Umum Pasien
Penundaan Penjadwalan
Pemadaman Instalasi Listrik
Lain-lain
keterangan_ditunda
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
alternatif_diberikan
enum('Dijadwalkan Ulang', 'Dirujuk Ke Layanan Kesehatan Lain', 'Dikembalikan Kepada Dokter Pengirim', 'Lain-lain')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Dijadwalkan Ulang
Dirujuk Ke Layanan Kesehatan Lain
Dikembalikan Kepada Dokter Pengirim
Lain-lain
keterangan_alternatif_diberikan
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nip
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - 013 - 013 123 - 123 012345678 - 012345678 200808006 - 200808006 200808007 - 200808007 200808009 - 200808009 201201013 - 201201013 201305014 - 201305014 201408015 - 201408015 201703019 - 201703019 201704020 - 201704020 201808025 - 201808025 201811026 - 201811026 201901028 - 201901028 202201035 - 202201035 202201044 - 202201044 202204036 - 202204036 202206040 - 202206040 202208042 - 202208042 202209043 - 202209043 202210044 - 202210044 202211039 - 202211039 202302045 - 202302045 202306049 - 202306049 202406052 - 202406052 202406053 - 202406053 202409054 - 202409054 202409056 - 202409056 202412057 - 202412057 202412058 - 202412058 202503059 - 202503059 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D000009 - D000009 D08 - D08 - - - 013 - 013 123 - 123 012345678 - 012345678 200808006 - 200808006 200808007 - 200808007 200808009 - 200808009 201201013 - 201201013 201305014 - 201305014 201408015 - 201408015 201703019 - 201703019 201704020 - 201704020 201808025 - 201808025 201811026 - 201811026 201901028 - 201901028 202201035 - 202201035 202201044 - 202201044 202204036 - 202204036 202206040 - 202206040 202208042 - 202208042 202209043 - 202209043 202210044 - 202210044 202211039 - 202211039 202302045 - 202302045 202306049 - 202306049 202406052 - 202406052 202406053 - 202406053 202409054 - 202409054 202409056 - 202409056 202412057 - 202412057 202412058 - 202412058 202503059 - 202503059 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D000009 - D000009 D08 - D08
kd_dokter
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - 20232047 - 20232047 D0000001 - D0000001 D0000002 - D0000002 D0000003 - D0000003 D0000004 - D0000004 D0000005 - D0000005 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D0000009 - D0000009 - - - 20232047 - 20232047 D0000001 - D0000001 D0000002 - D0000002 D0000003 - D0000003 D0000004 - D0000004 D0000005 - D0000005 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D0000009 - D0000009
