JP4602813B2 - Retirement allowance point calculation system and retirement allowance calculation system - Google Patents

Description

  The present invention relates to a retirement allowance point calculation system and a retirement allowance calculation system. Specifically, retirement points can be calculated by selecting valid basic data based on date information and extracting retirement points from the selected basic data without being particularly aware of system changes. This relates to a calculation system and a retirement allowance calculation system.

In the past, when calculating the retirement allowance of employees engaged in a company and a company having a similar organization (hereinafter referred to as “Company”),
(Retirement allowance) = (Calculation basic salary) x (Payment rate by length of service) x (Coefficient by retirement reason) + (Various additions)
Are used.

  The calculated basic salary is linked to the basic wage or monthly wage at a certain percentage of the basic salary.The annual wage increase is immediately reflected in the calculated basic salary. Will receive. In addition, there are several types of payment rates by length of service, such as a uniform increase type, a gradual increase type, and a progressive increase type, all of which increase in accordance with the years of service. In general, the increase is increased as the employee works for a long time. The retirement reason coefficient is a coefficient for causing a difference in the payment rate depending on retirement reasons such as retirement age, retirement due to company circumstances, or retirement due to personal reasons. In addition, various additions can be considered such as addition of achievements or addition of positions.

  The traditional retirement allowance system calculated using the above retirement allowance formula has a close relationship with monthly wages and is characterized by the use of a pay rate that emphasizes long-term service, On the other hand, it is also a problem. More recently, the adoption of an “annual salary system” in which the amount of salary increases or decreases depending on individual performance has increased, and this revision of the wage system has disrupted the concept of conventional basic retirement salary, and retirement as described above. The number of cases where gold cannot be calculated is increasing.

In order to deal with such problems, achievements that completely separate retirement benefits from wages (especially basic wages) and merit-based retirement plans, that is, point-based retirement plans are rapidly spreading. Here, when calculating retirement allowance under the point system retirement allowance system,
(Retirement allowance) = {(Cumulative qualification grade points) + (Cumulative years of service points)} x (Point unit price) x (Coefficient for retirement reasons) + (Various additions)
Are used.

  Cumulative qualification grade points are points given according to qualification grades in companies that employ a professional qualification system or a job grade system as the personnel system. For example, as shown in Table 1 below When a professional qualification grade is given, a new employee is given a J-1 qualification grade at the time of joining the company, and if he / she is enrolled for one year in this J-1 qualification grade, 6 points will be awarded. If you are enrolled in the same qualification grade for one year, 6 points will be awarded, and the cumulative qualification grade points will be 12 points.

  Accumulated years of service points are given for years of service. For example, when years of service as shown in Table 2 below are given, if the years of service are less than 3 years Will be awarded 5 points per year of service.

  Note that the point unit price is the amount per point of points granted as described above, and is generally set to (1 point) = (10000 yen), but depending on the company, There are cases where (1 point) = (8000 yen) and (1 point) = (6000 yen).

