SCH_REC_LINES_INT
This table stores the line information of a product recall notice which includes manufacturer part details such as part number, model or brand in the interface when the recall notice is populated using File Based Data Import. INTERFACE_LINE_ID is the unique system generated primary key of this table.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
SCH_REC_LINES_INT_PK |
INTERFACE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_LINE_ID | NUMBER | 18 | Yes | Recall Notice Line Interface unique identifier. | |
| INTERFACE_LINE_KEY | VARCHAR2 | 60 | Line record identifier, unique within LOAD_REQUEST_ID. Reserved for data uploaded through cloud interface only. | ||
| INTERFACE_HEADER_ID | NUMBER | 18 | Recall Notice Header Interface Unique identifier. This column is not used currently. | ||
| INTERFACE_HEADER_KEY | VARCHAR2 | 60 | Header record identifier, unique within LOAD_REQUEST_ID. Reserved for data uploaded through cloud interface only. | ||
| PRODUCT_TYPE | VARCHAR2 | 600 | A free text where the User can enter the type of the product as per the classification done by Regulatory Authority for the product being recalled. | ||
| ACTION | VARCHAR2 | 25 | Action can be either CREATE or UPDATE. | ||
| STATUS | VARCHAR2 | 80 | Indicates the status in which the recall notice has to be imported. If the recall notice has to be imported in review mode, the status has to be "NEW" where user can review and add more information before publishing it. If the recall notice has to be imported in published mode where all required information are provided, the status has to be "OPEN". This column is not used currently. | ||
| NDC_CODE | VARCHAR2 | 60 | National Drug Code for the recalled part. | ||
| MANUFACTURER_PART_NUMBER | VARCHAR2 | 700 | Trading partner item number with relationship type as Manufacturer. | ||
| MANUFACTURER_PART_ID | NUMBER | 18 | Trading partner item unique identifier with relationship type as Manufacturer or master item unique identifier which does not have any manufacturer item relationship. This column is not used currently. | ||
| ITEM_NUMBER | VARCHAR2 | 1200 | Internal Item Number defined and related to Manufacturer Part Number. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | INVENTORY_ITEM_ID is Master Item unique identifier. This column is not used currently. | ||
| ITEM_CATEGORY | VARCHAR2 | 250 | Category Code assigned to the master item for the Inventory functional area. This column is not used currently. | ||
| ITEM_CATEGORY_ID | NUMBER | 18 | ITEM_CATEGORY_ID is a Master Item number. This column is not used currently. | ||
| ITEM_VALIDATION_ORG_CODE | VARCHAR2 | 60 | Item Validation Organization Code. This column is not used currently. | ||
| ITEM_VALIDATION_ORG_ID | NUMBER | 18 | Item Validation Organization unique identifier. This column is not used currently. | ||
| BRAND_NAME | VARCHAR2 | 60 | Free text where the user can enter the brand name for the recalled product. | ||
| MODEL_NAME | VARCHAR2 | 60 | Free text where the user can enter the model name for the recalled product. | ||
| RECALL_QTY | NUMBER | Free text where the user can enter the recall quantity stated by the source of recall. This column is not used currently. | |||
| RECALL_UOM | VARCHAR2 | 120 | Free text where the user can enter the unit of measure stated by the source of recall. This column is not used currently. | ||
| RECALL_CLASSIFICATION_TYPE | VARCHAR2 | 80 | Indicates the classification of recall notice based on severity of the impact it has on consumers. These values are retrieved from the seeded lookup types. This column is not used currently. | ||
| REPLACEMENT_TYPE | VARCHAR2 | 80 | Indicates the method by which the recalled parts can be disposed off. These values are retrieved from the seeded lookup types. This column is not used currently. | ||
| RECALL_CLOSING_DATE | TIMESTAMP | Expected Recall notice closing date. This column is not used currently. | |||
| LINE_NUMBER | NUMBER | 18 | Recall Notice Line Number entered by the user. | ||
| LINE_ID | NUMBER | 18 | Recall Notice Line unique identifier. This column is not used currently. | ||
| HEADER_ID | NUMBER | 18 | Recall Notice Header unique identifier. This column is not used currently. | ||
| RECALL_LINE_STATUS | VARCHAR2 | 80 | Indicates the status of recall notice line. This column is not used currently. | ||
| RECALL_TRACK_START_DATE | DATE | Date from which the transactions for the recalled product has to be tracked to identify the traceability status and the location where it resides. This column is not used currently. | |||
| RECALL_TRACK_END_DATE | DATE | Date till which the transactions for the recalled product has to be tracked to identify the traceability status and the location where it resides. This column is not used currently. | |||
| 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. | ||
| 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_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. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Attribute indicating the request id associated with the data load process. | ||
| 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. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | 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_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE10 | 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. | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| SCH_REC_LINES_INT | sch_rec_headers_int | INTERFACE_HEADER_ID |
| sch_rec_lots_int | sch_rec_lines_int | INTERFACE_LINE_ID |
| sch_rec_serials_int | sch_rec_lines_int | INTERFACE_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SCH_REC_LINES_INT_N1 | Non Unique | Default | INTERFACE_HEADER_ID |
| SCH_REC_LINES_INT_U1 | Unique | Default | INTERFACE_LINE_ID |