This has occurred because they were originally hired as a contractor or on a fixed term contract, and then when they were converted to permanent. We incorrectly terminated their existing profile and created a new profile for them.
The presence of duplicate employee profiles can indeed pose challenges in maintaining clean and accurate data.
Here are the steps to guide you through this process:
Export Data from the Newer Profiles:
Begin by exporting the relevant data from the newer profiles. The reason for this is that the Lifecycle table is difficult to manipulate, meaning that adding older periods to the newer profiles would definitely be trickier.
2. Rehire the employees on their Older Profiles:
This will make sure that they have their Lifecycle tables accurate and with the new "Employed" rows. Before doing this, please apply conditions to your Onboarding Task Lists, so they don't unnecessarily trigger for them with this migration.
3. Data Comparison:
Create reports and compare the data between the newer and older profiles. Identify any data on the newer profile that might be missing from the older profile or that might need to be updated.
4. Import to the Older Profile:
After preparing your spreadsheets with the relevant data that needs updating, import it to the older profiles.
5. Data Validation Post-Import:
Following the import, thoroughly validate the data within the older profile. Ensure that all relevant information has been seamlessly integrated, and there are no unintended consequences of the merge. Once everything is verified, you can go ahead and delete the newer profiles.