Entity Definition

Logical Name : RecallEventItem
Physical Name : CO_RCL_EV_ITM

The set of items or inventory items that are impacted by a recall event. These items may be identified directly in the original recall or may be identified by tracing their application to the recall via traceability: contact with equipment, contact with specific workers, contact with other ingredients, location of items, or parent item or inventory item components

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EventID (FK)(PK) A token used to identify an object, represented as an Integer. ID_EV Identity integer RecallEvent(CO_RCL_EV)
RecallEventSequenceNumber (PK) A number, that together with a recall event ID, uniquely indentifies a recall event item or inventory item. AI_RCL_EV Identity integer
ItemTraceableUnitID (FK) A universally unique identifier used to identify an instance of a distinguisable instance of a retail item. The item traceable unit ID is similar to a serial number in that it allows each selling unit to be explicitly identified and distinguished from other sellling units of the same Item. ID_ITM_UN_TRC IdentityUUID CHAR(32) ItemTraceableUnit(AS_ITM_TRCBL_UN)


Parent Entity Verb Phrase Child Entity
RecallEvent impacts RecallEventItem
ItemTraceableUnit is contained on RecallEventItem

Logical Views containing RecallEventItem

Logical View
Logical 21000 - Fresh Item Management Macro View