Beschreibung

A foreign key to a record in the COHORT_DEFINITION table containing relevant Cohort definition information.

Datentyp

integer

Alias

UMLS CUI [1,1]

C0599755

UMLS CUI [1,2]

C1704788

UMLS CUI [1,3]

C1300638

Beschreibung

A foreign key to the subject in the cohort. These could be referring to records in the Person, Provider, Visit Occurrence table. Cohort records must contain a Subject Id, which can refer to the Person, Provider, Visit record or Care Site. The Cohort Definition will define the type of subject through the subject concept id.

Datentyp

integer

Alias

UMLS CUI [1,1]

C0599755

UMLS CUI [1,2]

C2348585

Beschreibung

The date when the cohort definition criteria for the person, provider or visit first match. Cohort records must have a Start Date.

Datentyp

date

Alias

UMLS CUI [1,1]

C0599755

UMLS CUI [1,2]

C0808070

Beschreibung

The date when the cohort definition criteria for the person, provider or visit no longer match or the cohort membership was terminated. Cohort records must have an End Date, but may be set to Start Date or could have applied a censored date using the Observation Period Start Date.

Datentyp

date

Alias

UMLS CUI [1,1]

C0599755

UMLS CUI [1,2]

C0806020