IP Library Granted Patent US 12,002,112
Granted Patent B2
US 12,002,112 · App. 17/373,233 · Granted Jun 4, 2024

Data migration and reporting for payroll systems

Inventors: Saurav Shah (Karnataka, IN); Kshitij Bathla (Karnataka, IN)
Assignee: People Center, Inc.
G06Q40/125G06Q10/1091
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,002,112
App. No.
17/373,233
Granted
Jun 4, 2024
Kind
B2
Abstract

Methods, systems, devices, and tangible non-transitory computer readable media for generating and validating reports. The disclosed technology can access organizational data that can include organizational reports associated with payrolls of an organization. The organizational reports can include fields respectively associated with entries. Formats of the organizational reports can be determined based at least in part on configurations of the fields. Validated reports can then be generated based on the performance of validation operations including evaluation of a validity of each of the organizational reports. The validated reports can include a portion of the fields and a portion of the entries. Furthermore, indications associated with the validity of the portion of the entries of the validated reports that were evaluated can be generated.

Claims (83)

1. A computing system that implements an organizational management platform that controls and leverages one or more sets of organizational data to manage organizational applications for one or more organizations that respectively correspond to the one or more sets of organizational data, the computing system comprising:

one or more processors;

one or more databases that collectively store the one or more sets of organizational data, wherein the one or more sets of organizational data respectively comprise an object graph data structure comprising a plurality of objects that respectively correspond to a plurality of entities of an organization of the one or more organizations; and

one or more non-transitory computer-readable media that store instructions that, when executed by the one or more processors, cause the computing system to perform operations, the operations comprising:

accessing organizational data from a set of the one or more sets of organizational data, the organizational data corresponding to the organization and comprising one or more payroll reports associated with one or more payrolls of the organization, wherein the one or more payroll reports comprise one or more fields respectively associated with one or more entries;

generating a graphical user interface (GUI) for presentation on a display device, the GUI comprising one or more first interface elements respectively associated with the one or more fields and one or more second interface elements respectively associated with the one or more entries;

determining one or more formats of the one or more payroll reports based at least in part on one or more configurations of the one or more fields;

generating one or more validated reports based at least in part on performance of one or more validation operations comprising evaluation of a validity of each of the one or more payroll reports, wherein the one or more validated reports comprise a portion of the one or more fields and a portion of the one or more entries; and

generating one or more indications associated with the validity of the portion of the one or more entries of the one or more validated reports that were evaluated,

wherein evaluation of the validity of each of the one or more payroll reports comprises traversing the object graph data structure to validate at least one of the one or more fields or the one or more entries against one or more attribute values of at least one object of the plurality of objects, and

wherein evaluation of the validity of each of the one or more payroll reports for migration of data from a first application of the organizational applications to a second application of the organizational applications comprises:

evaluating, by traversing the object graph data structure, one or more fields and one or more entries from a first payroll report associated with the first application to determine whether the one or more fields and the one or more entries from the first payroll report are valid according to at least one of:

a result of the computing system comparing a format or syntax of the one or more fields and the one or more entries against an expected format or syntax of the one or more fields and the one or more entries, or

a result of the computing system evaluating a consistency of the one or more fields and the one or more entries against properties of other fields and entries, and

in response to the computing system determining at least one of the one or more fields or the one or more entries from the first payroll report are invalid based on the evaluating, within the GUI altering a presentation on the display device of the one or more first interface elements or the one or more second interface elements by:

automatically changing a visual characteristic associated with the at least one of the one or more fields or the one or more entries or automatically modifying the at least one of the one or more fields or the one or more entries so as to be valid, and

generating, for presentation on the display device via the GUI, a first validated payroll report associated with the second application, the first validated payroll report including the changed visual characteristic associated with the at least one of the one or more fields or the one or more entries or the modified at least one of the one or more fields or the one or more entries.

2. The computing system of claim 1 , wherein comparing the format or syntax of the one or more fields and the one or more entries against the expected format or syntax of the one or more fields and the one or more entries comprises:

comparing one or more entries from the first payroll report to one or more fields respectively associated with the one or more entries; and

determining, based at least in part on the comparison, that the one or more entries with a format that does not correspond to the one or more fields are not valid.

3. The computing system of claim 1 , wherein the one or more indications comprise one or more indications that a field is valid, one or more indications that a field is not valid, one or more indications that an entry is valid, or one or more indications that an entry is not valid.

4. The computing system of claim 1 , wherein comparing the format or syntax of the one or more fields and the one or more entries against the expected format or syntax of the one or more fields and the one or more entries comprises:

determining an entity of the plurality of entities is associated with the first payroll report among a plurality of payroll reports, wherein the entity is associated with one or more fixed entries; and

determining that a portion of the first payroll report is not valid when the one or more fixed entries associated with the entity from the first payroll report is different compared to the plurality of payroll reports.

5. The computing system of claim 4 , wherein the entity comprises an employee of the organization or a department of the organization.

