MOW_BATCH_JOB_ITEMS_GT
Global Temporary Table. This table contains the information of individual job items temporarily
Details
-
Schema: FUSION
-
Object owner: MOW
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WORK_OBJ_PRIMARY_KEY1 | VARCHAR2 | 64 | Yes | Contains the job item's Primary Key 1 of the Work Object | |
| WORK_OBJ_PRIMARY_KEY2 | VARCHAR2 | 64 | Contains the job item's Primary Key 2 of the Work Object,if it is available | ||
| WORK_OBJ_PRIMARY_KEY3 | VARCHAR2 | 64 | Contains the job item's Primary Key 3 of the Work Object,if it is available | ||
| GROUP_ATTR_VALUE | VARCHAR2 | 300 | The same job item group will have the same value in this column, if available. | ||
| WORK_OBJ_IDENTIFIER_ATTR | VARCHAR2 | 300 | Contains the job item's unique identifier attribute value of the Work Object, if it is available | ||
| RECORD_NUMBER | NUMBER | 18 | Yes | unique values to identify rows |
Indexes
| Index | Uniqueness | Columns | Status |
|---|---|---|---|
| MOW_BATCH_JOB_ITEMS_GT_IX1 | Non Unique | "WORK_OBJ_IDENTIFIER_ATTR" | Obsolete |
| MOW_BATCH_JOB_ITEMS_GT_N1 | Non Unique | "GROUP_ATTR_VALUE" | |
| MOW_BATCH_JOB_ITEMS_GT_U1 | Unique | RECORD_NUMBER |