v_FACT_RECURRINGGIFTAMENDMENT

Stores information about recurring gift amendments.

Fields

Field	Field Type	Null	Description
RECURRINGGIFTAMENDMENTFACTID	int		BBDW.[FACT_RECURRINGGIFTAMENDMENT].[RECURRINGGIFTAMENDMENTFACTID]
RECURRINGGIFTAMENDMENTSYSTEMID	uniqueidentifier	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[RECURRINGGIFTAMENDMENTSYSTEMID]
FINANCIALTRANSACTIONSYSTEMID	uniqueidentifier	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[FINANCIALTRANSACTIONSYSTEMID]
FINANCIALTRANSACTIONFACTID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[FINANCIALTRANSACTIONFACTID]
AMENDMENTTYPECODE	smallint	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[AMENDMENTTYPECODE]
AMENDMENTTYPE	nvarchar(50)	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[AMENDMENTTYPE]
AMENDMENTDATE	datetime	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[AMENDMENTDATE]
AMENDMENTDATEDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[AMENDMENTDATEDIMID]
RECURRINGGIFTSTATUSCODE	smallint	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[RECURRINGGIFTSTATUSCODE]
RECURRINGGIFTSTATUS	nvarchar(50)	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[RECURRINGGIFTSTATUS]
PREVIOUSRECURRINGGIFTSTATUSCODE	smallint	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSRECURRINGGIFTSTATUSCODE]
PREVIOUSRECURRINGGIFTSTATUS	nvarchar(50)	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSRECURRINGGIFTSTATUS]
REVENUEDEVELOPMENTFUNCTION	nvarchar(100)	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[REVENUEDEVELOPMENTFUNCTION]
TRANSACTIONAMOUNT	money	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[TRANSACTIONAMOUNT]
PREVIOUSTRANSACTIONAMOUNT	money	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSTRANSACTIONAMOUNT]
TRANSACTIONAMOUNTCHANGE	money	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[TRANSACTIONAMOUNTCHANGE]
TRANSACTIONCURRENCYDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[TRANSACTIONCURRENCYDIMID]
BASEAMOUNT	money	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[BASEAMOUNT]
PREVIOUSBASEAMOUNT	money	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSBASEAMOUNT]
BASEAMOUNTCHANGE	money	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[BASEAMOUNTCHANGE]
BASECURRENCYDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[BASECURRENCYDIMID]
ORGANIZATIONAMOUNT	money	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[ORGANIZATIONAMOUNT]
PREVIOUSORGANIZATIONAMOUNT	money	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSORGANIZATIONAMOUNT]
ORGANIZATIONAMOUNTCHANGE	money	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[ORGANIZATIONAMOUNTCHANGE]
FREQUENCYCODE	smallint	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[FREQUENCYCODE]
FREQUENCY	nvarchar(25)	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[FREQUENCY]
PREVIOUSFREQUENCYCODE	smallint	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSFREQUENCYCODE]
PREVIOUSFREQUENCY	nvarchar(25)	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSFREQUENCY]
SOURCECODE	nvarchar(50)	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[SOURCECODE]
FINDERNUMBER	bigint	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[FINDERNUMBER]
APPEALDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[APPEALDIMID]
MARKETINGSEGMENTATIONDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[MARKETINGSEGMENTATIONDIMID]
REVENUECHANNELDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[REVENUECHANNELDIMID]
PAYMENTMETHODCODE	smallint	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PAYMENTMETHODCODE]
PAYMENTMETHOD	nvarchar(50)	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PAYMENTMETHOD]
PREVIOUSPAYMENTMETHODCODE	smallint	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSPAYMENTMETHODCODE]
PREVIOUSPAYMENTMETHOD	nvarchar(50)	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSPAYMENTMETHOD]
CREDITCARDTYPEDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[CREDITCARDTYPEDIMID]
PREVIOUSCREDITCARDTYPEDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSCREDITCARDTYPEDIMID]
CREDITCARDEXPIRESON	UDT_FUZZYDATE		BBDW.[FACT_RECURRINGGIFTAMENDMENT].[CREDITCARDEXPIRESON]
PREVIOUSCREDITCARDEXPIRESON	UDT_FUZZYDATE		BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSCREDITCARDEXPIRESON]
CONSTITUENTACCOUNTSYSTEMID	uniqueidentifier	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[CONSTITUENTACCOUNTSYSTEMID]
PREVIOUSCONSTITUENTACCOUNTSYSTEMID	uniqueidentifier	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSCONSTITUENTACCOUNTSYSTEMID]
REFERENCEDATE	UDT_FUZZYDATE		BBDW.[FACT_RECURRINGGIFTAMENDMENT].[REFERENCEDATE]
PREVIOUSREFERENCEDATE	UDT_FUZZYDATE		BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSREFERENCEDATE]
REFERENCENUMBER	nvarchar(20)	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[REFERENCENUMBER]
PREVIOUSREFERENCENUMBER	nvarchar(20)	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSREFERENCENUMBER]
CONSTITUENTSYSTEMID	uniqueidentifier	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[CONSTITUENTSYSTEMID]
CONSTITUENTDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[CONSTITUENTDIMID]
PREVIOUSCONSTITUENTSYSTEMID	uniqueidentifier	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSCONSTITUENTSYSTEMID]
PREVIOUSCONSTITUENTDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSCONSTITUENTDIMID]
ADDEDDATE	datetime	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[ADDEDDATE]
ADDEDDATEDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[ADDEDDATEDIMID]
CHANGEDDATE	datetime	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[CHANGEDDATE]
CHANGEDDATEDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[CHANGEDDATEDIMID]
RECURRINGGIFTSTATUSREASONDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[RECURRINGGIFTSTATUSREASONDIMID]
NEXTTRANSACTIONDATE	datetime	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[NEXTTRANSACTIONDATE]
NEXTTRANSACTIONDATEDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[NEXTTRANSACTIONDATEDIMID]
PREVIOUSNEXTTRANSACTIONDATE	datetime	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSNEXTTRANSACTIONDATE]
PREVIOUSNEXTTRANSACTIONDATEDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSNEXTTRANSACTIONDATEDIMID]
STATUSCHANGETYPECODE	smallint	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[STATUSCHANGETYPECODE]
STATUSCHANGETYPE	nvarchar(50)	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[STATUSCHANGETYPE]
OTHERPAYMENTMETHODDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[OTHERPAYMENTMETHODDIMID]
PREVIOUSOTHERPAYMENTMETHODDIMID	int	yes	BBDW.[FACT_RECURRINGGIFTAMENDMENT].[PREVIOUSOTHERPAYMENTMETHODDIMID]

