users

The users table stores data about badge users. This data can be entered and edited via the Users screen in the Vocera server Administration Console or the Basic Information screen of the Vocera server User Console.

Other tables in the Vocera Report Server schema contain a UserID column that corresponds to the UserID column in this table. Therefore, you can write queries that return data about badge users in other contexts.

For example, the following query returns data about badge users in the context of a report about broadcasts:

select * from broadcasts, users 
where broadcasts.UserID = users.UserID

This table has a unique key based on the UserID column.

Table 1. users table
Column	Description
UserID	`varchar(70) NOT NULL default ''` The UserID column specifies a user ID entered via the Administration Console or the User Console on the Vocera server. Example value: ALINCOLN
UserName	`varchar(255) NOT NULL default ''` The UserName column stores the value of the FirstName column, a space, and the value of the LastName column. Example value: ABRAHAM LINCOLN
LastName	`varchar(50) NOT NULL default ''` The LastName column stores the user's last name. Example value: LINCOLN.
FirstName	`varchar(50) NOT NULL default ''` The FirstName column stores the user's first name. Example value: ABRAHAM
Departments	`varchar(100) default NULL` The Departments column lists department groups that the user belongs to. Multiple department names are separated by a plus sign (+). Example values: Engineering, Admin+Marketing+Sales
Site	`varchar(50) default NULL` The Site column lists the site ID (not the site name) of each site the user is associated with. Example value: s-global
CostCenters	`varchar(100) default NULL` The CostCenters column specifies the user's cost centers. Multiple cost centers are separated by a plus sign (+). Example values: Engineering, Admin+Marketing+Sales
DeletedFlag	`int(1) unsigned zerofill NOT NULL default '0'` The DeletedFlag column indicates whether a user has been deleted (0 = false). Although the entity may be flagged as deleted, it is not purged from the database because historical data (that is, older report logs) may continue to reference it.
Email	`varchar(100) default NULL` Specifies the user's email address.