Social insurance information processing device, social insurance information processing method, and social insurance information processing program

Abstract

To provide a social insurance information processor, a social insurance information processing method, and a social insurance information processing program that can automatically acquire standard monthly remuneration and grade for monthly change notification and calculation basis notification.SOLUTION: A social insurance information processing device of this embodiment, which is a social insurance information processing device including a control unit, is capable of accessing employee attendance data, employee payment data, employee social insurance data, and a social insurance premium amount master. The control unit includes: an exclusion flag setting unit that sets, when there is no closure time in a month following a target month, and there is closure time within a three-month period prior to the target month, an exclusion flag in the month where there is a closure time; and a standard monthly remuneration calculation unit that calculates a monthly remuneration amount that changes due to the closure within a three-month period preceding the target month, while referring to the exclusion flag, to obtain an average monthly remuneration amount, and acquires the standard monthly remuneration amount and a grade from the social insurance premium amount master.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a social insurance information processing device, a social insurance information processing method, and a social insurance information processing program. [Background technology]

[0002] In the staffing industry, there are many cases of temporary leave due to furlough, so if leave allowance is paid due to leave, the month in which the leave allowance was paid must be excluded from the calculation of the Monthly Change Notification (Getsuhen) and Calculation Base Notification (Calculation).

[0003] Calculations are made once a year, in June only. When temporary leave allowance is paid, the standard monthly remuneration is calculated based on the monthly remuneration amount including the temporary leave allowance. However, if the temporary leave status is resolved by the first of the following month, i.e., July 1st, the standard monthly remuneration is calculated excluding the month in which the temporary leave allowance was paid.

[0004] In the case of Gekken, if an employee has already received unemployment benefits for three months due to temporary leave and will be paid for the fourth month, the standard monthly salary will be calculated based on the monthly salary including the unemployment benefits.

[0005] Previously, when calculating monthly changes, the person in charge had to determine the above conditions and perform the calculation, which required a very high level of social insurance knowledge and was a time-consuming process.

[0006] Patent document 1 describes a public insurance administrative service provision system that has a server with a specified memory area and that carries out administrative procedures related to public insurance by communicating data over a network on the server, and that includes an employment contract conclusion means for concluding an employment contract between a non-member of the public insurance and a provider of the public insurance administrative service to employ the non-member as an employee of the provider, a consulting contract conclusion means for concluding a paid consulting contract between the non-member of the public insurance and the provider of the public insurance administrative service, in which the provider will provide the non-member with specified services, a standard remuneration amount determination means for paying the non-member for labor provided based on the employment contract and determining a standard remuneration amount that serves as the calculation basis for public insurance premiums based on the amount of remuneration paid to the non-member, and an information provision means for providing information on the standard remuneration amount determined by the standard remuneration amount determination means and specified information related to the non-member to administrative agencies that serve as the contact point for public insurance procedures. [Prior art documents] [Patent documents]

[0007] [Patent Document 1] Japanese Patent Application Laid-Open No. 2002-24485 Summary of the Invention [Problem to be solved by the invention]

[0008] The system of Patent Document 1 outsources monthly calculations and other tasks, which requires outsourcing costs.

[0009] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a social insurance information processing device, a social insurance information processing method, and a social insurance information processing program that can automatically obtain standard monthly remuneration and grade for monthly change notifications and calculation base notifications. [Means for solving the problem]

[0010] In order to solve the above-mentioned problems and achieve the objectives, the social insurance information processing device of the present invention is a social insurance information processing device that has a control unit and is able to access employee attendance data including the employee's monthly leave hours, employee payment data including the employee's monthly fixed wage, monthly remuneration, leave allowance and leave allowance deduction amount, employee social insurance data including the employee's monthly standard monthly remuneration and grade, and a social insurance premium amount master including above standard remuneration, below standard remuneration, standard monthly remuneration and grade, and is characterized in that the control unit has an exclusion flag setting unit that sets an exclusion flag for the month in which there is leave hours if there are no leave hours in the month following a target month and there are leave hours within a period of three months prior to the target month, and a standard monthly remuneration calculation unit that calculates the monthly remuneration that has changed due to leave within a period of three months prior to the target month while referring to the exclusion flag set by the exclusion flag setting unit, calculates the average monthly remuneration, and obtains the standard monthly remuneration and grade from the social insurance premium amount master.

