DW_APPS_YEAR_D

This platform 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.    

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