DW_APPS_QUARTER_D

This platform table contains quarter-level information about the gregorian calendar.

Details

Module:

Key Columns

CAL_QUARTER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CAL_QUARTER_ID NUMBER 38 0 True Quarter identifier in YYYYQ format. For example, 19794.
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_YEAR_ID NUMBER 38 0 Year identifier in YYYY format. For example, 1979.
CAL_QUARTER_CODE VARCHAR2 32 Calendar quarter period. For example, 1979 Q4.
CAL_YEAR_CODE VARCHAR2 16 Calendar year period. For example, 1979
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_HALF_NUMBER NUMBER 38 0 Calendar half-year of this quarter. Possible values are 1 and 2.
CAL_QUARTER_NUMBER NUMBER 38 0 Calendar quarter. Possible values are 1, 2, 3, and 4.
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_QUARTER_CAL_YEAR_FLAG VARCHAR2 16 Indicates that this quarter is the first quarter of calendar year.
LAST_QUARTER_CAL_YEAR_FLAG VARCHAR2 16 Indicates that this quarter is the last quarter of calendar year.