Compensation modeling using plan collections
11620617 · 2023-04-04
Assignee
Inventors
Cpc classification
International classification
Abstract
A system for compensation modeling includes an interface and a processor. The interface is to receive live transactional compensation data. The system processor is to determine a set of compensation assignment plans based at least in part on the live transactional compensation data, determine a compensation model based at least in part on the set of compensation assignment plans, and provide the compensation model.
Claims
1. A system for compensation modeling, comprising: an interface to: receive live transactional compensation data, wherein the live transactional compensation data comprises a plurality of compensation factors associated with an employee; and a processor to: determine, for the employee, an appropriate set of compensation assignment plans from a set of compensation plans based at least in part on the plurality of compensation factors associated with the employee; determine a compensation scheme corresponding to the employee based at least in part on the appropriate set of compensation assignment plans; provide a compensation model that is based on the compensation scheme, wherein the compensation model is based on a first compensation factor of the plurality of compensation factors, wherein the compensation model corresponding to the employee is configured to output a total compensation amount that is based on corresponding amounts associated with each of the compensation assignment plans included in the appropriate set of compensation assignment plans; monitor the live transactional compensation data for one or more changes; determine that the first compensation factor that is based on the live transactional compensation data has changed; and in response to the determination that the first compensation factor that is based on the live transactional compensation data has changed, flag and update the compensation model.
2. The system of claim 1, wherein the set of compensation plans comprises a fixed amount plan.
3. The system of claim 1, wherein the set of compensation assignment plans comprises a percentage-based plan.
4. The system of claim 1, wherein a first plan in the set of compensation plans comprises a dependency on a second plan in the set of compensation plans.
5. The system of claim 1, wherein the processor is further to determine a plan type for a plan in the appropriate set of compensation assignment plans.
6. The system of claim 5, wherein the processor is further to determine a processing order for the appropriate set of compensation assignment plans based at least in part on the plan type.
7. The system of claim 5, wherein the processor is further to determine a processing order for the appropriate set of compensation assignment plans based at least in part on plan dependencies.
8. The system of claim 1, wherein the processor is further to determine dependencies within the appropriate set of compensation assignment plans.
9. The system of claim 1, wherein the processor is further to determine a processing order for the set of compensation assignment plans.
10. The system of claim 9, wherein to determine the compensation scheme, the processor is configured to assign a value to a plan based at least in part on the processing order.
11. The system of claim 1, wherein the compensation scheme of the compensation model is based at least in part on a total compensation value.
12. The system of claim 1, wherein the compensation model is configured to model an employee hire.
13. The system of claim 1, wherein the compensation model is configured to model an employee total compensation change.
14. The system of claim 1, wherein the compensation model is configured to model an employee position change.
15. The system of claim 1, wherein the compensation model is configured to model a change between multiple hypothetical compensation scenarios.
16. A method, comprising: receiving live transactional compensation data, wherein the live transactional compensation data comprises a plurality of compensation factors associated with an employee; determining, for the employee, an appropriate set of compensation assignment plans from a set of compensation plans based at least in part on the plurality of compensation factors associated with the employee; determining a compensation scheme corresponding to the employee based at least in part on the appropriate set of compensation assignment plans; providing a compensation model that is based on the compensation scheme, wherein the compensation model is based on a first compensation factor of the plurality of compensation factors, wherein the compensation model corresponding to the employee is configured to output a total compensation amount that is based on corresponding amounts associated with each of the compensation assignment plans included in the appropriate set of compensation assignment plans; monitoring the live transactional compensation data for one or more changes; determining that the first compensation factor that is based on the live transactional compensation data has changed; and in response to determining that the first compensation factor that is based on the live transactional compensation data has changed, flagging and updating the compensation model.
17. The method of claim 16, wherein the set of compensation assignment plans comprises a fixed amount plan.
18. The method of claim 16, wherein the set of compensation assignment plans comprises a percentage-based plan.
19. The method of claim 16, wherein a first plan in the set of compensation assignment plans comprises a dependency on a second plan in the set of compensation assignment plans.
20. A computer program product embodied in a non-transitory computer readable medium and comprising computer instructions for: receiving live transactional compensation data, wherein the live transactional compensation data comprises a plurality of compensation factors associated with an employee; determining, for the employee, an appropriate set of compensation assignment plans from a set of compensation plans based at least in part on the plurality of compensation factors associated with the employee; determining a compensation scheme corresponding to the employee based at least in part on the appropriate set of compensation assignment plans; providing a compensation model that is based on the compensation scheme, wherein the compensation model is based on a first compensation factor of the plurality of compensation factors, wherein the compensation model corresponding to the employee is configured to output a total compensation amount that is based on corresponding amounts associated with each of the compensation assignment plans included in the appropriate set of compensation assignment plans; monitoring the live transactional compensation data for one or more changes; determining that the first compensation factor that is based on the live transactional compensation data has changed; and in response to the determination that the first compensation factor that is based on the live transactional compensation data has changed, flagging and updating the compensation model.
Description
BRIEF DESCRIPTION OF THE DRAWINGS
(1) Various embodiments of the invention are disclosed in the following detailed description and the accompanying drawings.
(2)
(3)
(4)
(5)
(6)
(7)
(8)
(9)
(10)
(11)
(12)
(13)
DETAILED DESCRIPTION
(14) The invention can be implemented in numerous ways, including as a process; an apparatus; a system; a composition of matter; a computer program product embodied on a computer readable storage medium; and/or a processor, such as a processor configured to execute instructions stored on and/or provided by a memory coupled to the processor. In this specification, these implementations, or any other form that the invention may take, may be referred to as techniques. In general, the order of the steps of disclosed processes may be altered within the scope of the invention. Unless stated otherwise, a component such as a processor or a memory described as being configured to perform a task may be implemented as a general component that is temporarily configured to perform the task at a given time or a specific component that is manufactured to perform the task. As used herein, the term ‘processor’ refers to one or more devices, circuits, and/or processing cores configured to process data, such as computer program instructions.
(15) A detailed description of one or more embodiments of the invention is provided below along with accompanying figures that illustrate the principles of the invention. The invention is described in connection with such embodiments, but the invention is not limited to any embodiment. The scope of the invention is limited only by the claims and the invention encompasses numerous alternatives, modifications and equivalents. Numerous specific details are set forth in the following description in order to provide a thorough understanding of the invention. These details are provided for the purpose of example and the invention may be practiced according to the claims without some or all of these specific details. For the purpose of clarity, technical material that is known in the technical fields related to the invention has not been described in detail so that the invention is not unnecessarily obscured.
(16) A system for compensation modeling is disclosed. The system comprises an interface to receive live transactional compensation data. The system additionally comprises a processor to determine a set of compensation assignment plans based at least in part on the live transactional compensation data, determine a compensation model based at least in part on the set of compensation assignment plans, and provide the compensation model.
(17) In some embodiments, the system for compensation modeling is used to project or determine an employee's compensation based on live transactional compensation data. In various embodiments, the live transactional compensation data comprises a total compensation amount, job-related factors, a set of compensation plans, compensation plan guarantees, ceiling amounts, or any other appropriate compensation data. In some embodiments, an employee's total compensation is divided amongst multiple compensation plans, which in various embodiments comprises a salary base plan, a sales commission plan, a housing stipend, a yearly bonus, and any other appropriate plan. In some embodiments, a compensation plan guarantee stipulates a specific plan to have a minimum monetary value as specified by union contracts, legal requirements, obligations acquired through acquisitions, or other appropriate means. In some embodiments, guaranteed amounts represent a long-term obligation to the company that is an essential factor in budgeting and compensation allocation. In some embodiments, a ceiling amount stipulates an upper limit for an amount that can be allocated to an individual employee for a compensation plan. In some embodiments, a compensation modeling system takes into account compensation factors and compensation plans, which are continuously updated, and automatically calculates the breakdown of the employee compensation.
(18) In some embodiments, the system for compensation modeling comprises a processor to determine a set of compensation assignment plans based at least in part on the live transactional compensation data. In some embodiments, the compensation data comprises a set of plans. In some embodiments, the live transactional compensation data comprises compensation factors. In some embodiments, the processor uses compensation information stored in a computer memory and compensation factors to determine the appropriate set of plans. In some embodiments, the compensation information comprises a description of a compensation plan or information on compensation plan interdependencies. In some embodiments, the compensation plan information comprises information on determining a compensation scheme (e.g. a group of compensation plans) based on one or more compensation factors. The processor determines a compensation model based at least in part on the set of compensation assignment plans and provides the compensation model. In some embodiments, the compensation modeling system receives a total compensation amount for each employee, works out the interdependencies of each component compensation plan, and interprets the component's rules in order to automatically assign a value to each plan, such that the sum total of the values for each component is exactly equal to the assigned total compensation value.
(19) In some embodiments, a client of the system for compensation modeling comprises a compensation administrator, a user of the system, or any other appropriate person or entity. In some embodiments, a compensation modeling system allows a client system to access real-time compensation data in determining employee compensation. In some embodiments, a compensation modeling system allows a client system to pull a specific employee's compensation information and analyze the effect of changes, for example, a job change, on an employee's compensation. In some embodiments, a compensation modeling system saves hours of effort and provides forward looking planning capabilities that help users of a client system maximize compensation outlays. In some embodiments, the compensation modeling system determines plan behaviors and establishes the required processing order. Competing systems require that a compensation professional work out a processing order and assign a processing order number to each of potentially thousands of plans in their system. The compensation modeling system eliminates this requirement for compensation professionals, which saves many hours of effort. In addition, the compensation modeling system accurately computes a worker's salary amount from the context of a set of plan assignments. In some embodiments, the compensation modeling system accurately computes each worker's salary amount from the context of a set of plan assignments. Eliminating the need to compute and assign an individual salary amount for a worker, a set of workers, or each worker in the system is also a large time saver for the compensation professional. The compensation modeling system allows compensation administrators to quickly and accurately run a variety of hypothetical scenarios with real-time data to project the financial impact of future compensation changes to the organization. The combination of the time savings and financial planning support afforded by the system allows large complex multi-national companies to manage and optimize employees' compensation and costs with a single global model and a smaller, more centralized staff, giving these companies a competitive advantage over users of other systems.
(20) In some embodiments, a check is routinely performed to monitor the compensation data for changes. In some embodiments, in the event the compensation data is found to be updated, the compensation model is updated based on the compensation data. In some embodiments, the compensation data is flagged upon being used in determining a compensation plan. In some embodiments, in the event a flagged compensation data is changed, a corresponding compensation model is updated. In various embodiments, a compensation model is triggered to be updated based on an updated compensation data, a revision of the compensation scheme, a revision of the compensation factors, a revision of a compensation plan, a revision of compensation plan interdependencies, or a recalculation of the compensation model (e.g. as triggered by a user).
(21)
(22)
(23) In some embodiments, compensation modeling system updates a compensation model (e.g., compensation model 208, compensation model 216, etc.) based at least in part on an updated input data (e.g., input data comprising data provided by the client system, data provided by data storage system, live transaction data, compensation data, compensation scheme data, compensation pan data, etc.). In some embodiments, an indication indicates that an input data to a compensation model is updated, and based on the indication, the compensation modeling system stores the updated input data, recalculates the model, stores an updated model, and provides the updated model to a client system.
(24)
(25) In the example shown in
(26) In some embodiments, an appropriate set of compensation plans to use in a compensation model is determined by a compensation modeling system by searching for the set of compensation plans associated with a given set of compensation factors. In some embodiments, a compensation scheme comprises 5, 27, 93, or any appropriate number of compensation plans. In some embodiments, a collection of compensation plans or compensation scheme is determined by multiple job-related compensation factors. In various embodiments, a collection of compensation plans or compensation scheme is determined by 3, 25, 80, 140, or any appropriate number of compensation factors. In some embodiments, the compensation factors are continuously updated by an outside server to maintain accuracy. The table below describes compensation factors used in various embodiments:
(27) TABLE-US-00001 Compensation Factor Description Age Returns the Age of a Worker in years. Benefit Group Contains the Benefit Group for the Worker. Blended FTE Returns the Blended FTE for a Worker's Primary Job. Citizenship Status The legal status of the Worker. Collective Agreement The collective agreement(s) of the employee's contract. Collective Agreement Area The Collective Agreement Area for the Compensation Event. Collective Agreement Coefficient The Collective Agreement Coefficient for the Compensation Event. Collective Agreement Group The Collective Agreement Group for the Compensation Event. Collective Agreement Level The Collective Agreement Level for the Compensation Event. Collective Agreement Position The Collective Agreement Position for the Compensation Event. Collective Agreement Position for Worker The Collective Agreement Position for the Compensation Event. Collective Agreement Professional Category The Collective Agreement Professional Category for the Compensation Event. Collective Agreement Step The Collective Agreement Step for the Compensation Event. Company The company for the Worker. Compensation Grade Returns the applicable compensation grade. Compensation Grade Hierarchy Current Compensation Hierarchy Name and Rank for Worker. Compensation Grade Hierarchy Rank Current Compensation Hierarchy Rank value for Worker. Compensation Grade Profile Returns the applicable compensation grade profile. Compensation Plans Contains the compensation plans assigned to an employee. Compensation Step Returns the applicable compensation step. Continuous Service Date Employee service date taking into account breaks in service. Contract Reason The reason(s) of the employee contract. Cost Center Returns the applicable cost center. Country of Location Returns the country location. Country of Location Current Otherwise Last The country of the location for the Worker otherwise the last known Known Location country of the location for the terminated Worker. Custom Organizations The custom organizations for the Worker. External Pay Group The external pay group for the Worker. FTE % The full time equivalent percentage for the Worker. Gender The gender of the Worker. Hire Date Returns the applicable hire date. Is International Assignee Returns true if a Worker is on a current international assignment. Is Manager Returns true if the Worker has a Manager Role. Job Category The job category for the Worker. Job Classifications The complete set of job classifications proposed for the position, and job classifications associated with the job profile. Job Code Returns the applicable job code. Job Exempt The exempt flag for the Worker as of the effective date. This report field will only work for a Worker and does not work with unfilled positions (i.e. it cannot be used in a compensation rule associated with default compensation). Job Family and Job Family Group Returns the applicable job family and job family group. Job Level Returns the applicable job level. Job Profile Returns the applicable job profile. Last Review Rating The overall rating for the last completed employee review. The overall rating comes from the overall section in the manager's evaluation. Length of Service in Months from The number of months of service for the Worker, taking into account Continuous Service Date breaks in service. Length of Service in Partial Years The years of service for the Worker including a partial year represented in 2 decimals. Length of Service in Years The years of service for the Worker. Location Returns the applicable location. Location Hierarchy The location hierarchy for the Worker based on the location of the Worker. For job application, the location hierarchy is based on the location's hiring requirement of the Job Requisition. Management Level Returns the applicable management level. Nationality Contains the primary country of which the Worker is a national. On Leave Returns true if the employee is on leave. Organization Hierarchies The organization hierarchies for the new organizations assigned to the Worker as of the effective date. Organization and Superior Organizations The organization and superior organizations for the position. Organizations Contains all the organizations (e.g. supervisory, cost center, region, etc) for the position, headcount group, or hiring restrictions. Pay Group The proposed pay group for the Worker if available, else current pay group. Pay Rate Type The pay rate type for the Worker. Position Returns the applicable position. Primary Address-Country The country from the worker's primary home address. Primary Termination Reason The primary reason for termination. Rating-Current Performance Review The overall rating for the last completed performance review. The overall rating comes from the overall section in the manager's evaluation. Scheduled Hours Returns the applicable scheduled hours. Secondary Termination Reasons The secondary reasons for the termination. State of Location Returns the applicable state location. Supervisory Organization The supervisory organization for the position. Termination Date The effective date of the worker's termination Termination Date Recent or Future The effective date of the worker's recent or future termination. Termination Reason The reason for termination. Termination Reason Recent or Future The reason for recent or future termination. Time Type Returns the applicable time type. For example, full time or part time. Time in Position The length of time the Worker has been in the position. Unions-Active Contains the Unions that the Worker is currently Active in. Unions-Active and Paid Dues Contains the Unions that the Worker is Active in and is Paying Dues in. Unions-All Contains all Unions that the Worker is associated with, regardless of membership status. Unions-Paid Dues Contains the Unions in which the Worker is currently paying dues. Work Address-Country The country from the work address for the Worker. If the work address is blank, then uses the country of the primary address from the worker's location. Work Shift Returns the applicable work shift. Employee Contract Reason The reason(s) of the employee contract. Employee ID The Employee ID for the Worker. Employee/Contingent Worker Type Returns the applicable Worker sub-type. Worker Identifies the Worker. Worker Active Returns true if Worker is active. Worker Certifications Contains the certifications that a Worker has been issued. Worker Event Returns a Worker Event for certain Compensation Rule Targetable subclasses: For Position, returns the latest Staffing Event on or before the Processing Moment For Position Group return the most recent Position Group Event on or before the Processing Moment For Staffing Event and Position Group Event, returns itself. Worker is Employee Returns true if Worker is an employee.
(28)
(29) In
(30) In some embodiments, a set of compensation plans used to determine a compensation model comprises a fixed amount plan, wherein a plan has an associated fixed monetary amount. In some embodiments, a set of compensation plans comprises a percentage-based plan, wherein a plan has a monetary amount that is a percentage of a percentage basis. In various embodiments, a percentage basis is another plan or multiple plans of the compensation scheme. In some embodiments, for a compensation scheme comprising a percentage-based plan, a first plan of a set of compensation assignment plans comprises a dependency on a second plan or multiple plans in the set of compensation assignment plans. Column 408 comprises percentage bases for percentage-based plans.
(31) In some embodiments, compensation plan information 400 comprises percentage basis information 410. In some embodiments, percentage basis information 410 comprises a percentage basis name and a set of associated plans used as the basis for the percentage basis name. Column 412 comprises percentage basis names and column 414 comprises associated sets of plans used as the basis.
(32) In
(33) In some embodiments, the plan or multiple plans in the sets of plans used as bases must appear in the compensation scheme. In some embodiments, a plan included in the compensation scheme and has a dependency on another plan must be dependent only on plans that are also included in the compensation scheme. In some embodiments, a set of compensation plans used as the basis of a percentage-based plan comprises an unlimited number of plans. In some embodiments, a compensation scheme comprises an unlimited number of interdependent compensation plans. In some embodiments, compensation modeling system 210 of
(34) In some embodiments, compensation plan information 400 comprises information on a base pay plan that has an undetermined amount and is not a percentage of any other plan. In some embodiments, the base pay plan monetary amount is determined by the compensation modeling system based on the compensation scheme and corresponding compensation plan information. In the example shown, plan “SFZ2” is shown to be 12% of “GRNPS1.” Percentage basis name “GRNPS1” refers to a set of plans “PERF” and “VPBC.” In some embodiments, the monetary amount of “SFZ2” is 12% of the monetary amount of the sum of “PERF” and “VPBC.” In some embodiments, an additional field is included in compensation plan information 400, allowing the percentage to be taken from the difference of the total compensation amount and the sum of the monetary amounts of plans included in the percentage basis. For example, in a subtraction case, the monetary amount of “SFZ2” is 12% of the total compensation amount after subtracting the sum of “PERF” and “VPBC.”
(35) In some embodiments, a compensation plan is classified as a specific type of plan. The table below describes various embodiments of compensation plan types.
(36) TABLE-US-00002 Compensation Plan Type Description Salary Plan Defines basic payments. There are three variants: Salary by Amount, Salary by Units Worked (e.g. piece work rates) and Hourly. Period Salary A salary amount that is defined as a time based proportion of the employee's salary. For Plan example, 1 month's salary would mean the employee gets one additional month's worth of salary. Allowance Defines additional amounts that can be paid to an employee. There are three variants: Amount, Plan Percent and Unit based plans. Amount is a fixed amount. The amount for a percent plan is calculated as a percentage of a specified compensation basis. Unit based plans are based on a number of units achieved by an employee. There is a specialized type of plan called a reimbursement allowance which is used to reimburse employees for authorized expenses, for example: college tuition fees. Bonus Plan Defines the amount an employee is likely to be given were they to hit their goals and targets. There are 2 variants: Amount and Percent based. The amount for a percent plan is calculated as a percentage of a specified compensation basis. Stock Plan Defines the stock an employee is likely to be granted were they to hit their goals and targets. There are 3 variants: Amount, Percent and Unit based. Amount represents an amount that will be converted to actual stock units when the strike price is known. Similarly percent plans represent a percentage of a specified compensation basis which is converted to an amount and ultimately to actual stock units. Unit based plans specify the number of shares the employee will be granted. You can also specify different types of long term incentive (e.g. options, RSUs, long term cash, etc.). Commission Used in sales situations to reward employees with amounts based on sales achieved. Plan Calculated A specialized plan where a customer can define custom calculations to determine the amount an Plan employee is paid based on that plan. Retirement Defines the amount of money being paid into a retirement savings plan by the employee and Savings Plan employer. Future A specialized plan for employees who are paid bonuses over a term period. Payment Plan
(37)
(38)
(39) In some embodiments, compensation model request 500 or compensation model request 550 comprise a maximum or minimum plan value. For example, any plan in the compensation scheme determined for the compensation model may not exceed a given maximum monetary value or fall below a given minimum monetary value. In some embodiments, compensation model request 500 comprises a maximum value or minimum value for a given plan in set of plans 504. For example, compensation model request 500 specifies plan “VPBC” has a maximum value of $9000 and plan “SFZ2” has a minimum value of $500. In some embodiments, a modeling system considers maximum and minimum values specified in a model request in determining a compensation model.
(40)
(41)
(42)
(43)
(44)
(45)
(46) Although the foregoing embodiments have been described in some detail for purposes of clarity of understanding, the invention is not limited to the details provided. There are many alternative ways of implementing the invention. The disclosed embodiments are illustrative and not restrictive.