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
id_tb_03
varchar(30)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
id_periode_laporan
enum('1=Januari - Maret', '2=April - Juni', '3=Juli - September', '4=Oktober - Desember')
latin1_swedish_ci
= != IS NULL IS NOT NULL
1=Januari - Maret
2=April - Juni
3=Juli - September
4=Oktober - Desember
tanggal_buat_laporan
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tahun_buat_laporan
year(4)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kd_wasor
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
noregkab
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
id_propinsi
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kd_kabupaten
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
id_kecamatan
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
id_kelurahan
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_rujukan
enum('Inisiatif pasien/Keluarga', 'Anggota Masyarakat/Kader', 'Faskes', 'Dokter Praktek Mandiri', 'Poli lain', 'Lain-lain')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Inisiatif pasien/Keluarga
Anggota Masyarakat/Kader
Faskes
Dokter Praktek Mandiri
Poli lain
Lain-lain
sebutkan1
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tipe_diagnosis
enum('Terkonfirmasi bakteriologis', 'Terdiagnosis klinis')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Terkonfirmasi bakteriologis
Terdiagnosis klinis
klasifikasi_lokasi_anatomi
enum('Paru', 'Ekstraparu')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Paru
Ekstraparu
klasifikasi_riwayat_pengobatan
enum('Baru', 'Kambuh', 'Diobati setelah gagal', 'Diobati Setelah Putus Berobat', 'Lain-lain', 'Riwayat Pengobatan Sebelumnya Tidak Diketahui', 'Pindahan')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Baru
Kambuh
Diobati setelah gagal
Diobati Setelah Putus Berobat
Lain-lain
Riwayat Pengobatan Sebelumnya Tidak Diketahui
Pindahan
klasifikasi_status_hiv
enum('Positif', 'Negatif', 'Tidak diketahui')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Positif
Negatif
Tidak diketahui
total_skoring_anak
enum('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', 'Tidak dilakukan')
latin1_swedish_ci
= != IS NULL IS NOT NULL
1
2
3
4
5
6
7
8
9
10
11
12
13
Tidak dilakukan
konfirmasiSkoring5
enum('Uji Tuberkulin Positif', 'Ada Kontak TB Paru', 'Uji Tuberkulin Negatif', 'Tidak Ada Kontak TB Paru')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Uji Tuberkulin Positif
Ada Kontak TB Paru
Uji Tuberkulin Negatif
Tidak Ada Kontak TB Paru
konfirmasiSkoring6
enum('Ada Kontak TB Paru', 'Tidak Ada', 'Tidak Jelas Kontak TB Paru')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Ada Kontak TB Paru
Tidak Ada
Tidak Jelas Kontak TB Paru
tanggal_mulai_pengobatan
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
paduan_oat
varchar(500)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
sumber_obat
enum('Program TB', 'Bayar Sendiri', 'Asuransi', 'Lain-lain')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Program TB
Bayar Sendiri
Asuransi
Lain-lain
sebutkan
varchar(500)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
sebelum_pengobatan_hasil_mikroskopis
enum('Negatif', '1-19', '1+', '2+', '3+', 'Tidak dilakukan')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Negatif
1-19
1+
2+
3+
Tidak dilakukan
sebelum_pengobatan_hasil_tes_cepat
enum('Rif sensitif', 'Rif resisten', 'Negatif', 'Rif Indeterminated', 'Invalid', 'Error', 'No Result', 'Tidak dilakukan')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Rif sensitif
Rif resisten
Negatif
Rif Indeterminated
Invalid
Error
No Result
Tidak dilakukan
sebelum_pengobatan_hasil_biakan
enum('Negatif', '1-19 BTA', '1+', '2+', '3+', '4+', 'NTM', 'Kontaminasi', 'Tidak dilakukan')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Negatif
1-19 BTA
1+
2+
3+
4+
NTM
Kontaminasi
Tidak dilakukan
noreglab_bulan_2
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
hasil_mikroskopis_bulan_2
enum('Negatif', '1-19', '1+', '2+', '3+', 'Tidak dilakukan')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Negatif
1-19
1+
2+
3+
Tidak dilakukan
noreglab_bulan_3
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
hasil_mikroskopis_bulan_3
enum('Negatif', '1-19', '1+', '2+', '3+', 'Tidak dilakukan')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Negatif
1-19
1+
2+
3+
Tidak dilakukan
noreglab_bulan_5
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
hasil_mikroskopis_bulan_5
enum('Negatif', '1-19', '1+', '2+', '3+', 'Tidak dilakukan')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Negatif
1-19
1+
2+
3+
Tidak dilakukan
akhir_pengobatan_noreglab
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
akhir_pengobatan_hasil_mikroskopis
enum('Negatif', '1-19', '1+', '2+', '3+', 'Tidak dilakukan')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Negatif
1-19
1+
2+
3+
Tidak dilakukan
tanggal_hasil_akhir_pengobatan
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
hasil_akhir_pengobatan
enum('Belum', 'Sembuh', 'Pengobatan Lengkap', 'Lost To Follow Up', 'Meninggal', 'Gagal', 'Pindah', '')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Belum
Sembuh
Pengobatan Lengkap
Lost To Follow Up
Meninggal
Gagal
Pindah
tanggal_dianjurkan_tes
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tanggal_tes_hiv
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
hasil_tes_hiv
enum('Reaktif', 'Non Reaktif', 'Indeterminated')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Reaktif
Non Reaktif
Indeterminated
ppk
enum('Ya', 'Tidak')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Ya
Tidak
art
enum('Ya', 'Tidak')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Ya
Tidak
tb_dm
enum('Ya', 'Tidak')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Ya
Tidak
terapi_dm
enum('OHO', 'Inj. Insulin', '')
latin1_swedish_ci
= != IS NULL IS NOT NULL
OHO
Inj. Insulin
pindah_ro
enum('Ya', 'Tidak')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Ya
Tidak
status_pengobatan
enum('Sesuai Standar', 'Tidak Sesuai Standar')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Sesuai Standar
Tidak Sesuai Standar
foto_toraks
enum('Positif', 'Negatif', 'Tidak Dilakukan')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Positif
Negatif
Tidak Dilakukan
toraks_tdk_dilakukan
enum('Tidak dilakukan', 'Setelah terapi antibioka non OAT: tidak ada perbaikan Klinis, ada faktor resiko TB, dan atas pertimbangan dokter', 'Setelah terapi antibioka non OAT: ada Perbaikan Klinis')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Tidak dilakukan
Setelah terapi antibioka non OAT: tidak ada perbaikan Klinis
ada faktor resiko TB
dan atas pertimbangan dokter
Setelah terapi antibioka non OAT: ada Perbaikan Klinis
keterangan
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kode_icd_x
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
