OMOP_5.4_ER_ALL

OMOP_5.4_ER : Model

Entity - death link

Properties
Name Value
Description

DEATH

Table Description

The death domain contains the clinical event for how and when a Person dies. A person can have up to one record if the source system contains evidence about the Death, such as: Condition in an administrative claim, status of enrollment into a health plan, or explicit record in EHR data.

CDM Field User Guide ETL Conventions Datatype Required Primary Key Foreign Key FK Table FK Domain
person_id integer Yes No Yes PERSON
death_date The date the person was deceased. If the precise date include day or month is not known or not allowed, December is used as the default month, and the last day of the month the default day. date Yes No No
death_datetime If not available set time to midnight (00:00:00) datetime No No No
death_type_concept_id This is the provenance of the death record, i.e., where it came from. It is possible that an administrative claims database would source death information from a government file so do not assume the Death Type is the same as the Visit Type, etc. Use the type concept that be reflects the source of the death record. Accepted Concepts. A more detailed explanation of each Type Concept can be found on the vocabulary wiki. integer No No Yes CONCEPT Type Concept
cause_concept_id This is the Standard Concept representing the Person’s cause of death, if available. There is no specified domain for this concept, just choose the Standard Concept Id that best represents the person’s cause of death. integer No No Yes CONCEPT
cause_source_value If available, put the source code representing the cause of death here. varchar(50) No No No
cause_source_concept_id If the cause of death was coded using a Vocabulary present in the OMOP Vocabularies put the CONCEPT_ID representing the cause of death here. integer No No Yes CONCEPT

Data Model Physical
Primary Key Clustered Unspecified
Unlogged false

Columns Summary
Column Name Data Type PK / FK Nullable Description
person_id int4 PK / FK No
death_date date No
death_datetime timestamp(0) Yes
death_type_concept_id int4 PK / FK No
cause_concept_id int4 PK / FK No
cause_source_value varchar(50) Yes
cause_source_concept_id int4 PK / FK No

Relationships Summary
Name Begin End
 fpk_death_person_id : Relationship
 person : Entity
 death : Entity
 fpk_death_death_type_concept_id : Relationship
 concept : Entity
 death : Entity
 fpk_death_cause_concept_id : Relationship
 concept : Entity
 death : Entity
 fpk_death_cause_source_concept_id : Relationship
 concept : Entity
 death : Entity

Columns Detail
Name Value
Name person_id
Type int4
Nullable false
Unique false
Primary Key true
Index false
Length 0
Scale 0
Id Generator native
Foreign Key true
Generated Unspecified
Sync To Attribute Yes

Name Value
Name death_date
Type date
Nullable false
Unique false
Primary Key false
Index false
Type Name date
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name death_datetime
Type timestamp
Nullable true
Unique false
Primary Key false
Index false
Type Name timestamp
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name death_type_concept_id
Type int4
Nullable false
Unique false
Primary Key true
Index false
Length 0
Scale 0
Id Generator native
Foreign Key true
Generated Unspecified
Sync To Attribute Yes

Name Value
Name cause_concept_id
Type int4
Nullable false
Unique false
Primary Key true
Index false
Length 0
Scale 0
Id Generator native
Foreign Key true
Generated Unspecified
Sync To Attribute Yes

Name Value
Name cause_source_value
Type varchar
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 50
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name cause_source_concept_id
Type int4
Nullable false
Unique false
Primary Key true
Index false
Length 0
Scale 0
Id Generator native
Foreign Key true
Generated Unspecified
Sync To Attribute Yes

Relationships Detail
Name Value
Name fpk_death_person_id
Foreign Key
death
 person_id : Column
Primary Key
person
 person_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_death_death_type_concept_id
Foreign Key
death
 death_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_death_cause_concept_id
Foreign Key
death
 cause_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_death_cause_source_concept_id
Foreign Key
death
 cause_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Appears In
Diagram
 Standardized_Tables : Entity Relationship Diagram
 Vocabulary_With_Standard : Entity Relationship Diagram
OMOP_5.4_ER_ALL