01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
ACCOUNT→PATIENTS.ACCOUNTIMAGE_TYPE→V_IMAGE_TYPES.IMAGE_TYPEACCOUNT,EPISODE_CARE_ID→PAT_PROGRAMS.ACCOUNT,EPISODE_CARE_IDMASTER_TEMPLATE_CLASS→EMR_V_MASTER_TEMPLATE_CLASSES.MASTER_TEMPLATE_CLASS
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ACCOUNT PK | string | varchar(12) | no | |
| 2 | IMAGE_ID PK | integer | int | no | |
| 3 | IMAGE_TYPE | string | varchar(15) | no | |
| 4 | IMAGE_DESCRIPTION | string | varchar(200) | no | |
| 5 | IMAGE_DATETIME | datetime | datetime | no | |
| 6 | IMAGE_BODY | file | image | no | The stored document or image (path to the file under documents/). |
| 7 | IMAGE_THUMB | file | image | yes | Thumbnail image of the document, when one was stored. |
| 8 | IMAGE_FORMAT | string | varchar(5) | yes | File type recorded when the document was stored (e.g. PDF, JPG). |
| 9 | ENTRY_DATE | datetime | datetime | no | |
| 10 | ENTRY_USER_ID | string | varchar(20) | no | |
| 11 | CHANGE_DATE | datetime | datetime | no | |
| 12 | CHANGE_USER_ID | string | varchar(20) | no | |
| 13 | IMAGE_FILENAME | string | varchar(255) | yes | |
| 14 | EPISODE_CARE_ID | integer | int | yes | |
| 15 | PHI | boolean | bit | yes | |
| 16 | SHOW_ON_ENC_LIST | boolean | bit | yes | |
| 17 | ZIPPED | boolean | bit | yes | |
| 18 | MASTER_TEMPLATE_CLASS | string | varchar(15) | yes |