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_BASECURRENCYID BASECURRENCYID      
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_DATEADDED DATEADDED    
 IX_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_DATECHANGED DATECHANGED      
 PK_MKTMEMBERSHIPMAILINGSEGMENTACTIVE ID  

Trigger Name Description
 TR_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_AUDIT_UPDATE
 TR_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_AUDIT_DELETE
 TR_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_IU_ORGANIZATIONAMOUNTS

Entity-Relationship diagram of this table