Entity Definition

Logical Name : Event
Physical Name : CO_EV

Something that happens, takes place or has been planned represented by the designation of time, place and purpose.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EventID (PK) A unique, automatically assigned identifier for the Event ID_EV Identity integer
TypeCode Identifies the category for the event. Examples Scheduled Event and Device Event TY_EV Code4 char(4)
Name The business name of the event. NM_EV Name varchar(40)
Description Describes the event. DE_EV DescriptionShort varchar(255)
StatusCode The current status code of the event -- e.g. active, pending, deferred, canceled, etc. SC_EV Code2Status char(2)
ActualStartDateTimestamp The actual start date and time for an event. TS_EV_ACT_EF AuditDateTime datetime
ActualEndDateTimestamp The actual time and date when the event terminates. TS_EV_ACT_EP AuditDateTime datetime


Parent Entity Verb Phrase Child Entity
Event can be a ScheduledEvent
Event can be a RecallEvent
Event can be a DeviceEvent

Logical Views containing Event

Logical View
Logical 01300 - Item Price Maintenance View
Logical 06700 - Event Scheduler View
Logical 11100 - Worker - Macro View
Logical 21000 - Fresh Item Management Macro View