MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
NAME	nvarchar(100)		Default = ''
DESCRIPTION	nvarchar(255)		Default = ''
PROCESSPROGRAMSCODE	tinyint		Default = 0
PROCESSPROGRAMS	nvarchar(16) (Computed)	yes	CASE [PROCESSPROGRAMSCODE] WHEN 0 THEN N'All programs' WHEN 1 THEN N'Specific program' END
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)
CREATEOUTPUTIDSET	bit		Default = 0
OUTPUTSELECTIONNAME	nvarchar(100)		Default = ''
OVERWRITEOUTPUTSELECTION	bit		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
MEMBERSHIPPROGRAMID	uniqueidentifier	yes	MEMBERSHIPPROGRAM.ID
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS_DATEADDED	DATEADDED			yes
IX_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS_DATECHANGED	DATECHANGED
PK_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS	ID	yes	yes
UC_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS_NAME	NAME	yes

Triggers

Trigger Name	Description
TR_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS_DELETE_BUSINESSPROCESSINSTANCE
TR_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS_AUDIT_UPDATE
TR_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS_AUDIT_DELETE

Referenced by

Referenced by	Field
MEMBERSHIPPROGRAMCONTRIBUTIONPROCESSSTATUS	PARAMETERSETID