Stores information about the employee's overtime record. Its overtime hours, pay period, sub period and other related information.

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.

Shows the generating identity of the overtime record. This is the primary key for the OTRecord table.
Example: A1 / A66 / A110

Shows the identity for the overtime formula. This is also the foreign key for the OTRecord table.

Shows the year for the pay record.
Example: 2012

Shows the period for the pay record.
Example: January = "1", February = "2", March = "3" etc.

Holds the sub period for the pay record.

Example:
Sub period 1 = 1 Payment Group (Hourly, Daily & Monthly rated)
Sub period 2 = 2 Payment Group (Hourly, Daily & Monthly rated)
Sub period 3 = 3 Payment Group (Hourly & Daily rated), divided by 3 and the balance is placed in the last sub-period
Sub Period 4 = 4 Payment Group (Hourly & Daily rated)

Stores the identity for the pay record.
Example: Normal / Normal Time Sheet

Shows the type of overtime.

Shows the overtime rate.
Example: The company would pay the employee 1.5 times more per hour for working overtime.

The maximum number of hours the employee can work overtime.

Shows the current rate for when an employee works overtime.

Shows the current number of hours the employee can work overtime.

Shows the current amount for when an employee works overtime.

Shows the last rate for when an employee works overtime.

Shows the last number of hours the employee can work overtime.

Shows the last amount for when an employee works overtime.

Shows the back pay overtime rate.

Shows the number of back pay hours the employee has worked.

Shows the back pay overtime amount for when an employee works overtime.

Shows who created the overtime record.

Shows the foreign overtime amount.

Shows the identity of the overtime exchange rate.

Shows the overtime exchange rate.