Apparatuses, methods and systems for an employee onboarding automator

• US 9,454,576 B1
• Filed: 10/15/2010
• Issued: 09/27/2016
• Est. Priority Date: 10/16/2009
• Status: Active Grant

• Current Assignee: Iqor US Inc. (IQOR Holdings Incorporated)
• Original Assignee: IQOR Holdings Incorporated
• Inventors: Kapoor, Vikas, Madhavarapu, Abhilash
• Primary Examiner(s): Saeed, Usmaan
• Assistant Examiner(s): Ohba, Melissa M
• Application Number:
  US12/905,179
• Time in Patent Office: 2,174 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24561 Intermediate data storage techniques for performance improvement
• CPC Class Codes: G06F 16/24564 Applying rules; Deductive queries
• CPC Class Codes: G06F 9/451 Execution arrangements for user interfaces
• CPC Class Codes: G06Q 10/105 Human resources

Abstract

The APPARATUSES, METHODS AND SYSTEMS FOR AN EMPLOYEE ONBOARDING AUTOMATOR (hereinafter “EOA”) implement efficient and scalable monitoring, regulation, and allocation of computational processing, data, labor, and/or the like resources within an enterprise. The EOA may facilitate the dissemination and integration of information associated with employee status updates, including the hiring of job candidates, promotions, demotions, and/or the like. The EOA may be configured to automatically update enterprise database systems as needed or desired to reflect employee status changes and/or to transfer employee data from one place to another, such as from a human resources application database where the employee status change may be first entered to a wide variety of other enterprise systems, such as those associated with information technology, facilities, payroll, benefits, legal, marketing, and/or other enterprise departments. The EOA may further be configured to automatically generate a variety of reports based on employee status updates.

Claims

1. An employee onboarding automating processor-implemented method, comprising:

receiving an employee status update trigger indicator during a real-time employee onboarding session;

accessing at least one status update mapping record for access to data items in at least one database, wherein the at least one status update mapping record includes a plurality of status update mapping records, wherein each of the plurality of status update mapping records corresponds to a unique one of a plurality of database identifiers;

querying a database using the update mapping record to create a dynamic data-structure-tracking syntax-configured string associated with the update mapping record, wherein the syntax-configured string consists of a plurality of component parts delimited by syntax separators, and where each part of the string tracks a separate data structure and reflects the hierarchical organizational structure for an enterprise;

utilizing the created dynamic data-structure tracking syntax-configured string and the status update mapping record to generate a request to at least one business grammar rule database containing a plurality of business grammar rules for an enterprise;

obtaining and evaluating at least one business grammar rule for the enterprise from the business grammar rule database, and determining a plurality of additional data sources and table fields that need to be updated based on the evaluated business grammar rule;

selectively evaluating and obtaining at least one universal variable based on the update mapping record and the additional data sources identified after the evaluation of the business grammar rules for the enterprise and based on a presence of user-defined associated universal variables for at least one table field, wherein said universal variables comprise user-defined intermediate data objects that allow access and mapping of logically interrelated table fields in a plurality disparate relational databases and external data sources containing enterprise-specific data during a real-time session, mapping and interconnecting only logically related fields in disparate relational database, and wherein the universal data variables are organized into a hierarchical structure following the business grammar construct for the enterprise, where each segment of the hierarchy follows a user-defined business grammar token type, and wherein the selective evaluation and use of the universal variable for mapping and access is also dependent on the evaluated business grammar rules for the enterprise;

mapping the update mapping record using at least one universal data variable to a plurality of table fields in a plurality of relational databases and disparate data sources; and

updating a first set of table fields linked to the plurality of universal data variables in at least one database corresponding to the at least one data source identifier based on employee data stored in a second set of table fields and based on the at least one status update mapping record and the result of evaluation of the business grammar rules.

2. The method of claim 1, wherein accessing at least one status update mapping record occurs in response to receiving the employee status update trigger indicator.

3. The method of claim 1, wherein accessing at least one status update mapping record occurs before receiving the employee status update trigger indicator and populating a first set of table fields occurs in response to receiving the employee status update trigger indicator.

4. The method of claim 1, wherein the employee status update trigger indicator comprises occurrence of a scheduled employee status update data transaction time.

5. The method of claim 4, wherein the scheduled employee status update data transaction time recurs periodically.

6. The method of claim 1, wherein the employee status update trigger indicator comprises occurrence of an employee status change.

7. The method of claim 6, wherein the employee status change comprises an onboarding, wherein employee data stored in a second set of table fields comprises candidate employee data, and wherein updating a first set of table fields in at least one database corresponding to the at least one database identifier further comprises:

populating the first set of table fields with the candidate employee data.

8. The method of claim 1, wherein the employee status update trigger indicator comprises a transaction request.

9. The method of claim 1, wherein the at least one database identifier corresponds to an information technology resources database.

10. The method of claim 1, wherein the at least one database identifier corresponds to a payroll database.

11. The method of claim 1, wherein the at least one database identifier corresponds to an employee facilities database.

12. The method of claim 1, wherein the second set of table fields are in a human resources database.

13. The method of claim 1, wherein the employee data stored in the second set of table fields is candidate employee data, and wherein updating the first set of table fields further comprises:

