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 |