Equipment Resource Instance
The Equipment Resource Instance view object contains information about the instances of a resource of equipment type. Such instances are optionally associated with the assets defined in Maintenance Management.
Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.EquipmentInstanceExtractPVO
Primary Keys : EquipmentInstanceId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AssetId | Value that uniquely identifies the maintenance asset in the equipment resource instance. This is a foreign key to the Asset view object |
| AttributeCategory | Context name for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar1 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar10 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar11 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar12 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar13 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar14 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar15 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar16 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar17 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar18 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar19 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar2 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar20 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar3 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar4 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar5 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar6 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar7 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar8 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeChar9 | Character segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeDate1 | Date segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeDate2 | Date segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeDate3 | Date segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeDate4 | Date segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeDate5 | Date segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeNumber1 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeNumber10 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeNumber2 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeNumber3 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeNumber4 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeNumber5 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeNumber6 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeNumber7 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeNumber8 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeNumber9 | Number segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeTimestamp1 | Date and Time segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeTimestamp2 | Date and Time segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeTimestamp3 | Date and Time segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeTimestamp4 | Date and Time segment for the Equipment Resource Instance descriptive flexfield. |
| AttributeTimestamp5 | Date and Time segment for the Equipment Resource Instance descriptive flexfield. |
| CreatedBy | User who created the equipment resource instance record. |
| CreationDate | Date and time when the equipment resource instance record was created. |
| EquipmentInstanceCode | Code used to identify the equipment resource instance. This code uniquely identifies the equipment resource instance within a manufacturing plant. |
| EquipmentInstanceId | Value that uniquely identifies the equipment resource instance. This is a primary key that the application generates when it creates a equipment resource instance. |
| EquipmentInstanceName | Name of the equipment resource instance. |
| InactiveDate | Date when the equipment resource instance becomes inactive. |
| IotSyncStatus | Column which 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. |
| LastUpdateDate | Date and time when the user last updated the equipment resource instance record. |
| LastUpdateLogin | Session login associated with the user who last updated the equipment resource instance record. |
| LastUpdatedBy | User who last updated the equipment resource instance 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 equipment resource instance belongs. |
| ResourceId | Value that uniquely identifies the resource in the equipment resource instance. This is a foreign key to the Resource view object. |
| WorkCenterId | Value that uniquely identifies the work center in the equipment resource instance. This is a foreign key to the Work Center view object. |