v_dimgroupsdepartments

This view maps Vocera Voice Server internal group ids to VMP distribution list internal ids and department mappings.

Table 1. v_dimgroupsdepartments
Column	Description	Example
groupId	`bigint` The unique group id.	`4948`
vmpId	`bigint` The VMP id.	`7`
name	`varchar` The group name.	`Support Test`
type	`varchar` The group type.	`R`
siteName	`varchar` The site name for the group.	`MySiteName`
siteId	`varchar` The id of the group's site.	`s-mysitename`
isDeleted	`tinyint` Whether the group has been deleted (1=yes, 2=no).	`0`
departments	`varchar` The comma-separated list of internal Vocera Voice Server department ids.	`g-2100,g-21000`