Business support device, business support method, and business support program

Abstract

To prevent erroneous payments due to failure to register changes in information used for payroll calculations, and to distribute the workload associated with this process. [Solution] The business support device of this embodiment includes a revision table creation means that creates a fixed item pre-printed revision table 106a containing revision date, employee identification information, table name, items, and new values ​​for the items, and registers it in the storage unit 106; and an area creation means that creates an area for a target table 106d, which is used for payroll calculation and contains the target date, employee identification information, and item values ​​for each month, and registers it in the storage unit 106. The area creation means updates the value of the item for the target date in the target table 106d to the new value in the matching fixed item pre-printed revision table 106a if the target date and table name of the target table match the revision date and table name of the fixed item pre-printed revision table 106a registered in the storage unit 106.

Description

Technical Field

[0001] The present invention relates to a business support device, a business support method, and a business support program.

Background Art

[0002] For example, since the process of salary payment conducted annually repeats almost the same cycle every year, there may be cases where future revision contents are determined in the information used for salary calculation. As a system related to salary calculation, for example, there is Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, conventionally, during the implementation of the monthly processing for the current month, it has been impossible to register future information after the next month, and the previously determined revision contents have needed to be managed outside the system such as in Excel. Therefore, after the revision month arrives, it has been necessary to perform registration and confirmation work based on the previously backed-up revision contents, which has risked concentrating the work load. Also, since the revision month varies depending on employees and items, there has been a risk of registration omission.

[0005] The present invention has been made in view of the above, and for information used in salary calculation (salary payment), it is an object to provide a business support device, a business support method, and a business support program capable of preventing incorrect payment due to registration omission of revision contents of information used in salary calculation and dispersing the work load by pre-reserving and registering the revision contents for the revision month that will occur in the future and automatically reflecting the revision contents in the revision month.

Means for Solving the Problems

[0006] To solve the above-mentioned problems and achieve the objective, the present invention provides a business support device equipped with a control unit, wherein the control unit comprises: revision table creation means for creating a fixed item pre-approved revision table including revision date, employee identification information, table name, item, and new value of the item, and registering it in a storage area; and area creation means for creating an area of ​​a target table used for payroll calculation, which includes a target date, employee identification information, and item value for each month, and registering it in the storage area, wherein the area creation means updates the value of the item for the target date in the target table to the new value of the matching fixed item pre-approved revision table when the target date and table name of the target table match the revision date and table name of the fixed item pre-approved revision table registered in the storage area.

[0007] Furthermore, according to one aspect of the present invention, the target table may include a social insurance table.

[0008] Furthermore, according to one aspect of the present invention, the control unit may be configured to access a selection candidate classification list master in which table names are registered, and an item list master in which table names and item names are registered in association.

[0009] Furthermore, according to one aspect of the present invention, the area creation means may create an area for the target table for all table names stored in the selection candidate classification list master.

[0010] Furthermore, according to one aspect of the present invention, the revision table creation means may create the fixed item pre-revision table based on the new values ​​of the selected items entered by the operator, on a display screen having an area 1 where a list of table names of the selected candidate classification list master is displayed, an area 2 where the selected items are displayed, and an area 2 where the selected items are displayed.

[0011] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention provides a business support method executed by an information processing device equipped with a control unit, comprising: a revision table creation step, which is performed by the control unit to create a fixed item pre-approved revision table including revision year and month, employee identification information, table name, items, and new values ​​for said items, and to register it in a storage area; and a region creation step, which is used for payroll calculation and is performed each month to create a region for a target table including target year and month, employee identification information, and item values, and to register it in the storage area, wherein in the region creation step, if the target year and month and table name of the target table match the revision year and month and table name of the fixed item pre-approved revision table registered in the storage area, the value of the item for the target year and month of the target table is updated to the new value of the matching fixed item pre-approved revision table.

