Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 QUANTITY int   Default = 0 The number of people in the segment that were mailed to.
 RESPONDERS int   Default = 0 The number of people in the segment that responded to the marketing effort.
 RESPONSES int   Default = 0 The number of gifts from people in the segment that responded to the marketing effort.
 VARIABLECOST money   Default = 0 The package costs for the segment.
 FIXEDCOST money   Default = 0 The fixed cost for the segment.
 TOTALCOST money   Default = 0 The total cost (variable + fixed) for the segment.
 COSTPERDOLLARRAISED money   Default = 0 The cost per dollar raised for the segment.
 TOTALGIFTAMOUNT money   Default = 0 The total gift amount received for the segment.
 AVERAGEGIFTAMOUNT money   Default = 0 The average gift amount received for the segment.
 RESPONSERATE decimal(19, 4)   Default = 0 The response rate for the segment.
 LIFT decimal(19, 4)   Default = 0 The lift calculation for the segment.
 ROIAMOUNT money   Default = 0 The ROI as a dollar amount for the segment.
 ROIPERCENT decimal(19, 4)   Default = 0 The ROI as a percentage for the segment.
 EXPECTEDRESPONDERS int   Default = 0 The number of expected responders for the segment.
 EXPECTEDTOTALGIFTAMOUNT money   Default = 0 The expected total gift amount for the segment.
 EXPECTEDROIAMOUNT money   Default = 0 The expected ROI as a dollar amount for the segment.
 EXPECTEDROIPERCENT decimal(19, 4)   Default = 0 The expected ROI as a percentage for 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.
 EXPECTEDCOSTPERDOLLARRAISED money   Default = 0 The expected cost per dollar raised for the segment.
 IMPRESSIONS int   Default = 0 For a public media marketing effort, the number of impressions expected for this segment.
 IMPRESSIONCALCULATIONMETHODCODE tinyint   Default = 0 For a public media marketing effort, the method to be used to determine the total number of impressions contributed to a marketing effort by the segment.
 IMPRESSIONCALCULATIONMETHOD nvarchar(20) (Computed) CASE [IMPRESSIONCALCULATIONMETHODCODE] WHEN 0 THEN N'Per day' WHEN 1 THEN N'Per marketing effort' END Provides a translation for the 'IMPRESSIONCALCULATIONMETHODCODE' field.
 ORGANIZATIONVARIABLECOST money   Default = 0 The package costs, in organization currency, for the segment.
 ORGANIZATIONFIXEDCOST money   Default = 0 The fixed cost, in organization currency, for the segment.
 ORGANIZATIONTOTALCOST money   Default = 0 The total cost (variable + fixed), in organization currency, for the segment.
 ORGANIZATIONCOSTPERDOLLARRAISED money   Default = 0 The cost per dollar, in organization currency, raised for the segment.
 ORGANIZATIONTOTALGIFTAMOUNT money   Default = 0 The total gift amount, in organization currency, received for the segment.
 ORGANIZATIONAVERAGEGIFTAMOUNT money   Default = 0 The average gift amount, in organization currency, received for the segment.
 ORGANIZATIONROIAMOUNT money   Default = 0 The ROI as a dollar amount, in organization currency, for the segment.
 ORGANIZATIONEXPECTEDCOSTPERDOLLARRAISED money   Default = 0 The expected cost per dollar raised, in organization currency, for the segment.
 ORGANIZATIONEXPECTEDTOTALGIFTAMOUNT money   Default = 0 The expected total gift amount, in organization currency, for the segment.
 ORGANIZATIONEXPECTEDROIAMOUNT money   Default = 0 The expected ROI as a dollar amount, in organization currency, for the segment.

Foreign Key Field Type Null Notes Description
 TESTSEGMENTID uniqueidentifier MKTSEGMENTATIONTESTSEGMENT.ID The test segment these activated numbers belong to.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 SEGMENTID uniqueidentifier   MKTSEGMENTATIONSEGMENT.ID The segment these activated numbers belong to.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this activated marketing effort segment.

Index Name Field(s) Unique Primary Clustered
 IX_MKTSEGMENTATIONSEGMENTACTIVE_AVERAGEGIFTAMOUNT AVERAGEGIFTAMOUNT      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_BASECURRENCYID BASECURRENCYID      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_COSTPERDOLLARRAISED COSTPERDOLLARRAISED      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_DATEADDED DATEADDED    
 IX_MKTSEGMENTATIONSEGMENTACTIVE_DATECHANGED DATECHANGED      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_EXPECTEDCOSTPERDOLLARRAISED EXPECTEDCOSTPERDOLLARRAISED      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_EXPECTEDRESPONDERS EXPECTEDRESPONDERS      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_EXPECTEDROIAMOUNT EXPECTEDROIAMOUNT      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_EXPECTEDROIPERCENT EXPECTEDROIPERCENT      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_EXPECTEDTOTALGIFTAMOUNT EXPECTEDTOTALGIFTAMOUNT      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_FIXEDCOST FIXEDCOST      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_LIFT LIFT      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_ORGANIZATIONAVERAGEGIFTAMOUNT ORGANIZATIONAVERAGEGIFTAMOUNT      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_ORGANIZATIONCOSTPERDOLLARRAISED ORGANIZATIONCOSTPERDOLLARRAISED      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_ORGANIZATIONEXPECTEDCOSTPERDOLLARRAISED ORGANIZATIONEXPECTEDCOSTPERDOLLARRAISED      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_ORGANIZATIONEXPECTEDROIAMOUNT ORGANIZATIONEXPECTEDROIAMOUNT      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_ORGANIZATIONEXPECTEDTOTALGIFTAMOUNT ORGANIZATIONEXPECTEDTOTALGIFTAMOUNT      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_ORGANIZATIONROIAMOUNT ORGANIZATIONROIAMOUNT      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_ORGANIZATIONTOTALCOST ORGANIZATIONTOTALCOST      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_ORGANIZATIONTOTALGIFTAMOUNT ORGANIZATIONTOTALGIFTAMOUNT      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_ORGANIZATIONVARIABLECOST ORGANIZATIONVARIABLECOST      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_QUANTITY QUANTITY      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_RESPONDERS RESPONDERS      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_RESPONSERATE RESPONSERATE      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_RESPONSES RESPONSES      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_ROIAMOUNT ROIAMOUNT      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_ROIPERCENT ROIPERCENT      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_SEGMENTID SEGMENTID      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_TESTSEGMENTID TESTSEGMENTID      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_TOTALCOST TOTALCOST      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_TOTALGIFTAMOUNT TOTALGIFTAMOUNT      
 IX_MKTSEGMENTATIONSEGMENTACTIVE_VARIABLECOST VARIABLECOST      
 PK_MKTSEGMENTATIONSEGMENTACTIVE ID  

Trigger Name Description
 TR_MKTSEGMENTATIONSEGMENTACTIVE_IU_ORGANIZATIONAMOUNTS
 TR_MKTSEGMENTATIONSEGMENTACTIVE_AUDIT_UPDATE
 TR_MKTSEGMENTATIONSEGMENTACTIVE_AUDIT_DELETE

Referenced by Field
 MKTMEMBERSHIPMAILINGSEGMENTACTIVE ID

Entity-Relationship diagram of this table