DW_FISCAL_PERIOD_D

This table contains period-level information of fiscal calendars.

Details

Module:

Key Columns

FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_NAME

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_NAME VARCHAR2 256 True Accounting period name.
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of accounting calendar name and accounting period name.
FISCAL_PERIOD_SORT_KEY VARCHAR2 256 Enables sorting by fiscal calendar and fiscal period.
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type.
ADJUSTMENT_PERIOD_FLAG VARCHAR2 16 Indicates an adjustment period for the fiscal year.
FISCAL_PERIOD_NUMBER NUMBER 38 0 Accounting period number.
FISCAL_PERIOD_START_DATE DATE Start date of the fiscal period.
FISCAL_PERIOD_START_DATE_ID NUMBER 38 0 First day of fiscal day in YYYYMMDD format.
FISCAL_PERIOD_END_DATE DATE End date of the fiscal period.
FISCAL_PERIOD_END_DATE_ID NUMBER 38 0 Last day of fiscal period in YYYYMMDD format.
FISCAL_YEAR_NUMBER NUMBER 38 0 Fiscal Year in YYYY format.
FISCAL_QUARTER_NUMBER NUMBER 38 0 Fiscal quarter. Possible values are 1, 2, 3, and 4.
FISCAL_QUARTER_CODE VARCHAR2 16 Fiscal quarter period. For example, 1999Q2.
FISCAL_HALF_NUMBER NUMBER 38 0 Fiscal half. Possible values are 1 and 2.
FISCAL_PERIOD_TOTAL_WEEKS NUMBER 38 0 Number of weeks in the fiscal period.
FISCAL_PERIOD_TOTAL_DAYS NUMBER 38 0 Number of days in the fiscal period.
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.
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.
FIRST_PERIOD_FISCAL_QTR_FLAG VARCHAR2 16 Indicates the first fiscal period of the fiscal quarter.
LAST_PERIOD_FISCAL_QTR_FLAG VARCHAR2 16 Indicates the last fiscal period of the fiscal quarter.
FIRST_PERIOD_FISCAL_YEAR_FLAG VARCHAR2 16 Indicates the first fiscal period of the fiscal year.
LAST_PERIOD_FISCAL_YEAR_FLAG VARCHAR2 16 Indicates the last fiscal period of the fiscal year.
CURRENT_FISCAL_PERIOD_CODE VARCHAR2 16 Indicates that this day belongs to current fiscal period. Possible value is Current.
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.
PERIOD_END_OR_PRV_CRNT_DATE DATE For current fiscal period, day before current date else fiscal period end date
QUARTER_END_OR_PRV_CRNT_DATE DATE For current fiscal quarter, day before current date else fiscal quarter end date
YEAR_END_OR_PRV_CRNT_DATE DATE For current fiscal year, day before current date else fiscal year end date
FISCAL_TRAILING_PERIOD_NUMBER NUMBER 38 0 Indicates the trailing fiscal period number
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
NUMBER_PER_FISCAL_YEAR NUMBER 38 0 Number of periods per fiscal year.
PERIOD_END_OR_PRV_CRNT_DATE_ALT DATE For current month, if current month start then month end date else day before current date else Month end date
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
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
FISCAL_YEAR_NUMBER_1 NUMBER 38 0 Fiscal Year Number 1
USER_PERIOD_SET_NAME VARCHAR2 16 User accounting calendar name.
CALENDAR_TYPE_CODE VARCHAR2 32 Type of Calendar. Valid values are Accounting or Budgetary Control.
ACCOUNTING_CAL_FLAG VARCHAR2 16 Accounting Calendar Flag