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    
CREATED_FROM_CODE VARCHAR2 32     Method used to create this control budget. Valid values are CB_UI and PPM_API.    
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    
ACCOUNT_CREATION_ALLOWED_FLAG VARCHAR2 16     Indicates that when control budget accounts do not exist, they will be created by the system    
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    
BDG_AMT_NOT_FOUND_RESULT_CODE VARCHAR2 32     Result when budgeted amount not found. In V2, this column will be defaulted to PASS and won't be exposed in the UI. In future releases, it will have values as FAIL or PASS    
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    
REQUEST_ID NUMBER 38 0   Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.    
PREVIOUS_STATUS_CODE VARCHAR2 32     Contains the previous status of the control budget. This is used when the status needs to be reverted to the previous status.    
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.    
RECALC_REQUEST_ID NUMBER 38 0   Enterprise Service Scheduler: indicates the request ID of the recalculation program.    
PCBD_ERROR_CODE VARCHAR2 32     Error code indicating the error that was first encountered by the Prepare Control Budget Definition program.    
IN_USE_END_EFF_PERIOD_NUM NUMBER 38 0   End period effective number of the control budget when it was In Use the last time.    
RECALC_SUCCESS_FLAG VARCHAR2 16     Indicates whether the recalculation program has run successfully for this control budget.    
PCBD_INCOMPATIBLE_DATA VARCHAR2 32     Stores the parameter value, such as a control budget identifier. This prevents the prepare control budget definition process from running in parallel with another process that has the same value in this column.    
CUBE_ID NUMBER 38 0   Foreign key to XCC_BALANCES_CUBES. A null value means that either the cube does not exist, or the cube exists but control budget is not part of it yet.    
REFRESH_BALANCES_REQD_FLAG VARCHAR2 16     Indicates that balances for this control budget must be refreshed into the corresponding cube.    
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, 2024, Oracle and/or its affiliates.