ENROLL_INFO_HX_1

Description:

The ENROLL_INFO_HX_1 contains a history of changes to the study coordinators assigned to a patient's enrollment in a research study. This table should be linked to ENROLL_INFO_HX in order to determine additional information like when the change was made and who made the change.

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 ID of the patient enrollment record for this row. This column is frequently used to link to the ENROLL_INFO table.
2	GROUP_LINE	INTEGER	No
	The line number of the associated study coordinators history in this enrollment record. Together with ENROLL_ID, this forms the foreign key to the ENROLL_INFO_HX table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple study coordinators that are associated with the enrollment modification from the ENROLL_INFO_HX table.
4	HX_MOD_COORD_ID	VARCHAR	No
	The user ID of the study coordinators for the enrollment.
5	HX_MOD_COORD_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.