Definition

Copy


create view [BBDW].[v_FACT_RECURRINGGIFTAMENDMENT] as 
  select 
    [RECURRINGGIFTAMENDMENTFACTID],
    [RECURRINGGIFTAMENDMENTSYSTEMID],
    [FINANCIALTRANSACTIONSYSTEMID],
    [FINANCIALTRANSACTIONFACTID],
    [AMENDMENTTYPECODE],
    [AMENDMENTTYPE],
    [AMENDMENTDATE],
    [AMENDMENTDATEDIMID],
    [RECURRINGGIFTSTATUSCODE],
    [RECURRINGGIFTSTATUS],
    [PREVIOUSRECURRINGGIFTSTATUSCODE],
    [PREVIOUSRECURRINGGIFTSTATUS],
    [REVENUEDEVELOPMENTFUNCTION],
    [TRANSACTIONAMOUNT],
    [PREVIOUSTRANSACTIONAMOUNT],
    [TRANSACTIONAMOUNTCHANGE],
    [TRANSACTIONCURRENCYDIMID],
    [BASEAMOUNT],
    [PREVIOUSBASEAMOUNT],
    [BASEAMOUNTCHANGE],
    [BASECURRENCYDIMID],
    [ORGANIZATIONAMOUNT],
    [PREVIOUSORGANIZATIONAMOUNT],
    [ORGANIZATIONAMOUNTCHANGE],
    [FREQUENCYCODE],
    [FREQUENCY],
    [PREVIOUSFREQUENCYCODE],
    [PREVIOUSFREQUENCY],
    [SOURCECODE],
    [FINDERNUMBER],
    [APPEALDIMID],
    [MARKETINGSEGMENTATIONDIMID],
    [REVENUECHANNELDIMID],
    [PAYMENTMETHODCODE],
    [PAYMENTMETHOD],
    [PREVIOUSPAYMENTMETHODCODE],
    [PREVIOUSPAYMENTMETHOD],
    [CREDITCARDTYPEDIMID],
    [PREVIOUSCREDITCARDTYPEDIMID],
    [CREDITCARDEXPIRESON],
    [PREVIOUSCREDITCARDEXPIRESON],
    [CONSTITUENTACCOUNTSYSTEMID],
    [PREVIOUSCONSTITUENTACCOUNTSYSTEMID],
    [REFERENCEDATE],
    [PREVIOUSREFERENCEDATE],
    [REFERENCENUMBER],
    [PREVIOUSREFERENCENUMBER],
    [CONSTITUENTSYSTEMID],
    [CONSTITUENTDIMID],
    [PREVIOUSCONSTITUENTSYSTEMID],
    [PREVIOUSCONSTITUENTDIMID],
    [ADDEDDATE],
    [ADDEDDATEDIMID],
    [CHANGEDDATE],
    [CHANGEDDATEDIMID],
    [RECURRINGGIFTSTATUSREASONDIMID],
    [NEXTTRANSACTIONDATE],
    [NEXTTRANSACTIONDATEDIMID],
    [PREVIOUSNEXTTRANSACTIONDATE],
    [PREVIOUSNEXTTRANSACTIONDATEDIMID],
    [STATUSCHANGETYPECODE],
    [STATUSCHANGETYPE],
    [OTHERPAYMENTMETHODDIMID],
    [PREVIOUSOTHERPAYMENTMETHODDIMID]
  from [BBDW].[FACT_RECURRINGGIFTAMENDMENT];