WorkerClass

Entity Definition

Logical Name : WorkerClass
Physical Name : CO_CLS_WRKR

A group of Workers with similar terms and conditions of employment.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WorkerClassCode (PK) A unique retailer assigned code denoting a group of Workers with similar terms and conditions of employment. e..g E7,M3, CD_CLS_WRKR Code4 char(4)
WorkerClassName The name of a group of Workers with similar terms and conditions of employment. NM_CLS_WRKR Name varchar(40)
FullTimeFlag A flag recording wether or not Workers in this class work a mandated 37.5 or 40 hours per-week. FL_TM_FL Flag integer
SalaryFlag A flag recording wether or not Workers in this class are paid a Salary or per time period. FL_SLRY Flag integer
OvertimeExemptFlag A flag recording wether or not Workers in this class are exempt from working overtime. FL_EXM_OVR_TM Flag integer
PenalRateFlag A flag recording wether or not Workers in this class are paid a penal rate for working overtime. Sometimes referred to as OvertimeEligibileFlag. FL_RTE_PNL Flag integer
CommissionFlag A flag recording wether or not Workers in this class are paid commission on the sales that they make. FL_CMN Flag integer
PayPeriodCode A retailer assigned code denoting the normal pay period for Workers in this class. e.g. Hour, Week, Month, Year CD_PRD_PY Code4 char(4)
PayRate A monetary amount being the normal amount paid per PayPeriod to Workers in this class. MO_RTE_PY Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
WorkerClass delineates WorkerClassification

Logical Views containing WorkerClass

Logical View
Logical 11100 - Worker - Macro View