v_DIM_RESPONSE
The response dimension contains information about constituent responses.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RESPONSEDIMID | int | BBDW.[DIM_RESPONSE].[RESPONSEDIMID] | |
| RESPONSESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_RESPONSE].[RESPONSESYSTEMID] |
| RESPONSECODE | nvarchar(10) | yes | BBDW.[DIM_RESPONSE].[RESPONSECODE] |
| RESPONSE | nvarchar(100) | yes | BBDW.[DIM_RESPONSE].[RESPONSE] |
| RESPONSECATEGORY | nvarchar(100) | yes | BBDW.[DIM_RESPONSE].[RESPONSECATEGORY] |
Definition
Copy
create view [BBDW].[v_DIM_RESPONSE] as
select
[RESPONSEDIMID],
[RESPONSESYSTEMID],
[RESPONSECODE],
[RESPONSE],
[RESPONSECATEGORY]
from BBDW.[DIM_RESPONSE]