DW_APPS_DAY_D

This platform 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 Date in YYYYMMDD format.    
SOURCE_RECORD_ID NUMBER 38 0   Integration identifier generated by formatting the date in YYYYMMDD format.    
CALENDAR_DATE DATE       Calendar date.    
DAY_OF_WEEK NUMBER 38 0   Day of the week. Possible values are 1 through 7.    
DAY_OF_MONTH NUMBER 38 0   Day of the month. Possible values are 1 through 31.    
DAY_OF_YEAR NUMBER 38 0   Day of the year. Possible values are 1 through 366.    
DAY_AGO_DATE DATE       Previous day's date.    
DAY_AGO_ID NUMBER 38 0   Previous date in YYYYMMDD format.    
DAY_CODE VARCHAR2 16     Name of the day. Possible values are SUN, MON, and so on.    
DAY_LOCALE_NAME VARCHAR2 32     Full Name of the day. Possible values are Sunday, Monday..etc    
JULIAN_DAY_NUMBER NUMBER 38 0   Date in Julian format.    
CAL_WEEK_ID NUMBER 38 0   Week identifier in YYYYW format. For example, 197949.    
CAL_MONTH_ID NUMBER 38 0   Month identifier in YYYYQMM format. For example, 1979412.    
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, 1979 Q4.    
CAL_WEEK_CODE VARCHAR2 32     Calendar week period. For example, 1979 Week53.    
CAL_YEAR_CODE VARCHAR2 16     Calendar Year period. For example, 1979    
CAL_WEEK_START_DATE DATE       Start date of the week.    
CAL_WEEK_END_DATE DATE       End date of the week.    
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_HALF_NUMBER NUMBER 38 0   Calendar half-year of this day. Possible values are 1 and 2.    
CAL_MONTH_LOCALE_NAME VARCHAR2 32     Calendar month name of this day. Possible values are January, February    
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_WEEK_NUMBER NUMBER 38 0   Calendar week identifier. Possible values are 1 through 53.    
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_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_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_DAY_CAL_WEEK_FLAG VARCHAR2 16     Indicates that this day is the first day of the calendar week.    
LAST_DAY_CAL_WEEK_FLAG VARCHAR2 16     Indicates that this day is the last day of the calendar week.    
FIRST_DAY_CAL_MONTH_FLAG VARCHAR2 16     Indicates that this day is the first day of the calendar month.    
LAST_DAY_CAL_MONTH_FLAG VARCHAR2 16     Indicates that this day is the last day of the calendar month.    
FIRST_DAY_CAL_QTR_FLAG VARCHAR2 16     Indicates that this day is the first day of the calendar quarter.    
LAST_DAY_CAL_QTR_FLAG VARCHAR2 16     Indicates that this day is the last day of the calendar quarter.    
FIRST_DAY_CAL_YEAR_FLAG VARCHAR2 16     Indicates that this day is the first day of the calendar year.    
LAST_DAY_CAL_YEAR_FLAG VARCHAR2 16     Indicates that this day is the last day of the calendar year.    

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