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.