Unica Interact Contact and Response History Tables

When you install the Unica Interact design time server, you also run a SQL scripts to set up the required tables in your data source that Unica Interact needs to track contact and response history data. This document provides a data dictionary describing the structure and content of the contact and response history tables.

UACI_XSessResponse

This table is a staging table for cross-session responses coming in through the system. Because a cross-session response needs additional processing, the client thread that handles the posted event does the minimum, and that is to pass the response to a service which just logs to this table. A background thread will query against this table, and reconcile accordingly. Any processed records will be removed from the UACI_XSessResponse table from that same background thread.

Field Type Length Null? Description
SeqNumber INT64 false Unique ID for a record in this table. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values.
ICID INT64 false Unique ID for the interactive channel. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values.
CustomerID INT64 false Audience ID for the audience level Customer.
TrackingCode VARCHAR 64 false A code submitted by CFS to represent the treatment to which the response should be associated.
TrackingCodeType INT32 false The type of TrackingCode submitted by the CFS (such as TreatmentCode, OfferCode, alternateCode). Must be 1,2 and up.
OfferID INT64 true Unique ID of an offer. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values.
ResponseType INT32 false A type that indicates whether this is an accept or reject. Valid values are Undefined(0), Accept(1), Reject(2).
ResponseTypeCode VARCHAR 64 true Additional code to distinguish the user-defined response type code to which this response is associated. For valid values, see ResponseTypeCode in the UA_UsrResponseType table in the Unica Campaign System Tables guide.
ResponseDate DATETIME false Timestamp of the response.
Mark INT64 true A field used by the system to indicate a state so that the system knows which records to process. Valid values are NULL, -1, 0, 2.
UserDefinedFields CHAR 18 true This field represents an arbitrary field customizable by the user. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values

UACI_CRHTAB_Ver

Contains the version information of the current Interact CH/RH tables installation.

Field Type Length Null? Description
VersionID INT64 false pk, unique id of version table. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values.
VersionNumber VARCHAR 50 false Full version (major, minor, point, and build)
Parameters VARCHAR 255 false Optional parameters. This string value is currently not used and is here for future use.
CreateDate DATETIME false The date when the Interact CH/RH tables were installed.