GC Monitor - Pay Rates Setup - Alternative Pay Rates - Pay Rate Tables

On the Rates/Salary tab of an Employee Profile (standard Treeview path: US Payroll > Setup > Employees > Employee Profile), the rates for each of the 3 pay rate types can be set to come from a Pay Rate table instead of using the rates specified by the Hourly Rate, Charge Out Rate, and Billing Rate fields on this tab.  Alternative pay rates are set via the Preferred Pay Rate, Preferred Charge Out Rate, and Preferred Bill Rate fields.  The following provides details about the options available by these fields.

Trade

Trade indicates that the employee’s trade code is used to determine the rates.  If this option is selected, you must define the rates by trade.

Customer

Customer indicates that the customer code is used to determine the default rate based on the job code entered on the timesheet.  This option uses the Customer field on the Job Maintenance screen (standard Treeview path: Job Costing > Job > Enter Job) to determine the customer assigned to the job specified on the timesheet.  If this option is selected, you must define the rates by customer within the Customer Pay Rates screen.

Employee

Employee indicates that rates are to come from the Employee Pay Rates table, or the Employee Profile.  The Employee Pay Rates table is used to enter date sensitive rates.  The system will first look to the Employee Pay Rates table to determine if an employee’s pay rate is defined for the period specified by the timesheet.  If it is not found in the table, the system will use the rate set on the Rates/Salary tab of the Employee Profile (Hourly Rate, Charge Out Rate, Billing Rate fields).

Job

Job indicates that the job code is used to determine the rates based on the job code entered on the timesheet.  If this option is selected, you must define the rates by job.

Union

Union indicates that the employee’s union code is used to determine the rates.  If this option is selected, you must define the rates by union within the Union Pay Rates screen.

Job/Trade

Job/Trade indicates that rates should come directly from the Job Rates if set up, and then Trade Rates if no Job Rate exists. This is a hierarchical search starting with Job, then Trade, and if both are missing the standard search of Employee Rates, then Employee Profile rate.

Job/Union

Job/Union indicates that rates should come directly from the Job Rates if they exist, but if they don’t exist then Union Rates will be used.  This is a hierarchical search for rate selection starting with Job, then Union. If both are missing the standard search of Employee Rate table, then Employee Profile rate applies.

Pay Rate Hierarchy

If for some reason a specified rate cannot be found in the system, it will default the rate from the Employee Pay Rate table.  If an appropriate rate cannot be found within the Employee Pay Rate table, it will use the static information from the Employee Profile.

When you set a pay rate preference for an employee to Trade, Customer, Job, Union, or Employee, the system will look to the appropriate Pay Rate table for the rate.  If a rate cannot be found for the Employee within that table, the system will look to the Employee Pay Rate table for the rate.  If no rate is found there, the system will then look to the Employee Profile for the rate. If no rate is found in the Employee Profile, then the Timesheet Entry program will return an error stating that no rate could be found.

The exception to this rule is when an employee is working on a prevailing wage job that has the 'Rate By Job' checkbox turned on in the Job Work Locations screen (standard Treeview path: US Payroll > Setup > Jobs > Job Work Locations). Please refer to the section on Job Work Locations within the Company Setup of the US Payroll guide for further details. In this case, the system will automatically take the Job Pay Rate regardless of the preference pay rate setting within the Employee Profile.

Trade Pay Rates – Table

Pgm: PYTRDRAT – Trade Pay Rates Maintenance; standard Treeview path: US Payroll > Setup > Pay Rates > Trade

The Trade Pay Rates screen is used to define the pay rates, charge out rates and billing rates for the employees within your company based on their trade. Pay rates are given effective dates so that you have the ability to enter future as well as current pay rates; rates are then only calculated from the date specified.

If you have selected the trade option within the Employee Profile – Pay Rate, Charge Out, and Billing Rate fields, the system will default the rates indicated by the appropriate trade. If the system does not find a rate set up at this level, it will look to the Employee Pay Rates and then to the Employee Profile for the appropriate rate.

