v_DIM_CONSTITUENTSMARTFIELD
The constituent smart field dimension contains information about constituent smart fields
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SMARTFIELDDIMID | int | BBDW.[DIM_SMARTFIELD].[SMARTFIELDDIMID] | |
| 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] |
| SMARTFIELDLASTRUNON | datetime | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDLASTRUNON] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTSMARTFIELD] as
select
[SMARTFIELDDIMID],
[SMARTFIELDVALUEGROUPNAME],
[SMARTFIELDNAME],
[SMARTFIELDDESCRIPTION],
[SMARTFIELDTYPENAME],
[SMARTFIELDTYPEDESCRIPTION],
[SMARTFIELDLASTRUNON]
from BBDW.[DIM_SMARTFIELD]
where ([SMARTFIELDFORREPORTING] = 1) and ([SMARTFIELDRECORDTYPE] = 'Constituent')