CST_WO_UPDATE_EVENTS_INT
This is the interface table to temporarily store work order status update events sent by source manufacturing systems. When work order status is updated in source systems, they communicate the prior and the current status.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_UPDATE_EVENTS_INT_PK |
EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, EVENT_DATE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Code identifying the external system owning this work order definition. | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Surrogate ID identifying the work order in the source system. Manufacturing work order ID. | |
| EVENT_DATE | TIMESTAMP | Yes | Identifies the system date and time when the work order update was performed. | ||
| TRANSACTION_DATE | TIMESTAMP | Indicates the date entered by the user while making the status change. | |||
| WORK_ORDER_STATUS_ID | NUMBER | 18 | Yes | Surrogate ID identifying the current work order status. | |
| WO_SYSTEM_STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the system status code derived using WIE_WO_STATUSES_VL. | |
| PRIOR_WORK_ORDER_STATUS_ID | NUMBER | 18 | Surrogate ID identifying the prior work order status. | ||
| PRIOR_WO_SYSTEM_STATUS_CODE | VARCHAR2 | 30 | Indicates the prior system status code derived using WIE_WO_STATUSES_VL. | ||
| REASON | VARCHAR2 | 240 | User entered reason for the performing the work order update. | ||
| PREPROCESSING_STATUS | VARCHAR2 | 1 | Indicates the preprocessing status of the row. | ||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| INVENTORY_ORGANIZATION_ID | NUMBER | 18 | Manufacturing organization identifier in which the work order is created for this update event. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_WO_UPDATE_EVENTS_INT_PK | Unique | Default | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, EVENT_DATE |