V_QUERY_BBDW_DATE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| DATEDIMID | int | ||
| CALENDARYEAR | smallint | yes | |
| CALENDARFULLQUARTERYEARNAME | nvarchar(15) | yes | |
| CALENDARQUARTER | smallint | yes | |
| CALENDARQUARTERNAME | char(2) | yes | |
| CALENDARMONTH | smallint | yes | |
| CALENDARMONTHNAME | nvarchar(12) | yes | |
| CALENDARWEEK | smallint | yes | |
| CALENDARWEEKYEARNAME | nvarchar(15) | yes | |
| CALENDARDAYOFYEAR | smallint | yes | |
| CALENDARMONTHYEARNAME | nvarchar(15) | yes | |
| DAYOFMONTH | smallint | yes | |
| DAYNAME | nvarchar(12) | yes | |
| ACTUALDATE | datetime | yes | |
| DAYSSINCE | int | yes | |
| WEEKSSINCE | int | yes | |
| MONTHSSINCE | int | yes | |
| QUARTERSSINCE | int | yes | |
| YEARSSINCE | int | yes | |
| GLFISCALYEARSSINCE | int | yes | |
| GLFISCALYEAR | nvarchar(12) | yes | |
| GLFISCALYEARSTATUS | nvarchar(10) | yes | |
| GLFISCALPERIOD | int | yes | |
| GLFISCALPERIODCLOSED | bit | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_DATE] as
select
[DATEDIMID],
[CALENDARYEAR],
[CALENDARFULLQUARTERYEARNAME],
[CALENDARQUARTER],
[CALENDARQUARTERNAME],
[CALENDARMONTH],
[CALENDARMONTHNAME],
[CALENDARWEEK],
[CALENDARWEEKYEARNAME],
[CALENDARDAYOFYEAR],
[CALENDARMONTHYEARNAME],
[DAYOFMONTH],
[DAYNAME],
[ACTUALDATE],
[DAYSSINCE],
[WEEKSSINCE],
[MONTHSSINCE],
[QUARTERSSINCE],
[CALENDARYEARSSINCE] [YEARSSINCE],
[GLFISCALYEARSSINCE],
[GLFISCALYEAR],
[GLFISCALYEARSTATUS],
[GLFISCALPERIOD],
[GLFISCALPERIODCLOSED]
from BBDW.[DIM_DATE]
where [ISINCLUDED] = 1