[0012] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention is a business support program to be executed by an information processing device equipped with a control unit, wherein the control unit is configured to perform a revision table creation step of creating a fixed-item pre-approved revision table containing revision date, employee identification information, table name, items, and new values ​​for the items, and registering it in a storage area, and a region creation step of creating a region for a target table used in payroll calculation, which contains a target date, employee identification information, and item values ​​for each month, and registering it in the storage area, wherein in the table creation step, if the target date and table name of the target table match the revision date and table name of a fixed-item pre-approved revision table registered in the storage area, the value of the item for the target date in the target table is updated to the new value of the matching fixed-item pre-approved revision table. [Effects of the Invention]

[0013] According to the present invention, by pre-registering revisions to information used for payroll calculation (payroll payment) for future revision months, and automatically reflecting these revisions in the revision months, it becomes possible to prevent erroneous payments due to omissions in registering revisions to information used for payroll calculation and to distribute the workload. [Brief explanation of the drawing]

[0014] [Figure 1] Figure 1 is a diagram illustrating a concrete example of the conventional processing of information used in payroll calculations (social insurance). [Figure 2] Figure 2 is a diagram illustrating a concrete example (allowances) of the conventional processing of information used in payroll calculations. [Figure 3] Figure 3 is a block diagram showing an example of the configuration of the business support device according to this embodiment. [Figure 4] Figure 4 shows an example of the general structure of the fixed item pre-revision table, the selection candidate classification list master, and the item list master. [Figure 5]Fig. 5 is a diagram for explaining an overview of the overall processing of the control unit of the business support apparatus according to the present embodiment. [Figure 6] Fig. 6 is a diagram for explaining a specific example of the processing of the control unit of the business support apparatus according to the present embodiment. [Figure 7] Fig. 7 is a diagram for explaining a specific example of the processing of the control unit of the business support apparatus according to the present embodiment. [Figure 8] Fig. 8 is a diagram for explaining a specific example of the processing of the control unit of the business support apparatus according to the present embodiment. [Figure 9] Fig. 9 is a diagram for explaining a specific example of the processing of the control unit of the business support apparatus according to the present embodiment. [Figure 10] Fig. 10 is a diagram for explaining a specific example of the processing of the control unit of the business support apparatus according to the present embodiment. [Figure 11] Fig. 11 is a diagram for explaining a specific example of the processing of the control unit of the business support apparatus according to the present embodiment. [Figure 12] Fig. 12 is a diagram for explaining a specific example of the processing of the control unit of the business support apparatus according to the present embodiment. [Figure 13] Fig. 13 is a diagram for explaining a specific example of the processing of the control unit of the business support apparatus according to the present embodiment. [Figure 14] Fig. 14 is a diagram for explaining a specific example of the processing of the control unit of the business support apparatus according to the present embodiment. [Embodiments for Carrying Out the Invention]

[0015] Hereinafter, embodiments of a business support apparatus, a business support method, and a business support program according to the present invention will be described in detail based on the drawings. Note that the present invention is not limited by the present embodiment.

[0016] [1. Overview] For example, the annual payroll processing process remains largely unchanged year after year, repeating the same cycle. Therefore, the information used in payroll calculations may already contain information about future revisions.

[0017] However, previously, it was not possible to register information for the following months or beyond while monthly processing was underway, and predetermined revisions had to be managed outside the system, such as in Excel. As a result, registration and verification work had to be performed based on the previously saved revisions once the revision month arrived, which could lead to a concentration of workload. Furthermore, since revision months differed depending on the employee and item, there was a risk of registration being missed.

[0018] Referring to Figures 1 and 2, a concrete example of conventional processing of information used for payroll calculation will be explained.

[0019] Figure 1 illustrates Case 1: Social Insurance (Regular Determination) Operations. Social insurance premiums are determined after the annual salary payment in June, but the determined premiums are not reflected until September. Since all registration and verification work must be done in September, the revision month, there is a risk of a concentration of workload.

[0020] In Figure 1, (1) In June, the payroll staff prepares to create the calculation basis report based on the salaries paid from April to June. (2) In early July, the payroll staff creates the calculation basis report and submits it to the pension office. (3) In mid-July, the standard monthly remuneration determination notice arrives by mail (social insurance premiums from September are determined). Thus, there is a gap between the determination of the standard monthly remuneration and the month in which it is reflected. During this period from July to August, there is payroll calculation processing before the revision, so it is not possible to register the determined amount, etc. (4) The payroll staff registers the new social insurance premiums and verifies the registration details. In the month in which it is reflected, it is necessary to register the new social insurance premiums and perform verification work after registration all at once, which concentrates the workload.

