This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
documentation:cdm:cohort_attribute [2015/01/05 16:48] cgreich |
documentation:cdm:cohort_attribute [2017/09/25 15:09] (current) clairblacketer |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== COHORT_ATTRIBUTE table ===== | ===== COHORT_ATTRIBUTE table ===== | ||
+ | **THIS IS OUTDATED. All documentation is now on the [[https://github.com/OHDSI/CommonDataModel/wiki|github wiki]]. Please refer there or to the [[projects:workgroups:cdm-wg|CDM working group]] for more information** | ||
+ | |||
The COHORT_ATTRIBUTE table contains attributes associated with each subject within a cohort, as defined by a given set of criteria for a duration of time. The definition of the Cohort Attribute is contained in the ATTRIBUTE_DEFINITION table. | The COHORT_ATTRIBUTE table contains attributes associated with each subject within a cohort, as defined by a given set of criteria for a duration of time. The definition of the Cohort Attribute is contained in the ATTRIBUTE_DEFINITION table. | ||
^Field^Required^Type^Description^ | ^Field^Required^Type^Description^ | ||
- | |cohort_definition_id|Yes|integer|A foreign key to a record in the COHORT_DEFINITION table containing relevant Cohort Definition information.| | + | |cohort_definition_id|Yes|integer|A foreign key to a record in the [[documentation:cdm:cohort_definition|COHORT_DEFINITION]] table containing relevant Cohort Definition information.| |
|subject_id|Yes|integer|A foreign key to the subject in the Cohort. These could be referring to records in the PERSON, PROVIDER, VISIT_OCCURRENCE table.| | |subject_id|Yes|integer|A foreign key to the subject in the Cohort. These could be referring to records in the PERSON, PROVIDER, VISIT_OCCURRENCE table.| | ||
|cohort_start_date|Yes|date|The date when the Cohort Definition criteria for the Person, Provider or Visit first match.| | |cohort_start_date|Yes|date|The date when the Cohort Definition criteria for the Person, Provider or Visit first match.| | ||
|cohort_end_date|Yes|date|The date when the Cohort Definition criteria for the Person, Provider or Visit no longer match or the Cohort membership was terminated.| | |cohort_end_date|Yes|date|The date when the Cohort Definition criteria for the Person, Provider or Visit no longer match or the Cohort membership was terminated.| | ||
- | |attribute_definition_id|Yes|integer|A foreign key to a record in the ATTRIBUTE_DEFINITION table containing relevant Attribute Definition information.| | + | |attribute_definition_id|Yes|integer|A foreign key to a record in the [[documentation:cdm:ATTRIBUTE_DEFINITION|ATTRIBUTE_DEFINITION]] table containing relevant Attribute Definition information.| |
|value_as_number|No|float|The attribute result stored as a number. This is applicable to attributes where the result is expressed as a numeric value.| | |value_as_number|No|float|The attribute result stored as a number. This is applicable to attributes where the result is expressed as a numeric value.| | ||
|value_as_concept_id|No|integer|The attribute result stored as a Concept ID. This is applicable to attributes where the result is expressed as a categorical value.| | |value_as_concept_id|No|integer|The attribute result stored as a Concept ID. This is applicable to attributes where the result is expressed as a categorical value.| |