Largely empty. For some networks, it does provide some information on team-based care (i.e which providers are operating together in a team).

There is a wealth of data within the orig text – but only about a third of it is coded to calc field. Some effort has been made to code the data in terms of relationship degree. To truly get any value from this table would recommend requesting orig field. Date variables: use Date Created.

Eight exam types are coded. Also available, but not coded is Eye Exam (in the orig data only). If an adult patient has a height and weight then CPCSSN processing will calculate a BMI using the weight and the last recorded height. Date variables: use Date Created.

This table is often used in conjunction with the billing table to evaluate diagnoses and symptoms and classify a patient’s disease (health condition status). For some EMR products from some jurisdictions, this information may be a duplication of what is in the billing table; for other EMR products from other jurisdictions, this information is supplemental […]

This table is useful to determine if a patient had a visit/encounter. The white paper that details how to define a denominator in the CPCSSN database recommends using this table as one of the main tables to determine an active patient population. Methods for defining a patient denominator in the national CPCSSN database: recommendations for […]

This table provides information on a patient’s classification according to the CPCSSN disease case algorithms. This table is useful for understanding what criteria were met for the patient’s classification to a CPCSSN disease case.

A deprivation record is only available for patients who have a valid postal code (recorded within the EMR and submitted to the central CPCSSN repository). This table provides one measure of vulnerability indicator – the Pampalon index (link to Pampalon publication). This is a neighborhood-level measure that uses the postal code to map to a […]

This table contains information about whether a patient meets the algorithm for one of the validated case definitions implemented within the CPCSSN database (hyperlink) It is important to know that some of the algorithms have multiple versions – ie an algorithm that has been adjusted to increase sensitivity, or an algorithm that has been adjusted […]

This table is one of the most useful tables for determining patient diagnoses and/or reasons for a primary care encounter. Not all diseases and conditions are coded – only 75% of the code and text is coded to a calculated field. Diagnostic codes and text are standardized to ICD-9 ontology. It should be noted that, […]

This table contains records on a patient’s allergies or intolerances (drug, food, environmental, animals). This table is useful for determining documented drug allergies but needs more coding and cleaning to be useful for other types of allergies or intolerances. Only drug allergies have been coded (to ATC ontology), other types of allergy records (ex. ‘cats’, […]