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 | #_CHILD_LIVING_WITH | string | varchar(2) | yes | |
| 3 | #_OF_ARRESTS_6_MO | string | varchar(2) | yes | |
| 4 | #_OF_DAYS_INCARCERATED_6_MO | string | varchar(3) | yes | |
| 5 | #_OF_EMERGENCY | string | varchar(2) | yes | |
| 6 | #_OF_VISITS | string | varchar(2) | yes | |
| 7 | ADMISSION_DISPOSITION | string | varchar(50) | yes | |
| 8 | ASIAN_ORIGIN_2024 | string | varchar(max) | yes | |
| 9 | ASSESSMENT_DATE | datetime | datetime | yes | |
| 10 | BIRTHDATE | datetime | datetime | yes | |
| 11 | BRAIN_INJURY | string | varchar(3) | yes | |
| 12 | CHILD_OF_ALCOHOLIC | string | varchar(28) | yes | |
| 13 | CHILD_PROT_SERVICES | string | varchar(3) | yes | |
| 14 | CONDITION1 | string | varchar(3) | yes | |
| 15 | CONDITION2 | string | varchar(3) | yes | |
| 16 | CONDITION3 | string | varchar(3) | yes | |
| 17 | CONDITION4 | string | varchar(3) | yes | |
| 18 | CONDITION5 | string | varchar(3) | yes | |
| 19 | CONDITION6 | string | varchar(3) | yes | |
| 20 | CONDITION7 | string | varchar(3) | yes | |
| 21 | COUNTY_OF_RESIDENCE_LOOKUP | string | varchar(30) | yes | |
| 22 | CRIMINAL_JUSTICE_STATUS_N | string | varchar(32) | yes | |
| 23 | DAYS_HOSPITALIZED | string | varchar(2) | yes | |
| 24 | DAYS_IN_DETOX | string | varchar(3) | yes | |
| 25 | EMPLOYMENT_STATUS_LOOKUP | string | varchar(2) | yes | |
| 26 | HIGHEST_GRADE_COMPLETED_LOOKUP | integer | int | yes | |
| 27 | HISPANIC_ORIGIN_LOOKUP | string | varchar(80) | yes | |
| 28 | LAST_4_SSN | string | varchar(4) | yes | |
| 29 | LAST_NAME_FIRST_2_CHAR | string | varchar(2) | yes | |
| 30 | LIVING_ARRANGEMENTS_LOOKUP | string | varchar(1) | yes | |
| 31 | MARITAL_STATUS | string | varchar(17) | yes | |
| 32 | NUMBER_OF_CHILDREN | string | varchar(2) | yes | |
| 33 | PACIFIC_ORIGIN_2024 | string | varchar(max) | yes | |
| 34 | PAST_30D_NO_OF_ARREST | string | varchar(2) | yes | |
| 35 | PREGNANT | string | varchar(3) | yes | |
| 36 | PRIMARY_AGE_OF_FIRST_USE | integer | int | yes | |
| 37 | PRIMARY_FREQUENCY | string | varchar(24) | yes | |
| 38 | PRIMARY_LANGUAGE_2024 | string | varchar(14) | yes | |
| 39 | PRIMARY_ROUTE | string | varchar(24) | yes | |
| 40 | PRIMARY_SOURCE_OF_INCOME | string | varchar(36) | yes | |
| 41 | PRIMARY_SUBSTANCE | string | varchar(24) | yes | |
| 42 | PRINCIPAL_REFERRAL_SOURCE | string | varchar(max) | yes | |
| 43 | PROGRAM_NO | string | varchar(5) | yes | |
| 44 | PROVIDER_CLIENT_ID | string | varchar(10) | yes | |
| 45 | PROVIDER_NO | string | varchar(5) | yes | |
| 46 | RACE_LOOKUP | string | varchar(6) | yes | |
| 47 | REASON_FOR_HOSPITALIZATION | string | varchar(11) | yes | |
| 48 | SECONDARY_AGE_OF_FIRST_USE | integer | int | yes | |
| 49 | SECONDARY_FREQUENCY | string | varchar(24) | yes | |
| 50 | SECONDARY_ROUTE | string | varchar(24) | yes | |
| 51 | SECONDARY_SUBSTANCE | string | varchar(24) | yes | |
| 52 | SEX_AT_BIRTH | string | varchar(1) | yes | |
| 53 | SIGNIFICANT_OTHER | string | varchar(3) | yes | |
| 54 | SPECIAL_PROJECT_2018 | string | varchar(10) | yes | |
| 55 | TERTIARY_AGE_OF_FIRST_USE | integer | int | yes | |
| 56 | TERTIARY_FREQUENCY | string | varchar(24) | yes | |
| 57 | TERTIARY_ROUTE | string | varchar(24) | yes | |
| 58 | TERTIARY_SUBSTANCE | string | varchar(24) | yes | |
| 59 | TREATMENT1 | string | varchar(3) | yes | |
| 60 | TREATMENT2 | string | varchar(3) | yes | |
| 61 | TREATMENT3 | string | varchar(3) | yes | |
| 62 | TYPE_OF_RESIDENCE | string | varchar(37) | yes | |
| 63 | VETERAN_STATUS | string | varchar(3) | yes | |
| 64 | ZIP_CODE | string | varchar(10) | yes | |
| 65 | PROGRAM_STATUS_ASSESSMENT | string | varchar(20) | yes |