v_QUERY_BBDW_FACT_CONSTITUENTSMARTFIELD
This is used for query views on constituent attributes in the warehouse.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SMARTFIELDID | uniqueidentifier | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDSYSTEMID] |
| ID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTSMARTFIELD].[CONSTITUENTSYSTEMID] |
| VALUE | nvarchar(255) | yes | BBDW.[FACT_CONSTITUENTSMARTFIELD].[SMARTFIELDVALUE] |
| VALUEGROUP | nvarchar(100) | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDVALUEGROUPNAME] |
Definition
Copy
create view BBDW.[v_QUERY_BBDW_FACT_CONSTITUENTSMARTFIELD]
as
select
s.[SMARTFIELDSYSTEMID] [SMARTFIELDID],
cs.[CONSTITUENTSYSTEMID] [ID],
cs.[SMARTFIELDVALUE] [VALUE],
s.[SMARTFIELDVALUEGROUPNAME] [VALUEGROUP]
from bbdw.[FACT_CONSTITUENTSMARTFIELD] cs
inner join bbdw.[DIM_SMARTFIELD] s on cs.[SMARTFIELDDIMID] = s.[SMARTFIELDDIMID]