QA_IP_ACTIONS_GT
This table contains the results of the decision point functions for the obr engine for inspection plan actions.
Details
-
Schema: FUSION
-
Object owner: QA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INSPECTION_PLAN_ID | NUMBER | 18 | Yes | Identifies the inspection plan identifier. | |
| MESSAGE_TEXT | VARCHAR2 | 2400 | User defined message text | ||
| ISSUE_SEVERITY | VARCHAR2 | 20 | Indicate the serverity of the issue to be created. | ||
| SAMPLE_ID | NUMBER | 18 | Yes | Identifies the sample identifier. | |
| IP_SPECIFICATION_ID | NUMBER | 18 | Yes | Identifies the inspection plan specification identifier. | |
| CHARACTERISTIC_ID | NUMBER | 18 | Yes | Identifies the characteristic identifier. | |
| TARGET_VALUE | VARCHAR2 | 80 | Indicates the target value for the characteristic. | ||
| MINIMUM_VALUE | VARCHAR2 | 80 | Indicates the minimum value for the characteristic. | ||
| MAXIMUM_VALUE | VARCHAR2 | 80 | Indicates the maximum value for the characteristic. | ||
| RESULT_VALUE | VARCHAR2 | 80 | Indicates the result value for the characteristic. | ||
| ACTION_TYPE | VARCHAR2 | 30 | Yes | Indicates the action type as derived by the obr engine. | |
| ISSUE_ID | NUMBER | 18 | Indicates the quality issue identifier created as a result of the obr engine. | ||
| MESSAGE_NAME | VARCHAR2 | 30 | Indicates the message name as derived by the obr engine. | ||
| TOKEN1_NAME | VARCHAR2 | 30 | Indicates the token name for the message. | ||
| TOKEN1_VALUE | VARCHAR2 | 240 | Indicates the token value for the message. | ||
| TOKEN2_NAME | VARCHAR2 | 30 | Indicates the token name for the message. | ||
| TOKEN2_VALUE | VARCHAR2 | 240 | Indicates the token value for the message. | ||
| TOKEN3_NAME | VARCHAR2 | 30 | Indicates the token name for the message. | ||
| TOKEN3_VALUE | VARCHAR2 | 240 | Indicates the token value for the message. | ||
| TOKEN4_NAME | VARCHAR2 | 30 | Indicates the token name for the message. | ||
| TOKEN4_VALUE | VARCHAR2 | 240 | Indicates the token value for the message. | ||
| TOKEN5_NAME | VARCHAR2 | 30 | Indicates the token name for the message. | ||
| TOKEN5_VALUE | VARCHAR2 | 240 | Indicates the token value for the message. | ||
| TOKEN6_NAME | VARCHAR2 | 30 | Indicates the token name for the message. | ||
| TOKEN6_VALUE | VARCHAR2 | 240 | Indicates the token value for the message. | ||
| TOKEN7_NAME | VARCHAR2 | 30 | Indicates the token name for the message. | ||
| TOKEN7_VALUE | VARCHAR2 | 240 | Indicates the token value for the message. | ||
| TOKEN8_NAME | VARCHAR2 | 30 | Indicates the token name for the message. | ||
| TOKEN8_VALUE | VARCHAR2 | 240 | Indicates the token value for the message. | ||
| TOKEN9_NAME | VARCHAR2 | 30 | Indicates the token name for the message. | ||
| TOKEN9_VALUE | VARCHAR2 | 240 | Indicates the token value for the message. | ||
| TOKEN10_NAME | VARCHAR2 | 30 | Indicates the token name for the message. | ||
| TOKEN10_VALUE | VARCHAR2 | 240 | Indicates the token value for the message. | ||
| EMAIL_ID | VARCHAR2 | 80 | Indicates the email address to which the email is to be sent as derived by the obr engine. | ||
| USER_NAME | VARCHAR2 | 100 | Indicates the user name to which the worklist notification is to be sent as derived by the obr engine. | ||
| USER_GUID | VARCHAR2 | 64 | Indicates the user guid to which the worklist notification is to be sent as derived by the obr engine. | ||
| MATERIAL_STATUS_LEVEL | VARCHAR2 | 32 | Refers to the level of the material status change. SUBINVENTORY ('Z' zone), LOCATOR ('L') , LOT ('O'), SERIAL ('S'). | ||
| STATUS_ID | NUMBER | 18 | Refers to material status id or work order status id. | ||
| WORK_ORDER_TYPE | VARCHAR2 | 30 | Indicates the type of this work order to be created. Values are contained within the ORA_WIE_WO_TYPE lookup if this work order is a manufacturing work order. If this is a maintenance work order, valid values are contained within the ORA_MNT_WO_TYPE lookup. | ||
| WORK_ORDER_SUB_TYPE | VARCHAR2 | 30 | The subtype to be used to create maintenance work order. Values are contained in the ORA_WIE_WO_SUB_TYPE lookup if this work order is a manufacturing work order. If this is a maintenance work order, valid values are contained within the ORA_MNT_WO_SUB_TYPE lookup. | ||
| WORK_DEFINITION_NAME_ID | NUMBER | 18 | The work definition name to be used to create maintenance work order. | ||
| WORK_ORDER_PRIORITY | NUMBER | The work order priority to be used to create maintenance work order. | |||
| MNT_CONDITION_CODE | VARCHAR2 | 30 | The condition code to be used to create maintenance work order. |