01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | PRESCRIPTION_RCOPIA_ID PK | string | varchar(30) | no | |
| 2 | ACCOUNT PK | string | varchar(12) | no | |
| 3 | MEDICATION_ID | integer | int | yes | |
| 4 | DRUG_NAME | string | varchar(100) | yes | |
| 5 | BRAND_NAME | string | varchar(100) | yes | |
| 6 | GENERIC_NAME | string | varchar(100) | yes | |
| 7 | DRUG_FORM | string | varchar(40) | yes | |
| 8 | FORMULA_STRENGTH | string | varchar(100) | yes | |
| 9 | DOSAGE_VALUE | string | varchar(30) | yes | |
| 10 | DOSAGE_FORM | string | varchar(30) | yes | |
| 11 | DOSAGE_FREQUENCY | string | varchar(100) | yes | |
| 12 | DOSAGE_DESCRIPTION | string | varchar(100) | yes | |
| 13 | QUANTITY | string | varchar(15) | yes | |
| 14 | QUANTITY_UNIT | string | varchar(30) | yes | |
| 15 | ROUTE | string | varchar(30) | yes | |
| 16 | REFILLS | string | varchar(3) | yes | |
| 17 | SUBSTITUTION_PERMITTED | boolean | bit | yes | |
| 18 | DURATION | integer | int | yes | |
| 19 | IS_ACTIVE | boolean | bit | yes | |
| 20 | IS_DELETED | boolean | bit | yes | |
| 21 | CPOE | boolean | bit | yes | |
| 22 | START_DATE | datetime | datetime | yes | |
| 23 | FILL_DATE | datetime | datetime | yes | |
| 24 | STOP_DATE | datetime | datetime | yes | |
| 25 | STOP_REASON | string | varchar(350) | yes | |
| 26 | MODIFIED_DATE | datetime | datetime | yes | |
| 27 | MODIFIED_BY | string | varchar(20) | yes | |
| 28 | NDCID | string | varchar(11) | yes | |
| 29 | FDB_MED_ID | string | varchar(6) | yes | |
| 30 | RX_NORM_ID | string | varchar(20) | yes | |
| 31 | RX_NORM_TYPE | string | varchar(10) | yes | |
| 32 | RCOPIA_ID | string | varchar(20) | yes | |
| 33 | PAT_NOTES | string | varchar(350) | yes | |
| 34 | OTHER_NOTES | string | varchar(350) | yes | |
| 35 | PRESCRIPTION_NOTES | string | varchar(max) | yes | |
| 36 | PROVIDER_CODE | string | varchar(20) | yes | |
| 37 | USER_ID | string | varchar(20) | yes | |
| 38 | PHARMACY_NAME | string | varchar(100) | yes | |
| 39 | PHARMACY_ADDR1 | string | varchar(65) | yes | |
| 40 | PHARMACY_ADDR2 | string | varchar(65) | yes | |
| 41 | PHARMACY_CITY | string | varchar(35) | yes | |
| 42 | PHARMACY_STATE | string | varchar(2) | yes | |
| 43 | PHARMACY_ZIP | string | varchar(10) | yes | |
| 44 | PHARMACY_PHONE | string | varchar(20) | yes | |
| 45 | PHARMACY_FAX | string | varchar(20) | yes | |
| 46 | PHARMACY_NCPDP_ID | integer | int | yes | |
| 47 | SCHEDULE | string | varchar(15) | yes | |
| 48 | BRAND_TYPE | string | varchar(10) | yes | |
| 49 | PREPARER_USER_ID | string | varchar(20) | yes | |
| 50 | PREPARER_NAME | string | varchar(75) | yes | |
| 51 | PROVIDER_NAME | string | varchar(75) | yes | |
| 52 | PROVIDER_NPID | string | varchar(35) | yes |