MKTFINDERNUMBERCONSTITUENTAPPEAL

Stores information relating appeal and acquisition list member records with finder numbers.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
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
CONSTITUENTID	uniqueidentifier		MKTFINDERNUMBERCONSTITUENT.ID	The constituent record for this appeal.
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_MKTFINDERNUMBERCONSTITUENTAPPEAL_APPEALID	APPEALID
IX_MKTFINDERNUMBERCONSTITUENTAPPEAL_APPEALID_MKTSEGMENTATIONID_DATESENT	APPEALID, MKTSEGMENTATIONID, DATESENT
IX_MKTFINDERNUMBERCONSTITUENTAPPEAL_CONSTITUENTID	CONSTITUENTID
IX_MKTFINDERNUMBERCONSTITUENTAPPEAL_CONSTITUENTID_SOURCECODE	CONSTITUENTID, SOURCECODE
IX_MKTFINDERNUMBERCONSTITUENTAPPEAL_FINDERNUMBER	FINDERNUMBER
IX_MKTFINDERNUMBERCONSTITUENTAPPEAL_MKTSEGMENTATIONID	MKTSEGMENTATIONID
IX_MKTFINDERNUMBERCONSTITUENTAPPEAL_MKTSEGMENTATIONSEGMENTID	MKTSEGMENTATIONSEGMENTID
IX_MKTFINDERNUMBERCONSTITUENTAPPEAL_MKTSEGMENTATIONTESTSEGMENTID	MKTSEGMENTATIONTESTSEGMENTID
PK_MKTFINDERNUMBERCONSTITUENTAPPEAL	ID	yes	yes	yes