FACT_EVENTREGISTRANTBENEFITTOTAL

Intermediate storage table for benefits.

Primary Key

Primary Key	Field Type
EVENTREGISTRANTBENEFITTOTALFACTID	int

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]
CONSTITUENTSYTEMID	uniqueidentifier	yes		[dbo].[FAFREGISTRANTBENEFITSUMMARY].[CONSTITUENTID]
CONSTITUENTDIMID	int	yes		Reference key to the constituent dimension table derived from [dbo].[FAFREGISTRANTBENEFITSUMMARY].[CONSTITUENTID]
EVENTREGISTRANTSYSTEMID	uniqueidentifier	yes		dbo.[REGISTRANT].[ID]
EVENTREGISTRANTFACTID	int	yes		Reference key to the constituent dimension table derived from [dbo].[FAFREGISTRANTBENEFITSUMMARY].[CONSTITUENTID]
BENEFITLIST	nvarchar(500)	yes		dbo.[FAFREGISTRANTBENEFITSUMMARY].[BENEFITS]
TOTALVALUE	money	yes		[dbo].[FAFREGISTRANTBENEFITSUMMARY].[TOTALVALUE]
BENEFITTYPEDIMID	int	yes		Reference key to the benefit type dimension derived from [dbo].[FAFREGISTRANTBENEFITSUMMARY].[BENEFITTYPE]
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.
BENEFITTYPE	int	yes		[dbo].[FAFREGISTRANTBENEFITSUMMARY].[BENEFITTYPE]

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_FACT_EVENTREGISTRANTBENEFITTOTAL	EVENTREGISTRANTBENEFITTOTALFACTID	yes	yes	yes