SM_CAUSE_OF_DEATH Table
Information about the Oracle Empirica Signal configuration variables from the SM_CAUSE_ OF_DEATH table.
| Configuration Variable | Column | Description |
|---|---|---|
|
(Cause of Death) Autopsy Results |
RESULTS_VE |
Status of autopsy results |
|
(Cause of Death) Case Number |
CASE_NUM |
Case number |
|
(Cause of Death) Cause of Death Autopsy |
CAUSE_AUTOPSY |
Autopsy cause of death |
|
(Cause of Death) Cause of Death Reported |
CAUSE_REPTD |
Death cause as reported |
| (Cause of Death) Cause Type | CAUSE_TYPE_VE | Cause of death / autopsy result |
|
(Cause of Death) Date of Death |
DEATH_DATE |
Date of death |
|
(Cause of Death) Detailed Cause of Death |
DETAILED_CAUSE |
Detailed cause of death |
|
(Cause of Death) HLGT |
CAUSE_HLGT |
Death cause HLGT |
|
(Cause of Death) HLT |
CAUSE_HLT |
Death cause HLT |
|
(Cause of Death) SOC |
CAUSE_SOC |
Death cause SOC |
|
(Cause of Death) Sort ID |
CAUSE_SORT_ID |
Cause of death sort order |
|
(Cause of Death) Term Type |
TERM_TYPE_VE |
Term type |
|
(Cause of Death) ValidEnd |
VALIDEND |
Valid end date |
|
(Cause of Death) ValidStart |
VALIDSTART |
Valid start date |
Parent topic: Data Mining Table Schema