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