Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' A name for the test segment.
 DESCRIPTION nvarchar(255)   Default = '' A description about the test segment.
 CODE nvarchar(10)   Default = '' A unique code that identifies the test segment.
 RESPONSERATE decimal(5, 2)   Default = 0 The expected response rate for the test segment.
 GIFTAMOUNT money   Default = 0 The average expected gift amount per donor for the test segment.
 SAMPLESIZE int   Default = 100 The percent or number of records to use for the test 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 test segments in the segment.
 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.
 PREFIXCODE tinyint   Default = 0 Prefix type for the test segment name.
 TESTSEGMENTCODE nvarchar(10)   Default = '' A code that identifies the type of test segment.
 PREFIX nvarchar(12) (Computed) CASE [PREFIXCODE] WHEN 0 THEN N'' WHEN 1 THEN N'Segment name' WHEN 2 THEN N'Segment code' END Provides a translation for the 'PREFIXCODE' field.
 SAMPLESIZEMETHOD nvarchar(6) (Computed) CASE [SAMPLESIZEMETHODCODE] WHEN 0 THEN N'nth' WHEN 1 THEN N'Random' END Provides a translation for the 'SAMPLESIZEMETHODCODE' field.
 SAMPLESIZETYPE nvarchar(8) (Computed) CASE [SAMPLESIZETYPECODE] WHEN 0 THEN N'Percent' WHEN 1 THEN N'Records' WHEN 2 THEN N'Fraction' END Provides a translation for the 'SAMPLESIZETYPECODE' field.
 FRACTION nvarchar(10)   Default = '' Sample size represented as a fraction
 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.

Foreign Key Field Type Null Notes Description
 SEGMENTID uniqueidentifier   MKTSEGMENTATIONSEGMENT.ID The segment the test segment belongs to.
 PACKAGEID uniqueidentifier   MKTPACKAGE.ID The package associated with the test 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.
 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.
 ORGANIZATIONCURRENCYEXCHANGERATEID 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_MKTSEGMENTATIONTESTSEGMENT_ASKLADDERID ASKLADDERID      
 IX_MKTSEGMENTATIONTESTSEGMENT_BASECURRENCYID BASECURRENCYID      
 IX_MKTSEGMENTATIONTESTSEGMENT_DATEADDED DATEADDED    
 IX_MKTSEGMENTATIONTESTSEGMENT_DATECHANGED DATECHANGED      
 IX_MKTSEGMENTATIONTESTSEGMENT_ORGANIZATIONCURRENCYEXCHANGERATEID ORGANIZATIONCURRENCYEXCHANGERATEID      
 IX_MKTSEGMENTATIONTESTSEGMENT_PACKAGEID PACKAGEID      
 IX_MKTSEGMENTATIONTESTSEGMENT_PARTDEFINITIONVALUESID PARTDEFINITIONVALUESID      
 IX_MKTSEGMENTATIONTESTSEGMENT_TESTPARTDEFINITIONVALUESID TESTPARTDEFINITIONVALUESID      
 PK_MKTSEGMENTATIONTESTSEGMENT ID  
 UIX_MKTSEGMENTATIONTESTSEGMENT_SEGMENTID_NAME_PREFIXCODE SEGMENTID, NAME, PREFIXCODE    

Trigger Name Description
 TR_MKTSEGMENTATIONTESTSEGMENT_AUDIT_UPDATE
 TR_MKTSEGMENTATIONTESTSEGMENT_AUDIT_DELETE
 TR_MKTSEGMENTATIONTESTSEGMENT_AUDIT_ETLDELETEDID
 TR_MKTSEGMENTATIONTESTSEGMENT_IU_ORGANIZATIONGIFTAMOUNT

Referenced by Field
 BATCHDIRECTMARKETINGEFFORTTESTSEGMENT MKTSEGMENTATIONTESTSEGMENTID
 BATCHREVENUECONSTITUENTAPPEAL MKTSEGMENTATIONTESTSEGMENTID
 CONSTITUENTAPPEAL MKTSEGMENTATIONTESTSEGMENTID
 CONSTITUENTSEGMENT TESTSEGMENTID
 MKTFINDERNUMBERCONSTITUENTAPPEAL MKTSEGMENTATIONTESTSEGMENTID
 MKTSEGMENTATIONSEGMENTACTIVE TESTSEGMENTID
 MKTSEGMENTATIONTESTSEGMENTBUSINESSUNIT MKTSEGMENTATIONTESTSEGMENTID
 MKTSOURCECODEMAP SEGMENTATIONTESTSEGMENTID
 MKTSOURCECODEPART SEGMENTATIONTESTSEGMENTID
 REVENUESEGMENT TESTSEGMENTID

Entity-Relationship diagram of this table (BATCHDIRECTMARKETINGEFFORTTESTSEGMENT-REVENUESEGMENT)
Entity-Relationship diagram of this table (REVENUESEGMENT_09A6D736_2ACB_42FF_87DB_F4F92A2025E1)