Entity Definition

Logical Name : WorkerTrainingRecord
Physical Name : DO_WRKR_TRG

A record that a particular Worker has been trained in performing a particular Task.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WorkerID (FK)(PK) A unique system-assigned identifier for the Person who is a particular Worker. ID_WRKR Identity integer Worker(PA_WRKR)
TaskID (FK)(PK) A unique retailer assigned identifier for an individual activity that a Worker performs in the course of their Position. ID_TSK Identity integer Task(CO_TSK)
EffectiveDate The date on which the Worker completed training for the nominated Task. DC_EF EffectiveDate date
SkillLevelCode A retailer-assigned code denoting how skilled the Worker is for the nominated Task as a result of the training that took place. CD_LV_SKL Code2 char(2)
QualifiedFlag A flag recording if the Worker is qualified to perform the nominated Task as a result of the Training that took place. FL_QLF Flag integer


Parent Entity Verb Phrase Child Entity
Worker has WorkerTrainingRecord
Task classifies WorkerTrainingRecord

Logical Views containing WorkerTrainingRecord

Logical View
Logical 11100 - Worker - Macro View
Logical 11120 - Worker - Job Definition View