Primary Key Field Type
 ID uniqueidentifier

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) 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) CASE [ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'<Specific date>' END Provides a translation for the 'ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE' field.
 ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime 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

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

Index Name Field(s) Unique Primary Clustered
 IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_ADDRESSPROCESSINGOPTIONID ADDRESSPROCESSINGOPTIONID      
 IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_ASKLADDERID ASKLADDERID      
 IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_BASECURRENCYID BASECURRENCYID      
 IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_CURRENCYEXCHANGERATEID CURRENCYEXCHANGERATEID      
 IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_DATEADDED DATEADDED    
 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  
 UIX_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_ACKNOWLEDGEMENTMAILINGTEMPLATEID_SEGMENTID_PACKAGEID ACKNOWLEDGEMENTMAILINGTEMPLATEID, SEGMENTID, PACKAGEID    

Trigger Name Description
 TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_INSERTUPDATE_CURRENCY
 TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_AUDIT_UPDATE
 TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_AUDIT_DELETE

Entity-Relationship diagram of this table