[0011] In addition, the social insurance information processing device of the present invention is characterized in that the standard monthly remuneration calculation unit obtains the standard monthly remuneration and grade for monthly change notification when there is a fluctuation in fixed wage three months and two months before the target month and there is no month with the exclusion flag between two months before the target month.

[0012] In addition, the social insurance information processing device of the present invention is characterized in that the standard monthly remuneration calculation unit calculates the monthly remuneration for months other than the months for which the exclusion flag is set within a three-month period prior to the target month when there is no change in fixed wages between three months prior to the target month and two months prior to the target month, and the target month is June, to determine the average monthly remuneration, and obtain the standard monthly remuneration and grade for use in the calculation basis notification.

[0013] In addition, the social insurance information processing device of the present invention is characterized in that, when there is a fluctuation in fixed wage three months and two months before the target month, there is a month with the exclusion flag between two months before the target month, and the target month is June, the standard monthly remuneration calculation unit calculates the monthly remuneration for months other than the month with the exclusion flag set within a three-month period prior to the target month, determines the average monthly remuneration, and obtains the standard monthly remuneration and grade for use in the calculation basis notification.

[0014] In addition, the social insurance information processing device of the present invention is characterized in that the standard monthly remuneration calculation unit does not obtain the standard monthly remuneration amount and grade for the monthly change notification and calculation base notification if there is no change in fixed wage three months and two months prior to the target month and the target month is other than June.

[0015] In addition, the social insurance information processing device of the present invention is characterized in that the standard monthly remuneration calculation unit does not obtain the standard monthly remuneration amount and grade for the monthly change notification and calculation base notification if there is a fluctuation in fixed wage three months and two months before the target month, if there is a month with the exclusion flag between two months before the target month, and if the target month is other than June.

[0016] Furthermore, the social insurance information processing method of the present invention is a social insurance information processing method executed by a social insurance information processing device equipped with a control unit, wherein the social insurance information processing device has access to employee attendance data including the employee's monthly leave hours, employee pay data including the employee's monthly fixed wage, monthly remuneration, leave allowance and leave allowance deduction amount, employee social insurance data including the employee's monthly standard monthly remuneration and grade, and a social insurance premium amount master including above standard remuneration, below standard remuneration, standard monthly remuneration and grade, and is executed by the control unit, and is characterized by including: an exclusion flag setting step for setting an exclusion flag for the month in which there is leave hours if there are no leave hours in the month following a target month and there are leave hours within a period of three months prior to the target month; and a standard monthly remuneration calculation step for calculating the monthly remuneration that has changed due to leave within a period of three months prior to the target month while referring to the exclusion flag set in the exclusion flag setting step, to obtain an average monthly remuneration, and to obtain the standard monthly remuneration and grade from the social insurance premium amount master.

[0017] In addition, the social insurance information processing program of the present invention is a social insurance information processing program to be executed by a social insurance information processing device equipped with a control unit, wherein the social insurance information processing device has access to employee attendance data including the employee's monthly leave hours, employee payment data including the employee's monthly fixed wage, monthly remuneration, leave allowance and leave allowance deduction amount, employee social insurance data including the employee's monthly standard monthly remuneration and grade, and a calculated social insurance premium amount master including above standard remuneration, below standard remuneration, standard monthly remuneration and grade, and is characterized by including, for execution by the control unit, an exclusion flag setting step for setting an exclusion flag for the month in which there is leave hours if there are no leave hours in the month following a target month and there are leave hours within a period of three months prior to the target month, and a standard monthly remuneration calculation step for calculating the monthly remuneration that has changed due to leave within a period of three months prior to the target month while referring to the exclusion flag set in the exclusion flag setting step, to obtain an average monthly remuneration, and to obtain the standard monthly remuneration and grade from the social insurance premium amount master. [Effects of the Invention]

[0018] According to the present invention, it is possible to automatically obtain the standard monthly remuneration amount and grade while referring to the exclusion flag when calculating the monthly remuneration. [Brief explanation of the drawings]

