Prevailing Wages- Updates

• Prevailing wages have two permissions associated for the ability to utilize the functionality.​

• 6410 = PrevailingWageType (This is a universal permission and will be applied to Office Pro plans. This is the general permission to determine if prevailing wages show in columns and on project edit)​

• 6420 = PrevailingWageTypeAdmin (This is an individual user permission that grants access to data table maintenance and the ability to add/edit/remove prevailing wages)

   

  Within Data Table Maintenance, prevailing wages can be added, edited, and deleted.

   

• Within Data Table Maintenance, users can review previously created prevailing wages, or create new ones.​

• Within a Prevailing Wage, users have the following data to input:

• Prevailing Wage Name (Required)​

• Description (Optional)​

• Active/Inactive Status – Defines if they see the prevailing wage available for selection on projects and tasks​

• Regular Name (Required)- this is the prevailing wage name that will be outputted on payroll reports when the calculated wage type is regular/standard​

• Overtime/Other Name (Required) - this is the prevailing wage name that will be outputted on payroll reports when the calculated wage type is anything other than regular/standard.​

• Delete – There is an activity check on delete and can only be performed if there is no activity (aka this prevailing wage is not set on projects/tasks)

   

• Within a project, a default prevailing wage can be set. This defaults to none applied but can be chosen from the Project Edit>Financial Tab> Prevailing Wage​

• This list will include the ability to select all Active Prevailing wages ​

• The prevailing wage set on the project is also visible from the portfolio view adding the column “Prevailing Wage” into the column selection

   

   For a given task, users have the ability to set the appropriate prevailing wage at the task level (If needed)​

• The prevailing wage for the payroll reports will use the task override if provided, if not it will go to the Prevailing Wage set on the Project​

• Users can choose a different prevailing wage than what is set on the project​

• Users can also choose to “Exclude” prevailing wage for the task if it is a task that should NOT get prevailing wages set for payroll reports​

• Prevailing wages can be set within the project itself, or from the “Tasks” area

   

  

• For Payroll reports, the following logic is applied​

• When to determine if a prevailing wage should be available on the payroll report?​

• If a prevailing wage is set at the project level OR if a prevailing wage is set at the task level​

• If neither are present, we continue to show the auto-calculated wage types in the payroll report​

• If “Exclude” for a specific task is set for prevailing wage, the auto-calculated wage types will be displayed in the payroll reports​

• How to determine which prevailing wage name to display (Regular Name or Overtime/Other name)​

• If the time record has an auto-calculated wage type of the default “Regular” or standard type (aka not overtime, double-time, etc) the “Regular Name” of the associated Prevailing Wage will be displayed​

• If the time record has an auto-calculated wage type for anything other than Regular (aka it IS overtime, double-time, etc) the “Overtime/Other Name” from the associated Prevailing Wage is displayed.

• In the example below, I have a task without a specific task override, so it will assume the project prevailing wage (which is set to Davis Bacon Wage Laws)​

• This time entry has a total of 2 hours, one regular and the other Overtime. You can see from the example below the associated prevailing wage type will be displayed in the Wage Type column

 

 

 

If I were to take that same task and time entry but change the prevailing wage on the task to “SC Specific”, you will see the wage types now assume that prevailing wage type and the associated prevailing wage names based on the time entry and calculated wage types

 

 If I were to take that same task and set “Exclude” prevailing wages on the task, you will see that the standard wage types are then displayed for the wage type fields on payroll reports

Additional Requests in Release

• Adjust bid import abbreviations for bid import template for Estimated Quantity Units and adjust inputs to use the new versions​

• acre ac>Acre​

• y3 cy>Cubic Yard​

• ft2 sf>Square Foot​

• y2 sy>Square Yard​

• t tn>ton​

• ut times>Unit Time​

  0 hour time entries will now be displayed in Detailed Payroll Report

  

  

• Break times on Time entries are now considered into the “Total” time calculation and will be saved to the time object appropriately​

• This example has a 4 hour total duration time entry, however since there is a 2 hour break, the total calculated “Working minutes” will be set to 2 hours​

• Note- when users are editing clock in/clock out times, it will function similar to SCF where the underlying Total Duration will be retained, however the total time will be calculated from Total Duration- Total Break Times