Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 QUANTITY int   Default = 0 The number of people that were mailed to for the marketing effort.
 RESPONDERS int   Default = 0 The number of people that responded to the marketing effort.
 RESPONSES int   Default = 0 The number of gifts from people that responded to the marketing effort.
 VARIABLECOST money   Default = 0 The package costs for the marketing effort.
 TOTALCOST money   Default = 0 The total cost (variable + fixed) for the marketing effort.
 COSTPERDOLLARRAISED money   Default = 0 The cost per dollar raised for the marketing effort.
 TOTALGIFTAMOUNT money   Default = 0 The total gift amount received for the marketing effort.
 AVERAGEGIFTAMOUNT money   Default = 0 The average gift amount received for the marketing effort.
 RESPONSERATE decimal(19, 4)   Default = 0 The response rate for the marketing effort.
 ROIAMOUNT money   Default = 0 The ROI as a dollar amount for the marketing effort.
 ROIPERCENT decimal(19, 4)   Default = 0 The ROI as a percentage for the marketing effort.
 EXPECTEDRESPONDERS int   Default = 0 The number of expected responders for the marketing effort.
 EXPECTEDTOTALGIFTAMOUNT money   Default = 0 The expected total gift amount for the marketing effort.
 EXPECTEDRESPONSERATE decimal(19, 4)   Default = 0 The expected response rate for the marketing effort.
 EXPECTEDROIAMOUNT money   Default = 0 The expected ROI as a dollar amount for the marketing effort.
 EXPECTEDROIPERCENT decimal(19, 4)   Default = 0 The expected ROI as a percentage for the marketing effort.
 INDIRECTRESPONDERS int   Default = 0 The number of people that indirectly responded to the marketing effort.
 INDIRECTRESPONSES int   Default = 0 The number of gifts from people that indirectly responded to the marketing effort.
 INDIRECTTOTALGIFTAMOUNT money   Default = 0 The total gift amount indirectly received for the marketing effort.
 INDIRECTAVERAGEGIFTAMOUNT money   Default = 0 The average gift amount indirectly received for the marketing 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.
 EXPECTEDCOSTPERDOLLARRAISED money   Default = 0 The expected cost per dollar raised for the marketing effort.
 EXPECTEDAVERAGEGIFTAMOUNT money   Default = 0 The expected average gift amount for the marketing effort.
 UNRESOLVEDRESPONDERS int   Default = 0 The number of people that gave a gift to the appeal but the gift has not been credited to the marketing effort.
 UNRESOLVEDRESPONSES int   Default = 0 The number of gifts that were received for an appeal but the gifts have not been credited to the marketing effort.
 UNRESOLVEDTOTALGIFTAMOUNT money   Default = 0 The total gift amount that was received for an appeal but the gifts have not been credited to the marketing effort.
 UNRESOLVEDAVERAGEGIFTAMOUNT money   Default = 0 The average gift amount that was received for an appeal but the gifts have not been credited to the marketing effort.
 ORGANIZATIONVARIABLECOST money   Default = 0 The package costs, in organization currency, for the marketing effort.
 ORGANIZATIONTOTALCOST money   Default = 0 The total cost (variable + fixed), in organization currency, for the marketing effort.
 ORGANIZATIONCOSTPERDOLLARRAISED money   Default = 0 The cost per dollar raised, in organization currency, for the marketing effort.
 ORGANIZATIONTOTALGIFTAMOUNT money   Default = 0 The total gift amount, in organization currency, received for the marketing effort.
 ORGANIZATIONAVERAGEGIFTAMOUNT money   Default = 0 The average gift amount, in organization currency, received for the marketing effort.
 ORGANIZATIONROIAMOUNT money   Default = 0 The ROI as a dollar amount, in organization currency, for the marketing effort.
 ORGANIZATIONEXPECTEDCOSTPERDOLLARRAISED money   Default = 0 The expected cost per dollar raised, in organization currency, for the marketing effort.
 ORGANIZATIONEXPECTEDTOTALGIFTAMOUNT money   Default = 0 The expected total gift amount, in organization currency, for the marketing effort.
 ORGANIZATIONEXPECTEDAVERAGEGIFTAMOUNT money   Default = 0 The expected average gift amount, in organization currency, for the marketing effort.
 ORGANIZATIONEXPECTEDROIAMOUNT money   Default = 0 The expected ROI as a dollar amount, in organization currency, for the marketing effort.
 ORGANIZATIONINDIRECTTOTALGIFTAMOUNT money   Default = 0 The total gift amount, in organization currency, indirectly received for the marketing effort.
 ORGANIZATIONINDIRECTAVERAGEGIFTAMOUNT money   Default = 0 The average gift amount, in organization currency, indirectly received for the marketing effort.
 ORGANIZATIONUNRESOLVEDTOTALGIFTAMOUNT money   Default = 0 The total gift amount, in organization currency, that was received for an appeal but the gifts have not been credited to the marketing effort.
 ORGANIZATIONUNRESOLVEDAVERAGEGIFTAMOUNT money   Default = 0 The average gift amount, in organization currency, that was received for an appeal but the gifts have not been credited to the marketing effort.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   MKTSEGMENTATION.ID Primary Key.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this activated marketing effort.

