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 | CHEMICAL_USE_ABUSE_HISTORY | string | varchar(4000) | yes | |
| 3 | OTHER_ALCOHOL | string | varchar(3) | yes | |
| 4 | OTHER_ALPRAZOLAM | string | varchar(3) | yes | |
| 5 | OTHER_AMPHETAMINE | string | varchar(3) | yes | |
| 6 | OTHER_BARBITURATE | string | varchar(3) | yes | |
| 7 | OTHER_BENZODIAZEPINE | string | varchar(3) | yes | |
| 8 | OTHER_BUPRENORPHINE | string | varchar(3) | yes | |
| 9 | OTHER_CATAPRES | string | varchar(3) | yes | |
| 10 | OTHER_COCAINE | string | varchar(3) | yes | |
| 11 | OTHER_COMMENTS | string | varchar(4000) | yes | |
| 12 | OTHER_CRACK | string | varchar(3) | yes | |
| 13 | OTHER_ECSTASY | string | varchar(3) | yes | |
| 14 | OTHER_ELAVIL | string | varchar(3) | yes | |
| 15 | OTHER_EPHEDRINE | string | varchar(3) | yes | |
| 16 | OTHER_GHB | string | varchar(3) | yes | |
| 17 | OTHER_HALLUCINOGEN | string | varchar(3) | yes | |
| 18 | OTHER_HEROIN | string | varchar(3) | yes | |
| 19 | OTHER_INHALANT | string | varchar(3) | yes | |
| 20 | OTHER_KETAMINE | string | varchar(3) | yes | |
| 21 | OTHER_KHAT | string | varchar(3) | yes | |
| 22 | OTHER_MARIJUANA | string | varchar(3) | yes | |
| 23 | OTHER_METHADONE | string | varchar(3) | yes | |
| 24 | OTHER_METHAMPHETAMINE | string | varchar(3) | yes | |
| 25 | OTHER_NONE | boolean | bit | yes | |
| 26 | OTHER_OPIATE | string | varchar(3) | yes | |
| 27 | OTHER_OTHER | string | varchar(50) | yes | |
| 28 | OTHER_OVER_THE_COUNTER | string | varchar(3) | yes | |
| 29 | OTHER_OXYCONTIN | string | varchar(3) | yes | |
| 30 | OTHER_PCP | string | varchar(3) | yes | |
| 31 | OTHER_ROHYPNOL | string | varchar(3) | yes | |
| 32 | OTHER_SEDATIVE | string | varchar(3) | yes | |
| 33 | OTHER_STIMULANT | string | varchar(3) | yes | |
| 34 | OTHER_TRANQUILIZER | string | varchar(3) | yes | |
| 35 | OTHER_VIAGRA | string | varchar(3) | yes | |
| 36 | PRIMARY_AGE_FIRST_USE | integer | smallint | yes | |
| 37 | PRIMARY_COMMENTS | string | varchar(4000) | yes | |
| 38 | PRIMARY_DATE_LAST_USE | string | varchar(50) | yes | |
| 39 | PRIMARY_FREQUENCY | string | varchar(25) | yes | |
| 40 | PRIMARY_OTHER | string | varchar(50) | yes | |
| 41 | PRIMARY_ROUTE | string | varchar(10) | yes | |
| 42 | PRIMARY_ROUTE_OTHER | string | varchar(30) | yes | |
| 43 | PRIMARY_SUBSTANCE | string | varchar(25) | yes | |
| 44 | SECONDARY_AGE_FIRST_USE | integer | smallint | yes | |
| 45 | SECONDARY_COMMENTS | string | varchar(4000) | yes | |
| 46 | SECONDARY_DATE_LAST_USE | string | varchar(50) | yes | |
| 47 | SECONDARY_FREQUENCY | string | varchar(25) | yes | |
| 48 | SECONDARY_OTHER | string | varchar(50) | yes | |
| 49 | SECONDARY_ROUTE | string | varchar(10) | yes | |
| 50 | SECONDARY_SUBSTANCE | string | varchar(25) | yes | |
| 51 | TERTIARY_AGE_FIRST_USE | integer | smallint | yes | |
| 52 | TERTIARY_COMMENTS | string | varchar(4000) | yes | |
| 53 | TERTIARY_DATE_OF_LAST_USE | string | varchar(50) | yes | |
| 54 | TERTIARY_FREQUENCY | string | varchar(25) | yes | |
| 55 | TERTIARY_OTHER | string | varchar(30) | yes | |
| 56 | TERTIARY_ROUTE | string | varchar(10) | yes | |
| 57 | TERTIARY_SUBSTANCE | string | varchar(25) | yes |