Database Schema Tables / Vocera Voice Server Dimension Tables |
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.
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 |