FACT_CAMPAIGNSITE_STAGE

Intermediate storage table for campaign sites.

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]
CAMPAIGNSYSTEMID	uniqueidentifier	yes		[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]