MOW_BATCH_JOB_ITEMS_GROUP_GT
Global Temporary Table. This table contains the information of individual job items need to be processed in group temporarily
Details
-
Schema: FUSION
-
Object owner: MOW
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MOW_BATCH_JOB_ITEMS_GROUP_PK |
RECORD_NUMBER |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECORD_NUMBER | NUMBER | 18 | Yes | unique values to identify rows | |
| GROUP_ATTR_VALUE | VARCHAR2 | 300 | Yes | unique value grouping attribute | |
| GROUP_ITEM_COUNT | NUMBER | 18 | Yes | count of Group items in same group |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| MOW_BATCH_JOB_ITEMS_GROUP_PK | Unique | RECORD_NUMBER |