Recently, as a development of the above point system retirement allowance system, an increasing number of companies have added in-service points to reflect their personal achievements. In this case, the retirement allowance formula is:
(Retirement allowance) = {(Cumulative qualification grade points) + (Cumulative years of service points) + (Cumulative job tenure points) + (Cumulative achievement reflecting points)} x (point unit price) x (coefficient for retirement reasons) + (various additions) )
Are used.

  Cumulative position in-service points are given to those who are in office for the first year of his / her position. For example, if the position points shown in Table 3 below are given, he / she will serve for one year. If you are enrolled, you will receive 4 points.

  Accumulated results reflecting points are added to qualification grade points and incumbent points based on the results of individual performance, that is, the evaluation rank (for example, S rank, A rank, B rank, C rank, D rank) in the regular personnel evaluation. For example, if qualification grade points and job title points as shown in Tables 4 and 5 below are given, if the employee rank is 1 and the evaluation rank is A rank, In addition to the above 6 points, 2 points will be awarded as an achievement point, and if the evaluation rank is B rank as a manager, 1 point will be given as an achievement point in addition to 6 points as a manager It will be.

  In addition to the above-mentioned point-based retirement allowance system and its development, we ask each employee for the points of enrollment period and years of service on the base date for calculation of annual points (usually the last day of the fiscal year). Record in the ledger format, calculate each point up to the date of retirement at the time of retirement, and calculate the retirement amount by the above formula.

  By the way, the personnel system, once decided, is often changed due to changes in internal circumstances and the external management environment. Changes in numbers, etc. (hereinafter referred to as “minor changes”) are generally made at intervals of several years. That is, a change is added to the data (hereinafter referred to as “basic data”) that is the basis for determining the points to be given by a minor change. Minor changes in the system will be implemented after a predetermined period after discussions between the company and employee representatives or labor unions in advance and notification to all employees. This means that the new system will be applied all at once from the implementation date of the system change while applying the current system.

  Here, when such a minor change is made, the basic data changes before and after the minor change, but the point assignment work with reference to different basic data every time a minor change is made is very complicated, and the minor change There has been a strong demand for a system that can easily give points even if the above is performed.

  Even if a minor change is made by updating the basic data every time a minor change is made, that is, by completely discarding the basic data before the minor change and storing only the currently valid basic data in the system. A method of easily assigning points is also conceivable. However, there may be cases where correction of point grants is performed retroactively, so it is necessary to store not only the currently valid data but also the data that was valid in the past, so only the currently valid data is stored. It cannot be said that the method of doing this is sufficient.

  The present invention was devised to meet such demands, and provides a retirement point calculation system and such retirement point calculation system that can easily perform retirement point assignment work even if a minor change is made. It is an object of the present invention to provide a retirement allowance calculation system that can be used to easily calculate retirement allowances.

  In order to achieve the above object, a retirement point calculation system according to the present invention is a retirement point calculation system that inputs at least date information and personnel information as input information and derives retirement point based on the input information. , A plurality of personnel information is registered, each personnel information is associated with a predetermined retirement point, and a database in which basic data with a valid period is stored and date information inputted from outside are recognized, Basic data selection means for selecting effective basic data from the database based on the same date information, and externally input personnel information, and from the basic data selected by the basic data selection means, the personnel information Severance pay point extracting means for extracting severance pay points associated with.

  In order to achieve the above object, a retirement allowance calculation system according to the present invention is a retirement allowance calculation system that inputs at least date information and personnel information as input information and calculates retirement allowance based on the input information. , A plurality of personnel information is registered, each personnel information is associated with a predetermined retirement point, and a database in which basic data with an expiration date is stored and date information inputted from the outside are recognized, Basic data selection means for selecting effective basic data from the database based on the same date information, and externally input personnel information, and from the basic data selected by the basic data selection means, the personnel information Retirement allowance point extraction means to extract retirement allowance points associated with, date information and personnel input from outside A retirement point registration unit that registers the retirement point extracted by the point extraction unit together with the information, and a retirement amount calculation unit that calculates a retirement amount based on the retirement point point registered in the retirement point point registration unit With.

  Here, after recognizing the date information input from the outside by the basic data selection means, and selecting valid basic data from the database based on this date information, the personnel information input from the outside by the retirement point extraction means is obtained. Even if multiple basic data with different expiration dates are stored in the database by extracting the retirement points associated with the recognized personnel information from the basic data selected by the basic data selection means, Retirement points can be extracted simply by always executing the same processing logic, and processing can be performed without being conscious of whether or not a minor change has been made.

  In the above retirement allowance point calculation system, even if a minor change is made, the retirement points can be extracted by always executing the same processing logic, and processing is performed without being aware of whether or not a minor change has been made. Therefore, it is possible to perform retirement point granting work very easily. Similarly, the above-mentioned retirement allowance calculation system makes it possible to perform retirement allowance points very easily, so that it is possible to facilitate the calculation of retirement allowances.

Hereinafter, embodiments of the present invention will be described with reference to the drawings to facilitate understanding of the present invention.
FIG. 1 is a schematic diagram for explaining an example of a retirement allowance calculation system to which the present invention is applied. The retirement allowance calculation system shown here is a database in which a master table that is basic data for calculating retirement allowance points is stored. 1, master table selection means 2 for selecting a master table that satisfies a condition from the database based on date information input from the outside, and a master table selected by the master table selection means based on personnel information input from the outside Severance point extraction means 3 for extracting information related to a predetermined severance pay point, severance point registration means 4 for storing severance point information extracted by the severance point extraction means, and severance point registration means Retirement allowance calculation that calculates retirement allowance based on the retirement benefit point information provided It has a step 5.

