DW_BC_CONTROL_BUDGET_D (Preview)

This table requires activation of Budgetary Control functional area. This table stores the header information for a control budget.

Details

Module: Budgetary Control

Key Columns

CONTROL_BUDGET_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTROL_BUDGET_ID NUMBER 38 0 True Control Budget Unique Identifier    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Source record identifier.    
CONTROL_BUDGET_ID_CHAR VARCHAR2 128     Control Budget Unique Identifier    
NAME VARCHAR2 128     Control budget name user identifier    
DESCRIPTION VARCHAR2 256     Description of the control budget    
PERIOD_SET_NAME VARCHAR2 32     Budget calendar period set name    
PERIOD_TYPE VARCHAR2 32     Control budget calendar period type    
START_PERIOD_NAME VARCHAR2 32     Start period of the control budget    
END_PERIOD_NAME VARCHAR2 32     End period of the control budget    
START_EFF_PERIOD_NUM NUMBER 38 0   Effective period number of the start period of the control budget    
END_EFF_PERIOD_NUM NUMBER 38 0   Effective period number of the end period of the control budget    
START_DATE DATE       Start date of the start period of the control budget. Together with the end date, they indicate the entire date ranges of the control budget    
END_DATE DATE       End date of the end period of the control budget. Together with the start date, they indicate the entire date ranges of the control budget    
SOURCE_BUDGET_SYSTEM_CODE VARCHAR2 32     The source budget type code where budgets were created    
SOURCE_BUDGET VARCHAR2 128     XCC lookup code or control budget name value. Dependant on the source budget type code value    
CONTROL_LEVEL_CODE VARCHAR2 32     Control level code that will be used when determining funds available for distributions that fall into this supplemental budgetary control or default rule    
TOLERANCE_PERCENT NUMBER       The % of the budget amount that will be used as tolerance    
TOLERANCE_AMOUNT NUMBER       The fixed amount that will be used as tolerance    
BUDGET_CURRENCY_CODE VARCHAR2 32     Currency assigned to the control budget    
DEFAULT_RATE_TYPE VARCHAR2 32     Default rate type assigned to the control budget    
BUDGET_MANAGER_ID NUMBER 38 0   Budget manager responsible for this control budget    
STATUS_CODE VARCHAR2 32     Status code of the control budget    
LEDGER_ID NUMBER 38 0   Primary ledgers defined in GL and enabled for budgetary control. Default value is -98.    
CHART_OF_ACCOUNTS_ID NUMBER 38 0   Key flexfield structure defining column for the associated ledger's chart of accounts    
PROJECT_ID NUMBER 38 0   Project accounting project unique identifier. Default value is -98.    
BUDGET_CHART_OF_ACCOUNTS_ID NUMBER 38 0   Key flexfield structure defining column for the control budget accounts    
BALANCE_INCREASES_ALLOWED_FLAG VARCHAR2 16     Indicates whether increases are allowed as adjustments to the initial loaded amounts for control budget combination for this control budget or not    
BALANCE_DECREASES_ALLOWED_FLAG VARCHAR2 16     Indicates whether decreases are allowed as adjustments to the initial loaded amounts for control budget combination for this control budget or not    
NEGATIVE_BALANCES_ALLOWED_FLAG VARCHAR2 16     Indicates whether funds available balance is allowed to go negative from the adjustment to the initial loaded amounts for control budget combination for this control budget or not    
UOM_CODE VARCHAR2 16     UOM assigned to the control budget    
PARENT_SOURCE_BUDGET VARCHAR2 128     Source budget type code of the master control budget    
PARENT_SOURCE_SYSTEM VARCHAR2 32     Source budget name of the master control budget    
ALLOW_OVERRIDES_FLAG VARCHAR2 16     Indicates if overrides are allowed for this control budget.    
NO_OVERRIDES_NOTIFY_FLAG VARCHAR2 16     Indicates if the budget owner must be notified when no overrides are available.    
OVERRIDES_TAKEN_NOTIFY_FLAG VARCHAR2 16     Indicates if the budget owner must be notified when a override is taken.    
MAXIMUM_OVERRIDE_AMOUNT NUMBER       Maximum override amount allowed for this control budget. Amount is in the budget currency.    
FUNDS_RELEASE_TIMEFRAME VARCHAR2 32     Determines when the funds are made available for a particular period. Valid values are: RELEASE_IMMEDIATELY and RELEASE_UPON_OPEN.    
PJC_CONTRACT_ID NUMBER 38 0   Project accounting contract unique identifier for the award associated with the budget amount. Default value is -98.    
INTERNAL_BUDGET_TYPE_CODE VARCHAR2 32     Order of segments in the budget chart of accounts structure. For example, PARF indicates a segment order of Project, Award, Top Resource, Funding Source.    
FV_TYPE_CODE VARCHAR2 32     Indicates the budgetary control processing type of the control budget.    
OFFLINE_REASON_CODE VARCHAR2 32     Reason for taking control budget offline.    
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.