Score override table

The score override table must exist in your production profile database. You can create a sample score override table, UACI_ScoreOverride by running the aci_usrtab SQL script against your profile database.

The aci_usrtab SQL script is located in the ddl directory in your runtime environment installation directory.

You must define the AudienceID, OfferCode1, and Score fields for each row. The values in the other fields are optional to constrain your individual offer assignments further or provide score override information for the built-in learning.


Name	Type	Description
`AudienceID`	varchar(64)	(Required) The name of this column must match the name of the column defining the audience ID in Unica Campaign. The sample table created by the `aci_usrtab` ddl file create this column as the `CustomerID` column. If your audience ID consists of multiple columns, you can add them to this table. Each row must contain the audience ID to which you assign the individual offer, for example, `customer1`. For best performance, you should create an index on this column.
OfferCode1	varchar(64)	(Required) The offer code for the offer. If your offer codes are made of multiple fields, you can add the additional columns, for example `OfferCode2` and so on. If you are adding this offer to provide an individual offer assignment, you must add this offer to the `UACI_ICBatchOffers` table.
Score	float	A number to define the marketing score for this offer assignment.
OverrideTypeID	int	If set to `0` or null (or any number other than 1), use any data for the offer only if the offer exists in the candidate list of offers. In general, use `0` to provide score overrides. You must provide a cell code If set to `1`, if the offer does not exist in the candidate list of offers, add this offer to the list as well as using any score data for the offer. In general, use `1` to provide individual offer assignments.
Predicate	varchar(4000)	You can enter expressions in this column as for advanced options for treatment rules. You can use the same variables and macros available to you when writing advanced options for treatment rules. The behavior of this column depends on the value in the `EnableStateID` column. If the `EnableStateID` is `2`, this column works the same as Consider this rule eligible if the following expression is true option in the advanced options for treatment rules to constrain this offer assignment. This column must contain a boolean expression, and resolve to true to include this offer. If you accidentally define an expression that resolves to a number, any non-zero number is considered true and zero is considered false. If the `EnableStateID` is `3`, this column works the same as Use the following expression as the marketing score option in the advanced options for treatment rules to constrain this offer. This column must contain an expression that resolves to a number. If the `EnableStateID` is `1`, Unica Interact ignores any value in this column. Note: To assign score to an offer, the following sequence is considered. Final score field Score [column] Predicate column If you want to assign score from the predicate column, then you must leave the score column as null.
FinalScore	float	A number to override the final score used to order the final list of returned offers. This column is used if you have enabled the built-in learning module. You can implement your own learning to use this column.
CellCode	varchar(64)	The cell code for an interactive segment to which you want to assign this offer. If your cell codes are made of multiple fields, you can add the additional columns. You must provide a cell code if `OverrideTypeID` is 0 or null. If you do not include a cell code, the run time environment ignores this row of data. If the `OverrideTypeID` is 1, you do not have to provide a cell code in this column. If you do not provide a cell code, the runtime environment uses the cell code defined in the `DefaultCellCode` property for this audience level and table for reporting purposes.
Zone	varchar(64)	The name of the zone to which you want this offer assignment to apply. If NULL, this applies to all zones.
EnableStateID	int	The value in this column defines the behavior of the `Predicate` column. 1 - Do not use the `Predicate` column. 2 - Use `Predicate` as a boolean to filter the offer. This follows the same rules as the Consider this rule eligible if the following expression is true advanced option in a treatment rule. 3 - Use `Predicate` to define the marketer's score. This follows the same rules as the Use the following expression as the marketing score advanced option in a treatment rule. Any row where this column is Null or any value other than 2 or 3 ignores the `Predicate` column.
LikelihoodScore	float	This column is used only to influence built-in learning. You can add this column with the `aci_scoringfeature` ddl.
AdjExploreScore	float	This column is used only to influence built-in learning. You can add this column with the `aci_scoringfeature` ddl.
Suppression Count	int	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	int	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).