Quality Measures

Methods

Code on Github

The Quality Measures data mart is where we are building publicly available quality measures. You can see the roadmap in this section. If there is a publicly available measure you would like to see added you can submit an issue on GitHub.

Check out the Knowledge Base article for an overview of the data mart and a walkthrough example for calculating a quality measure.

Measure Name	Measure ID	Specification	Status
Documentation of Current Medications in the Medical Record	CMS Star C06, MIPS CQM 130	Link	Released
Hospital-Wide All-Cause Readmission (HWR)	CMS Star C15, MIPS CQM 479	Link	Released (Readmissions mart)
Medication Adherence for Cholesterol (Statins)	CMS Star D10, NQF 0541	Link	Released
Medication Adherence for Diabetes Medications	CMS Star D08, NQF 0541	Link	Released
Medication Adherence for Hypertension (RAS antagonists)	CMS Star D09, NQF 0541	Link	Released
Pain Assessment and Follow-Up	CMS Star C07, MIPS CQM 131	Link	Released
Statin Therapy for the Prevention and Treatment of Cardiovascular Disease	CMS Star C16, MIPS CQM 438	Link	Released
Statin Use in Persons with Diabetes (SUPD)	CMS Star D12	Link	Released

The data mart includes logic that allows you to choose a measurement period end date.

• quality_measures_period_end defaults to the current year-end
• snapshots_enabled is an optional variable that can be enabled to allow running the mart for multiple years

To run the data mart without the default, simply add the quality_measures_period_end variable to your dbt_project.yml file or use the --vars dbt command. See examples below.

dbt_project.yml:

vars:
    quality_measures_period_end: "2020-12-31"
    snapshots_enabled: true

Data Dictionary

summary_counts

Reporting measure counts with performance rates.

Column	Data Type	Description	Terminology

summary_long

Long view of the results for the reporting version of all measures. Each row represents the results a measure per patient. A null for the denominator indicates that the patient was not eligible for that measure.

Column	Data Type	Description	Terminology

summary_wide

Wide view of the results for the reporting version of all measures. This model pivots measures on the patient level (i.e. one row per patient with flags for each measure. The false flags can be treated as care gaps as exclusions have been included in the pivot logic.

Column	Data Type	Description	Terminology

Intermediate Tables

The intermediate tables contain the logic for calculating each quality measure. The subfolder for each quality measure contains that measure's specific logic for calculating the denominator, numerator, and exclusions. Many measures use the same logic for calculating exclusions, such as dementia or hospice. This shared logic can be found in the shared exclusions subfolder.

Example SQL

Quality Measure Performance

select
      measure_id
    , measure_name
    , performance_period_end
    , performance_rate
from quality_measures.summary_counts
order by performance_rate desc

Exclusion Reason Breakdown

select
      measure_id
    , exclusion_reason
    , count(person_id) as patient_count
from quality_measures.summary_long
where exclusion_flag = 1
group by
      measure_id
    , exclusion_reason
order by
      measure_id
    , exclusion_reason

Patient Pivot

select * from quality_measures.summary_wide