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 | ADHERENCE_1 | string | varchar(3) | yes | |
| 3 | ADHERENCE_10 | string | varchar(3) | yes | |
| 4 | ADHERENCE_11 | string | varchar(3) | yes | |
| 5 | ADHERENCE_12 | string | varchar(3) | yes | |
| 6 | ADHERENCE_2 | string | varchar(3) | yes | |
| 7 | ADHERENCE_3 | string | varchar(3) | yes | |
| 8 | ADHERENCE_4 | string | varchar(3) | yes | |
| 9 | ADHERENCE_5 | string | varchar(3) | yes | |
| 10 | ADHERENCE_6 | string | varchar(3) | yes | |
| 11 | ADHERENCE_7 | string | varchar(3) | yes | |
| 12 | ADHERENCE_8 | string | varchar(3) | yes | |
| 13 | ADHERENCE_9 | string | varchar(3) | yes | |
| 14 | DOSAGE_1 | string | varchar(25) | yes | |
| 15 | DOSAGE_2 | string | varchar(25) | yes | |
| 16 | DOSAGE_3 | string | varchar(25) | yes | |
| 17 | DOSAGE_4 | string | varchar(25) | yes | |
| 18 | DOSAGE_5 | string | varchar(25) | yes | |
| 19 | DOSAGE_6 | string | varchar(25) | yes | |
| 20 | DOSAGE_7 | string | varchar(25) | yes | |
| 21 | DOSAGE_8 | string | varchar(25) | yes | |
| 22 | DOSAGES_10 | string | varchar(25) | yes | |
| 23 | DOSAGES_11 | string | varchar(25) | yes | |
| 24 | DOSAGES_12 | string | varchar(25) | yes | |
| 25 | DOSAGES_9 | string | varchar(25) | yes | |
| 26 | FRE_12 | string | varchar(25) | yes | |
| 27 | FREQ_1 | string | varchar(25) | yes | |
| 28 | FREQ_10 | string | varchar(25) | yes | |
| 29 | FREQ_11 | string | varchar(25) | yes | |
| 30 | FREQ_2 | string | varchar(25) | yes | |
| 31 | FREQ_3 | string | varchar(25) | yes | |
| 32 | FREQ_4 | string | varchar(25) | yes | |
| 33 | FREQ_5 | string | varchar(25) | yes | |
| 34 | FREQ_6 | string | varchar(25) | yes | |
| 35 | FREQ_7 | string | varchar(25) | yes | |
| 36 | FREQ_8 | string | varchar(25) | yes | |
| 37 | FREQ_9 | string | varchar(25) | yes | |
| 38 | MED_1 | string | varchar(25) | yes | |
| 39 | MED_10 | string | varchar(25) | yes | |
| 40 | MED_11 | string | varchar(25) | yes | |
| 41 | MED_12 | string | varchar(25) | yes | |
| 42 | MED_2 | string | varchar(25) | yes | |
| 43 | MED_3 | string | varchar(25) | yes | |
| 44 | MED_4 | string | varchar(25) | yes | |
| 45 | MED_5 | string | varchar(25) | yes | |
| 46 | MED_6 | string | varchar(25) | yes | |
| 47 | MED_7 | string | varchar(25) | yes | |
| 48 | MED_8 | string | varchar(25) | yes | |
| 49 | MED_9 | string | varchar(25) | yes | |
| 50 | MEDICATIONS_NONE | boolean | bit | yes | |
| 51 | RX_GIVEN_10 | string | varchar(25) | yes | |
| 52 | RX_GIVEN_11 | string | varchar(25) | yes | |
| 53 | RX_GIVEN_12 | string | varchar(25) | yes | |
| 54 | RX_GIVEN_2 | string | varchar(25) | yes | |
| 55 | RX_GIVEN_3 | string | varchar(25) | yes | |
| 56 | RX_GIVEN_4 | string | varchar(25) | yes | |
| 57 | RX_GIVEN_5 | string | varchar(25) | yes | |
| 58 | RX_GIVEN_6 | string | varchar(25) | yes | |
| 59 | RX_GIVEN_7 | string | varchar(25) | yes | |
| 60 | RX_GIVEN_8 | string | varchar(25) | yes | |
| 61 | RX_GIVEN_9 | string | varchar(25) | yes | |
| 62 | RX_GIVN_1 | string | varchar(25) | yes |