This platform table contains quarter-level information about the gregorian calendar.
Module:
CAL_QUARTER_ID
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 | 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. |
Copyright © 2019, 2022, Oracle and/or its affiliates.