FACT_RECURRINGGIFTINSTALLMENTWRITEOFF

Contains information about recurring gift installment write-offs.

Primary Key

Primary Key Field Type
RECURRINGGIFTINSTALLMENTWRITEOFFFACTID int

Fields

Field Field Type Null Notes Description
RECURRINGGIFTINSTALLMENTWRITEOFFSYSTEMID uniqueidentifier yes [dbo].[RECURRINGGIFTINSTALLMENTWRITEOFF].[ID]
RECURRINGGIFTINSTALLMENTFACTID int yes Reference key to the installment fact, derived from [dbo].[RECURRINGGIFTINSTALLMENTWRITEOFF].[RECURRINGGIFTINSTALLMENTID]
WRITEOFFDATEDIMID int yes Reference key to the date dimension, derived from [dbo].[RECURRINGGIFTWRITEOFF].[DATE]
WRITEOFFDATE datetime yes [dbo].[RECURRINGGIFTWRITEOFF].[DATE]
WRITEOFFDIMID int yes Reference key to the write-off dimension, derived from [dbo].[RECURRINGGIFTWRITEOFF].[REASONCODEID]
WRITEOFFAMOUNT money [dbo].[RECURRINGGIFTINSTALLMENTWRITEOFF].[ORGANIZATIONAMOUNT]
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.[RECURRINGGIFTINSTALLMENTWRITEOFF].[BASECURRENCYID]
BASEWRITEOFFAMOUNT money yes dbo.[RECURRINGGIFTINSTALLMENTWRITEOFF].[AMOUNT]
FINANCIALTRANSACTIONSYSTEMID uniqueidentifier yes dbo.[RECURRINGGIFTWRITEOFF].[REVENUEID]
FINANCIALTRANSACTIONFACTID int yes Reference key to the financial transaction fact, derived from dbo.[RECURRINGGIFTWRITEOFF].[REVENUEID]

Indexes

Index Name Fields Unique Primary Clustered
PK_FACT_RECURRINGGIFTINSTALLMENTWRITEOFF RECURRINGGIFTINSTALLMENTWRITEOFFFACTID yes yes yes