v_DIM_CONSTITUENCY
The constituency dimension contains information about constituencies.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENCYDIMID | int | BBDW.[DIM_CONSTITUENCY].[CONSTITUENCYDIMID] | |
| CONSTITUENCYCODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENCY].[CONSTITUENCYCODESYSTEMID] |
| CONSTITUENCY | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENCY].[CONSTITUENCY] |
| CONSTITUENCYISACTIVE | bit | yes | BBDW.[DIM_CONSTITUENCY].[CONSTITUENCYISACTIVE] |
| CONSTITUENCYISSYSTEM | bit | yes | BBDW.[DIM_CONSTITUENCY].[CONSTITUENCYISSYSTEM] |
| DISPLAYORDER | int | yes | BBDW.[DIM_CONSTITUENCY].[DISPLAYORDER] |
Definition
Copy
CREATE view [BBDW].[v_DIM_CONSTITUENCY] as
select
[CONSTITUENCYDIMID],
[CONSTITUENCYCODESYSTEMID],
[CONSTITUENCY],
[CONSTITUENCYISACTIVE],
[CONSTITUENCYISSYSTEM],
[DISPLAYORDER]
from BBDW.[DIM_CONSTITUENCY]