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 Unica 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 Unica 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 Unica 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. It is applicable when “Override SQL” configuration is used. In this case, the matching query defined by user is used rather than the system generated SQL. Random Big Integer value – It is applicable when “Use System generated SQL” is set or default matching query is used. System updates the records to be processed with a unique big integer value to identify the records to be processed by that thread. 2 - Successful. It is applicable when contact history match is found and log response is executed successfully. NULL - New Records 0 - Retry. It is applicable when contact history match is not found and the record is in database for less than `purgeOrphanResponseThresholdInMinutes` minutes. -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.