dimgroupsdepartments

Dimension table delivering detailed associativity between group and department.

Table 1. dimgroupsdepartments table
Column Description Example
id

int

Specifies the unique id.

7
TenantId

int

This field is for future use only, and is currently not defined.

 
GroupId

varchar

Displays the Vocera Voice Server internal group id.

g-2100_nurse
DepartmentId

varchar

Displays the unique department id.

g-2100
LastUpdateDate

timestamp

Displays the date and time that the group department was last updated.

2017-12-13 19:24:17
DeletedFlag

tinyint

Displays 1 if deleted or else 0.

0