| RECURRINGGIFTDEVELOPMENTHISTORYSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY].[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] |
| RECURRINGGIFTDEVELOPMENTDIMID |
int |
yes |
|
Reference key to the recurring gift development dimension, derived using [dbo].[RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY].[FREQUENCYCODE], [dbo].[RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY].[PREVIOUSFREQUENCYCODE], [dbo].[REVENUEDEVELOPMENTFUNCTION].[REVENEUDEVELOPMENTFUNCTIONCODEID] |
| RECURRINGGIFTDEVELOPMENTHISTORYDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY].[TRANSACTIONDATE] |
| RECURRINGGIFTDEVELOPMENTHISTORYDATE |
datetime |
yes |
|
dbo.[RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY].[TRANSACTIONDATE] |
| AMOUNT |
money |
yes |
|
dbo.[RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY].[ORGANIZATIONAMOUNT] |
| PREVIOUSAMOUNT |
money |
yes |
|
dbo.[RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY].[PREVIOUSORGANIZATIONAMOUNT] |
| 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.[RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY].[BASECURRENCYID] |
| BASEAMOUNT |
money |
yes |
|
dbo.[RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY].[AMOUNT] |
| BASEPREVIOUSAMOUNT |
money |
yes |
|
dbo.[RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY].[PREVIOUSAMOUNT] |
| 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] |