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.