Required fields in the response history table

The response 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
Yes	TreatmentInstID	bigint	8	No
Yes	ResponsePackID	bigint	8	No
No	ResponseDateTime	datetime	8	No
No	WithinDateRangFlg	int	4	Yes
No	OrigContactedFlg	int	4	Yes
No	BestAttrib	int	4	Yes
No	FractionalAttrib	float	8	Yes
No	CustomAttrib	float	8	Yes
No	ResponseTypeID	bigint	8	Yes
No	DateID	bigint	8	Yes
No	TimeID	bigint	8	Yes
No	DirectResponse	int	4	Yes

Each response history table you create for a new audience level should have a foreign key constraint on the UA_Treatment table's TreatmentInstID field.