Here, a master table necessary for managing personnel history and calculating retirement points is stored in the database. As an example of the stored master table, an occupation name master table (see FIG. 2A), Qualification grade point master table (see Fig. 2 (b)), post-in-service point table (see Fig. 2 (c)), years of service point master table (see Fig. 2 (d)), point unit price master table (Fig. 2 (e))), retirement reason coefficient master table (see Fig. 2 (f)), etc., and when personal performance results are reflected in retirement points, individual performance results reflecting type qualification class A point master table (see FIG. 3A), a post-in-service point master table (see FIG. 3B), and the like are conceivable.
In each master table, an implementation date that is the start of the effective period of each master table and an end date that is the end of the effective period are defined.

  Now, as mentioned above, it is common for personnel systems to undergo minor changes once every few years, so here we established a company on April 1, 2000 and started introducing a point-based retirement allowance system. The above database will be described by taking as an example the case of the first minor change on April 1, 2004 and the second minor change on April 1, 2006. For convenience of explanation, only the qualification grade point master table and the years of service point master table will be explained.

  First, from the establishment of the company (April 1, 2000) to the first minor change, as shown in FIG. 4A, the first qualification point master table 6a and the first service period The years point master table 7a is stored in the database. At this time, the implementation date of both master tables is April 1, 2000, and the end date is December 31, 2999. Note that the maximum date that is allowed in the system is input as the end date, and it does not necessarily need to be December 31, 2999.

  Subsequently, when the first minor change is made, a second qualification grade point master table 6b and a second years of service point master table 7b are newly added to the database as shown in FIG. 4 (b). . Here, when the second qualification point master table having an implementation date of April 1, 2004 is added to the database, the end date of the first qualification point master table is December 2999. It was rewritten on March 31, 2004, the day before the implementation date of the second qualification point master table from 31st, and the end date of the second qualification point master table was December 31, 2999. It is configured to be. Similarly, when the second service year point master table having an implementation date of April 1, 2004 is added to the database, the end date of the first service year point master table is December 2999. From the 31st, it was rewritten on March 31, 2004, the day before the implementation date of the second service years point master table, and the end date of the second service years point master table was December 31, 2999 It is configured to be.

  Further, when the second minor change is made, a third qualification grade point master table 6c and a third service years point master table 7c are newly added to the database, as shown in FIG. 4C. Here, when the third qualification point master table having an implementation date of April 1, 2006 is added to the database, the end date of the second qualification point master table is December 2999. It was rewritten on March 31, 2006, the day before the implementation date of the third qualification point master table from 31st, and the end date of the third qualification point master table was December 31, 2999. It is configured to be. Similarly, when a third service year point master table with an implementation date of April 1, 2006 is added to the database, the end date of the second service year point master table is December 2999. From 31st, it was rewritten on March 31, 2006, which is the day before the implementation date of the third service years point master table, and the end date of the third service years point master table is December 31, 2999 It is configured to be.

  In the retirement allowance calculation system configured as described above, first, date information and personnel information, that is, personnel operations such as hiring, periodic appraisal, special promotion, special promotion, extraordinary appraisal, leave, reinstatement, self-retirement, retirement Date information on which an action (hereinafter referred to as “personal action”) is performed and personnel information such as what kind of personnel action has been performed are input as input information.

  When the date information is input, the master table selection means selects a master table that is effective in calculating retirement points when a personnel action is performed based on the input date information.

For example, if the base date for point calculation is April 1 every year,
(1) If the date information is April 1, 2001, the points given between April 1, 2000 and March 31, 2001 will be calculated. Select the first qualification grade point master table and the first years of service point master table included in the validity period,
(2) If the date information is April 1, 2005, the points given between April 1, 2004 and March 31, 2005 will be calculated. Select the second qualification point master table and the second years of service point master table included in the validity period,
(3) If the date information is April 1, 2008, the points given between April 1, 2007 and March 31, 2008 will be calculated. A third qualification point master table and a third years of service point master table included within the validity period are selected.

  Next, severance pay points are extracted from the master table selected by the master table selection means based on the date information based on the input personnel information, and the extracted severance pay point information is combined with the date information and personnel information. Save to retirement point registration means.

