v_dimgroups

This view gets group data from Vocera Voice Server groups and VMP distribution lists.

Table 1. v_dimgroups table
Column Description Example
groupId

varchar

The internal group id for Vocera Voice Server groups, and the internal distribution list id for VMP distribution lists.

g-everyone-s-cupertino
vmpId

bigint

The VMP id for the group.

5062
name

varchar

The group name.

Everyone-Cupertino
Type

varchar

The group type (for example: Ordinary, Department, Subdepartment).

Ordinary
siteName

varchar

The home site for the group.

Community 1
siteId

varchar

The id of the group's site.

s-community1
isDeleted

tinyint

Whether the group has been deleted (1=yes, 0=no).

0
ActualGroupName

varchar

The actual group name.

2100 Nurse
GroupDepartment

varchar

A comma-separated list of internal Vocera Voice Server department ids.

g-2100