COHORT table

THIS IS OUTDATED. All documentation is now on the github wiki. Please refer there or to the CDM working group for more information

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.

FieldRequiredTypeDescription
cohort_definition_idYesintegerA foreign key to a record in the COHORT_DEFINITION table containing relevant Cohort Definition information.
subject_idYesintegerA foreign key to the subject in the cohort. These could be referring to records in the PERSON, PROVIDER, VISIT_OCCURRENCE table.
cohort_start_dateYesdateThe date when the Cohort Definition criteria for the Person, Provider or Visit first match.
cohort_end_dateYesdateThe date when the Cohort Definition criteria for the Person, Provider or Visit no longer match or the Cohort membership was terminated.

Conventions