documentation:cdm:death
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
documentation:cdm:death [2014/12/06 17:40] cgreich |
documentation:cdm:death [2017/09/25 15:00] (current) clairblacketer |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== DEATH table ===== | ===== DEATH table ===== | ||
| + | **THIS IS OUTDATED. All documentation is now on the [[https://github.com/OHDSI/CommonDataModel/wiki|github wiki]]. Please refer there or to the [[projects:workgroups:cdm-wg|CDM working group]] for more information** | ||
| + | This table changed in version 5.1 of the OMOP CDM. The death_datetime was added. | ||
| + | ---- | ||
| 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: | 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 Code in the Header or Detail information of claims | * Condition Code in the Header or Detail information of claims | ||
| Line 9: | Line 12: | ||
| |person_id|Yes|integer|A foreign key identifier to the deceased person. The demographic details of that person are stored in the person table.| | |person_id|Yes|integer|A foreign key identifier to the deceased person. The demographic details of that person are stored in the person table.| | ||
| |death_date |Yes|date|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.| | |death_date |Yes|date|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.| | ||
| + | |death_datetime |No|datetime|The date and time 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.| | ||
| |death_type_concept_id|Yes|integer|A foreign key referring to the predefined concept identifier in the Standardized Vocabularies reflecting how the death was represented in the source data.| | |death_type_concept_id|Yes|integer|A foreign key referring to the predefined concept identifier in the Standardized Vocabularies reflecting how the death was represented in the source data.| | ||
| |cause_concept_id|No|integer|A foreign key referring to a standard concept identifier in the Standardized Vocabularies for conditions.| | |cause_concept_id|No|integer|A foreign key referring to a standard concept identifier in the Standardized Vocabularies for conditions.| | ||
documentation/cdm/death.1417887654.txt.gz ยท Last modified: 2014/12/06 17:40 by cgreich
Page Tools
