JP2022082295A - Temporary transfer fee calculation device, temporary transfer fee calculation method, and temporary transfer fee calculation program - Google Patents

Abstract

To provide a temporary transfer fee calculation device, a temporary transfer fee calculation method, and a temporary transfer fee calculation program for reducing work burden when a temporary transfer source company calculates the amount of temporary transfer fees for a temporarily transferred employee billed to a temporary transfer destination company.SOLUTION: A temporary transfer fee calculation device 100 comprises: an announcement registration unit 102b that registers, for every object employee, temporary transfer announcement information including a temporary transfer company and personnel announcement including a temporary transfer period in a storage unit; a temporarily transferred person registration unit 102a that registers, for every object employee, temporarily transferred person information including the object year and month, the temporary transfer company, and billed items indicating items of a temporary transfer contract in the storage unit; and a temporary transfer fee calculation unit 102d that acquires, for the object year and month, the temporary transfer period from the temporary transfer announcement information to calculate working days for every employee in the temporarily transferred person information, and for each of the billed items, calculates the amount billed by proportionally dividing the amount of calculated salary by the working days.SELECTED DRAWING: Figure 5

Description

The present invention relates to a secondment fee calculation device, a secondment fee calculation method, and a secondment fee calculation program.

For example, companies often send employees to other companies. Seconding means going from a company that currently has an employment contract to another company. This is decided based on the management strategy of the company, and in most cases, for example, it is made for the purpose of personnel coordination with group companies and training of employees. As a system for managing salaries of seconded employees, for example, there is Patent Document 1.

Japanese Unexamined Patent Publication No. 2007-52632

However, Patent Document 1 does not describe anything about reducing the work burden when the seconded company calculates the amount billed for the seconded employee's seconded fee to the seconded company.

The present invention has been made in view of the above, and is a seconded fee calculation device capable of reducing the work burden when the seconded company calculates the amount of the seconded employee's seconded fee billed to the seconded company. The purpose is to provide a fee calculation method and a secondment fee calculation program.

In order to solve the above-mentioned problems and achieve the object, the present invention is a seconded fee calculation device including a storage unit and a control unit, and the control unit is seconded to a seconded company for each target employee. The personnel announcement including the period, the announcement registration means for registering the secondment announcement information including the secondment in the storage unit, the target date, the seconded company, and the billing item indicating the item of the seconded contract for each target employee. For the seconded person registration means for registering the seconded person information including the seconded person information in the storage unit and the target year and month, the seconded period is acquired from the seconded person information for each employee of the seconded person information, the number of working days is calculated, and the request is made. It is characterized by being equipped with a seconded fee calculation means for calculating the billing amount obtained by dividing the salary calculation amount by the number of working days for each item.

Further, according to one aspect of the present invention, the claimed item may include at least one of a basic salary, an overtime allowance, and a seconded allowance.

Further, according to one aspect of the present invention, the billed amount may be calculated by the billed amount = salary calculation amount × (number of working days in the target year / month ÷ number of calendar days in the target year / month).

Further, according to one aspect of the present invention, the personnel announcement may include the announcement date of the start of the secondment and the announcement date of the cancellation of the secondment.

Further, according to one aspect of the present invention, the control unit may further include an output processing means for outputting a bill list or an invoice for each seconded company.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a secondment fee calculation method for causing an information processing apparatus provided with a storage unit and a control unit to execute, and is executed by the control unit. For each target employee, the seconded company, the personnel issuance including the seconded period, the issuance registration process for registering the seconded order information including the seconded order information in the storage unit, and for each target employee, the target date and the seconded company. The seconded person registration process for registering the seconded person information including the request item indicating the item of the seconded contract and the seconded person information in the storage unit, and the seconded person information for each employee of the seconded person information for the target year and month. It is characterized by including a secondment fee calculation process in which a period is acquired, the number of working days is calculated, and the billing amount is calculated by dividing the salary calculation amount by the number of working days for each billing item.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a secondment fee calculation program for causing an information processing apparatus provided with a storage unit and a control unit to execute, and is an object in the control unit. For each employee, the seconded company, the personnel issuance including the seconded period, the issuance registration process for registering the seconded order information including the seconded order information in the storage unit, and for each target employee, the target date, the seconded company, and the seconded company. Regarding the seconded person registration process of registering the seconded person information including the billing item indicating the contract item and the seconded person information in the storage unit, and the target date, the seconded period is acquired from the seconded person announcement information for each employee of the seconded person information. It is a secondment fee calculation program for calculating the number of working days and calculating the billing amount by dividing the salary calculation amount by the number of working days for each billing item. ..

According to the present invention, it is possible to reduce the work burden when the seconded company calculates the amount of the seconded employee's seconded fee to the seconded company.

