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.