# DW_BC_BALANCE_CF (Preview)

This table requires activation of Budgetary Control functional area. This fact table stores the budget balances and consumption of budget for each control budget, budget account and period.

## Details

Module: Budgetary Control

## Key Columns

CONTROL_BUDGET_ID, PERIOD_NAME, BUDGET_CODE_COMBINATION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
CONTROL_BUDGET_ID | NUMBER | 38 | 0 | True | Identifies the impacted control budget. |  |
BUDGET_CODE_COMBINATION_ID | NUMBER | 38 | 0 | True | Identifier of the budget account for which this balance is being tracked. |  |
PERIOD_NAME | VARCHAR2 | 32 |  | True | Corresponds to the budget period of this balance. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of Asset adjustment identifiers. |  |
PERIOD_SET_NAME | VARCHAR2 | 32 |  |  | Budget calendar period set name |  |
PERIOD_TYPE | VARCHAR2 | 32 |  |  | Control budget calendar period type |  |
LEDGER_ID | NUMBER | 38 | 0 |  | Primary ledgers defined in GL and enabled for budgetary control. Default value is -98. |  |
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Ledger Currency Code |  |
CHART_OF_ACCOUNTS_ID | NUMBER | 38 | 0 |  | Key flexfield structure defining column for the associated ledger's chart of accounts |  |
BUDGET_CHART_OF_ACCOUNTS_ID | NUMBER | 38 | 0 |  | Key flexfield structure defining column for the control budget accounts |  |
XCC_SEGMENT1 | VARCHAR2 | 32 |  |  | Accounting segment 1. |  |
XCC_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 1 value set code. |  |
XCC_SEGMENT2 | VARCHAR2 | 32 |  |  | Accounting segment 2. |  |
XCC_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 2 value set code. |  |
XCC_SEGMENT3 | VARCHAR2 | 32 |  |  | Accounting segment 3. |  |
XCC_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 3 value set code. |  |
XCC_SEGMENT4 | VARCHAR2 | 32 |  |  | Accounting segment 4. |  |
XCC_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 4 value set code. |  |
XCC_SEGMENT5 | VARCHAR2 | 32 |  |  | Accounting segment 5. |  |
XCC_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 5 value set code. |  |
XCC_SEGMENT6 | VARCHAR2 | 32 |  |  | Accounting segment 6. |  |
XCC_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 6 value set code. |  |
XCC_SEGMENT7 | VARCHAR2 | 32 |  |  | Accounting segment 7. |  |
XCC_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 7 value set code. |  |
XCC_SEGMENT8 | VARCHAR2 | 32 |  |  | Accounting segment 8. |  |
XCC_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 8 value set code. |  |
XCC_SEGMENT9 | VARCHAR2 | 32 |  |  | Accounting segment 9. |  |
XCC_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 9 value set code. |  |
XCC_SEGMENT10 | VARCHAR2 | 32 |  |  | Accounting segment 10. |  |
XCC_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 10 value set code. |  |
PROJECT_ID | NUMBER | 38 | 0 |  | Project accounting project unique identifier. Default value is -98. |  |
PROJECT_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Project Organization identifier |  |
PJC_CONTRACT_ID | NUMBER | 38 | 0 |  | Project accounting contract unique identifier for the award associated with the budget amount. Default value is -98. |  |
BUDGET_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Currency assigned to the control budget |  |
BC_BUDGET_AMOUNT | NUMBER |  |  |  | Initial budget amount. Add to budget adjustment amount to get current budget. |  |
BC_BUDGET_ADJUSTMENT_AMOUNT | NUMBER |  |  |  | Amount by which the budget has been adjusted. |  |
BC_COMMITMENT_AMOUNT | NUMBER |  |  |  | Budget consumption classified as commitments, typically requisitions |  |
BC_OBLIGATION_AMOUNT | NUMBER |  |  |  | Budget consumption classified as obligations, typically purchase orders |  |
BC_OTHER_AMOUNT | NUMBER |  |  |  | Other types of budget consumption, e.g. project expenditures |  |
BC_ACTUAL_AMOUNT | NUMBER |  |  |  | Budget consumption classified as actual expenditures, typically receipts or invoices |  |
BC_FUNDS_AVAILABLE_AMOUNT | NUMBER |  |  |  | Amount available for this budget. |  |
BC_APPROVED_COMMITMENT_AMOUNT | NUMBER |  |  |  | Amount in approved commitments, a lower level bucket. |  |
BC_APPROVED_AUTHORIZATION_AMOUNT | NUMBER |  |  |  | Approved spending authorization commitment amount. |  |
BC_APPROVED_OBLIGATION_AMOUNT | NUMBER |  |  |  | Amount in approved obligations a lower level bucket. |  |
BC_DETAIL_OTHER_AMOUNT | NUMBER |  |  |  | Amount in other encumbrances, a lower level bucket. |  |
BC_UNRELEASED_BUDGET_AMOUNT | NUMBER |  |  |  | Amount that has been budgeted to this period but has not yet been released for expenditure. |  |
BC_ACCOUNTED_PAYABLES_AMOUNT | NUMBER |  |  |  | Amount in accounted payables, a lower level bucket. |  |
BC_ACCOUNTED_RECEIPTS_AMOUNT | NUMBER |  |  |  | Amount in accounted receipts, a lower level bucket. |  |
BC_ACCOUNTED_PROJECT_AMOUNT | NUMBER |  |  |  | Amount in accounted projects, a lower level bucket. |  |
BC_MISC_EXPENDITURES_AMOUNT | NUMBER |  |  |  | Amount in miscellaneous expenditures, a lower level bucket. |  |
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.