XCC_STREAM_BALANCES_T
This temporary table contains budgetary control balances impacted by budget imports and transactions that have passed budgetary control validation but have not yet been updated to the budgetary control balances cubes. Oracle internal use only.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XCC_STREAM_BALANCES_T_PK |
CONTROL_BUDGET_ID, BUDGET_CCID, PERIOD_NAME |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CUBE_ID | NUMBER | 18 | Yes | Identifies the budgetary control balances cube with pending updates. | |
| CONTROL_BUDGET_ID | NUMBER | 18 | Yes | Identifies the control budget with pending updates. | |
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Identifies the budget period with pending updates. | |
| BUDGET_CCID | NUMBER | 18 | Yes | Identifies the budget account with pending updates. | |
| 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_STREAM_BALANCES_T_N1 | Non Unique | XCC_STREAM_BALANCES_T_N1 | CUBE_ID |
| XCC_STREAM_BALANCES_T_U1 | Unique | XCC_STREAM_BALANCES_T_U1 | CONTROL_BUDGET_ID, BUDGET_CCID, PERIOD_NAME |