Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 INSTALLMENTMODECODE tinyint   Default = 0 Controls how recurring gift installments behave when payments are posted to them.
 INSTALLMENTMODE nvarchar(44) (Computed) CASE [INSTALLMENTMODECODE] WHEN 0 THEN N'Update installment amounts to match payments' WHEN 1 THEN N'Maintain installment amounts' END Provides a translation for the 'INSTALLMENTMODECODE' field.
 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
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_RECURRINGGIFTSETTING_DATEADDED DATEADDED    
 IX_RECURRINGGIFTSETTING_DATECHANGED DATECHANGED      
 PK_RECURRINGGIFTSETTING ID  

Trigger Name Description
 TR_RECURRINGGIFTSETTING_AUDIT_UPDATE
 TR_RECURRINGGIFTSETTING_AUDIT_DELETE