fctvmimessages

Stores VMI message information.

Table 1. fctvmimessages table
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	`1507525143403`
TxDateTime	`datetime` Stores the date and time of the event, accurate to the second.	`2017-10-08 21:40:12`
TxDate	`date` Stores the date of an event, accurate to the day.	`2017-10-08`
ClientID	`varchar` The VMI client id.	`VMILoad`
DestinationType	`varchar` Specifies which type of entity was sent the message (for example: User, Group).	`User`
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.	`VCSLoadSite`
DestinationID	`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`
DestinationName	`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`
MessageID	`int` Specifies the numeric VMImMessage id.	`10172020`
Priority	`varchar` Specifies the VMI message priority (for example: Normal, High, Urgent).	`Normal`
MessageText	`text` Specifies the message content.	`This is a test message.`
PriorityID	`int` Specifies the VMI message priority id (for example: normal as 0, high as 1, urgent as 2).	`0`
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.