01Relates to the patient
STOCK_ID + STOCK_LINE_NO matches MMT_STOCK_DEPLETIONS.STOCK_ID + MMT_STOCK_DEPLETIONS.STOCK_LINE_NO on a row of MMT_STOCK_DEPLETIONS that relates to the patient
Single-patient export: the patient's rows.
02References
ACTION→MMT_STOCK_ACTIONS.ACTIONSTOCK_ID,STOCK_LINE_NO→MMT_STOCK_DEPLETIONS.STOCK_ID,STOCK_LINE_NOFILL_DATE,BOTTLE_ID→MMT_DISPENSING_BOTTLES.FILL_DATE,BOTTLE_IDOFFICE_LOCATION→LOCATIONS.OFFICE_LOCATIONOVERFILL_FILL_DATE,OVERFILL_BOTTLE_ID→MMT_DISPENSING_BOTTLES.FILL_DATE,BOTTLE_IDPUMP_ID→MMT_PUMPS.PUMP_IDRECEIVE_OFFICE_LOCATION→LOCATIONS.OFFICE_LOCATIONRO_ID,RO_LINE_NO→MMT_REPLENISH_ORDER_DETAILS.RO_ID,RO_LINE_NOSEND_OFFICE_LOCATION→LOCATIONS.OFFICE_LOCATION
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | BOTTLE_ID PK | integer | int | no | |
| 2 | FILL_DATE PK | datetime | smalldatetime | no | |
| 3 | ACTION_DATE PK | datetime | datetime | no | |
| 4 | OVERFILL_BOTTLE_ID | integer | int | yes | |
| 5 | ACTION | integer | int | no | |
| 6 | ACTION_USER_ID | string | varchar(20) | no | |
| 7 | BOTTLE_AMOUNT | integer | int | no | |
| 8 | PUMP_ID | string | varchar(20) | yes | |
| 9 | STOCK_ID | integer | int | yes | |
| 10 | STOCK_LINE_NO | integer | int | yes | |
| 11 | OVERFILL_FILL_DATE | datetime | smalldatetime | yes | |
| 12 | COMMENTS | string | varchar(1000) | yes | |
| 13 | RO_ID | integer | int | yes | |
| 14 | RO_LINE_NO | integer | int | yes | |
| 15 | SEND_OFFICE_LOCATION | string | varchar(20) | yes | |
| 16 | RECEIVE_OFFICE_LOCATION | string | varchar(20) | yes | |
| 17 | ORIG_ACTION_DATE | datetime | datetime | yes | |
| 18 | OFFICE_LOCATION | string | varchar(20) | yes |