# DW_FA_CALENDAR_PERIODS_D

This is the Dimension table for Fixed asset Calendar Periods details

## Details

Module: Assets

## Key Columns

CALENDAR_TYPE, PERIOD_NAME

## 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 |  |

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