Thai Care Clou d Nemo DMHT C A

Thai Care Clou d Nemo DM/HT C A S AD M h A P , p ro Bandit Thinkham D Isan C nter e C Direcoto is hor rt s ly a n A l a c ti s t and Stati Data Managemen niversity U n e a K n o h K , h lt ea Faculty of Public H CASCAP re CA Ca Cloud

Background • Thai Care Cloud has been developed based on PHP-My. SQL under YII 2 Framework. • It’s a web application that is free of charge for public use. • Thai Care Cloud originated from CASCAP Cloud at www. cascap. in. th – from one to any diseases. • Key developers are at the Data Management and Statistical Analysis Center (DAMASAC), Faculty of Public Health, Khon Kaen university, under the mission of the KKU's 50 years of social devotion.

Lots of applications for Thai Care Cloud Cancer Care Cloud Palliative Care Cloud PD, DPEX Disease Modules DM/HT Care Cloud COC CKD Care Cloud Smart Card Fast Track Patient Social Network Line Group

Thai Care Cloud as a tool for wisdom Improve care, Reduce cost, Problem solved Evidence-based practice Data collection, analysis, and report

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 TDC 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 TDC 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

HIS หลากหลายระบบ ตารางซบซอน TDC Client DB Standard data Real time Thai Care Cloud

องคประกอบของ TDC Client § § § Template Table Command Table Transfer Table Process Queue Table 43 + 7 + 2 Standard Table Views and Events Schedule

Template Table:

HIS Triggers Command Transfer Web Service Thai Care Cloud 43 + 7 +2 + X Files Views Events Process Queue

Triggers Create Trigger on table patients BEFORE/AFTER INSERT UPDATE DELETE DO ADD DATA TO Process Queue Real time Sync!!!

ตวอยาง Template Name: Create TDC Database Type: Command pre. SQL: DROP DATABASE IF EXISTS `_BUFFE_DB_`; SQL: CREATE DATABASE IF NOT EXISTS `_BUFFE_DB_` CHARACTER SET tis 620; ; Controller: command Name: Create F_Person Type: Command pre. SQL: DROP TABLE IF EXISTS `_BUFFE_DB_`. f_person; SQL: CREATE TABLE IF NOT EXISTS `_BUFFE_DB_`. `f_person` ( `sitecode` varchar(9) NOT NULL DEFAULT '', `HOSPCODE` varchar(9) NOT NULL DEFAULT '', `CID` varchar(26) DEFAULT '', `PID` varchar(11) NOT NULL DEFAULT '', `HOUSENO` varchar(10) DEFAULT NULL, `VILLCODE` varchar(25) DEFAULT NULL, `VILLNAME` varchar(250) DEFAULT NULL, `VILLAGE` varchar(5) DEFAULT NULL,

Name: Create F_Person Type: Command pre. SQL: DROP TABLE IF EXISTS `_BUFFE_DB_`. f_person; SQL: CREATE TABLE IF NOT EXISTS `_BUFFE_DB_`. `f_person` ( `sitecode` varchar(9) NOT NULL DEFAULT '', `HOSPCODE` varchar(9) NOT NULL DEFAULT '', `CID` varchar(26) DEFAULT '', `PID` varchar(11) NOT NULL DEFAULT '', `HOUSENO` varchar(10) DEFAULT NULL, `VILLCODE` varchar(25) DEFAULT NULL, `VILLNAME` varchar(250) DEFAULT NULL, `VILLAGE` varchar(5) DEFAULT NULL, `TAMBON` varchar(2) DEFAULT NULL, `AMPUR` varchar(2) DEFAULT NULL, `CHANGWAT` varchar(2) DEFAULT NULL, `Pre. Name` varchar(3) DEFAULT '', `Pname` varchar(50) DEFAULT '', `Name` varchar(100) DEFAULT '', `Lname` varchar(100) DEFAULT '', `HN` varchar(18) DEFAULT '', `sex` varchar(1) DEFAULT '', `Birth` date DEFAULT NULL, `Mstatus` varchar(1) DEFAULT NULL, `Occupation_Old` varchar(4) DEFAULT '', `Occupation_New` varchar(4) DEFAULT '', `Race` varchar(3) DEFAULT '', `Nation` varchar(3) DEFAULT '', `Religion` varchar(2) DEFAULT '', `Education` varchar(2) DEFAULT NULL, `Fstatus` varchar(1) DEFAULT '', `Father` varchar(26) DEFAULT '', `Mother` varchar(26) DEFAULT '', `Couple` varchar(26) DEFAULT '', `Vstatus` varchar(1) DEFAULT '', `Move. In` date DEFAULT NULL, `Discharge` varchar(1) DEFAULT '', `Ddischarge` date DEFAULT NULL, `ABOGROUP` varchar(20) DEFAULT NULL, `RHGROUP` varchar(5) DEFAULT '', `Labor` varchar(10) DEFAULT '', `Pass. Port` varchar(8) DEFAULT '', `Type. Area` varchar(11) DEFAULT NULL, `DEATH` varchar(2) DEFAULT NULL, `DDEATH` varchar(10) DEFAULT NULL, `D_Update` datetime DEFAULT NULL, `ptlink` varchar(32) DEFAULT NULL, PRIMARY KEY (`sitecode`, `PID`, `HOSPCODE`), KEY `ptlink` (`ptlink`), KEY `PID` (`PID`)) DEFAULT CHARSET=tis 620; Controller: command