FIG. 1 is a diagram for explaining in detail the problems in creating a conventional invoice for a secondment fee. FIG. 2 is a diagram for explaining in detail the problems in creating a conventional invoice for a secondment fee. FIG. 3 is a diagram for explaining in detail the problems in creating the conventional invoice for the secondment fee. FIG. 4 is a diagram for explaining in detail the problems in creating the conventional invoice for the secondment fee. FIG. 5 is a block diagram showing an example of the configuration of the secondment fee calculation device according to the present embodiment. FIG. 6 is a diagram showing a configuration example of a personnel table and a salary table. FIG. 7 is a diagram for explaining an outline of the entire processing of the control unit of the secondment fee calculation device according to the present embodiment. FIG. 8 is a diagram for explaining a specific example of processing of the control unit of the secondment fee calculation device according to the present embodiment. FIG. 9 is a diagram for explaining a specific example of processing of the control unit of the secondment fee calculation device according to the present embodiment. FIG. 10 is a diagram for explaining a specific example of processing of the control unit of the secondment fee calculation device according to the present embodiment. FIG. 11 is a diagram for explaining a specific example of processing of the control unit of the secondment fee calculation device according to the present embodiment. FIG. 12 is a diagram for explaining a specific example of processing of the control unit of the secondment fee calculation device according to the present embodiment. FIG. 13 is a diagram for explaining a specific example of processing of the control unit of the secondment fee calculation device according to the present embodiment. FIG. 14 is a diagram for explaining a specific example of processing of the control unit of the secondment fee calculation device according to the present embodiment. FIG. 15 is a diagram for explaining a specific example of processing of the control unit of the secondment fee calculation device according to the present embodiment. FIG. 16 is a diagram for explaining a specific example of processing of the control unit of the secondment fee calculation device according to the present embodiment. FIG. 17 is a diagram for explaining a specific example of processing of the control unit of the secondment fee calculation device according to the present embodiment.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Overview]
For example, companies often send employees to other companies. For the payment of salaries and bonuses to seconded employees, a secondment contract is concluded between the seconded company and the seconded company according to the seconded pattern. In general, the seconded company pays the seconded employee a salary, and the seconded company pays the amount (burden) of the seconded fee from the seconded company.

When the seconded company prepares an invoice for the seconded employee's seconded fee to the seconded company, there is a problem that the calculation of the invoice amount becomes complicated.

Specifically, it is rare to start a secondment at the beginning of the month or cancel the secondment at the end of the month, and it is common to start / cancel the secondment in the middle of the month. In this case, the billing amount for the month when the secondment starts and the month when the secondment is canceled must be proportionally divided according to the number of days of secondment in that month, not the full amount. After the secondment is decided, the person in charge of business approves the personnel announcement and notifies the seconded employee of the resignation of the secondment. Then, it is necessary to prepare an invoice in order to charge the seconded company for the salary payment after the secondment. The calculation of the billing amount is complicated because the billing start date and the cancellation date differ depending on the seconded employee, and the billing items and the burden amount of the seconded company also differ depending on the contents of the contract with the seconded company. Therefore, the work load of manually calculating the monthly salary increases in proportion to the number of seconded employees.

Therefore, in this embodiment, in order to reduce the work load when calculating the billed amount of the seconded fee, (1) the personnel issuance is approved even if the seconded period is not set when calculating the billed amount. We have built a mechanism to apportion the monthly billing amount according to the number of days seconded, and (2) a mechanism to manage billing items and calculation methods for each contracted employee, and automatically calculate the seconded fee from the personnel announcement. It was realized.

As a result, it is possible to flexibly respond according to the contents of the contract with the seconded company, and it is possible to reduce calculation errors and work load because there is no manual work by humans.

1 to 4 are diagrams for explaining in detail the problems in creating a conventional invoice for a secondment fee. In FIG. 1, the seconded company calculates the invoice amount to the seconded company and prepares an invoice. For example, in the seconded company, it is necessary to prepare an invoice for each of the seconded companies A, B, and C. In this case, there is a desire to easily create an invoice.

In FIG. 2, (1) the overlapping maintenance of the seconded period increases the risk of input errors and the work load. Specifically, it is troublesome to input the seconded period for each seconded employee many times in each business. For example, in the personnel announcement and approval business, when the seconded employee is decided, it is necessary to input the secondment order, and in the salary secondment business, it is necessary to input the secondment period while looking at the secondment order.

In FIG. 3, (2) the risk of calculation errors and the work load increase due to the complexity of the calculation formula. This factor 1 is because the seconded period differs depending on the seconded employee. For example, employee A is seconded to company A from August 3rd to October 2nd, employee B is seconded to company B from July 27th to August 14th, and employee C is seconded to company B from July 16th to September 15th. Suppose you are seconded to company C. In this case, the billing amount for August is 29th / 31st x billing amount for employee A, 14th / 31st x billing amount for employee B, and 31st / 31st x for employee C. It will be a billed amount and the work burden will be large.

