Unica Interact User Tables

When you install the Unica Interact runtime server, you also run a SQL script to set up the required user tables in your data source that Unica 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.
Suppression Count INT32 false This field is for Exclusive offer suppression. The field is located on the Strategy page. Once you save the Suppression Count in the Strategy Advance Option for rule then the 'Suppression Count' value is updated in this column, By default the value is 0.
Max Score INT32 false By default the value is false(0) and in the Strategy once you select Max score for rule and save the Strategy then the value becomes true(1).

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.
Suppression Count INT32 false This field is for Exclusive offer suppression. The field is located on the Strategy page. Once you save the Suppression Count in the Strategy Advance Option for rule then the 'Suppression Count' value is updated in this column, By default the value is 0.
Max Score INT32 false By default the value is false(0) and in the Strategy once you select Max score for rule and save the Strategy then the value becomes true(1).

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.