6. The computing system of claim 1 , wherein

the second application includes information and/or data associated with one or more formats and/or one or more configurations for one or more fields associated with one or more payroll reports associated with the second application,

each of the one or more fields from the first payroll report is associated with one or more field properties comprising a field type, a field length, or a field creation time, and wherein evaluating the consistency of the one or more fields from the first payroll report comprises:

evaluating a consistency of the one or more field properties with respect to each of the one or more fields from the first payroll report against field properties for corresponding fields from across the one or more payroll reports associated with the second application.

7. The computing system of claim 1 , wherein

the second application includes information and/or data associated with one or more formats and/or one or more configurations for one or more entries associated with one or more payroll reports associated with the second application,

each of the one or more entries from the first payroll report is associated with one or more entry properties comprising an entry type, an entry length, or an entry creation time, and wherein evaluating the consistency of the one or more entries from the first payroll report comprises:

evaluating a consistency of the one or more entry properties with respect to each of the one or more entries from the first payroll report against entry properties for corresponding entries from across the one or more payroll reports associated with the second application.

8. The computing system of claim 1 , further comprising:

providing, for display on the display device of the computing system, a first textual indication that an entry among the one or more entries is valid in response to determining the entry among the one or more entries from the first payroll report is valid based on the evaluating, and

providing, for display on the display device of the computing system, a second textual indication that an entry among the one or more entries is invalid in response to determining the entry among the one or more entries from the first payroll report is invalid based on the evaluating.

9. The computing system of claim 1 , wherein the operations further comprise:

determining one or more types of invalidity for each of the one or more entries that are not valid, wherein the one or more indications comprise one or more invalidity indications associated with the one or more types of invalidity for each of the one or more entries that are not valid.

10. The computing system of claim 9 , wherein the operations further comprise:

generating, based at least in part on the one or more types of invalidity, one or more indications comprising one or more descriptions of the one or more types of invalidity of the one or more entries.

11. The computing system of claim 9 , wherein the one or more types of invalidity comprise invalid syntax, field-entry inconsistency invalidity, and quantitative invalidity.

12. The computing system of claim 1 ,

wherein

in response to automatically changing the visual characteristic associated with the at least one of the one or more fields or the one or more entries, the one or more first interface elements are configured to receive one or more inputs to modify the one or more fields determined to be invalid or the one or more second interface elements are configured to receive one or more inputs to modify the one or more entries determined to be invalid, and

the method comprises:

receiving the one or more inputs to modify the at least one of the one or more fields or the one or more entries determined to be invalid; and

modifying the at least one of the one or more fields or the one or more entries determined to be invalid, based at least in part on the one or more inputs, wherein modifying the at least one of the one or more fields or the one or more entries comprises deleting an entry of the one or more entries, adding a new entry to the one or more entries, or changing an entry of the one or more entries.

13. The computing system of claim 1 , wherein the automatically modifying the at least one of the one or more fields or the one or more entries comprises deleting an entry of the one or more entries, adding a new entry to the one or more entries, or changing an entry of the one or more entries.

14. The computing system of claim 1 , wherein changing the visual characteristic comprises providing a highlight around the at least one of the one or more fields or the one or more entries that are invalid, or providing one or more colors around at least one of the one or more fields or the one or more entries that are invalid.

15. A computer-implemented method for implementing an organizational management platform that controls and leverages one or more sets of organizational data to manage organizational applications for one or more organizations that respectively correspond to the one or more sets of organizational data, the computer-implemented method comprising:

maintaining, by a computing system comprising one or more processors, the one or more sets of organizational data, the one or more sets of organizational data respectively comprising an object graph data structure comprising a plurality of objects that respectively correspond to a plurality of entities of an organization of the one or more organizations;

accessing, by the computing system, organizational data from a set of the one or more sets of organizational data, the organizational data corresponding to the organization and comprising one or more organizational reports associated with the organization, wherein the one or more organizational reports comprise one or more fields respectively associated with one or more entries;

generating, by the computing system, a graphical user interface (GUI) for presentation on a display device, the GUI comprising one or more first interface elements respectively associated with the one or more fields and one or more second interface elements respectively associated with the one or more entries;

determining, by the computing system, one or more formats of the one or more organizational reports based at least in part on one or more configurations of the one or more fields;

generating, by the computing system, one or more validated reports based at least in part on performance of one or more validation operations comprising evaluation of a validity of each of the one or more organizational reports, wherein the one or more validated reports comprise a portion of the one or more fields and a portion of the one or more entries; and

generating, by the computing system, one or more indications associated with the validity of the portion of the one or more entries of the one or more validated reports that were evaluated,

wherein evaluation of the validity of each of the one or more organizational reports comprises traversing, by the computing system, the object graph data structure to validate at least one of the one or more fields or the one or more entries against one or more attribute values of at least one object of the plurality of objects, and

wherein evaluation of the validity of each of the one or more organizational reports for migration of data from a first application of the organizational applications to a second application of the organizational applications comprises:

