Table 1.

Data variables

Domain	Variables
Patient demographics and clinical data	Patient ID (unique patient number generated by CPCSSN) Sex Month and year of birth Occupation Highest education Housing status Postal code EMR status—active, deceased, duplicate, inactive, unknown Language Race/ethnicity Deceased tear Date created (date this record was created) Time since last visit—6, 12, 24 or 36 months CPCSSN conditions—yes/no for diabetes, depression, osteoarthritis, COPD, hypertension, dementia, Parkinson's, epilepsy CPCSSN conditions—count (ie, numeric value) Disease case indicator—disease (diabetes, depression, osteoarthritis, COPD, hypertension, dementia, Parkinson's, epilepsy) Disease case indicator—indicator type (billing, encounter diagnosis, health conditions, laboratory result (HbA1C, fasting glucose), medication) Disease case indicator—indicator value (numeric value of HbA1C and/or fasting glucose)
Patient–provider pairing	Patient ID (unique patient number generated by CPCSSN) Provider ID (unique provider number generated by CPCSSN; primary provider of patient) Start date End date
Provider information	Provider ID (unique provider number generated by CPCSSN) Sex Birth year
Billing data	Patient ID (unique patient number generated by CPCSSN) Date created Service date Diagnosis text—cleaned Diagnosis text—original Diagnosis code type (ie, ICD-9, ICD-10) Diagnosis code (ie, 401)
Clinical encounters	Patient ID (unique patient number generated by CPCSSN) Provider ID (unique provider number of the attending provider generated by CPCSSN) Encounter date Encounter type—academic clinic, community clinic Reason for visit—cleaned Reason for visit—original
Encounter diagnoses	Patient ID (unique patient number generated by CPCSSN) Created date Diagnosis text—cleaned Diagnosis text—original Diagnosis code type (ie, ICD-9) Diagnosis code (ie, 401)
Physical examination data	Patient ID (unique patient number generated by CPCSSN) Exam name—systolic BP, diastolic BP, height, weight, BMI, waist circumference, waist to hip ratio (all values) Result—cleaned numeric value Result—original numeric value Unit of measure Most recent value—yes, no
Health condition	Patient ID (unique patient number generated by CPCSSN) Created date Onset date Diagnosis text—cleaned Diagnosis text—original Diagnosis code type (ie, ICD-9) Diagnosis code (ie, 401)
Laboratory data	Patient ID (unique patient number generated by CPCSSN) Date performed Laboratory name—cleaned text (fasting glucose, glucose tolerance, HbA1C, HDL, LDL, total cholesterol, triglycerides, microalbumin, urine albumin to creatinine ratio, haemoglobin, creatinine, eGFR/GFR) Laboratory name—original text Laboratory result—numeric value Unit of measure Most recent value—yes, no
Medical/surgical procedure	Patient ID (unique patient number generated by CPCSSN) Date created Date performed Procedure name—cleaned text Procedure name—original text
Medication records	Patient ID (unique patient number generated by CPCSSN) Start date Stop date Medication name—cleaned text Medication name—original text Medication code—ATC code (Anatomical Therapeutic Chemical classification system) Time since (initial prescription) DIN (drug identification number) Strength Dose Frequency Unit of measure
Referral data	Patient ID (unique patient number generated by CPCSSN) Date created Date completed Referral name—cleaned text Referral name—original text
Risk factor data	Patient ID (the unique patient number generated by CPCSSN) Date created Start date Stop date Most recent—yes, no Risk factor name—cleaned text (smoking, alcohol, diet, exercise, obesity) Risk factor name—original text Status—cleaned (current, never, n/a, not current, past, unknown) Status—original Value—cleaned Frequency Duration End

BMI, body mass index; BP, blood pressure; COPD, chronic obstructive pulmonary disease; CPCSSN, Canadian Primary Care Sentinel Surveillance Network; eGFR, estimated glomerular filtration rate; EMR, electronic medical records; HbA1C, glycated haemoglobin concentration; HDL, high density lipoprotein; ICD, International Classification of Diseases; LDL, low density lipoprotein.