condition_era

Standardized Derived Elements

Table Columns

field	type	required	phi	phi scrubbing operation
condition_era_id	INTEGER	Yes		Not Stable between Data Refreshes
person_id	INTEGER	Yes		Sub
condition_concept_id	INTEGER	Yes
condition_era_start_date	DATETIME	Yes	Yes	Jitter
condition_era_end_date	DATETIME	Yes	Yes	Jitter
condition_occurrence_count	INTEGER	No

Columns Description

condition_era_id

A unique identifier for each Condition Era.

person_id

A foreign key identifier to the Person who is experiencing the Condition during the Condition Era. The demographic details of that Person are stored in the PERSON table.

condition_concept_id

A foreign key that refers to a standard Condition Concept identifier in the Standardized Vocabularies.

condition_era_start_date

The start date for the Condition Era constructed from the individual instances of Condition Occurrences. It is the start date of the very first chronologically recorded instance of the condition.

condition_era_end_date

The end date for the Condition Era constructed from the individual instances of Condition Occurrences. It is the end date of the final continuously recorded instance of the Condition.

condition_occurrence_count

The number of individual Condition Occurrences used to construct the condition era.