HCL Interact User Tables

When you install the HCL® Interact runtime server, you also run a SQL script to set up the required user tables in your data source that Interact needs to operate. This document provides a data dictionary describing the structure and content of the user tables.

UACI_DefaultOffers

Table that contains the default offers by audience level to consider for serving. This table supports all the whitelist and offer rules columns supported in the UACI_ScoreOverride table.

Field	Type	Length	Null?	Description
AudienceLevel	VARCHAR	64	false	This field is the audience level (eg. Customer, Household) which this record will apply to.
OfferCode1	VARCHAR	64	false	First part of offerCode.
Score	FLOAT		false	The score value to use in the default treatment.
OverrideTypeID	INT32		true	The override type which will indicate whether this record will perform whitelist feature or just an override only feature.
Predicate	VARCHAR	4000	true	The expression logic for the predicate.
FinalScore	FLOAT		true	This field represents the final score to use by the built-in learning. Essentially, it will bypass any intermediate calculations made by the built-in calculator.
CellCode	VARCHAR	64	true	The code of the cell used for reporting.
Zone	VARCHAR	64	true	The name of the zone that this record applies to. If null, any zone applies.
EnableStateID	INT32		true	The enablestate id which tells us whether any advanced rules (predicate) should be applied.

UACI_ScoreOverride

This table contains offers per customer id that are to be either added to the candidate list of treatments, or to override the score of existing treatments, depending on the mode specified in the OverrideTypeID column. This table supports all the features of the Strategy tab but in table form and at the audience id level (Strategy tab is only at the segment level). Additionally, users may add columns to this table; extra column data will be accessible through the learning interface.

Field	Type	Length	Null?	Description
CustomerID	INT64		false	Audience id for the audience level Customer.
OfferCode1	VARCHAR	64	false	First part of an offercode.
Score	FLOAT		false	Explicit score to use in override/whitelist, unless advanced rule is activated.
OverrideTypeID	INT32		true	The override type which will indicate whether this record will perform whitelist feature or just an override only feature.
Predicate	VARCHAR	4000	true	The expression logic for the predicate.
FinalScore	FLOAT		true	This field represents the final score to use by the built-in learning. Essentially, it will bypass any intermediate calculations made by the built-in calculator.
CellCode	VARCHAR	64	true	The code of the cell used for reporting.
Zone	VARCHAR	64	true	The name of the zone that this record applies to. If null, any zone applies.
EnableStateID	INT32		true	The enablestate id which tells us whether any advanced rules (predicate) should be applied.

UACI_BlackList

This is the default table designed to be used for the audience level "Customer". The table contains offers per customerId that are to be suppressed from serving to the client facing system.

Field	Type	Length	Null?	Description
CustomerID	INT64		true	Audience id for the audience level Customer.
OfferCode1	VARCHAR	64	false	First part of an offercode.

UACI_USRTAB_Ver

Contains the version information of the current Interact user tables installation.

Field	Type	Length	Null?	Description
VersionID	INT64		false	PK, unique id of version table.
VersionNumber	VARCHAR	50	false	Full version (major, minor, point, and build).
Parameters	VARCHAR	255	true	Optional parameters. This is currently not utilized and is here for future use.
CreateDate	DATETIME		false	Date when the interact user based tables was installed.