# DW_BC_PERIOD_STATUS_D (Preview)

This table requires activation of Budgetary Control functional area. This table stores the periods statuses for control budgets which control when budget is available for consumption.

## Details

Module: Budgetary Control

## Key Columns

PERIOD_STATUS_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PERIOD_STATUS_ID | NUMBER | 38 | 0 | True | Period Status Unique Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
CONTROL_BUDGET_ID | NUMBER | 38 | 0 |  | Control Budget Identifier |  |
PERIOD_NAME | VARCHAR2 | 32 |  |  | Control budget period name user identifier |  |
EFFECTIVE_PERIOD_NUM | NUMBER | 38 | 0 |  | Effective period number of the period |  |
START_DATE | DATE |  |  |  | Date on which control budget period begins |  |
END_DATE | DATE |  |  |  | Date on which control budget period ends |  |
QUARTER_NUM | NUMBER | 38 | 0 |  | Quarter number of the control budget period |  |
PERIOD_YEAR | NUMBER | 38 | 0 |  | Budget year of the control budget period |  |
PERIOD_NUM | NUMBER | 38 | 0 |  | Control budget period number internal identifier |  |
FISCAL_YEAR | VARCHAR2 | 32 |  |  | Fiscal year of the control budget |  |
STATUS_CODE | VARCHAR2 | 32 |  |  | Control budget period status to indicate whether budget activity is allowed |  |
BUDGET_EFFECTIVE_PERIOD_NUM | NUMBER | 38 | 0 |  | Effective period number. Gaps due to adjustment periods are removed. |  |
BUDGET_PERIOD_NUM | NUMBER | 38 | 0 |  | Period number. Gaps due to adjustment periods are removed. |  |
CREATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who created the row. |  |
UPDATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who last updated the row. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |

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