The implementation of data warehouse for result reporting system: The case of out patient university clinic in Thailand

Abstract

This research aims to develop a result reporting system by utilizing data from a data warehouse designed for an outpatient clinic in a Thai university. Through a case study of the data warehouse, existing reports, data limitations of the hospital information system (HIS), and other information systems will be analyzed to extract data for use in the prototype data warehouse. The research findings indicate that the prototype data warehouse for performance reporting will consist of six main tables: patients, diagnosis, drugs and medical supplies, procedures and medical services, drug transactions, and procedure, medical service transactions. These data warehouse tables will be used to create reports with tabs for main dashboard, diagnosis, drug, and service. Each indicator and report can be drilled down into detailed levels and presented in various visual formats such as charts and tables. This data can be used to compare statistics by group of patients.

References

คณะทำงานกรอบการพัฒนาคุณภาพเทคโนโลยีสารสนเทศ โรงพยาบาล, กรอบการพัฒนาคุณภาพเทคโนโลยี สารสนเทศโรงพยาบาล Hospital IT Quality Improve ment Framework (HITQIF) 2.0, สมาคมเวชสารสนเทศ ไทย, 2564.

R. Kimball and M. Ross, The Data Warehouse Tool kit: The Complete Guide to Dimensional Modeling, 3rd ed., Indianapolis: John Wiley & Sons Inc, 2013.

J. R. Schubart and J. S. Einbinder, "Case study: a data warehouse for an academic medical center," Journal of Healthcare Information Management, vol. 15, no. 2, Summer 2001.

M. D. Krasowski, et al., "Use of a data warehouse at an academic medical center for clinical pathology quality improvement, education, and research," Journal of Pathology Informatics, vol. 6, no. 1, 2015.

J. R. Schubart and J. S. Einbinder, "Evaluation of a data warehouse in an academic health sciences center," International Journal of Medical Informatics, vol. 60, no. 3, pp. 319-333, 2000.

K. U. Kortüm, et al., "Using Electronic Health Records to Build an Ophthalmologic Data Warehouse and Visualize Patients' Data," American Journal of Ophthalmology, vol. 178, pp. 84-93, 2017.

R. D. Thantilage, N.-A. Le-Khac, and M.-T. Kechadi, "Healthcare data security and privacy in Data Warehouse architectures," Informatics in Medicine Unlocked, vol. 39, 2023.

S. Pattaravoratham, "การพัฒนาคลังข้อมูลด้านเวชศาสตร์ ฟื้นฟูโรงพยาบาลกลาง," Vajira Medical Journal, vol. 56, no. 3, Sep.-Dec. 2012.

บุรินทร์ สุรอรุณสัมฤทธิ์, "คู่มือการตรวจประเมินคุณภาพ การบันทึกเวชระเบียน," สำนักตรวจสอบการชดเชยและ คุณภาพบริการ ส􀂷ำนักงานหลักประกันสุขภาพแห่งชาติ, กรุงเทพฯ, 2563.