Index Name Field(s) Unique Primary Clustered
 IX_MKTSEGMENTATIONACTIVE_AVERAGEGIFTAMOUNT AVERAGEGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_BASECURRENCYID BASECURRENCYID      
 IX_MKTSEGMENTATIONACTIVE_COSTPERDOLLARRAISED COSTPERDOLLARRAISED      
 IX_MKTSEGMENTATIONACTIVE_DATEADDED DATEADDED    
 IX_MKTSEGMENTATIONACTIVE_DATECHANGED DATECHANGED      
 IX_MKTSEGMENTATIONACTIVE_EXPECTEDAVERAGEGIFTAMOUNT EXPECTEDAVERAGEGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_EXPECTEDCOSTPERDOLLARRAISED EXPECTEDCOSTPERDOLLARRAISED      
 IX_MKTSEGMENTATIONACTIVE_EXPECTEDRESPONDERS EXPECTEDRESPONDERS      
 IX_MKTSEGMENTATIONACTIVE_EXPECTEDRESPONSERATE EXPECTEDRESPONSERATE      
 IX_MKTSEGMENTATIONACTIVE_EXPECTEDROIAMOUNT EXPECTEDROIAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_EXPECTEDROIPERCENT EXPECTEDROIPERCENT      
 IX_MKTSEGMENTATIONACTIVE_EXPECTEDTOTALGIFTAMOUNT EXPECTEDTOTALGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_INDIRECTAVERAGEGIFTAMOUNT INDIRECTAVERAGEGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_INDIRECTRESPONDERS INDIRECTRESPONDERS      
 IX_MKTSEGMENTATIONACTIVE_INDIRECTRESPONSES INDIRECTRESPONSES      
 IX_MKTSEGMENTATIONACTIVE_INDIRECTTOTALGIFTAMOUNT INDIRECTTOTALGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONAVERAGEGIFTAMOUNT ORGANIZATIONAVERAGEGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONCOSTPERDOLLARRAISED ORGANIZATIONCOSTPERDOLLARRAISED      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONEXPECTEDAVERAGEGIFTAMOUNT ORGANIZATIONEXPECTEDAVERAGEGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONEXPECTEDCOSTPERDOLLARRAISED ORGANIZATIONEXPECTEDCOSTPERDOLLARRAISED      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONEXPECTEDROIAMOUNT ORGANIZATIONEXPECTEDROIAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONEXPECTEDTOTALGIFTAMOUNT ORGANIZATIONEXPECTEDTOTALGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONINDIRECTAVERAGEGIFTAMOUNT ORGANIZATIONINDIRECTAVERAGEGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONINDIRECTTOTALGIFTAMOUNT ORGANIZATIONINDIRECTTOTALGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONROIAMOUNT ORGANIZATIONROIAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONTOTALCOST ORGANIZATIONTOTALCOST      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONTOTALGIFTAMOUNT ORGANIZATIONTOTALGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONUNRESOLVEDAVERAGEGIFTAMOUNT ORGANIZATIONUNRESOLVEDAVERAGEGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONUNRESOLVEDTOTALGIFTAMOUNT ORGANIZATIONUNRESOLVEDTOTALGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_ORGANIZATIONVARIABLECOST ORGANIZATIONVARIABLECOST      
 IX_MKTSEGMENTATIONACTIVE_QUANTITY QUANTITY      
 IX_MKTSEGMENTATIONACTIVE_RESPONDERS RESPONDERS      
 IX_MKTSEGMENTATIONACTIVE_RESPONSERATE RESPONSERATE      
 IX_MKTSEGMENTATIONACTIVE_RESPONSES RESPONSES      
 IX_MKTSEGMENTATIONACTIVE_ROIAMOUNT ROIAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_ROIPERCENT ROIPERCENT      
 IX_MKTSEGMENTATIONACTIVE_TOTALCOST TOTALCOST      
 IX_MKTSEGMENTATIONACTIVE_TOTALGIFTAMOUNT TOTALGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_UNRESOLVEDAVERAGEGIFTAMOUNT UNRESOLVEDAVERAGEGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_UNRESOLVEDRESPONDERS UNRESOLVEDRESPONDERS      
 IX_MKTSEGMENTATIONACTIVE_UNRESOLVEDRESPONSES UNRESOLVEDRESPONSES      
 IX_MKTSEGMENTATIONACTIVE_UNRESOLVEDTOTALGIFTAMOUNT UNRESOLVEDTOTALGIFTAMOUNT      
 IX_MKTSEGMENTATIONACTIVE_VARIABLECOST VARIABLECOST      
 PK_MKTSEGMENTATIONACTIVE ID  

Trigger Name Description
 TR_MKTSEGMENTATIONACTIVE_AUDIT_UPDATE
 TR_MKTSEGMENTATIONACTIVE_AUDIT_DELETE
 TR_MKTSEGMENTATIONACTIVE_IU_ORGANIZATIONAMOUNTS

Entity-Relationship diagram of this table