NOTE_RESEARCH_LINK_HX

Description:

This table contains information about how the research study linkage on a note has changed over time.

Primary Key

Column Name	Ordinal Position
NOTE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	NOTE_ID	VARCHAR	No
	The unique identifier (.1 item) for the note 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_RESEARCH_ID_RESEARCH_STUDY_NAME	VARCHAR	No
	The name of the research study record.
4	HX_ENROLL_ID	NUMERIC	No
	History of the linked study association for the note.
5	HX_STUDY_LINK_UTC_DTTM	DATETIME (UTC)	No
	History of when the research link of the note was modified.
6	HX_STUDY_USER_ID	VARCHAR	No
	History of the user who modified the research link of a note.
7	HX_STUDY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.