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 | PROVIDER_NUMBER | string | varchar(5) | yes | |
| 3 | PROGRAM_NUMBER | string | varchar(5) | yes | |
| 4 | PROVIDER_CLIENT_ID | string | varchar(10) | yes | |
| 5 | SPECIAL_PROJECT | string | varchar(100) | yes | |
| 6 | LAST_4_SSN | integer | smallint | yes | |
| 7 | NAME_2_LETTER_LAST | string | varchar(2) | yes | |
| 8 | LAST_2_LETTER_FIRST | string | varchar(2) | yes | |
| 9 | ADMISSION_DATE | datetime | datetime | yes | |
| 10 | SINGNIFICANT_OTHER | string | varchar(3) | yes | |
| 11 | RACE | string | varchar(40) | yes | |
| 12 | HISPANIC_ORIGIN | string | varchar(30) | yes | |
| 13 | PRIMARY_LANGUAGE | string | varchar(20) | yes | |
| 14 | VETERAN | string | varchar(3) | yes | |
| 15 | ZIP_CODE_OF_RESIDENCE | string | varchar(5) | yes | |
| 16 | COUNTY_OF_RESIDENCE | string | varchar(35) | yes | |
| 17 | US_MILITARY_STATUS | string | varchar(50) | yes | |
| 18 | TYPE_OF_RESIDENCE | string | varchar(40) | yes | |
| 19 | LIVING_ARRANGEMENT | string | varchar(35) | yes | |
| 20 | CHEMICAL_DEPENDENCE | string | varchar(50) | yes | |
| 21 | HEALTH_CARE_SERVICES | string | varchar(40) | yes | |
| 22 | PRINCIPAL_REFERRAL | string | varchar(45) | yes | |
| 23 | PREVENTION_INTERVENTION_SERVICES | string | varchar(45) | yes | |
| 24 | EMPLOYER_EDUCATIONAL_SERVICE | string | varchar(45) | yes | |
| 25 | SOCIAL_SERVICES | string | varchar(50) | yes | |
| 26 | OTHER | boolean | bit | yes | |
| 27 | HIGHEST_GRADE_COMPLETED | string | varchar(35) | yes | |
| 28 | EMPLOYMENT_STATUS | string | varchar(50) | yes | |
| 29 | PRIMARY_SOURCE_INCOME | string | varchar(40) | yes | |
| 30 | MARITAL_STATUS | string | varchar(20) | yes | |
| 31 | CHILD_OF_ALCOHOLIC_SUBSTANCE_USER | string | varchar(30) | yes | |
| 32 | CASE_WITH_CHILD_PROTECTIVE_SERVICE | string | varchar(3) | yes | |
| 33 | NO_OF_CHILDREN | integer | smallint | yes | |
| 34 | NO_CHILDREN_LIVING_WITH_CLIENT | integer | smallint | yes | |
| 35 | NO_OF_CHILDREN_LIVING_FOSTER_CARE | integer | smallint | yes | |
| 36 | ALTERNATIVE_TO_INCARCERATION | string | varchar(3) | yes | |
| 37 | NO_OF_ARREST_30_DAYS | integer | smallint | yes | |
| 38 | NO_OF_ARREST_6_MONTHS | integer | smallint | yes | |
| 39 | NO_OD_DAYS_INCARCERATED | integer | smallint | yes | |
| 40 | PRIMARY_SUBSTANCE | string | varchar(35) | yes | |
| 41 | SECONDARY_SUBSTANCE | string | varchar(35) | yes | |
| 42 | TERTIARY_SUBSTANCE | string | varchar(35) | yes | |
| 43 | PRIMARY_ROUTE | string | varchar(15) | yes | |
| 44 | SECONDARY_ROUTE | string | varchar(15) | yes | |
| 45 | TERTIARY_ROUTE | string | varchar(15) | yes | |
| 46 | PRIMARY_FREQ | string | varchar(30) | yes | |
| 47 | SECONDARY_FREQ | string | varchar(30) | yes | |
| 48 | TERTIARY_FREQ | string | varchar(30) | yes | |
| 49 | PRIMARY_AGE_FIRST_USE | integer | smallint | yes | |
| 50 | SECONDARY_AGE_FIRST_USE | integer | smallint | yes | |
| 51 | TERTIARY_AGE_FIRST_USE | integer | smallint | yes | |
| 52 | ATTENDING_12_STEP | string | varchar(3) | yes | |
| 53 | EVER_USE_TOBACCO | string | varchar(3) | yes | |
| 54 | TOBACCO_AGE_FIRST_USE | integer | smallint | yes | |
| 55 | TOBACCOR_FREQ_USE | string | varchar(30) | yes | |
| 56 | DATE_LAST_USE_MONTH | string | varchar(2) | yes | |
| 57 | DATE_LAST_USE_YEAR | integer | smallint | yes | |
| 58 | TOBACCO_PRIMARY_ROUTE_OF_ADMIN | string | varchar(10) | yes | |
| 59 | NUMBER_PRIOR__SUBSTANCE_USE_EPISODE | string | varchar(1) | yes | |
| 60 | PREGNANT | string | varchar(3) | yes | |
| 61 | HEARING_IMPAIRMENT | string | varchar(3) | yes | |
| 62 | MOBILITY_IMPAIRMENT | string | varchar(3) | yes | |
| 63 | SPEECH_IMPAIRMENT | string | varchar(3) | yes | |
| 64 | SIGHT_IMPAIRMENT | string | varchar(3) | yes | |
| 65 | OTHER_HEALTH_CONDITION | string | varchar(3) | yes | |
| 66 | MENTAL_RETARDATION | string | varchar(3) | yes | |
| 67 | COEXISTING_PSYCHIATRIC_DISORDER | string | varchar(3) | yes | |
| 68 | TREATED_FOR_MENTAL_ILLNESS | string | varchar(3) | yes | |
| 69 | HOSPITALIZED_FOR_MENTAL_ILLNESS | string | varchar(3) | yes | |
| 70 | HOSPITALIZED_FOR_30_DAYS | string | varchar(3) | yes | |
| 71 | REASON_FOR_HOSPITALIZATION | string | varchar(15) | yes | |
| 72 | NO_OF_DAYS_INPATIENT_DETOX | integer | smallint | yes | |
| 73 | NO_OR_ER_EPISODE | integer | smallint | yes | |
| 74 | NO_OF_DAYS_HOSP_NON_DETOX | integer | smallint | yes | |
| 75 | POSITIVE_GAMBLING_PROBLEM | string | varchar(15) | yes | |
| 76 | PATIENT_ORIENTATION_TO_CHANGE | string | varchar(45) | yes | |
| 77 | NONE | boolean | bit | yes | |
| 78 | PROBATION | boolean | bit | yes | |
| 79 | PAROLE | boolean | bit | yes | |
| 80 | WORK_RELEASE | boolean | bit | yes | |
| 81 | IN_PRISON_JAIL | boolean | bit | yes | |
| 82 | IN_OCFS_FACILITY | boolean | bit | yes | |
| 83 | CHARGES_PENDING | boolean | bit | yes | |
| 84 | ANY_TREATMENT_SPECIALTY_COURT | boolean | bit | yes | |
| 85 | OTHER2 | boolean | bit | yes | |
| 86 | ASSESSMENT_VISIT | integer | smallint | yes | |
| 87 | CRIMINAL_JUSTICE_SRVC | string | varchar(45) | yes | |
| 88 | HOSPITALIZATION_REASON | string | varchar(30) | yes |