Standard Operation Resource
The Standard Operation Resource view object contains information about the resource requirements for a given standard operation.
Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.StdOperationResourceExtractPVO
Primary Keys : StdOperationResourceId
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 instances of the resource assigned to this standard operation. |
| AttributeCategory | Context name for the Standard Operation Resources descriptive flexfield. |
| AttributeChar1 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar10 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar11 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar12 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar13 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar14 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar15 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar16 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar17 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar18 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar19 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar2 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar20 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar3 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar4 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar5 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar6 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar7 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar8 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeChar9 | Character segment for the Standard Operation Resources descriptive flexfield. |
| AttributeDate1 | Date segment for the Standard Operation Resources descriptive flexfield. |
| AttributeDate2 | Date segment for the Standard Operation Resources descriptive flexfield. |
| AttributeDate3 | Date segment for the Standard Operation Resources descriptive flexfield. |
| AttributeDate4 | Date segment for the Standard Operation Resources descriptive flexfield. |
| AttributeDate5 | Date segment for the Standard Operation Resources descriptive flexfield. |
| AttributeNumber1 | Number segment for the Standard Operation Resources descriptive flexfield. |
| AttributeNumber10 | Number segment for the Standard Operation Resources descriptive flexfield. |
| AttributeNumber2 | Number segment for the Standard Operation Resources descriptive flexfield. |
| AttributeNumber3 | Number segment for the Standard Operation Resources descriptive flexfield. |
| AttributeNumber4 | Number segment for the Standard Operation Resources descriptive flexfield. |
| AttributeNumber5 | Number segment for the Standard Operation Resources descriptive flexfield. |
| AttributeNumber6 | Number segment for the Standard Operation Resources descriptive flexfield. |
| AttributeNumber7 | Number segment for the Standard Operation Resources descriptive flexfield. |
| AttributeNumber8 | Number segment for the Standard Operation Resources descriptive flexfield. |
| AttributeNumber9 | Number segment for the Standard Operation Resources descriptive flexfield. |
| AttributeTimestamp1 | Date and Time segment for the Standard Operation Resources descriptive flexfield. |
| AttributeTimestamp2 | Date and Time segment for the Standard Operation Resources descriptive flexfield. |
| AttributeTimestamp3 | Date and Time segment for the Standard Operation Resources descriptive flexfield. |
| AttributeTimestamp4 | Date and Time segment for the Standard Operation Resources descriptive flexfield. |
| AttributeTimestamp5 | Date and Time segment for the Standard Operation Resources 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 standard operation resource record. |
| CreationDate | Date when the standard operation resource record was created. |
| 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 resource usage rate that's required to produce one unit of the product. |
| LastUpdateDate | Date and time when the user last updated the standard operation resource record. |
| LastUpdateLogin | Session login associated with the user who last updated the standard operation resource record. |
| LastUpdatedBy | User who last updated the standard 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. |
| 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. This is a foreign key to the Resource view object. |
| ResourceSeqNumber | Sequence of the resource used in the standard operation. Multiple resources can be scheduled to be working concurrently within the same operation. Simultaneity is implemented by having more than one resource with the same sequence number. |
| ScheduleType | Indicates if this resource is scheduled. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_SCHEDULE. |
| StandardOperationId | Value that uniquely identifies the standard operation. This is a foreign key to the Standard Operation view object. |
| StdOperationResourceId | Value that uniquely identifies the standard operation resource. This is the primary key of the Standard Operation Resource view object. |
| UomCode | Unit of measure code of the resource usage rate. |
| UsageRate | Predefined usage rate of the resource to produce one unit of a product in discrete manufacturing, or process a standard batch quantity in process manufacturing. |
| WorkCenterId | Value that uniquely identifies the work center. This is a foreign key to the Work Center view object. |