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. |