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

BUDGET_CODE_COMBINATION_ID, PERIOD_NAME, CONTROL_BUDGET_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.