SCH_REC_HEADERS
This table stores the header information of a product recall notice A recall notice is created at business unit level.Each row contains the recall notice number that gets generated based on recall document sequence defined in configuration parameter. 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.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SCH_REC_HEADERS_PK |
HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| HEADER_ID | NUMBER | 18 | Yes | Recall Notice Header Unique identifier. | |
| RECALL_NOTICE_NUMBER | VARCHAR2 | 60 | Yes | Recall Notice number used for internal tracking within the enterprise which gets generated based on document sequencing setup. | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Business Unit unique identifier in which the recall notice is created. | ||
| STATUS | VARCHAR2 | 30 | Indicates the status of recall notice. | ||
| 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 | 30 | Indicates the different types of source who initiated the recall such as Manufacturer, Regulatory Authority etc values retrived from the seeded lookup type ORA_SCH_SOURCE_TYPE. | ||
| RECALL_SOURCE_ID | NUMBER | 18 | Recall source unique identifier. | ||
| RECALL_REASON | VARCHAR2 | 2000 | Free text where the user can enter details about the recall reasons. | ||
| MANUFACTURER_ID | NUMBER | 18 | Trading partner unique identifier. | ||
| BPA_MANUFACTURER_LINE_ID | NUMBER | 18 | Indicates the PO Line Identifier corresponding to the Blanket Purchase Agreement that stores the Manufacturer Name. | ||
| MANUFACTURER_URL | VARCHAR2 | 2000 | Free text where the user can enter the manufacturing firms URL. | ||
| RECALL_NOTICE_TYPE | VARCHAR2 | 30 | Indicates the classification of recall notice with values retrieved from the seeded look up type ORA_SCH_NOTICE_TYPE. | ||
| RECALL_CLASSIFICATION_TYPE | VARCHAR2 | 30 | Indicates the classification of recall notice based on severity of the impact it has on consumers. These values are retrieved from the seeded look up type ORA_SCH_CLASSIFICATION. | ||
| POTENTIAL_RISK | VARCHAR2 | 2000 | Free text where user can provide the details about the risk factors of the recalled product. | ||
| REPLACEMENT_TYPE | VARCHAR2 | 30 | Indicates the method by which the recalled parts can be disposed off. These values are retrieved from the seeded look up type ORA_SCH_REPLACEMENT_TYPE. | ||
| RECALL_INSTRUCTION | VARCHAR2 | 2000 | Free text where user can provide some special instructions against replacement type.It is mandatory for Correction replacement type. | ||
| 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. | |||
| TRACK_START_DATE | DATE | Indicates the start date provided while taking the Locate action. This date will override the start date captured in the recall notice. | |||
| 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. | |||
| TRACK_END_DATE | DATE | Indicates the end date provided while taking the Locate action. This date will override the end date captured in the recall notice. | |||
| DUP_VALIDATION_FLAG | VARCHAR2 | 1 | Flag indicating whether the duplication validation has happened or not. | ||
| ORIGINAL_HEADER_ID | NUMBER | 18 | Unique identifier of original recall notice header that gets updated for a recall notice marked as duplicate. | ||
| LOCATE_STATUS | VARCHAR2 | 30 | Indicates the status whether the locate action has been taken on the recall notice or not .The Status values are: NOT STARTED, INPROGRESS, COMPLETED. | ||
| COMMENTS | VARCHAR2 | 2000 | Indicates the comments for withdrawal of a recall notice. | ||
| 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. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| LOCATE_REQUEST_ID | NUMBER | 18 | Indicates the latest request ID of the locate ESS job that got submitted for the 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. | ||
| 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_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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 | sch_rec_headers | HEADER_ID |
| sch_rec_contacts | sch_rec_headers | HEADER_ID |
| sch_rec_serial_numbers | sch_rec_headers | HEADER_ID |
| sch_rec_bu_assignments | sch_rec_headers | HEADER_ID |
| sch_rec_lot_numbers | sch_rec_headers | HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SCH_REC_HEADERS_N1 | Non Unique | Default | BUSINESS_UNIT_ID |
| SCH_REC_HEADERS_U1 | Unique | Default | HEADER_ID |