| Database Schema Tables / Vocera Voice Server Dimension Tables | |
Dimension table delivering detailed associativity for Vocera Voice Server user details.
| Column | Description | Example |
|---|---|---|
| TenantId | int This field is for future use only, and is currently not defined. |
|
| UserId | varchar Displays the internal Vocera Voice Server user id. |
u-jsmith |
| UserName | varchar Displays the user name. |
JSmith |
| FirstName | varchar Displays the user's first name. |
John |
| LastName | varchar Displays the user's last name. |
Smith |
| SiteId | varchar Displays the internal Vocera Voice Server site id. This is the home site for the Vocera Voice Server user. |
s-mysitename |
| UserType | varchar Displays user type (for example: Ordinary User, Address Book Entry). |
Ordinary User |
| ConferenceGroup | varchar Displays the conference group id. |
g-tech_support |
| CostCenters | varchar Displays the cost centers for the user. |
401533 |
| LastUpdateDate | timestamp Displays the last update date for the user. |
2017-12-18 11:04:43 |
| AddressBookType | varchar Displays whether address book is a place or a person. |
|
| DeletedFlag | tinyint Displays 1 if deleted or else 0. |
0 |