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:

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



IBM Unica Campaign
 
8.5.0
For more information, see our support and community site: Customer Central