BATCHREVENUECONSTITUENTAPPEAL

Stores information relating appeal and constituent records for revenue batch.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENTID	uniqueidentifier	yes		The constituent record for this appeal.
SOURCECODE	nvarchar(50)		Default = ''	The source code for this record.
FINDERNUMBER	bigint		Default = ((0))	The finder number for this record.
DATESENT	datetime	yes		The date that this appeal was sent to this constituent.
COMMENTS	nvarchar(50)		Default = ''	Comments for this constituent appeal.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
APPEALID	uniqueidentifier		APPEAL.LOCALID	The appeal record to which this record belongs.
MKTSEGMENTATIONID	uniqueidentifier	yes	MKTSEGMENTATION.ID	The mailing record that generated this constituent appeal record.
MKTPACKAGEID	uniqueidentifier	yes	MKTPACKAGE.ID	The package that was sent to this constituent.
MKTSEGMENTATIONSEGMENTID	uniqueidentifier	yes	MKTSEGMENTATIONSEGMENT.ID	The segment of the mailing that includes this constituent.
MKTSEGMENTATIONTESTSEGMENTID	uniqueidentifier	yes	MKTSEGMENTATIONTESTSEGMENT.ID	The test segment of the mailing that includes this constituent.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BATCHREVENUECONSTITUENTAPPEAL_APPEALID_MKTSEGMENTATIONID_DATESENT	APPEALID, MKTSEGMENTATIONID, DATESENT
IX_BATCHREVENUECONSTITUENTAPPEAL_CONSTITUENTID	CONSTITUENTID
IX_BATCHREVENUECONSTITUENTAPPEAL_CONSTITUENTID_SOURCECODE	CONSTITUENTID, SOURCECODE
IX_BATCHREVENUECONSTITUENTAPPEAL_FINDERNUMBER	FINDERNUMBER
IX_BATCHREVENUECONSTITUENTAPPEAL_MKTSEGMENTATIONID	MKTSEGMENTATIONID
IX_BATCHREVENUECONSTITUENTAPPEAL_MKTSEGMENTATIONSEGMENTID	MKTSEGMENTATIONSEGMENTID
IX_BATCHREVENUECONSTITUENTAPPEAL_MKTSEGMENTATIONTESTSEGMENTID	MKTSEGMENTATIONTESTSEGMENTID
PK_BATCHREVENUECONSTITUENTAPPEAL	ID	yes	yes	yes