ADVERSE_EVENT_INFO
Description:
The ADVERSE_EVENT_INFO table contains information about adverse event records for a patient.

Primary Key
Column Name Ordinal Position
ADVERSE_EVENT_ID 1

Column Information
Name Type Discontinued?
1 ADVERSE_EVENT_ID NUMERIC No
The unique identifier for the adverse event record.
2 RESEARCH_ID VARCHAR No
The unique ID of the research study associated with this adverse event.
3 RESEARCH_ATTRIBUTION_C_NAME VARCHAR No
The category ID for the attribution level of the associated research study to this adverse event.
May contain organization-specific values: Yes
Category Entries:
Unrelated
Unlikely
Possible
Probable
Definite
4 SERIOUS_YN VARCHAR No
Indicates whether or not this adverse event is considered serious.
May contain organization-specific values: No
Category Entries:
No
Yes
5 EXPECTED_YN VARCHAR No
Indicates whether or not this adverse event is expected.
The category values for this column were already listed for column: SERIOUS_YN
6 DX_ID NUMERIC No
The unique ID of the diagnosis record containing information about the term associated with this adverse event.
7 STATUS_C_NAME VARCHAR No
The category ID of the status of this adverse event.
May contain organization-specific values: No
Category Entries:
Active
Resolved
Deleted
8 NOTE_ID VARCHAR No
The unique ID of the note record containing the comments for this adverse event.
9 RESOLVED_DATE DATETIME No
The date this adverse event was resolved.
10 RESEARCH_ATTR_NOT_COLL_YN VARCHAR No
Indicates whether the attribution for the associated research study was collected for this adverse event. '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: SERIOUS_YN
11 ENROLL_ID NUMERIC No
The unique ID of the research study association that has been linked to this adverse event. Linking an adverse event to a research study association means the adverse event may be related to or caused by the research study.
12 CLINICALLY_SIGNIFICANT_YN VARCHAR No
Indicates whether or not this adverse event is considered clinically significant.
The category values for this column were already listed for column: SERIOUS_YN