01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
PACKAGE_NDC→NDC_PACKAGES.PACKAGE_NDCACCOUNT→PATIENTS.ACCOUNTDOSE_FORM→MMT_DOSE_FORMS.DOSE_FORMOFFICE_LOCATION→LOCATIONS.OFFICE_LOCATIONSUPPLY_CODE→V_MMT_STOCK_SUPPLY.SUPPLY_CODE
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | STOCK_ID PK | integer | int | no | |
| 2 | PACKAGE_NDC | string | varchar(15) | no | |
| 3 | ORDER_DATE | datetime | datetime | no | |
| 4 | LOT_ID | string | varchar(50) | no | |
| 5 | SERIAL_NUMBER | string | varchar(50) | yes | |
| 6 | EXP_DATE | datetime | datetime | no | |
| 7 | UNIT_OF_MEASURE | string | varchar(10) | no | |
| 8 | QUANTITY | integer | int | no | |
| 9 | STRENGTH | decimal | decimal(6,2) | no | |
| 10 | DOSE_FORM | integer | int | no | |
| 11 | ORDER_USER_ID | string | varchar(20) | no | |
| 12 | STOCK_OPEN | boolean | bit | no | |
| 13 | STOCK_DEPLETED | boolean | bit | no | |
| 14 | OFFICE_LOCATION | string | varchar(20) | no | |
| 15 | CONTROL_NUMBER | string | varchar(50) | yes | |
| 16 | SUPPLY_CODE | string | varchar(10) | yes | |
| 17 | ACCOUNT | string | varchar(12) | yes |