Database Schema Tables / Summary Tables |
This summary table aggregates daily data from the vmialerts table: total VMI alert counts grouped by severity, user Vocera Voice Server site, and user department.
Column | Description | Example |
---|---|---|
Txdate | date The date of the aggregated data. |
2017-10-08 |
Site | varchar In a multi-site installation, the column specifies the Vocera site with which the recipient is associated. |
MySiteName |
Unit | varchar The unit with which the recipient user is associated. This is a comma-separated list of internal group ids. |
g-engineering0 |
clientID | varchar The VMI client ID. |
VMILoad |
Severity | varchar The severity of the alerts (normal, high, urgent). |
normal |
TotalVMIAlerts | bigint The total number of VMI alerts. |
44 |