DW_FISCAL_DAY_D_NO_ADJUST

This view will have the FISCAL_DAY_D data after applying the filter ADJUSTMENT_PERIOD_FLAG IN ('N','~NOVALUE~')

Details

Module:

Key Columns

FISCAL_PERIOD_NAME, FISCAL_PERIOD_TYPE, FISCAL_DAY_DATE_ID, FISCAL_PERIOD_SET_NAME

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FISCAL_PERIOD_NAME VARCHAR2 64 True Accounting period name.
FISCAL_PERIOD_SET_NAME VARCHAR2 16 True Accounting calendar name. #1
FISCAL_PERIOD_TYPE VARCHAR2 16 True Accounting period type.
FISCAL_DAY_DATE_ID NUMBER 38 0 True Fiscal day in YYYYMMDD format.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of accounting calendar name, accounting period type, accounting period nameand fiscal day in YYYYMMDD format.
FISCAL_PERIOD_SORT_KEY VARCHAR2 256 Enables sorting by fiscal calendar and fiscal period.
FISCAL_DAY_DATE DATE Date of the fiscal day.
FISCAL_DAY_CODE VARCHAR2 64 Name of the fiscal day. Values are from the table DW_DAYS_OF_WEEK_LKP_TL with CODE_TYPE=DAYS_OF_WEEK. DW_DAYS_OF_WEEK_LKP_TL DAYS_OF_WEEK_LKP_CODE
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_QUARTER_NUMBER NUMBER 38 0 Fiscal quarter. Possible values are 1, 2, 3, and 4.
FISCAL_QUARTER_CODE VARCHAR2 16 Fiscal quarter . 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. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
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. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
FISCAL_HALF_NUMBER NUMBER 38 0 Fiscal half year. Possible values are 1 and 2. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
FISCAL_YEAR_NUMBER NUMBER 38 0 Fiscal Year in YYYY format. DW_COST_CENTER_D COST_CENTER_SEGMENT
FISCAL_YEAR_START_DATE DATE Start date of the fiscal year. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
FISCAL_YEAR_START_DATE_ID NUMBER 38 0 First day of fiscal year in YYYYMMDD format. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
FISCAL_YEAR_END_DATE DATE End date of the fiscal year. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
FISCAL_YEAR_END_DATE_ID NUMBER 38 0 Last day of fiscal year in YYYYMMDD format. DW_GL_SEGMENT_D GL_SEGMENT_CODE
FISCAL_YEAR_TOTAL_WEEKS NUMBER 38 0 Number of weeks in this fiscal year. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
FISCAL_YEAR_TOTAL_DAYS NUMBER 38 0 Number of days in this fiscal year. DW_GL_SEGMENT_D GL_SEGMENT_CODE
FISCAL_DAY_OF_YEAR NUMBER 38 0 Day number in the fiscal year. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
FISCAL_DAY_OF_QUARTER NUMBER 38 0 Day number in the fiscal quarter. DW_GL_SEGMENT_D GL_SEGMENT_CODE
FISCAL_DAY_OF_PERIOD NUMBER 38 0 Day number in the fiscal period. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
FIRST_DAY_FISCAL_PERIOD_FLAG VARCHAR2 16 Indicates that this day is the first day of fiscal period. DW_GL_SEGMENT_D GL_SEGMENT_CODE
FIRST_DAY_FISCAL_QUARTER_FLAG VARCHAR2 16 Indicates that this day is the first day of fiscal quarter. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
FIRST_DAY_FISCAL_YEAR_FLAG VARCHAR2 16 Indicates that this day is the first day of fiscal year. DW_GL_SEGMENT_D GL_SEGMENT_CODE
LAST_DAY_FISCAL_PERIOD_FLAG VARCHAR2 16 Indicates that this day is the last day of fiscal period. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
LAST_DAY_FISCAL_QUARTER_FLAG VARCHAR2 16 Indicates that this day is the last day of fiscal quarter. DW_GL_SEGMENT_D GL_SEGMENT_CODE
LAST_DAY_FISCAL_YEAR_FLAG VARCHAR2 16 Indicates that this day is the last day of fiscal year. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
FISCAL_WEEK_NUMBER NUMBER 38 0 Week number in the fiscal year. Possible values are 1, 2, and so on. DW_GL_SEGMENT_D GL_SEGMENT_CODE
FISCAL_WEEK_START_DATE DATE Start date of the fiscal week. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
FISCAL_WEEK_START_DATE_ID NUMBER 38 0 First day of fiscal week in YYYYMMDD format. DW_GL_SEGMENT_D GL_SEGMENT_CODE
FISCAL_WEEK_END_DATE DATE End date of the fiscal week. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
FISCAL_WEEK_END_DATE_ID NUMBER 38 0 Last day of fiscal week in YYYYMMDD format. DW_GL_SEGMENT_D GL_SEGMENT_CODE
FIRST_DAY_FISCAL_WEEK_FLAG VARCHAR2 16 Indicates that this day is the first day of fiscal week. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
LAST_DAY_FISCAL_WEEK_FLAG VARCHAR2 16 Indicates that this day is the last day of fiscal week. DW_GL_SEGMENT_D GL_SEGMENT_CODE
FISCAL_DAY_OF_WEEK NUMBER 38 0 Day number in the fiscal week. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
CURRENT_FISCAL_DAY_CODE VARCHAR2 16 Indicates the current fiscal day. Possible value is Current.
CURRENT_FISCAL_WEEK_CODE VARCHAR2 16 Indicates that this day belongs to current fiscal week. Possible value is Current.
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.
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.
FISCAL_YEAR_NUMBER_1 NUMBER 38 0 Fiscal Year Number 1
CALENDAR_TYPE_CODE VARCHAR2 32 Type of Calendar. Valid values are Accounting or Budgetary Control.
ACCOUNTING_CAL_FLAG VARCHAR2 16 Accounting Calendar Flag