dimusers

Dimension table delivering detailed associativity for Vocera Voice Server user details.

Table 1. dimusers table
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