DW_NS_FISCALCALPERIOD_DH

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

Details

Module:

Key Columns

fiscalcalendar, fulldate, 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    

Copyright © 2019, 2026, Oracle and/or its affiliates.