Rapid reporting of meaningful use in electronic health records
A system includes a non-transitory computer-readable medium containing computer-executable instructions for providing a method related to rapid reporting of meaningful use in electronic health records. The method includes storing patient encounter data in a database, pre-calculating data related to at least one meaningful use measure, storing the pre-calculated data in a plurality of small staging tables, and compiling the pre-calculated and stored data from the small staging tables into a single table that is adapted to be accessed by reporting software.
1. A processor-based method of optimizing the generation of electronic reports of meaningful use in an electronic health records (EHR) computer system, comprising:
receiving patient encounter data in a database, wherein the patient encounter data comprises Boolean values;
pre-calculating first data related to a first meaningful use measure associated with at least a portion of the patient encounter data;
storing the pre-calculated first data in a first small staging table;
pre-calculating second data related to a second meaningful use measure associated with at least a portion of the patient encounter data;
storing the pre-calculated second data in a second small staging table;
processing the pre-calculated first data of the first small staging table to generate a first data column representing the first meaningful use measure without Boolean values, wherein a value of true is represented by a unique patient identifier, and a value of false is represented by a null value;
compiling the processed first small staging table and second small staging table into a single table;
accessing the single table via reporting software to calculate a meaningful use metric related to the first data column of the first meaningful use measure, the calculation comprising determining a number of unique values contained in the first data column; and
generating an electronic report for the EHR computer system comprising the meaningful use metric.
2. The system of claim 1 , wherein calculating the meaningful use metric comprises using a common aggregate function to solve for a final meaningful use data score.
3. The system of claim 2 , wherein the common aggregate function is a COUNT function.
4. The system of claim 2 , wherein the common aggregate function is a SUM function.
5. The system of claim 2 , wherein using a common aggregate function to solve for a final meaningful use data score includes determining a numerator by carrying out a first common aggregate function, and determining a denominator by carrying out a second common aggregate function.
6. The system of claim 2 , wherein using a common aggregate function is carried out given a dynamic time period.
7. The system of claim 2 , wherein the step of pre-calculating data related to a first meaningful use measure is carried out without respect to a known timeframe.
8. The system of claim 2 , wherein the storing the pre-calculated data in first and second small staging tables comprises storing the pre-calculated data with a common grain to optimize retrieval of results.
9. The system of claim 2 , wherein the step of storing the pre-calculated data is carried out independent of the time period.
10. The system of claim 2 , further comprising the step of accessing the single table via reporting software.