ID

19487

Description

OMOP Common Data Model (CDM) Death The DEATH table contains the clinical event for how and when a person dies. A person can have up to one record if the source systems contain evidence that s/he is deceased. All persons who were alive during all observation periods should not contain any information in the death table. The Observational Medical Outcomes Partnership (OMOP) was a public-private partnership established to inform the appropriate use of observational healthcare databases for studying the effects of medical products. © 2014 Observational Health Data Sciences and Informatics This work is based on work by the Observational Medical Outcomes Partnership (OMOP) and used under license from the FNIH at http://omop.fnih.org/publiclicense.

Link

http://omop.fnih.org/publiclicense

Keywords

  1. 1/4/17 1/4/17 -
  2. 2/7/19 2/7/19 -
  3. 2/28/19 2/28/19 -
Uploaded on

January 4, 2017

DOI

To request one please log in.

License

Creative Commons BY-NC 3.0

Model comments :

You can comment on the data model here. Via the speech bubbles at the itemgroups and items you can add comments to those specificially.

Itemgroup comments for :

Item comments for :

In order to download data models you must be logged in. Please log in or register for free.

OMOP Common Data Model (CDM) Death

OMOP Common Data Model (CDM) Death

Death
Description

Death

Alias
UMLS CUI-1
C0011065
UMLS CUI-2
C1955348
Person ID
Description

A foreign key identifier to the deceased person. The demographic details of that person are stored in the person table.

Data type

integer

Alias
UMLS CUI [1]
C2348585
Death date
Description

The date the person was deceased. If the precise date including 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.

Data type

date

Alias
UMLS CUI [1,1]
C0011008
UMLS CUI [1,2]
C0011065
Death type concept ID
Description

A foreign key referring to the predefined concept identifier in the Standardized Vocabularies reflecting how the death was represented in the source data.

Data type

integer

Alias
UMLS CUI [1,1]
C0011065
UMLS CUI [1,2]
C0332307
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Cause concept ID
Description

A foreign key referring to a standard concept identifier in the Standardized Vocabularies for conditions.

Data type

integer

Alias
UMLS CUI [1,1]
C0007465
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Cause source value
Description

The source code for the cause of death as it appears in the source data. This code is mapped to a standard concept in the Standardized Vocabularies and the original code is, stored here for reference.

Data type

text

Alias
UMLS CUI [1,1]
C0007465
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C1522609
Cause source concept ID
Description

A foreign key to the concept that refers to the code used in the source. Note, this variable name is abbreviated to ensure it will be allowable across database platforms.

Data type

integer

Alias
UMLS CUI [1,1]
C0007465
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638

Similar models

OMOP Common Data Model (CDM) Death

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Death
C0011065 (UMLS CUI-1)
C1955348 (UMLS CUI-2)
Person ID
Item
Person ID
integer
C2348585 (UMLS CUI [1])
Death date
Item
Death date
date
C0011008 (UMLS CUI [1,1])
C0011065 (UMLS CUI [1,2])
Death type concept ID
Item
Death type concept ID
integer
C0011065 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Cause concept ID
Item
Cause concept ID
integer
C0007465 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Cause source value
Item
Cause source value
text
C0007465 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C1522609 (UMLS CUI [1,3])
Cause source concept ID
Item
Cause source concept ID
integer
C0007465 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])

Please use this form for feedback, questions and suggestions for improvements.

Fields marked with * are required.

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial