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