v_DIM_SITE
Contains information about sites
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SITEDIMID | int | BBDW.[DIM_SITE].[SITEDIMID] | |
| SITESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_SITE].[SITESYSTEMID] |
| SITENAME | nvarchar(250) | yes | BBDW.[DIM_SITE].[SITENAME] |
| SITEDESCRIPTION | nvarchar(500) | yes | BBDW.[DIM_SITE].[SITEDESCRIPTION] |
| HIERARCHYPATH | hierarchyid | yes | BBDW.[DIM_SITE].[HIERARCHYPATH] |
| SHORTNAME | nvarchar(100) | yes | BBDW.[DIM_SITE].[SHORTNAME] |
| ACRONYM | nvarchar(100) | yes | BBDW.[DIM_SITE].[ACRONYM] |
| SITEID | nvarchar(100) | yes | BBDW.[DIM_SITE].[SITEID] |
| SITETYPE | nvarchar(100) | yes | BBDW.[DIM_SITE].[SITETYPE] |
| PARENTSITEDIMID | int | yes | BBDW.[DIM_SITE].[PARENTSITEDIMID] |
Definition
Copy
create view [BBDW].[v_DIM_SITE] as
select
[SITEDIMID],
[SITESYSTEMID],
[SITENAME],
[SITEDESCRIPTION],
[HIERARCHYPATH],
[SHORTNAME],
[ACRONYM],
[SITEID],
[SITETYPE],
[PARENTSITEDIMID]
from BBDW.[DIM_SITE]