Primary Key Field Type
 ID uniqueidentifier

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

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   MKTSEGMENTATIONSEGMENTACTIVE.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 segment.

Index Name Field(s) Unique Primary Clustered
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_AVERAGERENEWALAMOUNT AVERAGERENEWALAMOUNT      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_BASECURRENCYID BASECURRENCYID      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_COSTPERRENEWAL COSTPERRENEWAL      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_DATEADDED DATEADDED    
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_DATECHANGED DATECHANGED      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_DOWNGRADERATE DOWNGRADERATE      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_DOWNGRADES DOWNGRADES      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_ORGANIZATIONAVERAGERENEWALAMOUNT ORGANIZATIONAVERAGERENEWALAMOUNT      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_ORGANIZATIONCOSTPERRENEWAL ORGANIZATIONCOSTPERRENEWAL      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_ORGANIZATIONTOTALRENEWALAMOUNT ORGANIZATIONTOTALRENEWALAMOUNT      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_RENEWALRATE RENEWALRATE      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_RENEWALS RENEWALS      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_TOTALRENEWALAMOUNT TOTALRENEWALAMOUNT      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_UPGRADERATE UPGRADERATE      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_UPGRADES UPGRADES      
 PK_MKTMEMBERSHIPMAILINGSEGMENTACTIVE ID  

Trigger Name Description
 TR_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_IU_ORGANIZATIONAMOUNTS
 TR_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_AUDIT_UPDATE
 TR_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_AUDIT_DELETE

Entity-Relationship diagram of this table