Jobs: Wage Determinations - Web

Table of Contents

• Navigating to Wage Determinations
• Wage Determinations
• Creating a New Wage Determination
• Editing a Wage Determination
• Applying a Wage Determination to Positions
• Creating a Non-PWA Position on a PWA Job
• Exporting PWA Information

For Jobs that have Prevailing Wage & Apprenticeship (PWA) Tracking enabled, DSPTCH enables the creation and assignment of Wage Determinations to ensure compliance with PWA standards. To learn how to enable PWA Tracking, please read our Create a Job Help Document.

Navigating to Wage Determinations

To navigate to the Wage Determinations, start by clicking on the Jobs Tab from the primary navigation bar at the top of the screen. Then, click on the relevant Job Card. Next, click the Compliance Tab from the sub-navigation bar at the top of the screen. Lastly, click the Wage Determinations Tab from the menu on the left side of the screen. This will open the Wage Determinations Page.

See the video below for a demonstration:

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 provided by your client, or can be found from official Wage Determinations on Sam.gov

Creating a New Wage Determination

From the Wage Determinations Page, click the "+ New Federal Wage Determination" Button at the top right of the screen.

Please see the video below for a demonstration:

Fill out the Wage Determination information based upon the Wage Determination sheet that applies to your Job.

Using "Laborer: Pipelayer" from the image above as an example, a filled out Wage Determination would look like this:

• Labor Classification (Required):
  • The name of the Labor Classification from the reference document or Wage Determination.
• Classification Code (Optional):
  • 12-digit Alphanumeric ID for the Labor Classification. A classification code can have multiple labor classifications.
• Wage Rate (Optional):
  • The wage rate, in dollars, of the Labor Classification.
• Fringe Rate (optional):
  • The fringe rate, in dollars, of the Labor Classification.
• General Wage Determination (Optional):
  • 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.
• Category (Required):
  • The DOL prevailing Wage Determination category
  • Options: Building, Highway, Heavy, or Residential
• Treasury Guidance (Optional):
  • A file upload for any document with explicitly issued treasury guidance for a given Wage Determination
• Rationale (Optional);
  • A file upload for any document with an explanation for a Wage Determination

After filling out all required fields, click "Save" at the bottom right of the form to create the Wage Determination.

A success message reading, "Wage determination was successfully created" will appear at the bottom right of the screen (pictured below):

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.

Applying a Wage Determination to Positions

After Wage Determinations are created in DSPTCH, they will need to be applied them to Positions to take effect.

To add a Wage Determination to a new Position, locate the Wage Determination dropdown field and select the appropriate Wage Determination from the list that have been created for this Job.

Then, ensure that the "Enable Prevailing Wage and Apprenticeship Tracking" box is toggled on.

See video below for a demonstration:

To edit a Position and add/change a Wage Determination, click the pencil icon on the right side of the Wage Determination. Then, click on the Wage Determination dropdown and add/change the Wage Determination.

Please see video below for a demonstration:

When a Wage Determination is applied onto a Position, it will be visible as a green rectangle on the position. The Wage Determination rate in dollars ($) when moused over.

Creating a non-PWA Position on a PWA Job

To create a new Position with no PWA Tracking, start by clicking "+ New Position". Fill out the required fields for the Position (more information in the Positions Help Document). Then, toggle off the Prevailing Wage and Apprenticeship Tracking box. Lastly, click "Save". The new Position will be created and designated as "Non-PWA"

Please see the video below for a demonstration:

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 click the "Tabulate" button next to the New Wage Determination button. To see how to navigate to the Prevailing Wage Requirements box below, watch the video here.

Clicking Tabulate will open a tabular view of the LCP Export, as seen below.

The table displays data for the entire Job by default. Since LCP only accepts one week at a time, the data must be filtered to the desired week before exporting.

To do so, click on the "Filters" button on the left hand side menu (outlined in the red box). This will pull up some options of columns you can filter by.

The two important ones are "week_end_date" and "class_code".

Once the table is filtered as necessary, export the data by clicking the "Exports" button on the left hand side menu and choosing "to Excel" under "Export all rows."

Uploading exports to LCP Tracker

Once the export is downloaded, upload it to LCP Tracker by following these steps:

1. Login to LCP tracker and navigate to the "1. Payroll Records" tab
2. Click "Upload Records"
3. Choose the Week end date, project and location sections
   1. If there is payroll data syncing with DSPTCH, leave the "Calculate fringes automatically box un-checked
4. Choose the file downloaded from DSPTCH to upload
5. Hit "Upload"

After clicking "Upload", a progress bar should appear with records being uploaded and verified. Upon success, a screen will open to Craft Match or Edit the uploaded records.

WH347

Read our documentation here.

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:

1. Navigate to the "Time" tab. Ensure the correct company payroll and pay period (week) is selected
2. Select all necessary users to export.
3. Click "Exports"
4. Choose "Time Card PW CSV"