JP2011065372A - Payroll calculation expression preparation system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To automatically prepare a calculation expression for calculating a payroll of an employee required when introducing a personnel system in an enterprise or the like, based on a rule of employment including a pay regulation. <P>SOLUTION: An outline preparing part 110 obtains each item used in the calculation of the payroll out of an employment rule text data 21, based on an item name determination master 22, to be allocated to an outline calculation expression, and outputs it to an external storage device 1 as an outline calculation data 24. A detail preparing part 120 detects a description part about each item of the outline calculation data 24, from the employment rule text data 21, extracts a calculation condition and a calculation method therefor, based on a condition part master 23, builds a calculation expression combined therewith into the outline calculation data 24, and a payroll calculation expression data 25 is thereby prepared to be output to the external storage device 1. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a salary calculation formula creation system that automatically creates a calculation formula for calculating an employee's salary, which is necessary when introducing a personnel system in a company or the like, from a work rule including a salary rule.

  In recent years, business has been digitized in many companies. For example, Patent Document 1 discloses that “salary management can be quickly processed and flexibly handled simply by creating and registering a table for each item and a simple calculation formula” (paragraph [0006]). In addition, Patent Document 2 discloses that “inputs necessary for payroll calculation can be guided to the user in an easy-to-understand manner. It can be easily used without setting up "(paragraph [0005]) to disclose a payroll system.

  The salary management device of Patent Document 1 and the salary calculation system of Patent Document 2 have recently been referred to as personnel systems, etc., and in a company of a certain scale, by introducing this personnel system, It is no longer common to improve efficiency.

JP-A-8-129595 Japanese Patent Laid-Open No. 11-272753

  By the way, when introducing a personnel system in a company, first, the formula for calculating the salary to be paid to each employee who has various job types, working conditions, etc. Perform the logical assembly work according to the regulations, and then create the formula definition data to be input to the personnel system, such as a spreadsheet for spreadsheets, based on the calculated formula. Yes. That is, every time a personnel system is introduced, the calculation formula is created manually from scratch.

  However, according to the salary rules stipulated in the employment rules, the task of logically constructing the calculation formula (to calculate the salary to be paid to each employee with various job types and working conditions) from scratch However, it is not possible to eliminate the possibility that a large number of man-hours will be required, resulting in an increase in cost and the omission of items necessary for the calculation of salary.

  The present invention has been made in consideration of such circumstances, and a calculation formula for calculating a salary of an employee, which is necessary when introducing a personnel system in a company, etc., includes a salary regulation. It is an object of the present invention to provide a payroll formula creation system that realizes automatic creation from rules.

  In order to achieve the above-described object, the payroll formula creation system according to the present invention obtains, from the work rule data, work rule data obtained by digitizing a work rule including a pay rule and items used for calculation of the salary. Search data stored in the item master data, and an item master data defining an allocation rule for assigning an item acquired from the work rule data to the salary calculation formula. Based on the key data, the item used for calculation of the salary is acquired from the work rule data, and the item acquired from the work rule data is converted into the formula for calculating the salary based on the allocation rule defined in the item master data. By assigning, a first pay scale that creates a large calculation formula for calculating the salary and outputs it as first calculation formula data Formula calculation means, the employment rule data, the first calculation formula data, and the calculation conditions of the items assigned to the large calculation formula output as the first calculation formula data from the employment rule data Condition master data for storing search key data to be extracted, and based on the search key data stored in the condition master data, the calculation conditions for the items assigned to the general calculation formula are set as the work rule data. And extracting the calculation method of the item according to the calculation condition from the work rule data based on the detection location of the calculation condition, and combining the extracted calculation condition and the calculation method A detailed calculation formula for calculating the salary is created and incorporated as a second calculation formula data by incorporating it into the calculation formula of the outline as a calculation formula. Characterized by comprising a given calculation formula creation means.

  According to the present invention, it is realized that a calculation formula for calculating a salary of an employee, which is necessary when introducing a personnel system in a company or the like, is automatically created from a work rule including a salary rule. .