[0019] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of a social insurance information processing device according to this embodiment. [Figure 2] FIG. 2 is a diagram showing a flow of the social insurance information processing device according to this embodiment. [Figure 3] FIG. 3 is a diagram illustrating an example of employee attendance data. [Figure 4] FIG. 4 is a diagram illustrating an example of employee payment data. [Figure 5] FIG. 5 is a diagram illustrating an example of employee social insurance data. [Figure 6] FIG. 6 is a diagram showing an example of processing on the social insurance registration screen. [Figure 7] FIG. 7 is a diagram illustrating an example of the social insurance premium amount master. [Figure 8] FIG. 8 is a diagram showing an example of processing on the social insurance registration screen. [Figure 9] FIG. 9 is a diagram illustrating an example of employee social insurance processing data. [Figure 10] FIG. 10 is a diagram illustrating an example of employee attendance data. [Figure 11] FIG. 11 is a diagram illustrating an example of employee payment data. [Figure 12] FIG. 12 is a diagram showing an example of employee social insurance data. [Figure 13] FIG. 13 is a diagram showing an example of processing on the social insurance registration screen. [Figure 14] FIG. 14 is a diagram showing an example of processing on the social insurance registration screen. [Figure 15] FIG. 15 is a diagram illustrating an example of employee social insurance processing data. [Figure 16] FIG. 16 is a diagram showing an example of processing on the social insurance registration screen. [Figure 17] FIG. 17 is a diagram showing an example of processing on the social insurance registration screen. [Figure 18] FIG. 18 is a diagram illustrating an example of employee social insurance processing data. DETAILED DESCRIPTION OF THE INVENTION

[0020] Hereinafter, embodiments of a social insurance information processing device, a social insurance information processing method, and a social insurance information processing program according to the present invention will be described in detail with reference to the accompanying drawings. Note that the present invention is not limited to these embodiments.

[0021] [1. Configuration] An example of the configuration of a social insurance information processing device according to this embodiment will be described with reference to Fig. 1 etc. Fig. 1 is a diagram showing an example of the configuration of a social insurance information processing device 100 according to this embodiment.

[0022] The social insurance information processing device 100 is constructed based on a commercially available desktop personal computer. Note that the social insurance information processing device 100 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, but may also be constructed based on a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0023] The social insurance information processing device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit of the social insurance information processing device 100 is communicably connected via any communication path.

[0024] The communication interface unit 104 communicably connects the social insurance information processing device 100 to a network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the social insurance information processing device 100 and the server device 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the memory unit 106 may also be stored in the server device 200, for example.

[0025] An input device 400 and an output device 500 are connected to the input / output interface unit 108. The output device 500 may be a monitor (including a home television), a speaker, or a printer. The input device 400 may be a keyboard, a mouse, a microphone, or a monitor that functions as a pointing device in cooperation with a mouse. In the following, the output device 500 may be referred to as the monitor 500, and the input device 400 may be referred to as the keyboard 400 or the mouse 400.

[0026] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

[0027] The storage unit 106 stores, for example, employee attendance data 106a, employee payment data 106b, employee social insurance data 106c, social insurance premium amount master 106d, employee social insurance processing data 106e, and the like.

[0028] The employee attendance data 106a is data that compiles employee absence hours. The employee attendance data 106a stores information including the target year and month, employee number, and absence hours, as shown in an example in FIG.

[0029] The employee payment data 106b is data related to wages paid to employees. As shown in an example in Figure 4, the employee payment data 106b stores wage payment information including the target year and month, employee number, fixed wage, monthly remuneration, paid leave allowance, and paid leave allowance deduction.

[0030] The employee social insurance data 106c stores information for social insurance such as the target year and month, employee number, standard monthly remuneration, and grade, as shown in an example in FIG.

[0031] The social insurance premium master 106d stores a table including standard remuneration or more, standard remuneration, monthly standard remuneration amount, and grade, as shown in an example in FIG.

[0032] The employee social insurance processing data 106e is data for submitting Getsupen-santei. As shown in an example in Figure 9, the employee social insurance processing data 106e stores information such as the employee number, whether or not there is an exclusion flag for each month that is subject to Getsupen-santei, fixed wage and monthly remuneration, previous standard monthly remuneration and grade, revised standard monthly remuneration and grade in the case of Getsupen-santei, and notification classification.

[0033] The control unit 102 is a CPU or the like that comprehensively controls the social insurance information processing device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs.

[0034] The control unit 102 conceptually includes an exclusion flag setting unit 102a, a standard monthly remuneration calculation unit 102b, an employee social insurance processing data creation unit 102c, and the like.

[0035] If there is no holiday in the month following the target month and there is holiday in the period of three months prior to the target month, the exclusion flag setting unit 102a sets an exclusion flag for the month in which holiday occurs.

