| Literature DB >> 36096800 |
Dawei Wang1,2, Rhoann Kerh1, Sungbum Jun3, Seokcheon Lee1, Roy William Mayega4,5, Julius Ssentongo4, Andualem Oumer6, Md Haque7, Priyanka Brunese1,8, Yuehwern Yih9,10,11.
Abstract
BACKGROUND: Thirteen essential maternal child health (MCH) commodities, identified by the UN Commission on Life-Saving Commodities for Women and Children, could save the lives of more than 6 million women and children in Low-and-Middle-Income Countries (LMICs) if made available at the point of care. To reduce stockout of those commodities and improve the health supply chains in LMICs, the Electronic TRAcking system for healthcare commodities (E+TRA Health), an all-in-one out-of-box solution, was developed to track and manage medical commodities at lower-level health facilities in rural areas. It aims to support real-time monitoring and decision-making to (1) reduce the time needed to prepare orders, (2) reduce stockout and overstock cases of targeted medical supplies, (3) help improve patient outcomes. In this study, we adopted an integrated approach to analyze the process of information flow, identify and address critical paths of essential supplies associated with maternal health in the Ugandan health system.Entities:
Keywords: Demand sensing; Electronic medical record (EMR); Healthcare supply chain management; Maternal child health (MCH)
Mesh:
Year: 2022 PMID: 36096800 PMCID: PMC9469598 DOI: 10.1186/s12911-022-01982-8
Source DB: PubMed Journal: BMC Med Inform Decis Mak ISSN: 1472-6947 Impact factor: 3.298
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 |
Fig. 1E+TRA health 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 | The website is coded in an open-source language, PHP, which is relatively easy to develop and maintain. As of 2019, 79% of all server-side websites use PHP [ |
| 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 |
| 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 |
| 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 |
| 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 |
Fig. 2Document flow for MCH
Data overview
| 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 |
Type 1 item prediction result
| 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 |
Type 2 item prediction result
| 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 |
Fig. 3Demand prediction for sulfadoxine/pyrimethamine tablet
Fig. 4Demand prediction for tenofovir/lamivudine/efavirenz tablet
Fig. 5Demand prediction for cotrimoxazole tablet