ENC_LETTERS

Description:

Information about ADT Encounters Letters.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ENC_CSN_ID	NUMERIC	No
	A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
2	LINE	INTEGER	No
	The line number of the letter within the encounter. This is the second column in the primary key and, in addition to the contact serial number, uniquely identifies a letter within an encounter.
3	PAT_ID	VARCHAR	No
	The unique ID assigned to the patient record.
4	LETTER_ID	VARCHAR	No
	Encounter Letter to print
5	LETTER_ID_SMARTTEXT_NAME	VARCHAR	No
	The name of the SmartText record.
6	UPDATE_INSTANT	DATETIME (Local)	No
	When the letter was last updated (added or printed)
7	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.