| 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 |