HCL Interact Contact and Response History Tables

When you install the HCL® Interact design time server, you also run a SQL scripts to set up the required tables in your data source that 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 IBM 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.