10204171

Database Conversion Tool

PublishedFebruary 12, 2019
Assigneenot available in USPTO data we have
Technical Abstract

Patent Claims
22 claims

Legal claims defining the scope of protection, as filed with the USPTO.

1

1. A computer system for migrating human resources data from a first human resources data system to a second human resources data system, the computer system comprising at least one processor, operatively associated memory and a target database in communication with the at least one processor, wherein the computer system is programmed to execute: an import utility programmed to: receive first data from the first human resources system, the first human resources system comprising human resources information from a first business entity that was merged with or acquired by a second business entity for which the second human resources data system corresponds, wherein the first data comprises, for each of a plurality of employees of the first entity, a set of employee attributes according to a format of the first human resources data system; a translation utility programmed to: apply a translation table to the first data to generate translated data according to a target format, wherein the translation table comprises a mapping of employee attribute types according to the first human resources data system format to corresponding employee attribute types according to the target format; generate for the first employee a new computer network credential selected from the group consisting of a network log-in and an e-mail address; store the translated data at the target database; and display a translation screen comprising a translation definition field configured to allow a user to at least one of view and modify parameters of the translation table, the parameters comprising a source server and a source database to allow a user to indicate a location of the target database to be translated; an export utility programmed to: generate an export file comprising the translated data arranged according to a second human resources data system format; and a reports utility programmed to: receive from a user a request to generate a report comprising at least one requested employee attribute type in the first human resources data system format, the second human resources data system format and the target format; derive at least one employee attribute from at least one other employee attribute stored at the target database; and provide to the user the report comprising the at least one derived employee attribute, and wherein the report is based on the translated data in the target database that was translated from employee attribute types according to the first human resources data system format to corresponding employee attribute types according to the target format; wherein a preliminary translation is performed and the first data, before or after the preliminary translation, is used by the reports utility to generate an additional report.

2

2. The system of claim 1 , wherein the translation utility is further programmed to: determine whether each of a plurality of employee attribute types according to the target format correspond to each of the employee attribute types according to the first human resources data system format contained in the first data in the translation table; and upon determining that at least one employee attribute type of the employee attribute types according to the target format has no corresponding employee attribute type according to the first human resources data system format in the translation table, derive the at least one employee attribute type according to the target format based on at least one employee attribute type of the employee attribute types according to the first human resources data system format such that the translation table contains no non-corresponding entries.

3

3. The system of claim 1 , wherein generating the export file comprising the translated data arranged according to the second human resources data system format comprises ordering the translated data to be read by the second human resources data system.

4

4. The system of claim 1 , wherein the translation table defines a first employee attribute type not included in the first data in terms of at least a second employee attribute type that is included in the first data, and wherein applying the translation table to the first data to generate the translated data comprises finding a value for the first employee attribute type for each of the plurality of employees.

5

5. The system of claim 4 , wherein the first employee attribute type indicates whether an employee is full-time or part-time and wherein the second employee attribute type indicates a number of hours per week worked by the employee.

6

6. The system of claim 1 , wherein the import utility is also for receiving the translation table.

7

7. The system of claim 1 , wherein the export utility is also for receiving a request for a file, wherein the request defines the second human resources data system format, and wherein the second human resources data system format defines a plurality of fields of the translated data to be included in the requested file.

8

8. The system of claim 1 , wherein the translation table defines at least one equivalency between an original employee attribute type from the first human resources data system format and a new employee attribute type from the target format and derivation data describing at least a second new employee attribute type from the target format in terms of a plurality of employee attribute types in the first human resources data system format.

9

9. The system of claim 1 , wherein the reports utility is further programmed to receive a selection of at least one employee attribute type according to the target format from a drop down menu.

10

10. The system of claim 1 , wherein the reports utility is further programmed to receive a selection of at least one comparator.

11

11. The system of claim 1 , wherein the translation utility is further programmed to display a change log.

12

