# DW_NS_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 |  |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. |  |
CALENDAR_DATE | DATE |  |  |  |  |  |
DAY_OF_WEEK | NUMBER | 38 | 0 |  |  |  |
DAY_OF_MONTH | NUMBER | 38 | 0 |  |  |  |
DAY_OF_YEAR | NUMBER | 38 | 0 |  |  |  |
DAY_AGO_DATE | DATE |  |  |  |  |  |
DAY_AGO_ID | NUMBER | 38 | 0 |  |  |  |
DAY_CODE | VARCHAR2 | 16 |  |  |  |  |
DAY_LOCALE_NAME | VARCHAR2 | 32 |  |  |  |  |
JULIAN_DAY_NUMBER | NUMBER | 38 | 0 |  |  |  |
CAL_WEEK_ID | NUMBER | 38 | 0 |  |  |  |
CAL_MONTH_ID | NUMBER | 38 | 0 |  |  |  |
CAL_QUARTER_ID | NUMBER | 38 | 0 |  |  |  |
CAL_YEAR_ID | NUMBER | 38 | 0 |  |  |  |
CAL_MONTH_CODE | VARCHAR2 | 32 |  |  |  |  |
CAL_QUARTER_CODE | VARCHAR2 | 32 |  |  |  |  |
CAL_WEEK_CODE | VARCHAR2 | 32 |  |  |  |  |
CAL_YEAR_CODE | VARCHAR2 | 16 |  |  |  |  |
CAL_WEEK_START_DATE | DATE |  |  |  |  |  |
CAL_WEEK_END_DATE | DATE |  |  |  |  |  |
CAL_MONTH_START_DATE | DATE |  |  |  |  |  |
CAL_MONTH_END_DATE | DATE |  |  |  |  |  |
CAL_QUARTER_START_DATE | DATE |  |  |  |  |  |
CAL_QUARTER_END_DATE | DATE |  |  |  |  |  |
CAL_YEAR_START_DATE | DATE |  |  |  |  |  |
CAL_YEAR_END_DATE | DATE |  |  |  |  |  |
CAL_MONTH_NUMBER | NUMBER | 38 | 0 |  |  |  |
CAL_HALF_NUMBER | NUMBER | 38 | 0 |  |  |  |
CAL_MONTH_LOCALE_NAME | VARCHAR2 | 32 |  |  |  |  |
CAL_QUARTER_NUMBER | NUMBER | 38 | 0 |  |  |  |
CAL_TRIMESTER_NUMBER | NUMBER | 38 | 0 |  |  |  |
CAL_WEEK_NUMBER | NUMBER | 38 | 0 |  |  |  |
CAL_MONTH_END_DATE_ID | NUMBER | 38 | 0 |  |  |  |
CAL_MONTH_START_DATE_ID | NUMBER | 38 | 0 |  |  |  |
CAL_WEEK_END_DATE_ID | NUMBER | 38 | 0 |  |  |  |
CAL_WEEK_START_DATE_ID | NUMBER | 38 | 0 |  |  |  |
CAL_QUARTER_START_DATE_ID | NUMBER | 38 | 0 |  |  |  |
CAL_QUARTER_END_DATE_ID | NUMBER | 38 | 0 |  |  |  |
CAL_YEAR_END_DATE_ID | NUMBER | 38 | 0 |  |  |  |
CAL_YEAR_START_DATE_ID | NUMBER | 38 | 0 |  |  |  |
FIRST_DAY_CAL_WEEK_FLAG | VARCHAR2 | 16 |  |  |  |  |
LAST_DAY_CAL_WEEK_FLAG | VARCHAR2 | 16 |  |  |  |  |
FIRST_DAY_CAL_MONTH_FLAG | VARCHAR2 | 16 |  |  |  |  |
LAST_DAY_CAL_MONTH_FLAG | VARCHAR2 | 16 |  |  |  |  |
FIRST_DAY_CAL_QTR_FLAG | VARCHAR2 | 16 |  |  |  |  |
LAST_DAY_CAL_QTR_FLAG | VARCHAR2 | 16 |  |  |  |  |
FIRST_DAY_CAL_YEAR_FLAG | VARCHAR2 | 16 |  |  |  |  |
LAST_DAY_CAL_YEAR_FLAG | VARCHAR2 | 16 |  |  |  |  |
CURRENT_CAL_DAY_CODE | VARCHAR2 | 16 |  |  |  |  |
CURRENT_CAL_WEEK_CODE | VARCHAR2 | 16 |  |  |  |  |
CURRENT_CAL_MONTH_CODE | VARCHAR2 | 16 |  |  |  |  |
CURRENT_CAL_QTR_CODE | VARCHAR2 | 16 |  |  |  |  |
CURRENT_CAL_YEAR_CODE | VARCHAR2 | 16 |  |  |  |  |
MONTH_END_OR_PRV_CRNT_DATE | DATE |  |  |  |  |  |
QUARTER_END_OR_PRV_CRNT_DATE | DATE |  |  |  |  |  |
YEAR_END_OR_PRV_CRNT_DATE | DATE |  |  |  |  |  |
TRAILING_MONTH_NUMBER | NUMBER | 38 | 0 |  |  |  |
TRAILING_QUARTER_NUMBER | NUMBER | 38 | 0 |  |  |  |
TRAILING_YEAR_NUMBER | NUMBER | 38 | 0 |  |  |  |
MONTH_END_OR_PRV_CRNT_DATE_ALT | DATE |  |  |  |  |  |
QUARTER_END_OR_PRV_CRNT_DATE_ALT | DATE |  |  |  |  |  |
YEAR_END_OR_PRV_CRNT_DATE_ALT | DATE |  |  |  |  |  |

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