This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / VMP Tables | |
Fact table delivering detailed insight for text messages, including various events and associated values.
| Column | Description | Message |
|---|---|---|
| TenantID | int This field is for future use only, and is currently set to 0. |
|
| BatchId | int This field is for future use only, and is currently set to 0. |
|
| Id | int Displays a unique numeric id for this text message. |
26863 |
| ConversationID | int Displays the unique numeric id for the conversation of which this text message is a part. |
12067 |
| ExternalTransactionID | varchar Displays the external transaction id. |
|
| ClientID | varchar Displays the client id. |
Engage |
| EventID | varchar Displays the event id. |
2d9fc053-62dd-37e8-bcd9-e13a3bc5cf04 |
| InTime | timestamp Displays the date and time that this text message appeared. |
2017-12-09 07:51:26 |
| CreatorUserID | int Displays the numeric user id of the creator of the message. |
168 |
| Severity | int Displays an integer value representing the severity or priority of the message. |
0 |
| RouteToVS | tinyint Displays 1 if the message is routed through the Vocera Voice Server. |
1 |
| CreatorEndPoint | varchar Displays the creator endpoint. |
15 |
| SenderDeviceRoute | int Displays the sender device route. |
|
| MCR | varchar Displays whether the message has multiple choice responses. Valid values are Y and N. |
N |
| RowCreatedTS | timestamp Displays the date and time on which this table row was created. |
2017-12-05 23:43:26 |
This guide last modified:
2021-04-23 06:46.
.