ENROLL_STAT_CHNG_DT_HX

Description:

This table contains the history of enrollment status change effective dates for a patient 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 (.1 item) for the enrollment record.
2	GROUP_LINE	INTEGER	No
	The line number of the enrollment status change date in the enrollment record. Together with ENROLL_ID, this forms the foreign key to the ENROLL_STAT_CHNG_DT_HX table
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple enrollment status change dates associated with the enrollment record and the ENROLL_STAT_CHNG_HX_C from the ENROLL_STAT_CHNG_HX table
4	HX_ENROLL_STAT_CHNG_DATE	DATETIME	No
	The effective date of an enrollment status change in the history of an enrollment record.