ADV_EVT_PROC_ATTR_HISTORY

Description: |
This table contains the history of this adverse event's attribution to the associated procedure. Together with ADV_EVT_PROC_HISTORY, these tables contain the history of an adverse event's procedure attributions.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ADVERSE_EVENT_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ADVERSE_EVENT_ID | NUMERIC | No |
The unique identifier for the adverse event record.
2 | GROUP_LINE | INTEGER | No |
The line number of the adverse event history in the adverse event record. Together with ADVERSE_EVENT_ID, this forms the foreign key to the ADVERSE_EVENT_HISTORY table.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple attribution levels for the corresponding procedure record that is related to the adverse event at the time the adverse event was documented.
4 | HX_PROC_ATTRIBUTION_C_NAME | VARCHAR | No |
The attribution level category ID for the corresponding procedure to the adverse event at the time the adverse event was documented.
May contain organization-specific values: Yes
Category Entries:
Unrelated
Unlikely
Possible
Probable
Definite