RECURRINGGIFTINSTALLMENTEVENT

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
EVENTCODE	tinyint		Default = 0
DATE	date
PROCESSNAME	nvarchar(60)		Default = ''
RESULTCODE	nvarchar(20)		Default = ''
REJECTIONMESSAGE	nvarchar(500)		Default = ''
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)
EVENT	nvarchar(26) (Computed)	yes	CASE [EVENTCODE] WHEN 0 THEN N'Processing' WHEN 1 THEN N'Credit card authorization' WHEN 2 THEN N'Credit card rejection' WHEN 3 THEN N'Direct debit rejection' WHEN 4 THEN N'Installment amount changed' END
OLDAMOUNT	money		Default = 0
NEWAMOUNT	money		Default = 0
AMOUNTCHANGE	money (Computed)	yes	NEWAMOUNT-OLDAMOUNT

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
RECURRINGGIFTINSTALLMENTID	uniqueidentifier		RECURRINGGIFTINSTALLMENT.ID
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID
BATCHID	uniqueidentifier	yes	BATCH.ID
CURRENCYID	uniqueidentifier	yes	CURRENCY.ID
PAYMENTID	uniqueidentifier	yes	FINANCIALTRANSACTION.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_RECURRINGGIFTINSTALLMENTEVENT_BATCHID	BATCHID
IX_RECURRINGGIFTINSTALLMENTEVENT_CURRENCYID	CURRENCYID
IX_RECURRINGGIFTINSTALLMENTEVENT_DATEADDED	DATEADDED			yes
IX_RECURRINGGIFTINSTALLMENTEVENT_DATECHANGED	DATECHANGED
IX_RECURRINGGIFTINSTALLMENTEVENT_PAYMENTID	PAYMENTID
IX_RECURRINGGIFTINSTALLMENTEVENT_RECURRINGGIFTINSTALLMENTID	RECURRINGGIFTINSTALLMENTID
PK_RECURRINGGIFTINSTALLMENTEVENT	ID	yes	yes

Triggers

Trigger Name	Description
TR_RECURRINGGIFTINSTALLMENTEVENT_AUDIT_UPDATE
TR_RECURRINGGIFTINSTALLMENTEVENT_AUDIT_DELETE