Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 CODE nvarchar(10)   Default = '' A unique code that identifies the segment.
 TESTSEGMENTCODE nvarchar(10)   Default = '' A code that identifies the type of test 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 sponsorship 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.
 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
 SPONSORSHIPMAILINGTEMPLATEID uniqueidentifier   MKTSPONSORSHIPMAILINGTEMPLATE.ID The sponsorship 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.
 PARTDEFINITIONVALUESID uniqueidentifier MKTSOURCECODEPARTDEFINITIONVALUES.ID FK to MKTSOURCECODEPARTDEFINITIONVALUES
 TESTPARTDEFINITIONVALUESID uniqueidentifier MKTSOURCECODEPARTDEFINITIONVALUES.ID FK to MKTSOURCECODEPARTDEFINITIONVALUES
 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.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this sponsorship 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_MKTSPONSORSHIPMAILINGTEMPLATERULE_ADDRESSPROCESSINGOPTIONID ADDRESSPROCESSINGOPTIONID      
 IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_ASKLADDERID ASKLADDERID      
 IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_BASECURRENCYID BASECURRENCYID      
 IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_CURRENCYEXCHANGERATEID CURRENCYEXCHANGERATEID      
 IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_DATEADDED DATEADDED    
 IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_DATECHANGED DATECHANGED      
 IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_NAMEFORMATPARAMETERID NAMEFORMATPARAMETERID      
 IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_PACKAGEID PACKAGEID      
 IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_PARTDEFINITIONVALUESID PARTDEFINITIONVALUESID      
 IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_SEGMENTID SEGMENTID      
 IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_TESTPARTDEFINITIONVALUESID TESTPARTDEFINITIONVALUESID      
 PK_MKTSPONSORSHIPMAILINGTEMPLATERULE ID  
 UIX_MKTSPONSORSHIPMAILINGTEMPLATERULE_SPONSORSHIPMAILINGTEMPLATEID_SEGMENTID SPONSORSHIPMAILINGTEMPLATEID, SEGMENTID    

Trigger Name Description
 TR_MKTSPONSORSHIPMAILINGTEMPLATERULE_INSERTUPDATE_CURRENCY
 TR_MKTSPONSORSHIPMAILINGTEMPLATERULE_AUDIT_UPDATE
 TR_MKTSPONSORSHIPMAILINGTEMPLATERULE_AUDIT_DELETE

Entity-Relationship diagram of this table