PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/19/2017 3:20 PM by  thekboose
Salary/Pay Rate Information - Screens and Tables?
 11 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Mark6B
Private
Private
New Member
(1 points)
New Member
Posts:1


Send Message:

--
12/26/2011 5: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
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    12/27/2011 7:49 AM
    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 :)
    Thanks for using the LawsonGuru.com forums!
    John
    Cindy
    Application Support Analyst
    George's Inc.
    Advanced Member
    (66 points)
    Advanced Member
    Posts:28


    Send Message:

    --
    08/22/2012 2: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
    Ambrosius
    Oracle DBA
    Private
    (9 points)
    Posts:3


    Send Message:

    --
    09/30/2016 8:18 AM

    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
    Ambrosius
    Oracle DBA
    Private
    (9 points)
    Posts:3


    Send Message:

    --
    09/30/2016 8:18 AM

    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 



     





    Fed Perspective
    Veteran Member
    (922 points)
    Veteran Member
    Posts:330


    Send Message:

    --
    09/30/2016 8:25 AM
    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.
    Margie Gyurisin
    Private
    Private
    Veteran Member
    (1275 points)
    Veteran Member
    Posts:473


    Send Message:

    --
    09/30/2016 8:30 AM
    You may be able to get to it from the PAEMPPOS table though.
    Margie Gyurisin
    Private
    Private
    Veteran Member
    (1275 points)
    Veteran Member
    Posts:473


    Send Message:

    --
    09/30/2016 8:34 AM
    You can also get it in Lawson through HRWRITER (HR65 series screens)
    Karen Sheridan
    Private
    Private
    Veteran Member
    (325 points)
    Veteran Member
    Posts:123


    Send Message:

    --
    09/30/2016 9:06 AM
    Have you looked at the PRRATEHIST table?
    Ambrosius
    Oracle DBA
    Private
    (9 points)
    Posts:3


    Send Message:

    --
    09/30/2016 9:26 AM

    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



    obullock
    HRIS Analyst
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    01/19/2017 3: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...
    thekboose
    HRIS Manager
    The Federal Government
    Basic Member
    (30 points)
    Basic Member
    Posts:10


    Send Message:

    --
    01/19/2017 3:20 PM
    When you run PR110 it updates Salary History. Run BN102 to update benefits that are based on salary.
    You are not authorized to post a reply.