Database Schema Tables / Vocera Voice Server Fact Tables |
Stores information for VMI alerts.
Column | Description | Example |
---|---|---|
TxDate | date Stores the date of an event, accurate to the day. |
2017-10-08 |
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. |
1507514375333 |
messageInitiatedAt | datetime Stores the date and time of the message initiation event, accurate to the second. |
2017-10-08 21:40:12 |
txdatetime | datetime Stores the date and time of the event, accurate to the second. |
2017-10-08 18:59:35 |
MessageId | bigint The VMI message id. |
1 |
ClientId | varchar The VMI client id. |
VMILoad |
MessageText | varchar The VMI message text. |
Test message for TestUser1. |
priority | varchar Specifies the VMI message priority (Normal, High, Urgent). |
Normal |
priorityId | int Specifies the VMI message priority id (0 = normal, 1 = high, 2 = urgent). |
0 |
RecipientType | varchar Specifies which type of entity received the message (for example: User, Group). |
User |
recipientSite | varchar In a multi-site installation, the column specifies the Vocera site with which the recipient is associated. In a single-site installation, this value is null. |
VCSLoadSite |
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. |
JohnSmith |
recipientU_id | varchar Specifies the internal Vocera Voice Server id of the message recipient. |
u-jsmith |
recipientDisplayName | varchar Specifies the display name (LastName, FirstName) of the message recipient. |
Smith, John |
ActionType | varchar Specifies the action type (for example: Accepted, Delivered, Rejected) |
Accepted |
Actiondetail | text Specifies the details of the action (for example, the reason why the alert was rejected). |
User is not on network |
Response | longtext The alert response (for example: CallBack, Ok, Busy, Cancel). |
CallBack |
receiveruserdepartments | varchar Specifies the user departments. |
g-tech_support |
receivergroupDepartments | varchar Specifies the group departments. |
g-testgroup |
DestinationType | varchar Specifies the destination type (for example: User, Group). |
User |
DestinationName | varchar Specifies the destination name. |
Jane Doe |
destinationU_id | varchar Specifies the destination name userid. |
u-jdoe |
DestinationSite | varchar In a multi-site installation, the column specifies the Vocera site with which the destination is associated. In a single-site installation, this value is null. |
MySiteName |