Iteration 6 Queries

####AMCARE Queries

Nine queries below are a sub-set taken from the AMCARE list of indicators. They align with the AMCARE 1.0 XML specification so that, once these queries are answerable, they can be used in future iterations where the AMCARE XML output is generated by hQuery (or subcomponent).

Category	Query Title	Description	Source
Practice Profile	Practice population profile	Age-Gender stratification of active patients in a practice. The indicator also calculates a number of clinical contacts per each stratum.	AMCARE 1.0
Prevention	BMI or WC documented in last 2 yrs age >19	Active patients >19 years old who have either a BMI recorded; or a height and weight recorded; or a WC recorded in the EMR within the past 2 years.	AMCARE 1.0
Prevention	Pneumococcal vaccination age 65+	Active patients >64 years old who have one pneumococcal vaccination on file in the EMR.	AMCARE 1.0
Screening	Fasting blood sugar in last 3 yrs age > 45	Active patients >45 years old who have their fasting blood sugar tested (result recorded in the EMR) in last 3 yrs	AMCARE 1.0
Screening	Colon screening in last 2 yrs age 50-74	Active patients who are between 50 and 74 years old (74 years => age => 50 years) who received screening for colon cancer with a hemoccult test within the past 2 years OR who received screening for colon cancer with colonoscopy or sigmoidoscopy within the past 5 years.	AMCARE 1.0
CDM	Diabetes & BP <= 130/80 in last yr	Active patients with diabetes (based on problem list) who have a BP <130 AND <80 within the past 12 months on their record in the EMR.	AMCARE 1.0
CDM	Diabetics with HGBA1C in last 6 mo	Active patients with diabetes (based on problem list) who have a HGBA1C lab result within the past 6 months on their record in the EMR.	AMCARE 1.0
CDM	Diabetics with HGBA1C in last yr <= 7.0	Active patients with diabetes (based on problem list) who have a HGBA1C lab result within the past 12 months on their record in the EMR AND the value of HGBA1C is <=7%	AMCARE 1.0
CDM	Diabetics with LDL in last yr <= 2.5	Active patients with diabetes (based on problem list) who have an LDL lab result within the past 12 months on their record in the EMR AND the value of LDL is <= 2.5 mmol/L	AMCARE 1.0

####Rational Prescribing Queries

The queries below address Rational Prescribing. Some are carried over from the previous iterations and are strengthened in this iteration, while others are new.

| Category | Query Title | Description| Source |
| -----------| ----------------| --------- | ------ | ------ |
|Polypharmacy|Patients, 65 and older, on 5 or more medications|Active patients, 65 and older, that have 5 or more active prescriptions documented in the EMR |Pegasus | |Polypharmacy|Patients, 65 and older, on 10 or more medications|Active patients, 65 and older, that have 10 or more active prescriptions documented in the EMR |Pegasus | |Appropriate Prescribing|Most commonly prescribed medication classes|Top 10 most commonly prescribed medication classes by ATC level 2 | | |Appropriate Prescribing|Patients, 65 and older, with impaired renal function who are on digoxin >125 mcg/day|Active patients, 65 and older, that have a documented eGFR <50 ml/min or creatinine > 150 mmol/l and have a documented current prescription of digoxin where the dose is > 125 mcg/day|STOPP Criteria | |Appropriate Prescribing|Statins for primary prevention|Active patients that have a current documented prescription for statins but do not have an myocardial infarction (MI) or stroke documented in the EMR.|OPUS, Rx Atlas | |Appropriate Prescribing|Statins for secondary prevention|Active patients that have a current documented prescription for statins and have an myocardial infarction (MI) or stroke documented in the EMR.|OPUS, Rx Atlas |

NOTE: this page does not include detailed specifications for each indicator

This iteration, we will be asking a set of queries as a single batch or Query Set.