Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
The following measures belong to the group that falls into AHRQ's Prevention Quality Indicator category. The Prevention Quality Indicators (PQIs) are a set of measures that can be used with hospital inpatient discharge data to identify quality of care for "ambulatory care sensitive conditions." These are conditions for which good outpatient care can potentially prevent the need for hospitalization or for which early intervention can prevent complications or more severe disease. The PQIs are population based and adjusted for covariates.

...

SQL to acquire these measures is as follows:
.

Acquiring data on All PQI 

select a.measure_id, a.author_measure_id, a.name_friendly
from measures as a, measure_groups_measures as b
where a.measure_id = b.measure_id 
and b.measure_group_id = 23
.
This includes observed, risk-adjusted, and observed to expected measures.

...