UACI_XSessResponse

One instance of this table for each audience level must exist in the contact and response history data source available for Interact cross-session response tracking.

Column	Type	Description
SeqNumber	bigint	Identifier for the row of data. The CrossSessionResponse service processes all records in the SeqNumber order.
ICID	bigint	Interactive channel ID
AudienceID	bigint	The audience ID for this audience level. The name of this column must match the audience ID defined in Campaign. The sample table contains the column CustomerID.
TrackingCode	varchar(64)	The value passed by UACIOfferTrackingCode parameter of the postEvent method.
TrackingCodeType	int	The numeric representation of the tracking code. The value must be a valid entry in the UACI_TrackingType table.
OfferID	bigint	The offer ID as defined in Campaign.
ResponseType	int	The response type for this record. The value must be a valid entry in the UA_UsrResponseType table.
ResponseTypeCode	varchar(64)	The response type code for this record. The value must be a valid entry in the UA_UsrResponseType table.
ResponseDate	datetime	The date of the response.
Mark	bigint	The value of this field identifies the state of the record. 1 — In process 2 — Successful NULL — Retry -1 — Record has been in the database for more than purgeOrphanResponseThresholdInMinutes minutes. As part of the database administrator's maintenance of this table, you can check this field for records that are not being matched, that is, all records with value of -1. All records with value 2 are automatically removed by the CrossSessionResponse service.
UsrDefinedFields	char(18)	Any custom fields you want to include when matching offer responses to the contact and response history. For example, if you want to match on a promotional code, include a promotional code user defined field.