How are Hour Types set up and mapped at a Site Level?

Hour Types for a Site are set up from within Admin | Finance. From the Post Pay column, select Hour Types. You will be presented with a search screen comprising those Hour Types that have already been set up. Select +Add to create a new Hour Types. Follow the instructions to set up your Hour Types:

  1. Enter the details of the hour type in the General section
  2. Complete as appropriate the various parts of the screen
    • Pay Details
    • Bill Details
    • Default Hour Types
    • Absence
    • Invoice and Contracts
    • Mandatory Duty Links
  3. Select Save

 

The following should aid in your completion of 1 and 2:

General

Code

A unique code to identify the hour type for example REG (mandatory)

 

Description

A brief description of the hour type for example Regular Contracted Hours (mandatory)

 

Summary Hour Type

The summary hour type to allocate this hour type to, selected from a drop-down list for example Regular (Regular Hours). This is used for reporting and analysis only (mandatory)

 

Authorised Users Only

This limits the hour type drop-down list available to users if ticked (for example in Duty Edit). If this security item is selected, then it is only those users with the appropriate level of security access will be able to see the Hours Type

 

Remain in this Hour Type

This setting ensures the same pay and bill rules continue when one duty moves into another Hours Type (for example from regular hours to overtime) when selected. This means that anyone working this type of work will remain on normal hours and not benefit from the overtime rates. By default this is not selected, therefore, the pay and bill rules continue

 

Exclude from Period Overtime Calculations

This option should be selected if the user does not want this type of hours worked to be used towards the period overtime (POT) limit i.e. the hours’ worked before overtime kicks in.

For example, the hour type “Meal Break” would probably not be counted towards the overtime limit. Assume an employee’s Period Overtime Limit is 40 hours. The employee works 37.5 “Regular” hours and 5 “Meal Break” hours. This totals 42.5 hours. The overtime limit of 40 has not been exceeded, as only the 37.5 Regular hours count towards the overtime limit. Therefore, another 2.5 “Regular” hours would have to be worked before the overtime rate kicks in

 

Training Indicator

This is a code that is used when exporting to third party systems. Select as appropriate.

 

Training Type

This is a code for exporting to third party systems. This should be entered when Training Indicator is selected.

 

Contracted

If selected, then if a user manually adds a duty and uses this hour type, the contracted times of the duty are populated. This is a change from normal behavior, whereby these fields are only populated when the duty origin is auto schedule generated

 

 

Pay Details

Pay Method

This determines whether to use the employee's base pay rate (located within Set Up | Employees | Pay Details Tab) or the Rate within the Site Group Post Pay table (located within Set Up | Site Group | Post Pay Tab)

The five values to choose from on this drop-down list are as follows:

  • Table Rate – use the rate on the Post Pay Table
  • Employee Base Rate – use the employee's base pay rate
  • Greater of Base/Table Rate – use whichever is greater: the employee's base pay rate or the rate on the post pay table
  • Lesser of Base/Table Rate – use whichever is lesser: the employee's base pay rate or the rate on the post pay table
  • Time Off in Lieu (TOIL) – Tell the Rate Generation process to accumulate the duty hours’ into a “TOIL bucket”

 

Pay Column

If a Pay Method that needs to access the Post Pay table (Table Rate, Employee Base Rate or Lesser of Base/Table Rate) is chosen by the user, then this drop-down list should show which column in the table to use

 

Pay Multiplier Column

This indicates which column in the Site Group Post Pay table is used as a multiplier to the rate determined by the Pay Column that must be selected using the drop-down list (mandatory)

 

Pay Multiplier

This is a flat rate that is used as a multiplier to the rate defined in the Pay Column. Example values may include: 2 for double-time and 1.5 for time-and-a-half. If an hour type does not need a multiplier, the value must be set to 1

 

Pay Code

This value determines exactly which rate is to be used. A Pay Code can be assigned to an hour type. This pay code will ultimately be output to payroll

 

External Pay Code

