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.
 GIFTAMOUNT money   Default = 0 The average expected gift amount per donor for the segment.
 SEQUENCE int   Default = 0 The order of segments for each membership renewal effort.
 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
 MEMBERSHIPMAILINGTEMPLATEID uniqueidentifier   MKTMEMBERSHIPMAILINGTEMPLATE.ID The membership renewal effort template to which the rule belongs.
 SEGMENTID uniqueidentifier MKTSEGMENT.ID The segment to use as 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 membership 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_MKTMEMBERSHIPMAILINGTEMPLATERULE_ADDRESSPROCESSINGOPTIONID ADDRESSPROCESSINGOPTIONID      
 IX_MKTMEMBERSHIPMAILINGTEMPLATERULE_ASKLADDERID ASKLADDERID      
 IX_MKTMEMBERSHIPMAILINGTEMPLATERULE_BASECURRENCYID BASECURRENCYID      
 IX_MKTMEMBERSHIPMAILINGTEMPLATERULE_CURRENCYEXCHANGERATEID CURRENCYEXCHANGERATEID      
 IX_MKTMEMBERSHIPMAILINGTEMPLATERULE_DATEADDED DATEADDED    
 IX_MKTMEMBERSHIPMAILINGTEMPLATERULE_DATECHANGED DATECHANGED      
 IX_MKTMEMBERSHIPMAILINGTEMPLATERULE_NAMEFORMATPARAMETERID NAMEFORMATPARAMETERID      
 IX_MKTMEMBERSHIPMAILINGTEMPLATERULE_PACKAGEID PACKAGEID      
 IX_MKTMEMBERSHIPMAILINGTEMPLATERULE_PARTDEFINITIONVALUESID PARTDEFINITIONVALUESID      
 IX_MKTMEMBERSHIPMAILINGTEMPLATERULE_SEGMENTID SEGMENTID      
 IX_MKTMEMBERSHIPMAILINGTEMPLATERULE_TESTPARTDEFINITIONVALUESID TESTPARTDEFINITIONVALUESID      
 PK_MKTMEMBERSHIPMAILINGTEMPLATERULE ID  
 UIX_MKTMEMBERSHIPMAILINGTEMPLATERULE_MEMBERSHIPMAILINGTEMPLATEID_SEGMENTID MEMBERSHIPMAILINGTEMPLATEID, SEGMENTID    

Trigger Name Description
 TR_MKTMEMBERSHIPMAILINGTEMPLATERULE_INSERTUPDATE_CURRENCY
 TR_MKTMEMBERSHIPMAILINGTEMPLATERULE_AUDIT_UPDATE
 TR_MKTMEMBERSHIPMAILINGTEMPLATERULE_AUDIT_DELETE

Entity-Relationship diagram of this table