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