dimgroups

Dimension table delivering group details, including hierarchy details and alias group names. Vocera Voice Server groups, departments, and sub-departments are populated in this table.

Table 1. dimgroups table
Column	Description	Example
TenantId	`int` This field is for future use only, and is currently not defined.
GroupId	`varchar` Displays the unique group id.	`g-1201`
GroupName	`varchar` Displays the group name.	`1201`
GroupType	`varchar` Displays the group type: Ordinary, Department, or Others.	`Ordinary`
GroupScheduleType	`varchar` Displays the group schedule type: Sequential or Others.	`Sequential`
Site	`varchar` Displays the internal site id of the group.	`s-mysitename`
MemberDomainGroup	`varchar` Displays the Vocera Voice Server internal group id for the domain member.	`g-nurses`
DeviceManagerGroup	`varchar` Displays the Vocera Voice Server internal group id for the device manager.	`g-nursing_management`
ManagerGroup	`varchar` Displays manager group details.	`g-manager`
AliasGroupName	`varchar` Displays the alias (anonymous) group name.	`Tech Support`
SpokenMemberGroupName	`varchar` Displays the group name of the user who has spoken for the required event.	`A Technical Support Engineer`
Department	`varchar` Not in use in this version.
CostCenters	`varchar` Stores a value that identifies the group's cost center (typically used for accounting purposes).
LastUpdateDate	`timestamp` Displays the date and time that the group was last updated.	`2018-01-01 19:16:13`
DeletedFlag	`tinyint` Displays 1 if deleted or else 0.	`0`