This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / VMP Tables | |
Fact table delivering detailed insight on events and values of text-based conversations. This table is loaded if a VMP source is added or VMP data is migrated.
| Column | Description | Example |
|---|---|---|
| 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 the unique integer id for this conversation. |
|
| Created | timestamp Displays the date and time for this conversation. |
2015-08-27 18:18:23 |
| Activated | timestamp Displays the activation date and time. |
2015-08-27 18:18:23 |
| CreatorUserId | varchar Displays the creator user id. |
11579 |
| ExternalId | varchar Displays the external id. |
2458 |
| ParticipationCondition | varchar Displays the participation condition. |
1 |
| MassConversation | tinyint Displays 1 if this is a mass conversation or else 0. |
0 |
| Escalated | tinyint Displays 1 if this conversation is being escalated or else 0. |
1 |
| EscalationFinished | tinyint Displays 1 if the escalation is finished or else 0. |
1 |
| IsTerminated | tinyint Displays 1 if the text is terminated or else 0. |
1 |
| LastMessageReceived | timestamp Displays the date and time that the last message was received. |
2017-05-03 09:54:01 |
| RowCreatedTS | timestamp Displays the date and time that this table row was created. |
2017-12-05 23:43:18 |
This guide last modified:
2021-04-23 06:46.
.