Note:
A person’s death should be removed if any data available > 30 days after date_of_death
CDM Table: DEATH
In Optum EHR this information will be sourced from the native PATIENT table. Only take records where DECEASED_INDICATOR = 1 and DATE_OF_DEATH is not blank.
| Destination Field | Source Field | Applied Rule | Comment |
|---|---|---|---|
| PERSON_ID | PTID | ||
| DEATH_DATE | DATE_OF_DEATH | Since DATE_OF_DEATH is given as year/month, use the last day of the month as the day value. | |
| DEATH_DATETIME | Set time to 00:00:00 UTC Tz | ||
| DEATH_TYPE_CONCEPT_ID | 32519 | ||
| CAUSE_OF_DEATH_CONCEPT_ID | 0 | ||
| CAUSE_OF_DEATH_SOURCE_VALUE | 0 | ||
| CAUSE_SOURCE_CONCEPT_ID | 0 |
Change Log:
07-Feb-2024
- Added note