V_QUERY_BBDW_CONSTITUENT_SITE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTDIMID | int | yes | |
| SITESYSTEMID | uniqueidentifier | yes | |
| SITENAME | nvarchar(250) | yes | |
| SITEDESCRIPTION | nvarchar(500) | yes | |
| SHORTNAME | nvarchar(100) | yes | |
| ACRONYM | nvarchar(100) | yes | |
| SITETYPE | nvarchar(100) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_CONSTITUENT_SITE] as
select
cs.[CONSTITUENTDIMID],
s.[SITESYSTEMID],
s.[SITENAME],
s.[SITEDESCRIPTION],
s.[SHORTNAME],
s.[ACRONYM],
s.[SITETYPE]
from bbdw.[FACT_CONSTITUENTSITE] cs
inner join bbdw.[DIM_SITE] s on cs.[SITEDIMID] = s.[SITEDIMID] and s.[SITEDIMID] <> 0