PAT_ENC_LETTERS

Description:

The patient encounter letters table contains information about letters associated with encounters.

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
	The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2	LINE	INTEGER	No
	The line count used to identify different letters associated with an encounter.
3	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
4	LTR_STATUS_C_NAME	VARCHAR	No
	The category value associated with the status of each letter, such as 1- Open, 2- Deleted, 3- Sent, 4- Voided, 5-Sent by batch. May contain organization-specific values: No Category Entries: Open Deleted Sent Voided Sent by batch
5	LETTER_CREAT_DT	DATETIME	No
	The date that the letter was created.
6	LETTER_HNO_ID	VARCHAR	No
	The note (HNO) record that hold the letter text.
7	LETTER_FROM_ID	VARCHAR	No
	The user ID of the user entered as the "from" user in the letter activity.
8	LETTER_FROM_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
9	LETTER_ROUT_CMT_ID	VARCHAR	No
	The note (HNO) ID that holds the letter routing comments.
10	LETTER_REASON_C_NAME	VARCHAR	No
	The category value associated with the reason for the letter. May contain organization-specific values: Yes
11	LETTER_REASON_CMT	VARCHAR	No
	The comment for the letter reason.
12	LTR_STATUS_CHG_TM	DATETIME (Attached)	No
	The instant (date and time) the status of the letter was created or changed.
13	LTR_STAT_CH_USR_ID	VARCHAR	No
	The user that changed or created the letter status.
14	LTR_STAT_CH_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
15	LETTER_DELVRY_ADDR	VARCHAR	No
	The address the letter was sent to.
16	LETTER_RETURN_ADDR	VARCHAR	No
	The return address for the letter
17	LETTER_WORKINGDAYS	INTEGER	No
	The number of work days (excluding weekends and holidays) from the date of the letter's encounter to the date the letter was sent.