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.    
FUNDS_RELEASE_ID NUMBER 38 0   Temporary processing identifier to group periods when sharing funds across periods. The value is cleared once the process to release pending funds to summary control budget completes successfully.    
ARCHIVED_BUDGET_ENTRIES_FLAG VARCHAR2 16     Indicates whether there are archived budget entries.    
ARCHIVED_ACTIVITIES_FLAG VARCHAR2 16     Indicates whether there are archived activities.    
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, 2024, Oracle and/or its affiliates.