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.
Copyright IBM Corporation 2013. All Rights Reserved.