| Database Schema Tables / Summary Tables | |
This summary table aggregates the accepted, declined and total data counts, grouped by site, unit, severity, and interrupt source type(interrupt type).
| Column | Description | Example |
|---|---|---|
| TxDate | date The date of the aggregated data. |
2017-11-14 |
| Site | varchar The site or facility from which the data was collected. |
MYHOSPITAL |
| Unit | varchar The unit from which the data was collected. |
06PP |
| severity | varchar The severity of the event (for example: low, red alarm, hard inop). |
low |
| interrupt_type | varchar The event type (for example: NURSE CALLS, ORDER, PATIENT MONITOR, LAB TEST). |
NURSE CALLS |
| accept | bigint The number of accepted events. |
2 |
| decline | bigint The number of declined events. |
1 |
| Total | bigint The total number of events. |
39 |