CST_WORK_DEFINITIONS
This table contains the work definitions that are associated with the cost planning scenario.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_WORK_DEFINITIONS_PK |
CST_WORK_DEFINITION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_WORK_DEFINITION_ID | NUMBER | 18 | Yes | Surrogate key and unique identifier for costing work definition snapshot. | |
| SCENARIO_ID | NUMBER | 18 | Indicates the scenario identifier based on which the request to create the snapshot for the item is created from. | ||
| WORK_DEFINITION_ITEM_ID | NUMBER | 18 | Surrogate key and unique identifier for costing work definition items for which snapshot is to be created. | ||
| WORK_DEFINITION_VERSION_ID | NUMBER | 18 | Identifies the fusion manufacturing work definition version identifier from which the work definition snapshot is created. | ||
| WORK_DEFINITION_ID | NUMBER | 18 | Yes | Identifies the fusion manufacturing work definition identifier from which the work definition snapshot is created. | |
| VERSION_NUMBER | VARCHAR2 | 10 | Yes | Indicates the work definition version number based on which the work definition snapshot is created. | |
| BILL_SEQUENCE_ID | NUMBER | 18 | Identifies the bill of material information for the standard item when it is based on an item structure instead of a work definition. | ||
| WD_EFFECTIVE_FROM_DATE | TIMESTAMP | Yes | Indicates the date from which the work definition for which the snapshot is being created is effective. | ||
| WD_EFFECTIVE_TO_DATE | TIMESTAMP | Indicates the date till which the work definition for which the snapshot is being created is effective. | |||
| COSTING_BATCH_OUTPUT_SIZE | NUMBER | Indicates the costing batch output size for work definition for which the snapshot is created. | |||
| WORK_DEFINITION_TYPE | VARCHAR2 | 30 | Yes | Indicates the type of work definition for which the snapshot is being created for. | |
| WORK_DEFINITION_NAME_ID | NUMBER | 18 | Yes | Indicates the name of the work definition for which the snapshot is being created for. | |
| PRODUCTION_PRIORITY | NUMBER | Indicates the production priority of the work definition snapshot. | |||
| COSTING_PRIORITY | NUMBER | Indicates the costing priority of the work definition snapshot. | |||
| ORGANIZATION_ID | NUMBER | 18 | Yes | Indicates the plant under which the work definition snapshot is created. | |
| WORK_METHOD_ID | NUMBER | 18 | Yes | Indicates the work method identifier of the work definition snapshot. | |
| WORK_METHOD_CODE | VARCHAR2 | 30 | Yes | Indicates the work method code of the work definition snapshot. | |
| OUTPUT_INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Indicates the primary output item of the work definition snapshot. | |
| OUTPUT_INVENTORY_ORG_ID | NUMBER | 18 | Yes | Indicates the organization identifier of the primary output item of the work definition snapshot. | |
| CST_OPERATION_ID | NUMBER | 18 | Yes | Indicates the Fusion costing operation identifier and is used to model the BOM structure of all assemblies in the snapshot as it uniquely identifies an operation for every assembly structure. | |
| WD_OPERATION_ID | NUMBER | 18 | Yes | Indicates the Fusion manufacturing operation identifier as stored in WIS_WD_OPERATIONS_VL. For CTO snapshot data, this identifier can be shared across different assemblies and therefore should only be used to reference the data stored in WIS_WD_OPERATIONS_VL. | |
| OPERATION_SEQ_NUMBER | NUMBER | 9 | Yes | Indicates the sequence of the operation in the work definition snapshot. | |
| OPERATION_TYPE | VARCHAR2 | 30 | Indicates the type of operation. Valid options are: (1) In-House (2) Supplier. | ||
| OSP_ITEM_ID | NUMBER | 18 | Identifies the outside processing item reference associated with the operation. | ||
| SUPPLIER_ID | NUMBER | 18 | Identifies the supplier reference of the outside processing operation. | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Identifies the supplier site reference of the outside processing operation. | ||
| WORK_CENTER_ID | NUMBER | 18 | Indicates the work center identifier for the resource under the work definition operation. | ||
| WORK_CENTER_CODE | VARCHAR2 | 30 | Indicates the work center code for the resource under the work definition operation. | ||
| WORK_AREA_ID | NUMBER | 18 | Indicates the work area identifier for the resource under the work definition operation. | ||
| WORK_AREA_CODE | VARCHAR2 | 30 | Indicates the work area code for the resource under the work definition operation. | ||
| OP_EFFECTIVE_FROM_DATE | TIMESTAMP | Yes | Indicates the date from which the work definition operation is effective. | ||
| OP_EFFECTIVE_TO_DATE | TIMESTAMP | Indicates the date till which the work definition operation is effective. | |||
| WD_OPERATION_RESOURCE_ID | NUMBER | 18 | Indicates the fusion manufacturing operation resource identifier based on which the operation resource snapshot is created for work definitions. | ||
| RESOURCE_SEQ_NUMBER | NUMBER | Indicates the resource sequence for the resource under the work definition operation. | |||
| RESOURCE_ASSIGNED_UNITS | NUMBER | Indicates the number of assigned units of the resource for the operation sequence. | |||
| RESOURCE_USAGE_RATE | NUMBER | Indicates the resource usage rate for the resource under the work definition operation. | |||
| RESOURCE_UOM_CODE | VARCHAR2 | 3 | Indicates the unit of measure of the resource usage rate. | ||
| RESOURCE_PRIMARY_UOM_CODE | VARCHAR2 | 3 | Indicates the primary UOM of the resource. | ||
| RESOURCE_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor between the resource's usage UOM to its primary UOM. | |||
| RESOURCE_BASIS_TYPE | VARCHAR2 | 30 | Indicates the basis type for the resource usage rate. Fixed rate means that the resource is used once as per the resource usage rate for the entire batch. Variable rate means that for each item produced, the resource is used as per the resource usage rate specified. | ||
| RESOURCE_ACTIVITY_CODE | VARCHAR2 | 30 | Indicates the activity this resource is going to perform in this operation. Values are contained within the WIS_RESOURCE_ACTIVITY lookup. | ||
| RESOURCE_ID | NUMBER | 18 | Indicates the resource used for the work definition operation. | ||
| RESOURCE_COSTED_FLAG | VARCHAR2 | 1 | Indicates whether the resource is to be costed as part of the cost rollup process or not. | ||
| RESOURCE_SCALED_USAGE_RATE | NUMBER | Indicates the resource usage rate scaled for the work definition based on costing output batch size and resource basis type. | |||
| WD_OPERATION_MATERIAL_ID | NUMBER | 18 | Indicates the fusion manufacturing operation material identifier based on which the work definition operation material snapshot is created. | ||
| MATERIAL_TYPE | VARCHAR2 | 30 | Indicates the type of material, whether it is input or output. | ||
| MATERIAL_QUANTITY | NUMBER | Indicates the quantity of material used for the work definition operation. | |||
| MATERIAL_UOM_CODE | VARCHAR2 | 3 | Indicates the unit of measure of the material used for the work definition operation. | ||
| MATERIAL_PRIMARY_UOM_CODE | VARCHAR2 | 3 | Indicates the primary UOM of the item. | ||
| MATERIAL_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor between the input component's usage UOM to its primary UOM. | |||
| MATERIAL_BASIS_TYPE | VARCHAR2 | 30 | Indicates whether the item quantity is fixed (e.g., quantity per lot produced) or variable (e.g., quantity per item produced). | ||
| MATERIAL_YIELD_FACTOR | NUMBER | Indicates the percentage of material quantity incorporated into the finished good. | |||
| MATERIAL_INVENTORY_ITEM_ID | NUMBER | 18 | Indicates the material identifier of the material used in the work definition operation. | ||
| MATERIAL_INVENTORY_ORG_ID | NUMBER | 18 | Indicates the organization in which the material is defined. | ||
| ORIG_MAT_INV_ORG_ID | NUMBER | 18 | Indicates original inventory organization defined for the material on the work definition. | ||
| ALLOCATION_PERCENT | NUMBER | Percent of supply allocated to this source. | |||
| SOURCE_TYPE | NUMBER | 1 | Indicates the source type: 1 - Transfer from, 2 - Make at, 3 - Buy from. Lookup type is MSC_SOURCING_SOURCE_TYPE. | ||
| MATERIAL_SUPPLY_TYPE | VARCHAR2 | 30 | Indicates the supply type of the item. Used for identifying an item as supplier sources or phantom. | ||
| CST_MSC_SRC_RULE_ID | NUMBER | 18 | Costing identifier for sourcing rule. | ||
| MATERIAL_SCALED_QUANTITY | NUMBER | Indicates the scaled quantity of the material for the work definition based on component yield factor, costing output batch size and material basis type. | |||
| WD_CRITERION_DETAIL_ID | NUMBER | 18 | Indicates the criterion details from the scenario reference based on which the snapshot request is required. | ||
| SCENARIO_EVENT_ID | NUMBER | 18 | Indicates the scenario event identifier based on which the request to create the snapshot for the item is created from. | ||
| STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the explosion / snapshot process for the work definition. | ||
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Indicates the scenario rollup header identifier created using the costing work definition record for either material or resource. | ||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| BATCH_QUANTITY | NUMBER | Represents the quantity produced for the work definition. In process manufacturing, this is the batch quantity. | |||
| BATCH_UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the batch quantity. | ||
| BATCH_PRIMARY_UOM_CODE | VARCHAR2 | 3 | Represents the primary unit of measure code of the batch quantity. | ||
| BATCH_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor between the batch UOM to its primary UOM. | |||
| OPERATION_OUTPUT_ITEM_ID | NUMBER | 18 | Indicates the operation output item of the work definition snapshot. | ||
| OPERATION_OUTPUT_ORG_ID | NUMBER | 18 | Indicates the organization identifier of the operation output item of the work definition snapshot. | ||
| MATERIAL_SEQ_NUMBER | NUMBER | Indicates the material sequence number of the material consumed in the operation performed. | |||
| ELEVATED_FROM_PHANTOM_FLAG | VARCHAR2 | 1 | Indicates whether this component is elevated from phantom to parent level. Possible values are Y and null. | ||
| ELEVATED_FROM_PHANTOM_CWD_ID | NUMBER | 18 | Indicates the source costing work definition identifier for the elevated phantom record. | ||
| COMPONENT_SEQUENCE_ID | NUMBER | 18 | Sequence id of the Component Item. This is the ID column of the table EGP_COMPONENTS_B | ||
| FIND_NUMBER | NUMBER | Unique number to identify a material used multiple times in the same level of the item structure. | |||
| WIS_MATERIAL_SEQ_NUMBER | NUMBER | Indicates the material sequence number of the material consumed in the operation performed. | |||
| OP_YIELD_FACTOR | NUMBER | Indicates the yield factor for the operation. Default value is 1 (100%). Used by Cost Rollup process for yield calculations. | |||
| OP_CUM_YIELD_FACTOR | NUMBER | Indicates the cumulative yield factor for the operation. Default value is 1 (100%). | |||
| OP_REV_YIELD_FACTOR | NUMBER | Indicates the reverse cumulative yield factor for the operation. Default value is 1 (100%). |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_WORK_DEFINITIONS | cst_scenarios | SCENARIO_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_WORK_DEFINITIONS_N1 | Non Unique | FUSION_TS_TX_DATA | SCENARIO_ID, OUTPUT_INVENTORY_ITEM_ID |
| CST_WORK_DEFINITIONS_N2 | Non Unique | FUSION_TS_TX_DATA | SCENARIO_ID, CST_OPERATION_ID |
| CST_WORK_DEFINITIONS_N3 | Non Unique | FUSION_TS_TX_DATA | SCENARIO_ID, RESOURCE_ID |
| CST_WORK_DEFINITIONS_N4 | Non Unique | FUSION_TS_TX_DATA | SCENARIO_ID, MATERIAL_INVENTORY_ITEM_ID |
| CST_WORK_DEFINITIONS_N5 | Non Unique | FUSION_TS_TX_DATA | WORK_DEFINITION_ITEM_ID |
| CST_WORK_DEFINITIONS_N6 | Non Unique | Default | CST_OPERATION_ID |
| CST_WORK_DEFINITIONS_N7 | Non Unique | Default | WORK_DEFINITION_ID, WORK_DEFINITION_VERSION_ID |
| CST_WORK_DEFINITIONS_PK | Unique | FUSION_TS_TX_DATA | CST_WORK_DEFINITION_ID |