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

Salary/Pay Rate Information - Screens and Tables?

 11 Replies
 2 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Mark6B
New Member Send Private Message
Posts: 1
New Member
12/26/2011 10:52 PM
Does anyone have a list of Lawson Screens and Tables that house Salary/Pay Rate information? We have converted most of our LAUA users to LSF security. As most companies I assume, we only want certain users to have access to salary/pay rate information for Exec. Departments. I quickly learned that Lawson does not supply a list of screens and tables that access pay rate/salary information so where restriction were requested, I simply had to look at each screen a user group has access to and see salary info. can be obtained through the screen itself or via drill around. Lawson does not provide this list and I've talked to several different Lawson consultants that did not have the information available. If anyone has compiled a list, I would be grateful if you wouldn't mind sharing it. Thanks
Tags: Pay Rates, Salary
John Henley
Send Private Message
Posts: 3351
12/27/2011 12:49 PM
For the most part you need to secure the EMPLOYEE and PRRATEHIST tables as well as HRHISTORY records that have pay-related field numbers. Working with the data dictionary on this site, you should be able to determine the affected forms. Perhaps you should contact one of the more savvy consultants :)
Tags: Pay Rates, Salary
Thanks for using the LawsonGuru.com forums!
John
Cindy
Advanced Member Send Private Message
Posts: 29
Advanced Member
8/22/2012 6:30 PM
Mark, Did you get a list? We are looking for the same information and would like to have a copy of it if you have it. Thanks, Cindy
Tags: Pay Rates, Salary
Ambrosius
Send Private Message
Posts: 3
9/30/2016 12:18 PM
We see records that show $0 in the database pay_rate column via SQL tool or sqlplus, but shows dollar amounts on HR11 screen.  

select pay_rate from lawson.employee where employee = 10063;

Is HR11 code always use this pay-rate column on the employee table?

Attached is the print shot.

Thanks

Ambrosius 

 

Attachments
Tags: Pay Rates, Salary
Ambrosius
Send Private Message
Posts: 3
9/30/2016 12:18 PM
We see records that show $0 in the database pay_rate column via SQL tool or sqlplus, but shows dollar amounts on HR11 screen.  

select pay_rate from lawson.employee where employee = 10063;

Is HR11 code always use this pay-rate column on the employee table?

Attached is the print shot.

Thanks

Ambrosius 

 

Tags: Pay Rates, Salary
Deleted User
New Member Send Private Message
Posts: 0
New Member
9/30/2016 12:25 PM
Are you using Step and Grade schedules (grade "NEW"?)? If so, the rate of pay comes from that table, and only displays on the HR11, it doesn't actually reside on the employee rate field.
Tags: Pay Rates, Salary
Margie Gyurisin
Veteran Member Send Private Message
Posts: 538
Veteran Member
9/30/2016 12:30 PM
You may be able to get to it from the PAEMPPOS table though.
Tags: Pay Rates, Salary
Margie Gyurisin
Veteran Member Send Private Message
Posts: 538
Veteran Member
9/30/2016 12:34 PM
You can also get it in Lawson through HRWRITER (HR65 series screens)
Tags: Pay Rates, Salary
Karen Sheridan
Veteran Member Send Private Message
Posts: 142
Veteran Member
9/30/2016 1:06 PM
Have you looked at the PRRATEHIST table?
Tags: Pay Rates, Salary
Ambrosius
Send Private Message
Posts: 3
9/30/2016 1:26 PM

Thank you for the update. What do you mean "using Step and Grade schedules (grade "NEW"?)"....

So Rate of Pay on the HR11 not always uses the PAY_RATE column on the employee table?

Thanks

Ambrosius

Tags: Pay Rates, Salary
obullock
New Member Send Private Message
Posts: 1
New Member
1/19/2017 8:03 PM
Speaking of Step and Grade schedules... I am wondering why pay adjustments to schedules do not update the salary that shows up on bn32 screen. Surely we don't have to upload corrections to bn32 every time we adjust a pay schedule...
Tags: Pay Rates, Salary
thekboose
Advanced Member Send Private Message
Posts: 19
Advanced Member
1/19/2017 8:20 PM
When you run PR110 it updates Salary History. Run BN102 to update benefits that are based on salary.
Tags: Pay Rates, Salary