01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
APPT_ID→APPOINTMENTS.APPT_IDOFFICE_LOCATION→LOCATIONS.OFFICE_LOCATIONMASTER_TEMPLATE_ID→EMR_MASTER_TEMPLATES.MASTER_TEMPLATE_IDPROVIDER_CODE→PROVIDERS.PROVIDER_CODEREF_PROV_CODE→REFERRING_PROVIDERS.REF_PROV_CODESERVICE_NAME→SERVICES.SERVICE_NAMEACCOUNT,ACCIDENT_DATE→PAT_ACCIDENTS.ACCOUNT,ACCIDENT_DATEACTIVE_USER→USERS.USER_IDASSESSMENT_ENCOUNTER_ID→EMR_ENCOUNTERS.ENCOUNTER_IDACCOUNT,EPISODE_CARE_ID→PAT_PROGRAMS.ACCOUNT,EPISODE_CARE_IDACCOUNT→PEOPLE.ACCOUNTPROGRAM_CODE→PROGRAM_CODES.PROGRAM_CODE
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ENCOUNTER_ID PK | integer | int | no | |
| 2 | ENCOUNTER_DATE | datetime | datetime | no | |
| 3 | ENCOUNTER_END_DATE | datetime | datetime | yes | |
| 4 | ACCOUNT | string | varchar(12) | yes | |
| 5 | APPT_ID | integer | int | yes | |
| 6 | OFFICE_LOCATION | string | varchar(20) | yes | |
| 7 | PROVIDER_CODE | string | varchar(20) | no | |
| 8 | REF_PROV_CODE | string | varchar(20) | yes | |
| 9 | SERVICE_NAME | string | varchar(40) | yes | |
| 10 | MASTER_TEMPLATE_ID | integer | int | yes | |
| 11 | CREATED_USER_ID | string | varchar(20) | no | |
| 12 | CREATED_DATE | datetime | datetime | no | |
| 13 | MODIFIED_USER_ID | string | varchar(20) | yes | |
| 14 | MODIFIED_DATE | datetime | datetime | yes | |
| 15 | RULES_NOT_MET_TEMPS | string | varchar(100) | yes | |
| 16 | SUPERVISOR_ID | string | varchar(20) | yes | |
| 17 | AMENDED_DATE | datetime | datetime | yes | |
| 18 | AMENDED_USER_ID | string | varchar(20) | yes | |
| 19 | EPISODE_CARE_ID | integer | int | yes | |
| 20 | ACCIDENT_DATE | datetime | smalldatetime | yes | |
| 21 | IN_USE_BY | string | varchar(51) | yes | |
| 22 | IS_DELETED | boolean | bit | yes | 1 = the encounter was deleted in the application. Deleted records are included in exports. |
| 23 | ASSESSMENT_ENCOUNTER_ID | integer | int | yes | |
| 24 | IMAGE_BODY | file | image | yes | The signed encounter note rendered as PDF (path to the file under documents/). |
| 25 | IMAGE_FORMAT | string | varchar(5) | yes | |
| 26 | REVIEW_USER | string | varchar(20) | yes | |
| 27 | REVIEW_DATE | datetime | datetime | yes | |
| 28 | INCOMPLETE_DATE | datetime | datetime | yes | |
| 29 | INCOMPLETE_USER_ID | string | varchar(20) | yes | |
| 30 | INCOMPLETE_REASON | string | varchar(500) | yes | |
| 31 | ACTIVE_USER | string | varchar(20) | yes | |
| 32 | VOID_DATE | datetime | datetime | yes | |
| 33 | VOID_USER_ID | string | varchar(20) | yes | |
| 34 | VOID_REASON | string | varchar(300) | yes | |
| 35 | PROGRAM_CODE | string | varchar(15) | yes | |
| 36 | FIRST_CONTACT_DATE | datetime | smalldatetime | yes | |
| 37 | HEALTH_INFO_REQUESTED | boolean | bit | yes | |
| 38 | HEALTH_INFO_PROVIDED | boolean | bit | yes | |
| 39 | LOGO_IMAGE_ID | integer | int | yes |