WIE_WO_STATUS_HISTORY

This table stores the status transitions that happen in the work order business object. The new and old statuses are persisted in this table along with the date and the reason for the change. The cost management interface program will propagate these status transitions to the cost management reading the ones that are not transferred yet.

Details

• Schema: FUSION

• Object owner: WIE

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
WIE_WO_STATUS_HISTORY_PK	WO_STATUS_HISTORY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
WO_STATUS_HISTORY_ID	NUMBER		18	Yes	The unique identifier of work order status history record. Its value is an application generated unique id.
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.
ORGANIZATION_ID	NUMBER		18	Yes	The organization identifier that represents the manufacturing plant to which this status history record belongs.
WORK_ORDER_ID	NUMBER		18	Yes	Represents the internal identifier of the work order.
STATUS_CHANGE_DATE	TIMESTAMP			Yes	Date when the status change happens.
OLD_STATUS_ID	NUMBER		18	Yes	The old work order status identifier.
NEW_STATUS_ID	NUMBER		18	Yes	The new work order status identifier.
NEXT_STATUS_ID	NUMBER		18		Used to store the identifier of the work order status that the user intends the work order to change to after approvals have been granted.
REASON	VARCHAR2	240			The reason for the status change. Not all status transitions will have a reason. But some like cancellation will have a reason.
CST_INTERFACED_FLAG	VARCHAR2	1		Yes	Flag to indicate whether the records are interfaced to costing or not. When created this flag will have a value of 'N'. The interface program that pushes the data to costing will update this column value to 'Y' and also updates the job details that updated this record. The costing interface program only picks up records with a 'N' value.
WO_OPERATION_TRANSACTION_ID	NUMBER		18		Represents the foreign key to the operation transaction record that caused this status change to occur on the work order.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
WIE_WO_STATUS_HISTORY	wie_work_orders_b	WORK_ORDER_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
WIE_WO_STATUS_HISTORY_N01	Non Unique	Default	ORGANIZATION_ID
WIE_WO_STATUS_HISTORY_N02	Non Unique	Default	WORK_ORDER_ID	Obsolete
WIE_WO_STATUS_HISTORY_N03	Non Unique	Default	WORK_ORDER_ID, WO_OPERATION_TRANSACTION_ID
WIE_WO_STATUS_HISTORY_U01	Unique	Default	WO_STATUS_HISTORY_ID
WIE_WO_STATUS_HISTORY_U02	Unique	Default	WORK_ORDER_ID, STATUS_CHANGE_DATE	Obsolete