SEPAMANDATE

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
SIGNATUREDATE	date	yes
TYPECODE	tinyint		Default = 0
TYPE	nvarchar(9) (Computed)	yes	CASE [TYPECODE] WHEN 0 THEN N'One-off' WHEN 1 THEN N'Recurrent' END
STATUSCODE	tinyint		Default = 0
STATUS	nvarchar(17) (Computed)	yes	CASE [STATUSCODE] WHEN 0 THEN N'Pending signature' WHEN 1 THEN N'Active' WHEN 2 THEN N'Closed' WHEN 3 THEN N'Expired' END
PAYMENTCOUNT	int		Default = 0
CUSTOMIDENTIFIER	nvarchar(100)		Default = ''
SEQUENCEID	int
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)
LOOKUPID	nvarchar(100) (Computed)	yes	(CASE LEN(CUSTOMIDENTIFIER) WHEN 0 THEN 'mnd-' + CAST(SEQUENCEID AS nvarchar(20)) ELSE CUSTOMIDENTIFIER END)

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
CONSTITUENTACCOUNTID	uniqueidentifier	yes	CONSTITUENTACCOUNT.ID
BATCHREVENUECONSTITUENTACCOUNTID	uniqueidentifier	yes	BATCHREVENUECONSTITUENTACCOUNT.ID
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID
BATCHSPONSORSHIPCONSTITUENTACCOUNTID	uniqueidentifier	yes	BATCHSPONSORSHIPCONSTITUENTACCOUNT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_SEPAMANDATE_BATCHREVENUECONSTITUENTACCOUNTID	BATCHREVENUECONSTITUENTACCOUNTID
IX_SEPAMANDATE_CONSTITUENTACCOUNTID	CONSTITUENTACCOUNTID
IX_SEPAMANDATE_DATEADDED	DATEADDED			yes
IX_SEPAMANDATE_DATECHANGED	DATECHANGED
PK_SEPAMANDATE	ID	yes	yes
UC_SEPAMANDATE_LOOKUPID	LOOKUPID	yes

Triggers

Trigger Name	Description
TR_SEPAMANDATE_AUDIT_UPDATE
TR_SEPAMANDATE_AUDIT_DELETE

Referenced by

Referenced by	Field
BATCHMEMBERSHIPDUES	SEPAMANDATEID
BATCHREVENUE	SEPAMANDATEID
BATCHSPONSORSHIP	SEPAMANDATEID
DIRECTDEBITPAYMENTMETHODDETAIL	SEPAMANDATEID
RECURRINGGIFTAMENDMENT	SEPAMANDATEID
RECURRINGGIFTAMENDMENT	PREVIOUSSEPAMANDATEID
REVENUESCHEDULEDIRECTDEBITPAYMENT	SEPAMANDATEID
SEPAMANDATEACTIVITY	SEPAMANDATEID