ADVERSE_EVENT_HISTORY
Description:
The ADVERSE_EVENT_HISTORY table contains the history of adverse event records for a patient.

Primary Key
Column Name Ordinal Position
ADVERSE_EVENT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ADVERSE_EVENT_ID NUMERIC No
The unique identifier for the adverse event record.
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 EDIT_UTC_DTTM DATETIME (UTC) No
The date and time when this update to the adverse event was made.
4 EDIT_USER_ID VARCHAR No
The unique ID of the user who made this update to the adverse event.
5 EDIT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
6 HX_NOTE_CSN NUMERIC No
The unique contact serial number of the note containing the comments for this update of the adverse event record.
7 HX_RESEARCH_ATTRIBUTION_C_NAME VARCHAR No
The category ID of the study attribution level for the adverse event at the time the adverse event was documented.
May contain organization-specific values: Yes
Category Entries:
Unrelated
Unlikely
Possible
Probable
Definite
8 HX_SERIOUS_YN VARCHAR No
Indicates whether or not this adverse event was considered serious at the time the adverse event was documented.
May contain organization-specific values: No
Category Entries:
No
Yes
9 HX_EXPECTED_YN VARCHAR No
Indicates whether or not this adverse event was considered expected at the time the adverse event was documented.
The category values for this column were already listed for column: HX_SERIOUS_YN
10 HX_RESOLVED_DATE DATETIME No
The date the adverse event was resolved at the time the adverse event was documented.
11 HX_AE_STATUS_C_NAME VARCHAR No
The category ID of the status of this adverse event at the time of this update.
May contain organization-specific values: No
Category Entries:
Active
Resolved
Deleted
12 HX_RESEARCH_ATTR_NOT_COLL_YN VARCHAR No
Indicates whether the attribution for the associated research study was collected for this adverse event at the time of the update. 'Y' indicates that an attribution was not collected. 'N' or NULL indicate that an attribution was collected.
The category values for this column were already listed for column: HX_SERIOUS_YN
13 HX_CLINICALLY_SIGNIFICANT_YN VARCHAR No
Indicates whether or not this adverse event was considered clinically significant at the time the adverse event was documented.
The category values for this column were already listed for column: HX_SERIOUS_YN