Work Order Operation Start Stop

The Work Order Operation Start Stop view object contains information about the start time and stop time of work order operations. If the operation is serial controlled, then the start time and stop times of the work order operation are stored for individual product serials.

Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOOperationStartStopExtractPVO

Primary Keys : WOOpStartStopPEOOperationStartTime, WOOpStartStopPEOWoOperationId, WOOpStartStopPEOWoProductSerialId

Initial Extract Date : WOOpStartStopPEOCreationDate

Incremental Extract Date : WOOpStartStopPEOLastUpdateDate

Attributes

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

Name Description
WOOpStartStopPEOCreatedBy User who created the operation start or stop record.
WOOpStartStopPEOCreationDate Date and time when the operation start or stop record was created.
WOOpStartStopPEOJobDefinitionName Indicates the name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler.
WOOpStartStopPEOJobDefinitionPackage Indicates the package name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler.
WOOpStartStopPEOLastUpdateDate Date and time when the user last updated the operation start or stop record.
WOOpStartStopPEOLastUpdateLogin Session login associated with the user who last updated the operation start or stop record.
WOOpStartStopPEOLastUpdatedBy User who last updated the operation start or stop record.
WOOpStartStopPEOObjectVersionNumber 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.
WOOpStartStopPEOOperationStartTime Date and time when the work order operation started.
WOOpStartStopPEOOperationStopTime Date and time when the work order operation stopped.
WOOpStartStopPEOOrganizationId Value that uniquely identifies the manufacturing plant where the operation start and stop times are reported for a work order operation.
WOOpStartStopPEORequestId Indicates the request ID of the job that created or last updated the row. This is populated through Enterprise Service Scheduler.
WOOpStartStopPEOWoOpStartStopId Value that uniquely identities the work order operation start stops. This is the primary key of the Work Order Operation Start Stop view object.
WOOpStartStopPEOWoOperationId Value that uniquely identifies the work order operation for which the operation start or stop is reported. This is a foreign key to the Work Order Operation view object.
WOOpStartStopPEOWoProductSerialId Value that uniquely identifies the product serial in the work order view object for which the operation start or stop times are reported. This is a foreign key to the Work Order Product Serial view object.