We have a significant number of seasonal employees that we have each year. It used to be that Sage would delete terminated employees during the year end process, but that is no longer the case because of this. We're getting ready to import the seasonal employees for this year and if we used or normal import jobs from last year, Sage will have two employees with the same SSN--one is terminated from last year and the other is the newly created employee. We think this could cause some problems and that the cleanest approach would be to reactivate the employees that are the same SSN from the previous year. I think ideally we could run a VI job that will change employee numbers (and departments) and make the employee active, and then we could continue with our other import jobs that are based on employee number.
So, I'm wondering if there is a way do this? My thought is to create a VI job that will read in a file that has the following: SSN, New Dept #, New Empl #. The import job would need to match based on SSN and not the old employee number. I'm not sure how to do that. Am I going at this the right way, or is there an easier/better way to handle this?
Thanks!