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