dimvmpdistributionlists

Dimension table delivering detailed insight into VMP distribution lists, and into Vocera Voice Server groups if the Vocera Voice Server is synchronized with VMP.

Table 1. dimvmpdistributionlists table
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