Data Transfer by Thai Care Cloud User National

Data Transfer by Thai Care Cloud User National Health Database Ministry of Public Health User DHS DHS DHS

Data Transfer by Thai Care Cloud User Two ways, Automatic data transfer, Real time manner User National Health Database User Ministry of Public Health User DHS DHS DHS

Toward the National HIS User National Health Database Ministry of Public Health User DHS DHS DHS

TDC: Thai Database connector Thai Care Cloud Internet Server Install TDC Master TDC Password Slave: connected to internet Firewall HIS Internal Network Request commands from the TCC web service Data recorded based on routine care Data selected based on standard data set EMR • HIS Server Admin • Service provider • Others who were Internet authorized by Site Admin • EMR Owner Summary data or reports • Report for Inbound rejected CID, Name, Surname, House. Num, Village. Num Standard data structure provided via web service Individual record • HIS Server Admin • Service provider • Others who were authorized by Site Admin TCC Web Service Data encoded and encrypted Fields encrypted: Inbound rejected Internet Users 77 Provinces 13 Health Zones 1 Main Server Individual records Summary records Report only monitoring and evaluation -> Health administrators • General report -> Any users

TDC Core Syntax (cont. ) Trigger name CREATE TRIGGER before_employee_update BEFORE UPDATE ON employees Table Views in HIS FOR EACH ROW BEGIN Table in TCC Server INSERT INTO employees_audit SET action = 'update', employee. Number = OLD. employee. Number, lastname = OLD. lastname, changedat = NOW(); END Standard data set (Data Dictionary) Table Views In the Web service Table Views In the HIS Server • • • • • PERSON ADDRESS DEAD CARD DRUGALLERGY etc.