To define the UACI_ICBatchOffers table
If you use the default offers or score override tables, you must ensure that all offer codes exist in the deployment. If you know that all offers you use in the default offers or score override tables are used in your treatment rules, the offers exist in the deployment. However, any offer not used in a treatment rule must be defined in the
UACI_ICBatchOffers
table.
The
UACI_ICBatchOffers
table exists in the
Campaign
system tables.
You must populate the
UACI_ICBatchOffers
table with offer codes used in the default offer or score override tables. The table takes the following format.
Column Name
Type
Description
ICName
varchar(64)
The name of the interactive channel the offer is associated with. If you are using the same offer with two different interactive channels, you must provide a row for each interactive channel.
OfferCode1
varchar(64)
The first part of the offer code.
OfferCode2
varchar(64)
The second part of the offer code, if required.
OfferCode3
varchar(64)
The third part of the offer code, if required.
OfferCode4
varchar(64)
The fourth part of the offer code, if required.
OfferCode5
varchar(64)
The fifth part of the offer code, if required.
Copyright IBM Corporation 2013. All Rights Reserved.