Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 RENEWALS int   Default = 0 The number of people who renewed their membership as a result of the membership renewal effort.
 UPGRADES int   Default = 0 The number of people who upgraded their membership as a result of the membership renewal effort.
 DOWNGRADES int   Default = 0 The number of people who downgraded their membership as a result of the membership renewal effort.
 TOTALRENEWALAMOUNT money   Default = 0 The total gift amount related to renewals received for the membership renewal effort.
 AVERAGERENEWALAMOUNT money   Default = 0 The average gift amount related to renewals received for the membership renewal effort.
 COSTPERRENEWAL money   Default = 0 The cost per renewal for the membership renewal effort.
 RENEWALRATE decimal(19, 4)   Default = 0 The renewal rate for the membership renewal effort.
 UPGRADERATE decimal(19, 4)   Default = 0 The upgrade rate for the membership renewal effort.
 DOWNGRADERATE decimal(19, 4)   Default = 0 The downgrade rate for the membership renewal 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.
 ORGANIZATIONTOTALRENEWALAMOUNT money   Default = 0 The total gift amount, in organization currency, related to renewals received for the membership renewal effort.
 ORGANIZATIONAVERAGERENEWALAMOUNT money   Default = 0 The average gift amount, in organization currency, related to renewals received for the membership renewal effort.
 ORGANIZATIONCOSTPERRENEWAL money   Default = 0 The cost per renewal, in organization currency, for the membership renewal 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 membership effort.

Index Name Field(s) Unique Primary Clustered
 IX_MKTMEMBERSHIPMAILINGACTIVE_AVERAGERENEWALAMOUNT AVERAGERENEWALAMOUNT      
 IX_MKTMEMBERSHIPMAILINGACTIVE_BASECURRENCYID BASECURRENCYID      
 IX_MKTMEMBERSHIPMAILINGACTIVE_COSTPERRENEWAL COSTPERRENEWAL      
 IX_MKTMEMBERSHIPMAILINGACTIVE_DATEADDED DATEADDED    
 IX_MKTMEMBERSHIPMAILINGACTIVE_DATECHANGED DATECHANGED      
 IX_MKTMEMBERSHIPMAILINGACTIVE_DOWNGRADERATE DOWNGRADERATE      
 IX_MKTMEMBERSHIPMAILINGACTIVE_DOWNGRADES DOWNGRADES      
 IX_MKTMEMBERSHIPMAILINGACTIVE_ORGANIZATIONAVERAGERENEWALAMOUNT ORGANIZATIONAVERAGERENEWALAMOUNT      
 IX_MKTMEMBERSHIPMAILINGACTIVE_ORGANIZATIONCOSTPERRENEWAL ORGANIZATIONCOSTPERRENEWAL      
 IX_MKTMEMBERSHIPMAILINGACTIVE_ORGANIZATIONTOTALRENEWALAMOUNT ORGANIZATIONTOTALRENEWALAMOUNT      
 IX_MKTMEMBERSHIPMAILINGACTIVE_RENEWALRATE RENEWALRATE      
 IX_MKTMEMBERSHIPMAILINGACTIVE_RENEWALS RENEWALS      
 IX_MKTMEMBERSHIPMAILINGACTIVE_TOTALRENEWALAMOUNT TOTALRENEWALAMOUNT      
 IX_MKTMEMBERSHIPMAILINGACTIVE_UPGRADERATE UPGRADERATE      
 IX_MKTMEMBERSHIPMAILINGACTIVE_UPGRADES UPGRADES      
 PK_MKTMEMBERSHIPMAILINGACTIVE ID  

Trigger Name Description
 TR_MKTMEMBERSHIPMAILINGACTIVE_IU_ORGANIZATIONAMOUNTS
 TR_MKTMEMBERSHIPMAILINGACTIVE_AUDIT_UPDATE
 TR_MKTMEMBERSHIPMAILINGACTIVE_AUDIT_DELETE

Entity-Relationship diagram of this table