Years of Experience

Would PA19 work for you?

We use an employee user field to capture experience date. It does not give you the by position aspect that you mentioned, we typically are only focused on primary position.

In agreement with Yvonne; PA19 is probably closest fit; although it's job code not position. You can derive "years of experience" based on start/end dates.

Hi Bob: We have the same request. Compensation wanting to track years of experience on employees (both internal & external), as well has across different positions/job codes internally. For example if someone worked here 10 years and was a programmer for 7 and an analyst for 3, they want those values separated out. Just wondering if you found a viable solution to your initial request and what you are doing. The more details the better! Thanks!

Hi Chris – Thank you to those that suggested using the PA19 screen. We looked at several options and we decided to use the PA19 to track the years of experience for Nurses. We use the BEG-DATE field as the date to be used to calculate the number of years of experience.

We have a custom report that can be run in a multiple of different ways that breaks out the selected employees by position code. It shows the basic EE info and current position and a calculated time YY/MM in that position for the current position and then the first previous position held by them. Also shows the effective date of those positions. The YY/MM (years / months) is calculated for experience in that position within our company.

We use two HR11 user fields: one for years of experience and one for the date this value was entered. This allows me to calculate the years of experience + the time elapsed from when it was entered to calculate current years of experience.

(Yes, we could have just used one date field, taking current-date - years-of-experience and entered THAT date, but management wasn't sure the HR specialists entering that data would do the calculation correctly.)

We created three User Fields to track experience and Longevity. EXP_PREV (Previous Experience), EXP_HCPS (Current Company Experience based on Hire Date or Adjusted Hire Date) and EXP_Long (Longevity; Longevity = Previous + Current) When a new employee is first hired, the Hire Date and Adjusted Hire Date are set and are the same. If an employee leaves the company and comes back at some point in the future, the Hire Date (Initial Hire Date) stays the same and the "Adjusted" Hire Date is changed to reflect the "new" Hire date . The Current Company Experience (EXP_HCPS) and Longevity (EXP_Long) are adjusted by subtracting out the time the employee was separated from the company. We also subtract out Leave of Absence (except FMLA leave) from the experience values. We used to adjust all employee's experience values twice a year using Excel and then an Upload to change the Lawson values but, last year we hired a LAWSON consultant who wrote a program that updates the experience values. We added this routine to our nightly Jobs and this program is scheduled to run the Monday after payday twice a month. When the consultant wrote the program to update experience, we started using the Anniversary Date as a "virtual" Hire Date. Example, if the employee was initially hired on 9/1/2010 and then left the company on 8/31/2012 and then was rehired on 9/1/2013, the original hire date would remain 9/1/2010, the Adjusted Hire Date would become 9/1/2013 and the Anniversary date would become (Today's Date - Original Hire Date) = 6 Years then subtract out the year they were separated = 5 Years then, subtract the 5 Years from Today to yield an Anniversary Date of 9/1/2011. So, the Anniversary Date is a "virtual" Hire Date that reflects the actual amount of time in Service. The nightly job then uses the Anniversary Date to calculate the new Longevity and Company experience values. It does so by subtracting Today's Date from the Anniversary Date to yield the number of Days worked, then divides by 365 to yield the number of years of service out to one decimal point. In the example it would be 5.0 years 9/1/2016 - 9/1/2011 = 1827 Days/365 days per year = 5.0 Years