|
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. |
|
|