Further, in FIG. 4, this factor 2 is because the billing item differs depending on the contract information with the seconded company. For employee A seconded to company A, the basic salary, overtime allowance, and seconded allowance A are set in the seconded contract, and for employee B seconded to company B, the basic salary, overtime allowance, and seconded allowance B are set in the seconded contract. For employee C who is seconded to company C, if there is no basic salary, overtime allowance, or seconded allowance in the seconded contract, it is necessary to calculate the billing amount for each employee A to C using different billing items and calculation methods. The work burden is heavy.

[2. Constitution]
An example of the configuration of the secondment fee calculation device according to the present embodiment will be described with reference to FIG. FIG. 5 is a block diagram showing an example of the configuration of the secondment fee calculation device 100 according to the present embodiment. The seconded fee calculation device 100 shown in FIG. 5 can be suitably used, for example, by a seconded company or the like.

The secondment fee calculation device 100 may be, for example, a workstation or a personal computer. The secondment fee calculation device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 109. Each part of the secondment fee calculation device 100 is connected so as to be communicable via an arbitrary communication path.

The communication interface unit 104 connects the secondment fee calculation device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the secondment fee calculation device 100 and the server 200 so as to be communicable with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like.

An input device 112 and an output device 114 are connected to the input / output interface unit 109. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). As the input device 112, a keyboard, a mouse, and a microphone, as well as a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be described as a monitor 114. Further, the “output” includes displaying on the monitor of the output device 114 and printing on the printer of the output device 114. Further, the user operating the information displayed on the monitor 114 with the input device 112 or the like may be described as "user operation via UI".

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

The storage unit 106 includes a personnel table 107 and a salary table 108. The personnel table 107 includes a secondment announcement information file 107a, an employee master 107b, and a partner company master 107c. The salary table 108 includes a seconded basic master 108a, a seconded detailed master 108b, a seconded detailed information file 108c, a seconded item information file 108d, and an employee salary payment information file 108e. FIG. 6 is a diagram showing a configuration example of the personnel table 107 and the salary table 108.

The secondment order information file 107a is a file for storing the secondment order information. The secondment announcement information is information created when the secondment is announced, and may include data of the company number, the secondment announcement date, the announcement code, the employee CD, and the seconded company name as shown in FIG. ..

As shown in FIG. 6, the employee master 107b can be configured by a table or the like for registering a company number and an employee CD in association with each other.

The affiliated company master 107c is a master for associating the seconded company master 107a with the seconded destination basic master 108a, and can be configured by a table or the like for registering the company number and the affiliated company name in association with each other, as shown in FIG. ..

The seconded company basic master 108a is a master for holding the basic data of the seconded company, and as shown in FIG. 6, a table registered in association with the company NO, the seconded company NO, the seconded company name, the affiliated company CD, etc. Can be configured with.

