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

Time In Position

 2 Replies
 1 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Mark Petereit
Advanced Member
Posts: 21
Advanced Member
6/20/2019 2:39 PM

    OK, I think I'm missing the forest for the trees on this one.

    I've been given a list of 27 position codes and asked to produce a listing of everyone currently in those position codes and how long each person has been in that position.

    It's the recursing back through the chain of PAEMPPOS records for each person that's baking my noodle. I can't just pull MIN(EFFECT_DATE) because they may have been in that position before with a break in service, and I have to consider ONLY their current length of service.

    Someone, please tell me there's some super-easy way to do this that I'm completely missing.

    thekboose
    Advanced Member
    Posts: 19
    Advanced Member
    6/20/2019 3:04 PM
      Hi... will this not work:
      Run Length of Service Report (PA210) to print a list of the length of
      service for selected employees or groups of employees. Base the length of
      service on an employee date field or on employee position data. When
      calculating
      length of service using employee position data, choose position, job, or union
      code as the basis for the service calculation.

      PA210 options let you create a CSV file you can use with Employee Conversion
      (HR511) of User Field Conversion (HR515) to populate an employee date or date
      user field.
      Mark Petereit
      Advanced Member
      Posts: 21
      Advanced Member
      6/20/2019 3:21 PM

        Thanks. I figured it out by joining HRHISTORY where FLD_NBR = 126 and pulling the most recent BEG_DATE.