The settings for the sub period. Includes the Basic Rate and Gross Rate pay to specify which sub period it belongs to.

System generated identifier. It is blind to the user. It also holds the primary key for the Employee 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)

Takes the identity of the Day Rate Formula from OverTime.
Example: OTDayFormula1 / OTDayFormula2 etc.

Takes the identity of the Hour Rate Formula from OverTime.
Example: OTHourFormula1 / OTHourFormula2 etc.

Shows the current overtime amount calculated by the day (day rate).

Shows the current overtime amount calculated by the hour (hour rate).
This amount is the result after using the OT Hour Rate Formula:

[(Total Wage + Allowance & Shift subject to OT) x 12] / hours per year

or

[(Total Wage + Allowance & Shift subject to OT) x 12] / (52 x 44)

Shows the last overtime amount calculated by the hour (hour rate).

Shows the last overtime amount calculated by the day (day rate).

Shows the identity of the overtime table for the employee.

Shows the identity of the shift table for the employee.

Indicates if the employee is late. If the employee is late, the late amount will not be included in the Leave Deduction Amount.
Example: Late = "1" / Not late = "0"

Indicates if the employee is absent. If the employee is absent, the amount will not be included in the Leave Deduction amount.
Example: Absent = "1" / Present = "0"

Takes the identity of the Day Rate Formula from the Best Rate of Pay.
Example: BRPDayFormula1 / BRPDayFormula2 etc.

Takes the identity of the Hour Rate Formula from the Best Rate of Pay.
Example: BRPHourFormula1 / BRPHourFormula2 etc.

This is the calculated day rate amount from the Best Rate of Pay.

This is the calculated hour rate amount from the Best Rate of Pay.

Takes the identity of the Day Rate Formula from the Gross Rate of Pay.
Example: GRPDayFormula1 / GRPDayFormula2 etc.

Takes the identity of the Hour Rate Formula from the Gross Rate of Pay.
Example: GRPHourFormula1 / GRPHourFormula2 etc.

This is the calculated day rate amount from the Gross Rate of Pay.

This is the calculated hour rate amount from the Gross Rate of Pay.