12. A computer-implemented method for migrating human resources data from a first human resources data system to a second human resources data system, the method comprising: receiving first data from the first human resources system, the first human resources system comprising human resources information from a first business entity that was merged with or acquired by a second business entity for which the second human resources data system corresponds, wherein the first data comprises, for each of a plurality of employees of the first entity, a set of employee attributes according to a format of the first human resources data system; applying a translation table to the first data to generate translated data according to a target format, wherein the translation table comprises a mapping of employee attribute types according to the first human resources data system format to corresponding attribute types according to the target format; storing the translated data at a target database; displaying a translation screen comprising a translation definition field configured to allow a user to at least one of view and modify parameters of the translation table, the parameters comprising a source server and a source database to allow a user to indicate a location of the target database to be translated; generating an export file comprising the translated data arranged according to a second human resources data system format; generating, for the first employee, a new computer network credential selected from the group consisting of a network log-in and an e-mail address; receiving from a user a request to generate a report comprising at least one requested employee attribute type in the first human resources data system format, the second human resources data system format and the target format; deriving at least one employee attribute from at least one other employee attribute stored at the target database; and providing to the user the report comprising the at least one derived employee attribute, and wherein the report is based on the translated data in the target database that was translated from employee attribute types according to the first human resources data system format to corresponding attribute types according to the target format; wherein the applying a translation table further comprises performing a preliminary translation, wherein the first data is used by the reports utility to generate an additional report.

13

13. The method of claim 12 , further comprising: determining whether each of a plurality of employee attribute types according to the target format correspond to each of the employee attribute types according to the first human resources data system format contained in the first data in the translation table; and upon determining that at least one employee attribute type of the employee attribute types according to the target format has no corresponding employee attribute type according to the first human resources data system format in the translation table, deriving the at least one employee attribute type according to the target format based on at least one employee attribute type of the employee attribute types according to the first human resources data system format such that the translation table contains no non-corresponding entries.

14

14. The method of claim 12 , wherein generating the export file comprising the translated data arranged according to the second human resources data system format comprises ordering the translated data to be read by the second human resources data system.

15

15. The method of claim 12 , wherein the translation table defines a first employee attribute type not included in the first data in terms of at least a second employee attribute type that is included in the first data, and wherein applying the translation table to the first data to generate the translated data comprises finding a value for the first employee attribute type for each of the plurality of employees.

16

16. The method of claim 15 , wherein the first employee attribute type indicates whether an employee is full-time or part-time and wherein the second employee attribute type indicates a number of hours per week worked by the employee.

17

17. The method of claim 12 , further comprising receiving the translation table at a server specified by a user.

18

18. The method of claim 12 , further comprising receiving a request for a file, wherein the request defines the second human resources data system format, and wherein the second human resources data system format defines a plurality of fields of the translated data to be included in the requested file.

19

19. The method of claim 12 , wherein the translation table defines at least one equivalency between an original employee attribute type from the first human resources data system format and a new employee attribute type from the target format and derivation data describing at least a second new employee attribute type from the target format in terms of a plurality of employee attribute types in the first human resources data system format.

20

20. The method of claim 12 , further comprising receiving a selection of at least one employee attribute type according to the target format from a drop down menu.

21

21. The method of claim 12 , further comprising receiving a selection of at least one comparator.

22

22. The method of claim 12 , further comprising displaying a change log.

Patent Metadata

Filing Date

Unknown

Publication Date

February 12, 2019

Inventors

Marcel Schachter
Jerome E. Sindoni

Want to explore more patents?

Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.

Citation & reuse

Analysis on this page is generated by Patentable — an AI-powered patent intelligence platform. AI-generated summaries, explanations, and analysis may be reused with attribution and a visible link back to the canonical URL below. Patent abstracts and claims are USPTO public domain.

Cite as: Patentable. “DATABASE CONVERSION TOOL” (10204171). https://patentable.app/patents/10204171

© 2026 Patentable. All rights reserved.

Patentable is a research and drafting-assistant tool, not a law firm, and does not provide legal advice. Documents we generate are drafts for review by a licensed patent attorney.