Struktur Data Integrasi 3 Software Sistem Informasi Puskesmas di Gunungkuidul

mysql sim_sisdinkesStandar file integrasi :

Contoh :

report_01-2014_puskesmas_tanjungsari.zip

report_01-2014_puskesmas_patuk-i.zip

 

Berisi 3 file yaitu, contoh :

diagnosis_01-2014-puskesmas_tanjungsari.csv

kunjungan_01-2014-puskesmas_tanjungsari.csv

resep_01-2014-puskesmas_tanjungsari.csv

 

Struktur Data:

dinkes_visit

Column Type Null Default
id char(25) No  
visit_id varchar(10) Yes NULL
puskesmas_code varchar(30) Yes NULL
jeniskunjungan enum(‘L’, ‘B’) Yes NULL
noRM varchar(255) Yes NULL
nama varchar(150) Yes NULL
location varchar(13) Yes NULL
visit_date date Yes NULL
sex enum(‘L’, ‘P’) Yes P
age_year smallint(2) Yes NULL
age_month smallint(2) Yes NULL
age_day smallint(3) Yes NULL
age_group smallint(2) Yes NULL
dinas_id smallint(2) Yes NULL
insurance_no varchar(20) Yes NULL
poli_name varchar(70) Yes NULL
nik varchar(16) Yes NULL
origin enum(‘DW’, ‘LW’) Yes DW

dinkes_diagnosis

Column Type Null Default Comments
id char(25) No    
visit_id varchar(10) Yes NULL  
icd_code varchar(6) Yes NULL  
case enum(‘B’, ‘L’) Yes L  
puskesmas_code varchar(30) Yes NULL  

dinkes_prescription

Column Type Null Default Comments
id char(25) No    
visit_id varchar(10) No    
drugs_code varchar(6) No    
quantity double(10,3) No    
puskesmas_code varchar(30) Yes NULL  

 

nf

Leave a Reply

Your email address will not be published. Required fields are marked *