01Relates to the patient
reference data (no patient link)
Single-patient export: included in full (reference data).
02Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | LETTER_ID PK | integer | int | no | |
| 2 | LETTER_NAME | string | varchar(50) | no | |
| 3 | LETTER_BODY | file | image | yes | Stored file; the value is the path of the file under documents/. |
| 4 | ENTRY_USER_ID | string | varchar(20) | no | |
| 5 | ENTRY_DATE | datetime | datetime | no | |
| 6 | CHANGE_USER_ID | string | varchar(20) | no | |
| 7 | CHANGE_DATE | datetime | datetime | no | |
| 8 | RECALL_DAYS | integer | int | yes | |
| 9 | PRINT_SEQUENCE | integer | int | yes | |
| 10 | PRINT_GROUP | integer | int | yes | |
| 11 | LETTER_FILENAME | string | varchar(255) | yes |