documentation:cdm:cohort_attribute
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
documentation:cdm:cohort_attribute [2015/01/05 16:45] cgreich |
documentation:cdm:cohort_attribute [2015/01/05 16:48] cgreich |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| |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 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.| | |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 ==== | ==== Conventions ==== | ||
| * 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. | * 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. | ||
| - | * It addes to the records additional information, such as co-variates, scores of disease assessment indices, etc. | + | * It adds to the Cohort records calculated co-variates (for example age, BMI) or composite scales (for example Charleson index). |
| * 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. | * 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. | ||
| * 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. | * 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. | ||
documentation/cdm/cohort_attribute.txt ยท Last modified: 2017/09/25 15:09 by clairblacketer
Page Tools
