Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 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.

Foreign Key Field Type Null Notes Description
 MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID uniqueidentifier   MKTMEMBERSHIPRENEWALEFFORTPROCESSSTATUS.ID The instance of a membership renewal effort process.
 MEMBERSHIPMAILINGPROCESSSTATUSID uniqueidentifier MKTMEMBERSHIPMAILINGPROCESSSTATUS.ID The instance of a membership mailing process.
 SEGMENTATIONEXPORTPROCESSSTATUSID uniqueidentifier MKTSEGMENTATIONEXPORTPROCESSSTATUS.ID The instance of a membership mailing process.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 MEMBERSHIPPROGRAMID uniqueidentifier   MEMBERSHIPPROGRAM.ID The membership program the membership mailing process is for.

Index Name Field(s) Unique Primary Clustered
 IX_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_DATEADDED DATEADDED    
 IX_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_DATECHANGED DATECHANGED      
 IX_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_MEMBERSHIPMAILINGPROCESSSTATUSID MEMBERSHIPMAILINGPROCESSSTATUSID      
 IX_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_MEMBERSHIPPROGRAMID MEMBERSHIPPROGRAMID      
 IX_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_SEGMENTATIONEXPORTPROCESSSTATUSID SEGMENTATIONEXPORTPROCESSSTATUSID      
 PK_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS ID  
 UIX_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID_MEMBERSHIPPROGRAMID MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID, MEMBERSHIPPROGRAMID    

Trigger Name Description
 TR_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_AUDIT_UPDATE
 TR_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_AUDIT_DELETE

Entity-Relationship diagram of this table