FAMILY HISTORY
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.
ENCOUNTER DIAGNOSIS
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 […]
ENCOUNTER
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 (provide hyperlink) recommends using this table as one of the main tables to determine an active patient population. It is not recommended that this table be used (via the […]
DEPRIVATION
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 […]
DISEASE CASE
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 […]
BILLING
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, […]
ALLERGY INTOLERANCE
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’, […]