| FINANCIALTRANSACTIONLINEITEMSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[FINANCIALTRANSACTIONLINEITEM].[ID] |
| FINANCIALTRANSACTIONFACTID |
int |
yes |
|
Reference key to FACT_FINANCIALTRANSACTION, derived from dbo.[FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONID] |
| FINANCIALTRANSACTIONSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[FINANCIALTRANSACTION].[ID] |
| FINANCIALTRANSACTIONSEQUENCEID |
int |
yes |
|
dbo.[FINANCIALTRANSACTION].[SEQUENCEGENERATORID] |
| FINANCIALTRANSACTIONLOOKUPID |
nvarchar(100) |
yes |
|
dbo.[FINANCIALTRANSACTION].[USERDEFINEDID] |
| REVENUECODEDIMID |
int |
yes |
|
BBDW.[DIM_REVENUECODE].[REVENUECODEDIMID] |
| REVENUEFLAGDIMID |
int |
yes |
|
Reference key to the revenue code dimension, derived from the codes on dbo.[FINANCIALTRANSACTION], dbo.[REVENUE_EXT] and dbo.[REVENUEPAYMENTMETHOD] |
| REVENUECHANNELDIMID |
int |
yes |
|
Reference key to the appeal dimension, derived from dbo.[REVENUE_EXT].[CHANNELCODEID] |
| FINANCIALTRANSACTIONDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[FINANCIALTRANSACTION].[DATE] |
| FINANCIALTRANSACTIONDATE |
datetime |
yes |
|
dbo.[FINANCIALTRANSACTION].[DATE] cast as datetime |
| FINANCIALTRANSACTIONPOSTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[FINANCIALTRANSACTION].[POSTDATE] |
| FINANCIALTRANSACTIONPOSTDATE |
datetime |
yes |
|
dbo.[FINANCIALTRANSACTION].[POSTDATE] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from dbo.[FINANCIALTRANSACTION].[CONSTITUENTID] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[FINANCIALTRANSACTION].[CONSTITUENTID] |
| APPEALDIMID |
int |
yes |
|
Reference key to the appeal dimension, derived from dbo.[REVENUE_EXT].[APPEALID] |
| MARKETINGSEGMENTDIMID |
int |
yes |
|
Reference key to the marketing segment dimension, derived from dbo.[REVENUESEGMENT].[SEGMENTID] and dbo.[REVENUESEGMENT].[TESTSEGMENTID] |
| MARKETINGSOURCECODEDIMID |
int |
yes |
|
Reference key to the marketing source code dimension, derived from dbo.[REVENUESEGMENT].[SOURCECODEMAPID] |
| MARKETINGCONSTITUENTFACTID |
bigint |
yes |
|
Reference key to the marketing constituent fact, derived from dbo.[FINANCIALTRANSACTION].[CONSTITUENTID], dbo.[REVENUESEGMENT].[SEGMENTID] and dbo.[REVENUESEGMENT].[TESTSEGMENTID] |
| FINANCIALTRANSACTIONAMOUNT |
money |
yes |
|
dbo.[FINANCIALTRANSACTION].[ORGAMOUNT] |
| FINANCIALTRANSACTIONRECEIPTAMOUNT |
money |
yes |
|
dbo.[REVENUE_EXT].[RECEIPTAMOUNT] |
| BASECURRENCYDIMID |
int |
yes |
|
Reference key to the currency dimension, derived from dbo.[PDACCOUNTSYSTEM].[CURRENCYID] |
| FINANCIALTRANSACTIONBASEAMOUNT |
money |
yes |
|
dbo.[FINANCIALTRANSACTION].[BASEAMOUNT] |
| FINANCIALTRANSACTIONDATETIMEOFFSET |
datetimeoffset |
yes |
|
dbo.[FINANCIALTRANSACTION].[DATE] |
| ACCOUNTSYSTEMDIMID |
int |
yes |
|
Reference key to the account system dimension, derived from dbo.[FINANCIALTRANSACTION].[PDACCOUNTSYSTEMID] |
| APPUSERDIMID |
int |
yes |
|
Reference key to appuser dimension, derived from [dbo].[APPUSER][ID] |
| CHECKNUMBER |
nvarchar(50) |
yes |
|
dbo.[CHECKPAYMENTMETHODDETAIL].[CHECKNUMBER] |
| CREDITCARDTYPEDIMID |
int |
yes |
|
Reference key to creditcardtype dimension, derived from [dbo].[CREDITCARDTYPE][ID] |
| CHECKFUZZYDATE |
char(8) |
yes |
|
dbo.[CHECKPAYMENTMETHODDETAIL].[CHECKDATE] |
| GLREVENUECATEGORYDIMID |
int |
yes |
|
Reference key to the GL revenue category dimension, derived from dbo.[REVENUECATEGORY].[GLREVENUECATEGORYID] |
| FINANCIALTRANSACTIONLINEITEMPOSTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[FINANCIALTRANSACTIONLINEITEM].[POSTDATE] |
| FINANCIALTRANSACTIONLINEITEMPOSTDATE |
datetime |
yes |
|
dbo.[FINANCIALTRANSACTIONLINEITEM].[POSTDATE] |
| DESIGNATIONDIMID |
int |
yes |
|
Reference key to the designation dimension, derived from dbo.[REVENUESPLIT_EXT].[DESIGNATIONID] |
| PURPOSELEVEL1DIMID |
int |
yes |
|
Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL1ID] |
| PURPOSELEVEL2DIMID |
int |
yes |
|
Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL2ID] |
| PURPOSELEVEL3DIMID |
int |
yes |
|
Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL3ID] |
| PURPOSELEVEL4DIMID |
int |
yes |
|
Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL4ID] |
| PURPOSELEVEL5DIMID |
int |
yes |
|
Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL5ID] |
| EVENTREGISTRANTFACTID |
int |
yes |
|
Reference key to the event registrant fact, derived from dbo.[EVENTREGISTRANTPAYMENT].[REGISTRANTID] |
| FINANCIALTRANSACTIONLINEITEMAMOUNT |
money |
yes |
|
dbo.[FINANCIALTRANSACTIONLINEITEM].[ORGAMOUNT] |
| FINANCIALTRANSACTIONLINEITEMBASEAMOUNT |
money |
yes |
|
dbo.[FINANCIALTRANSACTIONLINEITEM].[BASEAMOUNT] |
| CHANGEDDATEDIMID |
int |
yes |
|
Reference key to date dimension, derived from [dbo].[REVENUE].[DATECHANGED] |
| CHANGEDDATE |
datetime |
yes |
|
dbo.[FINANCIALTRANSACTION].[DATECHANGED] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| BATCHNUMBER |
nvarchar(100) |
yes |
|
dbo.[REVENUE_EXT].[BATCHNUMBER] |
| SOURCELINEITEMFACTID |
int |
yes |
|
Reference key to financial transaction line item fact table, derived from [dbo].[FINANCIALTRANSACTIONLINEITEM].[SOURCELINEITEMID] |
| FINANCIALTRANSACTIONLINEITEMADJUSTMENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMADJUSTMENTID] |
| ADJUSTMENTCONSTITUENTDIMID |
int |
yes |
|
Reference key to constituent dimension, derived from [dbo].[FINANCIALTRANSACTIONLINEITEMADJUSTMENT].[CONSTITUENTID] |
| ADJUSTMENTDATEDIMID |
int |
yes |
|
Reference key to date dimension, derived from [dbo].[FINANCIALTRANSACTIONLINEITEMADJUSTMENT].[DATE] |
| ADJUSTMENTDATE |
datetime |
yes |
|
dbo.[FINANCIALTRANSACTIONLINEITEMADJUSTMENT].[DATE] |
| ADJUSTMENTREASONDIMID |
int |
yes |
|
Reference key to adjustment reason dimension, derived from [dbo].FINANCIALTRANSACTIONLINEITEMADJUSTMENT].[ADJUSTMENTREASONCODEID] |
| TRANSACTIONBALANCE |
money |
yes |
|
Calculated pledge balance, (Pledge amount - Writeoffs - Payments) |
| LINEITEMBALANCE |
money |
yes |
|
Calculated line item pledge balance, (Pledge amount - Writeoffs - Payments) |
| TRANSACTIONCURRENCYDIMID |
int |
yes |
|
Reference key to the currency dimension, derived from dbo.[FINANCIALTRANSACTION].[TRANSACTIONCURRENCYID] |
| MARKETINGSEGMENTATIONDIMID |
int |
yes |
|
Reference key to the marketing effort dimension, derived from dbo.[MKTSEGMENTATION].[ID] |
| FINANCIALTRANSACTIONLINEITEMTRANSACTIONAMOUNT |
money |
yes |
|
dbo.[FINANCIALTRANSACTIONLINEITEM].[TRANSACTIONAMOUNT] |
| REVENUESCHEDULEDIMID |
int |
yes |
|
Reference key to the revenue schedule dimension, derived using the combination flags and codes on [dbo].[REVENUESCHEDULE] |
| ADDEDDATE |
datetime |
yes |
|
[dbo].[FINANCIALTRANSACTION].[DATEADDED] |
| ADDEDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived using [dbo].[FINANCIALTRANSACTION].[DATEADDED] |
| OTHERPAYMENTMETHODDIMID |
int |
yes |
|
Reference key to other payment method dimension, derived from [dbo].[OTHERPAYMENTMETHODDETAIL].[OTHERPAYMENTMETHODCODEID] |
| PLANNEDGIFTDIMID |
int |
yes |
|
Reference key to the planned gift dimension, derived from dbo.[PLANNEDGIFTREVENUESPLIT].[PLANNEDGIFTID] |
| REVERSEDFINANCIALTRANSACTIONLINEITEMSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[FINANCIALTRANSACTIONLINEITEM].[REVERSEDLINEITEMID] |
| REVERSEDFINANCIALTRANSACTIONLINEITEMFACTID |
int |
yes |
|
Reference key to the financial transaction line item fact, derived from dbo.[FINANCIALTRANSACTIONLINEITEM].[REVERSEDLINEITEMID] |
| OTHERREVENUETYPEDIMID |
int |
yes |
|
Reference key to other revenue type dimension, derived from [dbo].[REVENUESPLITOTHER].[OTHERTYPECODEID] |