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 |