DW_WEEK_D

This table contains week-level information about the gregorian calendar.

Details

Module:

Key Columns

CAL_WEEK_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CAL_WEEK_ID NUMBER 38 0 True Week identifier in YYYYW format. For example, 197949.
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Integration identifier generated by formatting the week in YYYYMMDD format.
CAL_YEAR_ID NUMBER 38 0 Year identifier in YYYY format. For example, 1979.
CAL_WEEK_CODE VARCHAR2 32 Calendar week period Name. For example, 1979 Week53.
CAL_YEAR_CODE VARCHAR2 16 Calendar year period Name. For example, 1979
CAL_WEEK_START_DATE DATE Start date of the week.
CAL_WEEK_END_DATE DATE End date of the week.
CAL_YEAR_START_DATE DATE Start date of the year.
CAL_YEAR_END_DATE DATE End date of the year.
CAL_WEEK_NUMBER NUMBER 38 0 Calendar week identifier. Possible values are 1 through 53.
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_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_WEEK_CAL_YEAR_FLAG VARCHAR2 16 Indicates that this week is the first week of calendar year.
LAST_WEEK_CAL_YEAR_FLAG VARCHAR2 16 Indicates that this week is the last week of calendar year.
CURRENT_CAL_WEEK_CODE VARCHAR2 16 Indicates that this day belongs to current week. Possible value is Current.
CURRENT_CAL_YEAR_CODE VARCHAR2 16 Indicates that this day belongs to current year. Possible value is Current.