[0036] The standard monthly remuneration calculation unit 102b calculates the monthly remuneration that has changed due to leave of absence within a three-month period prior to the target month while referencing the exclusion flag set by the exclusion flag setting unit 102a, calculates the average monthly remuneration, and obtains the standard monthly remuneration and grade from the social insurance premium amount master 106d. The standard monthly remuneration calculation unit 102b also determines whether to change the monthly remuneration, calculate, or exclude the target based on the fluctuation in fixed wages between three months prior to the target month and two months prior to the target month, the presence or absence of an exclusion flag, and the processing month.

[0037] The employee social insurance data creation unit 102c creates employee social insurance processing data 106e including the standard monthly remuneration amount and grade acquired by the standard monthly remuneration calculation unit 102b, and the notification classification.

[0038] [2. Processing] Here, a specific example of the process executed by the social insurance information processing device 100 will be described with reference to FIGS.

[0039] Figure 2 is a diagram showing the flow of the social insurance information processing device 100 according to this embodiment. The social insurance information processing device 100 first performs the social insurance registration update process shown on the left side of Figure 2. In the social insurance registration update process, the exclusion flag setting unit 102a determines whether the number of days off in the month following the target month is 0 or greater than 0, and if it is greater than 0, and there are days off within the three months prior to the target month, sets an exclusion flag for the month in which there are days off.

[0040] Next, the social insurance calculation update process is performed on the right side of Figure 2. In the social insurance calculation update process, first, the standard monthly remuneration calculation unit 102b determines whether there is a change in the fixed wage three months and two months before the target month. If there is a change in the fixed wage three months and two months before the target month, and If there are no months with the exclusion flag set between two months prior to the target month, the standard monthly remuneration amount and grade are obtained for the monthly change notification.

[0041] In addition, if there is no change in fixed wages between three months and two months prior to the target month and the target month is June, the standard monthly remuneration calculation unit 102b calculates the monthly remuneration for months other than the month in which the exclusion flag was set within a three-month period prior to the target month, determines the average monthly remuneration, and obtains the standard monthly remuneration and grade for use in the calculation basis notification.

[0042] In addition, if there is a change in fixed wage between three months and two months before the target month, there is a month with the exclusion flag between two months before the target month, and the target month is June, the standard monthly remuneration calculation unit 102b calculates the monthly remuneration for months other than the month in which the exclusion flag was set within a three-month period prior to the target month, determines the average monthly remuneration, and obtains the standard monthly remuneration and grade for use in the calculation basis notification.

[0043] In addition, the standard monthly remuneration calculation unit 102b does not obtain the standard monthly remuneration amount and grade for the monthly change notification and calculation base notification if there is no change in the fixed wage three months and two months prior to the target month and the target month is other than June.

[0044] Below, we will explain the processing in the social insurance information processing device 100, separately for cases where the standard monthly remuneration amount is obtained for a monthly change notification, where the standard monthly remuneration amount is obtained for a calculation basis notification, and where the case is not subject to a monthly change notification or a calculation basis notification.

[0045] First, we will explain how to obtain the standard monthly remuneration amount for a monthly change notification. Figure 3 shows an example of employee attendance data, Figure 4 shows an example of employee payment data, Figure 5 shows an example of employee social insurance data, and Figure 6 shows an example of processing on the social insurance registration screen.

[0046] When the operator enters the employee number and the target month on the social insurance registration screen MA-1 in Figure 6, the previous standard monthly remuneration amount and grade, the result of the exclusion flag setting by the exclusion flow setting unit 102a, and the result of the calculation of the fixed wage and monthly remuneration amount by the standard monthly remuneration calculation unit 102b are output.

[0047] In this case, the target month is month n of 2022, and the standard monthly remuneration is to be calculated as a monthly variable for month n of 2022. The exclusion flow setting unit 102a obtains the absence hours for the month following target month n (month n+1) from employee attendance data 106a-1 in Figure 3. In Figure 3, the absence hours for the month following target month n (month n+1) are 10 hours, so the exclusion flag setting unit 102a does not perform system setting for the exclusion flag (see Figure 6).

[0048] The standard monthly remuneration calculation unit 102b determines whether there is a change in the fixed wage between three months and two months prior to the target month. If there is no leave, the fixed wage will be the fixed wage in the employee payment data 106b-1 in Figure 4, but if there is leave, it will be the fixed wage plus the leave allowance and leave deduction allowance. In Figure 4, the fixed wage for month n-3 of 2022, three months prior to the target month, is 150,000 yen, and the fixed wage for month n-2 of 2022, two months prior to the target month, is 149,200 yen (150,000 yen + 1,200 yen - 2,000 yen), so there is a change in the fixed wage.