[0021] Figure 2 is a diagram illustrating Case 2: Salary revision work (changes to allowance amounts, etc.). In Figure 2, (1) in February, a salary revision is decided, and some allowance amounts will be changed from April of the following year. The payroll staff will temporarily manage the decided changes in Excel or similar software. Because there is a gap between the decision on the revised content and the month in which it is implemented, there is a risk that registration may be missed in the month in which the changes are reflected.

[0022] (2) In April, the payroll officer will reflect and verify the revised amounts based on the contents of the Excel file. Because registration and post-registration verification must be done all at once in the month in which the changes are reflected, the workload becomes concentrated, which could lead to incorrect payments.

[0023] In this embodiment, the information used for payroll calculation (payroll payment) is registered in advance for revisions that will occur in future revision months, and the revised information is automatically reflected in the revision month. This prevents erroneous payments due to omissions in registering revisions to the information used for payroll calculation and distributes the workload.

[0024] More specifically, the workload associated with revisions will be distributed by creating a system that retains the revision month and content and reflects them in the revision month. By creating a system that allows for pre-registration of revision content for all salary attribute items, the scope of revisions can be freely set.

[0025] According to this embodiment, the following effects can be achieved. • Since registration can be performed immediately after the revision details are decided, work efficiency can be improved compared to before. • By pre-registering revisions, the risk of missing registrations can be reduced. • Since registration and verification do not need to be performed simultaneously, the workload can be distributed.

[0026] The business support device of the present invention is effective in preventing omissions and errors in work, even when there is a period between the determination of the amount of allowances and deductions related to salary and their reflection in the salary, and even when the timing of the determination itself differs for each employee. Furthermore, the business support device of the present invention is applicable to all industries and all types of businesses, and can be applied to all information related to payroll calculation (payment), such as insurance premiums including social insurance premiums, wage revisions due to salary increases and promotions, and resident tax amount revisions.

[0027] [2. Structure] The configuration of the business support device 100 according to this embodiment will be described with reference to Figure 3. Figure 3 is a block diagram showing an example of the configuration of the business support device 100.

[0028] The business support device 100 is, for example, a commercially available desktop personal computer or workstation. As shown in Figure 3, the business support device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the business support device 100 is connected to communicate via any communication path.

[0029] The communication interface unit 104 connects the business support device 100 to the network 300 via communication devices such as routers and wired or wireless communication lines such as dedicated lines, enabling communication between the two. The communication interface unit 104 also has the function of communicating data with other devices via communication lines. Here, the network 300 has the function of connecting the business support device 100 and the server 200 so that they can communicate with each other, and is, for example, the internet or a LAN (Local Area Network).

[0030] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, mouse, microphone, or a monitor that works in conjunction with a mouse to provide pointing device functionality. In the following, the output device 114 may be referred to as the monitor 114 as a display unit, and the input device 112 may be referred to as the keyboard 112 or mouse 112.

[0031] The memory unit (storage area) 106 stores various databases, tables, and files. The memory unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the memory unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

[0032] Furthermore, the storage unit 106 stores the fixed item pre-revision table 106a, the selection candidate classification list master 106b, the item list master 106c, the target table 106d, payroll data, etc. Figure 4 is a diagram showing an example of the general configuration of the fixed item pre-revision table 106a, the selection candidate classification list master 106b, and the item list master 106c.

[0033] The fixed item pre-revision table 106a can consist of the revision year and month, employee identification information (employee code and / or employee name), table name, field name (item name), and a table registered with associated new values, as shown in Figure 4. The table name is the name of the table for all attribute items (employee information) used in payroll calculation.

[0034] The selection candidate classification list master 106b can be composed of tables with registered table names, as shown in Figure 4.