The seconded details master 108b is a master for holding billing items for each seconded pattern, and as shown in FIG. 6, the company NO, the seconded company NO, and the seconded pattern CD (for example, 1: "normal seconded 2:" It can be composed of a table or the like registered in association with "seconded at the end of the month" and billing items (for example, basic salary, overtime allowance, seconded allowance, etc.).

The seconded person detailed information file 108c is a file for storing the seconded person detailed information. The seconded person detailed information is information for holding the seconded person's data, and as shown in FIG. 6, the company NO, the target date, the seconded company NO, the seconded pattern CD, the seconded start date, and the seconded cancellation year. It may include date data. The date of start of secondment and the date of cancellation of secondment are obtained from the information on the announcement of secondment.

The seconded person item information file 108d is a file for storing the seconded person item information. The seconded person item information is a master for holding billing items for each seconded person and each seconded pattern, and as shown in FIG. 6, the company NO, the target date, the seconded company NO, the seconded pattern CD, the employee CD, It may include data of item serial number, billing item, payroll amount, daily rate coefficient element, daily rate coefficient denominator, and billing amount. The payroll amount is obtained from the employee payroll information.

The employee salary payment information file 108e is a file for storing employee salary payment information. Employee salary payment information is information for holding monthly salary payment amount, and as shown in FIG. 6, includes data of company number, target year and month, employee CD, basic salary, overtime allowance, and home allowance. You may.

Returning to FIG. 5, the control unit 102 is a CPU or the like that collectively controls the secondment fee calculation device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. The control unit 102 has a functional concept of a seconded destination registration unit 102a, an issuance registration unit 102b, a seconded person registration unit 102c, a seconded charge calculation unit 102d, an output processing unit 102e, a screen display control unit 102f, and the like. It is equipped with.

The seconded destination registration unit 102a registers data in the seconded destination basic master 108a and the seconded destination detailed master 108b in response to an operator's operation on the seconded destination registration screen displayed on the monitor 114, for example.

The issuance registration unit 102b, for example, refers to the employee master 107b and the affiliated company master 107c in response to an operator's operation on the issuance registration screen displayed on the monitor 114, and is assigned to the seconded company for each target employee. , The personnel announcement including the secondment period, and the secondment announcement information including the secondment announcement information are input and registered in the secondment announcement information file 107a. The personnel announcement may include the announcement date of the secondment and the announcement date of the cancellation of the secondment.

The seconded person registration unit 102c indicates, for example, the target date, the seconded company, and the items of the seconded contract for each target employee according to the operation of the operator on the issuance registration screen displayed on the monitor 114. Register the billing items (details of salary items are specified in the secondment contract) and the seconded person information (seconded person detailed information, seconded person item information) in the seconded person detailed information file 108c and seconded person item information file 108d. .. The billing item may include at least one of basic salary, overtime allowance, and seconded allowance.

The secondment fee calculation unit 102d, for example, responds to an operator's operation on the secondment fee calculation screen displayed on the monitor 114, for the target date, for the employee subject to the secondment information, and for the secondment period from the secondment order information. Is obtained, the number of working days is calculated, the billing amount obtained by dividing the salary calculation amount by the number of working days is calculated for each billing item, and the seconded person information (seconded person detailed information, seconded person item information) is updated. The billed amount may be calculated by multiplying the billed amount by the payroll amount x (the number of working days in the target year / month / the number of calendar days in the target year / month).

The output processing unit 102e, for example, responds to an operator's operation on the output processing screen displayed on the monitor 114, and the seconded person detailed information and the seconded person item information file 108d registered in the seconded person detailed information file 108c. Based on the seconded person item information registered in, a billing list or invoice is created and output for each seconded company.

The screen display control unit 102f controls the display of various screens (for example, the seconded destination registration screen, the issuance registration screen, the seconded person registration screen, the seconded charge calculation screen, etc.) displayed on the monitor 114 and the acceptance of their input.

[3. Concrete example]
A specific example of the processing of the control unit 102 of the secondment fee calculation device 100 in the present embodiment will be described with reference to FIGS. 5 to 17. FIG. 7 is a diagram for explaining an outline of the entire processing of the control unit 102 of the secondment fee calculation device 100 in the present embodiment.

(3-1. Overall processing)
With reference to FIG. 7, the outline of the entire processing of the control unit 102 of the secondment fee calculation device 100 in the present embodiment will be described. In FIG. 7, the seconded destination registration unit 102a executes the seconded destination registration process (step S1). Specifically, in the seconded destination registration process, the seconded destination registration unit 102a receives, for example, an operator's operation on the seconded destination registration screen displayed on the monitor 114, and the seconded destination basic master 108a and the seconded destination details. Register the data in the master 108b.

The issuance registration unit 102b executes the issuance registration process (step S2). Specifically, in the issuance registration process, the issuance registration unit 102b refers to the employee master 107b and the affiliated company master 107c in response to the operator's operation on the issuance registration screen displayed on the monitor 114, for example. For each target employee, the seconded company, the personnel announcement including the seconded period, and the seconded announcement information including the seconded announcement information are input and registered in the seconded announcement information file 107a. The personnel announcement may include the announcement date of the secondment and the announcement date of the cancellation of the secondment.

The seconded person registration unit 102c executes the seconded person registration process (step S3). Specifically, in the seconded person registration process, the seconded person registration unit 102c sets the target year and month for each target employee in response to the operator's operation on the announcement registration screen displayed on the monitor 114, for example. , The seconded company and the billing item indicating the item of the seconded contract, and the seconded person information (seconded person detailed information, seconded person item information) are registered in the seconded person detailed information file 108c and the seconded person item information file 108d. The billing item may include at least one of basic salary, overtime allowance, and seconded allowance.

The secondment fee calculation unit 102d executes the secondment fee calculation process (step S4). Specifically, in the seconded charge calculation process, the seconded charge calculation unit 102d receives, for example, the operation of the operator on the seconded charge calculation screen displayed on the monitor 114, and the seconded person information is obtained for the target date. For the target employees, the number of working days was calculated by acquiring the secondment period from the secondment announcement information, and the salary calculation amount acquired from the employee salary payment information in the employee salary payment information file 108e was proportionally divided by the number of working days for each billing item. Calculate the billing amount and update the seconded person information (seconded person detailed information, seconded person item information). The billed amount may be calculated by multiplying the billed amount by the payroll amount x (the number of working days in the target year / month / the number of calendar days in the target year / month).

The output processing unit 102e executes output processing by the output processing unit 102e (step S5). Specifically, in the output processing, the output processing unit 102e is a seconded person registered in the seconded person detailed information file 108c, for example, in response to an operator's operation on the output processing screen displayed on the monitor 114. Based on the detailed information and the seconded person item information registered in the seconded person item information file 108d, a billing list or an invoice is created and output for each seconded company.

8 to 17 are diagrams for explaining a specific example of the processing of the control unit 102 of the secondment fee calculation device 100 in the present embodiment. A specific example of the processing of the control unit 102 of the secondment fee calculation device 100 in the present embodiment will be described with reference to FIGS. 8 to 17.

(3-2. Sample data)
A specific example of the processing of the control unit 102 of the secondment fee calculation device 100 in the present embodiment will be described with reference to FIGS. 8 to 14 using sample data.

(Seconded destination registration process)
The seconded destination registration unit 102a registers data in the seconded destination basic master 108a and the seconded destination detailed master 108b in response to an operator's operation on the registration screen displayed on the monitor 114, for example. FIG. 8A is a diagram showing a registration example of the seconded basic master 108a. FIG. 8B is a diagram showing an example of registration of the seconded destination detailed master 108b.

In the example of the seconded basic master 108a shown in FIG. 8A, the first line is the seconded company NO “100”, the seconded company name “sample 01 company”, the affiliated company code “777”, and the second line is the seconded company. Company number "200", seconded company name "sample 02 company", affiliated company code "888", third line is seconded company NO "300", seconded company name "sample 03 company", affiliated company code "999" It has become.

In the example of the seconded destination detailed master 108b shown in FIG. 8B, the first line is the seconded company NO “100”, the seconded pattern code “1: normal seconded”, the item serial number “1”, the billing item “basic salary”, and the second line. The second line is the seconded company NO "100", the seconded pattern code "1: normal seconded", the item serial number "2", the billing item "overtime allowance", and the third line is the seconded company NO "200". The pattern code is "1: normal secondment", the item serial number is "1", and the billing item is "basic salary".

(Announcement registration process)
For example, the issuance registration unit 102b refers to the employee master 107b and the affiliated company master 107c in response to an operator's operation on the registration screen displayed on the monitor 114, and transfers the secondment order information to the secondment order information file 107a. sign up. 9 (A) is a diagram showing an example of registration of the employee master 107b, FIG. 9 (B) is a diagram showing an example of registration of the affiliated company master 107c, and FIG. 9 (C) is a diagram showing an example of registration of secondment order information.

In the example of the employee master 107b shown in FIG. 9A, the first line is the employee code "1000000001", the employee name "Sample Taro", and the second line is the employee code "1000000002", the employee name "Sample Jiro". The third line is the employee code "1000000003" and the employee name "Sample Saburo".

In the example of the affiliated company master 107c shown in FIG. 9B, the first line is the affiliated company code "777", the seconded company name "sample 01 company", and the second line is the affiliated company code "888", the seconded company. The name "Sample 02 company", the third line is the affiliated company code "999", and the seconded company name "Sample 03 company".

With reference to the employee master 107b and the affiliated company master 107c, the secondment order information is input and registered in the secondment order information file 107a.

In the example of the seconded announcement information shown in FIG. 9C, the first line is the seconded announcement date "2020/8/3", the issuance code "4000: seconded", the employee code 1000000001: sample Taro ", and the seconded company name" "Sample 01 company", the second line is the secondment announcement date "2020/10/2", the announcement code "4020: secondment cancellation", the employee code "1000000001: sample Taro", the seconded company name "sample 01 company" There is.

(Seconded person registration process)
The seconded person registration unit 102c registers the seconded person information in response to the operation of the operator on the registration screen displayed on the monitor 114, and specifically, the seconded person detailed information is the seconded person detailed information file. It is registered in 108c, and the seconded person item information is registered in the seconded person item information file 108d. FIG. 10A is a diagram showing an example of registration of detailed information on seconded employees. FIG. 10B is a diagram showing an example of registration of seconded person item information.

In the example of the seconded person detailed information shown in FIG. 10A, the target year / month “2020/8”, the seconded company NO “100”, the seconded pattern code “1: normal seconded”, the employee code “1000000001: sample Taro”, The date of start of secondment is "" and the date of cancellation of secondment is "".

In the example of the seconded person item information shown in FIG. 10B, the first line is the target date "2020/8", the seconded company NO "100", the seconded pattern code "1: normal seconded", and the employee code "1000000001". : Sample Taro ”, item serial number“ 1 ”, billing item“ basic salary ”, salary calculation amount“ ”, daily rate coefficient denominator“ ”, daily rate coefficient molecule“ ”, billing amount“ ”, second line is the target year Month "2020/8", seconded company NO "100", seconded pattern code "1: normal seconded", employee code "1000000001: sample Taro", item serial number "2", billing item "overtime allowance", payroll calculation The amount is "", the daily rate factor denominator "", the daily rate coefficient element "", and the billed amount "".

(Seconded fee calculation process)
The secondment fee calculation unit 102d, for example, responds to an operator's operation on the secondment fee calculation screen displayed on the monitor 114, and refers to the secondment order announcement information and employee salary payment information for the target year and month. The secondment fee (billing amount) is calculated based on the information and the detailed information of the seconded person. FIG. 11 is a diagram for explaining a mechanism for calculating the number of working days every month only by approving the personnel announcement. FIG. 12 is a diagram for explaining a mechanism for calculating the billing amount (seconded fee) by proportionally dividing each billing item by the number of working days.

First, I will explain the mechanism for calculating the number of working days each month simply by approving the personnel announcement.
In FIG. 11, regarding the seconded start date and seconded cancellation date of the seconded detailed information, the seconded company NO and the employee code are used as keys, and the target date is acquired (coordinated) from the seconded announcement date of the seconded announcement information. .. Specifically, the secondment start date is the date of the secondment announcement for the announcement code "4000: secondment", and the secondment cancellation date is the secondment announcement date of the announcement code "4020: secondment cancellation". And update the seconded person detailed information.

In the example shown in FIG. 11, the target date “2020/8” is set using the seconded company NO (seconded name) “100” and the employee code “1000000001” in the seconded detailed information shown in FIG. 11 (B) as keys. From the secondment announcement information shown in FIG. 11 (A), the secondment announcement date "2020/8/3" of the announcement code "4000: secondment" is acquired as the secondment start date, and the secondment cancellation date is the announcement code. The secondment announcement date "2020/10/3" of "4020: Cancellation of secondment" is acquired, and the detailed information of the seconded person is updated.

Next, a mechanism for calculating the billed amount (seconded fee) by proportionally dividing each billing item by the number of working days will be described. In FIG. 12, for the daily molecular coefficient of the seconded employee item information, the seconded company NO and the employee code are used as the keys, and for the target date, the seconded start date and the seconded cancellation date of the seconded detailed information are acquired. , Calculate the daily rate coefficient numerator, which is the number of working days in the month. In addition, the number of calendar days is set in the daily coefficient denominator. Furthermore, using the employee code as a key, the salary calculation amount (basic salary, overtime allowance, etc.) of the billing item is acquired from the employee salary payment information. For each billing item, the billing amount (seconded fee) = salary calculation amount x (daily rate coefficient molecule) based on the payroll amount, daily rate coefficient molecule, and daily rate coefficient denominator, that is, proportionally divided by the number of working days in the month. / Daily coefficient denominator) is calculated and the seconded person detailed information is updated.

