The present invention relates to methods and systems for determining and controlling allocation of member compensation, such as bonuses.
In many organizations, such as financial services companies, a large part of an employee's compensation is bonus-based. As a general matter, managers are charged with allocating bonus money to their direct reports. However, problems arise when mangers allocate more bonus money than is available. In addition, higher level managers may want to have access to, and possibly control over, money allocated as bonuses to lower-level employees within their reporting structure. Finally, the window of time within which bonuses must be determined and allocated is often short; many important decisions must be made within this time period.
Thus, there is a need for an efficient method for determining and allocating bonus-based employee compensation, with improved transparency, that avoids overdraws.
The present invention is directed to a method and system for determining compensation to be paid to one or more members of an organization. The organization is comprised of a plurality of members organized in accordance with a hierarchical structure comprising one or more first-level members, one or more second-level members below the first-level members in the hierarchical structure, and one or more third-level members below the second-level members in the hierarchical structure. A pool of money to be paid to the members in the organization as compensation is identified. At least a first portion of the pool is assigned to the first-level member. Upon being assigned the first portion, the first-level member determines a second portion of the pool from the first portion to be distributed to one or more members below the first-level member in the hierarchical structure and/or an amount from the first portion to be paid to one or more members below the first-level member in the hierarchical structure. The portion of the pool is assigned to the second-level member. Upon being assigned the second portion, the second-level member determines a third portion of the pool from the second portion to be distributed to one or more members below the second-level member in the hierarchical structure and/or an amount from the second portion to be paid to one or more members below the second-level member in the hierarchical structure. The third-level member is allocated the amount from the first portion and/or the amount from the second portion to be paid as compensation. The first-level member is provided view and/or edit access to the third portion and/or the amount from the second portion.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory and are intended to provide further explanation of the invention as claimed.
The accompanying drawings, which are included to provide further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and, together with the description, serve to explain the principles of the invention.
In the drawings:
The invention relates to a software system developed to facilitate the management of compensation decisions within an organization and, in some embodiments, multiple divisions of the organization. While the examples described herein relate to bonus compensation, the invention is equally applicable to other types of compensation. Also, while the embodiments described herein refer to employees of an organization, the invention is equally applicable to all individuals within the organizational structure of an organization.
With reference to
The system and method described herein provide managers with the ability to distribute compensation money, e.g., bonus compensation money, to any of their direct reports within the organization and to distribute pools of employee bonus compensation money to direct report managers, as well as other managers within the organization. Pool Managers assign bonus pools to subordinate Pool Managers for their distribution to subordinate Pool Managers, who distribute to Bonus Managers, and so on, until all bonus pool money is distributed. Furthermore, Bonus Managers distribute bonus money to individual employees.
The system operates upon an infrastructure of employee data, manager-employee relationships data, and pool/bonus data. Employee data is pulled from databases associated with human resources applications, which contain the latest employee data, historical compensation values, and the latest currency exchange rates. Bonus-specific data is pulled from a database that contains information such as bonus values and manager reporting relationships.
The process is a top down process; that is, an initial bonus value is established at the top of the organization or division and then the bonus distributions cascade down the organization or division until all bonus money has been distributed. To keep the process orderly and accurate, business rules may be put in place to prevent managers from over-distributing their authorized bonus pools.
Various functionality is described herein for exemplary purposes; however, as will be apparent, not all of the functionality described herein need be included, and additional functionality may be added, within the scope of the present invention.
In many organizations, the bonus compensation distribution process is a once-per-year process. In a preferred embodiment, the inventive software is available to managers to distribute bonus money during a period of time that starts from the time the software is opened to managers for bonus data entry until the software is closed and is no longer available to managers for bonus data entry. The period of time between when the software is first opened until the software is closed for the last time is referred to herein as the Bonus Compensation Period. The Bonus Compensation Period can occur at multiple, various times throughout the year. The Bonus Compensation Period controls user access to the system, in the preferred embodiment. It is used by administrators to close the system to managers for data entry, during which time administrators can perform administrative activities on the data, and potentially take a “snapshot” of how the distribution process is proceeding.
In a preferred embodiment, the present invention contains a currency translation capability that permits users to distribute and view bonuses and bonus pool money in US dollars, as well as local currencies. If an amount is displayed or entered as a local currency, the amount may be converted and displayed/stored in US Dollars based on, e.g., the exchange rate established at the beginning of the Bonus Compensation Period. In other embodiments, all currency values are shown and entered in the local currency, whether the listed employees are paid in USD or another currency.
A preferred embodiment also allows for pre-pool distribution. In particular, managers are able to view their populations and model bonus payments. Each manager pool may be able to create a number (e.g., three) modeling scenarios. In this embodiment, one scenario is marked as “Master” at all times to allow for rollup and drilldown. Pools represent the available spend that is given to the managers. Managers fit one of their scenarios to the pool of money that they, eventually, receive. Numbers entered by managers at the lower levels of the hierarchy are rolled up to upper levels of the hierarchy and eventually up to the pool originator, thereby allowing all members of the management chain to review the activities of those in their reporting structure. Managers at upper levels of the hierarchy can drill down to their bonus managers to see how these managers plan to pay the people who report to them.
When an overspend flag is set to “on” in the system, the managers have no spending limit. If they go over the pool amount, the remaining pool amount is highlighted in red. When an overspend flag is set to “off”, managers must fit their master scenario within the pool limit. A tolerance factor (e.g., 0.01%) may be allowed for foreign exchange rate calculation/rounding issues. Bonus spend and pool distribution can happen in iterative cycles. Snapshots can be taken after each iterative cycle. Snapshots serve as a view as of a certain point in time. Once all managers sign off on the proposals for bonuses/salary, the administrator signs off for the division, and all bonus/salary numbers are sent to the human resources system.
The system also provides views to other populations (i.e., employees not within a manager's reporting chain. In particular, lists of other employees can be generated, thereby allowing managers outside such employees' management chain to submit bonus/salary recommendations.
This, and other, exemplary functionality is described in more detail below with reference to
The Pool Originator is at the top of the pyramid, with the ability to set the total division pool and distribute pools to pool managers. Guarantees and advances are automatically accounted for in the Bonus Spend. With reference to
The Pool Manager distributes pools to other Pool Managers and Bonus Managers. With reference to
With reference to
With reference to
With reference to
With reference to
The List Manager has view access to a predefined list of employees and can submit bonus and salary recommendations for those employees. With reference to
With reference to
With reference to
A Co-Manager is a co-owner of a pool who can view the primary manager's payment scenarios, but needs to coordinate with the primary owner of the pool to submit/finalize numbers. A Viewing Manager is pertinent to single pools only. This manager has view access to employee(s) and the hierarchy associated with the employee(s). The viewing manager hierarchy is separate and distinct from the bonus paid hierarchy. A Global Administrator manages system and user setup and may work on behalf of Pool Originators, Pool Managers and Bonus Managers. A Regional or Product Administrator may manage selective system and user setup options and may work on behalf of Pool Managers and Bonus Managers for a pre-defined region or product code. A Pool Administrator may work on behalf of Pool Managers and Bonus Managers in a leg of the hierarchy (e.g., a pool) for the purpose of keeping the process moving along; this administrator has no system or user setup access.
As will be apparent to those skilled in the art, the titles/roles and capabilities described for the various managers/administrators herein is for exemplary purposes only. Other titles/roles and associated capabilities can be used within the scope of the present invention.
In a preferred embodiment, database used to store the bonus application related information is an Oracle database (see database 106 of
Tables 2001 are used to organize the hierarchy information.
Tables 2002 are used to organize entitlement data. In particular, VIEWING_LIST_ED defines the viewing list available in the system. These lists will help adminstrators in defining the viewing hierarchy. VIEW_LIST_EMP_MAPPING_ED maps the person belonging to the list with the list. VIEW_LIST_VIEWRS_ED also serves to map the person belonging to the list with the list. REPORT_SUITE_ED stores the various report suites that are available. These are aggregates of reports. RESOURCE_ED defines the resources present within the system. RESOURCE_PARAMETER_ED defines the parameters that need to be passed for a particular resource. ROLE_RESOURCE_MAPPING_ED stores the mapping of roles and resources. ROLE_EMPLOYEE_MAPPING_ED stores the mapping of employees to roles. RESOURCE_EXCEPTION_ED stores the exceptions to the criteria which define the viewing list available in the system. DIV_BONUS_SCR_ED lists the various columns that can be available on the My Bonus screen depending on the divisions. EMP_HIDDEN_COLUMNS_ED maps to hidden column name in the html table of the jsp.
Tables 2003 are used to organize master data. BUSINESS_UNIT_MD_VIEW is the master view for the Division, which stores, in addition to the division names, the contact, pool owner information, etc. REGION_MD_VIEW is the master table for the region. This can be a view directly from the human resources application. DEPARTMENT_MD_VIEW is the master table for the department. This can be a view directly from the human resources application as well. COMP_BAND_MD stores the compensation bandings. This table is used to generate reports and list the employees in compensation bands based on their compensations. EXCHANGE_RATE_MD_VIEW is the master table for the exchange rates to be used within the system. It is derived from the human resources application. EMPLOYEE_MD contains information for all employees. EMPLOYEE_TYPE_MD is used as employee type master, which will basically describe employee types. SCENARIO_TYPE_MD contains possible values for scenario types. SCENARIO_STATUS_MD contains possible values for scenario status. FUNDING_POOL_MD contains all FUNDING_POOL related information for all divisions. The FUNDING_POOL_OWNERSHIP_MD should have Owner and may have one or more Co-owners. ROLE_MD defines the roles available in the system. RESOURCE_TYPE_MD stores the various types of resources available to a system. Resources can be tabs, report suites, reports etc. SERVICE_INTERVAL_MD stores the service intervals for all divisions. EMAIL_MESSAGES_MD stores data for email messages screens.
Tables 2004 are used to organize scenario data for pools and bonuses. POOL_SD contains Pool-related information for all Snapshots and Scenarios. The Pools are categorized by various FUNDING_POOLs. POOL_HISTORY_SD contains information about the individual pool transactions. The table is the source for the Registry popup on the Pools for my Managers screen. The table records information like the person who transferred the pool, the amount, the comments and date/time stamp for transactions. SNAPSHOT_SD contains all Snapshots created for all divisions. The current snapshot can be determined by checking the IS_CURRENT flag. When the snapshot is created by a divisional personnel from human resources, all the Pool and Bonus data will be snapshot on the respective tables with the newly created SNAPSHOT_ID. SCENARIO_SD contains all Scenario related information for all divisions. RECOMMENDATIONS_SD is the recommendations table which holds either Bonus or Total Comp recommendations made by other managers. EMPLOYEE_DIARY_SD contains diary information for all employees. DIV_BONUS_SCR_ORDER_SD stores the order of values in the columns that are defined in the DIV_BONUS_SCR_ED table. DIV_BONUS_SCR_DATA_SD stores the values for each of the employees in the columns described in DIV_BONUS_SCR_ED. BONUS_SD is the scenario table for the corresponding PS_LB_BONERN_TBL table. BONUS_DETAILS_SD is the scenario table for the corresponding PS_LB_BONERNG_BAL table. This table has all the different types of Bonus earnings for the employee for the fiscal year. It has data both in local currency and quote currency. BONUS_REPORT_SD is the scenario table for the corresponding PS_LB_BON_REPORT table. This table has all the employee details used for reporting. Each employee has two lines; one line has all figures in USD, the other line has all figures in quote currency. BUSINESS_UNIT_OPTIONS_SD stores additional data related to the division names the contact, pool owner information, etc. HIRE_CATEGORY_VIEW holds data for the Hire category. ALT_PRODUCT_CODE_VIEW holds data for the product code. SALARY_VIEW holds data for the salary indicator and its description. TITLE_VIEW holds data for the corporate title description. JOBCODE_VIEW holds data for the Job code and its description. PROGRAM_VIEW holds data for the program name description. PNP_VIEW holds data for the PNP code and its description. FLSA_STATUS_VIEW holds data for the FLSA code and its description. ALT_ORG_PRGP_VIEW holds data for the Organization PRGP code and its description. ALT__ORG_FUNCTION_VIEW holds data for the Organization function code and its description. CURRENCY_VIEW holds data for the currency code and its description.
Tables 2006 are used to organize audit information.
Tables 2005 are the global bonus tables present in the human resources application database. BONERN_TBL is the parent of BONERNG_BAL and has summary level employee information about indicators, restricted stock units, and options. BONERNG_BAL, has all the different types of Bonus earnings for the employee for the fiscal year. It has data both in local currency and quote currency. BON_REPORT has all the employee details used for reporting. BON_EMPDATA has all the employee non comp details for each fiscal year and some flags which indicate what Data has been updated. BON_OVERRIDE has all the different types of Bonus earnings for the employee for the fiscal year that has been over-written. This data flows to the BONERNG_BAL table as an override amount. This data is in local currency. BON_ERNACM1 is a setup table that links the two fields BONCAT_ID and BONCAT_TYPE. SYS_CONTROL is a setup table to indicate the current Bonus year. XRT_TBL is the table that has the conversion rate between other currencies and USD. SAL_PROG is the table which holds the various salary programs. SAL_GRID is the table which holds the grid information corresponding to the various salary programs. STK_PROG is the table which holds the various stock programs. STK_GRID is the table which holds the grid information corresponding to the various stock programs. BON_AUD_TBL is the table from the human resources application that has the audit info for the Global bonus data changes.
With reference to
The present invention is intended to embrace all alternatives, modifications and variances that fall within the scope of the appended claims.