EGI_IMPORT_BATCH_CHANGES
This table stores all change orders or new item requests associated with batch.
Details
-
Schema: FUSION
-
Object owner: EGI
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
EGI_IMPORT_BATCH_CHANGES_PK |
BATCH_ID, BUNDLE_ID, REQUEST_ID, CHANGE_TYPE, ITEM_CLASS_ID, ORGANIZATION_ID, CHANGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Identifier determining the batch id of the import batch | |
| BUNDLE_ID | NUMBER | 18 | Yes | Identifier determining the bundle id of the item being imported so that items with same bundle id will be grouped together in single change order if One per bundle change import option is choosen | |
| REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |
| ITEM_CLASS_ID | NUMBER | 18 | Yes | Item Class Id for which CO/NIR is being created. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | Organization Identifier for which CO/NIR is being created. | |
| CHANGE_TYPE | VARCHAR2 | 3 | Yes | Specifies if this record corresponds to CO or NIR | |
| CHANGE_ID | NUMBER | 18 | Yes | ChangeId depending upon ChangeType this will be either NIR Id or CO Id | |
| ERROR_CODE | VARCHAR2 | 36 | Error Code in case the row cannot be created. | ||
| THREAD_NUMBER | NUMBER | Thread NUMBER used in batch processes to take asynchronous actions on change orders or new item requests created by an item import job. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| EGI_IMPORT_BATCH_CHANGES | egi_import_batches_b | BATCH_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EGI_IMPORT_BATCH_CHANGES_U1 | Unique | Default | BATCH_ID, BUNDLE_ID, REQUEST_ID, CHANGE_TYPE, ITEM_CLASS_ID, ORGANIZATION_ID, CHANGE_ID |