[0049] Next, the standard monthly remuneration calculation unit 102b determines whether an exclusion flag has been set between two months prior to the target month. In this case, the number of hours of absence in the month following the target month n (month n+1) is 10 hours, and the exclusion flow setting unit 102a has not set an exclusion flag. Therefore, the standard monthly remuneration calculation unit 102b obtains the standard monthly remuneration and grade based on the monthly remuneration between two months prior to the target month.

[0050] The standard monthly remuneration calculation unit 102b calculates the monthly remuneration that has changed due to absences during the three-month period preceding the target month, and calculates the average monthly remuneration. Similar to the fixed wage, if there are no absences, the monthly remuneration is the monthly remuneration in the employee payment data 106b-1 in Figure 4. However, if there are absences, the monthly remuneration is the sum of the monthly remuneration and absence allowance deduction allowance. The monthly remuneration for the target month, from 2022n to 2022n-2, is 119,200 yen (120,000 yen + 1,200 yen - 2,000 yen), and the average monthly remuneration is also 119,200 yen. The standard monthly remuneration calculation unit 102b obtains the standard monthly remuneration and grade from the social insurance premium master 106d in Figure 7. In the social insurance premium master 106d, the monthly remuneration of 119,200 yen falls into the eighth category from the top, between 114,000 yen and 121,999 yen, resulting in a standard monthly remuneration of 1,118,000 yen and a grade of 8. In addition, in this case, in the flow of Figure 2, there is a change in fixed wages three months and two months before the target month, and there are no months with an exclusion flag between two months before the target month, so the standard monthly remuneration is calculated for the monthly change notification.

[0051] Figure 8 is a diagram showing an example of processing on the social insurance registration screen MA'-1. When input is completed on the social insurance registration screen MA-1 in Figure 6, the social insurance registration screen MA'-1 outputs the monthly standard remuneration amount and grade acquired by the monthly standard remuneration calculation unit 102b, and also outputs the notification classification as a monthly change.

[0052] 9 is a diagram showing an example of the employee social insurance processing data 106e-1. The employee social insurance data creation unit 102c creates the employee social insurance processing data 106e-1, which includes the standard monthly remuneration amount and grade, and the notification classification, output on the social insurance registration screen MA'-1.

[0053] Next, we will explain how to obtain the standard monthly remuneration amount for the calculation basis notification. Fig. 10 is a diagram showing an example of employee attendance data, Fig. 11 is a diagram showing an example of employee payment data, Fig. 12 is a diagram showing an example of employee social insurance data, and Fig. 13 is a diagram showing an example of processing on the social insurance registration screen.

[0054] The cases in which calculations are made are (1) when there is no change in fixed wages between three months and two months before the target month, and the target month is June, and (2) when there is a change in fixed wages between three months and two months before the target month, there is a month with an exclusion flag between two months before and the target month, and the target month is June. We will explain the latter case as an example.

[0055] When the operator enters the employee number and the target month on the social insurance registration screen MA-2 in Figure 13, the previous standard monthly remuneration amount and grade, the result of the exclusion flag setting by the exclusion flow setting unit 102a, and the result of the calculation of the fixed wage and monthly remuneration amount by the standard monthly remuneration calculation unit 102b are output.

[0056] In this case, the target month is June in 2022, and the standard monthly remuneration is calculated as the amount. The exclusion flow setting unit 102a obtains the absence hours for the month following the target month n (month n+1) from the employee attendance data 106a-2 in Figure 10. In Figure 10, the absence hours for the month following the target month n (month n+1) are 0 hours, so the exclusion flag setting unit 102a sets the exclusion flag. The exclusion flag is set when there is absence hours. In Figure 10, exclusion flags are set for months n-2 and n in 2022, which have absence hours (see Figure 13).

[0057] The standard monthly remuneration calculation unit 102b determines whether there is a change in the fixed wage between three months and two months prior to the target month. If there is no leave, the fixed wage will be the fixed wage in the employee payment data 106b-2 in Figure 11. However, if there is leave, the fixed wage will be the amount obtained by adding leave allowance and leave deduction allowance to the fixed wage. In Figure 11, the fixed wage for month n-3 of 2022, which is three months prior to the target month, is 150,000 yen, and the fixed wage for month n-2 of 2022, which is two months prior to the target month, is 149,200 yen (150,000 yen + 1,200 yen - 2,000 yen), so there is a change in the fixed wage.