[0035] As shown in Figure 4, the item list master 106c can be composed of tables and other items registered with associated table names and item names.

[0036] The control unit 102 is a CPU or similar component that comprehensively controls the business support device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.

[0037] The control unit 102 is configured to access the fixed item pre-revision table 106a, the selection candidate classification list master 106b, the item list master 106c, the target table 106d, the payroll data, etc., which are stored in the storage unit 106. Note that the fixed item pre-revision table 106a, the selection candidate classification list master 106b, the item list master 106c, the target table 106d, the payroll data, etc. may be located in another location (for example, on the server 200), as long as the control unit 102 can access them.

[0038] Functionally, the control unit 102 comprises a payroll date registration unit (revision table creation means, area creation means) 102a, a payroll calculation processing unit 102b, a payroll transfer processing unit 102c, and a screen display control unit 102d.

[0039] The payroll date registration unit 102a creates a fixed item pre-revision table 106a containing the revision year and month, employee identification information, table name, items, and new values ​​for those items, in response to, for example, the operator's actions on the fixed item pre-revision registration screen displayed on the monitor 114, and stores it in the storage unit 106.

[0040] The payroll registration unit 102a creates an area for the target table 106d each month, containing the target year and month, employee identification information, and item values, and stores it in the storage unit 106. In this case, for example, initial data (first month) for the target table 106d may be created in response to operator operations on the employee information registration screen, and for subsequent months, the details of the previous month may be copied.

[0041] If the target year and month and table name of the target table 106d match the revision year and month and table name of the fixed item pre-revision table 106a registered in the storage unit 106, the payroll date registration unit 102a updates the value of the item for the target year and month in the target table to the new value of the matching fixed item pre-revision table 106a.

[0042] The payroll date registration unit 102a may also create an area for the target table 106d for all table names stored in the selection candidate classification list master 106b.

[0043] On the Fixed Item Pre-Revision Registration screen, Area A1 displays a list of table names in the Selection Candidate Classification List Master 106b, and Area A2 displays the item names in the Item List Master 106c associated with the table names selected in "Selection Candidate Classification". The Payroll Payment Date Registration Unit 102a may also create the Fixed Item Pre-Revision Table 106a based on the new values ​​of the selected items entered by the operator for the table names and selected items selected by the operator.

[0044] The payroll processing unit 102b creates payroll data for each employee for the current month based on the target table 106d for the current month and stores it in the storage unit 106.

[0045] The payroll processing unit 102c processes payroll payments based on the payroll data for each employee for the current month.

[0046] The screen display control unit 102d controls the display and input of various screens (for example, the fixed item pre-subscription revision registration screen, the employee information registration screen, etc.) displayed on the monitor 114.

[0047] [3. Specific Examples] Referring to Figures 1 to 14, a specific example of the processing of the control unit of the business support device 100 in this embodiment will be explained. Referring to Figure 5, an overview of the overall processing of the control unit of the business support device 100 in this embodiment will be explained. Figure 5 is a diagram showing an overview of the overall processing of the control unit of the business support device 100 in this embodiment and an example of the data of the selection candidate classification list master 106b.

[0048] (3-1. Overall Processing) Referring to Figure 5, the overall processing of the control unit of the business support device 100 in this embodiment will be described.

[0049] In Figure 5, for each month (January to December), the payroll payment date registration unit 102a executes the payroll payment date registration process (step S1), the payroll calculation processing unit 102b executes the payroll calculation process (step S2), and the payroll transfer processing unit 102c executes the payroll transfer process (step S3).

[0050] Specifically, in the payroll date registration process (step S1), the payroll date registration unit 102a creates an area for the target table 106d, which includes the target year and month, employee identification information, and item values, for each month, and stores it in the storage unit 106. In this case, for example, initial data for the target table 106d (first month: January) may be created in response to the operator's operation on the employee information registration screen, and for subsequent months, the details of the previous month may be copied. In addition, the payroll date registration unit 102a creates a fixed item pre-application revision table 106a, which includes the revision year and month, employee identification information, table name, items, and new values ​​for those items, in response to the operator's operation on the fixed item pre-application revision registration screen displayed on the monitor 114, and stores it in the storage unit 106. If the target year and month and table name of the target table 106d match the revision year and month and table name of the fixed item pre-revision table 106a registered in the storage unit 106, the payroll date registration unit 102a updates the value of the item for the target year and month in the target table to the new value of the matching fixed item pre-revision table 106a.

