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