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 | ADDRESS | string | varchar(200) | yes | |
| 3 | BLACKOUTS_DETAIL | string | varchar(75) | yes | |
| 4 | CHEST_X_RAY_RESULT | string | varchar(75) | yes | |
| 5 | CLIENT_IS_TO_BE_REFERRED | string | varchar(3) | yes | |
| 6 | DATE_OF_REFERRAL | datetime | datetime | yes | |
| 7 | ELEVATED_LIVER_FUNCTION_DETAIL | string | varchar(75) | yes | |
| 8 | GOING_TO_CLINIC_OR_PHYSICIAN | string | varchar(3) | yes | |
| 9 | GONORRHEA_DETAIL | string | varchar(75) | yes | |
| 10 | HEPATITIS_B_TEST_POSITIVE_DETAIL | string | varchar(75) | yes | |
| 11 | HISTORY_OF_BLACKOUTS | string | varchar(3) | yes | |
| 12 | HISTORY_OF_HEP_B_TEST | string | varchar(3) | yes | |
| 13 | HISTORY_OF_HEP_C | string | varchar(3) | yes | |
| 14 | HISTORY_OF_INTRAVENOUS | string | varchar(3) | yes | |
| 15 | HISTORY_OF_OPPORTUNISTIC_INFECTION_DETAIL | string | varchar(75) | yes | |
| 16 | RINGWORM_DETAIL | string | varchar(75) | yes | |
| 17 | SCABIES | string | varchar(3) | yes | |
| 18 | SHINGLES_DETAIL | string | varchar(75) | yes | |
| 19 | VIRAL_LOAD_TREATED_DETAIL | string | varchar(75) | yes | |
| 20 | WAS_HEP_B_POSITIVE | string | varchar(3) | yes | |
| 21 | WAS_HEP_C_POSITIVE | string | varchar(3) | yes | |
| 22 | HEPATITIS_BE_TEST_DETAIL | string | varchar(75) | yes | |
| 23 | HISTORY_OF_HEP_A | string | varchar(3) | yes | |
| 24 | IF_POSITIVE_TREATED_DETAIL | string | varchar(75) | yes | |
| 25 | MENINGITIS_DETAIL | string | varchar(75) | yes | |
| 26 | SYPHILIS_MEDICATION_DETAIL | string | varchar(75) | yes | |
| 27 | TEST_NEGATIVE_OR_POSITIVE_DETAIL | string | varchar(75) | yes | |
| 28 | VACCINATION_HEPATITIS_A_DETAIL | string | varchar(75) | yes | |
| 29 | HERPES_DETAIL | string | varchar(75) | yes | |
| 30 | HISTORY_OF_HEP_B | string | varchar(3) | yes | |
| 31 | HISTORY_OF_OPPORTUNISTIC | string | varchar(3) | yes | |
| 32 | MEASLES_DETAIL | string | varchar(75) | yes | |
| 33 | MENINGITIS | string | varchar(3) | yes | |
| 34 | TB_POSITIVE_TREATED | string | varchar(3) | yes | |
| 35 | TEST_POSITIVE_T_CELL_VIRAL_DETAIL | string | varchar(75) | yes | |
| 36 | VACCINATION_HEPATITIS_B_DETAIL | string | varchar(75) | yes | |
| 37 | CHLAMYDIA | string | varchar(3) | yes | |
| 38 | DRINK_ALCOHOL_DETAIL | string | varchar(75) | yes | |
| 39 | HEPATITIS_A_TEST_POSITIVE_DETAIL | string | varchar(75) | yes | |
| 40 | HEPATITIS_C_TEST_POSITIVE_DETAIL | string | varchar(75) | yes | |
| 41 | IF_TREATED_HOW_LONG | string | varchar(75) | yes | |
| 42 | LAST_TEST_DETAIL | string | varchar(75) | yes | |
| 43 | LAST_TUBERCULOSIS_SKIN_TEST_DETAIL | string | varchar(75) | yes | |
| 44 | MUMPS_DETAIL | string | varchar(75) | yes | |
| 45 | RINGWORM | string | varchar(3) | yes | |
| 46 | SCABIES_DETAIL | string | varchar(75) | yes | |
| 47 | TEST_POSITIVE_CLINIC_DETAIL | string | varchar(75) | yes | |
| 48 | TIME_OF_REFERRAL | string | varchar(20) | yes | |
| 49 | DRINK_ALCOHOL_CURRENTLY | string | varchar(3) | yes | |
| 50 | FACILITY_NAME | string | varchar(75) | yes | |
| 51 | GONORRHEA | string | varchar(3) | yes | |
| 52 | HAVE_TCELL_AND_VIRAL | string | varchar(3) | yes | |
| 53 | HISTORY_OF_ELEVATED | string | varchar(3) | yes | |
| 54 | HISTORY_OF_HEP_A_TEST | string | varchar(3) | yes | |
| 55 | IF_TEST_POSITIVE_TREATED_DETAIL | string | varchar(75) | yes | |
| 56 | RESULT_T_CELL_DETAIL | string | varchar(75) | yes | |
| 57 | TESTED_FOR_SYPHILIS | string | varchar(3) | yes | |
| 58 | TESTED_FOR_SYPHILIS_DETAIL | string | varchar(75) | yes | |
| 59 | VENEREAL_WARTS_DETAIL | string | varchar(75) | yes | |
| 60 | VIRAL_WERE_YOU_TREATED | string | varchar(3) | yes | |
| 61 | CHICKEN_POX_DETAIL | string | varchar(75) | yes | |
| 62 | CHICKENPOX | string | varchar(3) | yes | |
| 63 | DID_YOU_IMMIGRATE | string | varchar(3) | yes | |
| 64 | DO_YOU_PRACTICE | string | varchar(3) | yes | |
| 65 | IF_TREATED_MEDICATION_DETAIL | string | varchar(75) | yes | |
| 66 | INTRAVENOUS_DRUG_USE_DETAIL | string | varchar(75) | yes | |
| 67 | LATEST_VIRAL_LOAD_DETAIL | string | varchar(75) | yes | |
| 68 | MUMPS | string | varchar(3) | yes | |
| 69 | PRACTICE_HIGH_RISK_SEX_DETAIL | string | varchar(75) | yes | |
| 70 | SYPHILIS_POSITIVE_TREATED_WHEN | string | varchar(3) | yes | |
| 71 | VENEREAL_WARTS | string | varchar(3) | yes | |
| 72 | VIRAL_LOAD_DETAIL | string | varchar(75) | yes | |
| 73 | VIRAL_LOAD_IF_TREATED_MEDICATION | string | varchar(75) | yes | |
| 74 | WAS_HEP_A_TEST_POSITIVE | string | varchar(3) | yes | |
| 75 | WHEN_T_CELL_AND_VIRAL_TEST_DONE_DETAIL | string | varchar(75) | yes | |
| 76 | WHERE_YOU_TREATED_DETAIL | string | varchar(75) | yes | |
| 77 | CHLAMYDIA_DETAIL | string | varchar(75) | yes | |
| 78 | HEPATITIS_A_TEST_DETAIL | string | varchar(75) | yes | |
| 79 | HERPES_II | string | varchar(3) | yes | |
| 80 | HISOTRY_OF_HEPATITIS_C_TEST_DETAIL | string | varchar(75) | yes | |
| 81 | IMMIRGRATE_DETAIL | string | varchar(75) | yes | |
| 82 | LAST_CHEST_X_RAY | string | varchar(75) | yes | |
| 83 | MEASLES | string | varchar(3) | yes | |
| 84 | SHINGLES | string | varchar(3) | yes | |
| 85 | TB_RESULTS | string | varchar(3) | yes | |
| 86 | WERE_YOU_TREATED | string | varchar(3) | yes |