| Database Schema Tables / VMP Tables | |
Dimension table delivering detailed insight into VMP distribution lists, and into Vocera Voice Server groups if the Vocera Voice Server is synchronized with VMP.
| Column | Description | Example |
|---|---|---|
| TenantID | int This field is for future use only, and is currently not defined. |
|
| BatchId | int This field is for future use only, and is currently not defined. |
|
| Id | int Displays the internal VMP id for the distribution list. |
17 |
| Name | varchar Displays the name of the distribution list. |
1201 |
| VoceraId | varchar Displays the internal Vocera Voice Server group id. This is populated only when a distribution list is created to map with a Vocera Voice Server group. If the distribution list is created from VMP, this value is null. |
g-1201 |
| SiteId | int Displays the site id for the distribution list. This is populated only when a distribution list is created to map with a Vocera Voice Server group. If the distribution list is created from VMP, this value is null. |
3 |
| OnCallEnabled | tinyint Displays 1 if on-call is enabled, and 0 otherwise. |
0 |
| OnCallMinUsers | int The minimum number of on-call users. |
1 |
| OnCallMaxUsers | int The maximum number of on-call users. |
1 |
| Type | varchar Displays the distribution list type (R for regular or E for escalation). |
R |
| EscDeliveryRoute | varchar Displays the delivery route after a call escalation (A for all users or V for visible users only). |
A |
| Hidden | tinyint Displays 1 if the distribution list is hidden, and 0 otherwise. |
0 |