Required fields in the response history table
The response history table for each audience level in the
Campaign
system database must minimally contain the following fields:
Required fields in the response history table
Key
Column Name
Data Type
Length
Allow Nulls
Yes
Identifier for audience level.
numeric or text
No
Yes
TreatmentInstID
bigint
8
No
Yes
ResponsePackID
bigint
8
No
No
ResponseDateTime
datetime
8
No
No
WithinDateRangeFlg
int
4
Yes
No
OrigContactedFlg
int
4
Yes
No
BestAttrib
int
4
Yes
No
FractionalAttrib
float
8
Yes
No
CustomAttrib
float
8
Yes
No
ResponseTypeID
bigint
8
Yes
No
DateID
bigint
8
Yes
No
TimeID
bigint
8
Yes
No
DirectResponse
int
4
Yes
Each response history table you create for a new audience level should have a foreign key constraint on the
UA_Treatment
table's
TreatmentInstID
field.
Copyright IBM Corporation 2012. All Rights Reserved.