Entity Overtime

Description of Entity Overtime

This entity contains the specified OT Rate. Limits can be set on overtime hours, days or total overtime pay. Though there are several levels of capping, use only one to avoid confusion.

The levels of capping are:
- OT Table: Min / Max OT amount capping
- OT Table: Min / Max Day Rate
- OT Table: Min / Max Hour Rate
- OT Rate: Fixed, Day and Hour Rate capping

OT Table level capping supersedes OT Rate level capping.


List of all Dependencies of the Entity Overtime

Name

Code

Class Name

Relation_56518

Relation_56518

Reference

Ref_5097

Ref_5097

Reference

Relation_648541

Relation_648541

Reference


List of Attributes of the Entity Overtime

Name

Code

OT Table ID

OTTableId

Description

OTTableDesc

Maximum Total Wage

MaxTotalWage

Minimum Total Wage

MinTotalWage

Maximum Total OT Amount

MaxOvertimeAmount

Minimum Total OT Amount

MinOvertimeAmount

Minimum Day Rate

MinDayRate

Maximum Day Rate

MaxDayRate

Minimum Hour Rate

MinHourRate

Maximum Hour Rate

MaxHourRate


Entity Attribute OT Table ID of the Entity Overtime

Card of Attribute OT Table ID of the Entity Overtime

Name

OT Table ID

Code

OTTableId

Data Type

char(20)

Mandatory

Yes


Description of Attribute OT Table ID of the Entity Overtime

Shows the identity of the overtime table. It holds the primary key for the Overtime table.


Entity Attribute Description of the Entity Overtime

Card of Attribute Description of the Entity Overtime

Name

Description

Code

OTTableDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity Overtime

Shows the description of the overtime table.


Entity Attribute Maximum Total Wage of the Entity Overtime

Card of Attribute Maximum Total Wage of the Entity Overtime

Name

Maximum Total Wage

Code

MaxTotalWage

Data Type

double

Mandatory

No


Description of Attribute Maximum Total Wage of the Entity Overtime

Shows the maximum total wage used for computing the day rate and hour rate.


Entity Attribute Minimum Total Wage of the Entity Overtime

Card of Attribute Minimum Total Wage of the Entity Overtime

Name

Minimum Total Wage

Code

MinTotalWage

Data Type

double

Mandatory

No


Description of Attribute Minimum Total Wage of the Entity Overtime

Shows the minimum total wage for working overtime.


Entity Attribute Maximum Total OT Amount of the Entity Overtime

Card of Attribute Maximum Total OT Amount of the Entity Overtime

Name

Maximum Total OT Amount

Code

MaxOvertimeAmount

Data Type

double

Mandatory

No


Description of Attribute Maximum Total OT Amount of the Entity Overtime

After getting the total OT amount (current OT + last OT exclude back pay OT), the amount is subject to this limitation.


Entity Attribute Minimum Total OT Amount of the Entity Overtime

Card of Attribute Minimum Total OT Amount of the Entity Overtime

Name

Minimum Total OT Amount

Code

MinOvertimeAmount

Data Type

double

Mandatory

No


Description of Attribute Minimum Total OT Amount of the Entity Overtime

Shows the minimum overtime amount. OT Capping by table. The limit here is used regardless of the day or individual OT rate capping.


Entity Attribute Minimum Day Rate of the Entity Overtime

Card of Attribute Minimum Day Rate of the Entity Overtime

Name

Minimum Day Rate

Code

MinDayRate

Data Type

double

Mandatory

No


Description of Attribute Minimum Day Rate of the Entity Overtime

Shows the minimum day rate when working overtime. Maximum / Minimum daily wage rate will be used if the employee's daily wage rated is below the minimum rate / above the max rate.


Entity Attribute Maximum Day Rate of the Entity Overtime

Card of Attribute Maximum Day Rate of the Entity Overtime

Name

Maximum Day Rate

Code

MaxDayRate

Data Type

double

Mandatory

No


Description of Attribute Maximum Day Rate of the Entity Overtime

Shows the maximum day rate when working overtime. Maximum / Minimum daily wage rate will be used if the employee's daily wage rated is below the minimum rate / above the max rate. Maximum day capping: limit the number of days that can be typed in.


Entity Attribute Minimum Hour Rate of the Entity Overtime

Card of Attribute Minimum Hour Rate of the Entity Overtime

Name

Minimum Hour Rate

Code

MinHourRate

Data Type

double

Mandatory

No


Description of Attribute Minimum Hour Rate of the Entity Overtime

Shows the minimum hour rate when working overtime. Maximum / Minimum hourly wage rate will be used if the employee's hourly rate is below / above the rate.


Entity Attribute Maximum Hour Rate of the Entity Overtime

Card of Attribute Maximum Hour Rate of the Entity Overtime

Name

Maximum Hour Rate

Code

MaxHourRate

Data Type

double

Mandatory

No


Description of Attribute Maximum Hour Rate of the Entity Overtime

Shows the maximum hour rate when working overtime. Maximum / Minimum hourly wage rate will be used if the employee's hourly rate is below / above the rate. Maximum hours capping: Set a limit on the number of overtime hours on an employee's Pay Record.