For example, “Date information: April 1, 2001, Personnel information: Employee level 1” is input to employee A who has been in the company for the first year as of April 1, 2000 and was level 1 When information is input, the first qualification point master table is selected as in (1) above, and from April 1, 2000, based on the input information (personnel information) of employee level 1 4 points will be given as qualification grade points for having been enrolled in the qualification grade of employee 1st grade until March 31, 2001, and information that 4 points were given as qualification grade points along with the input information It will be stored in the retirement point registration means.
Similarly, the first year of service point master table was selected as in (1) above, and the first year of service was enrolled for one year from April 1, 2000 to March 31, 2001. Thus, 5 points are given as years of service, and information that 5 points are given as years of service along with the input information is stored in the retirement point registration means.

  By the master table selection process by the master table selection unit, the retirement point extraction process by the retirement point extraction unit, and the storage process in the retirement point registration unit as described above, for example, the information as shown in FIG. Will be saved. In addition, in FIG. 5, in addition to the qualification grade points and years of service points described above, the achievement points of the qualification grade points, the position incumbent points and the result points of the position incumbent points are also stored. The method for extracting these points is the same as the method for extracting qualification grade points and years of service.

After that, when calculating retirement allowance, retirement allowance calculation means,
(Retirement allowance) = (Cumulative retirement points stored in retirement reward point registration means) x (point unit price) x (coefficient by retirement reason) + (various additions)
The retirement allowance is calculated and output by performing such a calculation process.

  In addition, since the basic data is generally changed by minor changes in the point unit price and the coefficient for retirement reasons, the above-mentioned qualification grade points and years of service are also used for these basic data when calculating retirement allowances. Similar to the point extraction, an appropriate master table is selected from the database based on the input date information.

  In the retirement allowance calculation system to which the present invention described above is applied, when a new master table is added to the database, the end date of the existing master table is rewritten to the day before the implementation date of the new master table. By setting the end date of the new master table to December 31, 2999, a plurality of master tables with different expiration dates are stored in the database, and the same processing logic is always executed, so that the retirement point can be obtained. Extraction is possible, processing can be performed without being aware of whether or not minor changes have been made, and retirement allowances can be calculated very easily.

It is a schematic diagram for demonstrating an example of the retirement allowance calculation system to which this invention is applied. It is a figure for demonstrating the occupation name master table. It is a figure for demonstrating the qualification grade point master table. It is a figure for demonstrating the post in office position point master table. It is a figure for demonstrating the length of service point master table. It is a figure for demonstrating a point unit price master table. It is a figure for demonstrating the retirement reason coefficient master table. It is a figure for demonstrating the qualification grade point master table (development type). It is a figure for demonstrating the post-employment point master table (development type). It is a schematic diagram for demonstrating the process at the time of a master table being added to the database. It is a schematic diagram for demonstrating the information preserve | saved at a retirement allowance point registration means.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Database 2 Master table selection means 3 Retirement allowance point extraction means 4 Retirement allowance point registration means 5 Retirement allowance calculation means 6a 1st qualification grade point master table 6b 2nd qualification grade point master table 6c 3rd qualification grade point master Table 7a First service years point master table 7b Second service years point master table 7c Third service years point master table

Claims (4)

In a retirement point calculation system that inputs at least date information and personnel information as input information and derives retirement point based on the input information,
A database in which a plurality of personnel information is registered, each personnel information is associated with a predetermined retirement point, and basic data with a valid period is stored,
Basic data selection means for recognizing date information input from the outside and selecting the effective basic data from the database based on the date information;
Retirement allowance point extraction means for recognizing personnel information input from the outside and extracting retirement allowance points associated with the personnel information from the basic data selected by the basic data selection means, Retirement allowance point calculation system. When one basic data is stored in the database and another basic data is stored in the database, the expiration date of the one basic data is changed to the day before the expiration date of the other basic data. The retirement allowance point calculation system according to claim 1, wherein the system is configured as described above. In a retirement allowance calculation system that inputs at least date information and personnel information as input information and calculates retirement allowance based on the input information,
A database in which a plurality of personnel information is registered, each personnel information is associated with a predetermined retirement point, and basic data with an expiration date is stored,
Basic data selection means for recognizing date information input from the outside and selecting the effective basic data from the database based on the date information;
Recognizing personnel information input from the outside, and from the basic data selected by the basic data selecting device, retirement point extraction means for extracting retirement points associated with the personnel information,
Along with date information and personnel information input from the outside, retirement point registration means for registering retirement point extracted by the point extraction means,
A retirement allowance calculation system comprising: retirement allowance calculation means for calculating retirement allowance based on retirement allowance points registered in the retirement allowance point registration means. When one basic data is stored in the database and another basic data is stored in the database, the expiration date of the one basic data is changed to the day before the expiration date of the other basic data. The retirement allowance calculation system according to claim 3, wherein the retirement allowance calculation system is configured as described above.

Images