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 |