In the example shown in FIG. 12, regarding the daily numerator coefficient of the seconded person item information shown in FIG. , 8/3 to 8/31 by acquiring the seconded start date "2020/8/3" and the seconded cancellation date "2020/10/2" of the seconded detailed information shown in FIG. 12 (A). The daily coefficient numerator "27", which is the number of working days of the above, is calculated. In addition, the number of calendar days in August "31" is set in the daily coefficient denominator. The payroll amount "200,000" is set for the basic salary of the billing item, and the payroll amount "100,000" for the overtime allowance is set. In the employee salary payment information, it is assumed that the basic salary "200,000" and the overtime allowance "100,000" are registered for the employee code "1000000001".

As shown in FIG. 12C, for the billing item “basic salary”, the billing amount = salary calculation amount “200,000” × (daily coefficient element “27” / daily coefficient denominator “31”) = 174,193. Is calculated, and for the billing item “overtime allowance”, billing amount = salary calculation amount “100,000” × (daily coefficient molecule “27” / daily coefficient denominator “31”) = 87,096 is calculated.

(Output processing)
The output processing unit 102e responds to the operation by the operator on the output screen (not shown) displayed on the monitor 114, and sets the seconded person detailed information and the seconded person item information file 108d registered in the seconded person detailed information file 108c. Based on the registered seconded person item information, a billing list or invoice is created and output (display output or print output) for each seconded company. FIG. 13 is a diagram showing an output example of a billing list.

