OMOP Common Data Model (CDM) Death

Death
Descrizione

Death

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

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

Tipo di dati

integer

Alias
UMLS CUI [1]
C2348585
Death date
Descrizione

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.

Tipo di dati

date

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

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

Tipo di dati

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
Descrizione

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

Tipo di dati

integer

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

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.

Tipo di dati

text

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

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.

Tipo di dati

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
genere
Description | Question | Decode (Coded Value)
Tipo di dati
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])