| RECURRINGGIFTINSTALLMENTSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[RECURRINGGIFTINSTALLMENT].[ID] |
| REVENUEFACTID |
int |
yes |
|
Reference key to the revenue fact, derived from [BBDW].[FACT_REVENUE].[REVENUEFACTID] |
| REVENUESCHEDULEDIMID |
int |
yes |
|
Reference key to the revenue schedule dimension, derived using the combination flags and codes on [dbo].[REVENUESCHEDULE] |
| REVENUESCHEDULESTARTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[REVENUESCHEDULE].[STARTDATE] |
| REVENUESCHEDULESTARTDATE |
datetime |
yes |
|
dbo.[REVENUESCHEDULE].[STARTDATE] |
| REVENUESCHEDULEENDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[REVENUESCHEDULE].[ENDDATE] |
| REVENUESCHEDULEENDDATE |
datetime |
yes |
|
dbo.[REVENUESCHEDULE].[ENDDATE] |
| RECURRINGGIFTINSTALLMENTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[RECURRINGGIFTINSTALLMENT].[DATE] |
| RECURRINGGIFTINSTALLMENTDATE |
datetime |
yes |
|
dbo.[RECURRINGGIFTINSTALLMENT].[DATE] |
| RECURRINGGIFTINSTALLMENTAMOUNT |
money |
yes |
|
[dbo].[RECURRINGGIFTINSTALLMENT].[ORGANIZATIONAMOUNT] |
| ISFIRSTINSTALLMENT |
bit |
yes |
|
Flag indicating this is the first installment for a recurring gift |
| ISLASTINSTALLMENT |
bit |
yes |
|
Flag indicating this is the last installment for a recurring gift |
| ISMISSEDINSTALLMENT |
bit |
yes |
|
Flag indicating this is a missing installment for a recurring gift |
| ISFUTUREINSTALLMENT |
bit |
yes |
|
Flag indicating this is a future installment for a recurring gift |
| 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.[RECURRINGGIFTINSTALLMENT].[BASECURRENCYID] |
| BASERECURRINGGIFTINSTALLMENTAMOUNT |
money |
yes |
|
dbo.[RECURRINGGIFTINSTALLMENT].[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] |
| RECURRINGGIFTFLAGDIMID |
int |
yes |
|
Reference key to the recurring gift flag dimension, derived from bbdw.[FACT_RECURRINGGIFTINSTALLMENT].[ISFIRSTINSTALLMENT], bbdw.[FACT_RECURRINGGIFTINSTALLMENT].[ISLASTINSTALLMENT], bbdw.[FACT_RECURRINGGIFTINSTALLMENT].[ISMISSEDINSTALLMENT], and bbdw.[FACT_RECURRINGGIFTINSTALLMENT].[ISFUTUREINSTALLMENT] |
| PASTDUEDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[RECURRINGGIFTINSTALLMENT].[PASTDUEDATE] |
| PASTDUEDATE |
datetime |
yes |
|
dbo.[RECURRINGGIFTINSTALLMENT].[PASTDUEDATE] |
| RECURRINGGIFTINSTALLMENTSTATUSCODE |
smallint |
yes |
|
dbo.[RECURRINGGIFTINSTALLMENT].[STATUSCODE] |
| RECURRINGGIFTINSTALLMENTSTATUS |
nvarchar(25) |
yes |
|
dbo.[RECURRINGGIFTINSTALLMENT].[STATUS] |
| RECURRINGGIFTINSTALLMENTBALANCE |
money |
yes |
|
Recurring gift installment balance. |