Configuring Data Quality Dashboard

Purpose

This feature helps ensure data quality on chosen variables. Based on the rules defined for those variables, a run for the patients yields a list of patients for whom the data is incomplete/erroneous. The results are displayed as a list of all data inconsistencies on a dashboard called the Data Quality Dashboard.

The rules can be customized by an implementer (Steps for the same will be updated later). These rules can be sometimes very complex and therefore the rules can be written in java/sql/groovy depending on the complexity.

This feature is influenced from the OpenMRS data integrity module (https://wiki.openmrs.org/display/docs/Data+Integrity+Module) and slightly modified to suit requirements.

Configure the Data Quality Dashboard:

1. Run Background job

The data integrity task is scheduled to run every day at 12:00AM by default. To change this setting, go to OpenMRS Administration > Manage Scheduler > click on Data Integrity Task link > Schedule and change the repeat interval .

2. Internationalize Data integrity module name

Add the value for key in respective home/ locale_${en,fr, .. }.json.

{
   "MODULE_LABEL_DATA_INTEGRITY_KEY": "Data integrity"
}

3. Internationalize Column Headers

Add the values for the following keys in respective clinical/locale_${en, fr, .. }.json. Sample values for the keys are provided below:

In clinical/locale_en.json,

Code Snippet

{
    "MODULE_LABEL_ERROR_REPORTS_KEY": "Error Reports",
    "DQ_PRINT_TITLE_DATA_QUALITY_REPORT": "Data Quality Report",
    "DQ_DASHBOARD": "Data Quality Dashboard",
    "DQ_COLUMN_TITLE_TREATMENT_REG_NO": "Treatment Reg No",
    "DQ_COLUMN_TITLE_NAME": "Name",
    "DQ_COLUMN_TITLE_EMR_ID": "EMR ID",
    "DQ_COLUMN_TITLE_NOTES": "Notes",
    "DQ_COLUMN_TITLE_ACTION": "Action",
    "DQ_COLUMN_TITLE_RULE_NAME":"Rule Name",
    "DQ_COLUMN_TITLE_REG_FACILITY":"Treatment facility" 
}

Change of name key

The key for name is changed from "name" to "DQ_COLUMN_TITLE_NAME" and column "DQ_COLUMN_TITLE_REG_FACILITY" is added from 1.4 release

4. Configure Print Button and HTML location

Add the config below to extension-dataintegrity.json

Code Snippet

{
  "bahmni_clinical_patients_search_allpatients_app_clinical": {
    "id": "bahmni.clinical.patients.search.allPatients",
    "extensionPointId": "org.bahmni.patient.search",
    "type": "config",
    "extensionParams": {
      "searchHandler": "endtb.sqlSearch.dataIntegrity",
      "forwardUrl": "#/default/patient/{{patientUuid}}/dashboard?programUuid={{programUuid}}&enrollment={{enrollment}}",
      "translationKey": "MODULE_LABEL_ERROR_REPORTS_KEY",
      "view" : "tabular",
      "showPrint": true,
      "printHtmlLocation": "/bahmni_config/openmrs/apps/dataintegrity/patientListPrint.html",
	  "searchColumns" : ["DQ_COLUMN_TITLE_TREATMENT_REG_NO", "DQ_COLUMN_TITLE_NAME"]	
    },
    "order": 1,
    "requiredPrivilege": "app:clinical"
  }
}

5. Hide Print Button

To hide print button on the DQ Dashboard set

"showPrint": false

6. Configure Searchable Columns

To configure columns to search on the DQ Dashboard, add the column keys to the list in searchColumns. The search facility can be enabled on all columns.

The configuration below will enable search on columns Treatment Reg No, Name of the patient.

"searchColumns" : ["DQ_COLUMN_TITLE_TREATMENT_REG_NO", "DQ_COLUMN_TITLE_NAME"]

Implementation of DQRules

The list of rules that are executed can be found in the table dataintegrity_rule in openMRS database.
DQ Rules for EndTB are written in the the openmrs-module-bahmniendtb repository.

Writing new custom rules

To write custom rules, clone the repository

git clone https://github.com/Bahmni/openmrs-module-bahmniendtb

2. Follow these steps to add a new DQ Rule :

query to insert rule

INSERT INTO dataintegrity_rule ( rule_name, rule_category, handler_config, handler_classname, uuid ) VALUES ( "Baseline Firstling DST missing", "java", "java", "org.openmrs.module.bahmniendtb.dataintegrity.rules.RuleName", uuid());

Deploy the latest DQ Rule for local testing

Run the below command on openmrs-module-bahmniendtb directory

mvn clean install

The OMOD is generated in this location : openmrs-module-bahmniendtb/omod/target/bahmniendtb-1.4-SNAPSHOT.omod
Replace the old OMOD with the one generated as above in /opt/openmrs/modules folder in vagrant box

Restart openMRS service

sudo service openmrs restart

Sample DQ Rules

The following are some sample DQ Rules

Next Steps

Open discussion with community

Support for rule_group and schedule tables so that certain rules can be grouped and can be assigned specific groups to a different schedules. (open for discussion)

Building ability to run rules per patient and making rule groups.

On this page

Feature Details

Data Quality Dashboard