Prev
Next
Forums Lawson S3 HR/Payroll/Benefits

IDENTIFYING NESTED GROUPS IN HR55

Sort:
You are not authorized to post a reply.
Author
Messages
TBonney
Veteran Member
Posts: 277
Veteran Member
6/19/2018 2:11 PM

    Does anyone have a simple way to identify when nested groups exist within an HR55.3 definition?

     

    I want to run a simple SQL query to ID when one group is part of the definition of another group in order to identify how many iterations of the HR155 would need to be run to capture changes made to the nested group.

     

    Thank you in advance!

    Margie Gyurisin
    Veteran Member
    Posts: 538
    Veteran Member
    6/19/2018 2:34 PM
      I have done this before. I believe I found the field number in PADICT (1999) and then queried the PERSGROUP table for that instance.
      TBonney
      Veteran Member
      Posts: 277
      Veteran Member
      6/19/2018 7:59 PM

        Thanks for the reply Margie.

         

        For anyone who is interested, it is the PGSELECT table that identified this for me.

        You are not authorized to post a reply.