# DW_NS_MONTH_D

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

## Details

Module:

## Key Columns

CAL_MONTH_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
CAL_MONTH_ID | NUMBER | 38 | 0 | True | Month identifier in YYYYQMM format. For example, 1979412. |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. Integration identifier generated by formatting the date in YYYYMMDD format. |  |
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, Q4 in 1979 Q4. |  |
CAL_YEAR_CODE | VARCHAR2 | 16 |  |  | Calendar year period. For example, 1979 |  |
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_MONTH_LOCALE_NAME | VARCHAR2 | 32 |  |  | Calendar month name of this day. Possible values are January, February |  |
CAL_HALF_NUMBER | NUMBER | 38 | 0 |  | Calendar half-year of this day. Possible values are 1 and 2. |  |
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_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_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_MONTH_CAL_QTR_FLAG | VARCHAR2 | 16 |  |  | Indicates that this month is the first month of calendar quarter. |  |
LAST_MONTH_CAL_QTR_FLAG | VARCHAR2 | 16 |  |  | Indicates that this month is the last month of calendar quarter. |  |
FIRST_MONTH_CAL_YEAR_FLAG | VARCHAR2 | 16 |  |  | Indicates that this month is the first month of calendar year. |  |
LAST_MONTH_CAL_YEAR_FLAG | VARCHAR2 | 16 |  |  | Indicates that this month is the last month of calendar year. |  |
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 |  |
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 |  |

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