SCH_REC_EXT_LOT_NUMBERS
This table stores the recalled lot information provided by the external sources such as manufacturers, distributors, and the regulatory authorities, who initiated or issued the recall. It also stores the lot level attributes that are transformed by generative artificial intelligence, the attributes that are enriched post transformation, and the attributes that are proposed by the end user.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
SCH_REC_EXT_LOT_NUMBERS_PK |
EXT_SOURCE_LOT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
EXT_SOURCE_LOT_ID | NUMBER | 18 | Yes | Unique identifier of the lot number in the external recall notification. | |
EXT_SOURCE_LINE_ID | NUMBER | 18 | Yes | Unique identifier of the external recall notification line and a foreign key to the SCH_REC_EXT_LINES table. | |
EXT_SOURCE_HEADER_ID | NUMBER | 18 | Yes | Unique identifier of the external recall notification header and a foreign key to the SCH_REC_EXT_HEADERS table. | |
MFG_LOT_NUMBER | VARCHAR2 | 80 | Indicates the manufacturer lot number. | ||
MFG_LOT_NUMBER_PROP | VARCHAR2 | 80 | Indicates the proposed final value of the manufacturer lot number. | ||
EXPIRATION_DATE | DATE | Expiration date for the recalled lot. | |||
EXPIRATION_DATE_PROP | DATE | Indicates the proposed final value of the Expiration date of the recalled lot. | |||
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. | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
SCH_REC_EXT_LOT_NUMBERS | sch_rec_ext_headers | EXT_SOURCE_HEADER_ID |
SCH_REC_EXT_LOT_NUMBERS | sch_rec_ext_lines | EXT_SOURCE_LINE_ID |
sch_rec_ext_serial_numbers | sch_rec_ext_lot_numbers | EXT_SOURCE_LOT_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
SCH_REC_EXT_LOT_NUMBERS_N1 | Non Unique | Default | EXT_SOURCE_LINE_ID, EXT_SOURCE_HEADER_ID |
SCH_REC_EXT_LOT_NUMBERS_N2 | Non Unique | Default | MFG_LOT_NUMBER |
SCH_REC_EXT_LOT_NUMBERS_U1 | Unique | Default | EXT_SOURCE_LOT_ID |