Work Center Resource
The Work Center Resources view object contains information about the resources assigned to perform work in the work center.
Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WorkCenterResourceExtractPVO
Primary Keys : ResourceId, WorkCenterId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AttributeCategory | Context name for the Work Center Resource descriptive flexfield. |
| AttributeChar1 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar10 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar11 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar12 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar13 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar14 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar15 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar16 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar17 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar18 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar19 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar2 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar20 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar3 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar4 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar5 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar6 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar7 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar8 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeChar9 | Character segment for the Work Center Resource descriptive flexfield. |
| AttributeDate1 | Date segment for the Work Center Resource descriptive flexfield. |
| AttributeDate2 | Date segment for the Work Center Resource descriptive flexfield. |
| AttributeDate3 | Date segment for the Work Center Resource descriptive flexfield. |
| AttributeDate4 | Date segment for the Work Center Resource descriptive flexfield. |
| AttributeDate5 | Date segment for the Work Center Resource descriptive flexfield. |
| AttributeNumber1 | Number segment for the Work Center Resource descriptive flexfield. |
| AttributeNumber10 | Number segment for the Work Center Resource descriptive flexfield. |
| AttributeNumber2 | Number segment for the Work Center Resource descriptive flexfield. |
| AttributeNumber3 | Number segment for the Work Center Resource descriptive flexfield. |
| AttributeNumber4 | Number segment for the Work Center Resource descriptive flexfield. |
| AttributeNumber5 | Number segment for the Work Center Resource descriptive flexfield. |
| AttributeNumber6 | Number segment for the Work Center Resource descriptive flexfield. |
| AttributeNumber7 | Number segment for the Work Center Resource descriptive flexfield. |
| AttributeNumber8 | Number segment for the Work Center Resource descriptive flexfield. |
| AttributeNumber9 | Number segment for the Work Center Resource descriptive flexfield. |
| AttributeTimestamp1 | Date and Time segment for the Work Center Resource descriptive flexfield. |
| AttributeTimestamp2 | Date and Time segment for the Work Center Resource descriptive flexfield. |
| AttributeTimestamp3 | Date and Time segment for the Work Center Resource descriptive flexfield. |
| AttributeTimestamp4 | Date and Time segment for the Work Center Resource descriptive flexfield. |
| AttributeTimestamp5 | Date and Time segment for the Work Center Resource descriptive flexfield. |
| Available24HoursFlag | Indicates if the work center resource is available 24 hours in a day or only during the shifts assigned. |
| CheckCtpFlag | Indicates if Oracle Global Order Promising Cloud performs capable-to-promise check based on the work center resource capacity. |
| CreatedBy | User who created the work center resource record. |
| CreationDate | Date and time when the work center resource record was created. |
| EfficiencyPercentage | Percent of time that the work center resource requires to finish the task. This percentage is used by the scheduler to calculate the available hours for the work center resource during work order scheduling and lead time calculations. |
| LastUpdateDate | Date and time when the user last updated the work center resource record. |
| LastUpdateLogin | Session login associated with the user who last updated the work center resource record. |
| LastUpdatedBy | User who last updated the work center 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. |
| ResourceId | Value that uniquely identifies the resource in the work center resource. This is a foreign key of the Resource view object. This attribute is a part of the composite key of the Work Center Resource view object. |
| ResourceQuantity | Number of units of this resource available at the work center. |
| UtilizationPercentage | Percent of time that's available to perform the task. This percentage is used by the scheduler to calculate the available hours for the work center resource during work order scheduling and lead time calculations. |
| WorkCenterId | Value that uniquely identifies the work center in the work center resource. This is a foreign key of the Work Center view object. This attribute is a part of the composite key of the Work Center Resource view object. |