MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS

Stores information linking the instance of membership renewal effort process and mailing process.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

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)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID	uniqueidentifier		MKTMEMBERSHIPRENEWALEFFORTPROCESSSTATUS.ID	The instance of a membership renewal effort process.
MEMBERSHIPMAILINGPROCESSSTATUSID	uniqueidentifier	yes	MKTMEMBERSHIPMAILINGPROCESSSTATUS.ID	The instance of a membership mailing process.
SEGMENTATIONEXPORTPROCESSSTATUSID	uniqueidentifier	yes	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.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_DATEADDED	DATEADDED			yes
IX_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_DATECHANGED	DATECHANGED
IX_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_MEMBERSHIPMAILINGPROCESSSTATUSID	MEMBERSHIPMAILINGPROCESSSTATUSID
IX_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_MEMBERSHIPPROGRAMID	MEMBERSHIPPROGRAMID
IX_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_SEGMENTATIONEXPORTPROCESSSTATUSID	SEGMENTATIONEXPORTPROCESSSTATUSID
PK_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS	ID	yes	yes
UIX_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID_MEMBERSHIPPROGRAMID	MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID, MEMBERSHIPPROGRAMID	yes

Triggers

Trigger Name	Description
TR_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_AUDIT_UPDATE
TR_MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS_AUDIT_DELETE