| 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 |