MSC_OPERATION_RESOURCES
This table stores operation resources from a resource sequence. For each resource sequence, we have an alternative between different set of operation resources. This is described by the Alternate Number. Resources with the same Alternate Number are simultaneous. Different Alternate Number represent alternatives between group of resources.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_OPERATION_RESOURCES_PK |
PLAN_ID, ORGANIZATION_ID, ROUTING_SEQUENCE_ID, OPERATION_SEQUENCE_ID, RESOURCE_SEQ_NUM, RESOURCE_ID, ALTERNATE_NUMBER, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | This value indicates the plan identifier for the record. | ||
| WD_OP_ALT_RESOURCE_ID | NUMBER | Source side value of the work definition operation alternate resource identifier. | |||
| PRIMARY_RESOURCE_ID | NUMBER | 18 | primary resource id for the alternate resource | ||
| DEPARTMENT_ID | NUMBER | 18 | Department identifier in which the operation takes place (Denormailsed) | ||
| ROUTING_SEQUENCE_ID | NUMBER | Yes | Routing sequence identifier from source application instance | ||
| OPERATION_SEQUENCE_ID | NUMBER | Yes | Operation sequence identifier | ||
| RESOURCE_SEQ_NUM | NUMBER | Yes | This value indicates the Resource sequence number. | ||
| RESOURCE_ID | NUMBER | 18 | Yes | This value indicates the Resource identifier. | |
| ALTERNATE_NUMBER | NUMBER | Yes | Represents the priority of the alternate resource.For primary resource it will be 0. | ||
| PRINCIPAL_FLAG | NUMBER | Yes | Flag to indicate whether the resource is the principal resource | ||
| BASIS_TYPE | NUMBER | Yes | Item(1), lot(2), resource units(3), resource value(4), total value(5), activity(6). | ||
| RESOURCE_USAGE | NUMBER | Yes | Alternate resource volume necessary for this operation resource | ||
| MAX_RESOURCE_UNITS | NUMBER | Maximum number of resource units consumed by this operation resource | |||
| RESOURCE_UNITS | NUMBER | Operation resource units (capacity). This can be fixed by the user and used as constraint | |||
| UOM_CODE | VARCHAR2 | 3 | Yes | Unit of measure code of the operation resource. | |
| PART_KEY1 | NUMBER | 18 | Yes | Source application instance identifier | |
| REFRESH_NUMBER | NUMBER | Refresh number populated by the collection program | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| RESOURCE_TYPE | NUMBER | This value indicates the Resource type. | |||
| ORGANIZATION_ID | NUMBER | 18 | Yes | Organization Identifier | |
| SETUP_ID | NUMBER | 18 | Setup type to be used for this resource. | ||
| MINIMUM_CAPACITY | NUMBER | This value indicates minimum capacity for the operation resource. | |||
| MAXIMUM_CAPACITY | NUMBER | Maximum Capacity of the Batchable resource | |||
| ORIG_RESOURCE_SEQ_NUM | NUMBER | 18 | Resource Seq Number in source instance | ||
| BREAKABLE_ACTIVITY_FLAG | NUMBER | 1= Activity is breakable, 2 Activity is non breakable | |||
| NEW_PLAN_ID | NUMBER | 18 | Yes | NEW_PLAN_ID | |
| SIMULATION_SET_ID | NUMBER | 18 | Yes | Simulation set to which the current record is added. | |
| SCHEDULE_FLAG | NUMBER | Schedule flag on the resource. If this is set then the resource is used in planning. | |||
| RESOURCE_OFFSET_PERCENT | NUMBER | This value indicates the RESOURCE_OFFSET_PERCENT. | |||
| NEW_PLAN_LIST | VARCHAR2 | 256 | List indicates the new plan identifiers for the record. | ||
| APPLIED | NUMBER | Flag used for online replanning | |||
| 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. | |
| ASSEMBLY_ITEM_ID | NUMBER | 18 | Item identifier of the assembly. | ||
| SIM_EDIT_FLAGS | NUMBER | Indicates which columns are edited in simulation set records |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_OPERATION_RESOURCES | msc_operation_resource_seqs | PLAN_ID, ORGANIZATION_ID, ROUTING_SEQUENCE_ID, OPERATION_SEQUENCE_ID, RESOURCE_SEQ_NUM, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_OPERATION_RESOURCES_U1 | Unique | Default | PLAN_ID, ORGANIZATION_ID, ROUTING_SEQUENCE_ID, OPERATION_SEQUENCE_ID, RESOURCE_SEQ_NUM, RESOURCE_ID, ALTERNATE_NUMBER, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 |