DW_FA_CALENDAR_PERIODS_D

This is the Dimension table for Fixed asset Calendar Periods details

Details

Module: Assets

Key Columns

PERIOD_NAME, CALENDAR_TYPE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CALENDAR_TYPE VARCHAR2 16 True Name of the asset depreciation calendar.
PERIOD_NAME VARCHAR2 16 True Asset book depreciation calendar period name.
SOURCE_RECORD_ID VARCHAR2 32 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of Calender Type and Period Name.
DESCRIPTION VARCHAR2 64 Description of the depreciation calendar.
PERIOD_SUFFIX_TYPE VARCHAR2 64 Indicates whether the fiscal year or calendar year is used as the default when generating the calendar period name.
NUMBER_PER_FISCAL_YEAR NUMBER 38 0 Number of accounting periods for the fiscal year.
PERIOD_NUM NUMBER 38 0 Period number of depreciation period in the fiscal year.
PERIOD_START_DATE DATE Start date of the calendar period.
PERIOD_END_DATE DATE Ending date of the calendar period.
FISCAL_YEAR_NAME VARCHAR2 32 Fiscal year identification name.
FISCAL_YEAR NUMBER 38 0 Name of the accounting fiscal year.
FY_START_DATE DATE Starting date of the fiscal year.
FY_END_DATE DATE Ending date of the fiscal year.
MID_YEAR_DATE DATE Starting date of the second half of the fiscal year.
TRAILING_PERIOD_NUMBER NUMBER 38 0 Indicates the trailing period number
TRAILING_YEAR_NUMBER NUMBER 38 0 Indicates the trailing year number
CREATION_DATE TIMESTAMP Creation Date