Workstation Check in Activities

The Workstation Check in Activities view object maintains check in and checkout details for workstations in a manufacturing organization including the utilization of workstations by recording the time when users check in to start using a workstation and when they checkout after completing their work.

Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WorkstationCheckinActivityExtractPVO

Primary Keys : WsCheckinActivityId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name Description
CheckinTime Value that identifies the time when an operator checked in.
CheckoutTime Value that identifies the time when an operator checked out.
CreatedBy User who created the workstation check in activity record.
CreationDate Date and time when the user created the workstation check in activity record.
LaborInstanceId Value that uniquely identifies the labor instance. It's a foreign key to the labor instance record.
LastUpdateDate Date and time when the user most recently updated the workstation check in activity record.
LastUpdateLogin Session login associated with the user who most recently updated the workstation check in activity record.
LastUpdatedBy User who most recently updated the workstation check in activity 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 organization in which the workstation activities are being tracked. It's a foreign key to the manufacturing plant identifier.
PersonId Value that uniquely identifies the person checked into the workstation.
WorkstationId Value that uniquely identifies the workstation in which an operator has checked in. It's a foreign key to the workstation identifier.
WsCheckinActivityId Value that uniquely identifies the check in activity of an operator at a workstation.