XCC_BUDGET_DATA_SETS_GT
This temporary table is used to process data sets for the budget import program
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XCC_BUDGET_DATA_SETS_GT_PK |
SOURCE_APPLICATION, SOURCE_BUDGET, DATA_SET |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| SOURCE_APPLICATION | VARCHAR2 | 30 | Yes | The source budget system where the budget data is prepared |
| SOURCE_BUDGET | VARCHAR2 | 100 | Yes | The source budget in the source budget system for which the budget data is prepared |
| DATA_SET | VARCHAR2 | 500 | Yes | Set of records to be imported by the budget import process. |
| STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates whether the data set has successfully passed validations or not |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XCC_BUDGET_DATA_SETS_GT_U1 | Unique | SOURCE_APPLICATION, SOURCE_BUDGET, DATA_SET |