MSC_ROUTING_OPERATIONS
This tables stores the operations composing each routing.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_ROUTING_OPERATIONS_PK |
PLAN_ID, ORGANIZATION_ID, ROUTING_SEQUENCE_ID, OPERATION_SEQUENCE_ID, 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. | ||
| OPERATION_SEQUENCE_ID | NUMBER | 18 | Yes | Reference to the operation to which this routing is assigned. | |
| ROUTING_SEQUENCE_ID | NUMBER | Yes | Routing sequence identifier for the routing/work definition. | ||
| OPERATION_SEQ_NUM | NUMBER | 18 | Yes | Operation sequence number of the operation associated with the routing. | |
| PART_KEY1 | NUMBER | 18 | Yes | Source application instance identifier | |
| OPERATION_DESCRIPTION | VARCHAR2 | 960 | Operation description (use for UI and reports) | ||
| EFFECTIVITY_DATE | DATE | Yes | Indicate the date from when this operation is effective | ||
| DISABLE_DATE | DATE | Date indicating End of effectivity | |||
| FROM_UNIT_NUMBER | VARCHAR2 | 30 | Effective from this unit number | ||
| TO_UNIT_NUMBER | VARCHAR2 | 30 | Effective up to this unit number | ||
| OPTION_DEPENDENT_FLAG | NUMBER | Yes | Flag to indicate whether this operation option dependent | ||
| OPERATION_TYPE | NUMBER | Indicate operation type: Process, Line, or Event. Events are not used here | |||
| MINIMUM_TRANSFER_QUANTITY | NUMBER | Minimum operation transfer quantity | |||
| YIELD | NUMBER | Process yield at this operation | |||
| DEPARTMENT_ID | NUMBER | 18 | Yes | Department identifier (source application identifier) in which the operation takes place | |
| DEPARTMENT_CODE | VARCHAR2 | 120 | Department code (for reporting) | ||
| OPERATION_LEAD_TIME_PERCENT | NUMBER | Indicates the amount of overlape its lead time has with the parent lead time | |||
| CUMULATIVE_YIELD | NUMBER | Cummulative process yield from the beginning of routing to this operation | |||
| REVERSE_CUMULATIVE_YIELD | NUMBER | Cummulative process yield from the end of routing to comparable operation | |||
| NET_PLANNING_PERCENT | NUMBER | Cummulative planning percents derived from the operation network | |||
| SETUP_DURATION | NUMBER | Duration of the set-up for the routing/work definition operation. | |||
| TEAR_DOWN_DURATION | NUMBER | Duration of the tear down for this operation | |||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure code of the routing operation. | ||
| STANDARD_OPERATION_CODE | VARCHAR2 | 4 | Code of the standard operation on which this operation is based. Operations having the same code are identical | ||
| 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. | ||
| USE_IN_PLAN | NUMBER | This column is used for Routing Effectivity Timestamp | |||
| ORGANIZATION_ID | NUMBER | 18 | Yes | This column indicates the organization identifier. | |
| STEP_QUANTITY | NUMBER | Quantity associated with an operation. Populated for opm jobs | |||
| STEP_QUANTITY_UOM | VARCHAR2 | 3 | Unit of measure of the step quantity of the routing or work definition operation. | ||
| NEW_PLAN_ID | NUMBER | 18 | Yes | This indicates the new plan identifier if the base plan exists for this record. | |
| SIMULATION_SET_ID | NUMBER | 18 | Yes | Simulation set to which the current record is added. | |
| 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. | ||
| SUPPLIER_ID | NUMBER | 18 | This value indicates the Supplier identifier in the planning system. | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Supplier Site ID for OSP operation | ||
| FIXED_LEAD_TIME | NUMBER | Represents the fixed lead time used to calculate the operations start and end date for the supplier operation. | |||
| VARIABLE_LEAD_TIME | NUMBER | Variable lead time used in conjunction with the quantity of the assembly being manufactured. | |||
| OPERATION_COST | NUMBER | This value indicates OSP Operation Cost. | |||
| OSP_OPERATION_TYPE | NUMBER | Indicate operation type: InHouse(1) or Supplier(2) | |||
| SIM_EDIT_FLAGS | NUMBER | Indicates which columns are edited in simulation set records |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_ROUTING_OPERATIONS | msc_routings | PLAN_ID, ORGANIZATION_ID, ROUTING_SEQUENCE_ID, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 |
| msc_operation_resource_seqs | msc_routing_operations | PLAN_ID, ORGANIZATION_ID, ROUTING_SEQUENCE_ID, OPERATION_SEQUENCE_ID, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_ROUTING_OPERATIONS_N1 | Non Unique | Default | PLAN_ID, OPERATION_SEQUENCE_ID |
| MSC_ROUTING_OPERATIONS_N2 | Non Unique | Default | PLAN_ID, ROUTING_SEQUENCE_ID, OPERATION_SEQ_NUM |
| MSC_ROUTING_OPERATIONS_U1 | Unique | Default | PLAN_ID, ORGANIZATION_ID, ROUTING_SEQUENCE_ID, OPERATION_SEQUENCE_ID, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 |
| MSC_ROUTING_OPERATIONS_U2 | Unique | Default | PLAN_ID, ORGANIZATION_ID, ROUTING_SEQUENCE_ID, OPERATION_SEQ_NUM, EFFECTIVITY_DATE, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 |