evaluating, by traversing the object graph data structure, one or more fields and one or more entries from a first organizational report associated with the first application to determine whether the one or more fields and the one or more entries from the first organizational report are valid according to at least one of:

a result of the computing system comparing a format or syntax of the one or more fields and the one or more entries against an expected format or syntax of the one or more fields and the one or more entries, or

a result of the computing system evaluating a consistency of the one or more fields and the one or more entries against properties of other fields and entries, and

in response to the computing system determining at least one of the one or more fields or the one or more entries from the first organizational report are invalid based on the evaluating, within the GUI altering a presentation on the display device of the one or more first interface elements or the one or more second interface elements by:

automatically changing a visual characteristic associated with the at least one of the one or more fields or the one or more entries or automatically modifying the at least one of the one or more fields or the one or more entries so as to be valid, and

generating, for presentation on the display device via the GUI, a first validated organizational report associated with the second application, the first validated organizational report including the changed visual characteristic associated with the at least one of the one or more fields or the one or more entries or the modified at least one of the one or more fields or the one or more entries.

16. The computer-implemented method of claim 15 , wherein the one or more entries from the first organizational report comprise one or more payroll entries for one or more employees of the organization.

17. The computer-implemented method of claim 15 , wherein the one or more formats are based at least in part on one or more applications that generate the one or more organizational reports.

18. One or more tangible non-transitory computer-readable media storing computer-readable instructions that when executed by one or more processors cause the one or more processors to perform operations, the operations comprising:

maintaining one or more sets of organizational data that respectively correspond to one or more organizations, the one or more sets of organizational data respectively comprising an object graph data structure comprising a plurality of objects that respectively correspond to a plurality of entities of an organization of the one or more organizations;

accessing organizational data from a set of the one or more sets of organizational data, the organizational data corresponding to the organization and comprising one or more organizational reports associated with one or more payrolls of the organization, wherein the one or more organizational reports comprise one or more fields respectively associated with one or more entries;

generating a graphical user interface (GUI) for presentation on a display device, the GUI comprising one or more first interface elements respectively associated with the one or more fields and one or more second interface elements respectively associated with the one or more entries;

determining one or more formats of the one or more organizational reports based at least in part on one or more configurations of the one or more fields;

generating one or more validated reports based at least in part on performance of one or more validation operations comprising evaluation of a validity of each of the one or more organizational reports, wherein the one or more validated reports comprise a portion of the one or more fields and a portion of the one or more entries; and

generating one or more indications associated with the validity of the portion of the one or more entries of the one or more validated reports that were evaluated,

wherein evaluation of the validity of each of the one or more organizational reports comprises traversing the object graph data structure to validate at least one of the one or more fields or the one or more entries against one or more attribute values of at least one object of the plurality of objects, and

wherein evaluation of the validity of each of the one or more organizational reports for migration of data from a first application associated with the organization to a second application associated with the organization comprises:

evaluating, by traversing the object graph data structure, one or more fields and one or more entries from a first organizational report associated with the first application to determine whether the one or more fields and the one or more entries from the first organizational report are valid according to at least one of:

a result of the computing system comparing a format or syntax of the one or more fields and the one or more entries against an expected format or syntax of the one or more fields and the one or more entries, or

a result of the computing system evaluating a consistency of the one or more fields and the one or more entries against properties of other fields and entries, and

in response to the computing system determining at least one of the one or more fields or the one or more entries from the first organizational report are invalid based on the evaluating, within the GUI altering a presentation on the display device of the one or more first interface elements or the one or more second interface elements by:

automatically changing a visual characteristic associated with the at least one of the one or more fields or the one or more entries or automatically modifying the at least one of the one or more fields or the one or more entries so as to be valid, and

generating, for presentation on the display device via the GUI, a first validated organizational report associated with the second application, the first validated organizational report including the changed visual characteristic associated with the at least one of the one or more fields or the one or more entries or the modified at least one of the one or more fields or the one or more entries.

19. The one or more tangible non-transitory computer-readable media of claim 18 , wherein the one or more configurations comprise one or more positions of the one or more fields within the one or more organizational reports.

20. The one or more tangible non-transitory computer-readable media of claim 19 , wherein the one or more positions comprise one or more absolute positions of the one or more fields or one or more relative positions of the one or more fields.

Assignments (2)
CORRECTIVE ASSIGNMENT TO CORRECT THE LINES 1 AND 4 OF THE CORRESPONDENCE DATA PREVIOUSLY RECORDED AT REEL: 056834 FRAME: 0318. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT . Recorded Aug 30, 2021
From: SHAH, SAURAV; BATHLA, KSHITIJ
To: PEOPLE CENTER, INC.
Reel/Frame 057353/0625 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 13, 2021
From: SHAH, SAURAV; BATHLA, KSHITIJ
To: PEOPLE CENTER, INC.
Reel/Frame 056834/0318 →
Continuity (1)
Related Publication 20230011565A1 · Jan 12, 2023