Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SEQUENCE int   Default = 0
 TRANSACTIONDATE date  
 AMOUNT money   Default = 0 The recurring gift amount.
 FREQUENCYCODE tinyint   Default = 0 The recurring gift installment frequency.
 FREQUENCY nvarchar(13) (Computed) CASE [FREQUENCYCODE] WHEN 0 THEN N'Annually' WHEN 1 THEN N'Semi-annually' WHEN 2 THEN N'Quarterly' WHEN 3 THEN N'Monthly' WHEN 6 THEN N'Bimonthly' WHEN 7 THEN N'Semi-Monthly' WHEN 8 THEN N'Biweekly' WHEN 9 THEN N'Weekly' END Provides a translation for the 'FREQUENCYCODE' field.
 PREVIOUSAMOUNT money   Default = 0 The previous recurring gift amount.
 PREVIOUSFREQUENCYCODE tinyint   Default = 0 The previous recurring gift installment frequency.
 PREVIOUSFREQUENCY nvarchar(13) (Computed) CASE [PREVIOUSFREQUENCYCODE] WHEN 0 THEN N'Annually' WHEN 1 THEN N'Semi-annually' WHEN 2 THEN N'Quarterly' WHEN 3 THEN N'Monthly' WHEN 6 THEN N'Bimonthly' WHEN 7 THEN N'Semi-Monthly' WHEN 8 THEN N'Biweekly' WHEN 9 THEN N'Weekly' END Provides a translation for the 'PREVIOUSFREQUENCYCODE' field.
 AMOUNTCHANGE money (Computed) case when SEQUENCE > 0 and FREQUENCYCODE = PREVIOUSFREQUENCYCODE then AMOUNT-PREVIOUSAMOUNT end The change in recurring gift amount, if the frequency is unchanged.
 SOURCECODE nvarchar(50)   Default = '' The direct marketing source code on the recurring gift.
 FINDERNUMBER bigint   Default = ((0)) The direct marketing finder number on the recurring gift.
 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.
 ORGANIZATIONAMOUNT money   Default = 0 The amount of the recurring gift in organization currency.
 PREVIOUSORGANIZATIONAMOUNT money   Default = 0 The previous amount of the recurring gift in organization currency.
 TRANSACTIONAMOUNT money   Default = 0 The amount of the recurring gift in transaction currency.
 PREVIOUSTRANSACTIONAMOUNT money   Default = 0 The previous amount of the recurring gift in transaction currency.
 ORGANIZATIONAMOUNTCHANGE money (Computed) case when SEQUENCE > 0 and FREQUENCYCODE = PREVIOUSFREQUENCYCODE then ORGANIZATIONAMOUNT-PREVIOUSORGANIZATIONAMOUNT end The change in recurring gift organization amount, if the frequency is unchanged.
 TRANSACTIONAMOUNTCHANGE money (Computed) case when SEQUENCE > 0 and FREQUENCYCODE = PREVIOUSFREQUENCYCODE then TRANSACTIONAMOUNT-PREVIOUSTRANSACTIONAMOUNT end The change in recurring gift transaction amount, if the frequency is unchanged.

Foreign Key Field Type Null Notes Description
 REVENUEID uniqueidentifier   FINANCIALTRANSACTION.ID FK to REVENUE
 REVENUEDEVELOPMENTFUNCTIONID uniqueidentifier REVENUEDEVELOPMENTFUNCTION.ID FK to REVENUEDEVELOPMENTFUNCTION
 APPEALID uniqueidentifier APPEAL.LOCALID The appeal on the recurring gift.
 MAILINGID uniqueidentifier MKTSEGMENTATION.ID The mailing on the recurring gift.
 CHANNELCODEID uniqueidentifier CHANNELCODE.ID The channel on the recurring gift.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this recurring gift.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to calculate the organization amount.
 PREVIOUSORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to calculate the previous organization amount.
 TRANSACTIONCURRENCYID uniqueidentifier CURRENCY.ID The transaction currency associated with this recurring gift.
 BASEEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to calculate the base amount.
 PREVIOUSBASEEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to calculate the previous base amount.

Index Name Field(s) Unique Primary Clustered
 IX_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY_APPEALID APPEALID      
 IX_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY_CHANNELCODEID CHANNELCODEID      
 IX_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY_DATEADDED DATEADDED    
 IX_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY_DATECHANGED DATECHANGED      
 IX_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY_MAILINGID MAILINGID      
 IX_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY_REVENUEID REVENUEID      
 IX_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY_SOURCECODE SOURCECODE      
 PK_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY ID  
 UIX_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY_REVENUEDEVELOPMENTFUNCTIONID REVENUEDEVELOPMENTFUNCTIONID    

Trigger Name Description
 TR_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY_AUDIT_ETLDELETEDID
 TR_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY_AUDIT_UPDATE
 TR_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY_AUDIT_DELETE
 TR_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY_INSERTUPDATE_CURRENCY

Entity-Relationship diagram of this table