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 | LAST_NAME_2_CHAR | string | varchar(2) | yes | |
| 3 | INDIV_EDUCATION_PLAN | string | varchar(7) | yes | |
| 4 | ID_CONSENT_REVOKE_DATE | datetime | datetime | yes | |
| 5 | DIABETES_CODE | string | varchar(7) | yes | |
| 6 | REASON_FOR_HOSPITALIZATION_CODE | string | varchar(11) | yes | |
| 7 | TOBACCO_ROUTE | string | varchar(7) | yes | |
| 8 | PROVIDER_NO | string | varchar(10) | yes | |
| 9 | DATE_STATUS_COMPLETED | datetime | datetime | yes | |
| 10 | TYPE_OF_RESIDENCE_CODE | string | varchar(2) | yes | |
| 11 | LAST_NAME_CURRENT | string | varchar(35) | yes | |
| 12 | TREATED_FOR_ASTHMA_CODE | string | varchar(3) | yes | |
| 13 | TESTED_FOR_HIV | string | varchar(7) | yes | |
| 14 | SECONDARY_FREQUENCY_CODE | string | varchar(22) | yes | |
| 15 | TERTIARY_SUBSTANCE_CODE | string | varchar(26) | yes | |
| 16 | NUMBER_DAYS_DETOXED_6MONTH | string | varchar(3) | yes | |
| 17 | NUMBER_ER_EPISODES_6MONTH | string | varchar(2) | yes | |
| 18 | ID_CONSENT_DATE | datetime | datetime | yes | |
| 19 | LAST_NAME_BIRTH | string | varchar(35) | yes | |
| 20 | LENGTH_OF_EMPLOYMENT_CODE | string | varchar(2) | yes | |
| 21 | PRIMARY_PAYMENT_SOURCE_CODE | string | varchar(2) | yes | |
| 22 | NUMBER_ARRESTS_6MONTH | integer | int | yes | |
| 23 | NUMBER_OF_DAYS_INCARCERATED_6MONTH | integer | int | yes | |
| 24 | TREATED_FOR_DIABETES_CODE | string | varchar(3) | yes | |
| 25 | PRIMARY_SUBSTANCE_CODE | string | varchar(26) | yes | |
| 26 | PROGRAM_NO | string | varchar(5) | yes | |
| 27 | CLIENT_ID | string | varchar(10) | yes | |
| 28 | ALTERNATIVE_TO_INCARCERATION | string | varchar(3) | yes | |
| 29 | HYPERTENSION_CODE | string | varchar(7) | yes | |
| 30 | TESTED_FOR_HEPATITIS_C | string | varchar(7) | yes | |
| 31 | TB_TEST_RESULT_CODE | string | varchar(20) | yes | |
| 32 | NUMBER_DAYS_HOSPITAL_6MONTH | string | varchar(3) | yes | |
| 33 | TOBACCO_AGE | string | varchar(2) | yes | |
| 34 | SSNO | string | varchar(11) | yes | |
| 35 | NUMBER_ARRESTS_30DAYS | integer | int | yes | |
| 36 | TREATED_FOR_HYPERTENSION_CODE | string | varchar(3) | yes | |
| 37 | TREATED_FOR_TB_CODE | string | varchar(7) | yes | |
| 38 | BIRTH_DATE | datetime | datetime | yes | |
| 39 | LAST_4_SSN | string | varchar(4) | yes | |
| 40 | ZIPCODE_OF_RESIDENCE | string | varchar(5) | yes | |
| 41 | COUNTY_OF_RESIDENCE_CODE | string | varchar(2) | yes | |
| 42 | FIRST_NAME | string | varchar(25) | yes | |
| 43 | MEDICAID_CLIENT_ID | string | varchar(11) | yes | |
| 44 | ADDICTION_MEDICATIONS | string | varchar(max) | yes | |
| 45 | HIV_STATUS_CODE | string | varchar(20) | yes | |
| 46 | PRIMARY_FREQUENCY_CODE | string | varchar(22) | yes | |
| 47 | SECONDARY_SUBSTANCE_CODE | string | varchar(26) | yes | |
| 48 | TERTIARY_FREQUENCY_CODE | string | varchar(22) | yes | |
| 49 | TOBACCO_FREQUENCY_CODE | string | varchar(22) | yes | |
| 50 | CURRENT_OPIATE_ADDICTION_MEDICINE | string | varchar(13) | yes | |
| 51 | EMPLOYMENT_CODE | string | varchar(2) | yes | |
| 52 | CURRENT_DOSE_METH_LAAM | string | varchar(3) | yes | |
| 53 | HEPATITIS_B_STATUS_CODE | string | varchar(20) | yes | |
| 54 | TESTED_FOR_HEPATITIS_B | string | varchar(7) | yes | |
| 55 | TOBACCO_LAST_USE_YEAR | string | varchar(4) | yes | |
| 56 | SEX | string | varchar(1) | yes | |
| 57 | DATE_STATUS_DUE | datetime | datetime | yes | |
| 58 | LIVING_ARRANGEMENTS_CODE | string | varchar(1) | yes | |
| 59 | EDUCATION_CODE | string | varchar(2) | yes | |
| 60 | CRIMINAL_JUSTICE_CODE | string | varchar(max) | yes | |
| 61 | CURRENT_SCHEDULE | string | varchar(22) | yes | |
| 62 | ASTHMA_CODE | string | varchar(7) | yes | |
| 63 | HEPATITIS_C_STATUS_CODE | string | varchar(20) | yes | |
| 64 | EVER_USED_TOBACCO | string | varchar(3) | yes | |
| 65 | TOBACCO_LAST_USE_MONTH | string | varchar(2) | yes |