documentation:cdm:details_of_the_model
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
documentation:cdm:details_of_the_model [2014/11/14 12:33] cgreich |
documentation:cdm:details_of_the_model [2014/12/02 01:48] jduke |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== Details of the Model ====== | ||
| + | |||
| + | The CDM defines table structures in a person-centric way. At a minimum, the tables have a foreign key into the Person table and a date. This allows for a longitudinal view on all the healthcare-relevant events. The exceptions from this rule are the standardized health system data tables, which are linked directly to events of the various domains. | ||
| + | |||
| + | To represent the relevant domains, the CDM contains the following 39 tables: | ||
| + | |||
| ^Table name^Description^ | ^Table name^Description^ | ||
| |**Standardized Vocabularies**|| | |**Standardized Vocabularies**|| | ||
| Line 26: | Line 32: | ||
| |CONDITION_OCCURRENCE|The CONDITION_OCCURRENCE table captures records of a disease or a medical condition based on evaluation by a provider or reported by a patient.| | |CONDITION_OCCURRENCE|The CONDITION_OCCURRENCE table captures records of a disease or a medical condition based on evaluation by a provider or reported by a patient.| | ||
| |MEASUREMENT|A measurement is the capture of a structured value (numerical or categorical) obtained through systematic examination of a person or sample. The MEASUREMENT table captures measurement orders and measurement results. The measurement domain can contain laboratory results, vital signs, or quantitative findings from pathology reports.| | |MEASUREMENT|A measurement is the capture of a structured value (numerical or categorical) obtained through systematic examination of a person or sample. The MEASUREMENT table captures measurement orders and measurement results. The measurement domain can contain laboratory results, vital signs, or quantitative findings from pathology reports.| | ||
| - | |NOTE|The NOTE table captures unstructured information that was recorded by a provider or a patient in free text notes on a given date. | + | |NOTE|The NOTE table captures unstructured information that was recorded by a provider or a patient in free text notes on a given date.| |
| |OBSERVATION|The OBSERVATION table captures any clinical facts about a patient obtained in the context of examination, questioning or a procedure. The observation domain supports capture of data not represented by other domains, including unstructured measurements, medical history and family history.| | |OBSERVATION|The OBSERVATION table captures any clinical facts about a patient obtained in the context of examination, questioning or a procedure. The observation domain supports capture of data not represented by other domains, including unstructured measurements, medical history and family history.| | ||
| |FACT_RELATIONSHIP|The FACT_RELATIONSHIP table contains records to detail the relationships between facts within one domain or across two domains, and the nature of the relationship. Examples of types of fact relationships include: person relationships (mother-child linkage), care site relationships (representing the hierarchical organization structure of facilities within health systems), drug exposures provided due to associated indicated condition, devices used during the course of an associated procedure, and measurements derived from an associated specimen. All relationships are directional, and each relationship is represented twice symmetrically within the fact relationship table. For example, two persons (PERSON_ID = 1 is the mother of PERSON_ID = 2) have two fact relationships: 1- ‘PERSON_ID 1’ ‘parent of’ ‘PERSON_ID 2’, and 2-‘PERSON_ID 2’ ‘child of’ ‘PERSON_ID 1’.| | |FACT_RELATIONSHIP|The FACT_RELATIONSHIP table contains records to detail the relationships between facts within one domain or across two domains, and the nature of the relationship. Examples of types of fact relationships include: person relationships (mother-child linkage), care site relationships (representing the hierarchical organization structure of facilities within health systems), drug exposures provided due to associated indicated condition, devices used during the course of an associated procedure, and measurements derived from an associated specimen. All relationships are directional, and each relationship is represented twice symmetrically within the fact relationship table. For example, two persons (PERSON_ID = 1 is the mother of PERSON_ID = 2) have two fact relationships: 1- ‘PERSON_ID 1’ ‘parent of’ ‘PERSON_ID 2’, and 2-‘PERSON_ID 2’ ‘child of’ ‘PERSON_ID 1’.| | ||
| Line 41: | Line 47: | ||
| |**Standardized derived elements**|| | |**Standardized derived elements**|| | ||
| |COHORT|The COHORT table contains records derived as a set of subjects that satisfy a given set of inclusion criteria for a duration of time. The definition of the cohort is contained within the COHORT_DEFINITION table. Example cohorts can include patients diagnosed with a specific condition, patients exposed to a particular drug, or providers who have performed a specific procedure.| | |COHORT|The COHORT table contains records derived as a set of subjects that satisfy a given set of inclusion criteria for a duration of time. The definition of the cohort is contained within the COHORT_DEFINITION table. Example cohorts can include patients diagnosed with a specific condition, patients exposed to a particular drug, or providers who have performed a specific procedure.| | ||
| - | |COHORT_ATTRIBUTE|The COHORT_ATTRIBUTE table contains attributes associated with each subject within a cohort, as defined by a given set of inclusion criteria for a duration of time. The definition of the cohort attribute is contained within the ATTRIBUTE_DEFINITION table. Example cohort attributes can be age, BMI or comorbidity score.| | + | |COHORT_ATTRIBUTE|The COHORT_ATTRIBUTE table contains attributes associated with each subject within a cohort, as defined by a given set of inclusion criteria for a duration of time. The definition of the cohort attribute is contained within the ATTRIBUTE_DEFINITION table. Example cohort attributes can be S~~age, BMI or comorbidity score.| |
| |DRUG_ERA|A Drug Era is defined as a span of time when the Person is assumed to be exposed to a particular active ingredient. A Drug Era is not the same as a Drug Exposure: Exposures are individual records corresponding to the source when drug was delivered to the Person, while successive periods of Drug Exposures are combined under certain rules to produce continuous Drug Eras.| | |DRUG_ERA|A Drug Era is defined as a span of time when the Person is assumed to be exposed to a particular active ingredient. A Drug Era is not the same as a Drug Exposure: Exposures are individual records corresponding to the source when drug was delivered to the Person, while successive periods of Drug Exposures are combined under certain rules to produce continuous Drug Eras.| | ||
| |DOSE_ERA|A Dose Era is defined as a span of time when the Person is assumed to be exposed to a constant dose of a specific active ingredient.| | |DOSE_ERA|A Dose Era is defined as a span of time when the Person is assumed to be exposed to a constant dose of a specific active ingredient.| | ||
| |CONDITION_ERA|A Condition Era is defined as a span of time when the Person is assumed to have a given condition.| | |CONDITION_ERA|A Condition Era is defined as a span of time when the Person is assumed to have a given condition.| | ||
documentation/cdm/details_of_the_model.txt · Last modified: 2017/09/25 14:56 by clairblacketer
Page Tools
