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_BASECURRENCYID BASECURRENCYID      
 IX_MKTSEGMENTATIONACTIVE_DATEADDED DATEADDED    
 IX_MKTSEGMENTATIONACTIVE_DATECHANGED DATECHANGED      
 PK_MKTSEGMENTATIONACTIVE ID  

Trigger Name Description
 TR_MKTSEGMENTATIONACTIVE_IU_ORGANIZATIONAMOUNTS
 TR_MKTSEGMENTATIONACTIVE_AUDIT_UPDATE
 TR_MKTSEGMENTATIONACTIVE_AUDIT_DELETE

Entity-Relationship diagram of this table