Salary/Pay Rate Information - Screens and Tables? -

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3288
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1348
Roger French	1311
mark.cook	1244

Mark6B

New Member

Posts: 1

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

Senior Member

Posts: 3348

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

Cindy

Advanced Member

Posts: 29

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

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

employee with zero pay rate in SQL and amount on screen-1.pdf

Tags: Pay Rates, Salary

Ambrosius

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

Fed Perspective

Veteran Member

Posts: 330

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

Posts: 538

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

Posts: 538

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

Posts: 141

9/30/2016 1:06 PM

Have you looked at the PRRATEHIST table?

Tags: Pay Rates, Salary

Ambrosius

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

Posts: 1

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

Posts: 19

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