v_DIM_SMARTFIELD
Contains information about smart fields.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SMARTFIELDDIMID | int | BBDW.[DIM_SMARTFIELD].[SMARTFIELDDIMID] | |
| SMARTFIELDVALUEGROUPSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDVALUEGROUPSYSTEMID] |
| SMARTFIELDSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDSYSTEMID] |
| SMARTFIELDCATALOGSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDCATALOGSYSTEMID] |
| SMARTFIELDVALUEGROUPNAME | nvarchar(100) | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDVALUEGROUPNAME] |
| SMARTFIELDNAME | nvarchar(100) | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDNAME] |
| SMARTFIELDDESCRIPTION | nvarchar(4000) | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDDESCRIPTION] |
| SMARTFIELDTYPENAME | nvarchar(100) | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDTYPENAME] |
| SMARTFIELDTYPEDESCRIPTION | nvarchar(4000) | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDTYPEDESCRIPTION] |
| SMARTFIELDDATATYPE | nvarchar(20) | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDDATATYPE] |
| SMARTFIELDRECORDTYPE | nvarchar(50) | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDRECORDTYPE] |
| SMARTFIELDLASTRUNON | datetime | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDLASTRUNON] |
| SMARTFIELDFORREPORTING | bit | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDFORREPORTING] |
| SMARTFIELDHASVALUEGROUP | bit | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDHASVALUEGROUP] |
Definition
Copy
create view [BBDW].[v_DIM_SMARTFIELD] as
select
[SMARTFIELDDIMID],
[SMARTFIELDVALUEGROUPSYSTEMID],
[SMARTFIELDSYSTEMID],
[SMARTFIELDCATALOGSYSTEMID],
[SMARTFIELDVALUEGROUPNAME],
[SMARTFIELDNAME],
[SMARTFIELDDESCRIPTION],
[SMARTFIELDTYPENAME],
[SMARTFIELDTYPEDESCRIPTION],
[SMARTFIELDDATATYPE],
[SMARTFIELDRECORDTYPE],
[SMARTFIELDLASTRUNON],
[SMARTFIELDFORREPORTING],
[SMARTFIELDHASVALUEGROUP]
from [BBDW].[DIM_SMARTFIELD];