V_QUERY_BBDW_INTERACTIONRESPONSE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| INTERACTIONRESPONSEFACTID | int | ||
| INTERACTIONRESPONSESYSTEMID | uniqueidentifier | yes | |
| INTERACTIONFACTID | int | yes | |
| INTERACTIONRESPONSEDATEDIMID | int | yes | |
| INTERACTIONRESPONSEDATE | datetime | yes | |
| RESPONSECATEGORY | nvarchar(100) | yes | |
| RESPONSECODE | nvarchar(10) | yes | |
| RESPONSE | nvarchar(100) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_INTERACTIONRESPONSE] as
select
ir.[INTERACTIONRESPONSEFACTID],
ir.[INTERACTIONRESPONSESYSTEMID],
ir.[INTERACTIONFACTID],
ir.[INTERACTIONRESPONSEDATEDIMID],
ir.[INTERACTIONRESPONSEDATE],
r.[RESPONSECATEGORY],
r.[RESPONSECODE],
r.[RESPONSE]
from bbdw.[FACT_INTERACTIONRESPONSE] ir
left join bbdw.[DIM_RESPONSE] r on ir.[RESPONSEDIMID] = r.[RESPONSEDIMID] and ir.[RESPONSEDIMID] <> 0