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 | WELL_GROOMED | boolean | bit | yes | |
| 3 | DISHEVELED | boolean | bit | yes | |
| 4 | BIZARRE | boolean | bit | yes | |
| 5 | INAPPROPRIATE | boolean | bit | yes | |
| 6 | COOPERATIVE | boolean | bit | yes | |
| 7 | GUARDED | boolean | bit | yes | |
| 8 | SUSPICIOUS | boolean | bit | yes | |
| 9 | UNCOOPERATIVE | boolean | bit | yes | |
| 10 | BILIGERENT | boolean | bit | yes | |
| 11 | CALM | boolean | bit | yes | |
| 12 | LETHARGIC | boolean | bit | yes | |
| 13 | HYPERACTIVE | boolean | bit | yes | |
| 14 | AGITATED | boolean | bit | yes | |
| 15 | TREMORS_TICS | boolean | bit | yes | |
| 16 | MUSCLE_SPASM | boolean | bit | yes | |
| 17 | APPROPRIATE | boolean | bit | yes | |
| 18 | LABILE | boolean | bit | yes | |
| 19 | EXPANSIVE | boolean | bit | yes | |
| 20 | CONSTRICTED | boolean | bit | yes | |
| 21 | BLUNTED | boolean | bit | yes | |
| 22 | FLAT | boolean | bit | yes | |
| 23 | EUTHYMIC | boolean | bit | yes | |
| 24 | DEPRESSED | boolean | bit | yes | |
| 25 | ANXIOUS | boolean | bit | yes | |
| 26 | EUPHORIC | boolean | bit | yes | |
| 27 | NORMAL | boolean | bit | yes | |
| 28 | DELAYED | boolean | bit | yes | |
| 29 | SOFT | boolean | bit | yes | |
| 30 | LOUD | boolean | bit | yes | |
| 31 | EXCESSIVE | boolean | bit | yes | |
| 32 | PRESSURED | boolean | bit | yes | |
| 33 | SLURRED | boolean | bit | yes | |
| 34 | PERSEVERATING | boolean | bit | yes | |
| 35 | INCOHERENT | boolean | bit | yes | |
| 36 | INTACT | boolean | bit | yes | |
| 37 | CIRCUMSTANTIAL | boolean | bit | yes | |
| 38 | LOOSENING_OF_ASSOCIATIONS | boolean | bit | yes | |
| 39 | TANGENTIAL | boolean | bit | yes | |
| 40 | FLIGHT_OF_IDEAS | boolean | bit | yes | |
| 41 | THOUGHT_CONTENT_APPROPRIATE | boolean | bit | yes | |
| 42 | OBESESSIONS | boolean | bit | yes | |
| 43 | COMPULSIONS | boolean | bit | yes | |
| 44 | PHOBIAS | boolean | bit | yes | |
| 45 | HALLUCINATIONS | boolean | bit | yes | |
| 46 | HALLUCINATION_NOT_PRESENT | boolean | bit | yes | |
| 47 | HALLUCINATIONS_AUDITORY | boolean | bit | yes | |
| 48 | HALLUCINATIONS_VISUAL | boolean | bit | yes | |
| 49 | HALLUCINATIONS_OLFACTORY | boolean | bit | yes | |
| 50 | DELUSIONS_NOT_PRESENT | boolean | bit | yes | |
| 51 | DELUSTIONS_PERSECUTORY | boolean | bit | yes | |
| 52 | DELUSTIONS_BEING_CONTROLLED | boolean | bit | yes | |
| 53 | DELUSIONS_GRANDIOSE | boolean | bit | yes | |
| 54 | DELUSIONS_THOUGHT_INSERTION | boolean | bit | yes | |
| 55 | DELUSTOINS_BIZARRE | boolean | bit | yes | |
| 56 | NO_IMPAIRMENT | boolean | bit | yes | |
| 57 | DEPERSONALIZATION | boolean | bit | yes | |
| 58 | DEREALIZATION | boolean | bit | yes | |
| 59 | ORIENTED | boolean | bit | yes | |
| 60 | PERSON | boolean | bit | yes | |
| 61 | PLACE | boolean | bit | yes | |
| 62 | TIME | boolean | bit | yes | |
| 63 | DISORIENTED | boolean | bit | yes | |
| 64 | DISORIENTED_PERSON | boolean | bit | yes | |
| 65 | DISORIENTED_PLACE | boolean | bit | yes | |
| 66 | DISORIENTED_TIME | boolean | bit | yes | |
| 67 | DISORIENTED_ALWAYS | boolean | bit | yes | |
| 68 | DISORIENTED_SOMETIMES | boolean | bit | yes | |
| 69 | MEMORY_INTACT | boolean | bit | yes | |
| 70 | MEMORY_IMPAIRED | boolean | bit | yes | |
| 71 | MEMORY_IMMEDIATE | boolean | bit | yes | |
| 72 | MEMORY_RECENT | boolean | bit | yes | |
| 73 | MEMORY_REMOTE | boolean | bit | yes | |
| 74 | AMNESIA_PARTIAL | boolean | bit | yes | |
| 75 | AMNESIA_GLOBAL | boolean | bit | yes | |
| 76 | GENERAL_KNOWLEDGE | string | varchar(3) | yes | |
| 77 | SIMPLE_CALCULATIONS | string | varchar(3) | yes | |
| 78 | JUDGMENT_INTACT | boolean | bit | yes | |
| 79 | JUDGMENT_IMPAIRED | boolean | bit | yes | |
| 80 | JUDGMENT_MINIMAL | boolean | bit | yes | |
| 81 | JUDGMENT_MODERATE | boolean | bit | yes | |
| 82 | JUDGMENT_SEVERE | boolean | bit | yes | |
| 83 | INSIGHT_INTACT | boolean | bit | yes | |
| 84 | INSIGHT_IMPAIRED | boolean | bit | yes | |
| 85 | INSIGHT_MINIMAL | boolean | bit | yes | |
| 86 | IMPAIRED_MODERATE | boolean | bit | yes | |
| 87 | IMPAIRED_SEVERE | boolean | bit | yes | |
| 88 | RELATIONSHIP_COOPERATIVE | boolean | bit | yes | |
| 89 | RELATIONSHIP_AGGRESSIVE | boolean | bit | yes | |
| 90 | RELATIONSHIP_COMPLIANT | boolean | bit | yes | |
| 91 | RELATIONSHIP_SUSPICIOUS | boolean | bit | yes | |
| 92 | RELATIONSHIP_UNCOOPERATIVE | boolean | bit | yes | |
| 93 | DELUSIONS | boolean | bit | yes | |
| 94 | DISORIENTED_2 | boolean | bit | yes | |
| 95 | AXIS1_1 | string | varchar(50) | yes | |
| 96 | AXIS1_2 | string | varchar(50) | yes | |
| 97 | AXIS1_3 | string | varchar(50) | yes | |
| 98 | AXIS2 | string | varchar(20) | yes | |
| 99 | AXIS3 | string | varchar(max) | yes | |
| 100 | AXIS4 | string | varchar(max) | yes | |
| 101 | AXIS5 | string | varchar(10) | yes | |
| 102 | HIGHEST_RATING_LAST_YEAR | string | varchar(10) | yes | |
| 103 | HAD_PSYCHOLOGICAL_TESTING | string | varchar(3) | yes | |
| 104 | DESCRIBE_TESTING | string | varchar(max) | yes | |
| 105 | NOT_ACCEPT_TO_TREATMENT | boolean | bit | yes | |
| 106 | NEED_OTHER_LEVEL_CARE | boolean | bit | yes | |
| 107 | REFERRAL_TO_ANOTHER_FACILITY | string | varchar(3) | yes | |
| 108 | NAME_OF_FACILITY | string | varchar(60) | yes | |
| 109 | TYPE_OF_PROGRAM | string | varchar(60) | yes | |
| 110 | NOT_ACCEPTED_COMMENT | string | varchar(max) | yes | |
| 111 | DIFFERENT_FACILITY_COMMENT | string | varchar(50) | yes | |
| 112 | REFUSED_FURTHER_TREATMENT | string | varchar(3) | yes | |
| 113 | ACCEPTED_TO_TREATMENT | boolean | bit | yes | |
| 114 | DATE_OF_ADMISSION | datetime | datetime | yes | |
| 115 | VOLUNTARY_PARTICIPATION | string | varchar(3) | yes | |
| 116 | PROGRAM_RULES_PROVIDED | string | varchar(3) | yes | |
| 117 | RELEASE_OF_INFORMATION | string | varchar(3) | yes | |
| 118 | HEALTH_HISTORY_FORM | string | varchar(3) | yes | |
| 119 | URINE_SCREEN_REQUEST | string | varchar(3) | yes | |
| 120 | RELAPSE_PREVENTION_PLAN | string | varchar(3) | yes | |
| 121 | PSYCHIATRIC_ASSESSMENT_NEEDED | string | varchar(3) | yes | |
| 122 | PSYCHIATRIC_ASSESSMENT_DATE | datetime | datetime | yes | |
| 123 | PSYCHIATRIC_ASSSESSMENT_NAME | string | varchar(50) | yes | |
| 124 | MEDICAL_ASSESSMENT_NEEDED | string | varchar(3) | yes | |
| 125 | MEDICAL_ASSESSMENT_DATE | datetime | datetime | yes | |
| 126 | MEDICAL_ASSESSMENT_NAME | string | varchar(50) | yes | |
| 127 | PHYSICAL_EXAM | string | varchar(3) | yes | |
| 128 | DETOXIFICATION_PLAN | string | varchar(3) | yes | |
| 129 | TWELVE_STEP | string | varchar(3) | yes | |
| 130 | TWELVE_STEP_TXT | string | varchar(30) | yes | |
| 131 | TWELVE_STEP_OTHER | string | varchar(30) | yes | |
| 132 | MEETING_LIST_PROVIDED | boolean | bit | yes | |
| 133 | REFERRAL_NEEDED | string | varchar(3) | yes | |
| 134 | VOC_ED | boolean | bit | yes | |
| 135 | SOCIAL_SERVICES | boolean | bit | yes | |
| 136 | CPS | boolean | bit | yes | |
| 137 | EAC | boolean | bit | yes | |
| 138 | OTHER_REFERRAL | boolean | bit | yes | |
| 139 | NO_URINE_TEST_EXPLAIN | string | varchar(70) | yes | |
| 140 | REFERRAL_OTHER_TXT | string | varchar(60) | yes | |
| 141 | FAMILY_TREATMENT | boolean | bit | yes | |
| 142 | AL_ANON_NAR_ANON | string | varchar(3) | yes | |
| 143 | AL_ANON_NAR_ANON_TXT | string | varchar(15) | yes | |
| 144 | AL_ANON_NAR_ANON_OTHER | string | varchar(40) | yes | |
| 145 | AL_ANON_NAR_ANON_MEETING_LIST | boolean | bit | yes | |
| 146 | STABLE_HOME | string | varchar(3) | yes | |
| 147 | UNSUPPORTIVE_BUT_IMPROVE | string | varchar(3) | yes | |
| 148 | NOT_SUPPORTED | string | varchar(3) | yes | |
| 149 | REDUCTION_IN_SYMPTOMS | boolean | bit | yes | |
| 150 | TRANSFER_SELF_HELP | boolean | bit | yes | |
| 151 | REFER_SUPPORTIVE_COUNSEL | boolean | bit | yes | |
| 152 | REFER_MEDICATION_MANAGEMENT | boolean | bit | yes | |
| 153 | MAINTAIN_VOC_ED_GOALS | boolean | bit | yes | |
| 154 | OUTCOME_OTHER | boolean | bit | yes | |
| 155 | OUTCOME_OTHER_TXT | string | varchar(80) | yes | |
| 156 | BELLMORE_CLINIC | boolean | bit | yes | |
| 157 | WOODMERE_CLINIC | boolean | bit | yes | |
| 158 | SYOSSET | boolean | bit | yes | |
| 159 | DATE1 | string | varchar(15) | yes | |
| 160 | DATE2 | string | varchar(15) | yes | |
| 161 | DATE3 | string | varchar(15) | yes | |
| 162 | DATE4 | string | varchar(15) | yes | |
| 163 | THERAPIST1 | string | varchar(37) | yes | |
| 164 | THERAPIST2 | string | varchar(37) | yes | |
| 165 | THERAPIST3 | string | varchar(37) | yes | |
| 166 | THERAPIST4 | string | varchar(35) | yes | |
| 167 | INDIVIDUAL_COUNSELING | boolean | bit | yes | |
| 168 | ERG | boolean | bit | yes | |
| 169 | RTG | boolean | bit | yes | |
| 170 | GROUP_CHECK | boolean | bit | yes | |
| 171 | FIP | boolean | bit | yes | |
| 172 | FAMILY_COUNSELING | boolean | bit | yes | |
| 173 | PATIENT_AGREES | string | varchar(3) | yes | |
| 174 | DESC1 | string | varchar(75) | yes | |
| 175 | DESC2 | string | varchar(75) | yes | |
| 176 | DESC3 | string | varchar(75) | yes | |
| 177 | DESC4 | string | varchar(75) | yes | |
| 178 | AXIS1_1_CODE | string | varchar(8) | yes | |
| 179 | AXIS1_2_CODE | string | varchar(8) | yes | |
| 180 | AXIS1_3_CODE | string | varchar(8) | yes | |
| 181 | AXIS2_1_CODE | string | varchar(8) | yes | |
| 182 | LEVEL_OF_CARE | boolean | bit | yes | |
| 183 | CLIENT_ADMISSION_REPORT | boolean | bit | yes | |
| 184 | AXIS_1_TEXT_1 | string | varchar(35) | yes | |
| 185 | AXIS_1_TEXT_2 | string | varchar(35) | yes | |
| 186 | AXIS_1_TEXT_3 | string | varchar(35) | yes | |
| 187 | AXIS_2_TEXT | string | varchar(35) | yes | |
| 188 | SUICIDAL_IDEATION | string | varchar(3) | yes | |
| 189 | CURRENT_STATUS | string | varchar(3) | yes | |
| 190 | CURRENT_STATUS_EXPLAIN | string | varchar(max) | yes | |
| 191 | PAST_HISTORY_EXPLAIN | string | varchar(max) | yes | |
| 192 | PAST_HISTORY | string | varchar(3) | yes | |
| 193 | IC_THERAPIST | string | varchar(50) | yes | |
| 194 | GROUP_DROPDOWN1 | string | varchar(50) | yes | |
| 195 | GROUP_DROPDOWN2 | string | varchar(50) | yes | |
| 196 | GROUP_DROPDOWN3 | string | varchar(50) | yes | |
| 197 | GROUP_DROPDOWN4 | string | varchar(50) | yes | |
| 198 | IC_PER_WEEK | string | varchar(2) | yes | |
| 199 | FAMILY_GROUP1 | string | varchar(50) | yes | |
| 200 | FAMILY_GROUP2 | string | varchar(50) | yes | |
| 201 | FAMILY_PER_WEEK1 | string | varchar(2) | yes | |
| 202 | FAMILY_PER_WEEK2 | string | varchar(2) | yes | |
| 203 | PSYCH_MGT | string | varchar(40) | yes | |
| 204 | DRUG_SCREENING | string | varchar(40) | yes | |
| 205 | OTHER_SERVICES | string | varchar(40) | yes | |
| 206 | AGENCY_REFERRAL | string | varchar(45) | yes | |
| 207 | SUPERVISED_DETOX | string | varchar(45) | yes | |
| 208 | OUTSIDE_AGENCY_REFERRAL | string | varchar(45) | yes | |
| 209 | MED_SUPERVISE_DETOX | string | varchar(45) | yes | |
| 210 | ACCEPTED_REFERRAL | string | varchar(100) | yes | |
| 211 | CASE_MANAGEMENT | string | varchar(100) | yes | |
| 212 | OTHER_TX_SERVICES | string | varchar(100) | yes | |
| 213 | TX_SERVICES_PROVIDED | string | varchar(500) | yes | |
| 214 | PREVENTION | string | varchar(3) | yes | |
| 215 | CC | string | varchar(3) | yes | |
| 216 | PREVENTION_TEXT | string | varchar(200) | yes | |
| 217 | CC_TEXT | string | varchar(200) | yes |