MSC_API_WD_OP_RESOURCES
This table is used to populate work definition operation resources staging table
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_API_WD_OP_RESOURCES_PK |
WD_OPERATION_ID, WORK_CENTER_ID, RESOURCE_ID, RESOURCE_SEQ_NUMBER, CONFIG_ITEM_ID, ORGANIZATION_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| WD_OPERATION_RESOURCE_ID | VARCHAR2 | 20 | Yes | Work definition operation resource identifier specified for the routing. |
| WD_OP_ALT_RESOURCE_ID | NUMBER | Work definition operation alt resource identifier specified for the routing. | ||
| PRIMARY_RESOURCE_ID | NUMBER | Indicates the primary resource id for an alt res | ||
| PRIORITY_RANKING | NUMBER | Indicates the ranking of the alternate resource | ||
| WD_OPERATION_ID | NUMBER | Yes | Work definition operation identifier specified for the routing. | |
| RESOURCE_ID | NUMBER | Yes | This value indicates the RESOURCE_ID. | |
| OPERATION_SEQ_NUMBER | NUMBER | Yes | OPERATION_SEQ_NUMBER | |
| RESOURCE_SEQ_NUMBER | NUMBER | Yes | This value indicates the RESOURCE_SEQ_NUMBER. | |
| RESOURCE_NAME | VARCHAR2 | 80 | Yes | This value indicates the RESOURCE_NAME. |
| PRIMARY_RESOURCE_CODE | VARCHAR2 | 80 | it represents the primary resource code incase of alternate res. | |
| RESOURCE_DESCRIPTION | VARCHAR2 | 240 | This value indicates the description of the resource. | |
| UOM_CODE | VARCHAR2 | 3 | Unit of measure code of the wd operation resource. | |
| USAGE_RATE | NUMBER | Work definition operation resource usage quantity. | ||
| INVERSE_USAGE_RATE | NUMBER | Indicates the inverse resource usage rate for the resource under the work definition operation. | ||
| BASIS_TYPE | VARCHAR2 | 30 | Indicates the usage of this resource i.e whether the resource usage is fixed (e.g., usage per lot produced) or variable (e.g., usage per item produced) | |
| REQUIRED_RESOURCE_USAGE | NUMBER | This value indicates the required resource usage for the resource attached to work definition. | ||
| ASSIGNED_UNITS | NUMBER | Yes | Number of resource units assigned to perform the operation. | |
| RESOURCE_ACTIVITY_CODE | VARCHAR2 | 30 | Work definition operation resource activity code. | |
| SCHEDULE_TYPE | VARCHAR2 | 30 | Yes | Schedule type of the work definition operation resource. |
| CHARGE_TYPE | VARCHAR2 | 30 | Indicates how the resource is charged during work execution | |
| PRINCIPAL_FLAG | VARCHAR2 | 1 | Yes | This flag indicates whether the resource is setup as principal. |
| LEVEL_NUMBER | NUMBER | LEVEL_NUMBER | ||
| WORK_CENTER_ID | NUMBER | Yes | Work centre identifier assigned to the work definition operation. | |
| PHANTOM_FLAG | VARCHAR2 | 1 | Phantom flag of the work definition operation resource. | |
| CONFIG_ITEM_ID | NUMBER | Yes | Unique identifier of the configured item | |
| ORGANIZATION_ID | NUMBER | Yes | ORGANIZATION_ID | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_API_WD_OP_RESOURCES_U1 | Unique | Default | WD_OPERATION_ID, WORK_CENTER_ID, RESOURCE_ID, RESOURCE_SEQ_NUMBER, CONFIG_ITEM_ID, ORGANIZATION_ID |