XCC_BALANCE_ACTIVITIES_HISTORY
This table stores Budgetary Control activities that have been purged from the regular XCC_BALANCE_ACTIVITIES table. Customers should save the contents of this table for audit purposes, but can feel free to archive them to some other storage location.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XCC_ACTIVITIES_HISTORY_PK |
HEADER_NUM, LINE_NUM, BALANCE_LINE_ORDER |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AP_REQUEST_ID | NUMBER | 18 | Archive and purge process request identifier. | ||
| PENDING_HEADER_GROUP_AMOUNT | NUMBER | Total pending reservation amount for earlier transactions with same header group in current budgetary control request for this control budget, account, and period at time of funds reservation. | |||
| HEADER_NUM | VARCHAR2 | 100 | Yes | Budgetary control transaction identifier. | |
| LINE_NUM | NUMBER | 18 | Yes | Line number to uniquely identify the transaction line within the transaction. | |
| BALANCE_LINE_ORDER | VARCHAR2 | 100 | Yes | Balance line number. Uniquely identifies the activity within the transaction line. | |
| CONTROL_BUDGET_ID | NUMBER | 18 | Control budget impacted by this activity. | ||
| CONTROL_LEVEL_CODE | VARCHAR2 | 30 | Control level that must be applied to this activity. Valid values are ABSOLUTE, ADVISORY, TRACKING, and NONE. | ||
| TOLERANCE_AMOUNT | NUMBER | Tolerance amount by which this activity can exceed funds. If both the tolerance amount and tolerance percent are available, the lesser tolerance of the two is used. | |||
| TOLERANCE_PERCENT | NUMBER | Tolerance percent by which this activity can exceed funds. The tolerance percent is applied to the budget amount to get the actual tolerance. If both the tolerance amount and tolerance percent are available, the lesser tolerance of the two is used. | |||
| ENTERED_AMOUNT | NUMBER | Yes | Amount of funds to consume, in the transaction line currency. | ||
| ENTERED_CURRENCY | VARCHAR2 | 15 | Yes | Currency in which the transaction line is denominated. | |
| CONVERSION_TYPE_CODE | VARCHAR2 | 30 | Yes | Conversion type to use for converting from the transaction line currency to the budget currency. | |
| CONVERSION_RATE | NUMBER | Yes | Conversion rate to use for converting from the transaction line currency to the budget currency. | ||
| AMOUNT | NUMBER | Yes | Amount of funds to consume, in the budget currency. | ||
| BUDGET_DATE | DATE | Yes | Date on which to consume funds. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Period in which to consume funds. | ||
| BUDGET_CCID | NUMBER | 18 | Yes | Budget account for which to consume funds. | |
| RESULT_CODE | VARCHAR2 | 30 | Yes | Status of funds check or reservation for this particular balance activity. | |
| ACTIVITY_TYPE_CODE | VARCHAR2 | 30 | Yes | Indicates whether this is an original activity, a liquidation activity, or a backout activity. | |
| ALLOC_HEADER_NUM | VARCHAR2 | 100 | For liquidation activities, identifies the budgetary control header being liquidated. Otherwise, it is NULL. | ||
| ALLOC_LINE_NUM | NUMBER | 18 | For liquidation activities, identifies the budgetary control line being liquidated. Otherwise, it is NULL. | ||
| BACKOUT_HEADER_NUM | VARCHAR2 | 100 | For backout activities, identifies the budgetary control header being undone or reversed. Otherwise, it is NULL. | ||
| BACKOUT_LINE_NUM | NUMBER | 18 | For backout activities, identifies the budgetary control line being undone or reversed. Otherwise, it is NULL. | ||
| BALANCE_TYPE_CODE | VARCHAR2 | 30 | Yes | Indicates the type of balance impacted by this activity. Some examples are commitment, obligation, and budget. | |
| SUB_BALANCE_TYPE_CODE | VARCHAR2 | 30 | Indicates the type of balance impacted by this activity, tracked at a more detailed level. Some examples are approved commitment, approved obligation, accounted payables, and accounted receipts. | ||
| BUDGET_AMOUNT | NUMBER | Initial amount budgeted to this control budget, account, and period at the time of funds validation. Add the budget adjustment amount to get the total budget. | |||
| BUDGET_ADJUSTMENT_AMOUNT | NUMBER | Amount by which the budgeted amount has been increased or decreased for this control budget, account, and period at the time of funds validation. Add the initial budget amount to get the total budget. | |||
| COMMITMENT_AMOUNT | NUMBER | Funds committed for this control budget, account, and period at the time of funds validation. | |||
| OBLIGATION_AMOUNT | NUMBER | Funds obligated for this control budget, account, and period at the time of funds validation. | |||
| ACTUAL_AMOUNT | NUMBER | Funds spent for this control budget, account, and period at the time of funds validation. | |||
| OTHER_AMOUNT | NUMBER | Expenditures other than funds spent, funds committed, and funds obligated for this control budget, account, and period at the time of funds validation. | |||
| FUNDS_AVAILABLE_AMOUNT | NUMBER | Total funds available for this control budget, account, and period at the time of funds validation. It is equal to the total budget minus the total expenditures. | |||
| PENDING_AMOUNT | NUMBER | Total pending reservations from earlier transactions for this control budget, account, and period at the time of funds validation. | |||
| OTHER_LINES_AMOUNT | NUMBER | Total pending reservations from earlier lines in this transaction for this control budget, account, and period at the time of funds validation. | |||
| NET_TOLERANCE_AMOUNT | NUMBER | Tolerance amount by which this activity can exceed funds. Calculated based on the least of the TOLERANCE_AMOUNT and the TOLERANCE_PERCENT. This column does not track the tolerance that was actually used; it just tracks the tolerance that was available. | |||
| PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Project Management expenditure type identifier. This is only populated for burdening activities. | ||
| PJC_TOP_RESOURCE_ID | NUMBER | 18 | Project Management top resource identifier being burdened against. This is only populated for burdening activities. | ||
| PJC_RESOURCE_ID | NUMBER | 18 | Project Management lowest resource identifier being burdened against. This is only populated for burdening activities. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | General ledger account associated with this activity. It is only populated for burdening activities, as they can override the line level account. | ||
| LEDGER_AMOUNT | NUMBER | Amount of funds to consume, in the ledger currency. It is only populated for burdening activities. | |||
| BURDEN_LINE_FLAG | VARCHAR2 | 1 | Indicates whether this activity originated from burdening. Valid values are Y and N. | ||
| OVERRIDE_CLOSED_PERIOD_FLAG | VARCHAR2 | 1 | Indicates whether closed period override is being considered for an activity. Valid values are Y and N. | ||
| OVERRIDE_FUNDS_FLAG | VARCHAR2 | 1 | Indicates whether insufficient funds override is being considered for an activity. Valid values are Y and N. | ||
| ESTIMATED_TOLERANCE_AMOUNT | NUMBER | Estimated tolerance amount needed for funds validation to pass. | |||
| ESTIMATED_OVERRIDE_AMOUNT | NUMBER | Estimated override amount needed for funds validation to pass. | |||
| PERIOD_CHANGE_FOR_UNDO_FLAG | VARCHAR2 | 1 | Indicates that the data is reversed into a different period. | ||
| PROCESSED_FOR_ESSBASE_FLAG | VARCHAR2 | 1 | Indicates whether balances have been transferred to the budget cube for this control budget and period name combination. | ||
| BALANCES_UPDATED_FLAG | VARCHAR2 | 1 | Indicates whether control budget balance is impacted. Valid values are Y, N, and NULL. | ||
| 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_ACTIVITIES_HISTORY_U1 | Unique | Default | HEADER_NUM, LINE_NUM, BALANCE_LINE_ORDER |