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

IDENTIFYING NESTED GROUPS IN HR55

 2 Replies
 1 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
TBonney
Veteran Member
Posts: 281
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: 281
      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.