DW_DAY_D

This table stores day-level information about the gregorian calendar.

Details

Module:

Key Columns

CAL_DAY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CAL_DAY_ID NUMBER 38 0 True Date in YYYYMMDD format.
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Integration identifier generated by formatting the date in YYYYMMDD format.
CALENDAR_DATE DATE Calendar date.
DAY_OF_WEEK NUMBER 38 0 Day of the week. Possible values are 1 through 7.
DAY_OF_MONTH NUMBER 38 0 Day of the month. Possible values are 1 through 31.
DAY_OF_YEAR NUMBER 38 0 Day of the year. Possible values are 1 through 366.
DAY_AGO_DATE DATE Previous day's date.
DAY_AGO_ID NUMBER 38 0 Previous date in YYYYMMDD format.
DAY_CODE VARCHAR2 16 Name of the day. Possible values are SUN, MON, and so on.
DAY_LOCALE_NAME VARCHAR2 32 Full Name of the day. Possible values are Sunday, Monday..etc
JULIAN_DAY_NUMBER NUMBER 38 0 Date in Julian format.
CAL_WEEK_ID NUMBER 38 0 Week identifier in YYYYW format. For example, 197949.
CAL_MONTH_ID NUMBER 38 0 Month identifier in YYYYQMM format. For example, 1979412.
CAL_QUARTER_ID NUMBER 38 0 Quarter identifier in YYYYQ format. For example, 19794.
CAL_YEAR_ID NUMBER 38 0 Year identifier in YYYY format. For example, 1979.
CAL_MONTH_CODE VARCHAR2 32 Calendar month period. For example, 1979/12.
CAL_QUARTER_CODE VARCHAR2 32 Calendar quarter period. For example, 1979 Q4.
CAL_WEEK_CODE VARCHAR2 32 Calendar week period. For example, 1979 Week53.
CAL_YEAR_CODE VARCHAR2 16 Calendar Year period. For example, 1979
CAL_WEEK_START_DATE DATE Start date of the week.
CAL_WEEK_END_DATE DATE End date of the week.
CAL_MONTH_START_DATE DATE Start date of the month.
CAL_MONTH_END_DATE DATE End date of the month.
CAL_QUARTER_START_DATE DATE Start date of the quarter.
CAL_QUARTER_END_DATE DATE End date of the quarter.
CAL_YEAR_START_DATE DATE Start date of the year.
CAL_YEAR_END_DATE DATE End date of the year.
CAL_MONTH_NUMBER NUMBER 38 0 Calendar month of this day. Possible values are 1 through 12.
CAL_HALF_NUMBER NUMBER 38 0 Calendar half-year of this day. Possible values are 1 and 2.
CAL_MONTH_LOCALE_NAME VARCHAR2 32 Calendar month name of this day. Possible values are January, February
CAL_QUARTER_NUMBER NUMBER 38 0 Calendar quarter of this day. Possible values are 1, 2, 3, and 4.
CAL_TRIMESTER_NUMBER NUMBER 38 0 Calendar trimester of this day. Possible values are 1, 2 and 3.
CAL_WEEK_NUMBER NUMBER 38 0 Calendar week identifier. Possible values are 1 through 53.
CAL_MONTH_END_DATE_ID NUMBER 38 0 Last day of month in YYYYMMDD format.
CAL_MONTH_START_DATE_ID NUMBER 38 0 First day of month in YYYYMMDD format.
CAL_WEEK_END_DATE_ID NUMBER 38 0 Last day of week in YYYYMMDD format.
CAL_WEEK_START_DATE_ID NUMBER 38 0 First day of week in YYYYMMDD format.
CAL_QUARTER_START_DATE_ID NUMBER 38 0 First day of quarter in YYYYMMDD format.
CAL_QUARTER_END_DATE_ID NUMBER 38 0 Last day of quarter in YYYYMMDD format.
CAL_YEAR_END_DATE_ID NUMBER 38 0 Last day of year in YYYYMMDD format.
CAL_YEAR_START_DATE_ID NUMBER 38 0 First day of year in YYYYMMDD format.
FIRST_DAY_CAL_WEEK_FLAG VARCHAR2 16 Indicates that this day is the first day of the calendar week.
LAST_DAY_CAL_WEEK_FLAG VARCHAR2 16 Indicates that this day is the last day of the calendar week.
FIRST_DAY_CAL_MONTH_FLAG VARCHAR2 16 Indicates that this day is the first day of the calendar month.
LAST_DAY_CAL_MONTH_FLAG VARCHAR2 16 Indicates that this day is the last day of the calendar month.
FIRST_DAY_CAL_QTR_FLAG VARCHAR2 16 Indicates that this day is the first day of the calendar quarter.
LAST_DAY_CAL_QTR_FLAG VARCHAR2 16 Indicates that this day is the last day of the calendar quarter.
FIRST_DAY_CAL_YEAR_FLAG VARCHAR2 16 Indicates that this day is the first day of the calendar year.
LAST_DAY_CAL_YEAR_FLAG VARCHAR2 16 Indicates that this day is the last day of the calendar year.
CURRENT_CAL_DAY_CODE VARCHAR2 16 Indicates current day. Possible value is Current.
CURRENT_CAL_WEEK_CODE VARCHAR2 16 Indicates that this day belongs to current week. Possible value is Current.
CURRENT_CAL_MONTH_CODE VARCHAR2 16 Indicates that this day belongs to current month. Possible value is Current.
CURRENT_CAL_QTR_CODE VARCHAR2 16 Indicates that this day belongs to current quarter. Possible value is Current.
CURRENT_CAL_YEAR_CODE VARCHAR2 16 Indicates that this day belongs to current year. Possible value is Current.
MONTH_END_OR_PRV_CRNT_DATE DATE For current month, day before current date else Month end date
QUARTER_END_OR_PRV_CRNT_DATE DATE For current quarter, day before current date else quarter end date
YEAR_END_OR_PRV_CRNT_DATE DATE For current year, day before current date else year end date
TRAILING_MONTH_NUMBER NUMBER 38 0 Indicate trailing month number
TRAILING_QUARTER_NUMBER NUMBER 38 0 Indicate trailing quarter number
TRAILING_YEAR_NUMBER NUMBER 38 0 Indicate trailing year number
MONTH_END_OR_PRV_CRNT_DATE_ALT DATE For current month, if current month start then month end date else day before current date else Month end date
QUARTER_END_OR_PRV_CRNT_DATE_ALT DATE For current quarter, if current quarter start then quarter end date else day before current date else quarter end date
YEAR_END_OR_PRV_CRNT_DATE_ALT DATE For current year,if current year start then year end date else day before current date else year end date