# DW_FISCAL_PERIOD_D

This table contains period-level information of fiscal calendars.

## Details

Module:

## Key Columns

FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_NAME

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  | True | Accounting calendar name. |  |
FISCAL_PERIOD_NAME | VARCHAR2 | 256 |  | True | Accounting period name. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of accounting calendar name and accounting period name. |  |
FISCAL_PERIOD_SORT_KEY | VARCHAR2 | 256 |  |  | Enables sorting by fiscal calendar and fiscal period. |  |
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type. |  |
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_YEAR_NUMBER | NUMBER | 38 | 0 |  | Fiscal Year in YYYY format. |  |
FISCAL_QUARTER_NUMBER | NUMBER | 38 | 0 |  | Fiscal quarter. Possible values are 1, 2, 3, and 4. |  |
FISCAL_QUARTER_CODE | VARCHAR2 | 16 |  |  | Fiscal quarter period. For example, 1999Q2. |  |
FISCAL_HALF_NUMBER | NUMBER | 38 | 0 |  | Fiscal half. Possible values are 1 and 2. |  |
FISCAL_PERIOD_TOTAL_WEEKS | NUMBER | 38 | 0 |  | Number of weeks in the fiscal period. |  |
FISCAL_PERIOD_TOTAL_DAYS | NUMBER | 38 | 0 |  | Number of days in the fiscal period. |  |
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_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_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. |  |
FIRST_PERIOD_FISCAL_QTR_FLAG | VARCHAR2 | 16 |  |  | Indicates the first fiscal period of the fiscal quarter. |  |
LAST_PERIOD_FISCAL_QTR_FLAG | VARCHAR2 | 16 |  |  | Indicates the last fiscal period of the fiscal quarter. |  |
FIRST_PERIOD_FISCAL_YEAR_FLAG | VARCHAR2 | 16 |  |  | Indicates the first fiscal period of the fiscal year. |  |
LAST_PERIOD_FISCAL_YEAR_FLAG | VARCHAR2 | 16 |  |  | Indicates the last fiscal period of the fiscal year. |  |
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. |  |
PERIOD_END_OR_PRV_CRNT_DATE | DATE |  |  |  | For current fiscal period, day before current date else fiscal period end date |  |
QUARTER_END_OR_PRV_CRNT_DATE | DATE |  |  |  | For current fiscal quarter, day before current date else fiscal quarter end date |  |
YEAR_END_OR_PRV_CRNT_DATE | DATE |  |  |  | For current fiscal year, day before current date else fiscal year end date |  |
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. |  |
PERIOD_END_OR_PRV_CRNT_DATE_ALT | DATE |  |  |  | For current month, if current month start then month end date else day before current date else Month end date |  |
QUARTER_END_OR_PRV_CRNT_DATE_ALT | DATE |  |  |  | For current quarter, if current quarter start then quarter end date else day before current date else quarter end date |  |
YEAR_END_OR_PRV_CRNT_DATE_ALT | DATE |  |  |  | For current year,if current year start then year end date else day before current date else year end date |  |
FISCAL_YEAR_NUMBER_1 | NUMBER | 38 | 0 |  | Fiscal Year Number 1 |  |
USER_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | User accounting calendar name. |  |
CALENDAR_TYPE_CODE | VARCHAR2 | 32 |  |  | Type of Calendar. Valid values are Accounting or Budgetary Control. |  |
ACCOUNTING_CAL_FLAG | VARCHAR2 | 16 |  |  | Accounting Calendar Flag |  |

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