Database Details / Vocera Usage Data |
The users table stores data about badge users. This data can be entered and edited via the Users screen in the Vocera Voice Server Administration Console or the Basic Information screen of the Vocera Voice 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.
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 Voice 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. |
varchar(100) default NULL Specifies the user's email address. |