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 |