FACT_INTERACTIONSITE

Contains the sites for interactions.

Primary Key

Primary Key Field Type
INTERACTIONSITEFACTID int

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]
INTERACTIONFACTID int yes Reference key to the interaction fact, derived from dbo.[INTERACTIONRESPONSE].[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

Indexes

Index Name Fields Unique Primary Clustered
PK_FACT_INTERACTIONSITE INTERACTIONSITEFACTID yes yes yes