01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
ACCOUNT→PATIENTS.ACCOUNTACTION→MMT_STOCK_ACTIONS.ACTIONSTOCK_ID→MMT_STOCK.STOCK_IDOFFICE_LOCATION→LOCATIONS.OFFICE_LOCATIONRECEIVE_OFFICE_LOCATION→LOCATIONS.OFFICE_LOCATIONRO_ID,RO_LINE_NO→MMT_REPLENISH_ORDER_DETAILS.RO_ID,RO_LINE_NOSEND_OFFICE_LOCATION→LOCATIONS.OFFICE_LOCATIONSTATION_ID→MMT_DISPENSING_STATIONS.STATION_IDMOUNT_STOCK_ID,MOUNT_STOCK_LINE_NO→MMT_STOCK_DEPLETIONS.STOCK_ID,STOCK_LINE_NOORIG_STOCK_ID,ORIG_STOCK_LINE_NO→MMT_STOCK_DEPLETIONS.STOCK_ID,STOCK_LINE_NO
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | STOCK_ID PK | integer | int | no | |
| 2 | STOCK_LINE_NO PK | integer | int | no | |
| 3 | ACTION_DATE | datetime | datetime | no | |
| 4 | ACTION | integer | int | no | |
| 5 | QUANTITY | decimal | decimal(10,2) | no | |
| 6 | USER_ID | string | varchar(20) | no | |
| 7 | COMMENTS | string | varchar(1000) | yes | |
| 8 | STATION_ID | string | varchar(20) | yes | |
| 9 | MOUNT_STOCK_ID | integer | int | yes | |
| 10 | MOUNT_STOCK_LINE_NO | integer | int | yes | |
| 11 | RO_ID | integer | int | yes | |
| 12 | RO_LINE_NO | integer | int | yes | |
| 13 | SEND_OFFICE_LOCATION | string | varchar(20) | yes | |
| 14 | RECEIVE_OFFICE_LOCATION | string | varchar(20) | yes | |
| 15 | OFFICE_LOCATION | string | varchar(20) | yes | |
| 16 | ACCOUNT | string | varchar(12) | yes | |
| 17 | ORIG_STOCK_ID | integer | int | yes | |
| 18 | ORIG_STOCK_LINE_NO | integer | int | yes |