Enables you to view a breakdown of all available calculation year hours data records. This window is only available for salaried workers of all pay frequencies with a UK legislation type. Control groups or individual employees must be identified as salaried in Control Group NMW Details or Employee NMW Details.

Opening Balances

Note: All of the following fields are display only.

Below Hours

The cumulative total of hours worked in this calculation year that are below the annual working hours threshold up to the start date of the selected period.

Above Hours

The hours calculated to be above the annual working hours threshold up to the start date of the selected period. This applies only to the period in which the annual working hours threshold was exceeded.

Excess Hours

The hours the employee has worked up to the start date of the selected period which are more than the calculated annualised hours. This is based on the employee’s contract hours and any additional hours worked in this calculation year.

Below Hours Yr2

The number of hours the employee has worked below the annual hours threshold for the calculation year that starts in this period.

Above Hours Yr2

The number of hours the employee has worked above the annual hours threshold for the calculation year that starts in this period.

Excess Hours Yr2

The number of actual hours the employee has worked above the annual hours threshold (based on contract hours plus any additional hours) for the calculation year that starts in this period.

Period Calc Details

Note: All of the following fields are display only.

Contract Hrs/Per

The employee's contract hours in this period.

Supp Flag

Y indicates that this is a supplementary run. N indicates that this is not a supplementary run.

Ann Threshold

The employee's annual hours threshold for the calculation year that applies in this period.

Anniversary Flag

Y indicates that a fixed anniversary date has been applied in this period. N indicates that a fixed anniversary date has not been applied in this period.

Anniversary Date

The fixed anniversary date applied in this period. This causes a new calculation year record to be created from this date onwards. The anniversary date is based on the company wide calculation year set in National Minimum Wage/Living Wage Parameters, Control Group NMW Details or Employee NMW Details.

Additional Hrs

The number of additional hours the employee worked during this period.

Total Worked Hrs

The total number of hours the employee worked during this period. If an anniversary occurs in this period, the value is subject to pro rata.

Hrs Aft Anniv

The pro rata number of worked hours after the anniversary date in the period. If an anniversary date does not occur in the period, this value will be zero.

Year Length

The year length in days.

Contract Hrs/Wk

The employee's contract hours that apply at the start of this period.

Calc Days/Per

The calculated number of days in the period.

Calc Hrs/Per

The transitional calculation of contract hours in the period, including any additional hours. The additional hours are prorated if there is an anniversary in the period.

Calc Hrs/Day

The calculated average hours the employee has worked per day, including any additional hours.

Threshold Date

The date on which the annual worked hours threshold was exceeded.

Days Bef Thresh

The number of days in the period up to the date on which the annual worked hours threshold was exceeded.

Days Aft Thresh

The number of days in the period on or after the date on which the annual worked hours threshold was exceeded.

Before Factor

A calculated factor based on the number of days in the year and the number of days in the period (up to the date on which the annual worked hours threshold was exceeded).

After Factor

A calculated factor based on the number of days in the year and the number of days in the period (on or after the date on which the annual worked hours threshold was exceeded).

Hrs Bef Thresh

The calculated number of hours for this period before the annual worked hours threshold was exceeded.

Hrs Above Thresh

The calculated number of hours for this period after the annual worked hours threshold was exceeded.

Act Above Thresh

The employee's actual hours worked over the annual worked hours threshold (based on contract hours and any additional hours worked).

Closing Balances

Note: All of the following fields are display only.

Below Hours

The cumulative year-to-date (YTD) total number of hours worked in this calculation year that are below the annual working hours threshold as at the end date of the selected period.

Above Hours

The hours calculated to be above the annual working hours threshold as at the end date of the selected period. This applies only to the period in which the annual working hours threshold was exceeded.

Excess Hours

The cumulative YTD total in this calculation year of actual hours worked that are above the annual working hours threshold, based on the employee’s contract hours and any additional hours worked in this calculation year, as at the end date of the selected period.

Below Hours Yr2

The number of hours the employee has worked below the annual hours threshold for the calculation year that starts in this period. This field is only populated if there is a fixed anniversary in this period.

Above Hours Yr2

The number of hours the employee has worked above the annual hours threshold for the calculation year that starts in this period. This field is only populated if there is a fixed anniversary in this period.

Excess Hours Yr2

The number of actual hours the employee has worked above the annual hours threshold (based on contract hours plus any additional hours) for the calculation year that starts in this period. This field is only populated if there is a fixed anniversary in this period.

MD305G35

Related knowledgebase articles