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