Introduction
Healthcare delivery systems
Health information system in Uganda
Healthcare supply management system
Methods
Step 1: site selection
Step 2: understanding issues facing health practitioners in selected sites
Step 3: development of system requirements
Sector | Function | Requirements |
---|---|---|
Sourcing | Once the commodities from the national medical store arrive at the healthcare facility, record item details such as names, quantities, expiry dates, arrival times | |
Supply Chain Management (SCM) | Item coding | Assign unique codes to identify commodities so that users can easily pull-out records for each item for detailed analysis and audits |
Dispatching | Capture quantities of products dispatched to wards such as the MCH unit and the lab. Record logs of dispensed commodities to capture consumption rates | |
Inventory management | Capture up-to-date sourcing and dispensing records. Aggregate logs to generate monthly transaction reports. Let warehouse managers manually override and adjust inventory levels and record it with reasons to keep transparency | |
Determination of order quantities | Suggest order quantity for each health product. Store managers can refer to the suggested order. Forecasted order quantities generated can be used directly as the order | |
Electronic Medical Record (EMR) | Patient record | Contains all information about the patient, such as admissions, prescriptions, diagnoses, lab results, antenatal records, and deliveries. Prescriptions are used to calculate consumption rates of health products |
Ministry of Health (MOH) Monthly reports | Generate monthly reports in standardized formats as required by Uganda MOH | |
Demand Sensing Integration | Lab dispensing log | Besides EMR (patient data) and SCM (inventory data), record daily activities in the labs: number of tests and patients, number not performed due to lack of supplies, and quantity of supplies and reagents used |
Integration | Triangulate consumption and sourcing data from labs, stores, and MCH units with patient data to forecast and generate purchase orders automatically |
Step 4: development of system architecture
Key features of E+TRA health system
Feature | Detail |
---|---|
Cloud-based | Any device with a web browser can use this system, including computers, smart phones, and tablets, with no installation or software updates. All maintenance and updates are done at the server side |
Coded in open-source language | |
Offline-compatible | In developing countries, different departments of a healthcare facility are quite far from each other. Some locations are not covered by wi-fi signals. There are power outages that shut down the routers. Open-source data collection software (e.g., OpenDataKit) provides offline function (Additional file 1: Appendix Fig. S1). Data is stored locally on the devices not covered by wi-fi signals and is uploaded and synchronized automatically when they get access to the local network |
Cross-platform | Accessible in different operating systems, e.g., Windows, Mac OS, Android, iOS, etc |
transparency | Track any item from receiving from national/district medical stores to dispensing to patients. All transactions/movements and manual adjustments are recorded |
Automatic report generation | Generate monthly standardized reports in real time, which are required to submit to the Ministry of Health of Uganda every month, would take one week for staff to manually generate (Additional file 1: Appendix Fig. S2). Visualize data collected (Additional file 1: Appendix Fig. S3) to support decision making |
Full patient record | Once admitted during their first visit, future visit histories will be connected automatically via patient ID that is assigned |
Automatic inventory level updates | Supply data is extracted from the sourcing forms. Consumption data is extracted from patient prescriptions and lab activities. Store managers no longer manually update and track stock levels on paper or spreadsheets. Full history of transactions of each commodity is recorded in the system and visualized (Additional file 1: Appendix Fig. S4) |
Generation of order quantities | Triangulates data collected from MCH, lab, and main store to forecast the order quantities to the national store, based on maximum stock levels of the health facility |
Step 5: integrating system with practitioner workflow
-
Main store good receiving note and good delivery note.The system was integrated with the ‘main store’ workflow by the development of the ‘notes feature’. The good receiving note was used to record what items have been received from the national/district medical store, while the good delivery note was used to record what has been dispatched to the MCH unit and the lab. The main store manager was in charge of completing these two forms. Inventory levels in the main store, lab, and MCH are updated automatically, so the main store manager did not need to manually update the inventory levels.
-
MCH unitThe system was integrated with the MCH unit workflow by the development of patient forms such as the admission form, the diagnosis form, the lab report, the prescription form, and the delivery form replace HMIS form 071 (Antenatal Register) and HMIS form 072 (Integrated Maternity Register) (see Additional file 1: Fig. S5).To improve workflow in digital forms, two paper-based forms were separated into five digital forms, since fields are filled at disjoint times: admission, lab result, doctor’s diagnosis, prescription issued, and delivery. All five forms were connected via the patient ID. Therefore, the information was filled exactly and only once. Entire patient history was tracked via patient ID. Inventory levels were deducted automatically upon submission of prescription forms.
-
LabThe system was integrated with the Lab workflow by the development of two forms to estimate commodity usage. The lab commodity dispensing form captures dispensing information of lab products. Lab products come in large volume bottles for multiple tests. It is difficult to count how many drops are used during each test. The form was designed to be filled when one countable unit of quantity is used, such as one bottle. The lab daily activity report captured the number of tests and patients served daily.
Step 6: design of information flow
Results
System testing and deployment
-
Mukono Health Center IV: laptop, router, wi-fi extender, 8 tablets.
-
Kojja Health Center IV: laptop, router, wi-fi extender, 5 tablets.
Summary of data collected from system deployment
Department | Forms | Kojja HC IV | Mukono HC IV |
---|---|---|---|
MCH | Patient admission | 1275 | 4417 |
Patient diagnosis | 104 | 6 | |
Patient prescription | 906 | 43 | |
Patient delivery | 39 | 0 | |
Patient lab tests | 252 | 11 | |
Lab | Lab dispensing report | 3 | 0 |
Lab activity report | 16 | 0 | |
Main store | Main store receiving form | 9 | 0 |
Main store distribution form | 0 | 1 |
Predictive model
-
Type 1 Demand forecasting is not applicable due to the lack of previous consumption data
-
Type 2 Demand forecasting for immediate future is possible with limited consumption data
-
Type 3 Demand forecasting for an extended period of time is possible with sufficient consumption data
Item ID | Item name | Actual demand | Predictive demand | Ven scale |
---|---|---|---|---|
1 | Artemether/Lumefantrine 120 mg tablet | 22 | 30 | Vital |
7 | Determine HIV Screening tests | 30 | 30 | |
10 | Malaria Rapid Diagnostic tests | 3 | 10 | |
21 | Nevirapine (NVP) 50 mg | 3 | 10 | |
22 | Cotrimoxazole 960 mg tablet | 30 | 30 | Vital |
28 | Ceftriaxone 1 g Injection | 1 | 10 | Vital |
46 | Iron | 270 | 300 | Essential |
100 | Pregnancy test strips 50 strips | 100 | 100 | |
346 | Erythromycin tablets bp 250 mg | 120 | 120 | Vital |
353 | Etonogestrel 150 mg implant (implanon) | 1 | 10 | Vital |
357 | Lamivudine, Zidovudine and Nevirapine tablets | 1470 | 1500 | |
360 | Efavirez, Lamuvidine, Torofoir, Disoproxil, Fumarate 600/300/300 mg | 1750 | 1800 | |
365 | Multivitamin tablets | 120 | 120 | Necessary |
339–1 | Doxycycline capsules 100 mg | 80 | 80 | Vital |
339–2 | CANNULA I.V, 20G. 0.9MM | 36 | 40 | Essential |
Item ID | Item name | Actual demand | Predictive demand | Ven scale |
---|---|---|---|---|
3 | Co-tromoxazole 480 mg tablet | 250 | 285 | Vital |
15 | Zidovudine/lamivudine/nevirapine | 215 | 210 | |
44 | Folic Acid | 600 | 620 | Essential |
347 | Amoxicilin capsules | 25 | 30 | Vital |
349 | Metronidazole tablets | 60 | 75 | Vital |