MIGRATION PAYROLL RECONCILIATION

Abstract

The present disclosure relates generally to data migration and, more particularly, to a system and method for post migration payroll reconciliation. The method of migrating data includes: receiving, by a computer system, projected input codes of a first system for use by a payroll engine; receiving, by the computer system, actual input codes of a second system for use by the payroll engine; comparing, by the computer system, the projected input codes to the actual input codes to determine misalignment of input codes between the first system and the second system; and mapping the misaligned projected input codes to the actual input codes.

Description

Claims

1. A method of migrating data comprising: receiving, by a computer system, projected input codes of a first system for use by a payroll engine;receiving, by the computer system, actual input codes of a second system for use by the payroll engine;comparing, by the computer system, the projected input codes to the actual input codes to determine misalignment of input codes between the first system and the second system; andmapping the misaligned projected input codes to the actual input codes.

2. The method of claim 1, further comprising migrating input data associated with the projected input codes to the second system.

3. The method of claim 2, further comprising streaming the input data from the second system to the payroll engine.

4. The method of claim 1, further comprising identifying and matching sequences of the projected input codes of the first system to the actual input codes of the second system such that the second system understands data associated with the projected input codes.

5. The method of claim 1, further comprising correcting values of non-matching patterns of the projected input codes to the actual input codes, prior to migration of input data to the payroll engine.

6. The method of claim 1, wherein the first system is a legacy human resource system and the second system is a different human resource system, and projected input codes are different than the actual input codes.

7. The method of claim 1, wherein projected input codes are mapped to the actual input codes of the second system.

8. The method of claim 1, further comprising certifying the second system when the projected input codes and the actual input codes are aligned.

9. The method of claim 1, wherein the comparing is performed in an iterative process.

10. The method of claim 1, further comprising measuring a data gap between an expected results and actual results using the actual input codes.

11. The method of claim 1, further comprising comparing input codes of the payroll engine to the actual input codes of the second system.

12. A computer program product comprising one or more computer readable storage media having program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to: receive projected codes associated with input data of a legacy system;receive actual codes of a second system also associated with the input data;match patterns of the projected codes and the actual codes;align any mismatching of the projected codes and the actual codes;migrating the input data of the legacy system to the aligned the actual codes; andsending the input data to a payroll engine for calculation of a payroll.

13. The computer program product of claim 12, further comprising identifying and matching sequences of the projected codes to the actual codes such that a non-originating system understands data associated with the projected codes.

14. The computer program product of claim 13, wherein the aligning comprises correcting values of non-matching patterns of the projected codes to the actual codes, prior to migration of input data to the payroll engine.

15. The computer program product of claim 14, wherein the projected codes are mapped to the actual codes of the non-originating system.

16. The computer program product of claim 14, further comprising certifying the non-originating system when the projected codes and the actual codes are aligned.

17. The computer program product of claim 13, wherein the matching of patterns of the projected codes and the actual codes are performed on an input perspective by comprising the projected codes and the actual codes in an iterative process.

18. The computer program product of claim 13, further comprising comparing input data of the payroll engine to input data that is correlated to the actual code in a non-originating system.

19. The computer program product claim 13, further comprising receiving input data from multiple sources and aligning the input data to the actual codes.

20. A system comprising: a processor, a computer readable memory, one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to:iteratively compare projected input codes to actual input codes;determine misalignment between the projected input codes to actual input codes;map the misaligned projected input codes to the actual input codes; andcorrelate input data previously associated with the projected input codes to the actual input codes; andstream the input data to a payroll engine.