Reports & Dashboard
Overview
Dashboards: should give summary data that can aid health facility managers in decision making on a day to day basis.
Reports**:** The system should support generation of routine and custom reports
Actors
- Health Facility Administrators : Track and Manage financial resources,Human resources,Patient Management
- Clinician : Clinical management of patients
- Clinical Manager : Management of Patients and clinical staff
- Lab Manager : Stock management
- Pharmacy Manager
- County/District Health Manager
- National Health Manager
User Stories for Dashboards
Actor: As a Health Facility Administrator
- I should be able to know the number of staff on duty by cadre and workload to inform duty reassignment
- I should be able to know how how much revenue was collected
- I should be able to know pending payments to manage the process of insurance claims.
- I should be able to know the number of patients scheduled for the day segregated by service area (manage duty roster)
- I should be able to know the number of patients at each service delivery point
- I should be able to know the number of patients served by sex, age, condition
- I should be able to know Patient waiting time
Actor: As a Clinician
- I should be able to know how many patients are waiting for me
- I should be able to know how many patients have lab results completed and are waiting to come back to me
- I should be able to know how the number of patients the clinician has seen
Actor : As a Clinical Manager
- I should be able to view the total number of patients seen by each clinician over a defined period
Actor: As a Lab Manager
- I should be able to know the total tests done by type ,by lab tech
User Stories for Reports
Actor: As a Pharmacy Manager
- I should be able to know the quantity of different medications dispensed and quantities in stock
- I should be able to view a drug dispense report
- I should be able to view a pharmacy revenue report
Actor:As a Lab Manager
- I should be able to know Lab commodity stock levels and usage
- I should be able to know the number of tests conducted by type of test, age, sex and results.
- I should be able to view the Laboratory revenue report
- I should be able to know the quantities of lab reagents in stock.
Actor: As a County/District Health Manager
- I should be able to view the Income and expenditure report
Implementation approach
The dashboards will leverage the following existing tools/infrastructure within OpenMRS:
- Mamba ETL engine - flatten and transform data into relational tables
- O3 Clinical Dashboards - structure
- Report Visualization and Reporting:
- Easier/Limited: Add Charting library and ESM to OpenMRS to leverage a REST API provided by Mamba ETL
- Integrate with Superset / DHIS
- Install and Configure: Apache Superset for reporting from flattened tables by Mamba ETL