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
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
    Posts: 3353
    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
      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
        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
          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
            Veteran 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
              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
                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
                  Posts: 142
                  Veteran Member
                  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
                      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
                        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