Pay Rate Details – Tab

Company/Trade

Enter/select the company and trade for which to define pay rates.

Effective Date

Enter the effective date for the pay rate you are assigning to the company specified in the Selection Criteria section. The system will begin calculating this pay rate from the date specified within this field.

Pay Rate

Enter the default pay rate for employees whose pay rates are set up to default from the trade you are defining on this line.

Charge Out Rate

Enter the default charge out rate for employees whose charge out rates are set up to default from the trade you are defining on this line.

Billing Rate

Enter the default billing rate for employees whose billing rates are set up to default from the trade you are defining on this line.

Non Factor – Checkboxes

Check the 'Non Factor' boxes to have overtime and double overtime rates determined by the Non-Factor OT Rates tab, rather than by the product of the standard rate and the multiplier value.

When these boxes are blank, the system takes the overtime or double overtime hours and multiplies them by the multiplier value defined by the rate code. Please refer to the Rate Code Maintenance screen for these values. Once this has been done, the system multiplies that number by the standard pay and/or charge out and/or billing rate to get the overtime pay and/or charge out and/or billing rate.

Non-Factor OT Rates – Tab

Pgm: PYTRDRAT – Trade Pay Rates Maintenance; standard Treeview path: US Payroll > Setup > Pay Rates > Trade - Non-Factor OT Rates tab

If the ‘Non Factor’ boxes beside the pay, charge out, or billing rate fields are checked on the Pay Rate Details tab, use this tab to enter the actual rates that apply to overtime or double overtime hours.

Customer Pay Rates – Table

Pgm: PYCUSRAT – Customer Pay Rates; standard Treeview path: US Payroll > Setup > Pay Rates > Customer

The Customer Pay Rates screen is used to define the pay rates, charge out rates and billing rates for the employees within your company based on the customer for whom they are working. Pay rates are given effective dates so that you have the ability to enter future as well as current pay rates; rates are then only calculated from the date specified.

If you have selected the Customer option within the Employee Profile – pay rate, charge out and billing rate fields, the system will default the rates indicated by the appropriate customer/trade combination. If the system does not find a rate set up at this level, it will look to the Employee Pay Rates and then to the Employee Profile for the appropriate rate.

Customer

Enter/select the customer whose pay rates will be defined.

Trade Code

Enter/select the trade code to set rates for this customer related to a specific trade.

If you wish to define the pay rates for all trades working on this customer's job, enter the code "ALL" within this field.

Effective Date

Enter the effective date for the pay rate. The system will begin calculating this pay rate from the date specified within this field.

Pay Rate

Enter the default pay rate for employees whose pay rates are set up to default from the customer and trade you are defining on this line.

Charge Out Rate

Enter the default charge out rate for employees whose charge out rates are set up to default from the customer and trade you are defining on this line.

Billing Rate

Enter the default billing rate for employees whose billing rates are set up to default from the customer and trade you are defining on this line.

Job Pay Rates – Table

Pgm: PYJOBRAT – Job Pay Rates Maintenance; standard Treeview path: US Payroll > Setup > Pay Rates > Job

The Job Pay Rates Maintenance screen is used to define the pay rates, charge-out rates and billing rates for the employees within your company based on the jobs on which they are working. Pay rates are given effective dates so that you have the ability to enter future as well as current pay rates; rates are then only calculated from the date specified.

If you have selected the job option within the Employee Profile - pay rate, charge out and billing rate fields, the system will default to the rates indicated by the appropriate job / trade combination. If the system does not find a rate set up at this level, it will look to the Employee Pay Rates and then to the Employee Profile for the appropriate rate.

Job Code

Enter/or select the job for which to define the pay rates.

Cost Code

Enter/select the specific cost code on this job. To define the pay rates for all cost codes on this job, enter the code "ALL" within this field.

