WorkCentersWorkCenterResource
Tracks resources allocated to work centers, supporting detailed resource planning and allocation.
Columns
Name | Type | Description |
WorkCentersWorkCenterId [KEY] | Long | The unique identifier that links the work center resource to its associated work center. This identifier ensures that all resources are properly mapped to the correct work center for accurate resource management and production planning. |
ResourceId [KEY] | Long | The primary key that uniquely identifies the work center resource. This system-generated key ensures that each resource is distinct and traceable within the work center structure. |
ResourceName | String | The name assigned to the work center resource. This name provides a user-friendly label to help identify the resource in reports, configurations, and operational workflows. |
ResourceDescription | String | A detailed description of the work center resource, explaining its purpose, capabilities, or role within the production process. This description helps users understand how the resource contributes to operational workflows. |
ResourceCode | String | A short code or abbreviation assigned to the work center resource. This code simplifies referencing and managing resources in system interfaces and reports. |
ResourceType | String | Specifies the type of resource (for example, 'Labor,' 'Machine,' or 'Tool'). This categorization supports effective resource allocation, scheduling, and reporting based on resource roles. |
WorkCenterId [KEY] | Long | The unique identifier for the work center associated with the resource. This linkage ensures that resources are correctly aligned with the work centers they serve. |
ResourceQuantity | Decimal | The number of resources assigned to the work center. This field supports capacity planning by specifying how many of the resource type are available within the work center. |
Available24HoursFlag | Bool | Indicates whether the work center resource is available 24 hours a day. If the value is 'true', the resource is continuously available. If the value is 'false', the resource is available only during specific shifts assigned to the work center resource. This field is critical for shift-based resource scheduling and availability planning. |
CheckCtpFlag | Bool | Indicates whether the capacity of this work center resource is considered during Oracle Global Order Promising Cloud’s capable-to-promise (CTP) checks. If the value is 'true', the resource’s capacity is factored into CTP calculations. If the value is 'false', the resource’s capacity is excluded from these checks, enabling more flexible planning for non-critical resources. |
UtilizationPercentage | Decimal | The percentage of time that the resource is available to perform tasks relative to its total scheduled time. This metric helps measure resource availability and assists in capacity planning. |
EfficiencyPercentage | Decimal | The percentage of time that the work center resource requires to complete a task compared to the standard or expected time. This metric evaluates resource performance and productivity, enabling optimization of work center operations. |
ChangedDate | Date | The date when changes were last made to the work center resource’s configuration or attributes. This value ensures traceability and provides an audit trail for resource updates. |
Finder | String | A utility field that enables advanced search and filtering capabilities for work center resources. This field enhances usability by allowing users to locate specific resources quickly based on various attributes. |
SubinventoryName | String | The name of the subinventory associated with the work center resource. This name identifies where materials or components required by the resource are stored, supporting inventory integration and operational efficiency. |