VIEW: MTH.MTH_445_PERIOD_CALENDAR#

Source

View Text - Preformatted

select DIMENSION_KEY DIMENSION_KEY, DAY_START_DATE DAY_START_DATE, DAY_OF_FISCAL_YEAR DAY_OF_FISCAL_YEAR, JULIAN_DATE JULIAN_DATE, DAY_OF_FISCAL_WEEK DAY_OF_FISCAL_WEEK, DAY_TIME_SPAN DAY_TIME_SPAN, DAY DAY, DAY_ID DAY_ID, DAY_DAY_CODE DAY_DAY_CODE, DAY_DESCRIPTION DAY_DESCRIPTION, DAY_NAME DAY_NAME, DAY_END_DATE DAY_END_DATE, DAY_OF_FISCAL_QUARTER DAY_OF_FISCAL_QUARTER, DAY_OF_FISCAL_MONTH DAY_OF_FISCAL_MONTH, FISCAL_WEEK_START_DATE FISCAL_WEEK_START_DATE, FISCAL_WEEK_FIS_WEEK_CODE FISCAL_WEEK_FIS_WEEK_CODE, FISCAL_WEEK_DESCRIPTION FISCAL_WEEK_DESCRIPTION, WEEK_OF_FISCAL_MONTH WEEK_OF_FISCAL_MONTH, FISCAL_WEEK_TIME_SPAN FISCAL_WEEK_TIME_SPAN, WEEK_OF_FISCAL_YEAR WEEK_OF_FISCAL_YEAR, FIS_WEEK_NUMBER FIS_WEEK_NUMBER, FISCAL_WEEK_END_DATE FISCAL_WEEK_END_DATE, FISCAL_WEEK_ID FISCAL_WEEK_ID, FISCAL_WEEK_NAME FISCAL_WEEK_NAME, WEEK_OF_FISCAL_QUARTER WEEK_OF_FISCAL_QUARTER, FISCAL_MONTH_START_DATE FISCAL_MONTH_START_DATE, FISCAL_MONTH_FIS_MONTH_CODE FISCAL_MONTH_FIS_MONTH_CODE, FISCAL_MONTH_DESCRIPTION FISCAL_MONTH_DESCRIPTION, MONTH_OF_FISCAL_QUARTER MONTH_OF_FISCAL_QUARTER, FISCAL_MONTH_END_DATE FISCAL_MONTH_END_DATE, FISCAL_MONTH_ID FISCAL_MONTH_ID, FISCAL_MONTH_NAME FISCAL_MONTH_NAME, FIS_MONTH_NUMBER FIS_MONTH_NUMBER, FISCAL_MONTH_TIME_SPAN FISCAL_MONTH_TIME_SPAN, MONTH_OF_FISCAL_YEAR MONTH_OF_FISCAL_YEAR, FISCAL_QUARTER_TIME_SPAN FISCAL_QUARTER_TIME_SPAN, QUARTER_OF_FISCAL_YEAR QUARTER_OF_FISCAL_YEAR, FISCAL_QUARTER_FIS_QUARTER_CO FISCAL_QUARTER_FIS_QUARTER_CO, FIS_QUARTER_NUMBER FIS_QUARTER_NUMBER, FISCAL_QUARTER_NAME FISCAL_QUARTER_NAME, FISCAL_QUARTER_END_DATE FISCAL_QUARTER_END_DATE, FISCAL_QUARTER_ID FISCAL_QUARTER_ID, FISCAL_QUARTER_DESCRIPTION FISCAL_QUARTER_DESCRIPTION, FISCAL_QUARTER_START_DATE FISCAL_QUARTER_START_DATE, FISCAL_YEAR_ID FISCAL_YEAR_ID, FISCAL_YEAR_NAME FISCAL_YEAR_NAME, FIS_YEAR_NUMBER FIS_YEAR_NUMBER, FISCAL_YEAR_START_DATE FISCAL_YEAR_START_DATE, FISCAL_YEAR_TIME_SPAN FISCAL_YEAR_TIME_SPAN, FISCAL_YEAR_FIS_YEAR_CODE FISCAL_YEAR_FIS_YEAR_CODE, FISCAL_YEAR_DESCRIPTION FISCAL_YEAR_DESCRIPTION, FISCAL_YEAR_END_DATE FISCAL_YEAR_END_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE from "MTH"."MTH_445_PERIOD_CALENDAR"

View Text - HTML Formatted

