FACT_RECURRINGGIFTINSTALLMENTPAYMENT

Contains information about recurring gift installment payments.

Primary Key

Primary Key Field Type
RECURRINGGIFTINSTALLMENTPAYMENTFACTID int

Fields

Field Field Type Null Notes Description
REVENUEFACTID int yes Reference key to the revenue fact, derived from [BBDW].[FACT_REVENUE].[REVENUEFACTID]
REVENUEAPPLICATIONSYSTEMID uniqueidentifier yes [dbo].[REVENUESPLIT].[ID] derived from [dbo].[RECURRINGGIFTINSTALLMENTPAYMENT].[PAYMENTID]
RECURRINGGIFTINSTALLMENTPAYMENTSYSTEMID uniqueidentifier yes [dbo].[RECURRINGGIFTINSTALLMENTPAYMENT].[ID]
RECURRINGGIFTINSTALLMENTFACTID int yes Reference key to the recurring gift installment fact, derived from [dbo].[RECURRINGGIFTINSTALLMENTPAYMENT].[RECURRINGGIFTINSTALLMENTID]
RECURRINGGIFTINSTALLMENTPAYMENTAMOUNT money yes [dbo].[REVENUESPLIT].[ORGANIZATIONAMOUNT] derived from [dbo].[RECURRINGGIFTINSTALLMENTPAYMENT].[PAYMENTID]
ISINCLUDED bit yes Flag indicating when data should be included in results.
ETLCONTROLID int yes ID generated through the ETL process.
SOURCEDIMID int yes Source system used.
BASECURRENCYDIMID int yes Reference key to the currency dimension, derived from dbo.[RECURRINGGIFTINSTALLMENTPAYMENT].[BASECURRENCYID]
BASERECURRINGGIFTINSTALLMENTPAYMENTAMOUNT money yes dbo.[RECURRINGGIFTINSTALLMENTPAYMENT].[AMOUNT]
FINANCIALTRANSACTIONFACTID int yes Reference key to financial transaction fact table, derived from [dbo].[FINANCIALTRANSACTION].[ID]
FINANCIALTRANSACTIONLINEITEMFACTID int yes Reference key to financial transaction line item fact table, derived from [dbo].[FINANCIALTRANSACTIONLINEITEM].[ID]
ACTIVITYTYPE nvarchar(8) yes [dbo].[RECURRINGGIFTACTIVITY].[TYPE]
ISFIRSTPAYMENT bit yes First payment for a recurring gift
ISLASTPAYMENT bit yes Last payment for a recurring gift

Indexes

Index Name Fields Unique Primary Clustered
PK_FACT_RECURRINGGIFTINSTALLMENTPAYMENT RECURRINGGIFTINSTALLMENTPAYMENTFACTID yes yes yes