Tracking Years of Experience by Position

I have seen the HR11 benefit date 1-5 being used.

We query the PAEMPPOS table. We did not want another field to maintain and then surely someone would want to know how many years someone was a CNA before they became a RN, or how many years they were a RN before a nurse manager.

The other field that became available in 9.0 was the assignment date for a position. The good new is that if you use it going forward, it is very easy to calculate the LOS.

Thanks for everyones input! We started using Lawson in 2005. So for the employee that were in 2005, their effective dates/assignment dates are their dates of hire.
I wondering how to handle those employees.

thanks

We tract licensure through EMPCODES. There are fields called ACQUIRED-DATE, RENEW-DATE that we use to tract expired licenses. You can use these fields to calculate how long they have been an RN or driver etc. We also created a custom table that house our job codes and all required license codes.

Example: A nurse can have multi job codes with different license requirements.

Having this setup we are able to send emails to those who have expiring licenses.

we are needing to use something like this. I am fairly new at this and I have not been able to produce a table like this. How do I go about creating a similar table?

Arod, this is very complicated. I have to deal with HR just to know what and how many empcodes a particular jobcode has. You would also consider multiple states regulation and mostly how do you define your jobcodes. Is it uniform across companies/process levels? The table is driven mainly by
jobcode/company/process level . A particular jobcode can have a : 1. one or many OR relations. 2. one or many AND relations. 3. combinations or OR and AND relations and some exceptions.

The maintenance screen alone is quite complicated.

Sam

WOW Awesome suggestion! We track licensure on PA22 Certifications. We populate ACQUIRED-DATE and RENEW-DATE. Thank you