OT50, OT100 and BO
OT50 and OT100 represent overtime that has been earned with 50% and 100% additional premium rates. The work schedule defines when these overtime rates come into effect.
The BO column is the total amount of bonus premium that was earned. For example, a single hour within OT50 and one more hour within OT100 would total 1.5 hours of bonus overtime. This would equate to 1.5 hours in addition to the standard working time.
If the work schedule defines different rates of pay for overtime, these will appear in the columns OT10 (10% Premium), OT25 (25% Premium) and, as in this example, OT50 (50% Premium.) The sum of overtime with the premium can be seen under BO.
PNT and TPT
PNT (Paid Non-Working Time) represents any time that the employee is entitled to be paid for, yet was not working. This includes public holidays, sickness and annual leave.
By default, other leave types contribute towards Paid Non-Working Time. These include maternity leave and training courses, among others.
TPT displays the Total Paid Time for that day. This is a sum of the Working Hours and any Paid Non-Working Time.
DB and TB
The DB column represents the Daily Balance of hours. This is the difference between the Total Paid Time and the Target Working Hours. For example, if the target hours for a day amounted to 8, and the employee worked 9.5 hours, then the Daily Balance would have a value of 1.5
The TB is the Total Balance, or the running total of an employee’s Daily Balance. This shows an overall plus or minus amount of hours up to that date.
OP and CT
OP refers to the Overtime Payout. This is a column where a manager can input the amount of hours that the employee has been paid for. Any figure entered here will reduce the Total Balance by that amount, too.
CT refers to Compensation Time, or additional hours that the employee has used to have time off from the workplace. Any figure entered here will reduce the Total Balance by that amount, too.
LD, PH, SA and OL
- LD (Leave Day): Whether annual leave was consumed on that day. A figure of 1 represents an entire working day. This will reduce the Target Working Hours accordingly.
- PH (Public Holiday): Whether a public holiday occurred on that day. A figure of 1 represents an entire working day. This will reduce the Target Working Hours accordingly.
- SA (Sickness Absence): Whether the employee was absent due to sickness on that day. A figure of 1 represents an entire working day. This will reduce the Target Working Hours accordingly.
- OL (Other Leave): Whether the employee was absent for another reason on that day. A figure of 1 represents an entire working day. This will reduce the Target Working Hours accordingly. The type of absence can be specified in the next column.
