v_FACT_INTERACTIONSITE
Contains the sites for interactions.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| INTERACTIONSITEFACTID | int | BBDW.[FACT_INTERACTIONSITE].[INTERACTIONSITEFACTID] | |
| INTERACTIONSITESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_INTERACTIONSITE].[INTERACTIONSITESYSTEMID] |
| SITEDIMID | int | yes | BBDW.[FACT_INTERACTIONSITE].[SITEDIMID] |
| INTERACTIONFACTID | int | yes | BBDW.[FACT_INTERACTIONSITE].[INTERACTIONFACTID] |
Definition
Copy
create view [BBDW].[v_FACT_INTERACTIONSITE] as
select
[INTERACTIONSITEFACTID],
[INTERACTIONSITESYSTEMID],
[SITEDIMID],
[INTERACTIONFACTID]
from [BBDW].[FACT_INTERACTIONSITE];