Required fields in the contact history table

The contact history table for each audience level in the Campaign system database must minimally contain the fields described in this section.

Required fields in the contact history table
Key	Column Name	Data Type	Length	Allow Nulls
Yes	Identifier for audience level	numeric or text		No
Yes	CellID	bigint	8	No
Yes	PackageID	bigint	8	No
No	ContactDateTime	datetime	8	Yes
No	UpdateDateTime	datetime	8	Yes
No	ContactStatusID	bigint	8	Yes
No	DateID	bigint	8	Yes
No	TimeID	bigint	8	Yes

Campaign is shipped with additional fields (ValueBefore and UsageBefore) in the UA_ContactHistory table for the Customer audience level to support the example reports. You can define your own "additionally tracked fields" for contact history and customize reports as needed.