[0051] Thus, in the payday registration process (step S1), (1) the data from the previous month is copied to all target tables 106d to create the details for the current month, and (2) the target tables 106d in (2) are updated by referring to the fixed item pre-application revision table 106a.

[0052] (1) and (2) are performed on all target tables whose table names are stored in the Selection Candidate Classification List Master 106b. (2) is a mechanism that can be set arbitrarily by each system user. When registering in the Fixed Item Pre-Applied Revision Table 106a, the tables that can be selected are those that consist only of fixed items (items that change with each payroll processing are excluded).

[0053] Here, "fixed items" are items whose information change cycle is long or that do not change at all (such as name and date of birth), and are copied from the previous month when registering the payday. "Variable items" are items whose information changes with each payroll processing (such as overtime hours and payment amount), and are not copied from the previous month when registering the payday.

[0054] In the example of the selection candidate classification list master 106b shown in Figure 5, table names such as basic attributes, address, tax category, email distribution, social insurance, labor insurance, previous employment information, bank, previous cumulative total, commuting allowance, paid leave, attendance, payment, and deduction are stored.

[0055] In the payroll processing step (S2), the payroll processing unit 102b creates payroll data for each employee for the current month based on the details in the target table for the current month.

[0056] In the payroll transfer process (step S3), the payroll transfer processing unit 102c performs payroll transfer processing based on the payroll data for each employee for the current month.

[0057] (3-2. Sample Data) Figures 6 to 14 are diagrams showing sample data to illustrate a specific example of the payroll payment date registration process S1 of the payroll payment date registration unit 102a of the business support device 100 in this embodiment. Referring to Figures 6 to 14, a specific example of the payroll payment date registration process S1 of the payroll payment date registration unit 102a of the business support device 100 in this embodiment will be explained. In the payroll payment date registration process S1, for the data of the target table 106d of all table names registered in the selection candidate classification list master 106b, the following is performed monthly: (1) copying of the previous month's data, and (2) updating process referring to the fixed item pre-application revision table 106a. Here, as an example, the creation and updating of data in the social insurance table will be explained as the target table 106d. As explained in Figure 1 above, social insurance revisions are decided in June and the revised content is implemented from September, so the following will explain the process from June 2024. The social insurance table up to May 2024 is assumed to be stored in the storage unit 106.

[0058] 1. Register the payday for June 2024. In each target table 106d, the information from the previous month is copied, and details for the June area (target year and month = 202406) are created. Payroll calculations and other processes use values ​​filtered based on the target year and month of each target table.

[0059] Figure 6(A) is a diagram illustrating an example of creating a statement for June in the social insurance table. The social insurance table contains the following fields: target year and month, employee code, health insurance grade, employee pension grade, standard health insurance remuneration, and standard employee pension remuneration. The "target year and month" field is created when the payday is registered and is stored in the table. The statement for the previous month (target year and month = 202405) is copied to the field where target year and month = 202406.

[0060] Figure 6(B) shows an example of a fixed-item pre-revision table 106a. The fixed-item pre-revision table 106a has fields for revision year and month, employee code, table name, field name (item name), and new value. The "revision year and month" is the year and month to which the revision content should be reflected, and is stored in the fixed-item pre-revision table 106a.

[0061] If the target year and month and table name of the social insurance table match the revision year and month and table name of the fixed item pre-application revision table 106a registered in the storage unit 106, an update process is executed (for the target year and month of the social insurance table, the value of the item is updated to the new value of the matching fixed item pre-application revision table 106a). In this example, the revision year and month is 202406, and the table name is "Social Insurance Table," but there is no such table, so the update process is skipped.