This value determines exactly which rate is to be used. The External Pay Codeis used instead of Pay Code when the length of the pay code is greater than 10 characters long. The External Pay Code can be used for values of up to 50 characters long. This pay code will ultimately be output to payroll

 

Bill Details

Bill Method

This determines whether to use the Site's fixed charge per hour rate (located within Set Up | Sites | Post Pay Tab) or the rate on the Site Group Post Pay table offering variable charge rates (located within Set Up | Site Group | Post Pay Tab). The four values to choose from on this drop-down list are as follows:

  • Table Rate – use the rate on the post pay table.
  • Site Card Charge Rate – use the site's charge rate
  • Greater of Base/Table Rate – use whichever is greater: the site's charge rate or the rate on the post pay table
  • Lesser of Base/Table Rate – use whichever is lesser: the site's charge rate or the rate on the post pay table

 

Bill Column

If a Bill Method that needs to access the post pay table Post Pay table (Table Rate, Employee Base Rate or Lesser of Base/Table Rate) is chosen by the User, then this drop-down list should show which column in the table to use

 

Bill Multiplier Column

This indicates which column in the Site Group Post Pay table is to be used as a multiplier to the rate. This is determined by the Bill Column that must be selected using the drop-down list

 

Bill Multiplier

This is a flat rate that is used as a multiplier which is applied to the rate defined in the Bill Column. Example values may include: 2 for double-time and 1.5 for time-and-a-half. If an hour type does not need a multiplier, the value must be set to 1 (mandatory)

 

Bill Code

This value determines which bill code is to be used for an hour type. This Bill Code will ultimately be exported to an accounts package

 

External Bill Code

This value determines exactly which bill rate is to be used. The External Bill Code is used

instead of the Bill Code when the length of the bill code is greater than 10 characters long. The External Bill Code can be used for values of up to 50 characters long.

 

 

Default Hour Types

Duty Overtime 1

These default mappings determine how Hour Types will be treated when Overtime or Holiday applies to duties worked under this Hour Type

  • The first drop-down list holds the Hour Types that will be used when Duty Overtime 1 applies
  • The second drop-down list holds the Hour Types that will be used when Duty Overtime 2 applies
  • The third drop-down list holds the Hour Types that will be used when Period Overtime 2 applies
  • The fourth drop-down list holds the Hour Types that will be used when Period Overtime 2 applies
  • The last drop-down list holds the Hour Types that will be used when Holiday applies

 

Any entries that are left blank will indicate that the Hour Types will remain unchanged, even if Overtime or Holiday applies.

 

Any Site Group, where appropriate, can copy these default hour type mapping into its Site Group hour types mapping automatically.

These are only the defaults. The mappings on the Site Group are the ones that are used in Rate Generation

Duty Overtime 2

Period Overtime 1

Period Overtime 2

Holiday

 

Absence

Use Regular Pay Rate

This setting is used in calculating averages for pay that is then used by the Absence module to calculate Holiday pay worked on average hours worked

 

Exclude from Average Calculations

This setting enables the user to include or exclude average daily rates when calculating authorised absences - tick the box in order to exclude from the calculation

 

Invoicing and Contracts

HED Number

This is a code for exporting to third party systems

 

Exclude From Budget

This option relates to the Site Teams and Wage to Budget Report (16-04-03). When this is selected for a particular hour type, any hour or amounts relating to duty rates records for that hour type are completely ignored in both the Site Teams and Wage to Budget Report

 

Billing Description

A description of the bill code

 

Non Billable Hour Type

No longer in use

 

Contract Cost Indicator

This is a code for exporting to third party systems - click to select

 

Contract Cost Type

This is a code for exporting to third party systems. The contents of this drop-down list are configured in the Admin | General | Contract Type Tab. Choices may, for example include Annual, Flexible, Temporary or Zero Hours depending upon how the system has been configured. The value in this field is used for the pay and bills rules

Mandatory Duty Info

Checking any of the Duty Info fields here will make that field become a mandatory field for any Duty Add or Duty Edit pages that have this Hour Type selected. Mandatory fields are only for non-rota-loaded duties.