DW_FISCAL_DAY_D

This table contains day-level information of fiscal calendars. Join can be done on one of these combinations (Fiscal Period Set Name - Fiscal Period Type - Fiscal Day Date Id, Fiscal Period Set Name - Fiscal Period Type - Fiscal Day Date, Fiscal Period Set Name - Fiscal Period Name - Fiscal Day Date Id, Fiscal Period Set Name - Fiscal Period Name - Fiscal Day Date)

Details

Module:

Key Columns

FISCAL_PERIOD_SET_NAME, FISCAL_DAY_DATE_ID, FISCAL_PERIOD_TYPE, FISCAL_PERIOD_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     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_CODE_VALUES_LKP_TL with CODE_TYPE=DAYS_OF_WEEK.    
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.    
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_HALF_NUMBER NUMBER 38 0   Fiscal half year. Possible values are 1 and 2.    
FISCAL_YEAR_NUMBER NUMBER 38 0   Fiscal Year in YYYY 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.    
FISCAL_DAY_OF_YEAR NUMBER 38 0   Day number in the fiscal year.    
FISCAL_DAY_OF_QUARTER NUMBER 38 0   Day number in the fiscal quarter.    
FISCAL_DAY_OF_PERIOD NUMBER 38 0   Day number in the fiscal period.    
FIRST_DAY_FISCAL_PERIOD_FLAG VARCHAR2 16     Indicates that this day is the first day of fiscal period.    
FIRST_DAY_FISCAL_QUARTER_FLAG VARCHAR2 16     Indicates that this day is the first day of fiscal quarter.    
FIRST_DAY_FISCAL_YEAR_FLAG VARCHAR2 16     Indicates that this day is the first day of fiscal year.    
LAST_DAY_FISCAL_PERIOD_FLAG VARCHAR2 16     Indicates that this day is the last day of fiscal period.    
LAST_DAY_FISCAL_QUARTER_FLAG VARCHAR2 16     Indicates that this day is the last day of fiscal quarter.    
LAST_DAY_FISCAL_YEAR_FLAG VARCHAR2 16     Indicates that this day is the last day of fiscal year.    
FISCAL_WEEK_NUMBER NUMBER 38 0   Week number in the fiscal year. Possible values are 1, 2, and so on.    
FISCAL_WEEK_START_DATE DATE       Start date of the fiscal week.    
FISCAL_WEEK_START_DATE_ID NUMBER 38 0   First day of fiscal week in YYYYMMDD format.    
FISCAL_WEEK_END_DATE DATE       End date of the fiscal week.    
FISCAL_WEEK_END_DATE_ID NUMBER 38 0   Last day of fiscal week in YYYYMMDD format.    
FIRST_DAY_FISCAL_WEEK_FLAG VARCHAR2 16     Indicates that this day is the first day of fiscal week.    
LAST_DAY_FISCAL_WEEK_FLAG VARCHAR2 16     Indicates that this day is the last day of fiscal week.    
FISCAL_DAY_OF_WEEK NUMBER 38 0   Day number in the fiscal week.    
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.    

Notes

#1: DW_FISCAL_DAY_D can be joined to DW_FISCAL_PERIOD_D using FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_NAME

DW_FISCAL_DAY_D can be joined to DW_FISCAL_QUARTER_D using FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_TYPE, FISCAL_YEAR_NUMBER, FISCAL_QUARTER_NUMBER

DW_FISCAL_DAY_D can be joined to DW_FISCAL_YEAR_D using FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_TYPE, FISCAL_YEAR_NUMBER