ENROLL_LINKED_CSN_HX

Description:

This table stores history information about encounters linked to or unlinked from research enrollments.

Primary Key

Column Name	Ordinal Position
ENROLL_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ENROLL_ID	NUMERIC	No
	The unique identifier for the enrollment record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	HX_PRL_CSN	NUMERIC	No
	History information of study protocols linked to the encounter's contact serial numbers (CSN).
4	HX_LNK_UNIQ_DAY_NUM	INTEGER	No
	History information of the timeline day linked to this encounter. This value corresponds to the value in ENROLL_TIMELINE.UNIQ_DAY_NUM.
5	HX_TPL_CSN	NUMERIC	No
	History information of the treatment plan contact serial number (CSN) linked to the encounter.
6	HX_TREATMENTDAY_CSN	NUMERIC	No
	History information of the treatment day contact serial number (CSN) linked to the encounter.
7	HX_WHO_LINK_ENC_ID	VARCHAR	No
	History information of the user who linked or unlinked an encounter to a study.
8	HX_WHO_LINK_ENC_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
9	HX_WHEN_LINK_ENC_DTTM	DATETIME (UTC)	No
	History information of UTC formatted instant when user links or unlinks an encounter to a study.
10	HX_LINKENC_ACTION_C_NAME	VARCHAR	No
	History information of what action the user takes on encounter-study linkage. May contain organization-specific values: Yes Category Entries: Linked Unlinked
11	HX_LINKED_ENC_CSN	NUMERIC	No
	History information of contact serial numbers (CSN) of encounters linked to the study.
12	HX_TREATMENT_DAY_LINE	INTEGER	No
	History information of the line number of the treatment day in the treatment plan that this encounter is linked to.