ENROLL_STAT_CHNG_HX
Description:
This table contains the enrollment status change history of a participant in a research study.

Primary Key
Column Name Ordinal Position
ENROLL_ID 1
GROUP_LINE 2
VALUE_LINE 3

Column Information
Name Type Discontinued?
1 ENROLL_ID NUMERIC No
The unique identifier for the enrollment record.
2 GROUP_LINE INTEGER No
The line number for the enrollment status change history in the enrollment record.Together with ENROLL_ID, this forms the foreign key to the ENROLL_STAT_CHNG_HX table.
3 VALUE_LINE INTEGER No
The line number of one of the multiple enrollment status changes associated with the enrollment record and the ENROLL_STAT_CHNG_DT_HX_DATE from the ENROLL_STAT_CHNG_DT_HX table
4 HX_CHNG_ENROLL_STATUS_C_NAME VARCHAR No
The enrollment status category ID of a status change in the enrollment history.
May contain organization-specific values: Yes