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 | ANTICIPATE_FUTURE_DEPLOYMENT_COMM | string | varchar(4000) | yes | |
| 3 | CHILDREN_1 | string | varchar(3) | yes | |
| 4 | CHILDREN_1_COMMENTS | string | varchar(4000) | yes | |
| 5 | CHILDREN_2 | string | varchar(3) | yes | |
| 6 | CHILDREN_3 | string | varchar(3) | yes | |
| 7 | CHILDREN_3_COMMENTS | string | varchar(4000) | yes | |
| 8 | CHILDREN_4 | string | varchar(3) | yes | |
| 9 | CHILDREN_4_COMMENTS | string | varchar(4000) | yes | |
| 10 | CHILDREN_NA | boolean | bit | yes | |
| 11 | CLINICAL_FORMULATION | string | varchar(4000) | yes | |
| 12 | COUPLE_2 | string | varchar(3) | yes | |
| 13 | COUPLE_NA | boolean | bit | yes | |
| 14 | COUPLES_1_COMMENT | string | varchar(4000) | yes | |
| 15 | DO_YOU_ANTICIPATE_FUTURE | string | varchar(3) | yes | |
| 16 | HAVE_YOU_BEEN_TO_VA | string | varchar(3) | yes | |
| 17 | RECEIVE_TREATMENT_FOR_PSYCH | string | varchar(3) | yes | |
| 18 | WHAT_JOB_DO_YOU_HAVE | string | varchar(4000) | yes | |
| 19 | WHEN_DID_YOU_SERVE | string | varchar(100) | yes | |
| 20 | CHALLENGE_COMMENTS | string | varchar(65) | yes | |
| 21 | DEPLOYMENT_PENDING | string | varchar(3) | yes | |
| 22 | FAMILY_TREATMENT | string | varchar(65) | yes | |
| 23 | WHO_HAS_BEEN_IN | string | varchar(100) | yes | |
| 24 | CONCERNS_SERVICE | string | varchar(3) | yes | |
| 25 | FAMILY_RELOCATED_COMM | string | varchar(100) | yes | |
| 26 | MOOD_CHANGES_COMM | string | varchar(100) | yes | |
| 27 | VIOLENCE_COMM | string | varchar(100) | yes | |
| 28 | RENEGOTIATING | string | varchar(3) | yes | |
| 29 | RENEGOTIATING_COMM | string | varchar(100) | yes | |
| 30 | LOVED_INJURED | string | varchar(3) | yes | |
| 31 | LOVE_INJURED_COMM | string | varchar(100) | yes | |
| 32 | KNOW_KILLED | string | varchar(3) | yes | |
| 33 | STORIES_COMM | string | varchar(100) | yes | |
| 34 | KNOWN_TRIGGERS_COMM | string | varchar(100) | yes | |
| 35 | SCREAMING_COMM | string | varchar(100) | yes | |
| 36 | SLEEP_WEAPONS_COMM | string | varchar(100) | yes | |
| 37 | SLEEP_WEAPONS | string | varchar(3) | yes | |
| 38 | COUPLE_2_COMMENTS | string | varchar(4000) | yes | |
| 39 | HAVE_YOU_BEEN_TO_VA_COMMENT | string | varchar(4000) | yes | |
| 40 | FAMILY_RELOCATED | string | varchar(3) | yes | |
| 41 | MOOD_CHANGES | string | varchar(3) | yes | |
| 42 | STORIES | string | varchar(3) | yes | |
| 43 | KNOWN_TRIGGERS | string | varchar(3) | yes | |
| 44 | SCREAMING | string | varchar(3) | yes | |
| 45 | THOUGHTS_DEATH | string | varchar(3) | yes | |
| 46 | CHILDREN_2_COMMENTS | string | varchar(4000) | yes | |
| 47 | CHILDREN_5 | string | varchar(3) | yes | |
| 48 | CHILDREN_5_COMMENTS | string | varchar(4000) | yes | |
| 49 | COUPLE_1 | string | varchar(3) | yes | |
| 50 | COUPLE_3_COMMENTS | string | varchar(4000) | yes | |
| 51 | WHAT_BRANCH_OF_MILITARY | string | varchar(35) | yes | |
| 52 | ANTICIPATED_DATE | datetime | datetime | yes | |
| 53 | DEPLOYMENT_COMMENT | string | varchar(65) | yes | |
| 54 | DEPLOYMENTS_OCCURRED | string | varchar(4000) | yes | |
| 55 | VIOLENCE | string | varchar(3) | yes | |
| 56 | KNOW_KILLED_COMM | string | varchar(100) | yes | |
| 57 | THOUGHTS_DEATH_COMM | string | varchar(100) | yes | |
| 58 | BRANCH_OF_MILITARY_OTHER | string | varchar(40) | yes | |
| 59 | COUPLE_3 | string | varchar(3) | yes | |
| 60 | CHALLENGE_BENEFITS | string | varchar(3) | yes | |
| 61 | CONCERNS_SERVICE_COMMENTS | string | varchar(100) | yes | |
| 62 | IMPACT | string | varchar(3) | yes | |
| 63 | IMPACT_COMMENTS | string | varchar(100) | yes | |
| 64 | FLASH_BACKS | string | varchar(100) | yes | |
| 65 | FLASHBACKS | string | varchar(3) | yes | |
| 66 | ARE_YOU_STILL_ACTIVE | string | varchar(100) | yes | |
| 67 | ARE_YOU_STILL_ACTIVE_COMMENTS | string | varchar(4000) | yes | |
| 68 | ASSESSED_TRAUMATIC_BRAIN_INJURY | string | varchar(3) | yes | |
| 69 | ASSESSED_TRAUMATIC_BRAIN_INJURY_COMMENT | string | varchar(4000) | yes | |
| 70 | AVOID_CLOSE_CONTACT | string | varchar(3) | yes | |
| 71 | AVOID_CLOSE_CONTACT_COMMENT | string | varchar(4000) | yes | |
| 72 | BEEN_IN_A_WAR_ZONE | string | varchar(3) | yes | |
| 73 | COME_UNDER_FIRE | string | varchar(3) | yes | |
| 74 | COMMUNITY_1 | string | varchar(3) | yes | |
| 75 | COMMUNITY_1_COMMENT | string | varchar(4000) | yes | |
| 76 | COMMUNITY_2 | string | varchar(3) | yes | |
| 77 | COMMUNITY_2_COMMENT | string | varchar(4000) | yes | |
| 78 | COMMUNITY_3 | string | varchar(3) | yes | |
| 79 | COMMUNITY_3_COMMENT | string | varchar(4000) | yes | |
| 80 | COMMUNITY_4 | string | varchar(3) | yes | |
| 81 | COMMUNITY_4_COMMENT | string | varchar(4000) | yes | |
| 82 | COMMUNITY_5 | string | varchar(3) | yes | |
| 83 | COMMUNITY_5_COMMENT | string | varchar(4000) | yes | |
| 84 | COMMUNITY_6 | string | varchar(3) | yes | |
| 85 | COMMUNITY_6_COMMENT | string | varchar(4000) | yes | |
| 86 | COMMUNITY_7 | string | varchar(3) | yes | |
| 87 | COMMUNITY_7_COMMENT | string | varchar(4000) | yes | |
| 88 | COMMUNITY_8 | string | varchar(3) | yes | |
| 89 | COMMUNITY_8_COMMENT | string | varchar(4000) | yes | |
| 90 | COMMUNITY_9 | string | varchar(3) | yes | |
| 91 | COMMUNITY_9_COMMENT | string | varchar(4000) | yes | |
| 92 | CONCERNS_THAT_SEEKING_HELP | string | varchar(3) | yes | |
| 93 | CONCERNS_THAT_SEEKING_HELP_COMMENT | string | varchar(4000) | yes | |
| 94 | CONTACTED_YOUR_LOCAL_COUNTY_COMMENT | string | varchar(4000) | yes | |
| 95 | DIFFICULTY_DRIVING | string | varchar(3) | yes | |
| 96 | DIFFICULTY_FALLING_ASLEEP | string | varchar(3) | yes | |
| 97 | DIFFICULTY_MANAGING_TEMPER | string | varchar(3) | yes | |
| 98 | DIFFICULTY_WITH_YOU_BACK | string | varchar(3) | yes | |
| 99 | DISCHARGE_COMMENTS_DATE | string | varchar(4000) | yes | |
| 100 | DRUGS_OR_DRINKING | string | varchar(3) | yes | |
| 101 | EXPERIENCE_A_HOSTAGE | string | varchar(3) | yes | |
| 102 | EXPERIENCE_COMMENTS_2 | string | varchar(4000) | yes | |
| 103 | EXPERIENCE_DIFFICULTY_WITH_CONCENTRATION | string | varchar(3) | yes | |
| 104 | EXPERIENCE_MOOD_CHANGES | string | varchar(3) | yes | |
| 105 | EXPERIENCED_COMMENTS | string | varchar(4000) | yes | |
| 106 | EXPERIENCED_INJURY_FROM_BULLET | string | varchar(3) | yes | |
| 107 | EXPERIENCED_INJURY_RESULTED_FEELING_DAZED | string | varchar(3) | yes | |
| 108 | EXPERIENCED_INJURY_TO_THE_HEAD | string | varchar(3) | yes | |
| 109 | EXPERIENCED_SYMPTOMS_OF_CONCUSSION | string | varchar(3) | yes | |
| 110 | EXPERIENCED_VEHICLE_ACCIDENT | string | varchar(3) | yes | |
| 111 | FEEL_VERY_AFRAIN | string | varchar(3) | yes | |
| 112 | FREQUENT_FEELINGS | string | varchar(3) | yes | |
| 113 | HAVE_YOU_CONTACTED_LOCAL_COUNTY | string | varchar(3) | yes | |
| 114 | IF_DISCHARGED | string | varchar(25) | yes | |
| 115 | LOSE_ANY_FRIENDS | string | varchar(3) | yes | |
| 116 | MILITARY_SECUAL_CHANGES_SEXUAL_FUNCTIONING | string | varchar(3) | yes | |
| 117 | MILITARY_SEXUAL_CHANGES_SEXUAL_FUNCTIONING_COMMENT | string | varchar(4000) | yes | |
| 118 | MILITARY_SEXUAL_COMMENTS | string | varchar(4000) | yes | |
| 119 | MILITARY_SEXUAL_PRESSURE | string | varchar(3) | yes | |
| 120 | MILITARY_SEXUAL_SOMEONE_USING_FORCE | string | varchar(3) | yes | |
| 121 | MILITARY_SEXUAL_UNWANTED_SEXUAL_ATTENTION | string | varchar(3) | yes | |
| 122 | MILITARY_TRAUMA_SCREEN_COMMENTS | string | varchar(4000) | yes | |
| 123 | RECEIVE_TREATMENT_FOR_PSYCH_COMMENT | string | varchar(4000) | yes | |
| 124 | RELIVING_TRAUMATIC_VISION | string | varchar(3) | yes | |
| 125 | SERVE_LEADERSHIP | string | varchar(3) | yes | |
| 126 | SLEEP_WITH_WEAPONS | string | varchar(3) | yes | |
| 127 | SOCIAL_CONTACT | string | varchar(3) | yes | |
| 128 | SOCIAL_CONTRACTS_COMMENTS | string | varchar(4000) | yes | |
| 129 | SOCIAL_CONTRACTS_DISCIPLINED | string | varchar(3) | yes | |
| 130 | SOCIAL_CONTRACTS_ENTITLEMENT | string | varchar(3) | yes | |
| 131 | SOCIAL_CONTRACTS_INFIDELITY | string | varchar(3) | yes | |
| 132 | SOCIAL_CONTRACTS_INPACT_ON_EMPLOYMENT | string | varchar(3) | yes | |
| 133 | SOCIAL_CONTRACTS_LACK_SUFFICIENT | string | varchar(3) | yes | |
| 134 | SOCIAL_CONTRACTS_SHAME | string | varchar(3) | yes | |
| 135 | STARTLE_RESPONSE | string | varchar(3) | yes | |
| 136 | TORTURE_ABUSE | string | varchar(3) | yes | |
| 137 | TRIGGER_FLASHBACKS | string | varchar(3) | yes | |
| 138 | TUNNEL_VISION | string | varchar(3) | yes | |
| 139 | WHERE_DID_YOU_SERVE | string | varchar(100) | yes | |
| 140 | WITNESS_SOMEONE_BEING_INJURED | string | varchar(3) | yes | |
| 141 | YOU_MIGHT_BE_SERIOUSLY_INJURED | string | varchar(3) | yes | |
| 142 | YOU_SERVICE_HONORED | string | varchar(3) | yes | |
| 143 | YOUR_SERVICE_HONORED_COMMENT | string | varchar(4000) | yes |