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   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.