Entity Definition

Logical Name : WorkerSchoolEnrollment
Physical Name : CO_ASGMT_WRKR_SCHL

A record that a particular Worker was enrolled at a particular School for a period of time.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
SchoolID (FK)(PK) A unique retailer assigned identifier for an educational institution that a Worker may attend, as well as working for the Retailer. ID_SCHL Identity integer School(PA_SCHL)
WorkerID (FK)(PK) A unique system-assigned identifier for the Person who is a particular Worker. ID_WRKR Identity integer Worker(PA_WRKR)
EffectiveDate The date from which the nominated Worker is enrolled at the nominated School. DC_EF EffectiveDate date
ExpirationDate The date from which the nominated Worker is no longer enrolled at the nominated School DC_EP ExpirationDate date


Parent Entity Verb Phrase Child Entity
Worker attends WorkerSchoolEnrollment
School enrolls WorkerSchoolEnrollment

Logical Views containing WorkerSchoolEnrollment

Logical View
Logical 11100 - Worker - Macro View