WIS_WD_OPERATION_RESOURCES
This table stores the resource requirements for a given operation in the work definition.
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIS_WD_OPERATION_RESOURCES_PK |
WD_OPERATION_RESOURCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WD_OPERATION_RESOURCE_ID | NUMBER | 18 | Yes | The unique identifier of a work definition operation resource. Its value is an application generated unique id. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that 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. | |
| RESOURCE_SEQ_NUMBER | NUMBER | Yes | Defines the actual sequence of the resource used in the 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. | ||
| ASSIGNED_UNITS | NUMBER | Yes | Indicates the number of resource instances assigned to this operation. | ||
| USAGE_RATE | NUMBER | Yes | The resource usage rate to yield one unit of product. | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Represents the unit of measure code of the resource usage rate. | |
| BASIS_TYPE | VARCHAR2 | 30 | Yes | Indicates whether the resource usage is fixed (i.e. usage per lot produced) or variable (i.e. usage per item produced). Valid values exist in the lookup with lookup type = EGP_BOM_BASIS_TYPE. | |
| SCHEDULE_TYPE | VARCHAR2 | 30 | Yes | Indicates if this resource is scheduled or not. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_SCHEDULE. | |
| PRINCIPAL_FLAG | VARCHAR2 | 1 | Yes | When two or more resources are running in parallel (i.e. simultaneous resources which have the same sequence number), one and only one of them must be marked as the principal/primary resource. Planning will identify bottlenecks if the principal resource is not available when checking for capacity. | |
| CHARGE_TYPE | VARCHAR2 | 30 | Indicates how the resource is charged during work execution. Valid values exist in the lookup with lookup type = ORA_WIS_CHARGE_TYPE. | ||
| RESOURCE_ACTIVITY_CODE | VARCHAR2 | 30 | Indicates the activity this production resource is going to perform at this operation. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_ACTIVITY. | ||
| INVERSE_USAGE_RATE | NUMBER | Indicates the inverse resource usage rate. | |||
| WD_OPERATION_ID | NUMBER | 18 | Yes | Represents the work definition operation identifier that is the foreign key to the WIS_WD_OPERATIONS_B table. | |
| WORK_CENTER_ID | NUMBER | 18 | Yes | Indicates the work center where this resource resides. | |
| RESOURCE_ID | NUMBER | 18 | Yes | Indicates the resource assigned to the operation. | |
| PROFILE_ID | NUMBER | 18 | Foreign key reference to HCM model profiles. | ||
| EQP_QUAL_PROFILE_ID | NUMBER | 18 | Foreign key reference to equipment qualification profiles. | ||
| DOCUMENT_ITEM_ID | NUMBER | 18 | Represents the unique identifier of the document item being associated to the resource instance that provides automation program information. Foreign key to EGP_SYSTEM_ITEMS_B table. | ||
| EQP_PARAMS_FILENAME | VARCHAR2 | 512 | Represents the name of the file used to define program parameters and their values for an automation equipment resource. | ||
| EQP_PARAMS_FILE_CONTENT | CLOB | Contains the program parameters and their values in csv format. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| WIS_WD_OPERATION_RESOURCES | wis_wd_operations_b | WD_OPERATION_ID |
| wis_wd_op_alt_resources | wis_wd_operation_resources | WD_OPERATION_RESOURCE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| WIS_WD_OPERATION_RESOURCES_N1 | Non Unique | Default | WORK_CENTER_ID, RESOURCE_ID |
| WIS_WD_OPERATION_RESOURCES_N2 | Non Unique | Default | PROFILE_ID |
| WIS_WD_OPERATION_RESOURCES_N3 | Non Unique | Default | EQP_QUAL_PROFILE_ID |
| WIS_WD_OPERATION_RESOURCES_N4 | Non Unique | Default | RESOURCE_ID, DOCUMENT_ITEM_ID |
| WIS_WD_OPERATION_RESOURCES_U1 | Unique | Default | WD_OPERATION_RESOURCE_ID |
| WIS_WD_OPERATION_RESOURCES_U2 | Unique | Default | WD_OPERATION_ID, RESOURCE_SEQ_NUMBER, RESOURCE_ID |