Appendix 1.

Canadian Primary Care Sentinel Surveillance Network (CPCSSN) Disease Definition Table, © CPCSSN 2008

Case Finding
1. Billing: ICD9- 250.x; Service code: in Ontario K030A or Q040A, in other provinces consult physician and document the code.1. Billing: ICD9 309.0, 309.1 or 309.81 (Physicians should be asked which code they use before doing this search. Potential codes include: 296, 300, 309, 311, 648)1. Billing: ICD9 –715.x1. Billing: ICD9 –401–4051. Billing: ICD9 –490–492, 496
2. In Problem List2. In Problem List2. In Problem List2. In Problem List2. In Problem List
Diabetes/NIDDM/DMDepression, post-traumatic stress disorder, 311OsteoarthritisHypertension, HTN,Bronchitis
3. In the medication list:3. In Medication list:3. In Medication List3. In Medication ListEmphysema
InsulinSSRINone identifiedACEi/ARBCOPD/COLD
Glyburide (Sulfonylureas)MAOIDiuretics3. In Medication List
Metformin (Biguanides)Tricyclics (>75 mg/day)Beta BlockersBeta agonists
4. In the lab result:Calcium Channel Blockers Alpha blockersAnticholinergics Xanthines
HbA1C > 7%Inhalant corticosteroids
Fasting BS > 7
4. Risk Factors
Data Type
Data to be extracted
    Billing DataNone identifiedNone identifiedNone identifiedNone identifiedNone identified
    EMR –Problem ListAll DiagnosesAll DiagnosesAll DiagnosesAll DiagnosesAll Diagnoses
    EMR –Physiological*BPWeightWeightBPWeight
Weight,Joint painPEFR
foot ulcer,
Waist:hip ratio
Waist circumference
    EMR -Adverse EventsAllergies to medication Adverse Events
Non-efficacious medication
    EMR –Medications ListAll medicationsAll medicationsAll medicationsAll medicationsAll medications
    EMR –RisksSmokerSmokerObesitySmokerSmoker
    EMR –LabsF-Glucose,None IdentifiedNone IdentifiedNone IdentifiedNone Identified
Alb:Creat in urine
    EMR –ReferralOphthalmology, nephrology,PsychiatristPsychologistOrthopedic surgeon PhysiotherapyCardiologyNephrologyRespirologyThoracic surgery
neurology,Occupational therapy
endocrinologyExercise program
Diabetes Education
    EMR –Diagnostic ImagingNot being collectedNot being collectedNot being collectedNot being collectedNot being collected
    EMR –ProceduresRevascularization procedureECTKnee-replacementAngioplastySpirometry
Coronary artery disease investigationHip-ReplacementCoronary artery stent
    EMR –OtherN/AER Crisis visitsADL/IADL
  • * BMI would not be collected as that should be calculated.

  • We will use look-up tables to allow conversion of names of meds to particular classes of drugs. This will be done at the central repository level.

  • EMR, electronic medical record; NIDDM, non-insulin dependent diabetes mellitus; DM, diabetes mellitus; HTN, hypertension; SSRI, selective serotonin reuptake inhibitor; ACEi, angiotensin converting enzyme inhibitor; ARB, angiotensin receptor blocker; COPD, chronic obstructive pulmonary disease; COLD, chronic obstructive lung disease; MAOI, monoamine oxidase inhibitor (MAOI) antidepressants; HbA1c, hemoglobin A1c levels in diabetic patients; BS, blood sugar; BP, blood pressure; PEFR, peak expiratory flow rate; TG, triglycerides; LDL, low density lipoproteins cholesterol; HDL, high density lipoproteins; TC, total blood cholesterol; Alb:Creat, albumin/creatinine ratio (ACR) urine; ECT, electroconvulsive therapy; ER, emergency room; ADL, activities of daily living; IADL, instrumental activities of daily living.