Jobs: Prevailing Wage & Apprenticeships - Web
Jobs on DSPTCH with PWA (Prevailing Wage & Apprenticeship) enabled will have a new tab appear. This section displays information related to apprenticeships hours and journeyworkers, and most importantly allows for setup of Prevailing Wage Determinations.
In this section we will go over the setup of Wage Determinations, where to find the required information, how it is applied to positions and how to export data necessary for compliance reporting.
Wage Determinations
A wage determination is a listing of the prevailing wage rates and fringe benefit rates for a specific type of construction work in a given area.
Your Wage Determination rates may be given to you be your client, or you can find official wage determinations on Sam.gov
Creating a new Wage Determination
You can create a new Wage Determination rate by navigating to the Prevailing Wage & Apprenticeships tab on a job and clicking "+ New Wage Determination" near the bottom of the page.
If you do not see the Prevailing Wage & Apprenticeships tab, be sure that you have checked the box to enable it on the job settings.
Fill out the wage determination information based upon the wage determination sheet that applies to your job.
The image below shows an example of a Wage Classification, and where the required values are on the sheet.
Using "Laborer: Pipelayer" from the image above as an example, a filed out wage determination would look like this:
- Labor Classification - The name of the Labor Classification from the reference document or wage determination.
- Classification Code - 12-digit Alphanumeric ID for the Labor Classification. A classification code can have multiple labor classifications.
- Wage Rate - The wage rate, in dollars, of the Labor Classification.
- Fringe Rate - The fringe rate, in dollars, of the Labor Classification.
- General Wage Determination - The reference number of the wage determination document.
- Formatted as <State><Year><Number>/<Revision>
- This can be found on the document, or on the suffix of the url for the wage determination.
Editing a Wage Determination
To edit a wage determination, click the pencil icon near the right hand side.
This will pull up the same menu as creating a wage determination, but with the existing settings.
Changes to the wage rate may cause hourly rates to change on positions. Check out our Hourly Rates article to learn more.
Applying a Wage Determination to Positions
After you have created your Wage Determinations in DSPTCH, you will need to apply them to positions for them to take effect.
When Prevailing Wage and Apprenticeship is enabled on a job, a new option, Wage Determination, will appear on Positions.
You can apply Wage Determinations to new positions, or edit existing positions and add a Wage Determination to them.
Assigning a Wage Determination to the position has affects on its hourly rate. Check out our Hourly Rate article to learn more.
When a Wage Determination is applied onto a position, it will be visible as a green rectangle on the position. You can mouse over this to see the Wage Determination rate in dollars ($)
Exporting PWA info
DSPTCH has exports specific to PWA and government requirements. These include:
- An export in format for LCP Tracker
- A WH347 export
- A payroll-friendly export of hours and rates with Wage Determination names
LCP Tracker
To access the LCP Tracker export, navigate to the Prevailing Wage and Apprenticeship tab and hit the "Tabulate" button next to the New Wage Determination button.
Clicking Tabulate will take you to a grid view of the LCP Export, as seen below.
By default, the table shows data for the entire job. LCP only takes in one week at a time, so we will have to filter the data down to the week we want to export.
To do so, click on the "Filters" button on the menu on the left hand side. This will pull up some options of columns you can filter by.
The two important ones are week_end_date and class_code.
week_end_date will be necessary to export a single week of data. Select one checkbox of the week you want to export.
class_code can be very useful when you have a job with a mix of PWA and non-PWA workers. De-selecting (Blanks) will exclude workers that are not PWA.
Once you have filtered the table as necessary, you can export the data by clicking the "Exports" button on the left hand side menu and choosing "to Excel" under "Export all rows."
It is important to use "to Excel" for the LCP export as that is what LCP Tracker expects.
Uploading exports to LCP Tracker
Once you have downloaded the export, you can upload it to LCP Tracker by following these steps:
- Login to LCP tracker and navigate to the "1. Payroll Records" tab
- Click "Upload Records"
- Choose the Week end date, project and location sections
- If you have payroll data syncing with DSPTCH, you will want to leave the "Calculate fringes automatically box un-checked
- Choose the file you downloaded from DSPTCH to upload
- Hit "Upload"
After you hit "Upload", you should see a progress bar that shows records being uploaded and verified. Upon success, you will be taken to a screen to Craft Match or Edit the uploaded records.
For more information about how to Craft Match or Edit, please refer to LCP Tracker's Documentation
We have seen the upload process run into errors when using the Microsoft Edge browser. If you are getting errors when uploading, try uploading while using Google Chrome.
WH347
Coming soon...
Payroll
The PWA export for payroll includes additional columns the base payroll export does not have, such as fringe amounts and separating out users regular and Prevailing Wage rates.
To access this export, follow these steps:
- Navigate to the "Time" tab. Make sure you are on the correct company payroll and pay period (week)
- Select all necessary users you want to export.
- Click "Exports"
- Choose "Time Card PW CSV"