(3-3. Screen image)
An example of a screen image will be described with reference to FIGS. 14 to 17. The following screen image example shows an example when the sample data of FIGS. 8 to 13 is used. The screen display control unit 102f controls the display of various screens (for example, a seconded destination registration screen, an issuance registration screen, a seconded person registration screen, a seconded charge calculation screen, etc.) displayed on the monitor 114, and responds to an instruction from the operator. , Various screens are displayed on the monitor 114.

(Seconded destination registration process)
FIG. 14A is a diagram showing an example of a seconded destination registration screen for registering seconded company basic information in the seconded destination basic master 108a. FIG. 14B is a diagram showing an example of a seconded destination registration screen for registering seconded destination detailed information in the seconded destination detailed master 108b. On the seconded destination registration screen, the seconded destination information is registered only when the seconded destination or the seconded contract is new. 14 (C) is a diagram showing a registration example of the seconded destination basic master 108a, and FIG. 14 (D) is a diagram showing an example of registration of the seconded destination detailed master 108b.

The example of the seconded company registration screen shown in FIG. 14A includes a field for inputting a seconded company code, a field for inputting a seconded company name, and a field for inputting a partner company code. For the affiliated company, select the company that matches the company registered in the "seconded destination" of the issuance registration. When the seconded company code, the seconded company name, and the affiliated company code are entered and the registration button is pressed, the entered data is registered in the seconded destination basic master 108a. FIG. 14C shows an example of data registered in the seconded basic master 108a.

