UACI_XSessResponse

The UACI_XSessResponse table is part of the runtime environment tables. This table is used for cross-session response tracking.

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 that is 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 that you want to include when you are 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.