CST_WO_UPDATE_EVENTS
This is the persistent table to store the work order status update events. Once the events in the interface table are processed, they are persisted in this table which then acts as source of truth for all the downstream tables.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_UPDATE_EVENTS_PK |
CST_WO_UPDATE_EVENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_WO_UPDATE_EVENT_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order status update in costing. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order in costing. | |
| EVENT_DATE | TIMESTAMP | Yes | Identifies the system date 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. | ||
| LATEST_STATUS_FLAG | VARCHAR2 | 1 | Yes | Indicates if the row represents the latest status for a work order. | |
| REASON | VARCHAR2 | 240 | User entered reason for the performing the work order status update. | ||
| PROCESSED_BY_CA_FLAG | VARCHAR2 | 5 | Flag to indicate whether the row has been processed by cost accounting. | ||
| 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_N1 | Non Unique | Default | PROCESSED_BY_CA_FLAG |
| CST_WO_UPDATE_EVENTS_PK | Unique | Default | CST_WO_UPDATE_EVENT_ID |
| CST_WO_UPDATE_EVENTS_U1 | Unique | Default | CST_WORK_ORDER_ID, EVENT_DATE |