Iteration 6 Queries

Iteration 6 Queries

To be edited for IT6

The following queries are meant to align with a subset of queries asked by AMCARE. in this way, we are aligning with the requirements of both AMCARE and the Physician Data Collaborative. The descriptions are estimates as we have not yet received validation from AMCARE of their query specifications.

###What is the population profile for measuring BMI in the last two years for patients 12-19 years old?

Denominator: Active Patients

• Who are >11 years old AND
• Are <20 years old.

Numerator: patient who meet the denominator and either

• Have a most recent BMI documented within the last 720 days.
• Have both a height and weight documented within the last 720 days.

###What is the population profile for measuring BMI in the last two years for patients >19 years old?

Denominator: Active Patients

• Are >=20 years old.

Numerator: patient who meet the denominator and either

• Have a most recent BMI documented within the last 720 days, OR
• Have both a height documented at some point and weight documented within the last 720 days.

###What is the population profile for screening cholesterol in the last 5 years for males 35-65?

Denominator: Active Patients

• Male gender
• Age >34
• Age <66

Numerator: patient who meet the denominator and

• Have at least one cholesterol test in the last 5 years (1826 days)

###What is the population profile for screening fasting glucose in patients over 45 years old?

Denominator: Active Patients

• Are >45 years old.

Numerator: patient who meet the denominator and either

• Who have at least one fasting serum glucose test in the lab results section since...

###What is the population profile for measuring blood pressure in patients with a documented diagnosis of hypertension in the last year?

• Population is patients >18 years old with a diagnosis of hypertension (exclude gestational hypertension)
• Display a histogram of frequency counts of patients stratified by the number of recorded BP readings in the last 365 days.

###What is the population profile for achieving a documented blood pressure of <=140/90 in the last year in patients with a documented diagnosis of hypertension in the last year?

Denominator: Active Patients >18 years old with a diagnosis of hypertension (exclude gestational hypertension)

Numerator:

• Patients who match the denominator criteria AND
• Have at least one BP in the last year where the systolic BP <=140
• Have at least one BP in the last year where the diastolic BP <=90