EPISODE_EVENT

Table Description

The EPISODE_EVENT table connects qualifying clinical events (such as CONDITION_OCCURRENCE, DRUG_EXPOSURE, PROCEDURE_OCCURRENCE, MEASUREMENT) to the appropriate EPISODE entry. For example, linking the precise location of the metastasis (cancer modifier in MEASUREMENT) to the disease episode.

User Guide

This connecting table is used instead of the FACT_RELATIONSHIP table for linking low-level events to abstracted Episodes.

ETL Conventions

Some episodes may not have links to any underlying clinical events. For such episodes, the EPISODE_EVENT table is not populated.

CDM Field	User Guide	ETL Conventions	Datatype	Required	Primary Key	Foreign Key	FK Table	FK Domain
episode_id	Use this field to link the EPISODE_EVENT record to its EPISODE.	Put the EPISODE_ID that subsumes the EPISODE_EVENT record here.	integer	Yes	No	Yes	EPISODE
event_id	This field is the primary key of the linked record in the database. For example, if the Episode Event is a Condition Occurrence, then the CONDITION_OCCURRENCE_ID of the linked record goes in this field.	Put the primary key of the linked record here.	integer	Yes	No	No
episode_event_field_concept_id	This field is the CONCEPT_ID that identifies which table the primary key of the linked record came from.	Put the CONCEPT_ID that identifies which table and field the EVENT_ID came from. Accepted Concepts	integer	Yes	No	Yes	CONCEPT	Metadata