Example+Query+Health+Questions+(Provided+by+PCIP)

include component="page" wikiName="siframework" page="Query Health Header"

**__Example Queries Using the Approach Outlined in the Query Health Generic User Story__**
Chlamydia reportable disease prevalence by 4 zip code areas:
 * Example #1**

Result Block 1 Entity A = All distinct patients Function X = count(All distinct patients) *Note- The Function used here could return a limited data set for reportable disease case reporting to public health departments, instead of an aggregate count. Attributes B = Demographics = Patients date of birth range 18 to 30 years old ICD9 Diagnosis = 483.1 Zip Codes in (10001, 10002, 10003)

Result Block 2 Entity A = All distinct patients Function X = count(All distinct patients) Attributes B = Demographics = Patients date of birth range 18 to 30 years old ICD9 Diagnosis = 483.1 Zip Codes in (10010, 10011, 10012) AND 10014

Result Block 3 Entity A = All distinct patients Function X = count(All distinct patients) Attributes B = Demographics = Patients date of birth range 18 to 30 years old ICD9 Diagnosis = 483.1 Zip Codes between 10020 and 10029

Result Block 4 Entity A = All distinct patients Function X = count(All distinct patients) Attributes B = Demographics = Patients date of birth range 18 to 30 years old ICD9 Diagnosis = 483.1 Zip Codes in (10030, 10031)

Denominator of diabetic patients, 18 to 75 years old as of the last office visit in the last 12 months as defined by the attributes of confirmed ICD9 diagnosis of 250.0 OR laboratory (LOINC 4548-4) hemoglobin A1C result > 7 Numerator of controlled hypertension defined as most recent recorded blood pressure measurement in the past 12 months, having both a systolic blood pressure below 130 mm Hg and a diastolic blood pressure below 80 mm Hg
 * Example #2**

Result Block 1 (Denominator) Entity A = All distinct patients Function X = count(All distinct patients) Attributes B = Demographics = Patients date of birth range 18 to 75 years old Encounter = CPT Code in (99211, 99212,99213,99214,99215) ICD9 Diagnosis = 250.0 OR Laboratory LOINC = 4548-4 and result > 7

Result Block 2 (Numerator) Entity A = All distinct patients Function X = count(All distinct patients) Attributes B = Demographics = Patients date of birth range 18 to 75 years old ICD9 Diagnosis = 250.0 OR Laboratory LOINC = 4548-4 and result > 7 Most recent blood pressure vital = <130 systolic and < 80 diastolic

Story: I am a 35 year old African American with controlled diabetes who is 30 lbs overweight and have been recently been told I have 2 vessels occluded, one at 50%, and the other at 60%. The cardiac surgeon consulting on my case recommends bypass surgery, but I am scared to have surgery, and I cannot afford to be out of work for so long, because I do not have paid leave and I have 3 children to support. What is my risk for surgical site postoperative infection compared to other patients like me who pursued a CABG procedure?
 * Example #3** (see Consumer Perspective Use Story #2)

One interpretation of the many possible outcomes that could be explored for each procedure (CABG, stent, Diet and Exercise + statin) in the same format, is as follows: Denominator of African American diabetic patients, 30 to 40 years old as of surgical CABG procedure date (CPT Code: 33510-33523) as defined by the attributes of confirmed ICD9 diagnosis of 250.0 AND laboratory (LOINC 4548-4) hemoglobin A1C result < 7 as of surgical CABG procedure date and Body Mass Index between 30 and 35.

Numerator of patients from denominator that have diagnosis of "Other postoperative infection" ICD9 = 998.59 dated >= one month after CABG procedure date.

Result Block 1 (Denominator) Entity A = All distinct patients Function X = count(All distinct patients) Attributes B = Demographics = Patients date of birth range 30 to 40 years old as of CABG procedure date CABG procedure = CPT Code between 33510 and 33523 ICD9 Diagnosis = 250.0 AND Laboratory LOINC = 4548-4 and result < 7 as of surgical CABG procedure date (meaning controlled diabetes)

Result Block 2 (Numerator) Entity A = All distinct patients Function X = count(All distinct patients) Attributes B = Demographics = Patients date of birth range 30 to 40 years old as of CABG procedure date CABG procedure = CPT Code between 33510 and 33523 ICD9 Diagnosis = 250.0 AND Laboratory LOINC = 4548-4 and result < 7 as of surgical CABG procedure date Most recent blood pressure vital = <130 systolic and < 80 diastolic ICD9 Diagnosis = 998.59 dated >= one month after CABG procedure date.

__ **Hundreds of more examples...** __
The Query Health Generic User Story was designed based upon the Michael Bucks experience with the Primary Care Information Project's Hub System as presented during the Summer Concert Series.

The linked below contains a PDF of hundreds of quality metric, meaningful use, and public health related distributed queries that were built in the Hub system or anticipated in the future. All of these examples could be built using this Generic User Story. These examples could be used by the clinical and technical committees as a starting point to help define the domain of queries for the Query Health project. The Hub Query Examples PCIP.pdf

include component="page" wikiName="siframework" page="space.template.inc_contentleft_end"