Entity Definition

Logical Name : WorkerTimeAccrualHistory
Physical Name : LE_HST_WRKR_TM

A record of the number of hours worked by a Worker during a ReportingPeriod.

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)
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
WorkerAccrualTypeCode (FK)(PK) A unique retailer assigned code denoting the kind of time that is being recorded. e.g. Regular, Overtime, Premium, PremiumOvertime, Holiday, PaidHoliday, Vacation, SickTime, Bereavement. CD_TYP_WRKR_TM Code4 char(4) WorkerTimeAccrualType(CO_TYP_WRKR_TM)
AccrualQuantity The number of Hours worked by the Worker during the nominated ReportingPeriod delineated by the nominated AccrualType QU_UN_CNT Quantity DECIMAL(9,3)


Parent Entity Verb Phrase Child Entity
ReportingPeriod delineates WorkerTimeAccrualHistory
WorkerTimeAccrualType classifies WorkerTimeAccrualHistory
Worker is tracked by WorkerTimeAccrualHistory

Logical Views containing WorkerTimeAccrualHistory

Logical View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 11150 - Worker - Time Punch View