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.
 SAMPLESIZE int   Default = 100 The percent or number of records to use for the segment.
 SAMPLESIZETYPECODE tinyint   Default = 0 The sample size type.
 SAMPLESIZEMETHODCODE tinyint   Default = 0 The method to use when retrieving the sample of records.
 SEQUENCE int   Default = 0 The order of segments for each marketing effort.
 NEXTBRIEFSEQUENCE int   Default = 0 The sequence of the next marketing plan item brief that is displayed after the segment.
 COLLAPSED bit   Default = 0 The collapsed/expanded state of a segment in the UI.
 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.
 SAMPLESIZEEXCLUDEREMAINDER bit   Default = 1 Whether or not to exclude remaining records from the rest of the marketing effort when the sample size less than 100%.
 USAGECODE tinyint   Default = 1 Indicates whether the segment is being used for testing, retesting, or is a continuation or reuse.
 TESTSEGMENTCODE nvarchar(10)   Default = '' A code that identifies the type of test segment.
 SAMPLESIZETYPE nvarchar(7) (Computed) CASE [SAMPLESIZETYPECODE] WHEN 0 THEN N'Percent' WHEN 1 THEN N'Records' END Provides a translation for the 'SAMPLESIZETYPECODE' field.
 SAMPLESIZEMETHOD nvarchar(6) (Computed) CASE [SAMPLESIZEMETHODCODE] WHEN 0 THEN N'nth' WHEN 1 THEN N'Random' WHEN 2 THEN N'Top' END Provides a translation for the 'SAMPLESIZEMETHODCODE' field.
 USAGE nvarchar(12) (Computed) CASE [USAGECODE] WHEN 1 THEN N'Test' WHEN 2 THEN N'Retest' WHEN 3 THEN N'Continuation' WHEN 4 THEN N'Reuse' END Provides a translation for the 'USAGECODE' field.
 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.
 EXPOSURESTARTDATE datetime For public media segments, the date on which the media is revealed.
 EXPOSUREENDDATE datetime For public media segments, the date on which the media ceases to be displayed.
 EXCLUDESPOUSE bit   Default = 0 Determines whether or not exclude the spouse name from the name format if the spouse is included in the mailing.
 OVERRIDEBUSINESSUNITS bit   Default = 0 Determines whether the business units on the effort are being overridden by the segment.
 ORGANIZATIONGIFTAMOUNT money   Default = 0 The amount of the gift in organization currency.
 EXCLUDE bit   Default = 0
 HISTORICALQUANTITY int   Default = 0

Foreign Key Field Type Null Notes Description
 SEGMENTATIONID uniqueidentifier   MKTSEGMENTATION.ID The marketing effort the segment belongs to.
 MARKETINGPLANBRIEFID uniqueidentifier MKTMARKETINGPLANBRIEF.ID The marketing plan item brief for this segment.
 SEGMENTID uniqueidentifier MKTSEGMENT.ID The segment to use for the communication segment.
 PACKAGEID uniqueidentifier MKTPACKAGE.ID The package associated with the segment.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 ASKLADDERID uniqueidentifier MKTASKLADDER.ID The ask ladder associated with this segment.
 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 segmentation segment.
 CURRENCYEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from the gift amount to organization gift amount.

Index Name Field(s) Unique Primary Clustered
 IX_MKTSEGMENTATIONSEGMENT_ADDRESSPROCESSINGOPTIONID ADDRESSPROCESSINGOPTIONID      
 IX_MKTSEGMENTATIONSEGMENT_ASKLADDERID ASKLADDERID      
 IX_MKTSEGMENTATIONSEGMENT_BASECURRENCYID BASECURRENCYID      
 IX_MKTSEGMENTATIONSEGMENT_CURRENCYEXCHANGERATEID CURRENCYEXCHANGERATEID      
 IX_MKTSEGMENTATIONSEGMENT_DATEADDED DATEADDED    
 IX_MKTSEGMENTATIONSEGMENT_DATECHANGED DATECHANGED      
 IX_MKTSEGMENTATIONSEGMENT_MARKETINGPLANBRIEFID MARKETINGPLANBRIEFID      
 IX_MKTSEGMENTATIONSEGMENT_NAMEFORMATPARAMETERID NAMEFORMATPARAMETERID      
 IX_MKTSEGMENTATIONSEGMENT_PACKAGEID PACKAGEID      
 IX_MKTSEGMENTATIONSEGMENT_PARTDEFINITIONVALUESID PARTDEFINITIONVALUESID      
 IX_MKTSEGMENTATIONSEGMENT_SEGMENTID SEGMENTID      
 IX_MKTSEGMENTATIONSEGMENT_TESTPARTDEFINITIONVALUESID TESTPARTDEFINITIONVALUESID      
 PK_MKTSEGMENTATIONSEGMENT ID  
 UIX_MKTSEGMENTATIONSEGMENT_ID ID    
 UIX_MKTSEGMENTATIONSEGMENT_SEGMENTATIONID_SEGMENTID_PACKAGEID SEGMENTATIONID, SEGMENTID, PACKAGEID    

Trigger Name Description
 TR_MKTSEGMENTATIONSEGMENT_AUDIT_UPDATE
 TR_MKTSEGMENTATIONSEGMENT_AUDIT_DELETE
 TR_MKTSEGMENTATIONSEGMENT_IU_ORGANIZATIONGIFTAMOUNT
 TR_MKTSEGMENTATIONSEGMENT_AUDIT_ETLDELETEDID

Referenced by Field
 APPEALMAILING MKTSEGMENTATIONSEGMENTID
 BATCHREVENUECONSTITUENTAPPEAL MKTSEGMENTATIONSEGMENTID
 CONSTITUENTAPPEAL MKTSEGMENTATIONSEGMENTID
 CONSTITUENTSEGMENT SEGMENTID
 MKTFINDERNUMBERCONSTITUENTAPPEAL MKTSEGMENTATIONSEGMENTID
 MKTSEGMENTATIONLISTACTIVE SEGMENTID
 MKTSEGMENTATIONSEGMENTACTIVE SEGMENTID
 MKTSEGMENTATIONSEGMENTBUSINESSUNIT MKTSEGMENTATIONSEGMENTID
 MKTSEGMENTATIONSEGMENTCACHEINFO SEGMENTID
 MKTSEGMENTATIONSEGMENTLIST ID
 MKTSEGMENTATIONTESTSEGMENT SEGMENTID
 MKTSOURCECODEMAP SEGMENTATIONSEGMENTID
 MKTSOURCECODEPART SEGMENTATIONSEGMENTID
 REVENUESEGMENT SEGMENTID

Entity-Relationship diagram of this table (ADDRESSPROCESSINGOPTION-MKTSEGMENTATIONSEGMENTLIST)
Entity-Relationship diagram of this table (MKTSEGMENTATIONTESTSEGMENT-REVENUESEGMENT_09A6D736_2ACB_42FF_87DB_F4F92A2025E1)