• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Position Turnover report

 4 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
RickyY
Veteran Member Send Private Message
Posts: 50
Veteran Member
12/6/2016 11:11 PM

I'm trying to create a position turnover report from Lawson but not sure exactly where to start. I need to have starting positions number, hire/term, and ending employee number for that specific month. Does anyone have a template I can get started on? Crystal / SQL / SSRS, doesn't matter. Thanks.

Margie Gyurisin
Veteran Member Send Private Message
Posts: 538
Veteran Member
12/7/2016 3:12 PM
Do you need to account for movement between positions? Just curious. We do organizational turnover. I've thought about what you are describing. I think you'd need to incorporate the PAEMPPOS table into the query.
Margie Gyurisin
Veteran Member Send Private Message
Posts: 538
Veteran Member
12/19/2016 9:57 PM

Did you get any response to this?

 

How do you want your turnover to appear?  Do you want turnover by month and then cumulative turnover in the same report?

 

I am curious how others may be creating the report.

Mary Porter
Veteran Member Send Private Message
Posts: 337
Veteran Member
12/19/2016 10:07 PM
We create the report by using Dashboard Gear's software - sweet! Turnover in 5 minutes
as opposed to 3 days, both positional and terminations.
Margie Gyurisin
Veteran Member Send Private Message
Posts: 538
Veteran Member
12/19/2016 10:13 PM
If I want to run it for the calendar year 2015, will it display turnover for each month and then give the total for the year? Is it real time or is there a one day delay?