REG_HX_AFF_PAT

Description:

This table shows information for patients that are affected when tracking registration history event notes.

Primary Key

Column Name	Ordinal Position
NOTE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	NOTE_ID	VARCHAR	No
	The unique identifier 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	REG_HX_PAT_CSN	NUMERIC	No
	The unique contact serial number for the patients affected by this event. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
4	REG_HX_PAT_DEPT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.