Practice Facilitation Handbook
Module 8 Appendix C
Table of Contents
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 ___
- Of diabetic patients selected, select those with three hemoglobin A1c values dated from 3/31/2011 to 3/31/2012:
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?
Page last reviewed May 2013
Page originally created May 2013
Page originally created May 2013
Internet Citation: Module 8 Appendix C. Content last reviewed May 2013. Agency for Healthcare Research and Quality, Rockville, MD. http://www.ahrq.gov/professionals/prevention-chronic-care/improve/system/pfhandbook/mod8appendixc.html