ID

35321

Beschreibung

OMOP Common Data Model (CDM) Death As of OMOP CDM v6.0, the DEATH table has been deprecated in favor of storing the cause of death in the CONDITION_OCCURRENCE table, any observations relating to death stored in the OBSERVATION table, and a singular death date will be chosen and stored in the PERSON table. The 'Death' domain contains the clinical events surrounding how and when a Person dies. A Person can have information in the source system containing evidence about the Death, such as: Condition Code in the Header or Detail information of claims, Status of enrollment into a health plan, Explicit record in EHR data. OMOP Common Data Model Version 6.0 Specifications 11October2018. 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. Version updated on 28.02.2019, from https://github.com/OHDSI/CommonDataModel/wiki/DEATH. Living patients should not have a value in PERSON.DEATH_DATETIME, nor should they have any records relating to death either in the CONDITION_OCCURRENCE or OBSERVATION tables. Only one death date per individual can be used. If a patient has clinical activity (e.g. prescriptions filled, labs performed, etc) more than 60+ days after death you may want to drop the death record as it may have been falsely reported. If multiple records of death exist on multiple days you may select the death that you deem most reliable (e.g. death at discharge) or select the latest death date. If multiple death records occur, the date and the person have to be the same, but the cause can be different. Can be reported by different sources as well. If PERSON.DEATH_DATETIME cannot be precisely determined from the data, the best approximation should be used. Any cause of death should be stored in the CONDITION_OCCURRENCE table, using the CONDITION_TYPE vocabulary with the DEATH_TYPE concept class. All observations relating to death should be stored in the OBSERVATION table. The DEATH_DATETIME in the PERSON table should not be used as the way to find all deaths: select * from PERSON where death_datetime is not null should not be the practice. Rather, deaths should be found through the OBSERVATION table and the PERSON table is only used to determine which death date should be used in analysis. For more information, please see https://github.com/OHDSI/CommonDataModel/wiki/DEATH

Link

http://omop.fnih.org/publiclicense

Stichworte

  1. 04.01.17 04.01.17 -
  2. 07.02.19 07.02.19 -
  3. 28.02.19 28.02.19 -
Rechteinhaber

Observational Medical Outcomes Partnership (OMOP)

Hochgeladen am

28. Februar 2019

DOI

Für eine Beantragung loggen Sie sich ein.

Lizenz

Creative Commons BY-NC 3.0

Modell Kommentare :

Hier können Sie das Modell kommentieren. Über die Sprechblasen an den Itemgruppen und Items können Sie diese spezifisch kommentieren.

Itemgroup Kommentare für :

Item Kommentare für :

Um Formulare herunterzuladen müssen Sie angemeldet sein. Bitte loggen Sie sich ein oder registrieren Sie sich kostenlos.

OMOP Common Data Model (CDM) Death

OMOP Common Data Model (CDM) Death

Death
Beschreibung

Death

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

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

Datentyp

integer

Alias
UMLS CUI [1]
C2348585
Death date
Beschreibung

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.

Datentyp

date

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

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

Datentyp

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
Beschreibung

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

Datentyp

integer

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

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.

Datentyp

text

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

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.

Datentyp

integer

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

Ähnliche Modelle

OMOP Common Data Model (CDM) Death

Name
Typ
Description | Question | Decode (Coded Value)
Datentyp
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])

Benutzen Sie dieses Formular für Rückmeldungen, Fragen und Verbesserungsvorschläge.

Mit * gekennzeichnete Felder sind notwendig.

Benötigen Sie Hilfe bei der Suche? Um mehr Details zu erfahren und die Suche effektiver nutzen zu können schauen Sie sich doch das entsprechende Video auf unserer Tutorial Seite an.

Zum Video