FACT_EVENTREGISTRANTBENEFITTOTAL_STAGE

Intermediate storage table for benefits.

Fields

Field	Field Type	Null	Notes	Description
EVENTREGISTRANTTOTALBENEFITSYSTEMID	uniqueidentifier	yes		[dbo].[FAFREGISTRANTBENEFITSUMMARY].[ID]
EVENTSYSTEMID	uniqueidentifier	yes		[dbo].[FAFREGISTRANTBENEFITSUMMARY].[EVENTID]
EVENTDIMID	int	yes		Reference key to the Event dimension derived from dbo.[FAFREGISTRANTBENEFITSUMMARY][EVENTID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[FAFREGISTRANTBENEFITSUMMARY].[CONSTITUENTID]
BENEFITLIST	nvarchar(500)	yes		dbo.[FAFREGISTRANTBENEFITSUMMARY].[BENEFITS]
TOTALVALUE	money	yes		[dbo].[FAFREGISTRANTBENEFITSUMMARY].[TOTALVALUE]
BENEFITTYPE	int	yes		dbo.[FAFREGISTRANTBENEFITSUMMARY].[BENEFITTYPE]
BENEFITTYPEDIMID	int	yes		Reference key to the benefit type dimension derived from dbo.[FAFREGISTRANTBENEFITSUMMARY][BENEFITTYPECODE]
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.