• Search Forums
    Advanced Search
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Step and Grade change

 4 Replies
 0 Subscribed to this topic
 69 Subscribed to this forum
Sort:
Author
Messages
Barry
Basic Member
Posts: 8
Basic Member
New Poster
New Poster
Congrats on posting!
5/21/2010 6:06 PM
We currently have 4 base steps for employees. This need to change to 7 steps after July 2010. So an existing employee at step 4 would go to step 7, and an employee at step 3 would go to step 6 and so on. A new employee would start at step 1.

To complicate this, the 4 steps are actually 24 steps depending on the employee's certification status. So step 1-4 is no certification, step 5-8 is one certification, step 9-12 two certifications, ect. With the change, step 1-7 is no certification, step 8-14 is one certification, etc. So a current step 8 becomes a new step 14.

Any thoughts on what is involved in this change? Does each employee have to be manually changed to their new step or is there a simpler way?

Windows Apps and Env 8.03

Thanks,
Barry
Barry
Basic Member
Posts: 8
Basic Member
New Poster
New Poster
Congrats on posting!
5/26/2010 11:29 AM
I didn't get any replies yet, but here is what I did.
Using a spreadsheet of the new step and grade pay_rate I developed a series of queries to add 1848 new entries in the PRSAGDTL table. I then updated the PRSAGHEAD table with the entry for the new schedule and effect_date. Does anyone know if bulk loading like this causes any problems? I don't want to hand enter1848 new values.

Next, I came up with a query to update the employee table to change the paystep entry to match the new scheme for all employees.

I'm an IT guy, not a Lawson user, so I'd be interested to know if this could cause potential issues.

Thanks,
Barry
TRACY
Veteran Member
Posts: 58
Veteran Member
5/26/2010 11:41 AM
Wish I could help for sure. Do you use Excel Addins? I just updated all of our mins/mids/maxs which I would assume is the same file as your pay and step. It worked really well and the best part is it follows the same edits that Lawson uses so you are not able to mess stuff up like you could with SQL etc.
Barry
Basic Member
Posts: 8
Basic Member
New Poster
New Poster
Congrats on posting!
5/26/2010 12:55 PM
We do have the Excel Addins but not being a Lawson user I haven't done anything with it. I can have one of our users have a look. Thanks.
Barry
Basic Member
Posts: 8
Basic Member
New Poster
New Poster
Congrats on posting!
6/2/2010 12:43 PM
Here's the follow-up answer to my question. I found a sample add-in spreadsheet for pr16 at http://solutions.lawson.com/lu/addins/main.htm and modified the vba code to support 45 steps. Works like a charm.