Database Schema Tables / Vocera Voice Server Fact Tables |
Stores messages/alerts sent through VMI to the Vocera Voice Server.
Column | Description | Message |
---|---|---|
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. |
1507514309777 |
TxDateTime | datetime Stores the date and time of the event, accurate to the second. |
2017-10-08 18:58:29 |
TxDate | date Stores the date of an event, accurate to the day. |
2017-10-08 |
ClientID | varchar The VMI client id. |
VMILoad |
MessageID | int The VMI message id. |
10172022 |
RecipientType | varchar Specifies which type of entity received the message. Examples include User and Group. |
User |
RecipientSite | varchar In a multi-site installation, the column specifies the Vocera site with which the recipient is associated. |
MyRecipientSite |
RecipientID | varchar For users, this is the user id specified in the Vocera Voice Server Administration Console. For groups, this is the actual group name. |
JSmith |
RecipientName | varchar For users, this specifies the name of the message recipient in Firstname Lastname format. For groups, this is the name of the group. |
John Smith |
ActionType | varchar Specifies the action type. Possible values are Response, Rejected, Dead, Delivered, DeleteMessage, CallStarted, CallEnded, and Accepted. |
Delivered |
ActionDetail | text Specifies the action details, if any. |
User is not logged in |
recipientU_Id | varchar Specifies the internal Vocera Voice Server id of the message recipient. |
u-jsmith |
recipientDisplayName | varchar Specifies the display name (last name, first name) of the message recipient. |
Smith, John |
receiverUserDepartments | varchar Specifies the user departments. This is a comma-separated list if the user is part of multiple departments. |
g-tech_support |
receiverGroupDepartments | varchar When RecipientType is Group, this is populated with a comma-separated list of group department ids. If the recipient group has no departments, this is set to Unknown. |