DW_NS_FISCALCALPERIOD_DH

This table contains fiscal period hierarchy of a day for each fiscal calendar.

Details

Module:

Key Columns

fulldate, fiscalcalendar, base_accountingperiod

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
fiscalcalendar NUMBER 38 0 True Internal ID
fulldate DATE True Calendar Date
base_accountingperiod NUMBER 38 0 True Internal ID
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Primary Key
top_accountingperiod NUMBER 38 0 Internal ID
level1_accountingperiod NUMBER 38 0 Internal ID
level2_accountingperiod NUMBER 38 0 Internal ID
fiscalcalendar_name VARCHAR2 128 Fiscal Calendar Name
isdefault VARCHAR2 16 Restrict to Department
level2_periodname VARCHAR2 128 Level 2 Period Name
level2_startdate DATE Level 2 Period Start Date
level2_enddate DATE Level 2 Period End Date
level1_periodname VARCHAR2 128 Level 1 Period Name
level1_startdate DATE Level 1 Period Start Date
level1_enddate DATE Level 1 Period End Date
top_periodname VARCHAR2 128 Top Period Name
top_startdate DATE Top Level Period Start Date
top_enddate DATE Top Level Period End Date
trailing_month_number NUMBER 38 0 Indicate trailing month number for standard gregorian period
trailing_quarter_number NUMBER 38 0 Indicate trailing quarter number for standard gregorian period
trailing_year_number NUMBER 38 0 Indicate trailing year number for standard gregorian period
trailing_fiscal_level2_number NUMBER 38 0 Indicate trailing level2 period number for fiscal calendar and fiscal period
trailing_fiscal_level1_number NUMBER 38 0 Indicate trailing level1 period number for fiscal calendar and fiscal period
trailing_fiscal_toplevel_number NUMBER 38 0 Indicate trailing toplevel period number for fiscal calendar and fiscal period