FACT_EVENTSITE

Contains information about sites associated with events.

Primary Key

Primary Key	Field Type
EVENTSITEFACTID	int

Fields

Field	Field Type	Null	Notes	Description
EVENTSITESYSTEMID	uniqueidentifier	yes		[dbo].[EVENTSITE].[ID]
SITEDIMID	int	yes		Reference key to the site dimension, derived using [dbo].[EVENTSITE].[SITEID]
EVENTDIMID	int	yes		Reference key to the site dimension, derived using [dbo].[EVENTSITE].[EVENTID]
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.
SITESYSTEMID	uniqueidentifier	yes		[dbo].[EVENTSITE].[SITEID]

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_FACT_EVENTSITE	EVENTSITEFACTID	yes	yes	yes