JP2000207465A - Salary calculating method and salary calculating device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve input work efficiency in a salary calculating device. SOLUTION: This device is provided with a fetching program 7 which fetches individual presence/absence data necessary to salary calculation as external data of a CSV(comma separated value format) format file 3 from another system 1. Thus, it is possible to easily and collectively input individual presence/ absence data that are optionally produced on the system 1, etc. and to drastically reduce an input manhour. Also, since an optional fetching order, etc. can preliminarily be set as a control file 6, it can flexibly correspond to other individual record systems, etc. and interlocking can be easily performed. Then, it is possible to improve input work efficiency and to simultaneously improve flexibility and extendability.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a payroll calculating method and a payroll calculating apparatus which are provided with a function of taking in data necessary for payroll calculation from another system as external data, thereby improving the input work efficiency.

[0002]

2. Description of the Related Art In a conventional salary calculation computer system (hereinafter referred to as a "salary calculation device"), an operator manually inputs data by a keyboard while checking attendance variation data of each employee on a screen every month. In addition, even when a data file such as a personnel master is converted into a salary calculation device and input to the salary calculation device, it is necessary for the operator to manually input the data again based on the form once printed out.

[0003]

However, if the attendance change data of many employees is manually input to the salary calculator with the increase in the number of employees, it is necessary to input data for the number of employees every month. There is a problem that a large number of input processing steps and time are required. An object of the present invention is to provide a salary calculation method and a salary calculation apparatus which improve the input work efficiency by providing a function for taking in data necessary for salary calculation from another system as external data.

[0004]

In order to achieve the above-mentioned object, the present invention provides a method for determining the order of items to be taken in by external data which is supplied from an external data file in a common text file format and is used as a basis for payroll calculation. The external data is fetched and the data in the master file is updated based on the fetch procedure setting processing step for defining the fetch sequence shown as a control file in advance and the control file previously defined by the fetch procedure setting processing step. External data acquisition processing step.

[0005]

Embodiments of the present invention will be described below with reference to the drawings. In FIG. 1, reference numeral 1 denotes another system such as another attendance system, and attendance change data necessary for salary calculation read from its data file 2 is collectively input to a salary calculation system 4 as a CSV format file 3. . The payroll calculation system 4 is composed of one computer system connected to another system 1 via a network or the like. The payroll calculation programs and the like processed by the computer system include an import information maintenance program 5, a control file 6, and the like. , A fetching program 7, a master file 8, and the like.

Then, the data file 2 of another system 1
When the attendance change data of the CSV format file 3 created based on the data is collectively input to the payroll system 4, the attendance change data of the CSV format file 3 is imported by the import program 7 and stored in the master file 8. You.

Here, the CSV format is the Comma Seperat
ed Value format is an abbreviation of ed Value format, in which data of various databases and spreadsheet software are arranged by separating each item and cell with a comma, and can be handled as a common text file, similar to a normal text file To the HDD (hard disk drive)
It can be exchanged via a network or the like, and can be exchanged between various databases and spreadsheet software.

When the attendance change data of the CSV format file 3 is imported by the import program 7, the data file 2 defined outside the system according to the definition of the control file 6 created in advance by the import information maintenance program 5. Only the necessary data from As a result, it is possible to input data of items set in the control file 6 in advance.

[0009] Data can be fetched in one of four methods: "data addition only", "data update only", "delete and add existing data", and "add if data is not updated if it exists". Any of the above methods can be selected and imported. In the import information maintenance program 5, as shown in FIG.
a, taking-in order determination processing 5b, and taking-in method determining processing 5
c are sequentially executed, and the control file 6 is generated based on the series of processes.

[0010] In the import program 7, a process 7a for determining an import process name and a process 7b for acquiring a CSV format file are performed.
And the data update process 7c are sequentially executed, and the master file 8 is updated based on the series of processes.

Next, the operation of the salary calculation system 4 will be described in detail with reference to FIG. First, step S1
After performing the import execution in step S2, the designation of the import process name is processed in step S2, and in the next step S3, it is determined whether or not the import process name exists in the control file 6, and it is determined that it does not exist. (When a negative determination is made in step S3), the capture information maintenance program 5
Is started (step S4), a series of processes of defining a capture process name (step S5), determining a capture sequence (step S6), and determining a capture method (step S7) are executed. After generating a new control file 6 in S8, the process proceeds to step S10, and the CSV format file 3
Execute the specified process.

