Versions Compared

Version Old Version 5 New Version 6
Changes made by

Alex Laird

Alex Laird

Saved on

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.
.

Even though these indicators are based on hospital inpatient data, they provide insight into the community health care system or services outside the hospital setting. For example, patients with diabetes may be hospitalized for diabetic complications if their conditions are not adequately monitored or if they do not receive the patient education needed for appropriate self-management.

The PQIs can be used as a "screening tool" to help flag potential health care quality problem areas that need further investigation; provide a quick check on primary care access or outpatient services in a community by using patient data found in a typical hospital discharge abstract; and, help public health agencies, State data organizations, health care systems, and others interested in improving health care quality in their communities.

 

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.

...