Netocodez/nmrs-sql-toolkit

A curated collection of SQL queries used for reporting, data quality improvement, troubleshooting, and database administration within the Nigeria Medical Record System (NMRS/OpenMRS). NMRS SQL Toolkit A curated collection of SQL queries used for reporting, data quality improvement, troubleshooting, and database administration within the Nigeria Medical Record System (NMRS/OpenMRS). Repository Contents Reporting Queries Data Quality Checks Patient Record Updates Encounter Corrections Observation Updates Utility Queries Stored Procedures Categories Folder Description reports Queries for extracting program reports data_quality Queries to identify data issues updates SQL scripts that modify data utilities Frequently used helper queries docs Documentation and references Database Compatible with: NMRS OpenMRS MySQL 5.7+ MariaDB