Sidebar
documentation:cdm:cohort_attribute
This is an old revision of the document!
COHORT_ATTRIBUTE 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 |
|---|---|---|---|
| cohort_definition_id | Yes | integer | A foreign key to a record in the 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. |
| 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_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.
- Cohort Attribute records must have a Start Date
- 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.
- 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.
documentation/cdm/cohort_attribute.1420475996.txt.gz · Last modified: 2015/01/05 16:39 by cgreich
