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 | LAST_4_SSN | integer | smallint | yes | |
| 6 | NAME_2_LETTER_LAST | string | varchar(2) | yes | |
| 7 | ADMISSION_DATE | datetime | datetime | yes | |
| 8 | SINGNIFICANT_OTHER | string | varchar(3) | yes | |
| 9 | RACE | string | varchar(40) | yes | |
| 10 | HISPANIC_ORIGIN | string | varchar(30) | yes | |
| 11 | VETERAN | string | varchar(3) | yes | |
| 12 | ZIP_CODE_OF_RESIDENCE | string | varchar(5) | yes | |
| 13 | COUNTY_OF_RESIDENCE | string | varchar(35) | yes | |
| 14 | TYPE_OF_RESIDENCE | string | varchar(40) | yes | |
| 15 | LIVING_ARRANGEMENT | string | varchar(35) | yes | |
| 16 | CHEMICAL_DEPENDENCE | string | varchar(50) | yes | |
| 17 | HEALTH_CARE_SERVICES | string | varchar(40) | yes | |
| 18 | PRINCIPAL_REFERRAL | string | varchar(45) | yes | |
| 19 | PREVENTION_INTERVENTION_SERVICES | string | varchar(45) | yes | |
| 20 | EMPLOYER_EDUCATIONAL_SERVICE | string | varchar(45) | yes | |
| 21 | SOCIAL_SERVICES | string | varchar(50) | yes | |
| 22 | OTHER | boolean | bit | yes | |
| 23 | HIGHEST_GRADE_COMPLETED | string | varchar(35) | yes | |
| 24 | EMPLOYMENT_STATUS | string | varchar(50) | yes | |
| 25 | PRIMARY_SOURCE_INCOME | string | varchar(40) | yes | |
| 26 | MARITAL_STATUS | string | varchar(20) | yes | |
| 27 | CHILD_OF_ALCOHOLIC_SUBSTANCE_USER | string | varchar(30) | yes | |
| 28 | NO_OF_CHILDREN | integer | smallint | yes | |
| 29 | NO_CHILDREN_LIVING_WITH_CLIENT | integer | smallint | yes | |
| 30 | NO_OF_ARREST_30_DAYS | integer | smallint | yes | |
| 31 | NO_OF_ARREST_6_MONTHS | integer | smallint | yes | |
| 32 | NO_OD_DAYS_INCARCERATED | integer | smallint | yes | |
| 33 | PRIMARY_SUBSTANCE | string | varchar(35) | yes | |
| 34 | SECONDARY_SUBSTANCE | string | varchar(35) | yes | |
| 35 | TERTIARY_SUBSTANCE | string | varchar(35) | yes | |
| 36 | PRIMARY_ROUTE | string | varchar(15) | yes | |
| 37 | SECONDARY_ROUTE | string | varchar(15) | yes | |
| 38 | TERTIARY_ROUTE | string | varchar(15) | yes | |
| 39 | PRIMARY_FREQ | string | varchar(30) | yes | |
| 40 | SECONDARY_FREQ | string | varchar(30) | yes | |
| 41 | TERTIARY_FREQ | string | varchar(30) | yes | |
| 42 | PRIMARY_AGE_FIRST_USE | integer | smallint | yes | |
| 43 | SECONDARY_AGE_FIRST_USE | integer | smallint | yes | |
| 44 | TERTIARY_AGE_FIRST_USE | integer | smallint | yes | |
| 45 | PREGNANT | string | varchar(3) | yes | |
| 46 | HEARING_IMPAIRMENT | string | varchar(3) | yes | |
| 47 | MOBILITY_IMPAIRMENT | string | varchar(3) | yes | |
| 48 | SPEECH_IMPAIRMENT | string | varchar(3) | yes | |
| 49 | SIGHT_IMPAIRMENT | string | varchar(3) | yes | |
| 50 | OTHER_HEALTH_CONDITION | string | varchar(3) | yes | |
| 51 | MENTAL_RETARDATION | string | varchar(3) | yes | |
| 52 | COEXISTING_PSYCHIATRIC_DISORDER | string | varchar(3) | yes | |
| 53 | TREATED_FOR_MENTAL_ILLNESS | string | varchar(3) | yes | |
| 54 | HOSPITALIZED_FOR_MENTAL_ILLNESS | string | varchar(3) | yes | |
| 55 | HOSPITALIZED_FOR_30_DAYS | string | varchar(3) | yes | |
| 56 | REASON_FOR_HOSPITALIZATION | string | varchar(15) | yes | |
| 57 | NO_OF_DAYS_INPATIENT_DETOX | integer | smallint | yes | |
| 58 | NO_OR_ER_EPISODE | integer | smallint | yes | |
| 59 | NO_OF_DAYS_HOSP_NON_DETOX | integer | smallint | yes | |
| 60 | NONE | boolean | bit | yes | |
| 61 | PROBATION | boolean | bit | yes | |
| 62 | PAROLE | boolean | bit | yes | |
| 63 | WORK_RELEASE | boolean | bit | yes | |
| 64 | IN_PRISON_JAIL | boolean | bit | yes | |
| 65 | IN_OCFS_FACILITY | boolean | bit | yes | |
| 66 | CHARGES_PENDING | boolean | bit | yes | |
| 67 | ANY_TREATMENT_SPECIALTY_COURT | boolean | bit | yes | |
| 68 | OTHER2 | boolean | bit | yes | |
| 69 | ADMISSION_DISPOSITION | string | varchar(50) | yes | |
| 70 | ASSESSMENT_VISIT | integer | smallint | yes | |
| 71 | CRIMINAL_JUSTICE_SRVC | string | varchar(45) | yes |