APPEALMAILINGSETUP

Stores information for setting up an appeal mailing before activation.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
SELECTEDSELECTIONS	xml	yes
CHANNELCODE	tinyint		Default = 0	0=Mail, 1=Email, 2=Mail and Email
CHANNELPREFERENCECODE	tinyint		Default = 0	0=Email, 1=Mail
CHANNELPREFERENCE	nvarchar(5) (Computed)	yes	CASE [CHANNELPREFERENCECODE] WHEN 0 THEN N'Email' WHEN 1 THEN N'Mail' END	Provides a translation for the 'CHANNELPREFERENCECODE' field.
DATEADDED	datetime		Default = getdate()	Indicates the date this record was added.
DATECHANGED	datetime		Default = getdate()	Indicates the date this record was last changed.
TS	timestamp			Timestamp.
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.
ESTIMATEDRESPONSERATE	decimal(5, 2)		Default = 0	The estimated response rate for this appeal mailing which is used for calculating KPI goals.
ESTIMATEDAVERAGEGIFTAMOUNT	money		Default = 0	The estimated average gift amount received due to this appeal mailing which is used for calculating KPI goals.
CHANNEL	nvarchar(14) (Computed)	yes	CASE [CHANNELCODE] WHEN 0 THEN N'Mail' WHEN 1 THEN N'Email' WHEN 2 THEN N'Mail and Email' END	Provides a translation for the 'CHANNELCODE' field.
HOUSEHOLDINGTYPECODE	tinyint		Default = 0	0=Send one letter per household, 1=Send a letter to each individual in the household
HOUSEHOLDINGTYPE	nvarchar(49) (Computed)	yes	CASE [HOUSEHOLDINGTYPECODE] WHEN 0 THEN N'Send one letter per household' WHEN 1 THEN N'Send a letter to each individual in the household' END	Provides a translation for the 'HOUSEHOLDINGTYPECODE' field.
ESTIMATEDNETREVENUE	money		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ID	uniqueidentifier		APPEALMAILING.ID	Primary Key.
MAILPACKAGEID	uniqueidentifier	yes	MKTPACKAGE.ID	FK to MKTPACKAGE
EMAILPACKAGEID	uniqueidentifier	yes	MKTPACKAGE.ID	FK to MKTPACKAGE
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
SEGMENTID	uniqueidentifier	yes	MKTSEGMENT.ID	FK to MKTSEGMENT
MKTASKLADDERID	uniqueidentifier	yes	MKTASKLADDER.ID	FK to MKTASKLADDER
MAILEXPORTDEFINITIONID	uniqueidentifier	yes	EXPORTDEFINITION.ID	FK to EXPORTDEFINITION
EMAILEXPORTDEFINITIONID	uniqueidentifier	yes	EXPORTDEFINITION.ID	FK to EXPORTDEFINITION

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_APPEALMAILINGSETUP_DATEADDED	DATEADDED			yes
IX_APPEALMAILINGSETUP_DATECHANGED	DATECHANGED
IX_APPEALMAILINGSETUP_EMAILPACKAGEID	EMAILPACKAGEID
IX_APPEALMAILINGSETUP_MAILPACKAGEID	MAILPACKAGEID
IX_APPEALMAILINGSETUP_MKTASKLADDERID	MKTASKLADDERID
IX_APPEALMAILINGSETUP_SEGMENTID	SEGMENTID
PK_APPEALMAILINGSETUP	ID	yes	yes

Triggers

Trigger Name	Description
TR_APPEALMAILINGSETUP_AUDIT_UPDATE
TR_APPEALMAILINGSETUP_AUDIT_DELETE

Referenced by

Referenced by	Field
APPEALMAILINGSETUPLETTER	APPEALMAILINGSETUPID
APPEALMAILINGSETUPSELECTION	APPEALMAILINGSETUPID
ARCHIVEDAPPEALMAILINGCONTENT	ID