Category Code

Enter/select the category code for the specific cost code on this job. To define the pay rates for all categories on this job, enter the code "ALL" within this field.

[Copy Rates to other Job] – Button

Press the [Copy Rates to other Job] button to copy the rates defined by this job to another job. When this button is pressed, a pop-up will appear asking to specify the target job. Enter the job to which the rates will be copied. This button will appear after filling the parameters in this section.

Pay Rate Details – Tab

Employee Code

Enter/select the employee code for the employee whose pay rate will be defined on the job specified within the Selection Criteria section.

To define the pay rates for all employees working on this job, enter the code “ALL” within this field.

Trade Code

Enter/select the trade code to specify a pay rate applicable to that trade on the job specified within the first section.

To define the pay rates for all trades working on this job, enter the code “ALL” within this field.

Shift

Select the shift type to specify a pay rate applicable to that shift on the job specified in the Selection Criteria section. Shifts that are checked on the E-Timesheet tab of the Company Control will be allowed in this screen. Timesheets from Crew or Mechanic Time that are posted against the specified shift type for the job will use the rates defined here.

Effective Date

Enter the effective date for the pay rate being assigned. The system will begin calculating this pay rate from the date specified within this field.

Pay Rate

Enter the default pay rate for employees whose pay rates are set up to default from the job and trade defined on this line.

Charge Out Rate

Enter the default charge-out rate for employees whose charge out rates are set up to default from the job and trade you are defining on this line.

Billing Rate

Enter the default billing rate for employees whose billing rates are set up to default from the job and trade you are defining on this line.

Non Factor – Checkboxes

Check the 'Non Factor' boxes to have overtime and double overtime rates determined by the Non-Factor OT Rates tab, rather than by the product of the standard rate and the multiplier value.

When these boxes are blank, the system takes the overtime or double overtime hours and multiplies them by the multiplier value defined by the rate code. Please refer to the Rate Code Maintenance screen for these values. Once this has been done, the system multiplies that number by the standard pay and/or charge out and/or billing rate to get the overtime pay and/or charge-out and/or billing rate.

Non-Factor OT Rates – Tab

Pgm: PYTRDRAT – Job Pay Rates; standard Treeview path: US Payroll > Setup > Pay Rates > Job - Non-Factor OT Rates tab

If the 'Non Factor' boxes beside the pay, charge out, or billing rate fields are checked on the Pay Rate Details tab, use this tab to enter the actual rates that apply to overtime or double overtime hours.

Union Pay Rates – Table

Pgm: PYUNIRAT – Union Pay Rates; standard Treeview path: US Payroll > Setup > Pay Rates > Union

The Union Pay Rates screen is used to define the pay rates, charge-out rates and billing rates for the employees within your company based on the unions on which they are working. Pay rates are given effective dates so that you have the ability to enter future as well as current pay rates; rates are then only calculated from the date specified.

If you have selected the union option within the Employee Profile pay rate field, the system will default the rates indicated by the appropriate union/trade combination. If the system does not find a rate set up at this level, it will look to the Employee Pay Rates and then to the Employee Profile for the appropriate rate.

Union

Enter/select the union for which the pay rates will be defined.

Job

Enter/select job for which rates are being specified.

Sector

Enter/select job sector for which rates are being specified.

Schedule

Enter/select job rate schedule for which rates are being specified.

Work Location

Enter/select work location for which rates are being specified.

Pay Rate Details – Tab

Trade

Enter/select the trade code to set rates by trade.

To define the pay rates for all trades working on this union, enter the code “ALL” within this field.

Shift

From the drop-down menu, select shift for which rates are being set.

Effective Date

Enter the effective date for the pay rates being defined. The system will begin calculating this pay rate from the date specified within this field.

Pay Rate

Enter the default Pay Rate for employees whose pay rates are set up to default from the union and trade being defined.

Charge Out Rate