[0062] 2. Register future revisions in advance (via the fixed item pre-revision registration screen). Figure 7(A) shows an example of the display of the main screen 400 of the fixed item pre-application revision registration screen. Figure 7(B) shows an example of data for the selection candidate classification list master 106b. Figure 7(C) shows an example of data for the item list master 106c.

[0063] The main screen 400 of the fixed item pre-application revision registration screen, as shown in Figure 7(A), includes area A1 for displaying candidate items, area A2 for displaying selected items, and add buttons (>), delete buttons (<), and execute buttons.

[0064] Area A1 displays "Selection Candidate Classification," which shows a list of table names from the Selection Candidate Classification List Master 106b, and "Selected Item Name," which shows the item names from the Item List Master 106c associated with the table name selected in Selection Candidate Classification. Select the table you want to revise from "Selection Candidate Classification," and select the item you want to revise from "Selected Item Name."

[0065] In Area A2, the "Selected Item" selected in "Selected Item Name" is displayed. You can select (add) an item by specifying the item in "Selected Item Name" in Area A1 (for example, by left-clicking) and pressing the add button (>), and the selected item will be displayed in "Selected Items" in Area A2. Items added to "Selected Items" can be deleted by specifying the item (for example, by left-clicking) and pressing the delete button (<).

[0066] Select the table and its items that you want to revise, and then press the execute button. The details screen 500 of the fixed item pre-application revision registration screen (see Figure 8) will be displayed.

[0067] In this example, the "Selection Candidate Classification" field displays table names such as Basic Attributes, Address, Tax Classification, Email Distribution, Social Insurance, Labor Insurance, Previous Employment Information, Bank, Previous Cumulative Total, Commuting Allowance, Paid Leave, Attendance, Payment, and Deduction, which are read from the Selection Candidate Classification List Master 106b. When the Social Insurance table is selected in the Selection Candidate Classification, the "Selection Item Name" field displays items from the Item List Master 106c that are linked to the Social Insurance table, such as Social Insurance Collection Classification, Health Insurance Classification, Long-Term Care Insurance Classification, Health Insurance Grade, Health Insurance Revision Date, Employees' Pension Classification, Employees' Pension Grade, Employees' Pension Revision Date, etc. Furthermore, the "Selection Item" field displays Health Insurance Grade, Employees' Pension Grade, Health Insurance Standard Remuneration, and Employees' Pension Standard Remuneration, which are selected from the "Selection Item Name" field.

[0068] When you press the execute button, the details screen 500 of the fixed item pre-application revision registration screen will be displayed, as shown in Figure 8.

[0069] Figure 8 shows an example of the display of detail screen 500 of the fixed item pre-application revision registration screen. On detail screen 500, the revision year and month and revision details are registered. Detail screen 500 includes a header area with fields for specifying the revision year and month, a field for specifying the target year and month, and buttons for ascending, descending, filtering, clearing, and batch update, as well as a detail area for setting the update details. The operator selects the "revision year and month" and "target year and month".

[0070] In the details area, the vertical axis represents employees, and the horizontal axis displays the items selected on the initial screen 400. The upper section displays the information before the revision, and the lower section is where the revision details are entered. Items with revision details entered are highlighted (for example, by changing the background color to yellow). When the extract button is pressed, the information of the selected items for the specified target year and month in the table selected on the initial screen 400 is read from the target table 106d (in this example, the social insurance table) and displayed. The operator enters the revision details for the selected items in the lower section. When the batch update button is pressed, a fixed item pre-approved revision table 106a is registered according to the input on the screen (revision year and month, revision details of the items).

[0071] In this example, revision date = 2024 / 9 and target date = 2024 / 6 are specified. For target date = 2024 / 6, information on health insurance grade, employee pension grade, standard health insurance remuneration, and standard employee pension remuneration is read from the social insurance table of target table 106d and displayed. Through operator operations, for example, for employee code "10001", the employee pension grade is revised from "28" to "30", and the standard employee pension remuneration is revised from "560,000" to "620,000".

[0072] In this input, a fixed item pre-application revision table 106a, as shown in Figure 9(B), will be registered.

[0073] Figure 9(A) shows an example of data from the social insurance table for the target year and month = 2024 / 6.

