Module 8 Appendix C

Sample Set of Electronic Pull Instructions for IT Staff

Diabetic Patient Identification

IT Instructions

Patient list generator

Step 1: Identify all patients that meet all of the following criteria:

  • Diabetic: Select patients with any ICD9 = 250.xxx in the billing data.
  • Among those, select patients with birth dates after 1/1/1927 and prior to 1/1/1962  [Age > 50 years and <85 on 1/1/12]
  • Record number of patients seen at least twice in the 2-year period (3/30/2010-3/31/2012) ___
    • Generate list seen at least once in both 12-month periods (3/30/2010-3/30/2011 AND 3/31/2011-3/31/2012).
  • Record number of diabetics identified ___
    • Of diabetic patients selected, select those with three hemoglobin A1c values dated from 3/31/2011 to 3/31/2012:
      • Record number of patients identified ___

Step 2: Identify all patients that meet all of the following criteria:

  • Hypertensive: Select patients with any ICD9 = 401 or 402 or 403 or 404.
  • Among those, select patients with birth dates after 1/1/1927 and prior to 1/1/1962  [Age > 50 years and <85 on 1/1/12]
  • Record number of patients seen at least twice in the 2-year period (3/30/2010-3/31/2012) ___
    • Generate list seen at least once in both 12-month periods (3/30/2010-3/30/2011 AND 3/31/2011-3/31/2012).
  • Record number of hypertensives identified ___

Of diabetic patients identified in Step 1 (excluding criteria for hemoglobin A1c values, including those seen twice in both 12-month periods and only those within the range of birth dates listed), how many have any ICD9 = 401 or 402 or 403 or 404?

Return to Module 8

Current as of May 2013
Internet Citation: Module 8 Appendix C: Sample Set of Electronic Pull Instructions for IT Staff. May 2013. Agency for Healthcare Research and Quality, Rockville, MD. http://www.ahrq.gov/professionals/prevention-chronic-care/improve/system/pfhandbook/mod8appendixc.html