Required fields in the detailed contact history table
The detailed contact 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 |
|
No |
TreatmentInstID |
bigint |
8 |
No |
No |
ContactStatusID |
bigint |
8 |
Yes |
No |
ContactDateTime |
datetime |
8 |
Yes |
No |
UpdateDateTime |
datetime |
8 |
Yes |
No |
DateID |
bigint |
8 |
No |
No |
TimeID |
bigint |
8 |
No |