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

1. Health Facility Administrators : Track and Manage financial resources,Human resources,Patient Management
2. Clinician : Clinical management of patients
3. Clinical Manager : Management of Patients and clinical staff
4. Lab Manager : Stock management
5. Pharmacy Manager
6. County/District Health Manager
7. 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:

1. Mamba ETL engine - flatten and transform data into relational tables
2. O3 Clinical Dashboards - structure
3. Report Visualization and Reporting:
   1. Easier/Limited: Add Charting library and ESM to OpenMRS to leverage a REST API provided by Mamba ETL
   2. Integrate with Superset / DHIS
   3. Install and Configure: Apache Superset for reporting from flattened tables by Mamba ETL