US 2021/0065124 A1Published application

Logging of changes in employment stages of a user-defined search pool

AssigneeMicrosoft Technology Licensing, LLC

InventorsRobert Reeves, Michael Jennings

Life of this patent

Estimating the term…

Loading patent…

Abstract

An online system server determines changes in employment stages for the employees of an organization, where the organization may have multiple employees. The online system server may store employee record in an employment history database, and implement an employment history database schema facilitate the determination of the employment movement. The employment history database schema may define that the rows of an employee history database table includes pointers, where the pointers indicate a prior employer or a subsequent employer. Using formulated queries with the employment history database schema, the online system server allows an organization to more accurately log the changes in employment stages for the employees of the organization.

Claims20

Dependent claims

A system comprising:

a machine-readable medium storing computer-executable instructions;
and
at least one hardware processor communicatively coupled to the machine-readable medium that, when the computer-executable instructions are executed, configures the system to perform a plurality of operations comprising:
receiving a request to determine employee stage metrics for at least one organization, wherein the request comprises a plurality of selected filter values, wherein each filter value corresponds to a selected filter;
determining whether the plurality of selected filters comprises a minimum set of predetermined filters;
in response to a determination that the plurality of selected filters comprises no more than the minimum set of predetermined filters, executing a first plurality of database queries on an employment history database using the plurality of selected filter values to obtain a first plurality of employee stage metrics;
in response to a determination that the plurality of selected filters comprises more than the minimum set of predetermined filters, executing a second plurality of database queries on the employment history database using the plurality of selected filter values to obtain a second plurality of employee stage metrics, wherein a database query of the second plurality of database queries uses a selected filter of the plurality of filters not included in the minimum set of predetermined filters;
generating an employment stages report using the first plurality of employee stage metrics or the second plurality of employee stage metrics;
and
presenting the employment stages report to a client device.

7 more elements

A machine-readable medium storing computer-executable instructions that, when the computer-executable instructions are executed, configures a system to perform a plurality of operations comprising:

receiving a request to determine employee stage metrics for at least one organization, wherein the request comprises a plurality of selected filter values, wherein each filter value corresponds to a selected filter;
determining whether the plurality of selected filters comprises a minimum set of predetermined filters;
in response to a determination that the plurality of selected filters comprises no more than the minimum set of predetermined filters, executing a first plurality of database queries on an employment history database using the plurality of selected filter values to obtain a first plurality of employee stage metrics;
in response to a determination that the plurality of selected filters comprises more than the minimum set of predetermined filters, executing a second plurality of database queries on the employment history database using the plurality of selected filter values to obtain a second plurality of employee stage metrics, wherein a database query of the second plurality of database queries uses a selected filter of the plurality of filters not included in the minimum set of predetermined filters;
generating an employment stages report using the first plurality of employee stage metrics or the second plurality of employee stage metrics;
and
presenting the employment stages report to a client device.

4 more elements

Dependencies are inferred from the claim text.