This is an old revision of the document!
The COHORT table contains records of subjects that satisfy a given set of criteria for a duration of time. The definition of the cohort is contained within the COHORT_DEFINITION table. Cohorts can be constructed of patients (Persons), Providers or Visits.
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. |