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 | ABDOMINAL_GIRTH | string | varchar(30) | yes | |
| 3 | ACTION_TAKEN_HIV | string | varchar(3) | yes | |
| 4 | ACTION_TAKEN_HIV_EXPLAIN | string | varchar(4000) | yes | |
| 5 | ACTION_TAKEN_UNDERSIGNED | string | varchar(3) | yes | |
| 6 | ALLERGIES_MED | string | varchar(4000) | yes | |
| 7 | ALLERGIES_OTHER | string | varchar(4000) | yes | |
| 8 | BLOOD_PRESSURE | string | varchar(30) | yes | |
| 9 | CHILD_ANY_OTHER_SIGNIFICANT_INFO | string | varchar(4000) | yes | |
| 10 | CHILD_DIPTHERIA | boolean | bit | yes | |
| 11 | CHILD_HEPATITIS_B | boolean | bit | yes | |
| 12 | CHILD_IMMUNIZATION_COMMENTS | string | varchar(4000) | yes | |
| 13 | CHILD_IMMUNIZATION_UPTO_DATE | string | varchar(3) | yes | |
| 14 | CHILD_MUMPS | boolean | bit | yes | |
| 15 | CHILD_POLIO | boolean | bit | yes | |
| 16 | CHILD_PRENATAL_EXPOSURE_COMMENTS | string | varchar(4000) | yes | |
| 17 | CHILD_SMALL_POX | boolean | bit | yes | |
| 18 | CHILD_TETANUS | boolean | bit | yes | |
| 19 | COMMENTS | string | varchar(4000) | yes | |
| 20 | CONDITION_COMMENT_11 | string | varchar(55) | yes | |
| 21 | CONDITION_COMMENT_12 | string | varchar(55) | yes | |
| 22 | CONDITION_COMMENT_13 | string | varchar(55) | yes | |
| 23 | CONDITION_COMMENT_14 | string | varchar(55) | yes | |
| 24 | CONDITION_COMMENT_15 | string | varchar(55) | yes | |
| 25 | CONDITION_COMMENT_16 | string | varchar(55) | yes | |
| 26 | CONDITION_COMMENT_17 | string | varchar(55) | yes | |
| 27 | CONDITION_COMMENT_18 | string | varchar(55) | yes | |
| 28 | CONDITION_COMMENT_19 | string | varchar(55) | yes | |
| 29 | CONDITION_COMMENT_21 | string | varchar(55) | yes | |
| 30 | CONDITION_COMMENT_23 | string | varchar(55) | yes | |
| 31 | CONDITION_COMMENT_24 | string | varchar(55) | yes | |
| 32 | CONDITION_COMMENT_5 | string | varchar(55) | yes | |
| 33 | CONDITION_COMMENT_7 | string | varchar(55) | yes | |
| 34 | CONDITION_COMMENT_9 | string | varchar(55) | yes | |
| 35 | CONDITION_DOCTOR_CARE_1 | string | varchar(3) | yes | |
| 36 | CONDITION_DOCTOR_CARE_12 | string | varchar(3) | yes | |
| 37 | CONDITION_DOCTOR_CARE_15 | string | varchar(3) | yes | |
| 38 | CONDITION_DOCTOR_CARE_17 | string | varchar(3) | yes | |
| 39 | CONDITION_DOCTOR_CARE_18 | string | varchar(3) | yes | |
| 40 | CONDITION_DOCTOR_CARE_19 | string | varchar(3) | yes | |
| 41 | CONDITION_DOCTOR_CARE_20 | string | varchar(3) | yes | |
| 42 | CONDITION_DOCTOR_CARE_21 | string | varchar(3) | yes | |
| 43 | CONDITION_DOCTOR_CARE_22 | string | varchar(3) | yes | |
| 44 | CONDITION_DOCTOR_CARE_23 | string | varchar(3) | yes | |
| 45 | CONDITION_DOCTOR_CARE_24 | string | varchar(3) | yes | |
| 46 | CONDITION_DOCTOR_CARE_3 | string | varchar(3) | yes | |
| 47 | CONDITION_DOCTOR_CARE_5 | string | varchar(3) | yes | |
| 48 | CONDITION_DOCTOR_CARE_7 | string | varchar(3) | yes | |
| 49 | CONDITION_NOW_PAST_11 | string | varchar(4) | yes | |
| 50 | CONDITION_NOW_PAST_12 | string | varchar(4) | yes | |
| 51 | CONDITION_NOW_PAST_13 | string | varchar(4) | yes | |
| 52 | CONDITION_NOW_PAST_14 | string | varchar(4) | yes | |
| 53 | CONDITION_NOW_PAST_15 | string | varchar(4) | yes | |
| 54 | CONDITION_NOW_PAST_16 | string | varchar(4) | yes | |
| 55 | CONDITION_NOW_PAST_19 | string | varchar(4) | yes | |
| 56 | CONDITION_NOW_PAST_2 | string | varchar(4) | yes | |
| 57 | CONDITION_NOW_PAST_21 | string | varchar(4) | yes | |
| 58 | CONDITION_NOW_PAST_22 | string | varchar(4) | yes | |
| 59 | CONDITION_NOW_PAST_23 | string | varchar(4) | yes | |
| 60 | CONDITION_NOW_PAST_24 | string | varchar(4) | yes | |
| 61 | CONDITION_NOW_PAST_3 | string | varchar(4) | yes | |
| 62 | CONDITION_NOW_PAST_6 | string | varchar(4) | yes | |
| 63 | CONDITION_NOW_PAST_7 | string | varchar(4) | yes | |
| 64 | CONDITION_NOW_PAST_8 | string | varchar(4) | yes | |
| 65 | CONDITION_NOW_PAST_9 | string | varchar(4) | yes | |
| 66 | DATE_2 | datetime | datetime | yes | |
| 67 | DATE_3 | datetime | datetime | yes | |
| 68 | DATE_4 | datetime | datetime | yes | |
| 69 | DENTIST_ADDRESS | string | varchar(200) | yes | |
| 70 | DENTIST_LAST_EXAM | datetime | datetime | yes | |
| 71 | DENTIST_NAME | string | varchar(65) | yes | |
| 72 | DENTIST_PHONE | string | varchar(14) | yes | |
| 73 | DOCTOR_ADDRESS | string | varchar(200) | yes | |
| 74 | DOCTOR_LAST_EXAM | datetime | datetime | yes | |
| 75 | DOCTOR_NAME | string | varchar(65) | yes | |
| 76 | DOCTOR_PHONE | string | varchar(14) | yes | |
| 77 | HEIGHT | string | varchar(30) | yes | |
| 78 | HOSPITAL_2 | string | varchar(40) | yes | |
| 79 | HOSPITAL_4 | string | varchar(40) | yes | |
| 80 | HOSPITALIZATION | string | varchar(3) | yes | |
| 81 | NONE | boolean | bit | yes | |
| 82 | NUTRIONAL_HYDRATION_DESC | string | varchar(4000) | yes | |
| 83 | NUTRITION_HYDRATION | boolean | bit | yes | |
| 84 | NUTRITIONAL_HYDRATION_STATUS_1 | string | varchar(4000) | yes | |
| 85 | NUTRITIONAL_HYDRATION_STATUS_2 | string | varchar(3) | yes | |
| 86 | NUTRITIONAL_HYDRATION_STATUS_2_EXPLAIN | string | varchar(4000) | yes | |
| 87 | OTHER_DESC | string | varchar(4000) | yes | |
| 88 | PAIN_ADEQUATELY_CONTROLLED_UNDER_MED_CARE | string | varchar(3) | yes | |
| 89 | PAIN_ASSESSMENT | string | varchar(3) | yes | |
| 90 | PAIN_DESCRIPTION_1 | string | varchar(4000) | yes | |
| 91 | PAIN_LOCATION_2 | string | varchar(50) | yes | |
| 92 | PAIN_SITE_1 | string | varchar(50) | yes | |
| 93 | PHYSCIAL_NO_PHYSICAL_EXAM | boolean | bit | yes | |
| 94 | PHYSICAL_DATE_1 | datetime | datetime | yes | |
| 95 | PHYSICAL_EXAM | string | varchar(1) | yes | |
| 96 | PHYSICAL_EXAM_2 | boolean | bit | yes | |
| 97 | PRIMARY_CARE_PHYSICAL_DESC | string | varchar(4000) | yes | |
| 98 | PULSE | string | varchar(30) | yes | |
| 99 | REASON_1 | string | varchar(70) | yes | |
| 100 | REASON_2 | string | varchar(70) | yes | |
| 101 | REASON_3 | string | varchar(70) | yes | |
| 102 | REASON_4 | string | varchar(70) | yes | |
| 103 | REMPERATURE | string | varchar(30) | yes | |
| 104 | SPECIALTY_CARE_DESC | string | varchar(4000) | yes | |
| 105 | WAS_LAST_PHYSICAL_COMPLETED | string | varchar(3) | yes | |
| 106 | WAS_LAST_PHYSICAL_COMPLETES_DOC | string | varchar(4000) | yes | |
| 107 | WEIGHT | string | varchar(30) | yes | |
| 108 | WOEMN_POLYCUSTIC_OVARY | string | varchar(3) | yes | |
| 109 | WOEMN_PREGNANACY_HISTORY_EXPLAIN | string | varchar(4000) | yes | |
| 110 | WOMEN_BREASTFEEDING | string | varchar(3) | yes | |
| 111 | WOMEN_CURRENTLY_PREGNANT | string | varchar(3) | yes | |
| 112 | WOMEN_MENSTRUAL_IRREGULARITIES | string | varchar(3) | yes | |
| 113 | WOMEN_MENSTRUAL_IRREGULARITIES_OTHER | string | varchar(50) | yes | |
| 114 | WOMEN_MENSTRUAL_PAIN | string | varchar(3) | yes | |
| 115 | WOMEN_MENSTRUAL_PERIOD_DATE | datetime | datetime | yes | |
| 116 | WOMEN_PRE_MENSTRUAL_SYMPTOMS | string | varchar(3) | yes | |
| 117 | WOMEN_PREGNANCY_HISTORY | string | varchar(3) | yes | |
| 118 | WOMEN_PRENATAL | string | varchar(3) | yes | |
| 119 | PRESCRIBER_1 | string | varchar(30) | yes | |
| 120 | PRESCRIBER_4 | string | varchar(30) | yes | |
| 121 | PRESCRIBER_5 | string | varchar(30) | yes | |
| 122 | PRESCRIBER_6 | string | varchar(30) | yes | |
| 123 | PRESCRIBER_7 | string | varchar(30) | yes | |
| 124 | PRESCRIBER_8 | string | varchar(30) | yes | |
| 125 | PURPOSE_2 | string | varchar(20) | yes | |
| 126 | PURPOSE_5 | string | varchar(20) | yes | |
| 127 | PURPOSE_7 | string | varchar(20) | yes | |
| 128 | SIDE_EFFECTS_1 | string | varchar(20) | yes | |
| 129 | SIDE_EFFECTS_2 | string | varchar(20) | yes | |
| 130 | SIDE_EFFECTS_3 | string | varchar(20) | yes | |
| 131 | SIDE_EFFECTS_4 | string | varchar(20) | yes | |
| 132 | SIDE_EFFECTS_5 | string | varchar(20) | yes | |
| 133 | SIDE_EFFECTS_6 | string | varchar(20) | yes | |
| 134 | SIDE_EFFECTS_7 | string | varchar(20) | yes | |
| 135 | SIDE_EFFECTS_8 | string | varchar(20) | yes | |
| 136 | MEDICATION_2 | string | varchar(20) | yes | |
| 137 | MEDICATION_3 | string | varchar(20) | yes | |
| 138 | MEDICATION_4 | string | varchar(20) | yes | |
| 139 | MEDICATION_6 | string | varchar(20) | yes | |
| 140 | MEDICATION_7 | string | varchar(20) | yes | |
| 141 | MEDICATION_8 | string | varchar(20) | yes | |
| 142 | ADDITIONAL_1 | string | varchar(4000) | yes | |
| 143 | DOSAGE_2 | string | varchar(30) | yes | |
| 144 | DOSAGE_5 | string | varchar(30) | yes | |
| 145 | DOSAGE_6 | string | varchar(30) | yes | |
| 146 | CHECK_NONE_1 | boolean | bit | yes | |
| 147 | CHECK_NONE_2 | boolean | bit | yes | |
| 148 | HELPFUL_1 | string | varchar(1) | yes | |
| 149 | HELPFUL_4 | string | varchar(1) | yes | |
| 150 | HELPFUL_5 | string | varchar(1) | yes | |
| 151 | HELPFUL_7 | string | varchar(1) | yes | |
| 152 | OTHER_CHECK | boolean | bit | yes | |
| 153 | EATING_PROBLEMS | boolean | bit | yes | |
| 154 | CHILD_MEASLES | boolean | bit | yes | |
| 155 | ACTION_TAKEN_UNDERSIGNED_REASON | string | varchar(4000) | yes | |
| 156 | CONDITION_COMMENT_1 | string | varchar(55) | yes | |
| 157 | CONDITION_COMMENT_10 | string | varchar(55) | yes | |
| 158 | CONDITION_COMMENT_20 | string | varchar(55) | yes | |
| 159 | CONDITION_DOCTOR_CARE_2 | string | varchar(3) | yes | |
| 160 | CONDITION_DOCTOR_CARE_9 | string | varchar(3) | yes | |
| 161 | CONDITION_NOW_PAST_1 | string | varchar(4) | yes | |
| 162 | CONDITION_NOW_PAST_10 | string | varchar(4) | yes | |
| 163 | CONDITION_NOW_PAST_17 | string | varchar(4) | yes | |
| 164 | CONDITION_NOW_PAST_18 | string | varchar(4) | yes | |
| 165 | CONDITION_NOW_PAST_20 | string | varchar(4) | yes | |
| 166 | CONDITION_NOW_PAST_5 | string | varchar(4) | yes | |
| 167 | HOSPITAL_3 | string | varchar(40) | yes | |
| 168 | PAIN_REFERRAL | boolean | bit | yes | |
| 169 | PHYSICAL_PHYSICAL_EXAM_DESC | string | varchar(1) | yes | |
| 170 | PRIMARY_CARE_GENERAL_DESC | string | varchar(4000) | yes | |
| 171 | RESPIRATION | string | varchar(30) | yes | |
| 172 | WOMEN_POLYCYSTIC_OVERY_PROVIDER | string | varchar(50) | yes | |
| 173 | WOMEN_PRENATAL_PROVIDER | string | varchar(40) | yes | |
| 174 | PRESCRIBER_2 | string | varchar(30) | yes | |
| 175 | PRESCRIBER_3 | string | varchar(30) | yes | |
| 176 | PURPOSE_6 | string | varchar(20) | yes | |
| 177 | PURPOSE_8 | string | varchar(20) | yes | |
| 178 | ADDITIONAL_2 | string | varchar(4000) | yes | |
| 179 | DOSAGE_3 | string | varchar(30) | yes | |
| 180 | DOSAGE_4 | string | varchar(30) | yes | |
| 181 | DOSAGE_7 | string | varchar(30) | yes | |
| 182 | DOSAGE_8 | string | varchar(30) | yes | |
| 183 | HELPFUL_6 | string | varchar(1) | yes | |
| 184 | HELPFUL_8 | string | varchar(1) | yes | |
| 185 | WEIGHT_LOSS_GAIN | boolean | bit | yes | |
| 186 | CHILD_GERMAN_MEASLES | boolean | bit | yes | |
| 187 | CHILD_OTHER | string | varchar(50) | yes | |
| 188 | CONDITION_COMMENT_6 | string | varchar(55) | yes | |
| 189 | CONDITION_COMMENT_8 | string | varchar(55) | yes | |
| 190 | CONDITION_DOCTOR_CARE_11 | string | varchar(3) | yes | |
| 191 | CONDITION_DOCTOR_CARE_13 | string | varchar(3) | yes | |
| 192 | CONDITION_DOCTOR_CARE_14 | string | varchar(3) | yes | |
| 193 | CONDITION_NOW_PAST_4 | string | varchar(4) | yes | |
| 194 | DATE_1 | datetime | datetime | yes | |
| 195 | HOSPITALIZATION_COMMNETS | string | varchar(4000) | yes | |
| 196 | PAIN_REFERRAL_DESC | string | varchar(4000) | yes | |
| 197 | PAIN_SCREENING | string | varchar(3) | yes | |
| 198 | PRIMARY_CARE_PHYSICIAN | boolean | bit | yes | |
| 199 | REFERRAL | string | varchar(50) | yes | |
| 200 | SPECIALTY_CARE | boolean | bit | yes | |
| 201 | WOMEN_DELIVERY_DATE | datetime | datetime | yes | |
| 202 | PURPOSE_1 | string | varchar(20) | yes | |
| 203 | PURPOSE_3 | string | varchar(20) | yes | |
| 204 | PURPOSE_4 | string | varchar(20) | yes | |
| 205 | MEDICATION_1 | string | varchar(20) | yes | |
| 206 | HELPFUL_2 | string | varchar(1) | yes | |
| 207 | HELPFUL_3 | string | varchar(1) | yes | |
| 208 | CHANGE_APPETITE | boolean | bit | yes | |
| 209 | ALLERGIES_FOOD | string | varchar(4000) | yes | |
| 210 | BMI | string | varchar(30) | yes | |
| 211 | CHILD_CHICKEN_POX | boolean | bit | yes | |
| 212 | CHILD_PRENATAL_EXPOSURE | string | varchar(3) | yes | |
| 213 | CONDITION_COMMENT_2 | string | varchar(55) | yes | |
| 214 | CONDITION_COMMENT_22 | string | varchar(55) | yes | |
| 215 | CONDITION_COMMENT_3 | string | varchar(55) | yes | |
| 216 | CONDITION_COMMENT_4 | string | varchar(55) | yes | |
| 217 | CONDITION_DOCTOR_CARE_10 | string | varchar(3) | yes | |
| 218 | CONDITION_DOCTOR_CARE_16 | string | varchar(3) | yes | |
| 219 | CONDITION_DOCTOR_CARE_4 | string | varchar(3) | yes | |
| 220 | CONDITION_DOCTOR_CARE_6 | string | varchar(3) | yes | |
| 221 | CONDITION_DOCTOR_CARE_8 | string | varchar(3) | yes | |
| 222 | HOSPITAL_1 | string | varchar(40) | yes | |
| 223 | PAIN_ADEQUATELY_CONTROLLED | string | varchar(3) | yes | |
| 224 | PAIN_ASSESSMENT_COMPLETE | string | varchar(4000) | yes | |
| 225 | PAIN_DESCRIPTION_2 | string | varchar(4000) | yes | |
| 226 | PAIN_LOCATION_1 | string | varchar(50) | yes | |
| 227 | PAIN_SITE_2 | string | varchar(50) | yes | |
| 228 | PRIMAY_CARE_PHYSICAN_FOR_PHYSICAL | boolean | bit | yes | |
| 229 | MEDICATION_5 | string | varchar(20) | yes | |
| 230 | DOSAGE_1 | string | varchar(30) | yes | |
| 231 | FOOD_CHECK | boolean | bit | yes | |
| 232 | MEDICINE_CHECK | boolean | bit | yes | |
| 233 | LATEX_CHECK | boolean | bit | yes | |
| 234 | CHILD_OTHER_CHECK | boolean | bit | yes | |
| 235 | HCILD_MEASLES | string | varchar(3) | yes | |
| 236 | NUTRITION_WEIGHT_LOSS | string | varchar(3) | yes | |
| 237 | NUTRITION_CHANGE_IN_APPETITE | string | varchar(3) | yes | |
| 238 | NUTRITION_EXPERIENCING_PROBLEM_EATING | string | varchar(3) | yes |