01Relates to the patient
ENCOUNTER_ID matches EMR_ENCOUNTERS.ENCOUNTER_ID on a row of EMR_ENCOUNTERS that relates to the patient
Single-patient export: the patient's rows.
02References
ENCOUNTER_ID→EMR_ENCOUNTERS.ENCOUNTER_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ENCOUNTER_ID PK | integer | int | no | |
| 2 | ASSESSED_NEED_1 | string | varchar(90) | yes | |
| 3 | ASSESSED_NEED_1_A | boolean | bit | yes | |
| 4 | ASSESSED_NEED_1_D | boolean | bit | yes | |
| 5 | ASSESSED_NEED_1_ID | boolean | bit | yes | |
| 6 | ASSESSED_NEED_1_R | boolean | bit | yes | |
| 7 | ASSESSED_NEED_2 | string | varchar(90) | yes | |
| 8 | ASSESSED_NEED_2_A | boolean | bit | yes | |
| 9 | ASSESSED_NEED_2_D | boolean | bit | yes | |
| 10 | ASSESSED_NEED_2_ID | boolean | bit | yes | |
| 11 | ASSESSED_NEED_2_R | boolean | bit | yes | |
| 12 | ASSESSED_NEED_3 | string | varchar(90) | yes | |
| 13 | ASSESSED_NEED_3_A | boolean | bit | yes | |
| 14 | ASSESSED_NEED_3_D | boolean | bit | yes | |
| 15 | ASSESSED_NEED_3_ID | boolean | bit | yes | |
| 16 | ASSESSED_NEED_3_R | boolean | bit | yes | |
| 17 | ASSESSED_NEED_4 | string | varchar(90) | yes | |
| 18 | ASSESSED_NEED_4_A | boolean | bit | yes | |
| 19 | ASSESSED_NEED_4_D | boolean | bit | yes | |
| 20 | ASSESSED_NEED_4_ID | boolean | bit | yes | |
| 21 | ASSESSED_NEED_4_R | boolean | bit | yes | |
| 22 | INDIVIDUAL_DECLINED_1 | string | varchar(max) | yes | |
| 23 | INDIVIDUAL_DECLINED_2 | string | varchar(max) | yes | |
| 24 | INDIVIDUAL_DECLINED_3 | string | varchar(max) | yes | |
| 25 | NONE | boolean | bit | yes | |
| 26 | SERVICE_PREFERENCE | string | varchar(max) | yes | |
| 27 | NO_ADDITIONAL_RECOMMENDATION | boolean | bit | yes | |
| 28 | LEVEL_OF_CARE | string | varchar(max) | yes | |
| 29 | NO_CHANGE | boolean | bit | yes | |
| 30 | INDIVIDUAL_SERVED | string | varchar(max) | yes |