NOTE_EXT_REL_PREDX

Description:

This table stores information about external pre-procedure diagnoses related to an external note.

Primary Key

Column Name	Ordinal Position
NOTE_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	NOTE_CSN_ID	NUMERIC	No
	The unique contact serial number (CSN) of the note contact. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	NOTE_ID	VARCHAR	No
	The unique identifier (.1 item) for the note record.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	EXT_REL_PREDX_NAME	VARCHAR	No
	Free text name of a pre-procedure diagnosis associated with the external note