MSC_PROCESS_EFFECTIVITY
This table stores links between the bill of material and routings and store effectivities for this process.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_PROCESS_EFFECTIVITY_PK |
PLAN_ID, PROCESS_SEQUENCE_ID, SIMULATION_SET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | This value indicates the plan identifier for the record. | |||
| SIMULATION_SET_ID | NUMBER | 18 | Yes | Simulation setid (this col is not collected). | ||
| PART_KEY1 | NUMBER | 18 | Source application instance identifier | |||
| PROCESS_SEQUENCE_ID | NUMBER | 18 | Yes | Process sequence identifier for the process effectivity. | ||
| ITEM_ID | NUMBER | 18 | Yes | Item identifier of the product/co-product | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | This column indicates the organization identifier. | ||
| EFFECTIVITY_DATE | DATE | Yes | Effectivity date of the process | |||
| DISABLE_DATE | DATE | Disable date of the process effectivity | ||||
| MINIMUM_QUANTITY | NUMBER | Minimum quantity for which the process can be used to produce the item, expressed in primary UOM | ||||
| MAXIMUM_QUANTITY | NUMBER | Maximum quantity for which the process can be used to produce the item, expressed in primary UOM | ||||
| PREFERENCE | NUMBER | This value indicates the preference of the process effectivity. | ||||
| ROUTING_SEQUENCE_ID | NUMBER | Routing sequence identifier from source application. | ||||
| BILL_SEQUENCE_ID | NUMBER | 18 | Bill of material unique identifier | |||
| SR_INSTANCE_ID | NUMBER | Yes | Source application instance identifier | Obsolete | ||
| TOTAL_PRODUCT_CYCLE_TIME | NUMBER | Total time that an assembly takes along the primary path in the operation network calculated by flow manufacturing | ||||
| ITEM_PROCESS_COST | NUMBER | Cost of alternate BOM and routing | ||||
| LINE_ID | NUMBER | 18 | This column indicates the manufacturing line identifier. | |||
| 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. | |||
| PRIMARY_LINE_FLAG | NUMBER | Flag indicating whether the line is used for lead time calculations | ||||
| PRODUCTION_LINE_RATE | NUMBER | Number of assemblies which run down the line per hour | ||||
| REFRESH_NUMBER | NUMBER | Refresh number populated by the collection program | ||||
| LOAD_DISTRIBUTION_PRIORITY | NUMBER | Load distribution priority specified for the process effectivity. | ||||
| RECIPE | VARCHAR2 | 240 | This value indicates the Recipe name for OPM. | |||
| NEW_PLAN_ID | NUMBER | 18 | Yes | Plan id of the copied plan(this column not collected) |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_PROCESS_EFFECTIVITY | msc_routings | PLAN_ID, ORGANIZATION_ID, ROUTING_SEQUENCE_ID, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 |
| MSC_PROCESS_EFFECTIVITY | msc_boms | PLAN_ID, ORGANIZATION_ID, BILL_SEQUENCE_ID, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_PROCESS_EFFECTIVITY_N1 | Non Unique | Default | PLAN_ID, ITEM_ID, ORGANIZATION_ID, SIMULATION_SET_ID |
| MSC_PROCESS_EFFECTIVITY_U1 | Unique | Default | PLAN_ID, PROCESS_SEQUENCE_ID, SIMULATION_SET_ID |
| MSC_PROCESS_EFFECTIVITY_U2 | Unique | Default | PLAN_ID, ORGANIZATION_ID, BILL_SEQUENCE_ID, ROUTING_SEQUENCE_ID, SIMULATION_SET_ID |