FACT_RECURRINGGIFTINSTALLMENT_STAGE

Intermediate storage table for recurring gift installments.

Fields

Field	Field Type	Null	Notes	Description
RECURRINGGIFTINSTALLMENTSYSTEMID	uniqueidentifier	yes		[dbo].[RECURRINGGIFTINSTALLMENT].[ID]
REVENUEAPPLICATIONSYSTEMID	uniqueidentifier	yes		dbo.[FINANCIALTRANSACTIONLINEITEM].[ID]
RECURRINGGIFTINSTALLMENTSEQUENCE	int	yes		A sequence for the installments for the corresponding dbo.[RECURRINGGIFTINSTALLMENT].[ID]
REVENUESCHEDULEDIMID	int	yes		Reference key to the revenue schedule dimension, derived using the combination flags and codes on [dbo].[REVENUESCHEDULE]
REVENUESCHEDULESYSTEMID	uniqueidentifier	yes		dbo.[RECURRINGGIFTINSTALLMENT].[ID]
REVENUESCHEDULEDATECHANGED	datetime	yes		dbo.[RECURRINGGIFTINSTALLMENT].[DATECHANGED]
REVENUESCHEDULESTARTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[REVENUESCHEDULE].[STARTDATE]
REVENUESCHEDULESTARTDATE	datetime	yes		dbo.[REVENUESCHEDULE].[STARTDATE]
REVENUESCHEDULEENDDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[REVENUESCHEDULE].[ENDDATE]
REVENUESCHEDULEENDDATE	datetime	yes		dbo.[REVENUESCHEDULE].[ENDDATE]
RECURRINGGIFTINSTALLMENTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[RECURRINGGIFTINSTALLMENT].[DATE]
RECURRINGGIFTINSTALLMENTDATE	datetime	yes		dbo.[RECURRINGGIFTINSTALLMENT].[DATE]
RECURRINGGIFTINSTALLMENTAMOUNT	money	yes		dbo.[RECURRINGGIFTINSTALLMENT].[AMOUNT]
ISFIRSTINSTALLMENT	bit	yes		Flag indicating this is the first installment for a recurring gift
ISLASTINSTALLMENT	bit	yes		Flag indicating this is the last installment for a recurring gift
ISMISSEDINSTALLMENT	bit	yes		Flag indicating this is a missing installment for a recurring gift
ISFUTUREINSTALLMENT	bit	yes		Flag indicating this is a future installment for a recurring gift
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.[RECURRINGGIFTINSTALLMENT].[BASECURRENCYID]
BASERECURRINGGIFTINSTALLMENTAMOUNT	money	yes		dbo.[RECURRINGGIFTINSTALLMENT].[AMOUNT]
PASTDUEDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[RECURRINGGIFTINSTALLMENT].[PASTDUEDATE]
PASTDUEDATE	datetime	yes		dbo.[RECURRINGGIFTINSTALLMENT].[PASTDUEDATE]
RECURRINGGIFTINSTALLMENTSTATUSCODE	smallint	yes		dbo.[RECURRINGGIFTINSTALLMENT].[STATUSCODE]
RECURRINGGIFTINSTALLMENTSTATUS	nvarchar(25)	yes		dbo.[RECURRINGGIFTINSTALLMENT].[STATUS]