Required fields in the response history table
The response history table for each audience level in the
Campaign
system database must minimally contain the fields described in this section.
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 2015. All Rights Reserved.