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 |