Entity Definition

Logical Name : WorkerEventAssignment
Physical Name : CO_ASGMT_WRKR_EV

Assignment of an Event to be performed by a particular Worker.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EventID (FK)(PK) A unique, automatically assigned identifier for the Event ID_EV Identity integer RetailStoreLocationEvent(CO_EV_RTL_STR_LCN)
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer RetailStoreLocationEvent(CO_EV_RTL_STR_LCN)
WorkerID (FK)(PK) A unique system-assigned identifier for the Person who is a particular Worker. ID_WRKR Identity integer Worker(PA_WRKR)


Parent Entity Verb Phrase Child Entity
Worker is assigned to WorkerEventAssignment
RetailStoreLocationEvent is assigned to WorkerEventAssignment

Logical Views containing WorkerEventAssignment

Logical View
Logical 06700 - Event Scheduler View
Logical 11100 - Worker - Macro View