DW_FISCAL_QUARTER_D

This table contains quarter-level information of fiscal calendars.

Details

Module:

Key Columns

FISCAL_PERIOD_SET_NAME, FISCAL_QUARTER_NUMBER, FISCAL_PERIOD_TYPE, FISCAL_YEAR_NUMBER

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FISCAL_PERIOD_SET_NAME VARCHAR2 16   True Accounting calendar name.    
FISCAL_PERIOD_TYPE VARCHAR2 16   True Accounting period type.    
FISCAL_YEAR_NUMBER NUMBER 38 0 True Fiscal Year in YYYY format.    
FISCAL_QUARTER_NUMBER NUMBER 38 0 True Fiscal quarter. Possible values are 1, 2, 3, and 4.    
SOURCE_RECORD_ID VARCHAR2 64     Source record identifier. Value is derived from a combination of accounting calendar name, accounting period type, fiscal year in YYYY format, and fiscal quarter.    
FISCAL_HALF_NUMBER NUMBER 38 0   Fiscal half. Possible values are 1 and 2.    
FISCAL_QUARTER_CODE VARCHAR2 16     Fiscal quarter period. For example, 1999Q2.    
FISCAL_QUARTER_START_DATE DATE       Start date of the fiscal quarter.    
FISCAL_QUARTER_START_DATE_ID NUMBER 38 0   First day of fiscal quarter in YYYYMMDD format.    
FISCAL_QUARTER_END_DATE DATE       End date of the fiscal quarter.    
FISCAL_QUARTER_END_DATE_ID NUMBER 38 0   Last day of fiscal quarter in YYYYMMDD format.    
FISCAL_YEAR_START_DATE DATE       Start date of the fiscal year.    
FISCAL_YEAR_START_DATE_ID NUMBER 38 0   First day of fiscal year in YYYYMMDD format.    
FISCAL_YEAR_END_DATE DATE       End date of the fiscal year.    
FISCAL_YEAR_END_DATE_ID NUMBER 38 0   Last day of fiscal year in YYYYMMDD format.    
FISCAL_YEAR_TOTAL_WEEKS NUMBER 38 0   Number of weeks in this fiscal year.    
FISCAL_YEAR_TOTAL_DAYS NUMBER 38 0   Number of days in this fiscal year.    
FIRST_QUARTER_FISCAL_YEAR_FLG VARCHAR2 16     Indicates that this quarter is the first quarter of fiscal year.    
LAST_QUARTER_FISCAL_YEAR_FLAG VARCHAR2 16     Indicates that this quarter is the last quarter of fiscal year.    
CURRENT_FISCAL_QUARTER_CODE VARCHAR2 16     Indicates that this day belongs to current fiscal quarter. Possible value is Current.    
CURRENT_FISCAL_YEAR_CODE VARCHAR2 16     Indicates that this day belongs to current fiscal year. Possible value is Current.    
FISCAL_TRAILING_QUARTER_NUMBER NUMBER 38 0   Indicates the trailing fiscal quarter number    
FISCAL_TRAILING_YEAR_NUMBER NUMBER 38 0   Indicates the trailing fiscal year number    
QUARTER_END_OR_PRV_CRNT_DATE DATE       For current fiscal quarter, day before current date else fiscal quarter end date    
NUMBER_PER_FISCAL_YEAR NUMBER 38 0   Number of periods per fiscal year.    
QUARTER_END_OR_PRV_CRNT_DATE_ALT DATE       For current quarter, if current quarter start then quarter end date else day before current date else quarter end date