Workstation Status Histories
The Workstation Status Histories view object gives the current condition or state of a workstation in the production facility.
Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WorkstationStatusHistoryExtractPVO
Primary Keys : WorkstationStatusPEOWsStatusHistoryId
Initial Extract Date : WorkstationStatusPEOCreationDate
Incremental Extract Date : WorkstationStatusPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| EquipmentInstancesPEOAssetId | Value that uniquely identifies the asset number. This is a foreign key to the Asset view object. |
| EquipmentInstancesPEOAttributeCategory | Context name for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar1 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar10 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar11 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar12 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar13 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar14 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar15 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar16 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar17 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar18 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar19 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar2 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar20 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar3 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar4 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar5 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar6 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar7 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar8 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeChar9 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeDate1 | Date segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeDate2 | Date segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeDate3 | Date segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeDate4 | Date segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeDate5 | Date segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeNumber1 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeNumber10 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeNumber2 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeNumber3 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeNumber4 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeNumber5 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeNumber6 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeNumber7 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeNumber8 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeNumber9 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeTimestamp1 | Date and Time segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeTimestamp2 | Date and Time segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeTimestamp3 | Date and Time segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeTimestamp4 | Date and Time segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOAttributeTimestamp5 | Date and Time segment for the Equipment Resource Instance descriptive flexfield. |
| EquipmentInstancesPEOCreatedBy | User who created the equipment resource instance record. |
| EquipmentInstancesPEOCreationDate | Date and time when the equipment resource instance record was created. |
| EquipmentInstancesPEOEquipmentInstanceCode | Code used to identify the equipment resource instance. This code uniquely identifies the equipment resource instance within a manufacturing plant. |
| EquipmentInstancesPEOEquipmentInstanceId | Value that uniquely identifies the equipment resource instance. This is a primary key that the application generates when it creates a equipment resource instance. |
| EquipmentInstancesPEOEquipmentInstanceName | Name of the equipment resource instance. |
| EquipmentInstancesPEOInactiveDate | Date when the equipment resource instance becomes inactive. |
| EquipmentInstancesPEOIotSyncStatus | Column that tracks the status of the data synchronization of the equipment resource instance record with IoT Production Monitoring Cloud. A list of valid values are defined in the lookup type ORA_WIE_IOT_SYNC_STATUS. |
| EquipmentInstancesPEOLastUpdateDate | Date and time when the user most recently updated the equipment resource instance record. |
| EquipmentInstancesPEOLastUpdateLogin | Session login associated with the user who most recently updated the equipment resource instance record. |
| EquipmentInstancesPEOLastUpdatedBy | User who most recently updated the equipment resource instance record. |
| EquipmentInstancesPEOObjectVersionNumber | 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. |
| EquipmentInstancesPEOOrganizationId | Value that uniquely identifies the manufacturing plant to which this equipment resource instance belongs. |
| EquipmentInstancesPEOResourceId | Value that uniquely identifies the resource in the equipment resource instance. This is a foreign key to the Resource view object. |
| EquipmentInstancesPEOWorkCenterId | Value that uniquely identifies the work center in the equipment resource instance. This is a foreign key to the Work Center view object. |
| WSEquipmentInstancesPEOCreatedBy | User who created the workstation equipment instance record. |
| WSEquipmentInstancesPEOCreationDate | Date and time when the user created the workstation equipment instance record. |
| WSEquipmentInstancesPEOEquipmentInstanceId | Value that uniquely identifies the equipment resource instance. This is a primary key that the application generates when it creates a equipment resource instance. |
| WSEquipmentInstancesPEOLastUpdateDate | Date and time when the user most recently updated the workstation record. |
| WSEquipmentInstancesPEOLastUpdateLogin | Session login associated with the user who most recently updated the workstation record. |
| WSEquipmentInstancesPEOLastUpdatedBy | User who most recently updated the workstation record. |
| WSEquipmentInstancesPEOObjectVersionNumber | 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. |
| WSEquipmentInstancesPEOWorkstationId | Value that uniquely identifies the workstation for which workstation statuses are being displayed. |
| WSEquipmentInstancesPEOWsEquipmentInstanceId | Unique identifier for the workstation equipment instance association. |
| WorkstationPEOAttributeCategory | Context name for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar1 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar10 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar11 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar12 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar13 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar14 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar15 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar16 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar17 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar18 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar19 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar2 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar20 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar3 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar4 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar5 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar6 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar7 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar8 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeChar9 | Character segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeDate1 | Date segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeDate2 | Date segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeDate3 | Date segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeDate4 | Date segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeDate5 | Date segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeNumber1 | Number segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeNumber10 | Number segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeNumber2 | Number segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeNumber3 | Number segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeNumber4 | Number segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeNumber5 | Number segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeNumber6 | Number segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeNumber7 | Number segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeNumber8 | Number segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeNumber9 | Number segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeTimestamp1 | Date and Time segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeTimestamp2 | Date and Time segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeTimestamp3 | Date and Time segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeTimestamp4 | Date and Time segment for the workstation descriptive flexfield. |
| WorkstationPEOAttributeTimestamp5 | Date and Time segment for the workstation descriptive flexfield. |
| WorkstationPEOCreatedBy | User who created the workstation record. |
| WorkstationPEOCreationDate | Date and time when the user created the workstation record. |
| WorkstationPEOLastUpdateDate | Date and time when the user most recently updated the workstation record. |
| WorkstationPEOLastUpdateLogin | Session login associated with the user who most recently updated the workstation record. |
| WorkstationPEOLastUpdatedBy | User who last updated the workstation record. |
| WorkstationPEOObjectVersionNumber | 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. |
| WorkstationPEOOrganizationId | Value that uniquely identifies the manufacturing plant organization in which the workstation is located. It's a foreign key to the manufacturing plant identifier. |
| WorkstationPEOWorkCenterId | Value that uniquely identifies the parent work center. It's a primary key that the application generates when it creates a work center. |
| WorkstationPEOWorkstationCode | Abbreviation that identifies the parent work center. |
| WorkstationPEOWorkstationId | Value that uniquely identifies the workstation. It's a primary key that the application generates when it creates a workstation. |
| WorkstationStatusPEOCreatedBy | User who created the workstation status history record. |
| WorkstationStatusPEOCreationDate | Date and time when the user created the workstation status history record. |
| WorkstationStatusPEOEndDateDerived | End date of the status change. |
| WorkstationStatusPEOEndTime | End time of the status change. |
| WorkstationStatusPEOLastUpdateDate | Date and time when the user most recently updated the workstation status history record. |
| WorkstationStatusPEOLastUpdateLogin | Session login associated with the user who most recently updated the workstation status history record. |
| WorkstationStatusPEOLastUpdatedBy | User who most recently updated the workstation status history record. |
| WorkstationStatusPEOObjectVersionNumber | 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. |
| WorkstationStatusPEOOrganizationId | Value that uniquely identifies the manufacturing plant organization in which the workstation is located. It's a foreign key to the manufacturing plant identifier. |
| WorkstationStatusPEOPersonId | Name of the person who logged into the workstation. |
| WorkstationStatusPEOStartDateDerived | Start date of the status change. |
| WorkstationStatusPEOStartTime | Start time of the status change. |
| WorkstationStatusPEOWorkstationId | Value that uniquely identifies the workstation for which workstation statuses are being displayed. |
| WorkstationStatusPEOWorkstationStatusCode | Abbreviation that identifies the workstation status code. |
| WorkstationStatusPEOWsStatusHistoryId | Value that uniquely identifies the workstation status history change. |