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.