Database Schema Tables / Vocera Voice Server Fact Tables |
Stores data about device DND activity 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. |
1507548410702 |
TxDateTime | date Stores the date and time of an event, accurate to the second. |
2017-10-09 04:26:50 |
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. |
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. |
My Site Name |
DND | int Specifies whether the user has turned DND on (1) or off (0). |
1 |
UserUID | varchar Specifies the Vocera Voice Server internal user id. |
u-jsmith |
UserDisplayName | varchar Specifies the user display name (LastName, FirstName) of the person who made the change. This value corresponds to a User lastname, firstname specified via the Administration Console or the User Console on the Vocera Voice Server, unless the user logged in with the built-in login ID Administrator. |
Smith, John |