FACT_RECURRINGGIFTAMENDMENT_STAGE

Staging table for the recurring gift amendment fact.

Fields

Field Field Type Null Notes Description
RECURRINGGIFTAMENDMENTSYSTEMID uniqueidentifier yes dbo.[RECURRINGGIFTAMENDMENT].[ID]
FINANCIALTRANSACTIONSYSTEMID uniqueidentifier yes 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]
PREVIOUSCONSTITUENTSYSTEMID uniqueidentifier yes 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]
DESIGNATIONS xml yes dbo.[RECURRINGGIFTAMENDMENT].[DESIGNATIONS]
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.