Practice Facilitation Handbook

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