[0074] Figure 9(B) shows an example of data in the fixed item pre-revision table 106a that is registered. The fixed item pre-revision table 106a has fields for revision year and month, table name, employee code, field name (item name), and new value. Only the fields for employees who registered the revision details on the details screen 500 are registered. In the example shown in Figure 9(B), for revision year and month = 2024 / 9, two records are created for employee code = 10001 because there were changes to the employee pension grade and employee pension standard remuneration. No record is created for employee code = 10002 because there were no changes. For employee code = 10003, four records are created because there were changes to the health insurance grade, employee pension grade, health insurance standard remuneration, and employee pension standard remuneration. For employee code = 10004, two records are created because there were changes to the health insurance grade and health insurance standard remuneration.

[0075] 3. Register the payday for each month. Figure 10(A) shows an example of the details for July in the social insurance table. The details for the previous month (Target Year / Month = 202406) are copied to the field with Target Year / Month = 202407.

[0076] Figure 10(B) shows an example of a fixed item pre-revision table 106a. If the target year and month "202407" in the target table "Social Insurance Table" matches the revision year and month in the fixed item pre-revision table 106a, the Social Insurance Table is updated. In this example, the fixed item pre-revision table 106a does not have a table with revision year and month = 202407 and table name = Social Insurance Table, so the update process is skipped.

[0077] Figure 11(A) shows an example of the details for August in the social insurance table. The details for the previous month (Target Year / Month = 202407) are copied to the field with Target Year / Month = 202408.

[0078] Figure 11(B) shows an example of a fixed item pre-revision table 106a. If the target year and month "202408" in the target table "Social Insurance Table" matches the revision year and month in the fixed item pre-revision table 106a, the target table is updated. In this example, the fixed item pre-revision table 106a does not have a table with revision year and month = 202408 and table name = Social Insurance Table, so the update process is skipped.

[0079] Figure 12 shows an example of the details for September in the social insurance table. The details for the previous month (Target Year / Month = 202408) are copied to the field with Target Year / Month = 202409.

[0080] Figure 13(A) shows an example of the fixed item pre-revision table 106a. If the target year and month "202409" in the target table "Social Insurance Table" matches the revision year and month in the fixed item pre-revision table 106a, the Social Insurance Table is updated. In this example, the fixed item pre-revision table 106a has "Revision Year and Month = 202409" and "Table Name = Social Insurance Table" registered, so the update process is performed.

[0081] As shown in Figure 13(B), the value of the field item for the target year and month "202409" in the social insurance table is updated to the new value for the revision year and month "202409" in the corresponding fixed item pre-revision table 106a. In this example, for example, for the target year and month "202409", the employee code "10001" will be updated to have a pension grade from "28" to "30" and a pension standard remuneration from "560,000" to "620,000".

[0082] After registering the payday for the revised month and year, the revised details are automatically updated and reflected on the screen. Figure 14 shows an example of the display on the employee information registration screen 600. The revised details for September, which were registered in advance, are reflected simultaneously when the payday for September is registered. This helps prevent errors in updating revised details and helps distribute the workload.

[0083] As described above, according to this embodiment, the system includes a revision table creation means that creates a fixed item pre-application revision table 106a containing the revision date, employee identification information, table name, items, and new values ​​for those items, and registers it in the storage unit 106, and an area creation means that creates an area for a target table 106d, which is used for payroll calculation and contains the target date, employee identification information, and item values ​​for each month, and registers it in the storage unit 106. The table creation means updates the value of the item for the target date in the target table 106d to the new value of the matching fixed item pre-application revision table 106a when the target date and table name of the target table match the revision date and table name of the fixed item pre-application revision table 106a registered in the storage unit 106. This makes it possible to pre-register revision details for future revision months for information used in payroll calculation (payroll payment) and automatically reflect the revision details in the revision month, thereby preventing erroneous payments due to omissions in registering revision details for information used in payroll calculation and distributing the workload.

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

[0085] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0086] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

[0087] [5. Other Embodiments] In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

[0088] 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 by known methods.

