v_DIM_TIMEZONE
Stores information about time zones
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| TIMEZONEDIMID | int | BBDW.[DIM_TIMEZONE].[TIMEZONEDIMID] | |
| TIMEZONESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_TIMEZONE].[TIMEZONESYSTEMID] |
| TIMEZONENAME | nvarchar(200) | yes | BBDW.[DIM_TIMEZONE].[TIMEZONENAME] |
| TIMEZONEDISPLAYNAME | nvarchar(200) | yes | BBDW.[DIM_TIMEZONE].[TIMEZONEDISPLAYNAME] |
| TIMEZONEISACTIVE | bit | yes | BBDW.[DIM_TIMEZONE].[TIMEZONEISACTIVE] |
| TIMEZONESEQUENCE | int | yes | BBDW.[DIM_TIMEZONE].[TIMEZONESEQUENCE] |
| BASETIMEZONEOFFSET | smallint | yes | BBDW.[DIM_TIMEZONE].[BASETIMEZONEOFFSET] |
Definition
Copy
create view [BBDW].[v_DIM_TIMEZONE] as
select
[TIMEZONEDIMID],
[TIMEZONESYSTEMID],
[TIMEZONENAME],
[TIMEZONEDISPLAYNAME],
[TIMEZONEISACTIVE],
[TIMEZONESEQUENCE],
[BASETIMEZONEOFFSET]
from [BBDW].[DIM_TIMEZONE];