FACT_RECURRINGGIFTINSTALLMENTMISSED_STAGE

Contains information about missed recurring gift installments since the last processing.

Fields

Field	Field Type	Null	Notes	Description
REVENUEFACTID	int	yes		[BBDW].[FACT_RECURRINGGIFTINSTALLMENT].[REVENUEFACTID]
REVENUESCHEDULEDIMID	int	yes		[BBDW].[FACT_RECURRINGGIFTINSTALLMENT].[REVENUESCHEDULEDIMID]
REVENUESCHEDULESTARTDATEDIMID	int	yes		[BBDW].[FACT_RECURRINGGIFTINSTALLMENT].[REVENUESCHEDULESTARTDATEDIMID]
REVENUESCHEDULESTARTDATE	datetime	yes		[BBDW].[FACT_RECURRINGGIFTINSTALLMENT].[REVENUESCHEDULESTARTDATE]
REVENUESCHEDULEENDDATEDIMID	int	yes		[BBDW].[FACT_RECURRINGGIFTINSTALLMENT].[REVENUESCHEDULEENDDATEDIMID]
REVENUESCHEDULEENDDATE	datetime	yes		[BBDW].[FACT_RECURRINGGIFTINSTALLMENT].[REVENUESCHEDULEENDDATE]
CLOSEDATE	datetime	yes		[BBDW].[FACT_RECURRINGGIFTINSTALLMENT].[REVENUESCHEDULEENDDATE] if it is not null and less than the current date else the current date
FREQUENCYCODE	int	yes		[BBDW].[DIM_REVENUESCHEDULE].[FREQUENCYCODE]
RECURRINGGIFTINSTALLMENTDATE	datetime	yes		This date is calculated using [FREQUENCYCODE], [CLOSEDATE], and the maximum known installment date for the recurring gift
FINANCIALTRANSACTIONFACTID	int	yes		Reference key to financial transaction fact table, derived from [dbo].[FINANCIALTRANSACTION].[ID]
FINANCIALTRANSACTIONLINEITEMFACTID	int	yes		Reference key to financial transaction line item fact table, derived from [dbo].[FINANCIALTRANSACTIONLINEITEM].[ID]