# 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.