v_DIM_ATTRIBUTE
Contains information about attribute.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ATTRIBUTEDIMID | int | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTEDIMID] | |
| ATTRIBUTECATEGORYSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTECATEGORYSYSTEMID] |
| ATTRIBUTEVALUESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTEVALUESYSTEMID] |
| ATTRIBUTEGROUP | nvarchar(100) | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTEGROUP] |
| ATTRIBUTETYPE | nvarchar(100) | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTETYPE] |
| ATTRIBUTENAME | nvarchar(100) | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTENAME] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEDATATYPE | nvarchar(20) | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTEDATATYPE] |
| ATTRIBUTEONLYALLOWONEPERRECORD | bit | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTEONLYALLOWONEPERRECORD] |
| ATTRIBUTEVALUEACTIVE | bit | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTEVALUEACTIVE] |
| ATTRIBUTEHASCODETABLE | bit | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTEHASCODETABLE] |
| ATTRIBUTEFORREPORTING | bit | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTEFORREPORTING] |
Definition
Copy
create view [BBDW].[v_DIM_ATTRIBUTE] as
select
[ATTRIBUTEDIMID],
[ATTRIBUTECATEGORYSYSTEMID],
[ATTRIBUTEVALUESYSTEMID],
[ATTRIBUTEGROUP],
[ATTRIBUTETYPE],
[ATTRIBUTENAME],
[ATTRIBUTEVALUE],
[ATTRIBUTEDATATYPE],
[ATTRIBUTEONLYALLOWONEPERRECORD],
[ATTRIBUTEVALUEACTIVE],
[ATTRIBUTEHASCODETABLE],
[ATTRIBUTEFORREPORTING]
from [BBDW].[DIM_ATTRIBUTE];