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_RESEARCH_STUDY_NAME | VARCHAR | No |
The name of the research study record.
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_DX_NAME | VARCHAR | No |
The name of the diagnosis.
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