MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE

Stores information pertaining to a marketing acknowledgement template rule.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
CODE	nvarchar(10)		Default = ''	A unique code that identifies the segment.
RESPONSERATE	decimal(5, 2)		Default = 0	The expected response rate for the segment.
MAXDAYSCHECKED	bit		Default = 0
MAXDAYS	int		Default = 1	The maximum number of days that can pass before a revenue is included in the process.
MINQUANTITYCHECKED	bit		Default = 0
MINQUANTITY	int		Default = 1	The minimum number of transactions to process.
GIFTAMOUNT	money		Default = 0	The average expected gift amount per donor for the segment.
SEQUENCE	int		Default = 0	The order of segments for each marketing acknowledgement.
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.
TESTSEGMENTCODE	nvarchar(10)		Default = ''	A code that identifies the type of test segment.
OVERRIDEADDRESSPROCESSING	bit		Default = 0	Determines whether or not to override the mailing-level address processing options when performing calculations and exporting this segment.
USEADDRESSPROCESSING	bit		Default = 0	If mailing-level options are overridden, determines whether or not to apply address processing options when performing calculations and exporting this segment.
ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint		Default = 0	If mailing-level options are overridden, indicates the type of date to be used when considering seasonal addresses.
ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPE	nvarchar(15) (Computed)	yes	CASE [ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N<Specific date> END	Provides a translation for the 'ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE' field.
ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	yes		If mailing-level options are overridden, the specific date to be used when considering seasonal addresses.
ORGANIZATIONGIFTAMOUNT	money		Default = 0	The average expected gift amount per donor for the segment in organization currency.
EXCLUDE	bit		Default = 0	Indicates that this segment functions as an inline exclusion.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ACKNOWLEDGEMENTMAILINGTEMPLATEID	uniqueidentifier		MKTACKNOWLEDGEMENTMAILINGTEMPLATE.ID	The marketing acknowledgement template the rule belongs to.
SEGMENTID	uniqueidentifier	yes	MKTSEGMENT.ID	The segment to use for the communication segment.
PACKAGEID	uniqueidentifier	yes	MKTPACKAGE.ID	The package associated with the segment.
ASKLADDERID	uniqueidentifier	yes	MKTASKLADDER.ID	The ask ladder associated with this segment.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
ADDRESSPROCESSINGOPTIONID	uniqueidentifier	yes	ADDRESSPROCESSINGOPTION.ID	If mailing-level options are overridden, the address processing options to be used for this segment.
NAMEFORMATPARAMETERID	uniqueidentifier	yes	NAMEFORMATPARAMETER.ID	If mailing-level options are overridden, the name format options to be used for this segment.
PARTDEFINITIONVALUESID	uniqueidentifier	yes	MKTSOURCECODEPARTDEFINITIONVALUES.ID	FK to MKTSOURCECODEPARTDEFINITIONVALUES
TESTPARTDEFINITIONVALUESID	uniqueidentifier	yes	MKTSOURCECODEPARTDEFINITIONVALUES.ID	FK to MKTSOURCECODEPARTDEFINITIONVALUES
BASECURRENCYID	uniqueidentifier	yes	CURRENCY.ID	The base currency associated with this acknowledgment template rule.
CURRENCYEXCHANGERATEID	uniqueidentifier	yes	CURRENCYEXCHANGERATE.ID	The exchange rate used to convert from the amounts to organization amount.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_ADDRESSPROCESSINGOPTIONID	ADDRESSPROCESSINGOPTIONID
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_ASKLADDERID	ASKLADDERID
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_BASECURRENCYID	BASECURRENCYID
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_CURRENCYEXCHANGERATEID	CURRENCYEXCHANGERATEID
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_DATEADDED	DATEADDED			yes
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_DATECHANGED	DATECHANGED
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_NAMEFORMATPARAMETERID	NAMEFORMATPARAMETERID
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_PACKAGEID	PACKAGEID
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_PARTDEFINITIONVALUESID	PARTDEFINITIONVALUESID
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_SEGMENTID	SEGMENTID
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_TESTPARTDEFINITIONVALUESID	TESTPARTDEFINITIONVALUESID
PK_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE	ID	yes	yes
UIX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_ACKNOWLEDGEMENTMAILINGTEMPLATEID_SEGMENTID_PACKAGEID	ACKNOWLEDGEMENTMAILINGTEMPLATEID, SEGMENTID, PACKAGEID	yes

Triggers

Trigger Name	Description
TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_AUDIT_UPDATE
TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_AUDIT_DELETE
TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_INSERTUPDATE_CURRENCY