FACT_INSTALLMENT_STAGE

Intermediate storage table for FACT_INSTALLMENT.

Fields

Field	Field Type	Null	Notes	Description
INSTALLMENTSPLITSYSTEMID	uniqueidentifier	yes		[dbo].[INSTALLMENTSPLIT].[ID]
INSTALLMENTSYSTEMID	uniqueidentifier	yes		[dbo].[INSTALLMENT].[ID]
REVENUEAPPLICATIONSYSTEMID	uniqueidentifier	yes		[dbo].[REVENUESPLIT].[ID] derived using [dbo].[INSTALLMENTSPLIT].[PLEDGEID] and [dbo].[INSTALLMENTSPLIT].[DESIGNATIONID]
REVENUESCHEDULEDIMID	int	yes		Reference key to the revenue schedule dimension, derived using the combination flags and codes on [dbo].[REVENUESCHEDULE]
REVENUESCHEDULESTARTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[INSTALLMENT].[DATE]
REVENUESCHEDULESTARTDATE	datetime	yes		dbo.[INSTALLMENT].[DATE]
REVENUESCHEDULEENDDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[INSTALLMENT].[DATE]
REVENUESCHEDULEENDDATE	datetime	yes		dbo.[INSTALLMENT].[DATE]
INSTALLMENTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[INSTALLMENT].[DATE]
INSTALLMENTDATE	datetime	yes		dbo.[INSTALLMENT].[DATE]
INSTALLMENTAMOUNT	money	yes		dbo.[INSTALLMENTSPLIT].[AMOUNT]
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.[INSTALLMENTSPLIT].[BASECURRENCYID]
BASEINSTALLMENTAMOUNT	money	yes		dbo.[INSTALLMENTSPLIT].[AMOUNT]
SOURCEREVENUESEQUENCEID	int	yes		A reference key to revenue sequenceID,derived from dbo.[REVENUEMATCHINGGIFT].[MGSOURCEREVENUEID]