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 | ACQUIRED_TBI_2024 | string | varchar(3) | yes | |
| 3 | ADMISSION_DATE | datetime | datetime | yes | |
| 4 | ALTERNATIVE_TO_INCARCERATION | string | varchar(3) | yes | |
| 5 | ASIAN_ORIGIN_2024 | string | varchar(26) | yes | |
| 6 | ASTHMA | string | varchar(7) | yes | |
| 7 | BIRTH_DATE | datetime | datetime | yes | |
| 8 | CHILD_PROTECTIVE_SVCS | string | varchar(3) | yes | |
| 9 | COA_COSA_2024 | string | varchar(62) | yes | |
| 10 | COEXISTING_PSYCH_DISORDER | string | varchar(3) | yes | |
| 11 | COUNTY_OF_RESIDENCE | string | varchar(30) | yes | |
| 12 | CRIMINAL_JUSTICE_CODE | string | varchar(max) | yes | |
| 13 | DAYS_HOSPITALIZED_NONDETOX | string | varchar(3) | yes | |
| 14 | DAYS_INCARCERATED_6_MONTH | string | varchar(3) | yes | |
| 15 | DAYS_INPATIENT_DETOX | string | varchar(3) | yes | |
| 16 | DIABETES | string | varchar(7) | yes | |
| 17 | ELEMENT_OF_CARE | string | varchar(15) | yes | |
| 18 | EMPLOYMENT_STATUS_2024 | string | varchar(35) | yes | |
| 19 | EVER_USED_TOBACCO | string | varchar(3) | yes | |
| 20 | EXPERIENCED_TRAUMA | string | varchar(17) | yes | |
| 21 | F10 | boolean | bit | yes | |
| 22 | F10_SUFFIX | string | varchar(3) | yes | |
| 23 | F11 | boolean | bit | yes | |
| 24 | F11_SUFFIX | string | varchar(3) | yes | |
| 25 | F12 | boolean | bit | yes | |
| 26 | F12_SUFFIX | string | varchar(3) | yes | |
| 27 | F13 | boolean | bit | yes | |
| 28 | F13_SUFFIX | string | varchar(3) | yes | |
| 29 | F14 | boolean | bit | yes | |
| 30 | F14_SUFFIX | string | varchar(3) | yes | |
| 31 | F15 | boolean | bit | yes | |
| 32 | F15_SUFFIX | string | varchar(3) | yes | |
| 33 | F16 | boolean | bit | yes | |
| 34 | F16_SUFFIX | string | varchar(3) | yes | |
| 35 | F18 | boolean | bit | yes | |
| 36 | F18_SUFFIX | string | varchar(3) | yes | |
| 37 | F19 | boolean | bit | yes | |
| 38 | F19_SUFFIX | string | varchar(3) | yes | |
| 39 | FIRST_NAME_CURRENT | string | varchar(25) | yes | |
| 40 | GAM_SCREEN_POSITIVE | string | varchar(12) | yes | |
| 41 | GENDER_IDENTITY_2024 | string | varchar(22) | yes | |
| 42 | HEARING_IMPAIRMENT | string | varchar(3) | yes | |
| 43 | HEPATITIS_B_STATUS | string | varchar(20) | yes | |
| 44 | HEPATITIS_C_STATUS | string | varchar(20) | yes | |
| 45 | HIGHEST_GRADE_COMPLETED | integer | int | yes | |
| 46 | HISPANIC_ORIGIN_2024 | string | varchar(47) | yes | |
| 47 | HIV_STATUS | string | varchar(20) | yes | |
| 48 | HOSP_FOR_MENTAL_ILLNESS | string | varchar(3) | yes | |
| 49 | HOSP_FOR_MENTAL_ILLNESS_30PLUS | string | varchar(3) | yes | |
| 50 | HOSPITALIZATION_REASON | string | varchar(11) | yes | |
| 51 | HYPERTENSION | string | varchar(7) | yes | |
| 52 | ID_CONSENT_DATE | datetime | datetime | yes | |
| 53 | ID_CONSENT_REVOKE_DATE | datetime | datetime | yes | |
| 54 | INDIV_EDU_PLAN | string | varchar(7) | yes | |
| 55 | LAST_4_SSN | string | varchar(4) | yes | |
| 56 | LAST_NAME_2_CHAR_BRITH | string | varchar(2) | yes | |
| 57 | LAST_NAME_2_CHAR_CURRENT | string | varchar(2) | yes | |
| 58 | LAST_NAME_BIRTH | string | varchar(50) | yes | |
| 59 | LAST_NAME_CURRENT | string | varchar(35) | yes | |
| 60 | LIVING_ARRANGEMENTS_2017 | string | varchar(30) | yes | |
| 61 | LOCADTR_ASMT_DATE | datetime | datetime | yes | |
| 62 | LOCADTR_ASMT_ID | string | varchar(9) | yes | |
| 63 | MARITAL_STATUS | string | varchar(17) | yes | |
| 64 | MEDICAID_CLIENT_ID | string | varchar(11) | yes | |
| 65 | MEDICATION_INCLUDED_IN_CLIENTS_TREATMENT | string | varchar(max) | yes | |
| 66 | MENTAL_CONDITION_2024 | string | varchar(3) | yes | |
| 67 | MILITARY_STATUS | string | varchar(2) | yes | |
| 68 | MOBILITY_IMPAIRMENT | string | varchar(3) | yes | |
| 69 | NUM_ARRESTS_PRIOR_30_DAYS | string | varchar(2) | yes | |
| 70 | NUM_ARRESTS_PRIOR_6_MONTH | string | varchar(3) | yes | |
| 71 | NUM_ASSESSMENT_VISITS | string | varchar(2) | yes | |
| 72 | NUM_CHILDREN_IN_FOSTER_CARE | string | varchar(1) | yes | |
| 73 | NUM_CHILDREN_W_CLIENT | string | varchar(1) | yes | |
| 74 | NUM_ER_EPISODES | string | varchar(2) | yes | |
| 75 | NUM_OF_CHILDREN | string | varchar(1) | yes | |
| 76 | ORIENTATION_TO_CHANGE_2024 | string | varchar(62) | yes | |
| 77 | OTHER_PHYSICAL_PROBLEM | string | varchar(3) | yes | |
| 78 | PACIFIC_ORIGIN_2024 | string | varchar(31) | yes | |
| 79 | PERPETRATOR_OF_DOMESTIC_VIOLENCE | string | varchar(17) | yes | |
| 80 | PREGNANT | string | varchar(3) | yes | |
| 81 | PRIMARY_AGE_1ST_USE | string | varchar(2) | yes | |
| 82 | PRIMARY_FREQUENCY_2017 | string | varchar(23) | yes | |
| 83 | PRIMARY_LANGUAGE_2024 | string | varchar(14) | yes | |
| 84 | PRIMARY_ROUTE_2017 | string | varchar(10) | yes | |
| 85 | PRIMARY_SOURCE_OF_INCOME_2017 | string | varchar(35) | yes | |
| 86 | PRIMARY_SUBSTANCE_2017 | string | varchar(27) | yes | |
| 87 | PRINCIPAL_REFERRAL_SOURCE | string | varchar(max) | yes | |
| 88 | PRIOR_TX_EPISODES | string | varchar(1) | yes | |
| 89 | PROGRAM_NO | string | varchar(5) | yes | |
| 90 | PROVIDER_CLIENT_ID | string | varchar(10) | yes | |
| 91 | PROVIDER_NO | string | varchar(5) | yes | |
| 92 | RACE_2024 | string | varchar(47) | yes | |
| 93 | REINTEGRATION_SETTING | string | varchar(12) | yes | |
| 94 | SECONDARY_AGE_1ST_USE | string | varchar(2) | yes | |
| 95 | SECONDARY_FREQUENCY_2017 | string | varchar(23) | yes | |
| 96 | SECONDARY_ROUTE_2017 | string | varchar(10) | yes | |
| 97 | SECONDARY_SUBSTANCE_2017 | string | varchar(27) | yes | |
| 98 | SELF_HELP_REFERRAL | string | varchar(3) | yes | |
| 99 | SEX | string | varchar(6) | yes | |
| 100 | SEXUAL_ORIENT_2024 | string | varchar(22) | yes | |
| 101 | SIGHT_IMPAIRMENT | string | varchar(3) | yes | |
| 102 | SIGNIFICANT_OTHER | string | varchar(3) | yes | |
| 103 | SPECIAL_PROJECT_2018 | string | varchar(31) | yes | |
| 104 | SPEECH_IMPAIRMENT | string | varchar(3) | yes | |
| 105 | SSNO | string | varchar(11) | yes | |
| 106 | TB_TEST_RESULT | string | varchar(20) | yes | |
| 107 | TERTIARY_AGE_1ST_USE | string | varchar(2) | yes | |
| 108 | TERTIARY_FREQUENCY_2017 | string | varchar(23) | yes | |
| 109 | TERTIARY_ROUTE_2017 | string | varchar(10) | yes | |
| 110 | TERTIARY_SUBSTANCE_2017 | string | varchar(27) | yes | |
| 111 | TOBACCO_AGE_1ST_USE | string | varchar(2) | yes | |
| 112 | TOBACCO_FREQUENCY_2017 | string | varchar(23) | yes | |
| 113 | TOBACCO_LAST_USE_MONTH | string | varchar(2) | yes | |
| 114 | TOBACCO_LAST_USE_YEAR | string | varchar(4) | yes | |
| 115 | TOBACCO_ROUTE | string | varchar(7) | yes | |
| 116 | TRANSGENDER | string | varchar(35) | yes | |
| 117 | TREATED_FOR_MENTAL_ILLNESS | string | varchar(3) | yes | |
| 118 | TYPE_OF_RESIDENCE_2024 | string | varchar(41) | yes | |
| 119 | VETERAN_STATUS | string | varchar(3) | yes | |
| 120 | VICTIM_OF_DOMESTIC_VIOLENCE | string | varchar(17) | yes | |
| 121 | ZIPCODE_OF_RESIDENCE | string | varchar(10) | yes | |
| 122 | SPECIAL_PROJECT | string | varchar(3) | yes | |
| 123 | NYSID | string | varchar(9) | yes | |
| 124 | CJ_CONSENT_DATE | datetime | datetime | yes | |
| 125 | CJ_CONSENT_REVOKE_DATE | datetime | datetime | yes | |
| 126 | SEXUAL_ORIENTATION | string | varchar(1) | yes | |
| 127 | HISPANIC_ORIGIN | string | varchar(80) | yes | |
| 128 | PRIMARY_LANGUAGE | string | varchar(30) | yes | |
| 129 | VETERAN | string | varchar(1) | yes | |
| 130 | TYPE_OF_RESIDENCE | string | varchar(2) | yes | |
| 131 | LIVING_ARRANGEMENTS | string | varchar(1) | yes | |
| 132 | SELF_FAMILY_OTHER | string | varchar(2) | yes | |
| 133 | PREVENTION_SERVICES | string | varchar(2) | yes | |
| 134 | HEALTH_CARE_SERVICES | string | varchar(2) | yes | |
| 135 | EMP_EDU_SPECIAL_SVCS | string | varchar(2) | yes | |
| 136 | PRINCIPLE_REF_SOURCE_OTHER | boolean | bit | yes | |
| 137 | EMPLOYMENT_STATUS | string | varchar(2) | yes | |
| 138 | PRIMARY_SOURCE_OF_INCOME | string | varchar(1) | yes | |
| 139 | COA_COSA | string | varchar(1) | yes | |
| 140 | CJ_NONE | boolean | bit | yes | |
| 141 | CJ_PROBATION | boolean | bit | yes | |
| 142 | CJ_WORK_RELEASE | boolean | bit | yes | |
| 143 | CJ_PRISON_JAIL | boolean | bit | yes | |
| 144 | CJ_OCFS_FACILITY | boolean | bit | yes | |
| 145 | CJ_CHARGES_PENDING | boolean | bit | yes | |
| 146 | CJ_ANY_TX_SP_COURT | boolean | bit | yes | |
| 147 | CJ_OTHER | boolean | bit | yes | |
| 148 | PRIMARY_SUBSTANCE | string | varchar(2) | yes | |
| 149 | PRIMARY_ROUTE | string | varchar(1) | yes | |
| 150 | PRIMARY_FREQUENCY | string | varchar(1) | yes | |
| 151 | SECONDARY_SUBSTANCE | string | varchar(2) | yes | |
| 152 | TERTIARY_SUBSTANCE | string | varchar(2) | yes | |
| 153 | TERTIARY_ROUTE | string | varchar(1) | yes | |
| 154 | TERTIARY_FREQUENCY | string | varchar(1) | yes | |
| 155 | MED_ASSIST_OPIOID_THERAPY | string | varchar(3) | yes | |
| 156 | TOBACCO_FREQUENCY | string | varchar(1) | yes | |
| 157 | MENTAL_RETARDATION | string | varchar(1) | yes | |
| 158 | ORIENTATION_TO_CHANGE | string | varchar(1) | yes | |
| 159 | GENDER_IDENTITY | string | varchar(1) | yes | |
| 160 | RACE | string | varchar(6) | yes | |
| 161 | CRIMINAL_JUSTICE_SERVICES | string | varchar(2) | yes | |
| 162 | CHEMICAL_DEPENDENCE_TX | string | varchar(2) | yes | |
| 163 | SOCIAL_SERVICES | string | varchar(2) | yes | |
| 164 | SECONDARY_ROUTE | string | varchar(1) | yes | |
| 165 | SECONDARY_FREQUENCY | string | varchar(1) | yes | |
| 166 | CJ_PAROLE | boolean | bit | yes | |
| 167 | ACQUIRED_OR_TBI | string | varchar(1) | yes | |
| 168 | CHEMICAL_DEPENDENCE_TX_2017 | string | varchar(28) | yes | |
| 169 | CRIMINAL_JUSTICE_SERVICES_2017 | string | varchar(40) | yes | |
| 170 | EMP_EDU_SPECIAL_SVCS_2017 | string | varchar(38) | yes | |
| 171 | HEALTH_CARE_SERVICES_2017 | string | varchar(50) | yes | |
| 172 | PREVENTION_SERVICES_2017 | string | varchar(37) | yes | |
| 173 | SELF_FAMILY_OTHER_2017 | string | varchar(36) | yes | |
| 174 | SPECIAL_PROJECT_2017 | string | varchar(31) | yes | |
| 175 | SEXUAL_ORIENTATION_2017 | string | varchar(20) | yes | |
| 176 | TYPE_OF_RESIDENCE_2017 | string | varchar(30) | yes | |
| 177 | COA_COSA_2017 | string | varchar(28) | yes | |
| 178 | ORIENTATION_TO_CHANGE_2017 | string | varchar(39) | yes | |
| 179 | GENDER_IDENTITY_2017 | string | varchar(35) | yes | |
| 180 | SOCIAL_SERVICES_2017 | string | varchar(57) | yes | |
| 181 | RECOVERY_SUPPORT_SERVICES | string | varchar(40) | yes | |
| 182 | PACIFIC_ISLANDER_ORIGIN | string | varchar(31) | yes | |
| 183 | SUD_PROGRAM_NEW | string | varchar(29) | yes | |
| 184 | ASAIN_ORIGIN | string | varchar(26) | yes | |
| 185 | SEXUAL_ORIENTATION_2018 | string | varchar(20) | yes | |
| 186 | GENDER_IDENTITY_2018 | string | varchar(35) | yes |