EXTERNAL_DEATH_REPORTS
Description:
External reports of patient death information.

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 EXT_DEATH_STAT_C_NAME VARCHAR No
Stores the current status of a given external report on a patient's death.
May contain organization-specific values: No
Category Entries:
Unconfirmed
Marked As Deceased
Declined Report
Erroneous
4 EXT_DEATH_DATE DATETIME No
Stores the reported date of death of a given external report on a patient's death.
5 EXT_DEATH_SOURCE_C_NAME VARCHAR No
Stores the source of a given external report on a patient's death.
May contain organization-specific values: Yes
Category Entries:
Patient Load
6 EXT_DEATH_COMMENT VARCHAR No
Stores an optional comment of a given external report on a patient's death.