XCC_TR_BALANCES

This table temporarily stores the balance updates for each budgetary control validation request until they get asynchronously posted to the budgetary control balances in XCC_BALANCES.

Details

• Schema: FUSION

• Object owner: XCC

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
XCC_TR_BALANCES_PK	CONTROL_BUDGET_ID, BUDGET_CCID, PERIOD_NAME, DATA_SET_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
DATA_SET_ID	NUMBER		18	Yes	Identifies the unique identifier of the budgetary control validation run for which balances changes are being tracked.
CONTROL_BUDGET_ID	NUMBER		18	Yes	Identifies the control budget ID for which balances are being tracked.
BUDGET_CCID	NUMBER		18	Yes	Identifies the budget account ID for which balance changes are being tracked.
PERIOD_NAME	VARCHAR2	15		Yes	Identifies the period name for which balance changes are being tracked.
BALANCES_POSTED_FLAG	VARCHAR2	1		Yes	Status of the transfer to XCC_BALANCES. Values can be either Y or N.
BUDGET_AMOUNT	NUMBER				Change to the budget balance because of budgetary control validation.
BUDGET_ADJUSTMENT_AMOUNT	NUMBER				Change to the budget adjustment balance because of budgetary control validation.
COMMITMENT_AMOUNT	NUMBER				Change to the commitment balance because of the budgetary control validation.
OBLIGATION_AMOUNT	NUMBER				Change to the obligation balance because of budgetary control validation.
OTHER_AMOUNT	NUMBER				Change to the other type of consumption balance because of budgetary control validation.
ACTUAL_AMOUNT	NUMBER				Change to the actual expenditure balance because of budgetary control validation.
FUNDS_AVAILABLE_AMOUNT	NUMBER				Change to the available budget balance because of budgetary control validation.
APPROVED_COMMITMENT_AMOUNT	NUMBER				Change to the approved commitment balance because of budgetary control validation.
APPROVED_AUTHORIZATION_AMOUNT	NUMBER				Change to the approved authorization balance because of budgetary control validation.
APPROVED_OBLIGATION_AMOUNT	NUMBER				Change to the approved obligation balance because of the budgetary control validation.
VALIDATED_PAYABLES_AMOUNT	NUMBER				Change to the validated payables balance because of budgetary control validation.
APPROVED_PROJECT_AMOUNT	NUMBER				Change to the approved project balance because of budgetary control validation.
DETAIL_OTHER_AMOUNT	NUMBER				Change to the encumbrance balance because of budgetary control validation.
UNRELEASED_BUDGET_AMOUNT	NUMBER				Change to the unreleased budget balance because of budgetary control validation.
ACCOUNTED_PAYABLES_AMOUNT	NUMBER				Change to the accounted payables balance because of budgetary control validation.
ACCOUNTED_RECEIPTS_AMOUNT	NUMBER				Change to the accounted receipts balance because of budgetary control validation.
ACCOUNTED_PROJECT_AMOUNT	NUMBER				Change to the accounted project balance because of budgetary control validation.
MISC_EXPENDITURES_AMOUNT	NUMBER				Change to the miscellaneous expenditure balance because of budgetary control validation.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
XCC_TR_BALANCES_N1	Non Unique	FUSION_TS_TX_DATA	BALANCES_POSTED_FLAG, CONTROL_BUDGET_ID, BUDGET_CCID, PERIOD_NAME
XCC_TR_BALANCES_U1	Unique	FUSION_TS_TX_DATA	CONTROL_BUDGET_ID, BUDGET_CCID, PERIOD_NAME, DATA_SET_ID