In the example of the seconded company registration screen shown in FIG. 14 (B), a field for inputting a seconded company code, a field for inputting a seconded pattern code, a field for inputting a seconded pattern name, and a billing item to be charged for each seconded pattern. It has a field to select and. In the field for selecting billing items, items such as basic salary, overtime allowance, and seconded allowance can be selected and set. In the field for selecting a billing item, a billing item can be added by pressing the item addition button, and if the billing item is added, the item serial number is incremented by "1". When the seconded company code, seconded pattern code, seconded pattern name, and seconded request item are entered and the registration button is pressed, the entered data is registered in the seconded destination detail master 108b. FIG. 14D shows an example of data registered in the seconded destination detail master 108b.

(Announcement registration process)
FIG. 15A is a diagram showing a display example of the issuance registration screen for registering the secondment issuance information. FIG. 15B is a diagram showing a display example of the seconded destination search sub-screen. FIG. 15C is a diagram showing a data example of the referenced employee master 107b. FIG. 15D is a diagram showing a data example of the referenced employee master 107b. FIG. 15 (E) is a diagram showing a data example of the seconded order information to be registered.

In the example of the issuance registration screen shown in FIG. 15 (A), a field for entering the issuance date, a field for entering the issuance name (4000: seconded, 4020: cancellation of seconding), a field for entering an employee code, and a seconded destination It has a field for entering the partner company code of. When the employee code is input, the corresponding employee name is read out from the employee master 107b shown in FIG. 15C and displayed. The input of the seconded partner company code is performed from the seconded destination search sub screen shown in FIG. 15 (B), in which a list of data registered in the affiliated company master 107c shown in FIG. 15 (D) is read out and displayed. You can select and enter. Enter the announcement date, the announcement name, the employee code, and the partner company code of the seconded destination, and press the registration button, and the entered data will be registered in the seconded announcement information. FIG. 15 (E) shows a data example of the seconded order information to be registered.

(Seconded person registration process)
FIG. 16A is a diagram showing a display example of a seconded person recording surface for registering seconded person information (seconded person detailed information, seconded person item information). FIG. 16B is a diagram showing a data example of the seconded destination detailed master 108b to be referred to. FIG. 16C is a diagram showing a data example of the registered seconded detailed information. FIG. 16D is a diagram showing a data example of registered seconded item information.

In the example of the seconded person registration screen shown in FIG. 16A, there are a field for entering an employee code, a field for selecting a seconded destination, a field for setting a seconded start date and a seconded cancellation date, and billing items. It has a column for setting the number of daily prorated days. In the field for selecting the seconded destination, it is possible to select from the seconded companies registered in the seconded destination detailed master 108b shown in FIG. 16 (B). The date of start of secondment and the date of cancellation of secondment are automatically set in cooperation with the date of announcement of personnel announcement employee information when the secondment fee calculation is executed. As the item of the billing item, the billing item of the seconded destination detail master 108b corresponding to the selected seconded company is displayed. For example, when the seconded company NO "100" is selected, the billing items "basic salary" and "overtime allowance" are displayed.

The number of prorated days for billing items is calculated and automatically set from the date of starting the secondment, the date of cancellation of the secondment, and the number of calendar days when the secondment fee calculation is executed. When the employee code and the seconded destination are entered and the registration button is pressed, the entered data is registered in the seconded person detailed information and the seconded person item information. 15 (C) and 15 (D) show data examples of the seconded destination detailed information and the seconded destination item information to be registered.

(Seconded fee calculation process)
FIG. 17A is a diagram showing a display example of the secondment fee calculation screen. FIG. 17B is a diagram showing a data example of the seconded order information to be referred to. FIG. 17C is a diagram showing a data example of detailed information on the seconded person. FIG. 17D is a diagram showing a data example of seconded person item information.

On the secondment fee calculation screen shown in FIG. 17A, when the target date is entered and the execute button is pressed, the secondment fee is charged for each billing item for the seconded person detailed information and the seconded person item information for the target year and month. The billing amount is calculated, and the seconded person detailed information and the seconded person item information are updated.

