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 Send Private Message
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 Send Private Message
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 Send Private Message
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.