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 | HAD_SEX_AGAINST_WILL | string | varchar(3) | yes | |
| 3 | HAD_UNPROTECTED_SEX | string | varchar(3) | yes | |
| 4 | NEEDLE_BLEACHED | string | varchar(3) | yes | |
| 5 | NEEDLE_REUSED_OWN | string | varchar(3) | yes | |
| 6 | NEEDLE_SHARED_AFTER_ME | string | varchar(3) | yes | |
| 7 | NEEDLE_SHARED_BEFORE_ME | string | varchar(3) | yes | |
| 8 | PAID_FOR_SEX | string | varchar(3) | yes | |
| 9 | SEX_TO_GET_MONEY | string | varchar(3) | yes | |
| 10 | SEX_WITH_HIV_POSITIVE | string | varchar(3) | yes | |
| 11 | SEX_WITH_HIV_STATUS | string | varchar(3) | yes | |
| 12 | SEX_WITH_INDIV_INJECTS_DRUGS | string | varchar(3) | yes | |
| 13 | SEXUAL_PARTNER_HOW_MANY | string | varchar(15) | yes | |
| 14 | TEST_FOR_HIV | string | varchar(3) | yes | |
| 15 | TEST_HEPATITIS_A_B_C | string | varchar(3) | yes | |
| 16 | TEST_HEPATITIS_OUTCOME | string | varchar(9) | yes | |
| 17 | TEST_HEPATITIS_POSITIVE_MED_CARE | string | varchar(9) | yes | |
| 18 | TEST_HEPATITIS_VACCINE | string | varchar(3) | yes | |
| 19 | TEST_PPD_TEST_RESULTS | string | varchar(8) | yes | |
| 20 | TEST_RESULT_LAST_CHEST_XRAY | string | varchar(500) | yes | |
| 21 | TEST_TB_TEST | string | varchar(3) | yes | |
| 22 | NEEDLE_NEW | string | varchar(3) | yes | |
| 23 | SEX_WHILE_ON_DRUGS | string | varchar(3) | yes | |
| 24 | USE_CONDOMS | string | varchar(3) | yes | |
| 25 | NEEDLE_ORIGIN_UNKNOWN | string | varchar(3) | yes | |
| 26 | TEST_FOR_HIV_RESULTS | string | varchar(8) | yes | |
| 27 | TEST_FOR_HIV_DATE | datetime | datetime | yes | |
| 28 | TEST_LAST_PPD_TEST_DATE | datetime | datetime | yes |