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_COMMENTS_1 | string | varchar(4000) | yes | |
| 3 | ADDITIONAL_COMMENTS_2 | string | varchar(4000) | yes | |
| 4 | ADDITIONAL_COMMENTS_3 | string | varchar(4000) | yes | |
| 5 | ADDRESS_1 | string | varchar(80) | yes | |
| 6 | ADDRESS_2 | string | varchar(80) | yes | |
| 7 | ADDRESS_3 | string | varchar(80) | yes | |
| 8 | APT_1 | string | varchar(5) | yes | |
| 9 | APT_2 | string | varchar(5) | yes | |
| 10 | APT_3 | string | varchar(5) | yes | |
| 11 | CHANGE_OF_INFORMATION | boolean | bit | yes | |
| 12 | CITY_1 | string | varchar(30) | yes | |
| 13 | CITY_2 | string | varchar(30) | yes | |
| 14 | CITY_3 | string | varchar(30) | yes | |
| 15 | CONSENT_COMPLETED_1 | string | varchar(3) | yes | |
| 16 | CONSENT_COMPLETED_2 | string | varchar(3) | yes | |
| 17 | CONSENT_COMPLETED_3 | string | varchar(3) | yes | |
| 18 | EMERGENCY_CONTACE | string | varchar(60) | yes | |
| 19 | EMERGENCY_RELATIONSHIP | string | varchar(30) | yes | |
| 20 | EMERGENCY_TELEPHONE | string | varchar(14) | yes | |
| 21 | INDIV_LIVING_ADDRESS_1 | string | varchar(55) | yes | |
| 22 | INDIV_LIVING_APT | string | varchar(5) | yes | |
| 23 | INDIV_LIVING_CITY | string | varchar(35) | yes | |
| 24 | INDIV_LIVING_COUNTY | string | varchar(35) | yes | |
| 25 | INDIV_LIVING_STATE | string | varchar(2) | yes | |
| 26 | INDIV_MAILING_ADDRESS_1 | string | varchar(55) | yes | |
| 27 | INDIV_MAILING_APT | string | varchar(5) | yes | |
| 28 | INDIV_MAILING_CITY | string | varchar(35) | yes | |
| 29 | INDIV_MAILING_COUNTY | string | varchar(35) | yes | |
| 30 | INDIV_MAILING_STATE | string | varchar(2) | yes | |
| 31 | INDIVIDUAL_IS_HOMELESS | boolean | bit | yes | |
| 32 | INIDV_LIVING_ZIP | string | varchar(10) | yes | |
| 33 | INIDV_MAILING_ZIP | string | varchar(10) | yes | |
| 34 | LAST_4_SSN | integer | smallint | yes | |
| 35 | MARITAL_STATUS | string | varchar(20) | yes | |
| 36 | NEW_INFORMATION | boolean | bit | yes | |
| 37 | OK_LEAVE_MESSAGE_1 | string | varchar(3) | yes | |
| 38 | OK_LEAVE_MESSAGE_2 | string | varchar(3) | yes | |
| 39 | PERSON_NAME_1 | string | varchar(60) | yes | |
| 40 | PERSON_NAME_2 | string | varchar(60) | yes | |
| 41 | PERSON_NAME_3 | string | varchar(60) | yes | |
| 42 | PRIMARY_TELEPHONE | string | varchar(14) | yes | |
| 43 | PRIMARY_TELEPHONE_1 | string | varchar(14) | yes | |
| 44 | PRIMARY_TELEPHONE_2 | string | varchar(14) | yes | |
| 45 | PRIMARY_TELEPHONE_3 | string | varchar(14) | yes | |
| 46 | RELATIONSHIP_1 | string | varchar(30) | yes | |
| 47 | RELATIONSHIP_2 | string | varchar(30) | yes | |
| 48 | RELATIONSHIP_3 | string | varchar(30) | yes | |
| 49 | SECONDARY_TELEPHONE | string | varchar(14) | yes | |
| 50 | SECONDARY_TELEPHONE_1 | string | varchar(14) | yes | |
| 51 | SECONDARY_TELEPHONE_2 | string | varchar(14) | yes | |
| 52 | SECONDARY_TELEPHONE_3 | string | varchar(14) | yes | |
| 53 | STATE_1 | string | varchar(2) | yes | |
| 54 | STATE_2 | string | varchar(2) | yes | |
| 55 | STATE_3 | string | varchar(2) | yes | |
| 56 | ZIP_1 | string | varchar(10) | yes | |
| 57 | ZIP_2 | string | varchar(10) | yes | |
| 58 | ZIP_3 | string | varchar(10) | yes | |
| 59 | ACTIVE_CASE_CHILD_PROTECTIVE | string | varchar(3) | yes | |
| 60 | ALASKA_NATIVE | string | varchar(3) | yes | |
| 61 | AMERICAN_INDIAN | string | varchar(3) | yes | |
| 62 | ARABIC | string | varchar(3) | yes | |
| 63 | ARABIC_2 | string | varchar(3) | yes | |
| 64 | ASIAN | string | varchar(3) | yes | |
| 65 | ASSIGNED_WORKER_NAME | string | varchar(50) | yes | |
| 66 | BLACK_ | string | varchar(3) | yes | |
| 67 | CALL_OR_WALK_IN | string | varchar(7) | yes | |
| 68 | CHINESE | string | varchar(3) | yes | |
| 69 | CHINESE_2 | string | varchar(3) | yes | |
| 70 | CJ_CONSENT_DATE | datetime | datetime | yes | |
| 71 | CJ_CONSENT_REVOKE_DATE | datetime | datetime | yes | |
| 72 | COMPLETED_BY | string | varchar(100) | yes | |
| 73 | COMPLETED_BY_DATE | datetime | datetime | yes | |
| 74 | DANGEROUS_SITUATION | string | varchar(3) | yes | |
| 75 | DETERMINATION_NOT_APPLICABLE | boolean | bit | yes | |
| 76 | ENGLISH | string | varchar(3) | yes | |
| 77 | ENGLISH_2 | string | varchar(3) | yes | |
| 78 | FRENCH | string | varchar(3) | yes | |
| 79 | FRENCH_2 | string | varchar(3) | yes | |
| 80 | GREEK | string | varchar(3) | yes | |
| 81 | GREEK_2 | string | varchar(3) | yes | |
| 82 | HAWAIIAN | string | varchar(3) | yes | |
| 83 | HINDI | string | varchar(3) | yes | |
| 84 | HINDI_2 | string | varchar(3) | yes | |
| 85 | HISPANIC_ORIGIN | string | varchar(25) | yes | |
| 86 | INDIV_RECEIVED_SERVICES_HERE | string | varchar(3) | yes | |
| 87 | INIDV_RECEIVED_SERVICES_WHEN | string | varchar(100) | yes | |
| 88 | INTAKE_AM_PM | string | varchar(2) | yes | |
| 89 | INTAKE_DATE | datetime | datetime | yes | |
| 90 | INTAKE_TIME | string | varchar(5) | yes | |
| 91 | JAPANESE | string | varchar(3) | yes | |
| 92 | JAPANESE_2 | string | varchar(3) | yes | |
| 93 | KNOWN_AS | string | varchar(50) | yes | |
| 94 | LAST_NAME_BIRTH_2_LETTERS | string | varchar(2) | yes | |
| 95 | LAST_NAME_CURRENT_2_LETTERS | string | varchar(2) | yes | |
| 96 | MOTHER_FIRST_NAME | string | varchar(30) | yes | |
| 97 | MOTHER_MAIDEN_NAME | string | varchar(30) | yes | |
| 98 | NAME_NUMBER_LEGAL_GUARDIAN | string | varchar(100) | yes | |
| 99 | NYSID | string | varchar(11) | yes | |
| 100 | OTHER_PREFERRED_LANGUAGE | string | varchar(30) | yes | |
| 101 | OTHER_PRIMARY_LANGUAGE | string | varchar(30) | yes | |
| 102 | OTHER_RACE | string | varchar(30) | yes | |
| 103 | OTHER_REFERRAL_SOURCE_NAME | string | varchar(65) | yes | |
| 104 | PHONE_NUMBER_CALLING_FROM | string | varchar(14) | yes | |
| 105 | PORTUGUESE | string | varchar(3) | yes | |
| 106 | PORTUGUESE_2 | string | varchar(3) | yes | |
| 107 | PROGRAM_ASSIGNED_INTAKE | string | varchar(3) | yes | |
| 108 | PROGRAM_ASSIGNED_INTAKE_SPECIFY | string | varchar(75) | yes | |
| 109 | PROGRAM_NUMBER | string | varchar(15) | yes | |
| 110 | PROVIDER_CLIENT_ID | string | varchar(15) | yes | |
| 111 | PROVIDER_NUMBER | string | varchar(15) | yes | |
| 112 | RACE_COMMENTS | string | varchar(4000) | yes | |
| 113 | REASON_FOR_REFERRAL | string | varchar(500) | yes | |
| 114 | REFERRAL_SOURCE | string | varchar(5) | yes | |
| 115 | REFERRED_OUTSIDE_AGENCY | string | varchar(3) | yes | |
| 116 | REFERRED_OUTSIDE_REASON | string | varchar(4000) | yes | |
| 117 | REFERRED_OUTSIDE_TO | string | varchar(75) | yes | |
| 118 | RUSSIAN | string | varchar(3) | yes | |
| 119 | RUSSIAN_2 | string | varchar(3) | yes | |
| 120 | SIGN_LANGUAGE | string | varchar(3) | yes | |
| 121 | SIGN_LANGUAGE_2 | string | varchar(3) | yes | |
| 122 | SIGNIFICANT_OTHER_SEEKING_TREATMENT_ | string | varchar(3) | yes | |
| 123 | SIGNIFICANT_OTHER_SEEKING_TREATMENT_DESCRIBE | string | varchar(500) | yes | |
| 124 | SPANISH | string | varchar(3) | yes | |
| 125 | SPANISH_2 | string | varchar(3) | yes | |
| 126 | SPECIAL_NEEDS_ASSISTIVE_LISTENING_DEVICE | string | varchar(3) | yes | |
| 127 | SPECIAL_NEEDS_LANGUATE_INTERPRETER | string | varchar(3) | yes | |
| 128 | SPECIAL_NEEDS_LITERACY_SKILLS | string | varchar(3) | yes | |
| 129 | SPECIAL_NEEDS_MEDICAID_TRANSPORTATION | string | varchar(3) | yes | |
| 130 | SPECIAL_NEEDS_NONE_REPORTED | boolean | bit | yes | |
| 131 | SPECIAL_NEEDS_OTHER | string | varchar(50) | yes | |
| 132 | SPECIAL_NEEDS_SIGN_LANGUAGE_INTERPRETER | string | varchar(3) | yes | |
| 133 | SPECIAL_NEEDS_TDD_TTY_DEVICE | string | varchar(3) | yes | |
| 134 | SPECIAL_NEEDS_WHEEL_CHAIR | string | varchar(3) | yes | |
| 135 | SPECIAL_PROJECT | string | varchar(100) | yes | |
| 136 | TOTAL_NUMBER_CHILDREN | integer | int | yes | |
| 137 | TOTAL_NUMBER_CHILDREN_FOSTER_CARE | integer | int | yes | |
| 138 | TOTAL_NUMBER_CHILDREN_LIVING_WITH_INDIV | integer | int | yes | |
| 139 | UNKNOWN_PRIMARY_LANGUAGE | string | varchar(30) | yes | |
| 140 | VETERAN_STATUS | string | varchar(3) | yes | |
| 141 | WHITE | string | varchar(3) | yes | |
| 142 | WHY_SEEKING_SERVICE | string | varchar(4000) | yes |