v_DIM_INTERACTION
The interaction dimension contains information about interactions.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| INTERACTIONDIMID | int | BBDW.[DIM_INTERACTION].[INTERACTIONDIMID] | |
| INTERACTIONSUBCATEGORYSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_INTERACTION].[INTERACTIONSUBCATEGORYSYSTEMID] |
| INTERACTIONSUBCATEGORY | nvarchar(100) | yes | BBDW.[DIM_INTERACTION].[INTERACTIONSUBCATEGORY] |
| INTERACTIONCATEGORY | nvarchar(100) | yes | BBDW.[DIM_INTERACTION].[INTERACTIONCATEGORY] |
| INTERACTIONTYPECODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_INTERACTION].[INTERACTIONTYPECODESYSTEMID] |
| INTERACTIONTYPE | nvarchar(100) | yes | BBDW.[DIM_INTERACTION].[INTERACTIONTYPE] |
| INTERACTIONSTATUSCODE | tinyint | yes | BBDW.[DIM_INTERACTION].[INTERACTIONSTATUSCODE] |
| INTERACTIONSTATUS | nvarchar(50) | yes | BBDW.[DIM_INTERACTION].[INTERACTIONSTATUS] |
| ISALLDAYEVENT | bit | yes | BBDW.[DIM_INTERACTION].[ISALLDAYEVENT] |
| ISCONTACTREPORT | bit | yes | BBDW.[DIM_INTERACTION].[ISCONTACTREPORT] |
| ISINTERACTION | bit | yes | BBDW.[DIM_INTERACTION].[ISINTERACTION] |
| ISINTERACTIONCOMPLETED | bit | yes | BBDW.[DIM_INTERACTION].[ISINTERACTIONCOMPLETED] |
Definition
Copy
create view [BBDW].[v_DIM_INTERACTION] as
select
[INTERACTIONDIMID],
[INTERACTIONSUBCATEGORYSYSTEMID],
[INTERACTIONSUBCATEGORY],
[INTERACTIONCATEGORY],
[INTERACTIONTYPECODESYSTEMID],
[INTERACTIONTYPE],
[INTERACTIONSTATUSCODE],
[INTERACTIONSTATUS],
[ISALLDAYEVENT],
[ISCONTACTREPORT],
[ISINTERACTION],
[ISINTERACTIONCOMPLETED]
from BBDW.[DIM_INTERACTION]