[0058] Next, the standard monthly remuneration calculation unit 102b determines whether an exclusion flag has been set between two months prior to the target month. In this case, the exclusion flag has been set for 2022n-2 and 2022n. Therefore, the standard monthly remuneration calculation unit 102b obtains the standard monthly remuneration and grade based on the monthly remuneration for 2022n-1 only.

[0059] The standard monthly remuneration calculation unit 102b calculates the monthly remuneration that has changed due to absences during the three-month period preceding the target month, and calculates the average monthly remuneration. Similar to the fixed wage, if there are no absences, the monthly remuneration is the monthly remuneration in the employee payment data 106b in Figure 11. However, if there are absences, the monthly remuneration is the sum of the monthly remuneration and absence allowance deduction allowance. The monthly remuneration for month n-1 of 2022, for which the exclusion flag is not set, is 120,000 yen, and the average monthly remuneration is also 120,000 yen. The standard monthly remuneration calculation unit 102b obtains the standard monthly remuneration and grade from the social insurance premium master 106d in Figure 7. In the social insurance premium master 106d, the monthly remuneration of 120,000 yen corresponds to the eighth from the top, between 114,000 yen and 121,999 yen, resulting in a standard monthly remuneration of 1,118,000 yen and a grade of 8. In addition, in this case, in the flow of Figure 2, there is a change in fixed wages three months and two months before the target month, there is a month with an exclusion flag between two months before the target month, and the processing month is June, so the standard monthly remuneration for the calculation base notification is calculated.

[0060] Fig. 14 is a diagram showing an example of processing on the social insurance registration screen MA'-2. When input is completed on the social insurance registration screen MA-2 in Fig. 13, the social insurance registration screen MA'-2 outputs the standard monthly remuneration amount and grade acquired by the standard monthly remuneration calculation unit 102b, and also outputs the notification classification as a calculation.

[0061] 15 is a diagram showing an example of the employee social insurance processing data 106e-2. The employee social insurance data creation unit 102c creates the employee social insurance processing data 106e-2, which includes the standard monthly remuneration amount and grade, and the notification classification, output on the social insurance registration screen MA'-2.

[0062] Next, we will explain cases that are not subject to monthly changes and calculations. Figure 16 is a diagram showing an example of processing on the social insurance registration screen. Cases that are not subject to monthly changes and calculations include (1) when there is no change in fixed wages three months and two months before the target month, and the target month is a month other than June, and (2) when there is a change in fixed wages three months and two months before the target month, there is a month with an exclusion flag between two months before and the target month, and the target month is a month other than June. We will explain the latter case as an example. Note that in the following case, we will use the employee attendance data 106a-2 (Figure 10), employee payment data 106b-2 (Figure 11), and employee social insurance data 106c-2 (Figure 12) of the calculation case described above, and explain the case where the target month n in 2022 is a month other than June.

[0063] When the operator enters the employee number and the target month on the social insurance registration screen MA-3 in Figure 16, the previous standard monthly remuneration amount and grade, the result of setting the exclusion flag by the exclusion flow setting unit 102a, and the result of calculating the fixed wage and monthly remuneration amount by the standard monthly remuneration calculation unit 102b are output.

[0064] In this case, the target month is month n of 2022 (other than June), and is not subject to monthly changes or calculations. The exclusion flow setting unit 102a obtains the absence hours for the month following target month n (month n+1) from the employee attendance data 106a-2 in Figure 10. In Figure 10, the absence hours for the month following target month n (month n+1) are 0 hours, so the exclusion flag setting unit 102a sets the exclusion flag. The exclusion flag is set when there is absence time. In Figure 10, exclusion flags are set for months n-2 of 2022 and n of 2022, which have absence time (see Figure 13).

[0065] The standard monthly remuneration calculation unit 102b determines whether there is a change in the fixed wage between three months and two months prior to the target month. If there is no leave, the fixed wage will be the fixed wage in the employee payment data 106b-2 in Figure 11. However, if there is leave, the fixed wage will be the amount obtained by adding leave allowance and leave deduction allowance to the fixed wage. In Figure 11, the fixed wage for month n-3 of 2022, which is three months prior to the target month, is 150,000 yen, and the fixed wage for month n-2 of 2022, which is two months prior to the target month, is 149,200 yen (150,000 yen + 1,200 yen - 2,000 yen), so there is a change in the fixed wage.

