DW_MONTH_D

This table contains 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   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, 2023, Oracle and/or its affiliates.