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 | ABILITY_TO_ABSTRACT | boolean | bit | yes | |
| 3 | ABOVE_AVERAGE | boolean | bit | yes | |
| 4 | ACCELERATED | boolean | bit | yes | |
| 5 | ACTIVITY_COMMENTS | string | varchar(64) | yes | |
| 6 | ACTIVITY_WNL | boolean | bit | yes | |
| 7 | AFFECT_COMMENTS | string | varchar(64) | yes | |
| 8 | AGITATED | boolean | bit | yes | |
| 9 | ANGRY | boolean | bit | yes | |
| 10 | ANXIOUS | boolean | bit | yes | |
| 11 | APPEARANCE_COMMENTS | string | varchar(64) | yes | |
| 12 | APPEARANCE_WNL | boolean | bit | yes | |
| 13 | APPEARS_OLDER_THAN_AGE | boolean | bit | yes | |
| 14 | APPEARS_YOUNGER_THAN_AGE | boolean | bit | yes | |
| 15 | ATTENTION | boolean | bit | yes | |
| 16 | ATTITUDE_TOWARD_PARENT | boolean | bit | yes | |
| 17 | ATYPICAL | boolean | bit | yes | |
| 18 | AUDITORY | boolean | bit | yes | |
| 19 | AVERAGE | boolean | bit | yes | |
| 20 | AVOIDANT | boolean | bit | yes | |
| 21 | BLOCKED | boolean | bit | yes | |
| 22 | BORDERLINE | boolean | bit | yes | |
| 23 | BUILD_COMMENTS | string | varchar(64) | yes | |
| 24 | BUILD_WNL | boolean | bit | yes | |
| 25 | CALCULATION_ABILITY | boolean | bit | yes | |
| 26 | CANNOT_SEPARATE | boolean | bit | yes | |
| 27 | CIRCUMSTANTIAL | boolean | bit | yes | |
| 28 | CLEAR | boolean | bit | yes | |
| 29 | CLINGY_TO_PARENT | boolean | bit | yes | |
| 30 | COGNITION_WNL | boolean | bit | yes | |
| 31 | COMMAND | boolean | bit | yes | |
| 32 | CONCRETE | boolean | bit | yes | |
| 33 | CONFUSED | boolean | bit | yes | |
| 34 | CONSTRICTED | boolean | bit | yes | |
| 35 | CONTROL | boolean | bit | yes | |
| 36 | COOPERATIVE | boolean | bit | yes | |
| 37 | DEFENSIVE | boolean | bit | yes | |
| 38 | DELUSIONS_COMMENTS | string | varchar(64) | yes | |
| 39 | DEMANDING | boolean | bit | yes | |
| 40 | DEPERSONALIZATION | boolean | bit | yes | |
| 41 | DEPRESSED | boolean | bit | yes | |
| 42 | DEPRESSIVE | boolean | bit | yes | |
| 43 | DEREALIZATION | boolean | bit | yes | |
| 44 | DIFFICULTY_ACKNOWLEDGING | boolean | bit | yes | |
| 45 | DISHEVELED | boolean | bit | yes | |
| 46 | DISINHIBITED | boolean | bit | yes | |
| 47 | DISRESPECTFUL | boolean | bit | yes | |
| 48 | ECHOLALIC | boolean | bit | yes | |
| 49 | EROTIC | boolean | bit | yes | |
| 50 | EUPHORIC | boolean | bit | yes | |
| 51 | EURHYMIC | boolean | bit | yes | |
| 52 | EVASIVE | boolean | bit | yes | |
| 53 | EXAMINER_COMMENTS | string | varchar(64) | yes | |
| 54 | EYE_CONTACT_AVERAGE | boolean | bit | yes | |
| 55 | EYE_CONTACT_COMMENTS | string | varchar(64) | yes | |
| 56 | FINDINGS | string | varchar(4000) | yes | |
| 57 | FLAT | boolean | bit | yes | |
| 58 | FLIGHT_OF_IDEAS | boolean | bit | yes | |
| 59 | FUND_OF_KNOWLEDGE | boolean | bit | yes | |
| 60 | GRANDEUR | boolean | bit | yes | |
| 61 | GRANDIOSE | boolean | bit | yes | |
| 62 | GUSTATORY | boolean | bit | yes | |
| 63 | HALLUCINATIONS_COMMENTS | string | varchar(64) | yes | |
| 64 | HOSTILE | boolean | bit | yes | |
| 65 | IGNORES_PARENT | boolean | bit | yes | |
| 66 | ILLUSIONS | boolean | bit | yes | |
| 67 | IMMATURE | boolean | bit | yes | |
| 68 | IMPAIRED_ABILITY | boolean | bit | yes | |
| 69 | IMPULSIVE | boolean | bit | yes | |
| 70 | INAPPROPRIATE | boolean | bit | yes | |
| 71 | INCOHERENT | boolean | bit | yes | |
| 72 | INGRATIATING | boolean | bit | yes | |
| 73 | INSIGHT_WNL | boolean | bit | yes | |
| 74 | INTENSE | boolean | bit | yes | |
| 75 | INTERMITTENT | boolean | bit | yes | |
| 76 | IRRITABLE | boolean | bit | yes | |
| 77 | JUDGMENT_WNL | boolean | bit | yes | |
| 78 | LABILE | boolean | bit | yes | |
| 79 | LACK_OF_SPONTANEITY | boolean | bit | yes | |
| 80 | LOGICAL | boolean | bit | yes | |
| 81 | LOOSE_RACING | boolean | bit | yes | |
| 82 | LOUD | boolean | bit | yes | |
| 83 | MAKE_DECISIONS | string | varchar(8) | yes | |
| 84 | MANIPULATIVE | boolean | bit | yes | |
| 85 | MEMORY | boolean | bit | yes | |
| 86 | MISTRUSTFUL | boolean | bit | yes | |
| 87 | MOOD_COMMENTS | string | varchar(64) | yes | |
| 88 | MOOD_FULL | boolean | bit | yes | |
| 89 | MOSTLY_BLAMES | boolean | bit | yes | |
| 90 | MR | boolean | bit | yes | |
| 91 | NONE_REPORTED | boolean | bit | yes | |
| 92 | OBSESSIONAL | boolean | bit | yes | |
| 93 | OLFACTORY | boolean | bit | yes | |
| 94 | ORIENTATION | boolean | bit | yes | |
| 95 | OVERPRODUCTIVE | boolean | bit | yes | |
| 96 | OVERWEIGHT | boolean | bit | yes | |
| 97 | PARANOID | boolean | bit | yes | |
| 98 | PARENT_COMMENTS | string | varchar(64) | yes | |
| 99 | PARENT_DEMANDING | boolean | bit | yes | |
| 100 | PERCEPTION_WNL | boolean | bit | yes | |
| 101 | PERSECUTION | boolean | bit | yes | |
| 102 | PHOBIC | boolean | bit | yes | |
| 103 | POSITIVE_INTERACTION | boolean | bit | yes | |
| 104 | POSTURE_COMMENTS | string | varchar(64) | yes | |
| 105 | POSTURE_WNL | boolean | bit | yes | |
| 106 | POVERTY_OF_CONTENT | boolean | bit | yes | |
| 107 | PREOCCUPATIONS | boolean | bit | yes | |
| 108 | PRESSURED | boolean | bit | yes | |
| 109 | RAPID | boolean | bit | yes | |
| 110 | READING_AND | boolean | bit | yes | |
| 111 | REEXPERIENCING | boolean | bit | yes | |
| 112 | REFERENCE | boolean | bit | yes | |
| 113 | RELIGIOUS | boolean | bit | yes | |
| 114 | RIGID | boolean | bit | yes | |
| 115 | SEDUCTIVE | boolean | bit | yes | |
| 116 | SELF_DEPRECATORY | boolean | bit | yes | |
| 117 | SEPARATION | boolean | bit | yes | |
| 118 | SEPARATION_ANXIOUS | boolean | bit | yes | |
| 119 | SEPARATION_COMMENTS | string | varchar(64) | yes | |
| 120 | SHORT | boolean | bit | yes | |
| 121 | SILLY | boolean | bit | yes | |
| 122 | SLOWED | boolean | bit | yes | |
| 123 | SLOWED_THINKING | boolean | bit | yes | |
| 124 | SLUMPED | boolean | bit | yes | |
| 125 | SLURRED | boolean | bit | yes | |
| 126 | SOFT | boolean | bit | yes | |
| 127 | SOMATIC | boolean | bit | yes | |
| 128 | SPEECH_COMMENTS | string | varchar(64) | yes | |
| 129 | STEREOTYPED | boolean | bit | yes | |
| 130 | TACTILE | boolean | bit | yes | |
| 131 | TALL | boolean | bit | yes | |
| 132 | TANGENTIAL | boolean | bit | yes | |
| 133 | TENSE | boolean | bit | yes | |
| 134 | THIN | boolean | bit | yes | |
| 135 | THOUGHT_BROADCASTING | boolean | bit | yes | |
| 136 | THOUGHT_CONTENT_COMMENTS | string | varchar(64) | yes | |
| 137 | THOUGHT_CONTENT_WNL | boolean | bit | yes | |
| 138 | THOUGHT_INSERTION | boolean | bit | yes | |
| 139 | THOUGHT_PROCESS_COMMENTS | string | varchar(64) | yes | |
| 140 | THOUGHT_WITHDRAWAL | boolean | bit | yes | |
| 141 | UNDERPRODUCTIVE | boolean | bit | yes | |
| 142 | UNKEMPT | boolean | bit | yes | |
| 143 | UNREMARKABLE_AGE | boolean | bit | yes | |
| 144 | VISUAL | boolean | bit | yes | |
| 145 | VISUOSPATIAL_ABILITY | boolean | bit | yes | |
| 146 | WELL_GROOMED | boolean | bit | yes | |
| 147 | TEST | string | varchar(max) | yes |