Stores information pertaining to a sponsorship effort template rule.
Foreign Key Fields
| Foreign Key |
Field Type |
Null |
Notes |
Description |
|
SPONSORSHIPMAILINGTEMPLATEID
|
uniqueidentifier
|
false
|
|
The sponsorship effort template to which the rule belongs.
|
|
SEGMENTID
|
uniqueidentifier
|
true
|
|
The segment to use as the communication segment.
|
|
PACKAGEID
|
uniqueidentifier
|
true
|
|
The package associated with the segment.
|
|
ASKLADDERID
|
uniqueidentifier
|
true
|
|
The ask ladder associated with this segment.
|
|
ADDEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
CHANGEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
PARTDEFINITIONVALUESID
|
uniqueidentifier
|
true
|
|
FK to MKTSOURCECODEPARTDEFINITIONVALUES
|
|
TESTPARTDEFINITIONVALUESID
|
uniqueidentifier
|
true
|
|
FK to MKTSOURCECODEPARTDEFINITIONVALUES
|
|
ADDRESSPROCESSINGOPTIONID
|
uniqueidentifier
|
true
|
|
If mailing-level options are overridden, the address processing options to be used for this segment.
|
|
NAMEFORMATPARAMETERID
|
uniqueidentifier
|
true
|
|
If mailing-level options are overridden, the name format options to be used for this segment.
|
|
BASECURRENCYID
|
uniqueidentifier
|
true
|
|
The base currency associated with this sponsorship template rule.
|
|
CURRENCYEXCHANGERATEID
|
uniqueidentifier
|
true
|
|
The exchange rate used to convert from the amounts to organization amount.
|
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
CODE
|
nvarchar(10)
|
false
|
|
A unique code that identifies the segment.
|
|
TESTSEGMENTCODE
|
nvarchar(10)
|
false
|
|
A code that identifies the type of test segment.
|
|
RESPONSERATE
|
decimal(5, 2)
|
false
|
|
The expected response rate for the segment.
|
|
GIFTAMOUNT
|
money
|
false
|
|
The average expected gift amount per donor for the segment.
|
|
SEQUENCE
|
int
|
false
|
|
The order of segments for each sponsorship effort.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
OVERRIDEADDRESSPROCESSING
|
bit
|
false
|
|
Determines whether or not to override the mailing-level address processing options when performing calculations and exporting this segment.
|
|
USEADDRESSPROCESSING
|
bit
|
false
|
|
If mailing-level options are overridden, determines whether or not to apply address processing options when performing calculations and exporting this segment.
|
|
ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE
|
tinyint
|
false
|
|
If mailing-level options are overridden, indicates the type of date to be used when considering seasonal addresses.
|
|
ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPE
|
nvarchar(15) (Computed)
|
true
|
|
Provides a translation for the 'ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE' field.
|
|
ADDRESSPROCESSINGOPTIONSEASONALASOFDATE
|
datetime
|
true
|
|
If mailing-level options are overridden, the specific date to be used when considering seasonal addresses.
|
|
ORGANIZATIONGIFTAMOUNT
|
money
|
false
|
|
The average expected gift amount per donor for the segment in organization currency.
|
|
EXCLUDE
|
bit
|
false
|
|
Indicates that this segment functions as an inline exclusion.
|
Indexes
| Index Name |
Field(s) |
Unique |
Primary |
Clustered |
|
IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_ADDRESSPROCESSINGOPTIONID
|
ADDRESSPROCESSINGOPTIONID
|
False
|
False
|
False
|
|
IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_ASKLADDERID
|
|
False
|
False
|
False
|
|
IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_BASECURRENCYID
|
|
False
|
False
|
False
|
|
IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_CURRENCYEXCHANGERATEID
|
|
False
|
False
|
False
|
|
IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_DATEADDED
|
|
False
|
False
|
True
|
|
IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_DATECHANGED
|
|
False
|
False
|
False
|
|
IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_NAMEFORMATPARAMETERID
|
|
False
|
False
|
False
|
|
IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_PACKAGEID
|
|
False
|
False
|
False
|
|
IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_PARTDEFINITIONVALUESID
|
|
False
|
False
|
False
|
|
IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_SEGMENTID
|
|
False
|
False
|
False
|
|
IX_MKTSPONSORSHIPMAILINGTEMPLATERULE_TESTPARTDEFINITIONVALUESID
|
TESTPARTDEFINITIONVALUESID
|
False
|
False
|
False
|
|
PK_MKTSPONSORSHIPMAILINGTEMPLATERULE
|
|
True
|
True
|
False
|
|
UIX_MKTSPONSORSHIPMAILINGTEMPLATERULE_SPONSORSHIPMAILINGTEMPLATEID_SEGMENTID
|
SPONSORSHIPMAILINGTEMPLATEID
SEGMENTID
|
True
|
False
|
False
|