[0089] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0090] Furthermore, with respect to the business support device 100, each component shown in the diagram is a functional concept and does not necessarily need to be physically configured as shown.

[0091] For example, the processing functions of the business support device 100, particularly those performed by the control unit, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the business support device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) contains a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.

[0092] Furthermore, this computer program may be stored on an application program server connected to the business support device 100 via any network, and it is possible to download all or part of it as needed.

[0093] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0094] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

[0095] The various databases stored in the memory unit are 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 website provision.

[0096] Furthermore, the business support device 100 may be configured as a known personal computer or workstation or other information processing device, or as an information processing device to which any peripheral devices are connected. Alternatively, the business support device 100 may be implemented by installing software (including programs or data, etc.) that enables the processing described in this embodiment on the device.

[0097] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Explanation of symbols]

[0098] 100 Business support equipment 102 Control Unit 102a Payroll Payment Date Registration Department 102b Payroll Processing Unit 102c Payroll Processing Unit 102d Screen display control unit 104 Communication Interface Section 106 Storage section 106a Fixed Item Pre-Revision Table 106b Selection Candidate Classification List Master 106c Item List Master 106d Target Table 108 Input / Output Interface Section 112 Input device 114 Output device 300 Networks

Claims

1. A business support device equipped with a control unit, The control unit, A revision table creation means that creates a fixed-item pre-registered revision table containing the revision date, employee identification information, table name, items, and new values ​​for those items, and registers it in the storage area. This is used for payroll calculation and includes a memory area creation means that creates a memory area for a target table containing the target year and month, employee identification information, and item values ​​for each month, and registers it in the memory area. Equipped with, The aforementioned area creation means is characterized in that, if the target year and month and table name of the target table match the revision year and month and table name of the fixed item pre-revision table registered in the storage area, it updates the value of the item for the target year and month of the target table to the new value of the matching fixed item pre-revision table.

2. The business support device according to claim 1, characterized in that the target table includes a social insurance table.

3. The control unit, A master list of selection candidate classifications with registered table names, A master list of items registered by associating table names and item names, The business support device according to claim 1, characterized in that it is configured to allow access to [something].

4. The business support device according to claim 3, characterized in that the area creation means creates an area for the target table for all table names stored in the selection candidate classification list master.

5. The business support device according to claim 3 or 4, wherein the revised table creation means has a display screen having an area 1 where a list of table names of the selected candidate classification list master is displayed, an area 1 where the item names of the item list master associated with the table name selected in "Selected Candidate Classification" are displayed, and an area 2 where the selected item selected in "Selected Item Name" is displayed, and the business support device according to claim 3 or 4, wherein the business support device creates the fixed item pre-approved revised table based on the new value of the selected item entered by the operator for the table name and selected item selected by the operator.

6. A business support method performed by an information processing device equipped with a control unit, The control unit is executed as follows: The revision table creation process involves creating a fixed-item pre-registered revision table containing the revision date, employee identification information, table name, items, and new values ​​for those items, and registering it in the storage area. This is used for payroll calculation, and involves a process of creating a target table area for each month that includes the target year and month, employee identification information, and item values, and registering it in the aforementioned storage area. Includes, In the area creation step, if the target year and month and table name of the target table match the revision year and month and table name of the fixed item pre-revision table registered in the storage area, the business support method is characterized in that, for the target year and month of the target table, the value of the item is updated to the new value of the matching fixed item pre-revision table.

7. A business support program to be executed by an information processing device equipped with a control unit, The control unit, The revision table creation process involves creating a fixed-item pre-registered revision table containing the revision date, employee identification information, table name, items, and new values ​​for those items, and registering it in the storage area. This is used for payroll calculation, and involves a process of creating a target table area for each month that includes the target year and month, employee identification information, and item values, and registering it in the aforementioned storage area. This is a business support program for executing tasks. In the area creation process, if the target year and month and table name of the target table match the revision year and month and table name of the fixed item pre-revision table registered in the storage area, the business support program updates the value of the item for the target year and month of the target table to the new value of the matching fixed item pre-revision table.

Images