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 |
|
| Provider information |
|
| 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 |
|
| 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 |
|
| 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
|