v_dimusers

The single distinct view of users from VMP and the Vocera Voice Server.

Table 1. v_dimusers table
Column	Description	Example
Id	`varchar` For Vocera Voice Server users, this is the Vocera Voice Server internal id. For standalone VMP users, this is the VMP internal id. For Vocera Secure Texting users, this id is negative.	`u-jsmith`
Name	`varchar` The user name.	`Smith, John`
FirstName	`varchar` The user's first name.	`John`
LastName	`varchar` The user's last name.	`Smith`
UserName	`varchar` The user's username.	`JohnSmith`
siteId	`varchar` The id for the user's site.	`s-mysitename`
userType	`varchar` The user type (Ordinary User or Address Book Entry).	`Ordinary User`
isDeleted	`tinyint` Whether the user has been deleted (1=yes, 2=no).	`0`