Turnover Reporting

Welcome to LawsonTalk. We hope you enjoy your visit.

You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free. After registration, please check your e-mail within 24 hours for an message from us, read it, and reply to it.

Join our community!

If you're already a member please log in to your account to access all of our features:

Turnover Reporting
Topic Started: Dec 15 2008, 08:02 AM (370 Views)
vc727	Dec 15 2008, 08:02 AM Post #1
Eric Posts: 192 Group: Members Member #493 Joined: March 3, 2006	I have been tasked with crearting a monthly departmental turnover report that tracks ytd totals. The problem I am running into is capturing active employee counts in the past.



mwingmgh17	Dec 15 2008, 09:57 AM Post #2
Member Posts: 24 Group: Members Member #782 Joined: November 1, 2006	Not sure if this will help or not but this is the formula I use for my "as of date" employee count report, I am on 9.0 and the default value for a blank date is 01 01 1753. Looks like last time I pulled it I wanted the counts for 8-1-08 :) and did not include status t4 {EMPLOYEE.ADJ_HIRE_DATE} <= DateTime (2008, 08, 01, 00, 00, 00) and {EMPLOYEE.TERM_DATE} = DateTime (1753, 01, 01, 00, 00, 00) and not ({EMPLOYEE.EMP_STATUS} in ["T4"]) or {EMPLOYEE.ADJ_HIRE_DATE} <= DateTime (2008, 08, 01, 00, 00, 00) and {EMPLOYEE.TERM_DATE}>= DateTime (2008, 08, 01, 00, 00, 00)



3monkeys	Dec 16 2008, 11:30 AM Post #3
Super Member Posts: 168 Group: Members Member #240 Joined: January 13, 2006	It may not help you now, but we've had a process the runs once a month every month that counts the number of employees by emp_status, job class and by department and stores those numbers in a table. So we can look back for as long as that process has been running and we know how many employees there were in total or in a department for each month. Without that you'll have to build the past based on current data, personnel action history, hr history, etc. It gets tricky though with effective dates and history. Somebody that was active 1 month ago may be terminated retroactively today with an effective date that was 2 months ago, such as with a per diem employee. Do they get counted for those months that they never worked but weren't actually terminated yet? In the example above, today that query would pick up anybody that currently meets the criteria. But what did they have back in August? Maybe they were terminated in September, rehired in November, had a status change, etc. I spent waaay too much time making turnover reports and encountered a lot of obstacles brought on just by the way the data is processed. It may not help much but I can share what I have. Everybody's setup is different though so no guarantee it would prove useful. -GW


« Previous Topic · Reporting (NEW!!) · Next Topic »