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 | BIRTHDATE | datetime | datetime | yes | |
| 3 | LAST_4_SSN | string | varchar(4) | yes | |
| 4 | #_OF_VISITS | string | varchar(2) | yes | |
| 5 | ZIP_CODE | string | varchar(10) | yes | |
| 6 | NUMBER_OF_CHILDREN | string | varchar(2) | yes | |
| 7 | #_CHILD_LIVING_WITH | string | varchar(2) | yes | |
| 8 | PRIMARY_AGE_OF_FIRST_USE | string | varchar(2) | yes | |
| 9 | DAYS_HOSPITALIZED | string | varchar(2) | yes | |
| 10 | PREGNANT | string | varchar(3) | yes | |
| 11 | CONDITION1 | string | varchar(3) | yes | |
| 12 | CONDITION3 | string | varchar(3) | yes | |
| 13 | TREATMENT1 | string | varchar(3) | yes | |
| 14 | TREATMENT2 | string | varchar(3) | yes | |
| 15 | RACE | string | varchar(41) | yes | |
| 16 | HISPANIC_ORIGIN | string | varchar(23) | yes | |
| 17 | LIVING_ARRANGEMENTS | string | varchar(29) | yes | |
| 18 | HIGHEST_GRADE_COMPLETED | string | varchar(33) | yes | |
| 19 | MARITAL_STATUS | string | varchar(17) | yes | |
| 20 | CHILD_OF_ALCOHOLIC | string | varchar(28) | yes | |
| 21 | SECONDARY_ROUTE | string | varchar(11) | yes | |
| 22 | TERTIARY_ROUTE | string | varchar(11) | yes | |
| 23 | SECONDARY_FREQUENCY | string | varchar(22) | yes | |
| 24 | REASON_FOR_HOSPITALIZATION | string | varchar(11) | yes | |
| 25 | ADMISSION_DISPOSITION_N | string | varchar(58) | yes | |
| 26 | TYPE_OF_RESIDENCE_N | string | varchar(35) | yes | |
| 27 | CRIMINAL_JUSTICE_SERVICES_N | string | varchar(39) | yes | |
| 28 | SELF_FAMILY_OTHER_N | string | varchar(33) | yes | |
| 29 | PREVENTION_SERVICES_N | string | varchar(37) | yes | |
| 30 | HEALTH_CARE_SERVICES_N | string | varchar(50) | yes | |
| 31 | EMPLOYMENT_STATUS_N | string | varchar(62) | yes | |
| 32 | CRIMINAL_JUSTICE_STATUS_N | string | varchar(32) | yes | |
| 33 | PRU_NUMBER | string | varchar(20) | yes | |
| 34 | DAYS_IN_DETOX | string | varchar(3) | yes | |
| 35 | BRAIN_INJURY | string | varchar(3) | yes | |
| 36 | CHEMICAL_DEPENDENCE_TREATMENT_N | string | varchar(28) | yes | |
| 37 | SOCIAL_SERVICES_N | string | varchar(62) | yes | |
| 38 | CLIENT_ID | string | varchar(15) | yes | |
| 39 | LAST_NAME_FIRST_2_CHAR | string | varchar(2) | yes | |
| 40 | ASSESSMENT_DATE | datetime | datetime | yes | |
| 41 | #_OF_DAYS_INCARCERATED_6_MO | string | varchar(3) | yes | |
| 42 | SECONDARY_AGE_OF_FIRST_USE | string | varchar(2) | yes | |
| 43 | COUNTY_OF_RESIDENCE | string | varchar(40) | yes | |
| 44 | CHILD_PROT_SERVICES | string | varchar(3) | yes | |
| 45 | CONDITION5 | string | varchar(3) | yes | |
| 46 | CONDITION6 | string | varchar(3) | yes | |
| 47 | PRIMARY_FREQUENCY | string | varchar(22) | yes | |
| 48 | TERTIARY_FREQUENCY | string | varchar(22) | yes | |
| 49 | TERTIARY_SUBSTANCE_N | string | varchar(25) | yes | |
| 50 | #_OF_ARRESTS_6_MO | string | varchar(2) | yes | |
| 51 | TERTIARY_AGE_OF_FIRST_USE | string | varchar(2) | yes | |
| 52 | SIGNIFICANT_OTHER | string | varchar(3) | yes | |
| 53 | VETERAN_STATUS | string | varchar(3) | yes | |
| 54 | CONDITION2 | string | varchar(3) | yes | |
| 55 | SEX | string | varchar(6) | yes | |
| 56 | EMPLOYER_SERVICES | string | varchar(38) | yes | |
| 57 | PRIMARY_ROUTE | string | varchar(11) | yes | |
| 58 | PRIMARY_SUBSTANCE_N | string | varchar(25) | yes | |
| 59 | SECONDARY_SUBSTANCE_N | string | varchar(25) | yes | |
| 60 | #_OF_EMERGENCY | string | varchar(2) | yes | |
| 61 | PAST_30D_NO_OF_ARREST | string | varchar(2) | yes | |
| 62 | CONDITION4 | string | varchar(3) | yes | |
| 63 | CONDITION7 | string | varchar(3) | yes | |
| 64 | TREATMENT3 | string | varchar(3) | yes | |
| 65 | PRIMARY_SOURCE_OF_INCOME | string | varchar(36) | yes | |
| 66 | PROVIDER_NUMBER | string | varchar(20) | yes |