Required fields in audience-level-specific tables

The list of the required fields in the system tables, required for each audience level, are as follows:

Required fields in the contact history table

The contact history table for each audience level in the Audience Central system database must minimally contain the fields described in the following table:


Primary Key	Column Name	Data Type	Allow Nulls
Yes	Identifier for audience level	numeric or text	No
Yes	CellID	numeric	No
Yes	PackageID	numeric	No
No	ContactDateTime	datetime	Yes
No	UpdateDateTime	datetime	Yes
No	ContactStatusID	numeric	Yes
No	DateID	numeric	Yes
No	TimeID	numeric	Yes

The detailed contact history table for each audience level in the Audience Central system database must minimally contain the fields described in the following table:

Table 1. Required fields in the detailed contact history table
Primary Key	Column Name	Data Type	Allow Nulls
Yes	Identifier for audience level	numeric or text	No
No	TreatmentInstID	numeric	No
No	ContactStatusID	numeric	Yes
No	ContactDateTime	datetime	Yes
No	UpdateDateTime	datetime	Yes
No	DateID	numeric	No
No	TimeID	numeric	No

Required fields in the response history table

The response history table for each audience level in the Audience Central system database must minimally contain the fields described in the following table:


Primary Key	Column Name	Data Type	Allow Nulls
Yes	Identifier for audience level.	numeric or text	No
Yes	TreatmentInstID	numeric	No
Yes	ResponsePackID	numeric	No
No	ResponseDateTime	datetime	No
No	WithinDateRangeFlg	numeric	Yes
No	OrigContactedFlg	numeric	Yes
No	BestAttrib	numeric	Yes
No	FractionalAttrib	numeric	Yes
No	CustomAttrib	numeric	Yes
No	ResponseTypeID	numeric	Yes
No	DateID	numeric	Yes
No	TimeID	numeric	Yes
No	DirectResponse	numeric	Yes

Required fields in the segment membership table

If you are using strategic segments, you must create the segment membership table for each audience level that you use with strategic segments. At a minimum, the table must contain the fields described in the following table:


Primary Key	Column Name	Data Type	Allow Nulls
Yes	SegmentID	numeric	No
Yes	Identifier for audience level	numeric or text	No