SCH_REC_HEADERS_INT
This table stores the header information of a product recall notice in the interface when the recall notice is populated using File Based Data Import. A recall notice is created at business unit level. It captures the details of the source who initiated the recall, the source recall document reference, initiation date and the classification of recall notice based on nature of the recall reason and the severity of the impact and the replacement method to dispose the recalled parts. Interface_Header_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_HEADERS_INT_PK |
INTERFACE_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_HEADER_ID | NUMBER | 18 | Yes | Recall Notice Header Interface Unique identifier. | |
| INTERFACE_HEADER_KEY | VARCHAR2 | 60 | Header record identifier, unique within LOAD_REQUEST_ID. Reserved for data uploaded through cloud interface only. | ||
| ACTION | VARCHAR2 | 25 | Action can be either CREATE or UPDATE. | ||
| STATUS | VARCHAR2 | 80 | Indicates the status of recall notice. If the recall notice has to be imported in published mode, the status should be specified as Open else should be New. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Business Unit unique identifier in which the recall notice is created. This column is not used currently. | ||
| BUSINESS_UNIT_NAME | VARCHAR2 | 240 | Name of the Business Unit in which the recall notice is created. | ||
| RECALL_REFERENCE_NUMBER | VARCHAR2 | 60 | Recall reference number provided by the source who initiated the recall. | ||
| RECALL_INITIATION_DATE | TIMESTAMP | Date on which recall notice is initiated by the source. | |||
| RECALL_CLOSING_DATE | TIMESTAMP | Indicates the expected closure date of recall notice provided by the initiator. | |||
| RECALL_SOURCE_TYPE | VARCHAR2 | 80 | Indicates the different types of source who initiated the recall such as Manufacturer, Regulatory Authority etc. | ||
| RECALL_SOURCE_ID | NUMBER | 18 | Recall source unique identifier. This column is not used currently. | ||
| RECALL_SOURCE_NAME | VARCHAR2 | 360 | Name of the Recall Source which includes Supplier name and Regulatory Authority name. | ||
| RECALL_REASON | VARCHAR2 | 2000 | Free text where the user can enter details about the recall reasons. | ||
| MANUFACTURER_NAME | VARCHAR2 | 700 | Name of the Trading Partner of type MANUFACTURER. | ||
| MANUFACTURER_NUMBER | VARCHAR2 | 30 | Party number of the Trading Partner of type MANUFACTURER. | ||
| MANUFACTURER_URL | VARCHAR2 | 2000 | Free text where the user can enter the manufacturing firms URL. | ||
| RECALL_NOTICE_TYPE | VARCHAR2 | 80 | Indicates the classification of recall notice with values retrieved from the seeded lookups. | ||
| 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 lookups. | ||
| POTENTIAL_RISK | VARCHAR2 | 2000 | Free text where user can provide the details about the risk factors of the recalled product. | ||
| REPLACEMENT_TYPE | VARCHAR2 | 80 | Indicates the method by which the recalled parts can be disposed off. These values are retrieved from the seeded lookups. | ||
| RECALL_INSTRUCTION | VARCHAR2 | 2000 | Free text where user can provide some special instructions against replacement type. It is mandatory for Correction replacement type. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| 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. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Attribute indicating the request id associated with the data load process. | ||
| BATCH_ID | NUMBER | The unique identifier of the Batch/Group to be imported together. | |||
| HEADER_ID | NUMBER | 18 | Recall Notice Header Unique identifier. This column is not used currently. | ||
| RECALL_NOTICE_NUM | VARCHAR2 | 240 | Recall Notice number used for internal tracking within the enterprise which gets generated based on document sequencing setup. | ||
| RECALL_TRACK_START_DATE | DATE | Indicates the start date provided by initiator of the recall notice. Receipts performed from this date onwards will be considered as recall when manufacturer lot or serial information does not exist in recall notice. | |||
| RECALL_TRACK_END_DATE | DATE | Indicates the end date provided by initiator of the recall notice. Receipts performed till this date will be considered as recall when manufacturer lot or serial information does not exist in recall notice. | |||
| 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. | ||
| 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_import_errors | sch_rec_headers_int | INTERFACE_HEADER_ID |
| sch_rec_lines_int | sch_rec_headers_int | INTERFACE_HEADER_ID |
| sch_rec_contacts_int | sch_rec_headers_int | INTERFACE_HEADER_ID |
| sch_rec_lots_int | sch_rec_headers_int | INTERFACE_HEADER_ID |
| sch_rec_serials_int | sch_rec_headers_int | INTERFACE_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SCH_REC_HEADERS_INT_U1 | Unique | Default | INTERFACE_HEADER_ID |