Database Schema Tables / Vocera Voice Server Fact Tables |
Stores data about changes made to the Vocera system.
Column | Description | Example |
---|---|---|
TxMillis | bigint Gives each row in the table a unique identifier. The value represents the number of milliseconds since January 1, 1970 (a date specified for internal use by the report system). Because of the uniqueness constraint, it may not reflect the exact actual date. |
1507550401992 |
TxDateTime | datetime Stores the date and time of an event, accurate to the second. |
2017-10-09 05:00:01 |
TxDate | date Stores the date of an event, accurate to the day. |
2017-10-09 |
UserID | varchar Specifies the user ID of the person who made the change. This value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera Server, unless the user logged in with the built-in login ID Administrator, in which ca |
JSmith |
UserSite | varchar In a multi-site installation, the UserSite column specifies the Vocera site with which the user is associated. In a single-site installation, this value is null. |
MyUserSite |
LoginId | varchar Specifies the login ID of the person who made the change. This value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera Server, unless the user logged in with the built-in login ID Administrator. |
JSmith |
Operation | varchar Specifies the operation that changed the Vocera database. Sample values include: Backup, Update, Create, and Update Conference Group. |
Login Admin Console |
ModifiedEntityType | varchar Specifies the type of the entity that was changed. Sample values include: AddrBook, Group, and User. |
Site |
ModifiedEntityID | varchar Identifies the entity that was changed. For a user, the value is the user ID. For a group, the value is the group name. For an address book entry, the value is the address book entry name. If the Vocera database was not changed, for example, when a Backup |
JSmith |
userUId | varchar Specifies the Vocera Voice Server internal user id of the person who made the change. |
u-jsmith |
userDisplayName | varchar Specifies the user Name (LastName,FirstName) of the person who made the change. This value corresponds to a User Name specified via the Administration Console or the User Console on the Vocera Server, unless the user logged in with the built-in login ID Administrator, in which ca |
Smith, John |
modifiedEntityUId | varchar Specifies the Vocera Voice Server internal id of the entity changed. |
u-jsmith |
modifiedDisplayName | varchar Identifies the entity that was changed. For a user, the value is the user Lastname,User first Name. For a group, the value is the group name. For an address book entry, the value is the address book entry name. If the Vocera database was not changed, for example, when a Backup |
Smith, John |
modifiedEntitySite | varchar Specifies the Vocera site with which the modified entity is associated. |
MyEntitySite |
groupDepartment | varchar Displays the comma-separated Vocera Voice Server internal department ids of the group. This field is populated only if ModifiedEntityType is set to Group. |
g-group_one |
userDepartments | varchar Displays a comma-separated list of the user's Vocera Voice Server internal department ids. |
g-group_one,g-engineering |
groupMembers | varchar Displays a comma-separated list of the Vocera Voice Server internal ids of the members of the group. This field is populated only if ModifiedEntityType is set to Group. |
u-jsmith,u-jdoe |