XCC_REV_FUND_RULE_BALANCES
This tables stores the budget balance funded from revenue by control budget, revenue funding rule and budget year.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
XCC_REV_FUND_RULE_BALANCES_PK |
CONTROL_BUDGET_ID, REV_FUND_RULE_ID, BUDGET_PERIOD_YEAR |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
CONTROL_BUDGET_ID | NUMBER | 18 | Yes | Control budget identifier of the accumulated funding balance. | |
REV_FUND_RULE_ID | NUMBER | 18 | Yes | Revenue funding rule identifier of the accumulated funding balance. | |
BUDGET_PERIOD_YEAR | NUMBER | 18 | Yes | Budget year of the control budget period derived from the calendar of the control budget. | |
ACCUMULATED_FUNDING_AMOUNT | NUMBER | Yes | Amount of funding from revenue added to the budget for the control budget, revenue funding rule and budget year. | ||
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_REV_FUND_RULE_BALANCES_U1 | Unique | FUSION_TS_TX_DATA | CONTROL_BUDGET_ID, REV_FUND_RULE_ID, BUDGET_PERIOD_YEAR |