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 | HIGH_BLOOD_PRESSURE | boolean | bit | yes | |
| 3 | TESTED_FOR_HIV | boolean | bit | yes | |
| 4 | TUBERCULOSIS | string | varchar(3) | yes | |
| 5 | PAST_MEDICAL_HISTORY | string | varchar(max) | yes | |
| 6 | KNOWNEXPOSE | string | varchar(3) | yes | |
| 7 | HX_BIPOLAR | boolean | bit | yes | |
| 8 | HX_ANXIETY | boolean | bit | yes | |
| 9 | HALLUCINATIONS_WHEN | string | varchar(7) | yes | |
| 10 | HOSPITALIZED_MENTAL | string | varchar(3) | yes | |
| 11 | OTHER_RESPIRATORY_PROBLEMS | boolean | bit | yes | |
| 12 | NONE_OF_THE_ABOVE | boolean | bit | yes | |
| 13 | RESTULTS_X_RAY | string | varchar(100) | yes | |
| 14 | TBTEST | string | varchar(20) | yes | |
| 15 | CHESTX | string | varchar(20) | yes | |
| 16 | INFECTIOUS_DIEASE | boolean | bit | yes | |
| 17 | SUICIDE_ATTEMPTS_WHEN | string | varchar(7) | yes | |
| 18 | PANCREATITIS | boolean | bit | yes | |
| 19 | PROVIDER_NAME_AND_CONTACT_INFO | string | varchar(max) | yes | |
| 20 | HIV_2 | boolean | bit | yes | |
| 21 | ARTHRITIS | boolean | bit | yes | |
| 22 | HX_FIRE_SETTING | boolean | bit | yes | |
| 23 | HX_DEPRESSION | boolean | bit | yes | |
| 24 | DENIES_ANY_MH_HX | boolean | bit | yes | |
| 25 | HOSPITALIZED_MEDICAL_DESCRIBE | string | varchar(max) | yes | |
| 26 | FATHER_HEALTH_STATUS | string | varchar(max) | yes | |
| 27 | OTHER_FAMILY | string | varchar(max) | yes | |
| 28 | UNDER_CARE | string | varchar(3) | yes | |
| 29 | OTHER_COMMENT | string | varchar(100) | yes | |
| 30 | SIGNIFICOUGH | string | varchar(3) | yes | |
| 31 | DISEASESCREENREC | string | varchar(3) | yes | |
| 32 | OPERATIONS | boolean | bit | yes | |
| 33 | HX_SUICIDE_ATTEMPTS_IDEATION | boolean | bit | yes | |
| 34 | MOTHER_HEALTH_STATUS | string | varchar(max) | yes | |
| 35 | HEPATITIS_ABC | boolean | bit | yes | |
| 36 | STDS | boolean | bit | yes | |
| 37 | CURRENTLY_TREATED_DESCRIBE | string | varchar(max) | yes | |
| 38 | ANEMIA | boolean | bit | yes | |
| 39 | SEIZURE_DISORDER | boolean | bit | yes | |
| 40 | HX_PTSD | boolean | bit | yes | |
| 41 | HX_MH_HOSPITALIZATIONS | boolean | bit | yes | |
| 42 | ASTHMA | boolean | bit | yes | |
| 43 | COMMUNICABLE_DISEASE | string | varchar(max) | yes | |
| 44 | RESULTS_TB | string | varchar(100) | yes | |
| 45 | CURRENT_MEDICAL_PROVIDER | string | varchar(3) | yes | |
| 46 | LASTPHYSICAL | string | varchar(20) | yes | |
| 47 | WANTSCREEN | string | varchar(3) | yes | |
| 48 | ACCIDENTS_TRAUMA | boolean | bit | yes | |
| 49 | HX_SCHIZOPHRENIA | boolean | bit | yes | |
| 50 | HX_AUDIO_VISUAL_HALLUCINATIONS | boolean | bit | yes | |
| 51 | MORE_TREATMENT | string | varchar(max) | yes | |
| 52 | HOSPITALIZED_MEDICAL | string | varchar(3) | yes | |
| 53 | CONTACT_INFORMATION | string | varchar(max) | yes | |
| 54 | DIABETES | boolean | bit | yes | |
| 55 | ELEVATED_LIVER_FUNCTIONS | boolean | bit | yes | |
| 56 | GASTROINTESTINAL_PROBLEMS | boolean | bit | yes | |
| 57 | UNEXPLAINED_BLEEDING | boolean | bit | yes | |
| 58 | TB | boolean | bit | yes | |
| 59 | OTHER | boolean | bit | yes | |
| 60 | RESULTS_HIV | string | varchar(100) | yes | |
| 61 | SEXNEEDLECONCERN | string | varchar(3) | yes | |
| 62 | HX_OCD | boolean | bit | yes | |
| 63 | HIV | string | varchar(3) | yes | |
| 64 | ALLERGIES | string | varchar(max) | yes | |
| 65 | CURRENTLY_TREATED | string | varchar(3) | yes | |
| 66 | HIVTEST | string | varchar(20) | yes | |
| 67 | CANCER | boolean | bit | yes |