FACT_EVENTREGISTRANTBENEFIT_STAGE

Intermediate storage table for benefits.

Fields

Field	Field Type	Null	Notes	Description
EVENTREGISTRANTBENEFITSYSTEMID	uniqueidentifier	yes		dbo.[REGISTRANTBENEFIT].[ID]
EVENTREGISTRANTSYSTEMID	uniqueidentifier	yes		dbo.[REGISTRANTBENEFIT].[REGISTRANTID]
BENEFITSYSTEMID	uniqueidentifier	yes		dbo.[REGISTRANTBENEFIT].[BENEFITID]
BENEFITDIMID	int	yes		Reference key to the benefit dimension, derived from dbo.[REGISTRANTBENEFIT].[BENEFITID]
QUANTITY	int	yes		dbo.[REGISTRANTBENEFIT].[QUANTITY]
TOTALVALUE	money	yes		[dbo].[REGISTRANTBENEFIT].[ORGANIZATIONTOTALVALUE]
BASETOTALVALUE	money	yes		[dbo].[REGISTRANTBENEFIT].[TOTALVALUE]
BASECURRENCYDIMID	int	yes		Reference key to the currency dimension, derived from dbo.[BENEFIT].[BASECURRENCYID]
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.