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

Copyright © 2019, 2026, Oracle and/or its affiliates.