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