MSS_ROUTINGS

This table stores routing template information. Data in this table is a snapshot of data from WIS_WORK_DEFINITIONS and MSC_ROUTINGS.

Details

• Schema: FUSION

• Object owner: MSS

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MSS_ROUTINGS_PK	PLAN_ID, ROUTING_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PLAN_ID	NUMBER		18	Yes	Identifier of the Production Scheduling plan.
ROUTING_ID	NUMBER		18	Yes	Work definition ID. This is a indirect foreign key to the WIS_WORK_DEFINITIONS table, and reference to MSC_ROUTINGS.ROUTING_SEQUENCE_ID.
ROUTING_CODE	VARCHAR2	300		Yes	Indicates user defined routing code.
ROUTING_TYPE	VARCHAR2	30		Yes	Indicates the type of this routing: Production|Maintenance|EAM.
WORK_METHOD_ID	NUMBER		18		Represents the work method identifier for this routing. The work method indicates the type of work being executed within the Fusion Manufacturing application. Required in the source schema.
WORK_METHOD_CODE	VARCHAR2	30			A code that represents the user key to the work method. Required in the source schema.
WORK_METHOD_NAME	VARCHAR2	120			Indicates the name of the work method. Required in the source schema.
WORK_ORDER_ONLY	VARCHAR2	1			Use this routing for work order only (Y/N)?
WORK_ORDER_UNIT_OF_EFFORT	VARCHAR2	1			Schedule work orders according to their unit of effort (minimum transfer quantity) (Y/N)?
ADJACENT_OPS_PREFERRED	VARCHAR2	1			Adjacent operations preferred when scheduling with minimum transfer quantity (Y/N)?
MINIMUM_TRANSFER_QUANTITY	NUMBER				The minimum quantity that must be completed from the prior operation or work order before the next operation or work order is allowed to start.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
mss_op_temporal_relations	mss_routings	PLAN_ID, ROUTING_ID
mss_operations	mss_routings	PLAN_ID, ROUTING_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MSS_ROUTINGS_U1	Unique	Default	PLAN_ID, ROUTING_ID
MSS_ROUTINGS_U2	Unique	Default	PLAN_ID, ROUTING_CODE