User Tools

Site Tools


documentation:cdm:cohort_attribute

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
documentation:cdm:cohort_attribute [2015/01/05 16:48]
cgreich
documentation:cdm:cohort_attribute [2015/01/05 17:45]
vojtechhuser
Line 2: Line 2:
 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.|
documentation/cdm/cohort_attribute.txt ยท Last modified: 2017/09/25 15:09 by clairblacketer