Abstract
Introduction: The Covid-19 pandemic that swept across our country claimed the lives of many and has altered the healthcare management. The increase in cases in the Federal Territory of Labuan peaked at two points: after the election in Sabah and following the wave of the Delta variant, which entailed the entry of workers from the shipping industry into Malaysia. Systematic and efficient data management is critical in pandemic management to develop effective control and prevention strategies. In the Health Department of Labuan, the data collected from each screening counter will be manually entered into Microsoft Excel software on a regular basis, which requires a lot of manpower and takes a long time to analyze. When it comes to how this works, data accessibility is limited, and backlogs are common. The objective of this innovation is to develop a secure and easy database management for every Covid-19 health screening for the population of Federal Territory of Labuan. This includes case index data, close contact screening and home surveillance order monitoring.
Method: The SWOT analysis approach has been used in the development of this system. This database application system was created using a combination of computer languages, including MYSQLi, PHP, HTML 5, and JavaScript, and is built on WeBase using mySQL and Apache. The time and manpower required for the same task are compared while using Microsoft Excel software and using system database applications.
Result: In comparison, the update of the screening data in this system show that the time used for entering and analyzing the data can be reduced by 55.13 %, and the manpower can be saved up to 50 % for the same task load. The cost of labor paid for the overtime of employees was reduced to 50 % for the same task load as well. Discussion: With a significant reduction in time and manpower required in data management, this project has met its main objective. Besides that, with the addition of several modules in the system, it has helped in disease control, prevention, contentment, enforcement, home surveillance order and the application of current policies. This effort was also a pillar in Labuan's accomplishment in becoming the first state to reach phase 4 during the pandemic and the state with the highest drop Covid-19 cases in Malaysia with 95.01% case reduction in 7 weeks. Way forward, this system application may be expanded to encompass the systematic management of data related to other infectious diseases, vaccination program and pandemic preparedness.
Links
- https://apcph.cphm.my/wp-content/uploads/2022/07/APCPH2022-P-42.pdf
- https://apcph.cphm.my/wp-content/uploads/wpforms/1176-1e04940bb5d885bf8711ed1909[...]
BibTeX (Download)
@proceedings{APCPH2022-P-42,
title = {EL-COVID Database Data Management During Pandemic COVID 19: Labuan FT Experience},
author = {Sabrina Dhanamani Daniel and Welly Welson Sominding and Jemhi Pian and Aaron Ryan Zoni and Mohd Zaki Ab. Hamid and Ismuni Bohari},
url = {https://apcph.cphm.my/wp-content/uploads/2022/07/APCPH2022-P-42.pdf
https://apcph.cphm.my/wp-content/uploads/wpforms/1176-1e04940bb5d885bf8711ed19095a89ed/EL-COVID-Database-Data-Management-During-Pandemic-COVID-19-Labua-73f649a70daa92179d5112eaafa8e3bf.pdf},
year = {2022},
date = {2022-08-02},
urldate = {2022-08-02},
issue = {7},
abstract = {Introduction: The Covid-19 pandemic that swept across our country claimed the lives of many and has altered the healthcare management. The increase in cases in the Federal Territory of Labuan peaked at two points: after the election in Sabah and following the wave of the Delta variant, which entailed the entry of workers from the shipping industry into Malaysia. Systematic and efficient data management is critical in pandemic management to develop effective control and prevention strategies. In the Health Department of Labuan, the data collected from each screening counter will be manually entered into Microsoft Excel software on a regular basis, which requires a lot of manpower and takes a long time to analyze. When it comes to how this works, data accessibility is limited, and backlogs are common. The objective of this innovation is to develop a secure and easy database management for every Covid-19 health screening for the population of Federal Territory of Labuan. This includes case index data, close contact screening and home surveillance order monitoring.
Method: The SWOT analysis approach has been used in the development of this system. This database application system was created using a combination of computer languages, including MYSQLi, PHP, HTML 5, and JavaScript, and is built on WeBase using mySQL and Apache. The time and manpower required for the same task are compared while using Microsoft Excel software and using system database applications.
Result: In comparison, the update of the screening data in this system show that the time used for entering and analyzing the data can be reduced by 55.13 %, and the manpower can be saved up to 50 % for the same task load. The cost of labor paid for the overtime of employees was reduced to 50 % for the same task load as well. Discussion: With a significant reduction in time and manpower required in data management, this project has met its main objective. Besides that, with the addition of several modules in the system, it has helped in disease control, prevention, contentment, enforcement, home surveillance order and the application of current policies. This effort was also a pillar in Labuan's accomplishment in becoming the first state to reach phase 4 during the pandemic and the state with the highest drop Covid-19 cases in Malaysia with 95.01% case reduction in 7 weeks. Way forward, this system application may be expanded to encompass the systematic management of data related to other infectious diseases, vaccination program and pandemic preparedness.},
howpublished = {published online at https://apcph.cphm.my},
note = {Type: POSTER PRESENTATION; Organisation:},
keywords = {Covid-19, Database, FT Labuan, Management., Pandemic},
pubstate = {published},
tppubtype = {proceedings}
}