As described above, according to the present embodiment, the seconded company, the seconded announcement including the seconded period, and the seconded order information including the seconded order information are registered in the storage unit 106 for each target employee, and the issuance registration unit 102b. For each target employee, the seconded person registration unit 102c, which registers the seconded person information including the target year and month, the seconded company, the billing item indicating the item of the seconded contract, and the seconded person information in the storage unit 106, and the seconded person for the target year and month. For each employee who is the target of the person information, the secondment period is acquired from the secondment order information, the number of working days is calculated, and the billing amount is calculated by dividing the salary calculation amount by the number of working days for each billing item. Therefore, it is possible to reduce the work burden when the seconded company calculates the amount billed for the seconded employee's seconded fee to the seconded company.

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

For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part can be automatically performed by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the secondment fee calculation device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the secondment fee calculation device 100, particularly each processing function performed by the control unit, all or any part thereof is realized by the CPU and a program that is interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the secondment fee is calculated as necessary. It is read mechanically by the device 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form a control unit.

Further, this computer program may be stored in an application program server connected to the secondment fee calculation device 100 via an arbitrary network, and all or part of the computer program may be downloaded as needed. Is.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for specific configurations and reading procedures for reading the recording medium in each apparatus shown in the embodiment, installation procedures after reading, and the like.

Various databases and the like stored in the storage unit are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the secondment fee calculation device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the secondment fee calculation device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

100 Seconded charge calculation device 102 Control unit 102a Seconded destination registration unit 102b Issue registration unit 102c Seconded person registration unit 102d Seconded charge calculation unit 102e Output processing unit 102f Screen display control unit 104 Communication interface unit 106 Storage unit 107 Personnel table 107a Seconded order information File 107b Employee master 107c Partner company master 108 Salary table 108a Seconded basic master 108b Seconded details master 108c Seconded detailed information file 108d Seconded item information file 108e Employee salary payment information file 109 Input / output interface 112 Input device 114 Output device 200 servers 300 networks

Claims (7)

A secondment fee calculation device equipped with a storage unit and a control unit.
The control unit
For each target employee, the seconded company, the personnel issuance including the seconded period, and the issuance registration means for registering the seconded order information including the seconded period in the storage unit.
A seconded person registration means for registering seconded person information including the target year and month, the seconded company, the billing item indicating the item of the seconded contract, and the seconded person information for each target employee.
For the target year and month, for each employee in the seconded information, the seconded period is acquired from the seconded order information to calculate the number of working days, and for each billing item, the billing amount is calculated by dividing the salary calculation amount by the number of working days. Seconded fee calculation method and
A secondment fee calculation device characterized by being equipped with. The secondment fee calculation device according to claim 1, wherein the billing item includes at least one of a basic salary, an overtime allowance, and a secondment allowance. The secondment fee calculation device according to claim 1 or 2, wherein the billing amount is calculated by the billing amount = salary calculation amount × (number of working days in the target year / month ÷ number of calendar days in the target year / month). The secondment fee calculation device according to any one of claims 1 to 3, wherein the personnel announcement includes the announcement date of the secondment and the announcement date of the cancellation of the secondment. The control unit further
The secondment fee calculation device according to any one of claims 1 to 4, wherein each seconded company is provided with an output processing means for outputting an invoice or an invoice. It is a method of calculating a secondment fee to be executed by an information processing device equipped with a storage unit and a control unit.
Executed in the control unit,
For each target employee, the seconded company, the personnel issuance including the seconded period, and the issuance registration process for registering the seconded order information including the seconded period in the storage unit.
A seconded person registration process for registering seconded person information including the target year and month, the seconded company, the billing item indicating the item of the seconded contract, and the seconded person information for each target employee.
For the target year and month, for each employee in the seconded information, the seconded period is acquired from the seconded order information to calculate the number of working days, and the billing amount is calculated by dividing the salary calculation amount by the number of working days for each billing item. The secondment fee calculation process and
A secondment fee calculation method characterized by including. It is a secondment fee calculation program to be executed by an information processing device equipped with a storage unit and a control unit.
In the control unit
For each target employee, the seconded company, the personnel issuance including the seconded period, and the issuance registration process for registering the seconded order information including the seconded period in the storage unit.
A seconded person registration process for registering seconded person information including the target year and month, the seconded company, the billing item indicating the item of the seconded contract, and the seconded person information for each target employee.
For the target year and month, for each employee in the seconded information, the seconded period is acquired from the seconded order information to calculate the number of working days, and the billing amount is calculated by dividing the salary calculation amount by the number of working days for each billing item. The secondment fee calculation process and
Seconded fee calculation program to execute.

Images