Differences

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

--- documentation:cdm:cohort_attribute [2015/01/05 16:39] – cgreich
+++ documentation:cdm:cohort_attribute [2017/09/25 15:09] (current) – clairblacketer
@@ Line 1: / Line 1: @@
 ===== 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.
 ^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.|
 |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.|
-|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, such as calculated entities (for example age, BMI) or composite scales (for example Charlson index).|
+|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.|
 ==== Conventions ====
-  * Like with Cohorts, the unifying definition or feature of any Cohort Attribute is captured in the cohort_definition_id.
+  * Each record in the COHORT_ATTRIBUTE table is linked to a specific record in the COHORT table, identified by matching cohort_definition_id, subject_id, cohort_start_date	and cohort_end_date fields.
-  * Cohort Attribute records must have a Start Date
+  * It adds to the Cohort records calculated co-variates (for example age, BMI) or composite scales (for example Charleson index).
-  * Cohort Attribute records must have an End Date, but may be set to Start Date or could apply a censored date using the Observation Period Start Date.
+  * The unifying definition or feature of the Cohort Attribute is captured in the attribute_definition_id referring to a record in the ATTRIBUTE_DEFINITION table.
-  * Cohort Attribute records must contain a Subject ID, which can refer to a Person, Provider, or Visit record. The cohort definition will define the type of subject through the subject concept id.
+  * The actual result or value of the Cohort Attribute (co-variate, index value) is captured in the value_as_number	(if the value is numberic) or the value_as_concept_id (if the value is a concept) fields.