fctvmievent

Stores VMI event information.

Table 1. fctvmievent 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	`1512150680643`
TxDateTime	`datetime` Stores the date and time of the event, accurate to the second.	`2017-12-01 09:51:20`
TxDate	`date` Stores the date of an event, accurate to the day.	`2017-12-01`
ClientID	`varchar` The VMI client id.	`ENGAGE`
EventID	`bigint` The unique VMI event id.	`7443`
EventType	`varchar` Specifies the VMI event type. Supported event types are MessageEvent, CancelEvent, and SystemEvent.	`MessageEvent`
Item1	`varchar` Stores the first item of the log event information.	`Epic:12012017-001`
Item2	`varchar` Stores the second item of the log event information, or blank if this item does not exist.	`21`
Item3	`varchar` Stores the third item of the log event information, or blank if this item does not exist.	`1`
Item4	`varchar` Stores the fourth item of the log event information, or blank if this item does not exist.	`1`
Item5	`varchar` Stores the fifth item of the log event information, or blank if this item does not exist.
Item6	`varchar` Stores the sixth item of the log event information, or blank if this item does not exist.
Item7	`varchar` Stores the seventh item of the log event information, or blank if this item does not exist.
Item8	`varchar` Stores the eighth item of the log event information, or blank if this item does not exist.
Item9	`varchar` Stores the ninth item of the log event information, or blank if this item does not exist.
Item10	`varchar` Stores the tenth item of the log event information, or blank if this item does not exist.