The functional block diagram of the salary calculation formula creation system which concerns on embodiment of this invention. The figure which shows schematic structure of the computer with which the salary calculation formula creation system of the embodiment operates. The functional block diagram of the large frame preparation part of the salary calculation formula preparation system of the embodiment. The functional block diagram of the detailed preparation part of the payroll formula preparation system of the embodiment. The figure which shows an example of the item name determination master used with the salary calculation formula creation system of the embodiment. The 1st figure which shows an example of the employment rule text data used with the salary calculation formula creation system of the embodiment. The figure which shows an example of the large frame calculation formula data created by the large frame creation part of the salary calculation formula creation system of the embodiment. The figure which shows an example of the condition part master used with the salary calculation formula creation system of the embodiment. The 2nd figure which shows an example of the employment rule text data used with the salary calculation formula creation system of the embodiment. The figure for demonstrating the extraction pattern of the calculation formula part which the detailed preparation part of the salary calculation formula preparation system of the embodiment applies. The figure which shows an example of the calculation formula of each item produced by the detailed preparation part of the salary calculation formula creation system of the embodiment. The figure which shows an example of the payroll formula data created by the detailed preparation part of the payroll formula creation system of the embodiment. The flowchart which shows the preparation procedure of the large calculation formula data by the salary calculation formula preparation system of the embodiment. The flowchart which shows the preparation procedure of the payroll formula data by the payroll formula preparation system of the embodiment.

  Hereinafter, an embodiment of the present invention will be described with reference to the drawings.

  FIG. 1 is a functional block diagram of a salary calculation formula creation system according to an embodiment of the present invention. As shown in FIG. 1, the salary calculation formula creation system 100 includes a large frame creation unit 110, a detail creation unit 120, a natural language processing engine 130, and an editor 140. The natural language processing engine 130 is a module that executes natural language processing, and the editor 140 is a module that executes data editing processing, and these are not necessarily included in the payroll formula creation system 100. In addition, it is possible to use what exists separately from the salary calculation formula creation system 100. Further, any known module can be applied to the natural language processing engine 130 and the editor 140.

  The personnel system 200 shown in FIG. 1 has a function of calculating the salary of an employee using a personnel data master 31 and a calculation formula definition sheet 32. The calculation formula definition sheet 32 is, for example, a spreadsheet software. It has a configuration like a worksheet. The salary calculation formula creation system 100 according to this embodiment uses the salary calculation formula data 25 used for creating the calculation formula definition sheet 32 as work rule text data obtained by digitizing the work rules of a company that introduces the personnel system 200. 21. This point can be automatically created, and this point will be described in detail below.

  First, an outline of a process in which the payroll formula creation system 100 creates the payroll formula data 25 from the work rule text data 21 will be described.

  The large frame creation unit 110 inputs the work rule text data 21 and the item name determination master 22 from the external storage device 1, assembles a large frame calculation formula for calculating salary, and generates the large frame calculation formula data 24 as an external storage device. Output to 1. The item name determination master 22 stores search key data for acquiring items used for salary calculation from the work rule text data 21, and the large frame creation unit 110 is stored in the item name determination master 22. Each item is acquired by searching the work rule text data 21 based on the search key data. In order to appropriately acquire this item (cut out from the sentence), the large frame creation unit 110 uses the natural language processing engine 130.

  The item name determination master 22 also defines an assignment rule that indicates how to assign an item acquired from the work rule text data 21 to a calculation formula for calculating a salary. The large frame creation unit 110 assembles a large frame calculation formula by allocating the items acquired from the work rule text data 21 to the calculation formula based on the allocation rule defined in the item name determination master 22, and creates the large frame calculation formula data. 24 is output to the external storage device 1.

  When the creation of the large frame calculation formula data 24 by the large frame creation unit 110 is completed, for example, the operator uses the editor 140 to display the large frame calculation formula data 24 stored in the external storage device 1 on the display device 2, and the contents Check. The operator operates the input device 3 as necessary to correct the large frame calculation formula data 24.

  Further, the detail creation unit 120 inputs the large frame calculation formula data 24, the work rule text data 21 and the condition unit master 23 from the external storage device 1, and calculates the large frame calculation formula (shown as the large frame calculation formula data 24). A detailed calculation formula in which the calculation condition and calculation method of each item assigned to is incorporated in the calculation formula of the outline is generated and output to the external storage device 1 as salary calculation formula data 25. The condition part master 23 stores search key data for extracting the calculation condition part of the calculation condition part and the calculation method part constituting the calculation formula of each item from the work rule text data 21. First, the part 120 searches the work rule text data 21 based on the search key data stored in the condition part master 23, and extracts a calculation condition part that is a component of the calculation formula of each item. In order to appropriately extract the calculation condition part (cut out from the sentence), the detail creation unit 120 uses the natural language processing engine 130.

  Subsequently, the detail creation unit 120 extracts the calculation method part corresponding to the calculation condition part from the work rule text data 21 based on the extracted part of the calculation condition part in the work rule text data 21. Also in the extraction of the calculation method part, the detail creating part 120 uses the natural language processing engine 130. Then, the detail creation unit 120 combines the extracted calculation condition unit and the calculation method unit to form a calculation formula for each item, and incorporates the calculated calculation formula for each item into the general calculation formula. And is output to the external storage device 1 as salary calculation formula data 25.

  When the creation of the payroll formula data 25 by the detailed creation section 120 is completed, for example, the operator uses the editor 140 to display the payroll formula data 25 stored in the external storage device 1 on the display device 2, and the contents Check. The operator operates the input device 3 as necessary to correct the salary calculation formula data 25. The salary calculation formula data 25 created as described above is used to create a calculation formula definition sheet 32 to be input to the personnel system 200.

  FIG. 2 is a diagram showing a schematic configuration of an information processing apparatus in which the salary calculation formula creation system 100 of the present embodiment operates. This information processing apparatus is, for example, a desktop personal computer, and as shown in FIG. 2, a CPU (Central Processing Unit) 11, a main memory 12, a display controller 13, a keyboard controller 14, an HDD (Hard Disk Drive) 15, An ODD (Optical Disc Drive) 16 or the like is included.

  The CPU 11 is a processor that controls the operation of the computer, and executes various programs such as an operating system (OS), utilities and applications operating under the OS, which are loaded from the HDD 15 to the main memory 12. The salary calculation formula creation system 100 according to the present embodiment includes, as one of various programs, for example, after a salary calculation formula creation program 100A stored in an optical disc is read via the ODD 16 and installed in the HDD 15, the main memory 12 is executed on the computer by being loaded on the computer 12 and executed by the CPU 11. That is, the salary calculation formula creation program 100A is a program for causing the computer to function as, for example, the large frame creation unit 110 or the detailed creation unit 120 of the salary calculation formula creation system 100.

  The main memory 12 is a storage medium that plays the role of the main memory of the computer, and is configured by, for example, a DRAM (Dynamic Random Access Memory). On the other hand, the HDD 15 and the ODD 16 are storage media that play a role of auxiliary storage of the computer, and correspond to the external storage device 1 shown in FIG.

  Further, the display controller 13 is a control device that plays an output side of the user interface provided by the computer, and controls the display device 2 shown in FIG. On the other hand, the keyboard controller 14 is a control device responsible for the input side of the user interface provided by the computer, and controls the input device 3 shown in FIG.

  Next, with reference to FIG. 3 and FIG. 4, the operation principle of the salary calculation formula creation system 100 of this embodiment will be described. 3 shows a functional block of the large frame creation unit 110, and FIG. 4 shows a functional block of the detail creation unit 120, respectively.

  As shown in FIG. 3, the large frame creation unit 110 is a module that inputs the work rule text data 21 and the item name determination master 22 and outputs the large frame calculation formula data 24, and includes the item acquisition unit 111 and the calculation formula assignment. Part 112 is provided. FIG. 5 shows an example of the item name determination master 22 input by the large frame creation unit 110.

  As shown in FIG. 5, the item name determination master 22 is provided with a “classification n” field, a “calculation n” field, and an “acquired item” field. The item acquisition unit 111 takes in the data (a1 in FIG. 5) in the “acquired item” field, searches the work rule text data 21 using this data as search key data, and acquires items used for calculation of salary. .

  “*” Present in the data in the “acquired item” field is a so-called wild card. For example, as shown in FIG. 6, “employment salary”, “work location addition”, If there are phrases such as “support supply” and “special work supply”, they are detected by “* supply”, “* addition”, “* supply” in the retrieved search key data. In order to appropriately acquire items (phrases) by the search using the wild card, a natural language processing engine 130 that executes a morphological analysis of sentences is used.

  The item acquired by the item acquisition unit 111 is delivered to the calculation formula assignment unit 112. The calculation formula assigning unit 112 assigns the items delivered from the item acquisition unit 111 to the calculation formula while referring to the item name determination master 22, and assembles a large calculation formula.

  As shown in FIG. 5, the item name determination master 22 is provided with a “classification n” field, a “calculation n” field, and an “acquired item” field. In this example, the salary calculation formula is assembled in a format for calculating the value of “deduction” in the “class 0” field, and the item name determination master 22 sets the value of “deduction” in the “class 0” field as From the “Calculation 0” field and the “Category 1” field, it can be calculated by “Supply”-“Deduction”.

  Similarly, it can be seen that the “payment” value in the “Category 1” field can be calculated from the “Calculation 1” field and the “Category 2” field by “Standard wage” + “Non-standard wage” + “Other pay” Further, the value of “wage within the standard” in the “Category 2” field is “item detected with“ * fee ”as search key data” + “item detected with“ * salary ”as search key data” + “ It can be seen that “item detected with“ * gold ”as search key data” can be calculated. Therefore, the calculation formula assignment unit 112 assembles a large calculation formula while allocating the items delivered from the item acquisition unit 111 to the calculation formula based on the item name determination master 22. FIG. 7 shows an example of the large frame calculation formula data 24 output by the large frame creation unit 110.

  For example, the job salary (b1 in FIG. 7) in FIG. 7 is “item detected using“ * salary ”as search key data”. Therefore, the “addition” attribute of the “calculation 2” field indicates “wage within the standard”. Is assigned to the formula for calculating. As described above, the large frame creation unit 110 acquires the items necessary for the salary calculation from the work rule text data 21 based on the item name determination master 22 and executes the process of assigning the acquired items to the calculation formula.

  In the example shown in FIG. 7, the calculation formula of “non-standard wage” is created as “overtime work allowance” + “work location addition” + “support supply” + “special work supply”. Of these, “work location addition” + “sustainable supplement” + “special work supplement” (b2 in FIG. 7) are items detected using “* addition” and “* addition” as search key data. The item name determination master 22 shown in FIG. 5 is assigned to the “non-standard wage” calculation formula, but it is actually assumed that it should be assigned to the “standard wage” calculation formula.

  Similarly, the mutual aid expense (b3 in FIG. 7) is an item detected with “* expense” as the search key data, and therefore, based on the item name determination master 22 shown in FIG. Although it is assigned to the “other deduction” formula, it is assumed that it should actually be assigned to the “welfare” formula.

  In order to cope with such a case, for example, the operator uses the editor 140 to display the large frame calculation formula data 24 created by the large frame creation unit 110 on the display device 2 and check the contents, and if necessary, Then, the input device 3 is operated and corrected.

  On the other hand, as shown in FIG. 4, the detail creation unit 120 inputs the large frame calculation formula data 24 (created by the large frame creation unit 110 as described above), the work rule text data 21, and the condition part master 23. The payroll calculation formula data 25 is a module that has a condition part extraction unit 121, a calculation formula part extraction unit 122, and a calculation formula creation unit 123. FIG. 8 shows an example of the condition part master 23 input by the detail creation part 120.

  The condition part master 23 detects “calculation conditions” for each item acquired from the work rule text data 21 by the item name determination master 22 shown in FIG. "Phrase" is stored. Therefore, first, the condition part extraction unit 121 extracts the calculation condition of each item as a condition part based on the condition part master 23.

  Assuming that “special work supply” in the large frame calculation formula data 24 shown in FIG. 7 is to be processed, the condition part extraction unit 121 first uses the natural language processing engine 130 to execute the “special work supply”. Extract relevant paragraphs, such as chapters that describe "work supplement". Subsequently, the condition part extraction unit 121 searches the extracted related paragraph based on the condition part master 23 and extracts the calculation condition of “special work supply”. For example, as shown in FIG. 9, if there is a chapter “Chapter n Special Work Supply” in the work rule text data 21, this chapter is detected, and a search for calculation conditions is performed using this chapter as a search range.

  In the example of FIG. 9, “when engaged in a work environment with high heat and danger” is extracted as a calculation condition by “when” of the condition part master 23 shown in FIG. The natural language processing engine 130 analyzes that “high heat” and “danger” are in a parallel relationship, and performs extraction including “high heat” beyond the reading point. Also, “to key puncher” is extracted as a calculation condition by “to” of the condition part master 23. Here, the word “typist” does not exist in the corresponding part of the work rule text data 21, but it is assumed that “typist” should be added together with “key puncher”. In the same manner as described above, this is dealt with, for example, by an operator using the editor 140 (c1 in FIG. 9). In addition, each time the condition part extraction unit 121 extracts the calculation conditions for each item, the contents may be displayed on the display device 2 so as to actively prompt the operator or the like to confirm and correct.

  In addition, for a phrase with a ending mark, as in “However” in the condition part master 23 shown in FIG. 8, the condition part extraction unit 121 causes the natural language processing engine 130 It is extracted as a calculation condition together with the main phrase. Here, it is assumed that “however, a telephone exchange” is extracted as a calculation condition.

  The calculation formula part extraction unit 122 receives the extraction result of the condition part extraction unit 121 and extracts a calculation method corresponding to the extracted calculation condition as a calculation formula part. For example, there are three patterns shown in FIG.

