MSC_ST_ROUTING_OPERATIONS
The staging table used by the collection program to validate and process data for table MSC_ROUTING_OPERATIONS.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OPERATION_SEQUENCE_ID | NUMBER | Reference to the operation to which this routing is assigned. | |||
| ROUTING_SEQUENCE_ID | NUMBER | Routing sequence identifier for the routing/work definition. | |||
| OPERATION_SEQ_NUM | NUMBER | Operation sequence number of the operation associated with the routing. | |||
| OPERATION_DESCRIPTION | VARCHAR2 | 960 | This column indicates the description of the routing operation. | ||
| EFFECTIVITY_DATE | DATE | Indicate the date from when this operation is effective | |||
| DISABLE_DATE | DATE | Effective end date of the work definition operation. | |||
| 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 | Flag to indicate whether this operation option dependent | |||
| OPERATION_TYPE | NUMBER | Indicate operation type: Process, Line, or Event. | |||
| MINIMUM_TRANSFER_QUANTITY | NUMBER | Minimum operation transfer quantity | |||
| YIELD | NUMBER | Process yield at this operation | |||
| DEPARTMENT_ID | NUMBER | Department identifier or the work centre of the resource. | |||
| DEPARTMENT_CODE | VARCHAR2 | 120 | Department code or the work centre of the resource. | ||
| 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 | |||
| TEAR_DOWN_DURATION | NUMBER | Duration of the tear down for this operation | |||
| SETUP_DURATION | NUMBER | Duration of the set-up for the routing/work definition operation. | |||
| UOM_CODE | VARCHAR2 | 50 | Unit of measure code of the routing operation. | ||
| STANDARD_OPERATION_CODE | VARCHAR2 | 4 | Code of the standard operation on which this operation is based | ||
| ORGANIZATION_ID | NUMBER | This column indicates the organization identifier. | |||
| DELETED_FLAG | NUMBER | Yes/No flag indicates whether corresponding record in ODS will be deleted | |||
| 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. | ||
| SR_INSTANCE_ID | NUMBER | Source application instance identifier | |||
| REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection progam | |||
| COMPANY_ID | NUMBER | Unique id assigned to the company | |||
| COMPANY_NAME | VARCHAR2 | 255 | Party name with which the company is registered. | ||
| ROUTING_NAME | VARCHAR2 | 250 | Name of the routing or a work definition. | ||
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | 30 | Name of the alternate routing. Null for primary routing | ||
| ORGANIZATION_CODE | VARCHAR2 | 18 | This column indicates the organization code. | ||
| ASSEMBLY_NAME | VARCHAR2 | 300 | Assembly Name. This has to be provided for uploads from legacy | ||
| SR_INSTANCE_CODE | VARCHAR2 | 30 | Source Instance code from which data is being populated. | ||
| OPERATION_SEQ_CODE | VARCHAR2 | 10 | This value indicates Operation Sequence Code. | ||
| PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed | |||
| DATA_SOURCE_TYPE | VARCHAR2 | 15 | Source Type indicating the source of the records | ||
| ERROR_TEXT | VARCHAR2 | 2000 | This will describe the reason for the error if any. | ||
| MESSAGE_ID | NUMBER | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML | |||
| ST_TRANSACTION_ID | NUMBER | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | |||
| BATCH_ID | NUMBER | Batch identifier generated during pre-processing | |||
| SOURCE_ORGANIZATION_ID | NUMBER | This is the Organization ID for the Organization in the legacy(source) system.This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | |||
| SOURCE_OPERATION_SEQUENCE_ID | NUMBER | This is the Operation Sequence ID for the Operation Sequence in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | |||
| SOURCE_OPERATION_SEQ_NUM | NUMBER | This is the Operation Sequence Numberfor the Operation Sequence in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | |||
| SOURCE_DEPARTMENT_ID | NUMBER | This is the Department ID for the Department in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | |||
| STEP_QUANTITY | NUMBER | Step quantity associated with an operation. Populated for opm | |||
| STEP_QUANTITY_UOM | VARCHAR2 | 3 | Unit of measure of the step quantity of the routing or work definition operation. | ||
| OSP_OPERATION_TYPE | NUMBER | Indicate operation type: InHouse(1) or Supplier(2) | |||
| OSP_ITEM_NAME | VARCHAR2 | 300 | Name of OSP Item for the OSP Operation | ||
| OSP_ITEM_ID | NUMBER | Inventory item identifier of the Outside processing item. | |||
| SUPPLIER_NAME | VARCHAR2 | 360 | Name of supplier for OSP operation | ||
| SUPPLIER_ID | NUMBER | 18 | This value indicates the Supplier identifier in the planning system. | ||
| SUPPLIER_SITE_CODE | VARCHAR2 | 240 | Supplier site code for OSP operation | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Supplier Site ID for OSP Operation | ||
| OPERATION_COST | NUMBER | This value indicates OSP Operation cost. | |||
| 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. | |||
| RETRY_COUNT | NUMBER | Number of retries to process failed records. | |||
| ERROR_CODE | VARCHAR2 | 150 | Error code for functional validation errors in the record | ||
| LOAD_REQUEST_ID | NUMBER | It Stores the Request ID of Job that loaded the data. |