Forgot to mention - we use CRE 300 17.1

Hi Jen, Which Union Local are you to report the wages associated with this project too? Are you required to show the wage differential as a separate line item or would it be acceptable to have a single line of time that includes wage differential in the rate when the employee works in that Union?  There is a feature in Payroll that can switch the Union Local automatically (Job Local Tables) to the appropriate Local based on the Job. With that in place you can use a Rate Table in Payroll to retrieve the required pay rates associated with each Union Local.

Article 31185 in our knowledgebase outlines how to create the Job Local Tables.  You can use that to switch the Union Local automatically based on the Job, and then either create or add to a Union Pay Rate table the rates associated with this Local.

Hi Denise! The way we have it set up right now is by using the job tables. We currently have it calculated in sage that when we put in the local with the differential, sage pulls up the hourly rate which consists of their original local wage and the outside local. For example, if I have an employee who is part of Local Union 112 and is working on a job for Local Union 58, Sage is set up that when we input the employee's time we fill in the "Certified Class" column with the wage equalization local (in this example, Local 58), and Sage will calculate their hourly wage based on that. So if the employee makes $15.00 in Local 112 and would get $2.00 extra per hour for doing the Local 58 job, Sage would input $17.00 in the "Rate" column. 

What we're looking to do is instead of having the "rate" be (in this example) $17.00, it would be $2.00 so we can see what the differential is per hour. The problem we run into is that we would have to calculate the amount separately, because if we put in how many hours they did on that job, it wouldn't be correct in reports because that time is already accounted for under the normal rate:  For example, if an employee in the example above worked 1 hour on a Local 58 job, line 1 would show Unit: 1, rate: $15.00, amount: $15.00. The second line item would show Unit 1, rate, $2.00, amount $2.00. when we run reports it would show that this employee worked 2 hours on this wage equalized job rather than 1 hour. 

The other option we have thought of is not calculating the hours in the differential line and just putting the amount. but then wage reports wouldn't necessarily be correct because there are no hours associated with the amount.

Hope this makes things a little clearer and not more confusing..lol

The method to accomplish what you are asking is going to vary depending on if you report the wages, deductions and benefits to Local 112 or to Local 58.  Another possibility is to use the shift differential to trigger the appropriate rate.  if you have a support plan you may want to call in or work with your local consultant to make sure all things are considered. It sounds like right now the Union Local that the time is being coded to is still 112 and that the certified class is what is trigger the wage differential when the Job is associated with Local 58.