populating the first set of table fields with at least a subset of the candidate employee data.

14. The method of claim 1, further comprising:

identifying the at least one status update mapping record based on the employee status update trigger indicator.

15. The method of claim 14, wherein identifying he at least one status update mapping record further comprises:

accessing at least one status update mapping record selection rule based on the employee status update trigger indicator; and

applying the at least one status update mapping record selection rule to employee data associated with the employee status update trigger indicator to identify the at least one status update mapping record.

16. The method of claim 1, wherein at least one of said plurality of universal data variables specifies at least one function that is applied to the at least one data source associated and lined with one or more of said universal data variables.

17. An employee onboarding automating apparatus, comprising:

a memory;

a processor disposed in communication with said memory and configured to issue a plurality of processing instructions stored in the memory, wherein the processor issues instructions to;

receive an employee status update trigger indicator during a real-time employee onboarding session;

access at least one status update mapping record for access to data items in at least one database, wherein the at least one status update mapping record includes a plurality of status update mapping records, wherein each of the plurality of status update mapping records corresponds to a unique one of a plurality of database identifiers;

query a database using the update mapping record to create a dynamic data-structure-tracking syntax-configured string associated with the update mapping record, wherein the syntax-configured string consists of a plurality of component parts, delimited by syntax separators, and where each part of the string tracks a separate data structure and reflects the hierarchical organizational structure for an enterprise;

utilize the created dynamic data-structure tracking syntax-configured string and the status update mapping record to generate a request to at least one business grammar rule database containing a plurality of business grammar rules for an enterprise;

obtain and evaluate at least one business grammar rule for the enterprise from the at least one business grammar rule database, and determine a plurality of additional data sources and table fields that need to be updated based on the evaluated business grammar rule;

selectively evaluate and obtain at least one universal variable based on the update mapping record and the additional data sources identified after evaluation of the business grammar rules for the enterprise and base on presence of at least one user-defined associated universal variables for at least one table field, wherein said universal variables comprise user-defined intermediate data objects that allow access and mapping of logically interrelated table fields in a plurality disparate relational databases and external data sources containing enterprise-specific data during a real-time session, mapping and interconnecting only logically related fields in disparate relational database, and wherein the universal data variables are organized into a hierarchical structure following the business grammar construct for the enterprise and each segment of the hierarchy follows a user-defined business grammar token type, and wherein the use of the universal variable for mapping and access are dependent on the evaluated business grammar rules for the enterprise;

map the update mapping record using at least one universal data variable to a plurality of table fields in a plurality of relational databases and disparate data sources; and

update a first set of table fields linked to the plurality of universal data variables in at least one database corresponding to the at least one data source identifier based on employee data stored in a second set of table fields and based on the at least one status update mapping record and evaluation of the business grammar rules.

19. The apparatus of claim 17, wherein at least one of said plurality of universal data variables specifies at least one function that is applied to the at least one data source associated and lined with one or more of said universal data variables.

18. An employee onboarding automating non-transitory processor-accessible computer memory medium, comprising:

a plurality of processing instructions stored in the computer memory medium and issuable by the processor to;

receive an employee status update trigger indicator during a real-time employee onboarding session;

access at least one status update mapping record access at least one status update mapping record for access to data items in at least one database, wherein the at least one status update mapping record includes a plurality of status update mapping records, wherein each of the plurality of status update mapping records corresponds to a unique one of a plurality of database identifiers;

query a database using the update mapping record to create a dynamic data-structure-tracking syntax-configured string associated with the update mapping record, wherein the syntax-configured string consists of a plurality of component parts, delimited by syntax separators, and where each part of the string tracks a separate data structure and reflects the hierarchical organizational structure for an enterprise;

utilize the created dynamic data-structure tracking syntax-configured string and the status update mapping record to generate a request to at least one business grammar rule database containing a plurality of business grammar rules for an enterprise;

obtain and evaluate at least one business grammar rule for the enterprise from the at least one business grammar rule database, and determine a plurality of additional data sources and table fields that need to be updated based on the evaluated business grammar rule;

selectively evaluate and obtain at least one universal variable based on the update mapping record and the additional data sources identified after evaluation of the business grammar rules for the enterprise and base on presence of at least one user-defined associated universal variables for at least one table field, wherein said universal variables comprise user-defined intermediate data objects that allow access and mapping of logically interrelated table fields in a plurality disparate relational databases and external data sources containing enterprise-specific data during a real-time session, mapping and interconnecting only logically related fields in disparate relational database, and wherein the universal data variables are organized into a hierarchical structure following the business grammar construct for the enterprise and each segment of the hierarchy follows a user-defined business grammar token type, and wherein the use of the universal variable for mapping and access are dependent on the evaluated business grammar rules for the enterprise;

map the update mapping record using at least one universal data variable to a plurality of table fields in a plurality of relational databases and disparate data sources; and

update a first set of table fields linked to the plurality of universal data variables in at least one database corresponding to the at least one data source identifier based on employee data stored in a second set of table fields and based on the at least one status update mapping record and evaluation of the business grammar rules.

20. The non-transitory processor-accessible computer memory medium of claim 18, wherein at least one of said plurality of universal data variables specifies at least one function that is applied to the at least one data source associated and lined with one or more of said universal data variables.