Additional Pay per Hour

 7 Replies
 1 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
MSheldon
Basic Member Send Private Message
Posts: 5
Basic Member

We have a location where we are required to pay an additional hourly amount for employees who do not qualify for our vacation plan and an additional amount per hour for employees who do not elect to carry our insurance.  We would like to keep the base pay amount (shown under pay in the HR11) and then show separate pay codes that calculate the additional amount based on hours loaded into the PR36.  Is it possible to do this without a manual calculation?

Example:  Hourly rate = $9.00, No health coverage = $0.50, No vacation = $1.50

If the employee works 40 hours in a week we would like to see:

40 Hours (regular) x $9.00

40 Hours (health premium pay) x $0.50

40 Hours (vacation premium pay) x $1.50

Instead of having to lump it all together where we would see 40 Hours x $11.00.  Is it possible to do this for 1 location only without having to manually add the additional pay codes each pay period?

Jimmy Chiu
Veteran Member Send Private Message
Posts: 641
Veteran Member
I would create 2 additional employee groups. One emp group with no health premium and one emp group that do not qualify for vacation plan for that one location.

So after you put in all the regular hours. Do a join query and export timerecord of the first employee group (no health premium). You just need to company/employee/paycode/hours/transDate etc. Change the pay code and addins upload that back in.

Repeat the same for the (no vacation plan)

If you want a more automatic time entry. you can customize PR36 to check if the employee has no health premium or not quality vacation plan etc. When it enter your regular time, it writes additional health premium pay time record + vacation premium pay time record automatically.
MSheldon
Basic Member Send Private Message
Posts: 5
Basic Member
We upload the time records from our time keeping system using an interface that loads them into the PR35.2.

Can the customization be done there or only after it is released to the PR36?

Also, how do you set the system up to check that in the PR36? Is it on another screen?
Karen Ploof
Veteran Member Send Private Message
Posts: 118
Veteran Member
If you're going to code customization anyway, I'd look at using the custom calculation type on the pay code with code to calculate the amount.
MSheldon
Basic Member Send Private Message
Posts: 5
Basic Member
I am planning to set up pay codes for the new amounts that need to be paid.

Are you saying that you can customize the pay code look at what has been loaded?
Karen Ploof
Veteran Member Send Private Message
Posts: 118
Veteran Member
My experience has been that if we define a pay code to use the X-Custom Calculation type, a programmer can write a user-exit that can do ANYTHING :-). It's been a lot of years, but I think I had a union deduction that required we multiply the # of hours worked for pay types in a specific pay class by a flat rate. Sounds pretty similar to your situation.

Ragu Raghavan
Veteran Member Send Private Message
Posts: 477
Veteran Member
In my experience, a user exit is best used when it affects only one pay code. In this case, looks like based on hours in one pay code, the amounts in two different pay codes will be affected. Probably better to use a custom process (4GL, process_flow etc) that will run after the import. Look up certain pay codes, create new time records with the appropriate pay-code/hours/amt
Karen Ploof
Veteran Member Send Private Message
Posts: 118
Veteran Member
Good to have an opinion on the different options. Thanks, I'll keep this in mind.

Karen