SELECT DIMENSION_KEY DIMENSION_KEY
, DAY_START_DATE DAY_START_DATE
, DAY_OF_FISCAL_YEAR DAY_OF_FISCAL_YEAR
, JULIAN_DATE JULIAN_DATE
, DAY_OF_FISCAL_WEEK DAY_OF_FISCAL_WEEK
, DAY_TIME_SPAN DAY_TIME_SPAN
, DAY DAY
, DAY_ID DAY_ID
, DAY_DAY_CODE DAY_DAY_CODE
, DAY_DESCRIPTION DAY_DESCRIPTION
, DAY_NAME DAY_NAME
, DAY_END_DATE DAY_END_DATE
, DAY_OF_FISCAL_QUARTER DAY_OF_FISCAL_QUARTER
, DAY_OF_FISCAL_MONTH DAY_OF_FISCAL_MONTH
, FISCAL_WEEK_START_DATE FISCAL_WEEK_START_DATE
, FISCAL_WEEK_FIS_WEEK_CODE FISCAL_WEEK_FIS_WEEK_CODE
, FISCAL_WEEK_DESCRIPTION FISCAL_WEEK_DESCRIPTION
, WEEK_OF_FISCAL_MONTH WEEK_OF_FISCAL_MONTH
, FISCAL_WEEK_TIME_SPAN FISCAL_WEEK_TIME_SPAN
, WEEK_OF_FISCAL_YEAR WEEK_OF_FISCAL_YEAR
, FIS_WEEK_NUMBER FIS_WEEK_NUMBER
, FISCAL_WEEK_END_DATE FISCAL_WEEK_END_DATE
, FISCAL_WEEK_ID FISCAL_WEEK_ID
, FISCAL_WEEK_NAME FISCAL_WEEK_NAME
, WEEK_OF_FISCAL_QUARTER WEEK_OF_FISCAL_QUARTER
, FISCAL_MONTH_START_DATE FISCAL_MONTH_START_DATE
, FISCAL_MONTH_FIS_MONTH_CODE FISCAL_MONTH_FIS_MONTH_CODE
, FISCAL_MONTH_DESCRIPTION FISCAL_MONTH_DESCRIPTION
, MONTH_OF_FISCAL_QUARTER MONTH_OF_FISCAL_QUARTER
, FISCAL_MONTH_END_DATE FISCAL_MONTH_END_DATE
, FISCAL_MONTH_ID FISCAL_MONTH_ID
, FISCAL_MONTH_NAME FISCAL_MONTH_NAME
, FIS_MONTH_NUMBER FIS_MONTH_NUMBER
, FISCAL_MONTH_TIME_SPAN FISCAL_MONTH_TIME_SPAN
, MONTH_OF_FISCAL_YEAR MONTH_OF_FISCAL_YEAR
, FISCAL_QUARTER_TIME_SPAN FISCAL_QUARTER_TIME_SPAN
, QUARTER_OF_FISCAL_YEAR QUARTER_OF_FISCAL_YEAR
, FISCAL_QUARTER_FIS_QUARTER_CO FISCAL_QUARTER_FIS_QUARTER_CO
, FIS_QUARTER_NUMBER FIS_QUARTER_NUMBER
, FISCAL_QUARTER_NAME FISCAL_QUARTER_NAME
, FISCAL_QUARTER_END_DATE FISCAL_QUARTER_END_DATE
, FISCAL_QUARTER_ID FISCAL_QUARTER_ID
, FISCAL_QUARTER_DESCRIPTION FISCAL_QUARTER_DESCRIPTION
, FISCAL_QUARTER_START_DATE FISCAL_QUARTER_START_DATE
, FISCAL_YEAR_ID FISCAL_YEAR_ID
, FISCAL_YEAR_NAME FISCAL_YEAR_NAME
, FIS_YEAR_NUMBER FIS_YEAR_NUMBER
, FISCAL_YEAR_START_DATE FISCAL_YEAR_START_DATE
, FISCAL_YEAR_TIME_SPAN FISCAL_YEAR_TIME_SPAN
, FISCAL_YEAR_FIS_YEAR_CODE FISCAL_YEAR_FIS_YEAR_CODE
, FISCAL_YEAR_DESCRIPTION FISCAL_YEAR_DESCRIPTION
, FISCAL_YEAR_END_DATE FISCAL_YEAR_END_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "MTH"."MTH_445_PERIOD_CALENDAR"