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 | ADDITIONAL_COMMENT_SPECIFY_PHH | string | varchar(4000) | yes | |
| 3 | ADDITIONAL_COMMENTS | boolean | bit | yes | |
| 4 | BARRIERS | string | varchar(4000) | yes | |
| 5 | COLLATERALS_INTERVIEWED | string | varchar(4000) | yes | |
| 6 | COMMENT_FAMILY_RELATIONSHIPS | string | varchar(4000) | yes | |
| 7 | COMMUNITY_SUPPORTS | string | varchar(4000) | yes | |
| 8 | COMMUNITY_VIOLENCE | string | varchar(3) | yes | |
| 9 | CULTURAL_ETHNIC_INFORMATION | string | varchar(4000) | yes | |
| 10 | CUSTODY_ARRANGEMENT | string | varchar(4000) | yes | |
| 11 | DATED_PHYSICAL_HEALTH_HISTORY | datetime | datetime | yes | |
| 12 | DEVELOPMENTAL_HISTORY | string | varchar(4000) | yes | |
| 13 | DOMESTIC_VIOLENCE | string | varchar(3) | yes | |
| 14 | ELDER_ABUSE | string | varchar(3) | yes | |
| 15 | EVIDENCED_BASED | string | varchar(3) | yes | |
| 16 | FAMILY_GUARDIAN | string | varchar(4000) | yes | |
| 17 | FAMILY_HISTORY | string | varchar(4000) | yes | |
| 18 | FRIENDSHIPS | string | varchar(4000) | yes | |
| 19 | HISTORY_PRESENT_ILLNESS | string | varchar(4000) | yes | |
| 20 | HOUSEHOLD_COMPOSITION | string | varchar(4000) | yes | |
| 21 | IMMIGRATION_TRAUMA | string | varchar(3) | yes | |
| 22 | INTERPRETIVE_SUMMARY | string | varchar(4000) | yes | |
| 23 | LIFE_GOALS | string | varchar(4000) | yes | |
| 24 | MEANINGFUL_ACTIVITIES | string | varchar(4000) | yes | |
| 25 | NA_CUSTORY_ISSUES | boolean | bit | yes | |
| 26 | OTHER_ABUSE | string | varchar(50) | yes | |
| 27 | PAST_AND_PRESENT | string | varchar(4000) | yes | |
| 28 | PAST_PSYCHIATRIC_HISTORY | string | varchar(4000) | yes | |
| 29 | PHYSICAL_ABUSE | string | varchar(3) | yes | |
| 30 | REASON_REFERRAL | string | varchar(4000) | yes | |
| 31 | REFER_BRIEF_MED | boolean | bit | yes | |
| 32 | RELEVENT_DETAILS_CURRENT_CLINICAL_IMPACT | string | varchar(4000) | yes | |
| 33 | RELIGION_SPIRITUALITY | string | varchar(4000) | yes | |
| 34 | SERVICE_PREFERENCES | string | varchar(4000) | yes | |
| 35 | SEXUAL_ABUSE | string | varchar(3) | yes | |
| 36 | SEXUAL_HISTORY_CONCERNS | string | varchar(4000) | yes | |
| 37 | SEXUAL_HISTORY_NA | boolean | bit | yes | |
| 38 | SPECIFY | string | varchar(4000) | yes | |
| 39 | STRENGTHS | string | varchar(4000) | yes | |
| 40 | SUBSTANCE_ALCOHOL | boolean | bit | yes | |
| 41 | SUBSTANCE_GAMBLING | boolean | bit | yes | |
| 42 | SUBSTANCE_ILLEGAL_DRUG | boolean | bit | yes | |
| 43 | SUBSTANCE_NON_PRESCRIPTION | boolean | bit | yes | |
| 44 | SUBSTANCE_NONE_REPORTED | boolean | bit | yes | |
| 45 | SUBSTANCE_PRESCRIPTION_DRUG | boolean | bit | yes | |
| 46 | SUBSTANCE_TOBACCO | boolean | bit | yes | |
| 47 | TRAUMA_HIST_NONE_REPORTED | boolean | bit | yes | |
| 48 | VERBAL_ABUSE | string | varchar(3) | yes | |
| 49 | WITNESS_TO_VIOLENCE | string | varchar(3) | yes | |
| 50 | COMPREHENSIVE_ASSESSMENT_COMPLETE_YES_NO | string | varchar(3) | yes | |
| 51 | DATE_MOST_RECENT_ASSESSMENT | datetime | datetime | yes | |
| 52 | INDIVIDUAL_PRESENT_YES_NO | string | varchar(3) | yes | |
| 53 | OTHERS_PRESENT_SPECIFY | string | varchar(500) | yes | |
| 54 | PAST_PSYCHIATRIC_HISTORY_YES_NO | string | varchar(3) | yes | |
| 55 | PMP_CONFIDENTIAL_DRUG_USER_REPORT_REVIEWED | boolean | bit | yes | |
| 56 | REFER_COMMUNICABLE_DISEASE_ASSESSMENT | boolean | bit | yes | |
| 57 | SUBSTANCE_USE_DESCRIPTION | string | varchar(4000) | yes | |
| 58 | COMMENT_ON_DAILY_LIVING | string | varchar(4000) | yes | |
| 59 | OTHER_FUNCTIONAL_IMPAIRMENTS | string | varchar(4000) | yes | |
| 60 | SMOKING_STATUS | string | varchar(30) | yes | |
| 61 | LIVING_SITUATION_DESCRIBE_PAST_SITUATIONS | string | varchar(max) | yes |