[0066] Next, the standard monthly remuneration calculation unit 102b determines whether an exclusion flag has been set between two months prior to the target month. In this case, the exclusion flag has been set for 2022n-2 and 2022n. Therefore, the standard monthly remuneration calculation unit 102b obtains the standard monthly remuneration and grade based on the monthly remuneration for 2022n-1 only.

[0067] The standard monthly remuneration calculation unit 102b calculates the monthly remuneration that has changed due to absences during the three-month period preceding the target month, and calculates the average monthly remuneration. Similar to the fixed wage, if there are no absences, the monthly remuneration is the monthly remuneration in the employee payment data 106b in Figure 11. However, if there are absences, the monthly remuneration is the sum of the monthly remuneration and absence allowance deduction allowance. The monthly remuneration for month n-1 of 2022, for which the exclusion flag is not set, is 120,000 yen, and the average monthly remuneration is also 120,000 yen. The standard monthly remuneration calculation unit 102b obtains the standard monthly remuneration and grade from the social insurance premium master 106d in Figure 7. In the social insurance premium master 106d, the monthly remuneration of 120,000 yen corresponds to the eighth from the top, between 114,000 yen and 121,999 yen, resulting in a standard monthly remuneration of 1,118,000 yen and a grade of 8. In addition, in this case, in the flow of Figure 2, there is a change in fixed wages three months and two months before the target month, there is a month with an exclusion flag between two months before the target month, and the processing month is other than June, so it is not included.

[0068] Figure 17 is a diagram showing an example of processing on the social insurance registration screen MA'-3. When input is completed on the social insurance registration screen MA-3 in Figure 16, the social insurance registration screen MA'-3 outputs the standard monthly remuneration amount and grade acquired by the standard monthly remuneration calculation unit 102b, and also outputs the notification category as excluded.

[0069] 18 is a diagram showing an example of the employee social insurance processing data 106e-3. The employee social insurance data creation unit 102c creates the employee social insurance processing data 106e-3, which includes the standard monthly remuneration amount and grade, and the notification classification, output on the social insurance registration screen MA'-3.

[0070] The social insurance information processing device 100 of this embodiment sets an exclusion flag for the month in which there is holiday time if there is no holiday time in the month following the target month, but there is holiday time within the three-month period prior to the target month.This makes it possible to automatically obtain the standard monthly remuneration amount and grade by referring to the exclusion flag when calculating the monthly change, thereby significantly reducing the effort involved in the work.

[0071] [3. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.

[0072] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0073] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to Goal 16 of the SDGs.

[0074] 4. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0075] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0076] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.

[0077] Furthermore, with regard to the social insurance information processing device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0078] For example, all or any part of the processing functions of the social insurance information processing device 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the social insurance information processing device 100 as needed. That is, a computer program for providing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

[0079] In addition, this computer program may be stored in an application program server connected to the social insurance information processing device 100 via any network, and all or part of it may be downloaded as needed.

[0080] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.

[0081] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0082] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

[0083] The social insurance information processing device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as an information processing device connected to any peripheral device. The social insurance information processing device 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.

[0084] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

[0085] The present invention can be used in industries where many employees are absent due to temporary leave, such as the temporary staffing industry. [Explanation of symbols]

[0086] 100 Social insurance information processing device 102 Control section 102a Exclusion Flags 102b Standard Monthly Remuneration Calculation Section 102c Employee Social Insurance Processing Data Creation Department 104 Communication interface unit 106 Storage section 106a Employee attendance data 106b Employee Payment Data 106c Employee Social Insurance Data 106d Social insurance premium amount master 106e Employee Social Insurance Processing Data 108 Input / Output Interface Section 200 servers 300 Network 400 Input Device 500 output devices

Claims

1. A social insurance information processing device including a control unit, Employee attendance data including employee monthly absence times, Employee pay data including monthly fixed wages, monthly remuneration, paid leave allowances and paid leave allowance deductions; Employee social insurance data including monthly standard salary and grade of employees, Social insurance premium master including standard remuneration above, below, standard remuneration monthly amount and grade, is accessible to The control unit an exclusion flag setting unit that sets an exclusion flag for a month in which there is a holiday if there is no holiday in the month following the target month and there is a holiday within a period of three months prior to the target month; If there is a change in fixed wages between three months and two months prior to the target month, and there are no months with the exclusion flag between two months prior to the target month, the standard monthly remuneration amount and grade are obtained from the social insurance premium amount master for the monthly change notification. If there is no change in fixed wages between three months and two months prior to the target month, and the target month is June, calculate the monthly remuneration for the months other than the months for which the exclusion flag is set within the three-month period prior to the target month, calculate the average monthly remuneration, and obtain the standard monthly remuneration and grade from the social insurance premium amount master for the calculation basis notification. a standard monthly remuneration calculation unit that calculates the monthly remuneration for months other than the months with the exclusion flag set within a three-month period from the target month to obtain an average monthly remuneration, and acquires the standard monthly remuneration amount and grade from the social insurance premium amount master for use in the calculation base notification, when there is a change in fixed wage between three months and two months prior to the target month, there is a month with the exclusion flag set between two months prior to the target month, and the target month is June; A social insurance information processing device comprising:

