Work Definition Operation Resource

The Work Definition Operation Resource view object contains information about the resource requirements of an operation.

Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WDOperationResourceExtractPVO

Primary Keys : WdOperationResourceId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name Description
AssignedUnits Number of resource units required to perform the operation.
AttributeCategory Context name for the Work Definition Operation Resource descriptive flexfield.
AttributeChar1 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar10 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar11 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar12 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar13 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar14 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar15 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar16 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar17 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar18 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar19 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar2 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar20 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar3 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar4 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar5 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar6 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar7 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar8 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeChar9 Character segment for the Work Definition Operation Resource descriptive flexfield.
AttributeDate1 Date segment for the Work Definition Operation Resource descriptive flexfield.
AttributeDate2 Date segment for the Work Definition Operation Resource descriptive flexfield.
AttributeDate3 Date segment for the Work Definition Operation Resource descriptive flexfield.
AttributeDate4 Date segment for the Work Definition Operation Resource descriptive flexfield.
AttributeDate5 Date segment for the Work Definition Operation Resource descriptive flexfield.
AttributeNumber1 Number segment for the Work Definition Operation Resource descriptive flexfield.
AttributeNumber10 Number segment for the Work Definition Operation Resource descriptive flexfield.
AttributeNumber2 Number segment for the Work Definition Operation Resource descriptive flexfield.
AttributeNumber3 Number segment for the Work Definition Operation Resource descriptive flexfield.
AttributeNumber4 Number segment for the Work Definition Operation Resource descriptive flexfield.
AttributeNumber5 Number segment for the Work Definition Operation Resource descriptive flexfield.
AttributeNumber6 Number segment for the Work Definition Operation Resource descriptive flexfield.
AttributeNumber7 Number segment for the Work Definition Operation Resource descriptive flexfield.
AttributeNumber8 Number segment for the Work Definition Operation Resource descriptive flexfield.
AttributeNumber9 Number segment for the Work Definition Operation Resource descriptive flexfield.
AttributeTimestamp1 Date and Time segment for the Work Definition Operation Resource descriptive flexfield.
AttributeTimestamp2 Date and Time segment for the Work Definition Operation Resource descriptive flexfield.
AttributeTimestamp3 Date and Time segment for the Work Definition Operation Resource descriptive flexfield.
AttributeTimestamp4 Date and Time segment for the Work Definition Operation Resource descriptive flexfield.
AttributeTimestamp5 Date and Time segment for the Work Definition Operation Resource descriptive flexfield.
BasisType 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.
ChargeType Indicates if the resource is transacted automatically or manually. A list of accepted values is defined in the lookup type ORA_WIS_CHARGE_TYPE.
CreatedBy User who created the work definition operation resource record.
CreationDate Date and time when the work definition operation resource record was created.
DocumentItemId Value that uniquely identifies the document item that represents the name of the program file associated to the work definition operation resource.
EqpQualProfileId Value that uniquely identifies the equipment qualification profile. This is a foreign key to the Equipment Qualification Profile view object.
InverseUsageRate Inverse of the predefined usage rate that's required to produce one unit of the product.
LastUpdateDate Date and time when the user last updated the work definition operation resource record.
LastUpdateLogin Session login associated with the user who last updated the work definition operation resource record.
LastUpdatedBy User who last updated the work definition operation resource 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.
PrincipalFlag Indicates if this resource is the principal resource within a group of simultaneous resources, which share the same resource sequence number.
ProfileId 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.
ResourceActivityCode 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.
ResourceId Value that uniquely identifies the resource in the Work Definition Operation Resource view object. This is a foreign key to the Resource view object.
ResourceSeqNumber 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.
ScheduleType Indicates if this resource is automatically scheduled when a work order is created or rescheduled. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_SCHEDULE.
UomCode Unit of measure code of the resource usage.
UsageRate 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.
WdOperationId Value that uniquely identifies the work definition operation in the Work Definition Operation Resource view object. This is a foreign key to the Work Definition Operation view object.
WdOperationResourceId Value that uniquely identifies the work definition operation resource. This is the primary key of the Work Definition Operation Resource view object.
WorkCenterId Value that uniquely identifies the work center of an operation in the Work Definition Operation Resource view object. This is a foreign key to the Work Center view object.