FACT_INTERACTIONSITE_STAGE

Contains the sites for interactions.

Fields

Field	Field Type	Null	Notes	Description
INTERACTIONSITESYSTEMID	uniqueidentifier	yes		dbo.[INTERACTIONSITE].[ID]
SITEDIMID	int	yes		Reference key to the site dimension, derived from dbo.[INTERACTIONSITE].[SITEID]
INTERACTIONSYSTEMID	uniqueidentifier	yes		dbo.[INTERACTIONSITE].[INTERACTIONID]
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