Enter the default charge out rate for employees whose charge out rates are set up to default from the union and trade being defined.

Billing Rate

Enter the default billing rate for employees whose billing rates are set up to default from the union and trade being defined.

Non Factor – Checkboxes

Check the 'Non Factor' boxes to have overtime and double overtime rates determined by the Non-Factor OT Rates tab, rather than by the product of the standard rate and the multiplier value.

When these boxes are blank, the system takes the overtime or double overtime hours and multiplies them by the multiplier value defined by the rate code. Please refer to the Rate Code Maintenance screen for these values. Once this has been done, the system multiplies that number by the standard pay and/or charge out and/or billing rate to get the overtime pay and/or charge out and/or billing rate.

Prevailing Wage Rate

The Prevailing Wage Rate field allows for the entry of prevailing wage rates by trade within a union. If the 'Prevailing Wage' checkbox and the 'Davis Beacon' checkbox are both checked on the timesheet job, the higher rate between the Prevailing Wage Pay Rate and the standard Union Rate if the employee’s Pay Rate is Union will be used. If the 'Davis Beacon' checkbox is unchecked, then the system will pick up the pay rate as per the setting of the employee’s Preferred Pay Rate.

Non-Factor OT Rates – Tab

If the 'Non Factor' boxes beside the pay, charge out, or billing rate fields are checked on the Pay Rate Details tab, use this tab to enter the actual rates that apply to overtime or double overtime hours.

Employee Pay Rates – Table

Pgm: PYEMPRAT – Employee Pay Rates Maintenance; standard Treeview path: US Payroll > Setup > Pay Rates > Employee

The Employee Pay Rates Maintenance screen is used to define the pay rates, charge out rates and billing rates for the employees within your company. Pay rates are given effective dates so that you have the ability to enter future as well as current pay rates; rates are then only calculated from the date specified.

If you have selected the employee option within the Employee Profile - pay rates, charge out and billing rate fields, the system will default the rates indicated by the employee pay rates. If the system does not find a rate set up at this level, it will look to the Employee Profile for the appropriate rate.

Trade

Enter/select the trade code to define rates by trade for the employee. If you wish to define the pay rates for all trades in which this employee works, enter the code "ALL" within this field.

Effective Date

Enter the effective date for the pay rate you are assigning to the employee specified in the first section. The system will begin calculating this pay rate from the date specified within this field.

Pay Rate

Enter the default pay rate for this employee when pay rates are set up to default from the employee.

Charge Out Rate

Enter the default charge out rate for employees whose charge out rates are set up to default from the employee.

Billing Rate

Enter the default billing rate for employees whose billing rates are set up to default from the employee.

Non Factor – Checkboxes

Check the 'Non Factor' boxes to have overtime and double overtime rates determined by the Non-Factor OT Rates tab, rather than by the product of the standard rate and the multiplier value.

When these boxes are blank, the system takes the overtime or double overtime hours and multiplies them by the multiplier value defined by the rate code. Please refer to the Rate Code Maintenance screen for these values. Once this has been done, the system multiplies that number by the standard pay and/or charge out and/or billing rate to get the overtime pay and/or charge out and/or billing rate.

Payroll Control – Rate Codes Tab

Pgm: PYCOMPRO – PY Control; standard Treeview path: US Payroll > Setup > Company > Control – Rate Codes tab

The rate codes entered here will determine the default codes used for each of the four types of standard hours. These values are used to identify hour types in various timesheet screens.  The Other Hours field type is also used when recording Leave time.

Normal Hours

Enter/select a default code for normal hours.

Overtime Hours

Enter/select the default overtime hours rate code.

Double Overtime Hours

Enter/select a default double overtime hours rate code.

Other Hours

Enter/select the default other hours rate code.

NOTE: Code values from Rate Code Maintenance screen (standard Treeview path: US Payroll > Setup > Local Tables > Rate Codes) are used to define the type of hours in timesheet entry.