| RECURRINGGIFTAMENDMENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[ID] |
| FINANCIALTRANSACTIONSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[FINANCIALTRANSACTIONID] |
| FINANCIALTRANSACTIONFACTID |
int |
yes |
|
Reference key to the financial transaction fact, derived from dbo.[RECURRINGGIFTAMENDMENT].[FINANCIALTRANSACTIONID] |
| AMENDMENTTYPECODE |
smallint |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[AMENDMENTTYPECODE] |
| AMENDMENTTYPE |
nvarchar(50) |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[AMENDMENTTYPE] |
| AMENDMENTDATE |
datetime |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[DATE] |
| AMENDMENTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[DATE] |
| RECURRINGGIFTSTATUSCODE |
smallint |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[STATUSCODE] |
| RECURRINGGIFTSTATUS |
nvarchar(50) |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[STATUS] |
| PREVIOUSRECURRINGGIFTSTATUSCODE |
smallint |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSSTATUSCODE] |
| PREVIOUSRECURRINGGIFTSTATUS |
nvarchar(50) |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSSTATUS] |
| REVENUEDEVELOPMENTFUNCTION |
nvarchar(100) |
yes |
|
dbo.[REVENUEDEVELOPMENTFUNCTIONCODE].[DESCRIPTION] |
| TRANSACTIONAMOUNT |
money |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[TRANSACTIONAMOUNT] |
| PREVIOUSTRANSACTIONAMOUNT |
money |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSTRANSACTIONAMOUNT] |
| TRANSACTIONAMOUNTCHANGE |
money |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[TRANSACTIONAMOUNTCHANGE] |
| TRANSACTIONCURRENCYDIMID |
int |
yes |
|
Reference key to the currency dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[TRANSACTIONCURRENCYID] |
| BASEAMOUNT |
money |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[BASEAMOUNT] |
| PREVIOUSBASEAMOUNT |
money |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSBASEAMOUNT] |
| BASEAMOUNTCHANGE |
money |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[BASEAMOUNTCHANGE] |
| BASECURRENCYDIMID |
int |
yes |
|
Reference key to the currency dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[BASECURRENCYID] |
| ORGANIZATIONAMOUNT |
money |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[ORGANIZATIONAMOUNT] |
| PREVIOUSORGANIZATIONAMOUNT |
money |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSORGANIZATIONAMOUNT] |
| ORGANIZATIONAMOUNTCHANGE |
money |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[ORGANIZATIONAMOUNTCHANGE] |
| FREQUENCYCODE |
smallint |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[FREQUENCYCODE] |
| FREQUENCY |
nvarchar(25) |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[FREQUENCY] |
| PREVIOUSFREQUENCYCODE |
smallint |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSFREQUENCYCODE] |
| PREVIOUSFREQUENCY |
nvarchar(25) |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSFREQUENCY] |
| SOURCECODE |
nvarchar(50) |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[SOURCECODE] |
| FINDERNUMBER |
bigint |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[FINDERNUMBER] |
| APPEALDIMID |
int |
yes |
|
Reference key to the appeal dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[APPEALID] |
| MARKETINGSEGMENTATIONDIMID |
int |
yes |
|
Reference key to the marketing segmentation dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[MAILINGID] |
| REVENUECHANNELDIMID |
int |
yes |
|
Reference key to the revenue channel dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[CHANNELCODEID] |
| PAYMENTMETHODCODE |
smallint |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PAYMENTMETHODCODE] |
| PAYMENTMETHOD |
nvarchar(50) |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PAYMENTMETHOD] |
| PREVIOUSPAYMENTMETHODCODE |
smallint |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSPAYMENTMETHODCODE] |
| PREVIOUSPAYMENTMETHOD |
nvarchar(50) |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSPAYMENTMETHOD] |
| CREDITCARDTYPEDIMID |
int |
yes |
|
Reference key to the credit card type dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[CREDITCARDTYPEID] |
| PREVIOUSCREDITCARDTYPEDIMID |
int |
yes |
|
Reference key to the credit card type dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSCREDITCARDTYPEID] |
| CREDITCARDEXPIRESON |
UDT_FUZZYDATE |
|
|
dbo.[RECURRINGGIFTAMENDMENT].[CREDITCARDEXPIRESON] |
| PREVIOUSCREDITCARDEXPIRESON |
UDT_FUZZYDATE |
|
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSCREDITCARDEXPIRESON] |
| CONSTITUENTACCOUNTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[CONSTITUENTACCOUNTID] |
| PREVIOUSCONSTITUENTACCOUNTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSCONSTITUENTACCOUNTID] |
| REFERENCEDATE |
UDT_FUZZYDATE |
|
|
dbo.[RECURRINGGIFTAMENDMENT].[REFERENCEDATE] |
| PREVIOUSREFERENCEDATE |
UDT_FUZZYDATE |
|
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSREFERENCEDATE] |
| REFERENCENUMBER |
nvarchar(20) |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[REFERENCENUMBER] |
| PREVIOUSREFERENCENUMBER |
nvarchar(20) |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSREFERENCENUMBER] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[CONSTITUENTID] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[CONSTITUENTID] |
| PREVIOUSCONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSCONSTITUENTID] |
| PREVIOUSCONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSCONSTITUENTID] |
| ADDEDDATE |
datetime |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[DATEADDED] |
| ADDEDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[DATEADDED] |
| CHANGEDDATE |
datetime |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[DATECHANGED] |
| CHANGEDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[DATECHANGED] |
| RECURRINGGIFTSTATUSREASONDIMID |
int |
yes |
|
Reference key to the recurring gift status reason dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[RECURRINGGIFTSTATUSREASONCODEID] |
| NEXTTRANSACTIONDATE |
datetime |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[NEXTTRANSACTIONDATE] |
| NEXTTRANSACTIONDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[NEXTTRANSACTIONDATE] |
| PREVIOUSNEXTTRANSACTIONDATE |
datetime |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSNEXTTRANSACTIONDATE] |
| PREVIOUSNEXTTRANSACTIONDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSNEXTTRANSACTIONDATE] |
| STATUSCHANGETYPECODE |
smallint |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[STATUSCHANGETYPECODE] |
| STATUSCHANGETYPE |
nvarchar(50) |
yes |
|
dbo.[RECURRINGGIFTAMENDMENT].[STATUSCHANGETYPE] |
| OTHERPAYMENTMETHODDIMID |
int |
yes |
|
Reference key to the other payment method dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[OTHERPAYMENTMETHODID] |
| PREVIOUSOTHERPAYMENTMETHODDIMID |
int |
yes |
|
Reference key to the other payment method dimension, derived from dbo.[RECURRINGGIFTAMENDMENT].[PREVIOUSOTHERPAYMENTMETHODID] |
| 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. |