Work Order Operation Resource
The Work Order Operation Resource view object contains information about the resource requirements of an operation in a work order.
Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOOperationResourceExtractPVO
Primary Keys : WOOpResourcePEOWoOperationResourceId
Initial Extract Date : WOOpResourcePEOCreationDate
Incremental Extract Date : WOOpResourcePEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| EqpQualProfileId | Value that uniquely identifies the equipment qualification profile. This is a foreign key to the Equipment Qualification Profile view object. |
| WOOpMntCompleteFlag | Indicates whether the resource has completed the maintenance work order operation. Contains one of the following values: Y or N. Applicable only for labor resources. |
| WOOpResourcePEOActualResourceUsage | Net actual usage of the resource to perform the operation. |
| WOOpResourcePEOAssignedUnits | Number of resource units required to perform the operation. |
| WOOpResourcePEOAttributeCategory | Context name for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar1 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar10 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar11 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar12 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar13 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar14 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar15 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar16 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar17 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar18 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar19 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar2 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar20 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar3 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar4 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar5 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar6 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar7 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar8 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeChar9 | Character segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeDate1 | Date segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeDate2 | Date segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeDate3 | Date segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeDate4 | Date segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeDate5 | Date segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeNumber1 | Number segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeNumber10 | Number segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeNumber2 | Number segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeNumber3 | Number segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeNumber4 | Number segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeNumber5 | Number segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeNumber6 | Number segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeNumber7 | Number segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeNumber8 | Number segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeNumber9 | Number segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeTimestamp1 | Date and Time segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeTimestamp2 | Date and Time segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeTimestamp3 | Date and Time segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeTimestamp4 | Date and Time segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOAttributeTimestamp5 | Date and Time segment for the Work Order Operation Resource descriptive flexfield. |
| WOOpResourcePEOBasisType | Indicates if the resource usage is dependent on quantity of product produced. A list of accepted values is defined in the lookup type EGP_BOM_BASIS_TYPE. |
| WOOpResourcePEOChargeType | Indicates if the resource is transacted automatically or manually. A list of accepted values is defined in the lookup type ORA_WIS_CHARGE_TYPE. |
| WOOpResourcePEOCreatedBy | User who created the work order operation resource record. |
| WOOpResourcePEOCreationDate | Date and time when the work order operation resource record was created. |
| WOOpResourcePEOInverseRequiredUsage | Inverse of the predefined usage rate that's required to produce one unit of the product. |
| WOOpResourcePEOJobDefinitionName | Indicates the name of the job that created or last updated the work order operation resource record. This is populated through Enterprise Service Scheduler. |
| WOOpResourcePEOJobDefinitionPackage | Indicates the package name of the job that created or last updated the work order operation resource record. This is populated through Enterprise Service Scheduler. |
| WOOpResourcePEOLastUpdateDate | Date and time when the user last updated the work order operation resource record. |
| WOOpResourcePEOLastUpdateLogin | Session login associated with the user who last updated the work order operation resource record. |
| WOOpResourcePEOLastUpdatedBy | User who last updated the work order operation resource record. |
| WOOpResourcePEOObjectVersionNumber | 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. |
| WOOpResourcePEOOrganizationId | Value that uniquely identifies the manufacturing plant to which this work order operation resource belongs. |
| WOOpResourcePEOPhantomFlag | Indicates if the resource was inherited to the operation as part of explosion of a phantom item. |
| WOOpResourcePEOPlannedCompletionDate | Planned date and time of the resource to complete the work in this operation. The scheduling application generally sets this date. |
| WOOpResourcePEOPlannedStartDate | Planned date and time of the resource to start the work in this operation. The scheduling application generally sets this date. |
| WOOpResourcePEOPrincipalFlag | Indicates if this resource is the principal resource within a group of simultaneous resources, which share the same resource sequence number. |
| WOOpResourcePEOProfileId | Value that identifies a set of qualifications that are required for a job. When a job profile is specified for an operation resource, then only resources that meet the qualifications can perform the operation. |
| WOOpResourcePEORequestId | Indicates the request ID of the job that created or last updated work order operation resource record. This is populated through Enterprise Service Scheduler. |
| WOOpResourcePEORequiredUsage | Resource usage that the plant requires to make the work order quantity. The application calculates this value depending on whether the basis type is fixed or variable. If the value is Fixed, the required usage equals the usage rate. Else, if the value is Variable, the required usage equals the usage rate multiplied by the work order quantity. |
| WOOpResourcePEOResourceActivityCode | Activity used to represent any intra operation steps or any other custom run steps to track at the resource level. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_ACTIVITY. |
| WOOpResourcePEOResourceId | Value that uniquely identifies the resource in the Work Order Operation Resource view object. This is the foreign key to the Resource view object. |
| WOOpResourcePEOResourceSeqNumber | Sequence of the resource used in the operation. It determines whether resources are scheduled to work concurrently or sequentially. Resources with the same sequence number are scheduled to work concurrently. |
| WOOpResourcePEOScheduledFlag | Indicates if this resource is automatically scheduled when the work order is created or rescheduled. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_SCHEDULE. |
| WOOpResourcePEOUomCode | Unit of measure code of the resource usage. |
| WOOpResourcePEOUsageRate | Predefined resource usage rate that's required to produce one unit of the product in discrete manufacturing, or a standard batch quantity in process manufacturing. |
| WOOpResourcePEOWdOperationResourceId | Value that uniquely identifies the work definition operation resource in the Work Order Operation Resource view object. This is a foreign key to the Work Definition Operation Resource view object. |
| WOOpResourcePEOWoOperationId | Value that uniquely identifies the operation in the Work Order Operation Resource view object. This is a foreign key to the Work Order Operation view object. |
| WOOpResourcePEOWoOperationResourceId | Value that uniquely identifies the work order operation resource. This is the primary key of the Work Order Operation Resource view object. |
| WOOpResourcePEOWorkCenterId | Value that uniquely identifies the work center of an operation in the Work Order Operation Resource view object. This is a foreign key to the Work Center view object. |