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
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
    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
      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
        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
          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?