First pattern: A sentence following the sentence extracted as the condition part is extracted as a calculation formula part ((A) in FIG. 10).
Second pattern: When an operation symbol (+, −, ×, ÷) exists in the following sentence, the sentence in the paragraph is extracted as a calculation formula part ((B) of FIG. 10).

  3rd pattern: If there is a table in the following sentence, create a table where the column ends with “result”, the rest is “case”, and the first word in the row is the heading of each column. It is extracted as a calculation formula part ((C) of FIG. 10).

  The calculation formula creation unit 123 combines the condition part extracted by the condition part extraction unit 121 and the calculation formula part extracted by the calculation formula part extraction unit 122 to assemble the calculation formula of each item. A detailed calculation formula is created and output as salary calculation formula data 25 by incorporating the calculated calculation formula for each item into the large frame calculation formula data 24. FIG. 11 shows an example of a calculation formula for each item assembled by combining the condition part and the calculation formula part, and FIG. 12 shows a salary calculation formula in which the calculation formula for each assembled item is incorporated into the outline calculation formula data. An example of data 25 is shown.

  As shown in (A) of FIG. 10, if there is a sentence “Fixed flat 5000 yen” as a sentence following “When engaged in a work environment with high heat and danger”, this “Fixed 5000”. “Yen is paid” is extracted, and the natural language processing engine 130 shortens it to “Uniform 5000 Yen”, and is set as (Calculation Formula 1) as shown in FIG.

  Further, it is assumed that the table shown in FIG. 10C exists in the sentence following “for key puncher”. In this case, the last “amount” field data is “result”, the other “qualification salary” field and “employee classification” field data are “case n”, and this “qualification salary” and “employee” A table having the heading of each column “membership category” and “amount” is created and set as (calculation formula 2) as shown in FIG.

  Furthermore, if an operation symbol “×” is present in the sentence following “however”, such as “professional salary × (1/20)” shown in FIG. Is extracted by the natural language processing engine 130 as “working salary × (1/20)” and set as (calculation formula 3) as shown in FIG.

  And the calculation formula preparation part 123 which assembled the calculation formula about "special work supply" as shown in FIG. 11 incorporates this calculation formula in the large frame calculation formula data 24 shown in FIG. Salary calculation formula data 25 as shown in FIG. 12 is created.

  As described above, according to the payroll formula creation system 100 of the present embodiment, (1) items necessary for payroll calculation are acquired from the work rule text data 21, and a general formula that assigns each acquired item is assembled. (2) The calculation condition and calculation method of each item assigned to the large frame calculation formula are extracted from the work rule text data 21 and combined as a calculation formula, and the detailed calculation formula is created by incorporating it into the large frame calculation formula. Thus, the salary calculation formula data 25 is automatically created from the work rule text data 21. Therefore, when the personnel system 200 is introduced, the formula used to create the formula definition sheet 32 to be input to the personnel system 200. It is possible to eliminate the need to manually create each time.

  FIG. 13 is a flowchart showing a procedure for creating the large frame calculation formula data 24 by the salary calculation formula creation system 100.

  The payroll formula creation system 100 reads the work rule text data 21 and the item name determination master 22 from the external storage device 1 (steps A1 and A2) and stores them in the item name determination master 22 from the work rule text data 21. Items detected by the search key data are acquired (step A3).

  Subsequently, the salary calculation formula creation system 100 assigns each item acquired from the work rule text data 21 to the calculation formula based on the item name determination master 22 (step A4). Then, the payroll formula creation system 100 outputs the formula assigned to each item to the external storage device 1 as the large frame formula data 24 (step A5).

  FIG. 14 is a flowchart showing a procedure for creating salary calculation formula data 25 based on salary calculation formula data by the salary calculation formula creation system 100.

  The salary calculation formula creation system 100 reads the large frame calculation formula data 24, the work rule text data 21 and the item name determination master 22 from the external storage device 1 (steps B1 to B3), and from the large frame calculation formula data 24 (item name determination) The detailed setting items (detected by the search key data stored in the master 22) are sequentially acquired (step B4).

  Subsequently, the payroll formula creation system 100 detects the description location of the acquired detailed setting item from the work rule text data 21 (step B5). If the description location of the acquired detailed setting item is detected (YES in step B6), the payroll formula creation system 100 sets the calculation condition of this detailed setting item as the detected description location based on the condition part master 23. (Step B7), and based on this extraction position, this time, the calculation method of the detailed setting item is extracted (step B8). The salary calculation formula creation system 100 creates a calculation formula that combines the extracted calculation conditions and the calculation method, and incorporates the created calculation formula into the large frame calculation formula data 24 (step B9).

  The payroll formula creation system 100 repeatedly executes the processes of steps B4 to B9 while the unprocessed detailed setting items remain in the large frame formula data 24 (NO in step B10). If the processing of steps B4 to B9 has been executed for all the detailed setting items (YES in step B10), the large frame calculation formula data 24 in which the detailed calculation formula of each item is incorporated is externally set as the salary calculation formula data 25. The data is output to the storage device 1 (step B11).

  As described above, the salary calculation formula creation system 100 according to the present embodiment includes a calculation formula for calculating an employee's salary, which is required when introducing a personnel system in a company or the like. To create automatically from.

  In the description of the above-described embodiment, the salary calculation formula data 25 is created for use in creating the calculation formula definition sheet 32 to be input to the personnel system 200. For example, the description of the working rule is ambiguous. Paying attention to the fact that the payroll formula data 25 is not created as intended, the payroll formula creation system 100 of the present embodiment can also be used as a correction tool for examining whether the description of the work rules is appropriate. it can.

  Further, the present invention is not limited to the above-described embodiments as they are, and can be embodied by modifying the constituent elements without departing from the scope of the invention in the implementation stage. In addition, various inventions can be formed by appropriately combining a plurality of components disclosed in the embodiment. For example, some components may be deleted from all the components shown in the embodiment. Furthermore, you may combine a component suitably in different embodiment.

  DESCRIPTION OF SYMBOLS 1 ... External storage device, 2 ... Display apparatus, 3 ... Input device, 11 ... CPU, 12 ... Main memory, 13 ... Display controller, 14 ... Keyboard controller, 15 ... HDD, 16 ... ODD, 21 ... Work rule text data, 22 ... Item name determination master, 23 ... Condition part master, 24 ... Outline calculation formula data, 25 ... Salary calculation formula data, 31 ... Personnel data master, 32 ... Calculation formula definition sheet, 100 ... Salary calculation formula creation system, 100A ... Salary calculation formula creation program, 110 ... large frame creation section, 111 ... item acquisition section, 112 ... calculation formula assignment section, 120 ... detail creation section, 121 ... condition section extraction section, 122 ... calculation formula section extraction section, 123 ... calculation formula Creation unit, 130 ... natural language processing engine, 140 ... editor, 200 ... personnel system.