2. The standard monthly remuneration calculation unit does not obtain the standard monthly remuneration and grade for the monthly change notification and calculation base notification if there is no change in the fixed wage three months and two months prior to the target month and the target month is other than June.

2. The social insurance information processing device according to claim 1.

3. The standard monthly remuneration calculation unit does not obtain the standard monthly remuneration and grade for the monthly change notification and calculation basis notification if there is a change in fixed wage three months and two months before the target month, there is a month with the exclusion flag between two months before the target month, and the target month is other than June, 2. The social insurance information processing device according to claim 1.

4. A social insurance information processing method executed by a social insurance information processing device having a control unit, The social insurance information processing device includes: Employee attendance data including employee monthly absence times, Employee pay data including monthly fixed wages, monthly remuneration, paid leave allowances and paid leave allowance deductions; Employee social insurance data including monthly standard salary and grade of employees, Social insurance premium master including standard remuneration above, below, standard remuneration monthly amount and grade, is accessible to The control unit executes an exclusion flag setting step for setting an exclusion flag for the month in which there is a closure time if there is no closure time in the month following the target month and there is a closure time within a period of three months prior to the target month; If there is a change in fixed wages between three months and two months prior to the target month, and there are no months with the exclusion flag between two months prior to the target month, the standard monthly remuneration amount and grade are obtained from the social insurance premium amount master for the monthly change notification. If there is no change in fixed wages between three months and two months prior to the target month, and the target month is June, calculate the monthly remuneration for the months other than the months for which the exclusion flag is set within the three-month period prior to the target month, calculate the average monthly remuneration, and obtain the standard monthly remuneration and grade from the social insurance premium amount master for the calculation basis notification. a standard monthly remuneration calculation step in which, if there is a change in fixed wage between three months and two months prior to the target month, there is a month with the exclusion flag between two months prior to the target month, and the target month is June, the monthly remuneration for the months other than the months with the exclusion flag set within a three-month period prior to the target month is calculated to determine the average monthly remuneration, and the standard monthly remuneration amount and grade are obtained from the social insurance premium amount master for use in the calculation basis notification; A social insurance information processing method comprising:

5. A social insurance information processing program to be executed by a social insurance information processing device having a control unit, The social insurance information processing device includes: Employee attendance data including employee monthly absence times, Employee pay data including monthly fixed wages, monthly remuneration, paid leave allowances and paid leave allowance deductions; Employee social insurance data including monthly standard salary and grade of employees, Social insurance premium master including standard remuneration above, below, standard remuneration monthly amount and grade, is accessible to To be executed by the control unit, an exclusion flag setting step for setting an exclusion flag for the month in which there is a closure time if there is no closure time in the month following the target month and there is a closure time within a period of three months prior to the target month; If there is a change in fixed wages between three months and two months prior to the target month, and there are no months with the exclusion flag between two months prior to the target month, the standard monthly remuneration amount and grade are obtained from the social insurance premium amount master for the monthly change notification. If there is no change in fixed wages between three months and two months prior to the target month, and the target month is June, calculate the monthly remuneration for the months other than the months for which the exclusion flag is set within the three-month period prior to the target month, calculate the average monthly remuneration, and obtain the standard monthly remuneration and grade from the social insurance premium amount master for the calculation basis notification. a standard monthly remuneration calculation step in which, if there is a change in fixed wage between three months and two months prior to the target month, there is a month with the exclusion flag between two months prior to the target month, and the target month is June, the monthly remuneration for the months other than the months with the exclusion flag set within a three-month period prior to the target month is calculated to determine the average monthly remuneration, and the standard monthly remuneration amount and grade are obtained from the social insurance premium amount master for use in the calculation basis notification; A social insurance information processing program comprising:

Images