01Relates to the patient
reference data (no patient link)
Single-patient export: included in full (reference data).
02References
BOTTLE_ID→MMT_BOTTLE_IDS.BOTTLE_IDOFFICE_LOCATION→LOCATIONS.OFFICE_LOCATIONPUMP_ID→MMT_PUMPS.PUMP_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | BOTTLE_ID PK | integer | int | no | |
| 2 | FILL_DATE PK | datetime | smalldatetime | no | |
| 3 | START_AMOUNT | integer | int | no | |
| 4 | OFFICE_LOCATION | string | varchar(20) | yes | |
| 5 | BOTTLE_ACTIVE | boolean | bit | no | |
| 6 | MOUNTED | boolean | bit | no | |
| 7 | CHECKED_IN | boolean | bit | no | |
| 8 | REMAIN_AMOUNT | integer | int | no | |
| 9 | PUMP_ID | string | varchar(20) | yes | |
| 10 | LAST_MOUNT_DATE | datetime | datetime | yes | |
| 11 | CONTROL_NUMBER | string | varchar(50) | yes | |
| 12 | PRIMED | boolean | bit | yes |