Workstation Operator Assignments

The Workstation Operator Assignments view object contains information about the operators assigned to do work in a specific shift of a workstation.

Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.OperatorAssignmentExtractPVO

Primary Keys : WsOperatorAssignmentId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
CreatedBy	User who created the workstation operator assignment record.
CreationDate	Date and time when the workstation operator assignment record was created.
LaborInstanceId	Value that uniquely identifies the labor resource instance.
LastUpdateDate	Date and time when the user last updated the workstation operator assignment record.
LastUpdateLogin	Session login associated with the user who last updated the workstation operator assignment record.
LastUpdatedBy	User who last updated the workstation operator assignment record.
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.
OrganizationId	Value that uniquely identifies the manufacturing plant to which this workstation operator assignment belongs.
PersonId	Value that uniquely identifies the operator who's assigned to a workstation.
ShiftDate	Date when the workstation operator assignment is made for a shift.
ShiftId	Value that uniquely identifies the shift in the workstation operator assignment.
WorkstationId	Value that uniquely identifies the workstation in the workstation operator assignment.
WsOperatorAssignmentId	Value that uniquely identifies the workstation operator assignment. This is the primary key of the Workstation Operator Assignments view object.