Work Order Status History

The Work Order History Status view object contains the history of status transitions in a work order. The new and old statuses are stored along with the date and other details.

Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOStatusHistoryExtractPVO

Primary Keys : WOStatusHistoryPEOWoStatusHistoryId

Initial Extract Date : WOStatusHistoryPEOCreationDate

Incremental Extract Date : WOStatusHistoryPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
WOStatusHistoryPEOCreatedBy	User who created the work order status history record.
WOStatusHistoryPEOCreationDate	Date and time when the work order status history record was created.
WOStatusHistoryPEOCstInterfacedFlag	Indicates if the status history records are interfaced to costing.
WOStatusHistoryPEOJobDefinitionName	Indicates the name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler.
WOStatusHistoryPEOJobDefinitionPackage	Indicates the package name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler.
WOStatusHistoryPEOLastUpdateDate	Date and time when the user last updated the work order status history record.
WOStatusHistoryPEOLastUpdateLogin	Session login associated with the user who last updated the work order status history record.
WOStatusHistoryPEOLastUpdatedBy	User who last updated the work order status history record.
WOStatusHistoryPEONewStatusId	Value that uniquely identifies the work order status after the status change. This is a foreign key to the Work Order Status view object.
WOStatusHistoryPEONextStatusId	Value that uniquely identifies the expected work order status after the electronic record approval.
WOStatusHistoryPEOObjectVersionNumber	Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time 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.
WOStatusHistoryPEOOldStatusId	Value that uniquely identifies the work order status before the status change. This is a foreign key to the Work Order Status view object.
WOStatusHistoryPEOOrganizationId	Value that uniquely identifies the manufacturing plant to which this work order status history belongs.
WOStatusHistoryPEOReason	Reason for canceling the work order.
WOStatusHistoryPEORequestId	Indicates the request ID of the job that created or last updated the row. This is populated through Enterprise Service Scheduler.
WOStatusHistoryPEOStatusChangeDate	Date when the work order status was changed.
WOStatusHistoryPEOWoStatusHistoryId	Value that uniquely identifies the work order status history. This is the primary key of the Work Order Status History view object.
WOStatusHistoryPEOWorkOrderId	Value that uniquely identifies the work order in the Work Order Status History view object. This is a foreign key to the Work Order view object.