DW_YEAR_D

This table contains year-level information about the gregorian calendar.

Details

Module:

Key Columns

CAL_YEAR_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CAL_YEAR_ID NUMBER 38 0 True Year identifier in YYYY format. For example, 1979.
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_CODE VARCHAR2 16 Calendar year period. For example, 1979
CAL_YEAR_START_DATE DATE Start date of the year.
CAL_YEAR_END_DATE DATE End date of the year.
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.
CURRENT_CAL_YEAR_CODE VARCHAR2 16 Indicates that this day belongs to current year. Possible value is Current.
YEAR_END_OR_PRV_CRNT_DATE DATE For current year, day before current date else year end date
TRAILING_YEAR_NUMBER NUMBER 38 0 Indicate trailing year number
YEAR_END_OR_PRV_CRNT_DATE_ALT DATE For current year,if current year start then year end date else day before current date else year end date