This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / VMP Tables | |
This table is the real source for all text message activity in Vocera Voice Server, and it contains VMP text messages, email messages, and desktop messages. The data in this table is populated every five minutes from all other tables.
| Column | Description | Example |
|---|---|---|
| conversationId | int Displays the conversation id. This id is used for all messages in a conversation. |
12167 |
| textMessageId | int Displays the unique id for a specific text message in a conversation. |
26860 |
| inTime | timestamp Displays the date and time of the message arrival. |
2017-12-09 07:51:26 |
| sourceUserId | varchar The internal Vocera Voice Server user id. |
u-jsmith |
| targetUserId | varchar The userid of the message recipient. |
u-jdoe |
| sourceUser | varchar The name of the message sender. |
John Smith |
| targetUser | varchar The name of the message recipient. |
Jane Doe |
| sourceDeviceTypeId | varchar The type id of the device from which the message was sent. |
3 |
| targetDeviceTypeId | int The type id of the device on which the message was received. |
8 |
| targetDeviceType | varchar The name of the device type from which the message was sent. Examples include Apple Push Notification Service, Vocera Smartphone Client, and Vocera Secure Texting. |
Apple Push Notification Service |
| sourceDeviceType | varchar The name of the device type on which the message was received. Examples include VMP_SMARTPHONE, VMP_WEBCONSOLE, and VOCERA (for badges). |
VMP_SMARTPHONE |
| severityId | int Displays the severity/priority id. This is one of 0 (normal), 1 (high), or 2 (urgent). |
0 |
| severity | varchar Displays the severity/priority id. This is one of normal, high, or urgent. |
normal |
| sourceUserVoceraId | varchar The internal Vocera Voice Server user id. Similar to the sourceUserId field. |
u-jsmith |
| targetSiteId | varchar Displays the site id of the message recipient. |
s-mysitename |
| sourceSiteId | varchar Displays the site id of the message sender. |
s-myothersitename |
| targetSite | varchar Displays the site name of the message recipient. |
My Site Name |
| sourceSite | varchar Displays the site name of the message sender. |
My Other Site Name |
| genericSourceDeviceTypeId | varchar The generic type id of the message sender's device. Examples include smartphone and web_console. |
smartphone |
| genericTargetDeviceTypeId | varchar The generic type id of the message recipient's device. Examples include smartphone and web_console. |
badge |
| genericSourceDeviceType | varchar The generic type name of the message sender's device. Examples include Smartphone and Web Console. |
Smartphone |
| genericTargetDeviceType | varchar The generic type name of the message recipient's device. Examples include Smartphone and Web Console. |
Badge |
| groupId | varchar The id of the group that the message recipient belongs to. This is populated only when a message is sent to a VMP distribution list. If the distribution list is a Vocera Voice Server group, this is the internal Vocera Voice Server group id. |
g-qa |
| groupName | varchar The Vocera Messaging Platform distribution list name. |
Quality Assurance |
| Userdepartment | varchar The department that the user belongs to. |
g-tech_support |
| GroupDepartment | varchar The department that the group belongs to. |
g-engineering |
| TypeOfMessage | int The message type. Possible values are 0 for VMP messages, 1 for desktop messages (messages sent from the Vocera Voice Server user console), and 2 for email messages (email sent to the Vocera Voice Server that will be delivered to the Badge/VCS client). |
0 |
This guide last modified:
2021-04-23 06:46.
.