This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / VMP Tables | |
Fact table delivering user details and events associated with text messages.
| 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 numeric id for this user interaction. |
36122 |
| InTime | timestamp Displays the date and time that the message came in. |
2017-12-09 07:52:16 |
| TextMessageID | int Displays the unique numeric text message id. |
26859 |
| UserID | int Displays the numeric user id. |
226 |
| SentTime | timestamp Displays the date and time that the message was sent. |
2017-12-09 07:57:22 |
| FailTime | timestamp If the message failed to send, the date and time of the failure. |
2017-12-09 07:57:22 |
| FailMessage | varchar Displays the reason why the message failed, if applicable. |
|
| OpenTime | timestamp Displays the date and time that the message was opened, if applicable. |
2017-12-09 07:57:32 |
| DeliveryTime | timestamp Displays the date and time that the message was delivered, if applicable. |
2017-12-09 07:57:22 |
| ResponseID | int Displays the numeric id of the responder. |
3299 |
| ResponseTime | timestamp Displays the date and time that the message was responded to, if applicable. |
2017-12-09 07:57:39 |
| CancelTime | timestamp Displays the date and time that the message was canceled, if applicable. |
2017-12-09 07:57:32 |
| Expired | varchar Displays the date and time that the message availability expired, if applicable. |
|
| RowCreatedTS | timestamp Displays the date and time that the table row was created. |
2017-12-10 23:43:59 |
This guide last modified:
2021-04-23 06:46.
.