On the other hand, if it is determined in step S3 that the import processing name exists in the control file 6 (if the determination is affirmative in step S3), the process proceeds to the next step S9, where the definition content of the control file 6 (the After confirming the loading order and the loading method, the process proceeds to step S10, and the process of specifying the CSV format file 3 is executed.

Next, in step S11, it is determined whether or not the attribute and the number of digits of the item of the CSV format file 3 to be fetched are within a predetermined range so that there is no problem in processing.
When it is determined that there is no problem (when an affirmative determination is made in step S11), the process proceeds to step S13, where the process of updating the master file 8 is executed, and then a series of processes is ended. On the other hand, if it is determined in step S11 that there is a problem with the attribute and the number of digits of the item in the CSV format file 3 (in the case of a negative determination in step S11), a warning message output display process is performed in step S12. , A series of processing ends.

Next, the operation of this embodiment will be described using a specific example. As shown in FIG. 4, for example, in another system 1,
Attendance change data such as employee number and number of working days is input, and the data is converted into a CSV format, and the CSV format file 3
Output as In this case, the employee number, the number of working days, and overtime hours are output in this order.

Next, the capture information maintenance program 5
In, the control file 6 is set. here,
1. 1. employee number; 2. the number of working days; Items are set in the order of overtime hours, and the fetching method is set to “data addition only” and registered in the control file 6 under the name of “time data processing”.

The fetch program 7 is started, and the process name "time data processing" created by the fetch information maintenance program 5 is specified to execute the fetch. As a result, the setting is reflected in the setting item of the master file 8 of the payroll calculation system 4. Here, no data is input to the item of the name because there is no setting for capturing. The name item is not used at the time of payroll calculation, but is performed by employee number.

As described above, according to the above-described embodiment, the attendance change data and the like have conventionally been required to be input by the number of persons. Since the capture program 7 for capturing as external data of the file 3 is provided, it is possible to easily and collectively input the attendance variation data and the like arbitrarily created on the separate system 1, thereby greatly reducing the number of input steps. . In addition, since the control file 6 can be set in advance in any order and method, the system can flexibly cope with other attendance systems and the like, and can be easily linked. . As a result, input work efficiency can be improved, and at the same time, versatility and expandability can be improved. In addition to the attendance data,
Since data such as personnel masters can be imported, smooth data migration is possible.

In the above-described embodiment, the CSV format is used as an example of the common text file format. However, other general-purpose formats may be used, and the present invention is limited to the above-described embodiments. However, it is needless to say that changes may be made as appropriate within the scope of the technical idea of the present invention.

[0019]

As described above, according to the present invention, the function for taking in the data necessary for payroll calculation from another system as external data in the form of a common text file is provided, thereby improving the input work efficiency. It is possible,
At the same time, there is an effect that versatility and expandability can be improved.

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating a system configuration according to an embodiment of the present invention.

FIG. 2 is a block diagram showing a program configuration of a salary calculation system according to the embodiment of the present invention.

FIG. 3 is a flowchart showing an operation of the salary calculation system according to the embodiment of the present invention.

FIG. 4 is a conceptual diagram showing a specific example of a calculation procedure of the salary calculation system according to the embodiment of the present invention.

[Explanation of symbols]

 1 Separate system 2 Data file 3 CSV format file 4 Payroll system 5 Import information maintenance program 6 Control file 7 Import program 8 Master file

Claims (4)

[Claims] 1. An import procedure setting process for defining, as a control file, an import order indicating the order of items to be imported of external data serving as a source of payroll supplied from an external data file in a common text file format. Based on a control file defined in advance by the capture procedure setting processing step, captures the external data,
A salary calculation method comprising: an external data import processing step of updating data of a master file. 2. An acquisition procedure setting means for predefining, as a control file, an acquisition order indicating the order of items to be acquired of external data serving as a basis for payroll supplied from an external data file in a common text file format. A payroll calculating apparatus comprising: an external data importing unit that imports the external data based on a control file defined in advance by the importing procedure setting unit and updates data of a master file. 3. The control method according to claim 2, wherein the fetching procedure setting means defines in advance, as a control file, a fetching method indicating whether data should be added or updated based on the external data. Payroll calculator according to 4. 4. The common text file format is:
3. The payroll calculator according to claim 2, wherein the data is in a CSV format in which data of each item is arranged by being separated by commas.