Required fields in the detailed contact history table
The detailed contact history table for each audience level in the
Campaign
system database must minimally contain the following fields:
Required fields in the detailed contact history table
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
Copyright IBM Corporation 2012. All Rights Reserved.