Claims (5)

Employment rule data that digitizes work rules including salary rules and search key data for obtaining items used for calculation of salary from the work rule data are stored, and items obtained from the work rule data Input item master data defining an assignment rule for assigning to the formula for calculating the salary, and based on the search key data stored in the item master data, items used for calculating the salary from the work rule data Based on the allocation rules defined in the item master data, and by assigning the items acquired from the work rule data to the salary formula, create a general formula for calculating the salary First salary calculation formula creation means for outputting as first calculation formula data;
Retrieval for extracting from the employment rule data the calculation conditions of the items assigned to the calculation formula of the outline which is output as the employment rule data, the first calculation formula data, and the first calculation formula data The condition master data for storing the key data is input, and based on the search key data stored in the condition master data, the calculation conditions for the items assigned to the general formula are extracted from the work rule data, Based on the detected part of the calculation condition, the calculation method of the item according to the calculation condition is extracted from the work rule data, and the calculation condition of the item is combined with the calculation method and the calculation method. The second payroll formula creation method for creating a detailed formula for calculating the salary and outputting it as the second formula data by incorporating it into the formula And,
A salary calculation formula creation system characterized by comprising:   The second salary calculation formula creation means presents a calculation condition extracted from the work rule data for each item assigned to the outline calculation formula and accepts a correction instruction for the presented calculation condition. The salary calculation formula creation system according to claim 1, further comprising:   The second salary calculation formula creation means searches the employment rule data for a chapter including the item assigned to the calculation formula of the outline in the title sentence, and detects the detected chapter in the calculation condition and the extraction range of the calculation method. The salary calculation formula creating system according to claim 1, wherein   4. The second salary calculation formula creation means extracts a sentence between punctuation marks existing before and after a word that matches the search key data stored in the condition master data as the calculation condition. The payroll formula creation system described.   The salary calculation according to claim 3, wherein the second salary calculation formula creating means extracts, as the calculation method, the entire paragraph including the operation symbol when the operation symbol exists in the set extraction range. Formula creation system.

Images