FACT_CAMPAIGNSITE

Contains information about sites associated with campaigns.

Primary Key

Primary Key	Field Type
CAMPAIGNSITEFACTID	int

Fields

Field	Field Type	Null	Notes	Description
CAMPAIGNSITESYSTEMID	uniqueidentifier	yes		[dbo].[CAMPAIGNSITE].[ID]
SITEDIMID	int	yes		Reference key to the site dimension, derived using [dbo].[CAMPAIGNSITE].[SITEID]
CAMPAIGNDIMID	int	yes		Reference key to the site dimension, derived using [dbo].[CAMPAIGNSITE].[CAMPAIGNID]
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].[CAMPAIGNSITE].[SITEID]

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_FACT_CAMPAIGNSITE	CAMPAIGNSITEFACTID	yes	yes	yes