Workstation Execution Activities

The Workstation Execution Activities view object contains information about execution activities a production operator performs when producing items for a work order within a manufacturing organization. Details track the start and end times of an activity, associated workers, and other relevant production information.

Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WorkstationExecutionActivityExtractPVO

Primary Keys : WsExecActivityId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
CompletionTime	Time the workstation execution activity was completed.
CreatedBy	User who created the workstation execution activities record.
CreationDate	Date and time when the workstation execution activities row was created.
LastUpdateDate	Date and time when a user last updated the workstation execution activities row.
LastUpdateLogin	Session login associated with the user who last updated the workstation execution activities record.
LastUpdatedBy	User who last updated the workstation execution activities row.
ObjectVersionNumber	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.
OpFixedTime	Total fixed time in seconds required for the operation.
OpVariableTime	Total per unit variable time in seconds required for the operation.
OrganizationId	Identifier of the manufacturing plant to which this workstation execution activity belongs.
PersonId	Internal person identifier of the person who performed the execution activity.
StartTime	Start time when the production execution activity begins.
WoOperationId	Value that uniquely identifies the work order operation for a workstation execution activity.
WoQuantity	Total work order quantity at the beginning of an operation.
WorkOrderId	Value that uniquely identifies the work order for a workstation execution activity.
WorkstationId	Value that uniquely identifies the work station in a workstation execution activity.
WsCheckinActivityId	Value that's a foreign key to a workstation check-in and check-out activity row.
WsExecActivityId	Value that uniquely identifies the workstation execution activities row. This is the primary key of the Workstation Execution Activities view object.