| gabung_id |
bigint(20)
|
|
|
|
| no_rkm_medis |
varchar(15)
|
utf8_general_ci
|
|
|
| nm_pasien |
varchar(40)
|
utf8_general_ci
|
|
|
| no_ktp |
varchar(20)
|
utf8_general_ci
|
|
|
| jk |
enum('L', 'P')
|
utf8_general_ci
|
|
|
| tmp_lahir |
varchar(15)
|
utf8_general_ci
|
|
|
| tgl_lahir |
date
|
|
|
|
| nm_ibu |
varchar(40)
|
utf8_general_ci
|
|
|
| alamat |
varchar(200)
|
utf8_general_ci
|
|
|
| gol_darah |
enum('A', 'B', 'O', 'AB', '-')
|
utf8_general_ci
|
|
|
| pekerjaan |
varchar(60)
|
utf8_general_ci
|
|
|
| stts_nikah |
enum('BELUM MENIKAH', 'MENIKAH', 'JANDA', 'DUDHA', 'JOMBLO')
|
utf8_general_ci
|
|
|
| agama |
varchar(12)
|
utf8_general_ci
|
|
|
| tgl_daftar |
date
|
|
|
|
| no_tlp |
varchar(40)
|
utf8_general_ci
|
|
|
| umur |
varchar(30)
|
utf8_general_ci
|
|
|
| pnd |
enum('TS', 'TK', 'SD', 'SMP', 'SMA', 'SLTA/SEDERAJAT', 'D1', 'D2', 'D3', 'D4', 'S1', 'S2', 'S3', '-')
|
utf8_general_ci
|
|
|
| keluarga |
enum('AYAH', 'IBU', 'ISTRI', 'SUAMI', 'SAUDARA', 'ANAK', 'DIRI SENDIRI', 'LAIN-LAIN')
|
utf8_general_ci
|
|
|
| namakeluarga |
varchar(50)
|
utf8_general_ci
|
|
|
| kd_pj |
char(3)
|
utf8_general_ci
|
|
|
| no_peserta |
varchar(25)
|
utf8_general_ci
|
|
|
| kd_kel |
int(11)
|
|
|
|
| kd_kec |
int(11)
|
|
|
|
| kd_kab |
int(11)
|
|
|
|
| pekerjaanpj |
varchar(35)
|
utf8_general_ci
|
|
|
| alamatpj |
varchar(100)
|
utf8_general_ci
|
|
|
| kelurahanpj |
varchar(60)
|
utf8_general_ci
|
|
|
| kecamatanpj |
varchar(60)
|
utf8_general_ci
|
|
|
| kabupatenpj |
varchar(60)
|
utf8_general_ci
|
|
|
| perusahaan_pasien |
varchar(8)
|
utf8_general_ci
|
|
|
| suku_bangsa |
int(11)
|
|
|
|
| bahasa_pasien |
int(11)
|
|
|
|
| cacat_fisik |
int(11)
|
|
|
|
| email |
varchar(50)
|
utf8_general_ci
|
|
|
| nip |
varchar(30)
|
utf8_general_ci
|
|
|
| kd_prop |
int(11)
|
|
|
|
| propinsipj |
varchar(30)
|
utf8_general_ci
|
|
|
| simrs_id |
bigint(30)
|
|
|
|
| simrs_user |
varchar(99)
|
utf8_general_ci
|
|
|
| simrs_nama |
varchar(99)
|
utf8_general_ci
|
|
|
| simrs_gelardepan |
varchar(22)
|
utf8_general_ci
|
|
|
| simrs_gelarbelakang |
varchar(22)
|
utf8_general_ci
|
|
|
| simrs_tempat |
varchar(22)
|
utf8_general_ci
|
|
|
| simrs_lahir |
date
|
|
|
|
| simrs_npwp |
varchar(22)
|
utf8_general_ci
|
|
|
| simrs_ktp |
varchar(22)
|
utf8_general_ci
|
|
|
| simrs_alamat |
text
|
utf8_general_ci
|
|
|
| simrs_kodepos |
int(5)
|
|
|
|
| simrs_telp |
varchar(22)
|
utf8_general_ci
|
|
|
| simrs_email |
varchar(33)
|
utf8_general_ci
|
|
|
| simrs_kelamin |
varchar(99)
|
utf8_general_ci
|
|
|
| simrs_darah |
varchar(99)
|
utf8_general_ci
|
|
|
| simrs_agama |
varchar(99)
|
utf8_general_ci
|
|
|
| simrs_kawin |
varchar(22)
|
utf8_general_ci
|
|
|
| simrs_kerja |
varchar(22)
|
utf8_general_ci
|
|
|
| simrs_prov |
varchar(22)
|
utf8_general_ci
|
|
|
| simrs_kab |
varchar(22)
|
utf8_general_ci
|
|
|
| simrs_kec |
varchar(22)
|
utf8_general_ci
|
|
|
| simrs_kel |
varchar(22)
|
utf8_general_ci
|
|
|
| simrs_pend |
int(4)
|
|
|
|
| simrs_namap |
varchar(33)
|
utf8_general_ci
|
|
|
| simrs_foto |
varchar(33)
|
utf8_general_ci
|
|
|
| simrs_status |
int(1)
|
|
|
|
| simrs_tanggal |
date
|
|
|
|
| simrs_alergi |
text
|
utf8_general_ci
|
|
|
| simrs_idrm |
varchar(22)
|
utf8_general_ci
|
|
|
| simrs_noKartu |
varchar(100)
|
utf8_general_ci
|
|
|
| simrs_noMr |
varchar(100)
|
utf8_general_ci
|
|
|
| simrs_kdJenisPeserta |
varchar(5)
|
utf8_general_ci
|
|
|
| simrs_nmJenisPeserta |
varchar(100)
|
utf8_general_ci
|
|
|
| simrs_kdKelas |
varchar(5)
|
utf8_general_ci
|
|
|
| simrs_nmKelas |
varchar(100)
|
utf8_general_ci
|
|
|
| simrs_statusPeserta |
varchar(100)
|
utf8_general_ci
|
|
|
| simrs_tglCetakKartu |
date
|
|
|
|
| simrs_tglTAT |
date
|
|
|
|
| simrs_tglTMT |
date
|
|
|
|
| simrs_umur |
varchar(4)
|
utf8_general_ci
|
|
|
| gabung_source_status |
varchar(40)
|
utf8_general_ci
|
|
|
| gabung_match_rule |
varchar(40)
|
utf8_general_ci
|
|
|
