The following measures belong to the group that falls into AHRQ's Prevention Quality Indicator category. This includes observed, risk-adjusted, and observed to expected measures.
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
.
Statistical significance is calculated using a 95% confidence interval on a standard z-test for state-wide values and populated in the sig_var_state field of pellucid2.entity_values.
...