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 |