01Relates to the patient
ACCOUNT is the patient's ACCOUNT; or 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
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | MEDICATION_ID PK | integer | int | no | |
| 2 | ACCOUNT PK | string | varchar(12) | no | |
| 3 | DRUG_ID | string | varchar(12) | yes | |
| 4 | DRUG_NAME | string | varchar(100) | yes | |
| 5 | STRENGTH_UNITS | string | varchar(50) | yes | |
| 6 | DOSAGE_FORM | string | varchar(50) | yes | |
| 7 | DOSAGE_DESCRIPTION | string | varchar(100) | yes | |
| 8 | REFILLS | string | varchar(10) | yes | |
| 9 | ROUTE | string | varchar(50) | yes | |
| 10 | DISPENSE | integer | smallint | yes | |
| 11 | PRESCRIPTION_NOTES | string | varchar(max) | yes | |
| 12 | PRESCRIPTION_DATE | datetime | datetime | yes | |
| 13 | PROVIDER_CODE | string | varchar(20) | yes | |
| 14 | USER_ID | string | varchar(20) | yes | |
| 15 | IS_ACTIVE | boolean | bit | yes | |
| 16 | IS_DELETED | boolean | bit | yes | |
| 17 | PRESCRIPTIONGUID | string | varchar(150) | yes | |
| 18 | GENERIC_NAME | string | varchar(100) | yes | |
| 19 | FILL_DATE | datetime | datetime | yes | |
| 20 | START_DATE | datetime | datetime | yes | |
| 21 | STOP_DATE | datetime | datetime | yes | |
| 22 | STOP_REASON | string | varchar(350) | yes | |
| 23 | MODIFIED_BY | string | varchar(20) | yes | |
| 24 | MODIFIED_DATE | datetime | datetime | yes | |
| 25 | SUBSTITUTION_PERMITTED | boolean | bit | yes | |
| 26 | QUANTITY | string | varchar(15) | yes | |
| 27 | QUANTITY_UNIT | string | varchar(30) | yes | |
| 28 | NDCID | string | varchar(11) | yes | |
| 29 | RCOPIA_ID | string | varchar(20) | yes | |
| 30 | PAT_NOTES | string | varchar(350) | yes | |
| 31 | OTHER_NOTES | string | varchar(350) | yes | |
| 32 | FORMULA_STRENGTH | string | varchar(100) | yes | |
| 33 | DRUG_FORM | string | varchar(50) | yes | |
| 34 | DURATION | integer | int | yes | |
| 35 | STRENGTH_VALUE | string | varchar(50) | yes | |
| 36 | DOSAGE_VALUE | string | varchar(50) | yes | |
| 37 | DOSAGE_FREQUENCY | string | varchar(100) | yes | |
| 38 | BRAND_NAME | string | varchar(100) | yes | |
| 39 | CPOE | boolean | bit | yes | |
| 40 | ACTOR_ID | string | varchar(100) | yes | |
| 41 | ENCOUNTER_ID | integer | int | yes | |
| 42 | DRUG_TYPE | string | varchar(1) | yes | |
| 43 | STATUS | string | varchar(20) | yes | |
| 44 | SOURCE | string | varchar(20) | yes | |
| 45 | FDB_MED_ID | string | varchar(6) | yes | |
| 46 | RX_NORM_ID | string | varchar(20) | yes | |
| 47 | RX_NORM_TYPE | string | varchar(10) | yes | |
| 48 | PHARMACY_NCPDP_ID | integer | int | yes | |
| 49 | PHARMACY_NAME | string | varchar(100) | yes | |
| 50 | PHARMACY_ADDR1 | string | varchar(65) | yes | |
| 51 | PHARMACY_ADDR2 | string | varchar(65) | yes | |
| 52 | PHARMACY_CITY | string | varchar(35) | yes | |
| 53 | PHARMACY_STATE | string | varchar(2) | yes | |
| 54 | PHARMACY_ZIP | string | varchar(10) | yes | |
| 55 | PHARMACY_PHONE | string | varchar(20) | yes | |
| 56 | PHARMACY_FAX | string | varchar(20) | yes | |
| 57 | SCHEDULE | string | varchar(15) | yes | |
| 58 | BRAND_TYPE | string | varchar(10) | yes | |
| 59 | PREPARER_USER_ID | string | varchar(20) | yes | |
| 60 | PREPARER_NAME | string | varchar(75) | yes | |
| 61 | PROVIDER_NAME | string | varchar(75) | yes | |
| 62 | PROVIDER_NPID | string | varchar(35) | yes |