QA_IP_EVENTS
This table stores inspection events
Details
-
Schema: FUSION
-
Object owner: QA
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QA_IP_EVENTS_PK |
IP_EVENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| IP_EVENT_ID | NUMBER | 18 | Yes | Unique identifier for this inspection event. PK. | |
| WO_OPERATION_TRANSACTION_ID | NUMBER | 18 | The unique identifier of an operation transaction record. Foreign key to table WIE_OPERATION_TRANSACTIONS. | ||
| WO_EXECUTION_RUN_ID | NUMBER | 18 | The unique identifier of execution run record. Foreign key to table WIE_WO_EXECUTION_RUNS. | ||
| ASSET_ID | NUMBER | 18 | Value that uniquely identifies an asset. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TOTAL_SAMPLE_QUANTITY | NUMBER | Total amount of material required for testing in the inspection quantity unit of measure. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| EVENT_TYPE | VARCHAR2 | 20 | Indicate the inspection event is Manufacturing Operations, Receiving, or Standard alone. | ||
| INSPECTION_PLAN_ID | NUMBER | 18 | Reference to inspection plan that is used | ||
| INSPECTION_LEVEL_ID | NUMBER | 18 | Reference to inspection level that is used. | ||
| IP_CRITERIA_ID | NUMBER | 18 | Reference to inspection criteria | ||
| SOURCE_LINE_QTY | NUMBER | Total quantity on the source line: receiving transaction quantity or manufacturing operation completion quantity. | |||
| UOM_CODE | VARCHAR2 | 3 | Unit of measurement for the quantity of samples being inspected in this event. | ||
| QTY_REQUESTED | NUMBER | Requested inspection quantity from manufacturing or receiving. | |||
| SAMPLING_QTY | NUMBER | Quantity resulted from sampling plan to be inspected. | |||
| QTY_INSPECTED | NUMBER | Total quantity actually inspected in this event. | |||
| QTY_ACCEPTED | NUMBER | Total quantity actually accepted in this event. | |||
| QTY_REJECTED | NUMBER | Total quantity actually rejected in this event. | |||
| ORIGINAL_DISPOSITION | VARCHAR2 | 20 | Original disposition for the samples being inspected. | ||
| INSPECTION_STATUS | VARCHAR2 | 20 | Inspection status. Valid values include PENDING or COMPLETE. | ||
| INLINE_FLAG | VARCHAR2 | 1 | Contains one of the following values: Y or N. If Y, then the application collects results as part of a receipt or work order, and the application requires the transaction identifiers. If N, then the application collects results independent of the receipt or work order, and the application doesn't require the transaction identifiers. This attribute doesn't have a default value. | ||
| DRAFT_FLAG | VARCHAR2 | 1 | Value 'Y' or 'N'. A 'Y' value indicates that the inspection is in draft mode that the source transactions are yet be completed. A non-draft (value 'N') indicates that the related transaction is required. | ||
| INSPECTED_BY | VARCHAR2 | 64 | Identifier for the person who is actually conducting the inspection. | ||
| INSPECTION_DATE | TIMESTAMP | Indicating the Date that this inspection event is conducted. | |||
| DISPOSITION_DATE | TIMESTAMP | Indicating the date that disposition is made for this inspection event. | |||
| INVENTORY_ITEM_ID | NUMBER | 18 | Reference to the inventory item being inspected in this event. | ||
| ORGANIZATION_ID | NUMBER | 18 | Identifier for the Inventory Organization. | ||
| REVISION_ID | NUMBER | 18 | Revision identifier for the inspected material if the item is revision controlled. | ||
| ITEM_REVISION | VARCHAR2 | 18 | Identifies the item version for which the inspection is conducted. | ||
| CATEGORY_SET_ID | NUMBER | 18 | Reference to the catalogue of item being inspected. | ||
| CATEGORY_ID | NUMBER | 18 | Reference to the category of item being inspected. | ||
| WORK_ORDER_ID | NUMBER | 18 | Identifier for the work order for manufacturing inspections. | ||
| WO_OPERATION_ID | NUMBER | 18 | Identifier for the work order operation in manufacturing inspection. | ||
| OPERATION_SEQ_NUMBER | NUMBER | 9 | Sequence number for the work order operation in manufacturing inspection. | ||
| DISPATCH_STATUS | VARCHAR2 | 30 | Dispatch status for the work order operation. | ||
| WORK_CENTER_ID | NUMBER | 18 | Identifier for the work center for resource inspections. | ||
| WORK_AREA_ID | NUMBER | 18 | Identifier for the work area for resource inspections. | ||
| RESOURCE_ID | NUMBER | 18 | Identifier for the resource to be inspected. | ||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | Sub inventory where the inspected material is located. | ||
| LOCATOR_ID | NUMBER | 18 | Reference to the sub inventory locator of the material being inspected in this event. | ||
| LOT_NUMBER | VARCHAR2 | 80 | Lot number of the material being inspected in this event. | ||
| TRANSACTION_TYPE | VARCHAR2 | 25 | indicates receiving transaction type. | ||
| SOURCE_ORG_ID | NUMBER | 18 | Source organization if the receiving transaction type is transfer. | ||
| SUPPLIER_ID | NUMBER | 18 | Reference to the supplier of the material being inspected. | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Identifier for the supplier site. | ||
| CUSTOMER_ID | NUMBER | 18 | Reference to the customer of the material being inspected. | ||
| DOC_TYPE | VARCHAR2 | 50 | Document type for receiving inspection events | ||
| DOC_NUMBER | VARCHAR2 | 240 | Document number for receiving inspection events. | ||
| DOC_LINE_NUMBER | NUMBER | 9 | Document line number for receiving inspection events. | ||
| DOC_SCHEDULE_NUMBER | VARCHAR2 | 50 | Document schedule number for receiving inspection events. | ||
| DOC_LINE_NUM | VARCHAR2 | 100 | Document line number for receiving inspection events. | ||
| RECEIPT_NUM | VARCHAR2 | 30 | Receipt number that is inspected in this inspection event. | ||
| SHIPMENT_HEADER_ID | NUMBER | 18 | Reference to header of shipment for the material being inspected. | ||
| SHIPMENT_LINE_ID | NUMBER | 18 | Reference to shipment line item for the material being inspected. | ||
| SUPPLIER_LOT_NUM | VARCHAR2 | 80 | Reference to shipment lot number | ||
| INTERFACE_TRANSACTION_ID | NUMBER | 18 | Value that uniquely identifies the interface transaction when inspecting a receipt. This attribute references the RCV_TRANSACTIONS_INTERFACE table. | ||
| SAMPLE_SIZE_CODE | VARCHAR2 | 3 | Sample size code letter derived based on lot size. | ||
| ACCEPTANCE_NUMBER | NUMBER | Acceptance number derived based on sample size code letter and associated acceptable quality limits. | |||
| REJECTION_NUMBER | NUMBER | Rejection number derived based on sample size code letter and associated acceptable quality limits. | |||
| NON_CONFORMANCE_COUNT | NUMBER | Nonconformance number calculated based on sample inspection that determines lot acceptance. | |||
| EXECUTE_ACTION_RULES_FLAG | VARCHAR2 | 1 | Indicates whether action rules defined in plan are executed or not. Options are Y, N and Null (treated as No). Only applicable when using the Inspection Events REST resource. | ||
| E_SIGNATURE_STATUS | VARCHAR2 | 20 | Electronic signature approval status if inspection organization is Electronic signature and electronic record enabled. Values could be 'PENDING', 'SUBMITTED', 'APPROVED' and 'REJECTED'. A null value means it is not applicable. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QA_IP_EVENTS_N1 | Non Unique | Default | INSPECTION_DATE |
| QA_IP_EVENTS_N2 | Non Unique | Default | INVENTORY_ITEM_ID |
| QA_IP_EVENTS_N3 | Non Unique | Default | WORK_ORDER_ID |
| QA_IP_EVENTS_N4 | Non Unique | Default | RESOURCE_ID |
| QA_IP_EVENTS_PK | Unique | Default | IP_EVENT_ID |