JP7249650B2 - Working time calculation system, payroll system and computer program - Google Patents

Description

The present invention relates to a working time calculation system, a payroll calculation system, and a computer program for establishing a more rational method of calculating overtime hours (overtime working hours).

Conventionally, at each place of business, employers and workers have exchanged agreements on wages based on labor contracts, and wages and other wages are calculated based on these agreements. At that time, if a worker works longer than the working hours specified in the employment regulations, etc. (hereinafter referred to as the prescribed working hours in this specification), a separate wage will be paid as overtime work, etc. required by law. In particular, for overtime work that exceeds legal working hours (8 hours per day, 40 hours per week) or work on legal holidays, it is also obligatory to pay extra overtime wages. It is

In recent years, the problem of unpaid overtime has become apparent, and lawsuits and the like related to this have also occurred. Unpaid overtime pay may be ordered to be paid retroactively to the past two years, so businesses that have not paid overtime pay are potentially at great risk. On the other hand, the provisions of laws such as the Labor Standards Act have a certain degree of freedom. In some cases, it is possible to eliminate the risk of non-payment of overtime wages.

In view of this background, in Patent Document 1, the prescribed working hours of each worker are read from an information file prepared in advance, and the attendance and departure data of each worker for each day recorded in the attendance and departure time data file by the time recorder. Calculate the actual overtime hours for each day by comparing with the regular working hours, and total the actual overtime hours of the worker during the aggregation period. A system for aggregating current period results is disclosed. Here, what is specifically used as the information file in Patent Document 1 is information on the prescribed working hours of each worker on each day and information on the working days set for each worker based on the annual calendar. file. In this case, in order to be able to legally calculate overtime hours, it is natural that the annual calendar included in the information file should be an employment rule that conforms to the Labor Standards Act and the Ordinance for Enforcement of the Labor Standards Act. It is a major premise that the one created according to is prepared in advance.

In addition, Patent Document 2 discloses a work management device that automatically sends warning information to the parties involved and supervisors when a rule is violated, based on work performance and standards based on rules regarding labor. disclosed. Determination of whether or not the labor performance conflicts with the rules is executed by referring to the alert criteria information database. According to the disclosure of paragraph 0035 of Patent Document 2, this alert criteria information database is It stores calendar information based on the work regulations of the business entity, etc. This calendar information includes the start and end working hours (so-called regular working hours) stipulated in the work regulations, etc., and the business entity BP's regular holidays This includes information necessary for calculating working hours, such as information indicating the number of hours worked, the specified overtime work start time, and the like. Therefore, here as well, it is necessary as a premise that a calendar created in accordance with the employment regulations is prepared in a form of data.

JP 2013-134629 A JP 2007-272746 A JP 2011-065372 A

However, there are cases where business operators prepare only calendars that are inconsistent with the work rules, or calendars that include legal flaws due to problems inherent in the work rules themselves even if they are compatible. Also, the underlying calendar itself may not exist. When trying to actually implement the technique of Patent Document 1 or Patent Document 2, in the former case, if the calendar used is not legal, there is no way that the overtime hours can be calculated legally. . Moreover, if the calendar itself does not exist like the latter, it is fundamentally impossible to utilize such technology. The number of businesses in this situation is surprisingly large, and we are far from being able to calculate and pay overtime wages in a rational manner as described above.

Patent document 3 discloses an example of a system that automatically calculates salaries including overtime wages in accordance with employment regulations. However, this system adopts a very complicated and expensive equipment system that converts work regulations into data as character strings, analyzes them using AI, and extracts the items of the salary calculation formula. has not yet become widespread.

The object of the present invention is to obtain the values of overtime hours for each day, which are necessary for calculating overtime pay, etc., even when a working hour calendar that conforms to the work rules is not prepared. To provide a working hours calculation system that can be rationally calculated using

In order to solve the above problems, the working hours calculation system of the present invention includes: A working hour system input setting unit that selectively inputs and sets the working hours system to be set to either the general working hours system or the variable working hours system, and a predetermined schedule of days to be set for each worker's prescribed work day A daily scheduled working hours input unit for inputting working hours, a daily total working hours calculation unit for calculating the total working hours for each worker on each day based on the data of the starting and leaving times, and a total daily working hours calculation unit for each worker The date attribute applied to each date for each employee is determined as a holiday for dates when the calculated total daily working hours are less than a predetermined value, and as a predetermined working day for dates when the total daily working hours are greater than a predetermined value. For dates whose date attribute is determined to be a scheduled working day, the total working hours per day are determined according to the input scheduled working hours and working hour system. and determine the daily scheduled working hours to be allocated to the date based on the result of the comparison. a working hours determination unit for creating, for each worker, a working hours calendar in which dates, date attributes determined for the dates, and prescribed working hours per day are associated with each other; a working hour calendar storage unit for storing the created working hour calendar; read the daily prescribed working hours for each worker on the working hour calendar; An overtime calculation unit that divides the daily overtime hours for each date into legal overtime hours and non-legal overtime hours by comparing the hours and the day-specific legal working hours, and each date for each worker an overtime hours counting unit that calculates aggregated overtime hours by aggregating daily overtime hours for a predetermined aggregate target period; It is characterized by comprising a time storage unit and an aggregated overtime hours output unit that outputs the aggregated overtime hours stored in the aggregated overtime hours storage unit.

Further, a payroll calculation system of the present invention comprises the working hours calculation system of the present invention, and a payroll calculation unit that calculates the payroll of each worker based on the information on the aggregated overtime hours output by the working hours calculation system. It is characterized by having

A first aspect of the computer program of the present invention is characterized by causing a computer to function as each function implementation unit of the working time calculation system of the present invention. Furthermore, a second computer program of the present invention is characterized by causing a computer to function as each function implementation unit of the payroll accounting system of the present invention.

In the working time calculation system of the present invention, data on arrival/departure times recorded by a time recorder or the like is acquired, and based on the data on arrival/departure times, the total working hours of each worker on each date is calculated as the total daily working hours. calculate. The feature is that a working hour calendar is created using the calculated total daily working hours. Therefore, even if a working hour calendar that conforms to the rules of employment is not prepared, by using the created working hour calendar, it is possible to rationally calculate the value of overtime hours for each day necessary for calculating overtime pay, etc. . More detailed effects are as follows.

The criteria for classifying total daily working hours into regular working hours and overtime hours are the values of statutory working hours specific to the day and the values of scheduled regular working hours that are individually agreed upon with workers in contracts, etc. . Assuming that a detailed working hour calendar in which these values are individually incorporated cannot be prepared by the user for some reason, the minimum information for the user is the type of working hour system and the scheduled work day. to enter the time. The reason why the type of working hour system is required to be entered is that the statutory working hours for each day differ according to the type of working hour system under the Labor Standards Act (and its Enforcement Regulations). In the present invention, the types of working hours system that can be selected in the working hours system input setting section are the general working hours system where the legal working hours are stipulated in the above law, weekly, monthly and yearly variable working hours. system. As a result, the working hours system that can be set on the created calendar is limited to those that comply with the Labor Standards Act. In addition, in the present invention, "prescribed working hours" are set within the scope of "statutory working hours" in accordance with the Labor Standards Act, and of course, the scheduled prescribed working hours are also set and input within the scope of the day-specific legal working hours. be.

On the premise of the above, the working hour calendar creation department determines that the dates for which the calculated total daily working hours are less than a predetermined value are holidays, and the total daily working hours are determined as holidays. Dates exceeding the value are discriminated as predetermined working days. Then, for the date whose date attribute is determined to be a scheduled work day, the total daily working hours calculated by the total daily working hours calculation unit are calculated according to the input scheduled working hours for the day and the type of working hour system. It compares with at least one of the prepared day-specific statutory working hours, and determines the daily prescribed working hours to be allocated to the date based on the comparison result. On the other hand, for dates whose date attributes are determined as holidays, the daily prescribed working hours are determined as zero. Then, the date attribute determined for each date and the daily prescribed working hours are linked to form a working hour calendar. Here, the predetermined value set for the total working hours per day for the discrimination of days off is, for example, zero. In some cases, it is also possible to set a positive non-zero value. However, in order to enhance compliance with the Labor Standards Act, it is more desirable to set the predetermined value to zero.

In the working hours calendar created in this way, the prescribed daily working hours determined by referring to the scheduled daily working hours that comply with the Labor Standards Act and the statutory working hours peculiar to the day are set for each date, and the contents thereof is essentially guided in a law-abiding direction. Furthermore, the statutory overtime hours and non-statutory overtime hours for each date calculated by the overtime hours calculation unit with reference to this will surely comply with the provisions of the Labor Standards Act.

In other words, even if the business operator can only use a calendar that is inconsistent with the work rules, a calendar that contains legal defects, or even if the calendar itself does not exist, according to the present invention, the Labor Standards Law It is possible to easily create a working time calendar that conforms to the provisions of , based on the data of workers' arrival and departure times. From a different point of view, the implementation of overtime calculations using the legally compliant working hour calendar created by the present invention leads to the encouragement of employers to operate working styles in accordance with legal employment regulations. , the effect on labor guidance is also remarkable. In addition, even if the employer does not pay the full amount of wages for overtime hours, by showing the calculation results of the total overtime hours that are legally subject to wage payment, the actual situation of illegal wage payment and its risks It can also be an opportunity for business operators to grasp the situation with concrete figures and to promote reforms that lead to legal work styles.

For each worker on each date, the working hour calendar creation unit determines the day-specific statutory working hours, which are the statutory working hours peculiar to each day, according to the value of the total daily working hours and the setting type of the working hour system. It can be configured so as to have a unique legal working hours determination unit and create a working hour calendar by associating dates, date attributes, daily prescribed working hours, and daily unique legal working hours. In this case, the overtime hours calculation unit refers to the working hour calendar to calculate the non-statutory overtime hours for each date using the corresponding day-specific legal working hours. Since the legal working hours specific to each day are set for each date in the working hours calendar, it is possible to calculate the non-legal overtime hours for each date without error. In particular, when the variable working hours system is adopted, the statutory daily working hours are legally permitted to vary on a weekly, monthly, or yearly basis. By setting specific statutory working hours, it is possible to calculate the non-statutory working hours for each day more easily and reliably. The specific statutory working hours for each day, week, and month are

The working hour calendar creation unit creates a daily working hour calendar in which the date, the date attribute determined for the date, and the calculation result of the daily prescribed working hours are associated with each other, and divides the working hour calendar into weeks. A weekly working hours calendar in which week specific information is added to each week obtained by the method can be created as a working hours calendar. In this case, a total weekly working hours calculation unit is provided to calculate the total weekly working hours by summing up the total daily working hours for each week. The overtime calculation unit calculates the cumulative daily non-statutory overtime hours for each week, which is the total of non-statutory overtime hours for each day, and compares the total weekly working hours with the predetermined weekly specific legal working hours, If the comparison results show that weekly overtime hours exceed the specific weekly statutory working hours, the weekly overtime hours are added to the weekly cumulative daily overtime hours to calculate the total weekly overtime hours. It can be configured to include a non-statutory overtime hours calculation unit. The Labor Standards Act (and its enforcement regulations) also stipulates the statutory weekly working hours, which are the statutory working hours of workers per week. Hours are subject to premium wage payment as non-statutory overtime hours. By creating the above weekly working hours calendar based on the daily working hours calendar created from the arrival and departure time data, the total weekly non-statutory overtime hours including weekly overtime hours can be calculated according to the Labor Standards Act. can be calculated accurately according to the provisions of

In this case, the working hour calendar creation unit has a week-specific statutory working hours determination unit that determines the week-specific statutory working hours, which are the statutory working hours peculiar to each week, according to the setting type of the working hour system for each week. It is even better to construct a weekly working hours calendar by associating the specific information with the weekly specific statutory working hours. The overtime hours calculation unit can be configured to determine the weekly overtime hours as the difference between the weekly total working hours and the weekly specific statutory working hours by referring to the weekly working hours calendar. By setting the statutory working hours specific to each week in the working hours calendar, it becomes possible to calculate the weekly overtime hours more accurately. In particular, when a variable working hours system is adopted, the statutory weekly working hours are legally allowed to vary on a weekly, monthly or yearly basis, but each week of the working hours calendar By setting the working hours in advance, the weekly overtime hours can be calculated more easily and reliably.

In the above configuration, when the general working hours system is input and set as the working hours system, the daily prescribed working hours determination part determines the daily prescribed working hours for days when the total daily working hours are less than 8 hours. hours, while on days when the total working hours per day exceeds 8 hours, the daily scheduled working hours are set to 8 hours. As a result, on days when the total working hours per day are less than the legal working hours of 8 hours due to leaving early or arriving late, the reduced total working hours per day can be set as the prescribed working hours per day. is subtracted from the scheduled working hours per day, it is possible to accurately calculate the shortage of hours subject to wage reduction in accordance with the Labor Standards Act. On the other hand, from the viewpoint of uniformly and accurately calculating non-statutory overtime hours according to the Labor Standards Act when the general working hours system is input and set, the day-specific legal working hours It is preferable that the working hours are uniformly determined as 8 hours, and the weekly statutory working hours determining section uniformly determines the statutory weekly working hours as 40 hours for each week. In addition, the unique statutory working hours for each day, week, and month are set to values that do not match the statutory working hours stipulated in the Labor Standards Act Enforcement Regulations for the convenience of legally calculating non-statutory overtime hours. (especially where flexible working hours are in place).

Next, a desirable mode when the variable working hours system is adopted will be described. The variable working hours system is a working hours system that adjusts working hours on a monthly or yearly basis so that even if working hours increase due to busy periods, etc., it is not treated as overtime work. There is an advantage that working hours can be adjusted when the time required for work varies from month to week, such as during the off-season. On the other hand, many black companies misunderstand the variable working hours system as a system that allows employees to work as many hours as they want. Even in the case of the variable working hours system, employees must be paid for overtime work that exceeds the working hours stipulated by law.

In the present invention, the working hours system input setting unit can be configured to be able to input and set a weekly modified working hours system as the modified working hours system. When the weekly variable working hours system is input and set, the above problem can be solved by configuring as follows. First, the prescribed daily working hours determination unit sets the prescribed daily working hours for each date to be equal to the total daily working hours regardless of the value of the total daily working hours. In addition, the week-specific statutory working hours determining unit uniformly determines the statutory weekly working hours for each week as 40 hours when the weekly variable working hours system is input and set.

In the weekly variable working hours system, the upper limit of legal working hours is stipulated on a weekly basis. The concept of non-statutory overtime hours does not exist. However, in the above aspect of the present invention, a value equal to the total daily working hours is purposely set as the daily prescribed working hours for each date on the created daily working hours calendar. That is, as a result of always setting a value equal to the total daily working hours as the daily prescribed working hours, the statutory overtime hours per day are always calculated as zero regardless of the total daily working hours. On the other hand, the weekly-specific legal working hours determination section uniformly determines the weekly-specific legal working hours for each week as 40 hours. Even if a work situation occurs in which the prescribed working days are set excessively, the working hours exceeding 40 hours, which are the peculiar weekly legal working hours, are accurately calculated as non-legal overtime hours. In other words, by making the above settings on the created daily working hours calendar, non-statutory overtime even if a weekly variable working hours system with no limit on statutory working hours per day is adopted The time can be accurately calculated, and the effect of labor guidance for business operators is also remarkable.

In the present invention, the working hours system input setting unit can be configured to be able to input and set a monthly modified working hours system as the modified working hours system. In the case where the monthly variable working hours system is input and set, it is desirable to configure as follows. That is, the monthly specific legal working hours that divide the daily working hours calendar into months and determine the monthly specific legal working hours according to the number of days in each month for each divided month. Establish a decision section. In addition, the daily prescribed working hours determining unit sets the daily prescribed working hours equal to the total daily working hours regardless of the value of the total daily working hours. The weekly statutory working hours determination unit shall not set limits on the statutory weekly working hours for each week. The overtime hours calculation unit calculates the total monthly working hours, which is the sum of the total working hours for each month, and compares the total working hours of the month with the legal working hours specific to the month. is provided with a monthly total non-statutory overtime hours calculation unit for calculating the monthly overtime hours as the monthly total non-statutory overtime hours when the monthly overtime working hours exceed .

Under the monthly variable working hours system, the upper limit on total daily working hours as well as the total weekly working hours will be abolished, and instead the upper limit on total working hours per month will be limited by the (month) statutory working hours. Therefore, according to the above configuration, the value equal to the total daily working hours is always set as the daily prescribed working hours, as in the case where the weekly variable working hours system is adopted, and as a result, the legal overtime hours per day are It is always calculated as zero regardless of the total hours worked per day. The Department for Determining Weekly Specific Statutory Working Hours does not set limits on the statutory working hours specific to the week, but calculates the total monthly working hours and determines the portion of the total working hours of the month that exceeds the statutory working hours specific to the month. is calculated as monthly total non-statutory overtime hours. As a result, even if an employment situation occurs in which the prescribed working days for the total daily working hours exceeding 8 hours (which is the legal working hours under the general working hours system) are set excessively, the monthly specific legal working hours can be accurately calculated as non-statutory overtime hours. In other words, by making the above settings on the created daily working hours calendar, non-statutory overtime hours even if a monthly variable working hours system with no restrictions on legal working hours per day is adopted can be calculated legally, and the effect of labor guidance for employers is also remarkable.

In addition, when the weekly variable working hours system or the monthly variable working hours system is entered and set, the day-specific statutory working hours decision section By setting the value to be equal to the total daily working hours, the daily statutory overtime hours can always be calculated as zero for the date. On the other hand, the day-specific statutory working hours determination department is configured to determine the day-specific statutory working hours to 8 hours on dates where the total daily working hours are less than 8 hours. Time can always be calculated as zero.

In the present invention, the working hours system input setting unit can be configured to be able to input and set annual modified working hours system as modified working hours system. When the variable working hours system for each year is input and set, it is desirable to configure as follows. In other words, on days when the total daily working hours are less than 10 hours, the daily scheduled working hours determination unit determines the daily scheduled working hours to be equal to the total daily working hours, while on the other hand, the total daily working hours exceed 10 hours. The date shall be determined assuming that the prescribed working hours per day is 10 hours. In addition, the weekly specific statutory working hours determination unit determines the peculiar weekly statutory working hours as 52 hours for the week in which the total prescribed daily working hours exceeds 52 hours.

Under the annual variable working hours system, if working hours per week are 40 hours or less on average for a certain period (target period) exceeding one month and up to one year determined by the place of business, It can be understood as a system that does not need to be treated as overtime work even if there are weeks exceeding 40 hours or days exceeding 8 hours. This is a useful system when there are fluctuations in work during the year, such as when there are seasonally busy times, or when the five-day work week system cannot be implemented, and it allows flexible operation of working hours. There are advantages. Specifically, the upper limit on the total working hours per day, the total working hours per week and the total working hours per month will be abolished, and instead the upper limit on the total working hours per year will be set by the (annual) statutory working hours. be done. However, in order to prevent an unlimited increase in working hours per day or per week, the Labor Standards Act (and its Enforcement Regulations) requires that the total working hours per day be 10 hours and the total working hours per week be 10 hours. Each time is capped at 52 hours.

In the above structure, on days when the total daily working hours exceed 10 hours, the prescribed daily working hours are determined as 10 hours, which is the upper limit of the legal limit, and the working hours exceeding this are accurately calculated as non-statutory overtime hours per day. . In addition, since the weekly statutory working hours determination department determines that the statutory working hours peculiar to the week exceeds 52 hours, the total weekly working hours that exceed the statutory working hours exceed 52 hours. The portion is accurately calculated as weekly non-statutory overtime hours.

In addition, when inputting and setting the variable working hours system on a yearly basis, the day-specific statutory working hours determination department determines the day-specific statutory working hours as 10 hours on dates where the total daily working hours exceed 10 hours. On days when working hours exceed 8 hours and less than 10 hours, the day-specific statutory working hours shall be determined equal to the total daily working hours, and on days when the total daily working hours are less than 8 hours, the day-specific statutory working hours shall be 8 hours. If it is configured to be determined as hours, it is possible to always calculate the daily non-statutory overtime hours as zero for dates when the total daily working hours is less than 10 hours. Similarly, the weekly specific legal working hours determination unit determines the weekly specific legal working hours to be equal to the total weekly working hours for weeks in which the total of the daily prescribed working hours exceeds 40 hours and is less than 52 hours. If you configure the system to determine the weekly total statutory working hours to be 40 hours for weeks where the total hours are less than 40 hours, the weekly non-statutory overtime hours will always be zero for the days when the total weekly working hours are less than 52 hours. can be calculated as

Next, it is not possible to determine the types of holidays on dates when the total working hours calculated from the arrival/departure time data are less than a predetermined value. In order to solve this problem, the working hours calculation system of the present invention can be provided with a legal holiday setting condition input unit for inputting legal holiday setting conditions for each worker. The date attribute determination unit of the working hour calendar creation unit determines whether the date determined as a holiday is a legal holiday based on the input legal holiday setting conditions and the appearance form of the date determined as a holiday in the date attribute. It can be configured as having a legal holiday determination unit that determines whether or not. The overtime hours totaling unit can be configured to separately total the total daily working hours for dates determined to be legal holidays as holiday attendance hours. As a result, legal holidays can be reflected in the working hour calendar created by the working hour calendar creation unit, and the holiday work hours subject to extra wages can be accurately calculated.

In this case, the statutory holiday setting condition input unit is a statutory holiday system input setting unit for selectively inputting and setting the statutory holiday system to either a fixed day of the week, an unspecified day of the week 1 day a week, or an unspecified day of the week 4 weeks 4 days; A legal holiday Sunday input setting unit for inputting and setting a legal holiday Sunday to be fixed when the set legal holiday system is a fixed day of the week. If the selected statutory holiday system has fixed days of the week, the statutory holiday determination unit determines a holiday that matches the selected statutory holiday Sunday as a statutory holiday, and determines that the selected statutory holiday system has no fixed days of the week. If there is one day per week, the first day of each holiday is determined as a legal holiday, and if the selected legal holiday system is 4 weeks and 4 days with no fixed days, each week is divided into 4 weeks. In addition, it is possible to determine up to four of the holidays that appear in each of the four divided weeks as legal holidays. As a result, irregular legal holidays that arise due to shift work or the like can be accurately reflected in the created working hour calendar.

Further, the working hours calculation system of the present invention can be provided with a paid vacation date input unit for inputting the paid vacation date notified for each worker. The date attribute determination unit of the working time calendar creation unit can be configured to determine the date attribute of the input paid vacation date as paid vacation. The overtime hours totaling unit can be configured to separately total the total daily working hours for the date determined as the paid vacation time as the paid vacation hours. As a result, it is possible to accurately reflect paid vacations that cannot be determined only by the data of the leaving and leaving time data in the working time calendar to be created. In addition, if the paid vacation date input section allows selection and input of only one of morning only, afternoon only, and all morning and afternoon as the acquisition form of paid vacation time, compliance with the Labor Standards Act can be further improved. .

Furthermore, the working hours calculation system of the present invention can be provided with a substitute holiday information input unit for inputting substitute holiday information notified for each worker. In this case, the working hour calendar creation unit is configured to have a date attribute transfer unit that transfers the date attribute of the target date between the predetermined work day and the holiday based on the content of the input substitute holiday information. can. On a date when the total working hours calculated from the arrival/departure time data is less than a predetermined value, it cannot be determined whether or not it is a transfer from another holiday. With the above configuration, it is possible to accurately reflect the notification of the substitute holiday in the working hours calendar created by the working hours calendar creation unit.

Since the effect of the present invention has been described in detail in the column of Means for Solving the Problems, it will not be repeated here.

FIG. 2 is a block diagram showing one configuration example of the salary calculation system of the present invention; 1 is a block diagram showing an example of a user terminal device incorporating functions of the working hours calculation system of the present invention; FIG. The figure which shows the example of the content of the attendance clock data. The figure which shows an example of the content of the common item data contained in medical record data. FIG. 4 is a diagram showing selection input items included in common item data; The figure which shows an example of the content of the item list classified by department included in medical record data. FIG. 10 is a diagram showing selection input items included in a department-by-department item list; The figure which shows an example of the content of employee master data. The figure which shows the 1st example of submission calendar data. The figure which shows the second example of submission calendar data. FIG. 4 is a diagram showing an example of the content of vacation application data; The figure which shows the example of the content of early/late application data. The figure which shows the example of the content of night duty application data. FIG. 4 is a diagram showing an example of contents of created calendar data; The figure which shows the example of the content of working time calculation summary data. 4 is a flow chart showing the flow of processing of the main software; The flowchart which shows the flow of a chart data creation process. 4 is a flowchart showing the flow of submission calendar data integration processing. 4 is a flowchart showing the flow of stamp correction processing. 4 is a flowchart showing the flow of total daily working hours calculation processing; The flowchart which shows the flow of a midnight restraint time calculation process. 4 is a flowchart showing the flow of a late-night break time calculation process; 4 is a flowchart showing the flow of daily calendar creation processing. 4 is a flowchart showing the flow of processing for setting working hours for a predetermined working day. 4 is a flowchart showing the flow of weekly/monthly calendar creation processing. 6 is a flowchart showing the flow of vacation application reflection processing; 4 is a flowchart showing the flow of paid vacation reflection processing; 6 is a flowchart showing the flow of a transfer holiday reflection process; A flowchart showing the flow of the total daily working hours apportionment process. 4 is a flow chart showing the flow of stamped data use processing. 4 is a flowchart showing the flow of submission calendar use processing; 4 is a flowchart showing the flow of weekly work hours integration/distribution processing. 4 is a flow chart showing the flow of monthly working hour accumulation/distribution processing.

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below with reference to the accompanying drawings.
FIG. 1 is a block diagram showing one configuration example of the payroll accounting system of the present invention. The payroll accounting system 1 includes a labor management server 5 and a plurality of user terminals 2 which are interconnected by the Internet 6 as a public communication network. The labor management server 5 is configured as, for example, a cloud server, and is installed with payroll calculation software 5a. By logging into the labor management server 5 from each user terminal 2 via the Internet, the payroll calculation software 5a can be used in the form of cloud software.

FIG. 2 is a block diagram of the user terminal 2. As shown in FIG. The user terminal 2 is configured as a personal computer (PC) having a microcomputer as a main processor. The microcomputer comprises a CPU 51, a RAM 52 serving as a program execution area, a ROM 53, an input/output unit 54, and a bus 50B interconnecting them. Also, the bus 50B is connected to a mass storage device 55 constituted by a hard disk drive (which may be composed of a semiconductor storage device such as a flash memory). Communication software 55b and Internet browser 55c are installed. The input/output unit 54 is also connected to an input unit 57 including a monitor 56 and a keyboard. Further, a broadband router 60 is connected to the bus 50B, and the user terminal 2 is connected to the Internet 6 via the broadband router 60. FIG.

Main software 55d for realizing the main functions of the working time calculation system of the present invention is installed in the mass storage device 55. FIG. The main software 55d includes program modules of a data input module 55d1, a calendar creation module 55d2, a working time calculation module 55d3 and a CSV file generation module 55d4. In this embodiment, the main software 55d is built on spreadsheet software (eg, Microsoft Excel, trade name) that is convenient for calculating working hours, but the software form is not limited to this. .

The main software 55d can be installed in each user terminal 2 by downloading it from a predetermined distribution server 3 via the Internet 6 in FIG. 1, for example. It may also be configured so that it can be installed from a CD-ROM, removable memory medium, or the like. In FIG. 2, a USB memory loading unit 59 is provided for loading a USB memory 59m as a detachable memory medium. , are not shown because they are well-known devices).

In the large-capacity storage device 55, the user of the payroll calculation system 1, such as a company, a corporation, a store, or a sole proprietor (hereafter collectively referred to as "enterprise"), is created and stored in a computer-readable form. Original data 55e to be submitted and used as a basis for calculating working hours is stored. Specifically, the original data 55e includes chart data 55e0 (including common item list data 55e1 and affiliation item list data 55e2), employee master data 55e3, submission calendar data 55e4, and vacation application data. 55e5, early departure/late arrival application data 55e6, night duty application data 55e7, and attendance/leaving clock data (hereinafter simply referred to as clock data) 55e8. These data can be acquired by communication via the Internet 6 (for example, an attached file of an e-mail or downloaded from a server), or can be acquired through a storage medium such as a USB memory 59m. 55d1 is responsible for realizing the function. That is, the function of the departure/exit time data acquisition unit is realized.

A configuration example of the original data 55e will be described below.
FIG. 3 shows an example of attendance/leaving data 55e8 included in the chart data 55e0. The attendance/leaving data 55e8 is a collection of data stamped and recorded by a time recorder for attendance/leaving management deployed at an office or the like for each worker (employee). It corresponds to "time data". In this embodiment, the data is in the form of a spreadsheet of spreadsheet software, and the employee code, name, date, arrival time, leaving (leaving), break entry time, break return time, etc., which are specific information for each worker. data are associated with each other.

FIG. 4 shows an example of the common item list data 55e1 included in the chart data 55e0. This includes a notification email address, a notification telephone number, and the like. On the other hand, selection input items include "break input method", "replacement of attendance time", "night duty regulations" and "if yes, whether night duty allowance is included in night duty allowance". Data entry is possible. "Break input method" is information that defines the format of the break time input on the attendance/leaving stamp data 55e8 in FIG. 3, and as shown in FIG. A choice is possible. The attendance/leaving time data 55e8 in FIG. 3 is displayed in the format when "entering-returning time" is selected, and when "obtained time" is selected, the length of time obtained for the break is the same as the break shown in FIG. It is incorporated into the spreadsheet of attendance/leaving data 55e8 in place of entry time and break return time. In addition, as for "replacement of attendance time", it is possible to select and input either "yes" or "no". Also, although not shown in the figure, "night duty regulations" can be either "yes" or "no", and "if yes, whether night duty allowance is included in night duty allowance" is "included". Selective input to either "not included" is possible respectively.

FIG. 6 shows an example of affiliation item list data 55e2 included in the chart data 55e0. "Working hour system" for selecting and inputting the type of salary payment, "Salary payment" for selecting and inputting the unit period of salary payment, "Starting day of the week" for selecting and inputting the first day of the week on the working hours calendar, "Statutory holiday" for entering legal holiday setting conditions (responsible for the function of the legal holiday setting condition input part), "basic legal holiday" for selecting and inputting the basic legal holiday of the week, scheduled working hours in the morning "Morning hours" to enter, "Afternoon hours" to enter scheduled working hours in the afternoon functions are realized), and each item of "Calendar Submission Method" is defined.

In the "Affiliation" item, specific information of the department to which the user belongs (in this embodiment, a number determined for each department to which the user belongs) is entered. In addition, as shown in Fig. 7, the "Working hours system" item can be selected from a pull-down menu for general working hours system, modified working hours system (one week), modified working hours system (one month), and modified working hours system (one month). year) can be selected. In other words, the function of the working hour system input setting unit that selectively inputs and sets the working hour system to be set for each worker to either the general working hours system or the variable working hours system is realized. For the "salary payment" item, one of "hour", "day", and "month" can be selected and input from a pull-down menu. Any one of "fixed", "one day per week", and "four days per four weeks" can be selected and input for the "statutory holiday" item. The "basic legal holiday" item is for selecting the day of the week when "fixed" is selected as the "legal holiday", and one of the seven days of the week can be selected and input from the pull-down menu. If the business office has a calendar of working hours that can be submitted, the item "Method of submitting a calendar" can be selected from the pull-down menu by selecting "Create annually" (yearly calendar), "Create monthly (department)" (Monthly calendar (by department). )), or “created monthly (individual)” (monthly calendar (by worker)). On the other hand, if the business office does not have a working hours calendar that can be submitted, "stamping data" is selected. When "stamping data" is selected, the working hours calendar is not submitted, but is processed by the calendar creation module 55d2 using the attendance/leaving stamping data 55e8 of FIG.

Next, FIG. 8 shows an example of the contents of the employee master data 55e3, in which worker identification information (employee code), worker name (name), and department identification information (affiliation) are associated with each other. It was given.

FIG. 9 shows an example of the contents of an annual working hours calendar (annual calendar) for each department, as an example of the submission calendar data 55e4. , (day) scheduled prescribed working hours and scheduled attendance time are associated with each other. The upper part of FIG. 10 shows an example of the contents of a monthly working hour calendar (monthly calendar) for each department, including department specific information (department), date, date attribute (date type), (day) scheduled scheduled work Each piece of information on the time and scheduled time of work is associated with each other. The lower part of Fig. 10 shows an example of the content of a monthly calendar for each individual worker, which includes worker identification information (employee code), worker name (name), date, date attribute (date type), (day) schedule. Each piece of information on the prescribed working hours and the scheduled attendance time is associated with each other.

FIG. 11 shows an example of the content of the leave application data 55e5, which includes worker identification information (employee code), worker name (name), application content, application date, days off, length of leave, and no days off. , the working day (in the case of a substitute holiday/substitute holiday), the length of work, and the scheduled work arrival time in that case are associated with each other. Each of these items is entered as data according to the content of the leave application form submitted by the worker. Among these, the content of the application is selected from a pull-down menu, and one of "paid leave", "alternative holiday", and "substitute holiday" is input. In addition, only one of "all day", "AM" (morning) and "PM" (afternoon) can be selected for the length of rest, and requests for leave for shorter time units will not be accepted. It has become.

FIG. 12 shows an example of the contents of the early arrival/late arrival application data 55e6. are associated with each other. Each of these items is entered as data in accordance with the content of the early arrival/late arrival application form submitted by the worker. FIG. 13 shows an example of the contents of the night duty application data 55e7, in which worker identification information (employee code), worker name (name), and night duty day information are associated with each other. Each of these items is entered as data according to the contents of the night duty application form submitted by the worker.

Next, the working time calculation module 55d3 in FIG. 2 is for realizing the following functions.
・Total daily working hours calculation unit: Calculates the total working hours of each worker on each day as the total working hours per day based on the data of the time of arrival and departure.
・Overtime hours calculation unit: Overtime hours calculation unit Reads the daily prescribed working hours for each worker on the working hour calendar, and calculates the daily total working hours, the daily scheduled working hours, and the day-specific statutory working hours for each date. By comparing , the daily overtime hours for each date are calculated by classifying them into statutory overtime hours and non-statutory overtime hours.
- Overtime hours totaling unit: Calculates the totaled overtime hours by totaling the daily overtime hours of each worker on each date for a predetermined aggregation target period.

Also, the calendar creation module 55d2 is for realizing the function of the working hour calendar creation section, and includes the following function implementation section.
・Date attribute determination unit: For each worker, the date attribute for each date is determined as a holiday for the date when the calculated total daily working time is less than the predetermined value, and for the date when the total daily working time exceeds the predetermined value is determined as a prescribed working day.
- Daily scheduled working hours determination part: For dates whose date attribute is determined to be a scheduled working day, the total daily working hours are calculated according to the input scheduled working hours for the day and the type of working hour system. While comparing with at least one of the statutory working hours and determining the daily scheduled working hours that should be allocated to the date based on the comparison result, the daily scheduled working hours are determined as zero for the date whose date attribute is determined as a holiday. do.
Then, for each worker, a working hour calendar is created in which the date, the date attribute determined for that date, and the daily prescribed working hours are associated with each other.

The created working hours calendar is stored in the mass storage device 55 as created calendar data 55f (that storage area forms a working hours calendar storage section). FIG. 14 shows an example of created calendar data 55f, which is created individually for each worker. Specifically, items of "affiliation", "date" and "day of the week", "date attribute" calculated or determined in accordance with the calendar creation process described later, and the most frequent The value of each item of "scheduled work time", "daily prescribed working hours" (DWH), and "day-specific statutory working hours" (SWH) estimated from the work arrival time etc. is associated (this part is the daily work hours forms a time calendar). In addition, the daily working hours calendar is divided into weeks using the information of the belonging item list data 55e2 corresponding to the content of the "affiliation" item, and week specific information (week number) is assigned to each of the separated weeks. be. Then, each week number is associated with the weekly scheduled working hours DWH' and the weekly statutory working hours (SWH') calculated or determined in accordance with the calendar creation process described later (this part forms the weekly working hours calendar). are doing). Furthermore, each week is divided into monthly units, and correspondingly, the item of monthly peculiar statutory working hours SWH" used in the monthly variable working hour system is also associated.

According to the Labor Standards Act, the scheduled weekly working hours DWH' are set within 40 hours in the case of the weekly variable work system, and no upper limit is set in the case of the monthly variable work system. In addition, in the case of the annual variable work system, according to the Labor Standards Act, it is possible to set it appropriately within a range not exceeding 52 hours. Therefore, it is desirable to input a legal numerical value for each week in advance as the weekly scheduled predetermined working hours DWH'.

The aggregated overtime hours data is then stored in the mass storage device 55 as aggregated working hours calculation data 55g (that storage area forms an aggregated overtime hours storage unit). FIG. 15 shows an example of the total working hours calculation data 55g, which is also created individually for each worker. In addition, "date", "total daily working hours" (TWH), "day and night working hours (NWH)," legal overtime hours per day" (SOH), "non-statutory overtime hours per day" (NSO), " Day Shortage Hours" (QWH), "Holiday Hours", "Week Number", "Weekly Total Hours" (TWH), "Weekly Midnight Hours" (NWH), "Weekly Legal Overtime Hours" (SOH), It has a data structure in which each aggregation/calculation item of "weekly non-statutory overtime hours" (NSO) and "overtime hours exceeding 60 hours" are associated with each other in a format similar to the working hours calendar.

FIG. 16 shows the main processing flow of the working time calculation system of the present invention by the main software 55d. In S1 (creation of chart data), original data provided by the user is taken in, and processing such as creation of an employee master is executed. In S2 (integration of submitted calendar data), if the original data contains calendar data that has been divided and submitted, a process of integrating the data is performed. In S3 (correction of clocking), rounding/correction processing of the clocking data of attendance/leaving clock data 55e8 is performed. In S4 (calculation of total working hours per day), the total working hours of each day are calculated from the time of arrival/departure and break time of the clock data.

In S5 (creation of daily calendar), a calendar of daily working hours (hereinafter also referred to as a daily calendar) is created for employees for whom there is no calendar data to be submitted, from the total daily working hours of each day. In S6 (creation of weekly calendar), the daily calendar is aggregated to create a weekly working hours calendar (hereinafter also referred to as a weekly calendar). In S7 (creation of monthly calendar), the weekly calendars are aggregated to create a monthly working hours calendar (hereinafter also referred to as a monthly calendar). In S8 (reflection of vacation application), the daily working hours calendar is assigned to the working hour calculation total data 55g (FIG. 15) to reflect the vacation application data.

In S9 (total working hours distribution per day), a process of distributing the total working hours based on the daily prescribed working hours, the statutory working hours peculiar to the day, and date attributes is performed. In S10 (accumulation/distribution of weekly working hours), the aggregated results of the daily working hours are accumulated for each week. Also, based on the weekly calendar, the weekly total of each working hour is redistributed. In S11 (Monthly Working Hours Accumulation/Distribution), the aggregated result of each weekly working hours is accumulated for each month. Also, based on the monthly calendar, the monthly total of each working hour is redistributed.

FIG. 17 is a flowchart showing the details of the chart data creation process (FIG. 16: S1). In S101, original data provided by the user is obtained. Specifically, the medical record data 55e0 (FIG. 4: common item list data 55e1, FIG. 6: affiliation item list data 55e2), submission calendar data 55e4 (FIG. 9 or 10), and time attendance data 55e8 are sent to the Internet 6. (FIG. 1) Obtained by download via a route, acquisition by communication such as e-mail, reading from a storage medium, or manual input. In S102, employee master data is similarly acquired.

In S103, selection/input of input items from the pull-down menu included in the common item list data 55e1 of FIG. do In S104, input items from the pull-down menu included in the affiliation item list data 55e2 of FIG. monthly salary), legal holiday system (fixed, 1 day a week, 4 days a week), basic legal holiday days (Sunday to Saturday), etc. In S105, the user obtains the vacation application data 55e5 of FIG. 11 and selects/inputs the input items from the pull-down menu, that is, the application contents (paid/compensatory holiday/substitute holiday) and the length of vacation (all day/AM/PM). do Finally, in S106, the early arrival/late arrival application data 55e6 of FIG. 12 and the night duty application data 55e7 of FIG. 13 are obtained.

FIG. 18 shows details of the submission calendar data integration process (S2). In S201, first, what is referred to as the item of "Calendar Submission Method" in the item list data 55e2 by department 55e2 in FIG. If "stamping data" is selected in this item, it means that there is no submission calendar data, submission calendar data integration processing is unnecessary, and the process proceeds to the next step of stamping correction processing (S3). On the other hand, if any other form is selected, the process advances to S202 to determine what form is selected as the calendar submission form. In this embodiment, as the submitted calendar data 55e4, when a yearly calendar (Fig. 9) is submitted, when a monthly calendar by belonging department (Fig. 10 top) is submitted, and when a monthly calendar by individual worker ( Fig. 10 bottom) is assumed, and in S203 to S205, each submitted calendar data is converted into a calendar template file (see Fig. 14) used when creating a working hour calendar. Transfer to each item in parts. As a result, in S204 and S205, the submitted monthly calendar data for each month are integrated into a yearly calendar. In this embodiment, the value of each date of the (day) scheduled predetermined working hours included in the submitted calendar data is transferred as each value of the daily predetermined working hours (DWH) in FIG. In addition, each value of the day-specific legal working hours (SWH) is set to a predetermined value according to the type of working hour system selected and the date attribute (the function of the day-specific legal working hours determination unit has been realized). Each value of the weekly calendar and monthly calendar portions is the same as the process for creating the calendar, which will be described later.

Next, FIG. 19 shows the details of the stamp correction process (S3). This processing is executed for each date for each worker's attendance and leaving data 55e8 (FIG. 3). First, in S301, when "replace attendance time" is selected as "Yes" in the common item list data 55e1 (FIG. 4), the process proceeds to S302. In S302, it is determined whether or not the corresponding worker's early arrival/late arrival application data has been input on the relevant date. is replaced with the scheduled attendance time of the day calendar. As a result, even if the stamped attendance time data varies from day to day, the data is uniformly rounded to the predetermined scheduled attendance time.

On the other hand, if early departure/late application data exists in S302, the process proceeds to S304, and the attendance time data is replaced with the applied time. In addition, if you arrive late or leave early without applying in advance, it is assumed that the application data for early departure/late arrival will be submitted and supplemented at a later date, and there is no early arrival/late application data (that is, the notification was forgotten). The attendance time data corresponding to early arrival or late arrival is not considered. Subsequently, in S305, the time to come to work and the time to leave work (leaving) stamped on the same date are compared. This is for confirming whether or not the leaving time is over the date. If the leaving time is less than the starting time, it is determined that the date is over. Perform processing to add time. In this case, it is assumed that the time to leave work is displayed, for example, within the range of the 30-hour system.

Next, FIG. 20 shows details of the total daily working hours calculation process (S4). This processing is also executed for each date for each worker's attendance and leaving time stamp data 55e8 (FIG. 3). In S401, a calendar template file (see FIG. 14) is opened. The calculation result of the total daily working hours for each date is written in the cell of the corresponding date of the working hour calculation summary data 55g (FIG. 15) described later. In S402, the duty time RH is calculated as the leaving time ET-arriving time AT. This on-duty time RH includes a break time VH to be deducted from the total working time WTH. In addition, an algorithm is adopted that takes into consideration the calculation of working hours for the payment of late-night allowances, which is assumed when legally compliant employment rules are enacted. A detailed description will be given below.

In S403, it is checked whether or not the night duty application data for the applicable worker has been entered for the applicable date. If it has been input, the process proceeds to S404, and if it has not been input, S404 is skipped. In S404, the common item list 55e1 (FIG. 4) is checked to determine whether or not the night duty allowance includes the late-night allowance (whether or not there is a provision for the provision of the late-night allowance in the night duty allowance). is selected, the process proceeds to S406, and if not included (no provision for payment of late-night allowance) is selected, the process proceeds to S405 and sets the late-night duty time NRH=0. If the process proceeds to S406, it is determined whether or not the restraint time RH is applied from 22:00 to 5:00 the next morning, when AT≧05:00 and ET≦22, as determined by the Labor Standards Law. : Examine whether or not 00 is satisfied. In the case of no in S406, the process advances to S407 to perform midnight duty time calculation processing. In the case of yes in S406, the process proceeds to S405, and the midnight restraint time NRH=0.

FIG. 21 shows an example of a late-night on-duty time calculation process. In S40701, it is checked whether AT<05:00. If yes in S40701, the process advances to S40702 to check whether ET<05:00. If yes in S40702, proceed to S40703A to calculate the midnight duty time (1) by ET-AT. If no in S40702, proceed to S40703B to calculate the midnight duty time (1) at 05:00-AT. On the other hand, if S40701 is no, S40702 to S40704 are skipped.

Next, in S40705, it is checked whether ET>22:00. If yes in S40705, the process advances to S40706 to check whether AT>22:00. If yes in S40706, the process advances to S40707 to check whether ET<29:00. If yes in S40707, the process proceeds to S40708, and the midnight duty time (2) is calculated by ET-AT. If no in S40707, the process advances to S40709 to calculate the midnight duty time (2) at 29:00-AT.

On the other hand, if no in S40706, the process advances to S40710 to check whether ET<29:00. If yes in S40710, proceed to S40711 to calculate the midnight duty time (2) at ET-22:00. If no in S40710, proceed to S40712, and calculate the midnight duty time (2) from 29:00 to 22:00. Also, in the case of no in S40705, the process advances to S40712 and the same processing is performed. In S40713, the final midnight duty time is calculated as midnight duty time (1)+midnight duty time (2).

Returning to FIG. 20, in S408, it is confirmed what is selected as the break input method in the common item list data 55e1 (FIG. 4). If "acquisition time" is selected, the process proceeds to S409, and the stamped value is adopted as the break time (this also applies to the late-night break time). On the other hand, if the "entering/returning time" is selected, the process proceeds to S411 to calculate the break time VH by (returning time VET - entering time VAT). Next, in order to calculate the late-night rest period included in the rest period, it is checked in S412 whether VAT≧05:00 and VET≦22:00 are satisfied. In the case of no in S412, the process advances to S413 to perform midnight break time calculation processing. In the case of yes in S412, the process proceeds to S410, and the late-night break time NVH is set to zero.

FIG. 22 shows an example of a late-night break time calculation process. In S41301, it is checked whether VAT<05:00. If yes in S41301, the process advances to S41302 to check whether VET<05:00. If yes in S41302, proceed to S41303 to calculate the late-night break time (1) by VET-VAT. If no in S41302, proceed to S41304 to calculate the late-night break time (1) as 05:00-VAT. On the other hand, if S41301 is no, S41302 to S41304 are skipped.

Next, in S41305, it is checked whether or not VET>22:00. If yes in S41305, proceed to S41306 to check whether VAT>22:00. If yes in S41306, proceed to S41307 to calculate the midnight break time (2) by VET-VAT. If S41306 is no, proceed to S41308 to calculate the late-night break time (2) at VET-22:00. In S41309, the final late-night break time is calculated as late-night break time (1)+late-night break time (2).

Since the calculation of the on-duty time and the break time is completed as described above, returning to FIG. 20, the total daily working hours TWH is calculated as the on-duty time RH-the break time VH in S414. Further, in S416, the day and night working hours NWH are calculated by dividing the midnight duty time NRH-the midnight break time NVH. The calculated daily total working hours TWH and day/night working hours NWH are transferred and stored in the corresponding date cell of the corresponding worker's working hours calculation summary data 55g (FIG. 15).

FIG. 23 shows the details of the daily calendar creation process (S5). This processing is sequentially carried out by referring to the calculation results of the total working hours TWH in the working hour calculation summary data 55g (FIG. 15) of each worker for each date on the calendar template file of FIG. . In S501, it is determined whether or not there is submission calendar data. If there is submission calendar data, day calendar creation is not required and the entire process is skipped.

In S502, it is determined whether or not the total working hours TWH>0 (that is, the predetermined value for the holiday determination comparison is set to zero). If no in S502, the process proceeds to S503 to set the day as a predetermined holiday on the day calendar. Also, set the daily prescribed working hours DWH=0 and the day-specific statutory working hours SWH=0, and store the values in the corresponding cells of the calendar template file. On the other hand, in the case of yes in S502, the process proceeds to S504, and the relevant day is set as a predetermined working day on the day calendar. Then, the process advances to S505 to perform working hours setting processing for a predetermined working day.

FIG. 24 shows details of the processing. In S50501, the affiliation item list data 55e2 of FIG. 6 is referenced to determine the type of working hour system selected for the department to which the target worker belongs. If the general working hours system is selected in S50501, the process advances to S50502 to determine whether or not TWH≧8 for the total working hours TWH. If YES in S50502, proceed to S50504 to set daily prescribed working hours DWH=8 and daily specific statutory working hours SWH=8 and store the values in the corresponding cells of the calendar template file. On the other hand, if no in S50502, proceed to S50503 and set the daily prescribed working hours DWH=TWH (that is, set the calculated value of the total working hours of the day as the value of the daily prescribed working hours DWH). Also, the day-specific statutory working hours SWH is set to 8 (hours), and each value is stored in the corresponding cell of the calendar template file.

Here, the calculated daily scheduled working hours are the actual scheduled working hours, which are the scheduled working hours actually worked, as is clear from the fact that they are calculated based on the total working hours. It is different from the daily scheduled prescribed working hours input and set in the data 55e2 (Fig. 6). According to the Labor Standards Act, under the general working hours system, the statutory working hours per day is 8 hours, and the scheduled working hours per day can be freely set within the statutory working hours per day (i.e., 8 hours). . Therefore, when the total working hours TWH≧8 in S50502, both the daily prescribed working hours DWH and the day-specific legal working hours SWH are both set to 8 hours in S50504, so that the day-specific legal working hours are reached. work as prescribed working hours, and working hours exceeding this are legally and compulsorily calculated as non-statutory overtime hours. In addition, as will be described later, the statutory overtime hours are also calculated in compliance with the set value of the daily scheduled overtime hours. In other words, for businesses that do not have rules of employment that do not violate the Labor Standards Act or a calendar of working hours that conforms to this, the calculation of working hours (and wage calculations using such calculations) will be implemented as if the rules of employment were legal. This can be done automatically.

In FIG. 24, if the variable working hours system is selected in S50501, the process advances to S50505 to further discriminate what the selected variable unit type is. If the weekly or monthly variable working hours system is selected in S50505, the process advances to S50506 to determine whether or not TWH≧8. If no in S50506, proceed to S50507 and set the daily prescribed working hours DWH=TWH (that is, set the calculated value of the total working hours of the day as the value of the daily prescribed working hours DWH). Also, the day-specific statutory working hours SWH is set to 8 (hours), and each value is stored in the corresponding cell of the calendar template file. On the other hand, if YES in S50506, proceed to S50508 to set both the daily prescribed working hours DWH and the day-specific statutory working hours SWH to be equal to the total working hours TWH for that day, and fill the corresponding cells in the calendar template file. Store. In the variable working hours system, it is possible to set prescribed working hours that exceed the legal working hours specific to the day under certain restrictions, and by setting as above, legal overtime hours or non-legal overtime hours for that date Calculations can be induced so that does not occur.

On the other hand, if the yearly variable working hours system is selected in S50505, the process advances to S50509 to determine whether or not TWH≧8. If no in S50509, proceed to S50510 and set the daily prescribed working hours DWH=TWH. Also, the day-specific statutory working hours SWH is set to 8 (hours), and each value is stored in the corresponding cell of the calendar template file. On the other hand, if YES in S50509, the process advances to S50511 to determine whether or not TWH≧10. This reflects the fact that the Labor Standards Law (and its Enforcement Regulations) limits the total daily working hours to 10 hours under the annual variable working hours system. If no in S50511, both the daily prescribed working hours DWH and the day-specific statutory working hours SWH are set equal to the total working hours TWH for that day, and the respective values are stored in the corresponding cells of the calendar template file. On the other hand, if YES in S50511, set daily prescribed working hours DWH=10 and daily specific statutory working hours SWH=10, and store the values in the corresponding cells of the calendar template file.

Next, FIG. 25 shows the details of the weekly/monthly calendar creation process (S6). In S601, the type of working hour system selected is discriminated. If the general working hours system is selected in S601, the process advances to S609 to set the week-specific statutory working hours SWH'=40 (hours) and store the value in the corresponding cell of the calendar template file. If the variable working hours system is selected in S601, the process proceeds to S602. If the weekly variable working hours system is selected, the process advances to S609 to set the weekly statutory working hours SWH'=40 (hours) and store the value in the corresponding cell of the calendar template file. In the other cases, proceed to S603. If the monthly variable working hours system with no restrictions on legal weekly working hours is selected, skip S609 and enter the legal weekly working hours SWH in the calendar template file. ' is blank, for example.

On the other hand, if the yearly variable working hours system is selected in S603, the process advances to S604 to determine whether or not DWH'≧40 for the weekly scheduled prescribed working hours DWH'. If no in S604, proceed to S605, set the week-specific legal working hours SWH'=40, and store the value in the corresponding cell of the calendar template file. On the other hand, if YES in S604, the process advances to S606 to determine whether or not DWH'≧52. In the case of no in S606, the weekly specific legal working hours SWH'=DWH' (that is, the set value of the weekly scheduled prescribed working hours of the week is set as the value of the weekly specific legal working hours SWH'), and the calendar template is created. Store the value in the corresponding cell of the file. In this case, it is assumed that the weekly scheduled working hours DWH' are appropriately adjusted values so that the average scheduled working hours for each week of the year is 40 hours or less. On the other hand, if yes in S606, SWH'=52 (hours) and the value is stored in the corresponding cell of the calendar template file. This is based on the violation of the provisions of the Labor Standards Act for the scheduled weekly working hours DWH' to exceed 52 hours in the annual variable working hours system, and the employer's request is Even if the time DWH' is set to 52 hours or more, working hours exceeding 52 hours are forcibly calculated as non-statutory overtime hours. This completes the weekly calendar creation process. In addition, it is clear that the function of the week-specific statutory working hours determining unit is realized in the above process flow.

The steps from S701 onward are monthly calendar creation processing. In S701, the type of working hour system selected is discriminated. Month-specific settings are required only when the monthly variable working hours system is adopted. Calculate as 40 (hours) and store the value in the corresponding cell of the calendar template file (the function of the month-specific statutory working hour determination unit is realized). does not set a limit on monthly statutory working hours, and finishes processing.

Subsequently, a process of reflecting the contents of the vacation application in the calendar data created as described above is executed. FIG. 26 shows the details of the vacation application reflecting process (S8). In S801, the data of each date in the day calendar is assigned to the record of each date in the total working hours calculation data 55g (FIG. 15). The processing for each date is described below. In S802, it is checked whether vacation application data has been input for the target date. Also, in S803, it is checked whether the day is the day for which the vacation application is reflected. If the answer is no in either case, the vacation request reflection process is skipped. On the other hand, if both are yes, the process advances to S804 to discriminate the vacation type selected for the date. In the case of a substitute holiday, processing such as transfer is unnecessary, and leave application reflection processing is skipped. On the other hand, if the paid vacation is selected, the process proceeds to S805, and if the substitute holiday is selected, the process proceeds to S806, and individual processing is performed.

FIG. 27 is a flow chart showing details of the paid vacation reflecting process (S805). In S80501, the form of taking paid leave (length of rest) is discriminated. As already explained with reference to FIG. 11, in this embodiment, only one of "all day," "AM" (morning), and "PM" (afternoon) can be selected for the length of rest. Although not shown in FIG. 15, for example, the number of paid days PHN for each worker and the paid hours for each date are stored in the working hours calculation summary data 55g. If the length of rest is all day, the process advances to S80502 to add 1 to the number of paid days taken PHN. In addition, in S80503, all the scheduled working hours for that day are incorporated into the paid hours PHH.

If the length of rest is "AM" (morning), the process advances to S80504 to add 0.5 to the number of paid days taken PHN. In S80505, the morning set time AMH (see FIG. 6: departmental item list data 55e2) of the day's scheduled prescribed working hours on that date is incorporated into the paid hours PHH. If the rest length is "PM" (afternoon), the process advances to S80506 to add 0.5 to the number of paid days taken PHN. In S80507, the afternoon setting time PMH (see FIG. 6: departmental item list data 55e2) of the day's scheduled prescribed working hours on that date is incorporated into the paid hours PHH. Since wage calculation for paid hours is performed separately from wage calculation for working hours, in S80508, the paid hours PHH are subtracted from the scheduled predetermined working hours of the day. In S80509, it is checked whether the remaining hours of the day's scheduled working hours are negative, and if so, the scheduled working hours of the day are set to zero in S80509.

For example, when the length of rest is "AM", the worker comes to work in the "PM" time zone, and the time to come to work and the time to leave work are stamped. The daily scheduled scheduled working hours after the subtraction are applied to the total working hours calculated based on this, and if overtime work occurs, the overtime hours are calculated. On the other hand, rest time will be calculated as paid hours PHH.

FIG. 28 shows the details of the transfer holiday reflection process (S806), and in S80601, the designation of the transfer target period is confirmed. In this embodiment, the transfer period is set to only one day unit, and if the rest of the transfer target period is selected, the process advances to S80604 to perform alert processing by displaying on the monitor 56 or the like. On the other hand, if the entire target date is specified as the transfer target period, the flow advances to S80602 to check whether submission calendar data has been input. If it has been submitted, proceed to S80603 to perform transfer processing of date attributes, daily prescribed working hours DWH, and day-specific statutory working hours SWH on the submitted calendar data transferred to the calendar template file (see FIG. 14). On the other hand, if the submission calendar data does not exist, the process advances to S80605 to guide the user to manually input the transfer on the calendar data created using the calendar template file.

FIG. 29 is a flow chart showing the details of the total daily working hours distribution (S9). In S91, it is determined whether or not there is submission calendar data. If there is no calendar data to be submitted, the process proceeds to S92, and processing is performed using the attendance/leaving data. On the other hand, if there is submission calendar data, the process proceeds to S93, and the processing is performed using the submission calendar data. Both are run for each worker on each date.

FIG. 30 shows the details of the process (S92) when using the attendance/leaving data (that is, when there is no submitted calendar data and a calendar is created from the attendance/withstanding data). In accordance with the Labor Standards Act, consideration has been given to the algorithm so that holiday working hours that are subject to premium wages are calculated only for working on legal holidays. First, in S9201, the affiliation item list data 55e2 is referenced to determine the selection state of the legal holiday type. If the legal holiday is fixed on the day of the week (the day of the week selected as the basic legal holiday in the affiliation item list data 55e2 (Fig. 6) is the legal holiday) or 4 days a week is selected, proceed to S9202; Determine whether the date attribute being processed is a legal holiday (the function of the legal holiday discriminating unit is realized above). If it is a legal holiday, the process advances to S9203 to set the total working hours TWH for that date to the holiday working hours HWH and all other types of working hours to zero in the working hour calculation summary data 55g. If the date attribute is not a legal holiday in S9202, the process proceeds to S9204 and subsequent steps. In this process, the working hours are calculated for the predetermined working days or predetermined holidays that are not subject to the calculation of the holiday working hours.

First, in S9204, the total working hours TWH and the scheduled daily working hours PWD are compared to determine whether or not TWH≧PWD. If the result in S9204 is no, that is, if the total working hours TWH of the date is smaller than the scheduled daily working hours PWD, the process advances to S9205 to set the total working hours TWH as the (actual) prescribed working hours DWH, The working hours QWH are calculated as QWH=PWD-TWH and set in the working hours calculation summary data 55g. On the other hand, if YES in S9204, that is, if the total working hours TWH for the date is greater than the daily scheduled working hours PWD, the process advances to S9206 to set the daily scheduled working hours PWD as the (actual) scheduled working hours DWH. Furthermore, the day shortage working hours QWH is calculated as zero and set in the working hour calculation summary data 55g. In S9207, the total working hours TWH and the day-specific statutory working hours SWH are compared to determine whether or not TWH≧SWH. If no in S9207, that is, if the total working hours TWH on the date is smaller than the day-specific legal working hours SWH, proceed to S9208, calculate the legal overtime hours SOH by SOH = TWH - PWD, and perform non-legal overtime work. The hour NSO is calculated as zero and set in the working hours calculation summary data 55g respectively. If yes in S9207, that is, if the total working hours TWH on the date is greater than the day-specific legal working hours SWH, the process advances to S9209 to calculate legal overtime hours SOH by SOH = SWH - PWD, while non-legal The overtime hours NSO are calculated as NSO=TWH-SWH, and each is set in the working hour calculation summary data 55g.

Here, in the case of a predetermined holiday, the daily scheduled predetermined working hours PWD are set to zero, so in S9204 the process proceeds to the S9206 side regardless of the value of the total working hours TWH. If the worker does not come to work on this day, TWH is zero. In S9206, the (actual) prescribed working hours DWH is also zero. It is equal to SWH (0 hours because it is a holiday), and the process proceeds to S9209. Therefore, both legal overtime hours SOH (=TWH-PWD) and non-legal overtime hours NSO (=TWH-SWH) are zero, and there is no inconsistency in processing. On the other hand, if the worker came to work on this day, the (actual) prescribed working hours DWH is also zero in S9206, and the total working hours TWH (time spent at work) is changed to the day-specific statutory working hours SWH (because it is a holiday, it is 0 in S9207). time) and proceeds to S9209. As for the legal overtime hours SOH (=SWH-PWD), the legal overtime hours SOH (=SWH-PWD) is zero because both the day-specific legal working hours SWH and the daily scheduled prescribed working hours PWD are zero. On the other hand, the legal non-statutory overtime hours NSO (=TWH-SWH) is equal to the total working hours TWH (hours spent at work) because the day-specific statutory working hours SWH is zero. In other words, it can be seen that all attendances on prescribed holidays are calculated as non-statutory overtime hours NSO, and are calculated in accordance with the Labor Standards Act.

Note that if 4 days/4 weeks is selected as the type of legal holiday, it is also possible to separately input which date is to be set as the legal holiday. On the other hand, if such setting is not performed and the date of the legal holiday cannot be specified, for example, the following can be done. That is, each date is divided into predetermined four-week periods, and if there are five or more days specified as holidays in the divided periods in the attendance and leaving time stamp data 55e8, the predetermined four days (For example, the first four days) are determined as legal holidays, and the remaining days are determined as predetermined holidays. Also, if the dates specified as holidays are four days or less, all of those dates are determined to be legal holidays. Also, in order to make the total number of statutory holidays during the period 4 days, for example, using the input unit 57 in FIG. It should be configured so that it can be modified.

On the other hand, the form in which there is one legal holiday per week is adopted in the case of shift work, etc., and one legal holiday is always taken per week, but the days of the week are not fixed. However, as there are many cases where the business side just verbally informs the workers of the arrangement of one day a week, in reality, the business office where the workload is large and is suffering from chronic labor shortages, management of setting legal holidays is neglected, and labor is sometimes operated without legal holidays.

Therefore, when one day a week is selected as the legal holiday type in S9201 of FIG. 30, the following processing is adopted in this embodiment. In other words, proceeding to S9210, it is checked whether or not there is a date determined as a holiday on another day within the same week (that is, within the week of the week number including the date being processed) in the created calendar data 55f. . If it is determined that there is a holiday, it is determined that the legal holiday setting of one day a week is being observed, the process proceeds to S9204, and the subsequent processing is the same as described above. At this time, if the date being processed is a predetermined working day, and if there is only one holiday in the same week, that date can be set as a legal holiday. On the other hand, if there are two or more days off, only one day can be set as a statutory holiday and the other days can be set as predetermined holidays. In either case, the working hours calculation for the date being processed can be executed without any problem in the flow from S9204 onwards regardless of the date attribute.

On the other hand, if it is determined in S9210 that there is no date determined to be a holiday on another day within the same week, the process advances to S9211. In this case, if the date being processed is a holiday, it means that the remaining days within the week are not holidays, so it can be determined that the date being processed is one legal holiday per week. On the other hand, if it is a prescribed working day, it means that there is no holiday in that week, and that the work operation is contrary to the setting of one legal holiday per week. Therefore, in S9211, the day of the week of the date currently being processed is confirmed. If the day of the week matches the day of the week selected as a basic legal holiday in the affiliation item list data 55e2, the date attribute of the date is a legal holiday. set the total working hours TWH for the holiday working hours HWH, and set all other types of working hours to zero. On the other hand, if it is a day of the week other than the above in S9211, the date attribute of the date is a predetermined working day, and the process advances to S9204 to perform the same processing thereafter.

FIG. 31 shows the details of the processing (S93) when using submission calendar data. In S9301, the affiliation item list data 55e2 is referred to determine the selection state of the legal holiday type. Since the processing from S9302 to S9309 is the same as the processing from S9202 to S9209 in FIG. 30, detailed description thereof will be omitted.

Returning to S9301, if the legal holiday type selection status is fixed to the day of the week or one day a week is selected in S9301, the process proceeds to S9310, and if the submitted calendar data contains the same week (that is, the date being processed is included) check whether there is a date that is determined to be a holiday on another day (within the week of the specified week number). If yes in S9310, that is, if it is determined that there is a holiday on another day within the week that includes the date being processed, it is determined that the fixed day of the week or the legal holiday setting of one day per week is observed. Then, the process advances to S9304, and the following processes are the same as those described above. On the other hand, if no in S9310, that is, if there is no holiday on another day within the same week, proceed to S9311 to see if there is a date for which the date attribute is defined as a legal holiday in the submission calendar data within that week. confirm whether or not If there is no legal holiday in S9311, it is determined that the submission calendar data has been created contrary to the fixed day or one day per week legal holiday setting, and the flow advances to S9312 to determine which week for the submission calendar data. Either a process for replacing the day with a legal holiday is performed, or a display or the like prompting the replacement process is output. On the other hand, if there is a legal holiday in S9311, the process advances to S9302 to perform the same processing as above.
This is the end of the explanation of the daily total working hours apportioning process.

FIG. 32 shows the details of the weekly working hours integration/distribution process (S10). In S1001, in the working hours calculation total data 55g (Fig. 15), for each week, the daily total working hours TWH, the daily prescribed working hours DWH, the daily statutory overtime hours SOH, the daily non-statutory overtime hours NSO, and the daily insufficient working hours QWH , day and night working hours NWH, working hours on Sundays and holidays HWH, and paid days PHN (the function of the total weekly working hours calculating section is realized). In the following, each parameter is a total value for each week, and for the sake of convenience, it is distinguished by adding a "'" to the sign.

In S1002, it is determined whether or not QWH'>0 for the weekly short working hours QWH'. If YES in S1002, the process proceeds to S1003 to determine whether the weekly working hours shortfall QWH' and the weekly statutory overtime hours SOH' are offset. Specifically, when SOH'≤QWH', the process advances to S1004, where the legal weekly overtime hours SOH is set to 0, while the weekly working hours shortfall QWH' is offset with SOH', and the value is set to QWH'-SOH. '. On the other hand, when SOH'>QWH', the process proceeds to S1005, where the weekly statutory overtime hours QWH' are set to 0, while the weekly statutory overtime hours SOH' are offset with QWH', and the value is calculated by SOH'-QWH'. replace. Note that if S1002 is no, S1002 to S1005 are skipped.

Next, in S1006, it is determined whether or not the employed working hours system is the monthly modified working hours system. If no in S1006, the process advances to S1007 to compare the value of weekly scheduled prescribed working hours DWH'+weekly statutory overtime hours SOH' with weekly peculiar legal working hours SWH'. If DWH'+SOH'≤SWH' in S1007, the process advances to S1008 to set the weekly total working hours TWH' as the value of the weekly scheduled prescribed working hours DWH' in the working hours calculation total data 55g (FIG. 15), and the weekly shortage is determined. The working hours QWH' is set to the value of (weekly specific statutory working hours SWH' - weekly scheduled prescribed working hours DWH').

If DWH'+SOH'>SWH' in S1007, the process advances to S1009 to compare the value of the weekly scheduled prescribed working hours DWH' with the weekly specific statutory working hours SWH'. If DWH'≤SWH' in S1009, the process proceeds to S1010, and in the working hour calculation summary data 55g (FIG. 15), the value of the weekly legal overtime hours SOH' is the value of the weekly legal working hours SWH'-the weekly scheduled prescribed working hours DWH. ' is set. In addition, as the value of the weekly overtime hours NSO', the weekly cumulative daily overtime hours NSO ^* (weekly total value of the daily overtime hours NSO) is added to the scheduled weekly working hours DWH' + the weekly legal overtime hours SOH '-Weekly statutory working hours SWH' value is added.

If DWH'>SWH' in S1009, the process advances to S1011 to set the value of the weekly legal overtime hours SOH' to zero in the working hours calculation summary data 55g (FIG. 15). In addition, as the value of the weekly overtime hours NSO', the weekly cumulative daily overtime hours NSO ^* (weekly total value of the daily overtime hours NSO) is added to the scheduled weekly working hours DWH' + the weekly legal overtime hours SOH '-Weekly statutory working hours SWH' value is added. It should be noted that if the determination in S1006 is yes, that is, if the employed working hours system is the monthly modified working hours system, S1006 to S1011 are skipped.

FIG. 33 shows the details of the monthly working hours integration/distribution process (S11). In S1101, the total weekly working hours TWH', daily prescribed working hours DWH', daily statutory overtime hours SOH', daily non-statutory overtime hours NSO', day The total value of the insufficient working hours QWH', the day and night working hours NWH', the working hours on Sundays and holidays HWH', and the number of paid days PHN' is calculated. In the following, each parameter is a total value for each month, and is distinguished by adding "" to the sign for convenience.

In S1102, it is determined whether or not QWH''>0 for the monthly insufficient working hours QWH''. If yes in S1102, proceed to S1103 to determine whether the monthly statutory overtime hours SOH are offset by the monthly insufficient working hours QWH''. While the time SOH" is set to 0, the monthly insufficient working hours QWH" are offset with SOH" and replaced with QWH"-SOH". On the other hand, when SOH">QWH", the process proceeds to S1105, and the monthly statutory overtime hours QWH" is set to 0, while the monthly statutory overtime hours SOH" is offset with QWH", and its value is set to SOH"-QWH". If S1102 is NO, S1102 to S1105 are skipped.

Next, in S1106, it is determined whether or not the employed working hours system is the monthly modified working hours system. If yes in S1106, proceed to S1107 to compare the value of monthly scheduled prescribed working hours DWH"+monthly statutory overtime hours SOH" with monthly specific legal working hours SWH". If DWH"+SOH"≦SWH" in S1107 advances to S1108, in the working hours calculation summary data 55g (Fig. 15), sets monthly total working hours TWH" as the value of monthly scheduled prescribed working hours DWH", and sets monthly specific statutory working hours SWH" as monthly insufficient working hours QWH" Set the value of "-month scheduled predetermined working hours DWH".

If DWH"+SOH">SWH" in S1107, proceed to S1109, and compare the value of the monthly scheduled prescribed working hours DWH" with the monthly statutory working hours SWH". If DWH"≤SWH" in S1109, proceed to S1110. , in the working hours calculation summary data 55g (FIG. 15), set monthly statutory working hours SWH"-monthly scheduled prescribed working hours DWH" as the value of monthly statutory overtime hours SOH". In addition, as the value of the monthly legal overtime hours NSO, the monthly cumulative daily overtime hours NSO ^** (monthly total value of the daily legal overtime hours NSO) is added to the monthly scheduled working hours DWH” + the monthly legal overtime hours SOH"-month-specific statutory working hours SWH" is added and set.

If DWH">SWH" in S1109, the process advances to S1111 to set the value of monthly statutory overtime hours SOH" to zero in the working hours calculation summary data 55g (FIG. 15). As the value of NSO", the monthly accumulated daily non-statutory overtime hours NSO ^* (monthly total value of daily non-statutory overtime hours NSO) is added to the monthly scheduled prescribed working hours DWH" + monthly legal overtime hours SOH" - month-specific legal working hours SWH" value is added. If the answer is no in S1106, that is, if the employed working hours system is other than the monthly variable working hours system, S1106 to S1111 are set. skip.

Then, in S1103, it is determined whether or not the value of the monthly non-statutory overtime hours NSO'' exceeds 60 hours. It is set in the working hour calculation summary data 55g (Fig. 15). If not, S1104 is skipped.

The working hours calculation value of each item of the working hours calculation summary data 55g is also used in general salary calculation software, and as described above, the main software 55d calculates in a manner conforming to the provisions of the Labor Standards Act. - Aggregation is done. The working hours calculation aggregated data 55g can be converted into a CSV file, for example, by the CSV file generation module 55d4 (FIG. 2), and transferred to the labor management server 5 via the Internet 6 (in this case, for example, the broadband router 60 can It can be considered that it takes over the function of the overtime hours output unit). The labor management server 5 receives the total working hours calculation data 55g converted to the CSV file, and multiplies the calculated value of the working hours for each item (type) by a predetermined unit wage per hour using the payroll calculation software 5a. In addition, the wages of each worker are calculated after deduction of wages based on the working hours shortage. The calculation result is downloaded from the labor management server 5 to each user terminal 2 via the Internet 6, and can be output from the monitor 56 or the printer 58 in FIG. 2 in a predetermined format. The contents of the calculation processing by the payroll calculation software 5a using the working hours calculation result are well known, and detailed description thereof will be omitted.

Also, if the payroll calculation software 5a is installed in the user terminal 2 together with the main software 55d, it is possible to complete the functions of the payroll calculation system of the present invention within the user terminal 2. FIG. Similarly, if the main software 55d is installed in the labor management server 5 along with the payroll calculation software 5a, the functions of the payroll calculation system of the present invention can be completed within the labor management server 5. FIG. In the latter case, the functions of the payroll accounting system of the present invention can be used by logging into the labor management server 5 from each user terminal 2 .

1 Payroll calculation system 2 User terminal (working hours calculation system)
3 distribution server 5 labor management server 5a salary calculation software 50B bus 51 CPU
52 RAMs
53 ROMs
54 Input/output unit 55 Mass storage device 55a Operating system (OS) software 55b Communication software 55c Internet browser 55d Main software 55d1 Data input module 55d2 Calendar creation module 55d3 Working hours calculation module 55d4 CSV file generation module 55e Original data 55e0 Chart data 55e1 Common item list data 55e2 Affiliation item list data 55e3 Employee master data 55e4 Submission calendar data 55e5 Leave application data 55e6 Early arrival/late arrival application data 55e7 Night duty application data 55e8 Attendance/leaving stamp data 55f Created calendar data 55g Working hours calculation summary data 56 Monitor 57 Input unit 58 Printer 59 USB memory loading unit 59m USB memory 60 Broadband router

Claims (19)

an arrival/departure time data acquisition unit that acquires arrival/departure time data recording the arrival/departure time of each worker on each date;
a working hours system input setting unit that selectively inputs and sets the working hours system to be set for each worker to either the general working hours system or the modified working hours system;
a daily scheduled working hours input unit for inputting the daily scheduled scheduled working hours to be set for each worker on the scheduled working day;
a total daily working hours calculation unit that calculates the total working hours of each of the workers on each of the dates as the total daily working hours based on the arrival and departure time data;
For each worker, the date attribute for each date is determined to be a holiday for the date when the calculated total daily working time is less than a predetermined value, and a predetermined value for the date when the total daily working time exceeds a predetermined value. A date attribute discriminating unit that discriminates a working day, and for a date whose date attribute is discriminated as a prescribed working day, the total working hours per day are determined according to the input scheduled prescribed working hours for the day and the type of working hour system. While comparing with at least one of the day-specific statutory working hours prepared accordingly, and determining the daily prescribed working hours to be allocated to the date based on the comparison result, for the date whose date attribute is determined to be a holiday a daily scheduled working hours determination unit that determines the daily scheduled working hours as zero, wherein for each of the workers, the date, the date attribute determined for the date, and the daily scheduled working hours are determined; a working hour calendar creation unit that creates a working hour calendar associated with each other;
a working hour calendar storage unit that stores the created working hour calendar;
Read the prescribed daily working hours of each worker on each of the dates on the working hours calendar, and compare the total working hours for the day, the scheduled prescribed working hours for the day, and the statutory working hours specific to the day for each of the dates. an overtime hours calculation unit that divides and calculates the daily overtime hours of each date into statutory overtime hours and non-statutory overtime hours;
an overtime hours totaling unit that calculates totaled overtime hours by totaling the daily overtime hours of each of the workers on each of the dates for a predetermined totaling target period;
an aggregated overtime hours storage unit that stores the aggregated overtime hours in association with the specific information of each worker;
an aggregated overtime hours output unit that outputs the aggregated overtime hours stored in the aggregated overtime hours storage unit;
A working hour calculation system comprising: The working hour calendar creation unit calculates, for each date of each worker, according to the value of the total daily working hours and the setting type of the working hour system, the day-specific statutory working hours, which is the statutory working hours specific to each date. a day-specific statutory working hours determination unit that determines working hours, and creates the working hours calendar by associating the date, the date attribute, the daily prescribed working hours with the day-specific statutory working hours,
2. The working hours according to claim 1, wherein the overtime hours calculating unit calculates the non-statutory overtime hours on each of the dates by referring to the working hours calendar, using the corresponding day-specific legal working hours. calculation system. The working hour calendar creation unit creates a daily working hour calendar in which the date, the date attribute determined for the date, and the calculation result of the daily prescribed working hours are associated with each other, and the daily working hour calendar. is divided into weeks, and a weekly working hours calendar in which week specific information is added to each divided week is created as the working hours calendar,
A total weekly working hours calculation unit is provided for calculating the total weekly working hours by totaling the total daily working hours for each week,
The overtime hours calculation unit calculates the weekly cumulative daily overtime hours that are the sum of the non-stipulated overtime hours of each day for each week, and compares the total weekly working hours with a predetermined weekly specific statutory working hours. If, as a result of the comparison, there are weekly overtime hours that exceed the aforementioned weekly statutory working hours, the weekly overtime hours are added to the above-mentioned weekly accumulated daily overtime hours to obtain the total weekly overtime hours. 3. The working hour calculation system according to claim 2, further comprising a weekly total non-statutory overtime hours calculation unit that calculates the total weekly overtime hours. The working hour calendar creating unit comprises a weekly statutory working hours determining unit that determines the statutory working hours peculiar to each week according to the setting type of the working hour system for each week, A weekly working hours calendar is created by associating the weekly specific information with the statutory working hours peculiar to the week,
4. The overtime hours calculating unit determines the weekly overtime hours as a difference between the total weekly working hours and the peculiar weekly statutory working hours by referring to the weekly working hours calendar. working hours calculation system. When the general working hours system is input and set as the working hours system,
The predetermined daily working hours determining unit sets the predetermined daily working hours to be equal to the total daily working hours for dates on which the total daily working hours are less than 8 hours, and sets the predetermined daily working hours to be equal to the total daily working hours for dates on which the total daily working hours exceed 8 hours. Regarding, the prescribed daily working hours are set to 8 hours,
The day-specific statutory working hours determination unit uniformly determines the day-specific statutory working hours for each date as 8 hours,
5. The working hours calculation system according to claim 4, wherein the weekly specific legal working hours determining unit uniformly determines the weekly specific legal working hours for each week as 40 hours. The working hours system input setting unit can input and set a weekly modified working hours system as the modified working hours system, and when the modified weekly working hours system is input and set,
The predetermined daily working hours determination unit sets the predetermined daily working hours on each of the dates to be equal to the total daily working hours regardless of the value of the total daily working hours,
6. The working hours calculation system according to claim 4, wherein the weekly specific legal working hours determining unit uniformly determines the weekly specific legal working hours for each week as 40 hours. In the case where the weekly variable working hours system is input and set, the day-specific statutory working hours determination unit determines the day-specific statutory working hours on dates where the total daily working hours exceed 8 hours. 7. The working hours calculation system according to claim 6, wherein the working hours are determined to be equal to the working hours, and on dates when the total working hours per day are less than 8 hours, the day-specific statutory working hours are determined to be 8 hours. The working hours system input setting unit is capable of inputting and setting a monthly modified working hours system as the modified working hours system,
The working hour calendar creation unit divides the daily working hour calendar into months and, for each divided month, according to the number of days in each month, when the monthly variable working hour system is input and set. a month-specific statutory working hours determination unit that determines the monthly statutory working hours that are the statutory working hours unique to each month;
The predetermined daily working hours determination unit sets the predetermined daily working hours on each of the dates to be equal to the total daily working hours regardless of the value of the total daily working hours,
The weekly statutory working hours determination unit shall not set a limit on the statutory weekly working hours for each week,
The overtime calculation unit calculates the total monthly working hours, which is the sum of the total working hours for each month, and compares the total working hours for the month with the legal working hours specific to the month. Any one of claims 4 to 7, comprising a monthly total non-statutory overtime hours calculation unit that calculates the monthly total non-statutory overtime hours as the monthly total non-statutory overtime hours when monthly overtime working hours that exceed inherent legal working hours occur. or the working hour calculation system according to item 1. On dates where said total daily working hours exceed 8 hours, said day-specific statutory working hours shall be determined to be equal to said total daily working hours, and on dates where said total daily working hours are less than 8 hours, said day 9. The working hours calculation system according to claim 8, wherein the inherent legal working hours are determined to be eight hours. The working hour system input setting unit is capable of inputting and setting a yearly variable working hours system as the variable working hours system, and when the yearly variable working hours system is input and set,
The predetermined daily working hours determination unit determines the predetermined daily working hours to be equal to the total daily working hours on dates when the total daily working hours are less than 10 hours. For dates that exceed the hours, the prescribed daily working hours are determined as 10 hours,
10. A method according to any one of claims 4 to 9, wherein said weekly specific statutory working hours determination unit determines said weekly peculiar legal working hours to be 52 hours for a week in which the total of said daily prescribed working hours exceeds 52 hours. Working hours calculation system as described in paragraph. The day-specific statutory working hours determination unit determines the day-specific statutory working hours as 10 hours on dates when the total daily working hours exceed 10 hours, On dates when the total working hours are less than 8 hours, the statutory working hours peculiar to the day shall be equal to the total working hours per day, and on dates when the total working hours per day are less than 8 hours, the statutory working hours peculiar to the day shall be 8 hours. is determined as
The weekly specific statutory working hours determining unit determines the peculiar weekly statutory working hours to be equal to the total weekly working hours for a week in which the total prescribed daily working hours exceeds 40 hours and is less than 52 hours, 11. The working hours calculation system according to claim 10, wherein for a week in which the total prescribed daily working hours is less than 40 hours, the week-specific statutory working hours are determined to be 40 hours. a statutory holiday setting condition input unit for inputting the statutory holiday setting condition for each worker;
The date attribute determination unit of the working hour calendar generation unit determines whether the date determined as a holiday is a legal holiday based on the input legal holiday setting condition and the appearance form of the date determined as a holiday in the date attribute. Equipped with a legal holiday discrimination unit that discriminates whether or not
12. The working hours calculation according to any one of claims 1 to 11, wherein the overtime hours totaling unit separately totals the total daily working hours for the dates determined as the legal holidays as holiday working hours. system. The statutory holiday setting condition input unit is a statutory holiday system input setting unit for selectively inputting and setting the statutory holiday system to either a fixed day of the week, an unspecified day of the week 1 day a week, or an unspecified day of the week 4 weeks 4 days. and a legal holiday Sunday input setting unit for inputting and setting a legal holiday Sunday to be fixed when the legal holiday system is fixed on the day of the week,
When the selected legal holiday system is a fixed day of the week, the legal holiday determination unit determines a holiday that matches the selected legal holiday Sunday as the legal holiday, and determines the selected legal holiday. If the holiday system is one day per week with unspecified days of the week, up to one of the holidays in each week is determined as the legal holiday, and if the selected legal holiday system is four days per week with no fixed days of the week 13. The working hours calculation system according to claim 12, wherein each week is divided into four weeks, and up to four of the holidays appearing in each of the divided four weeks are determined as the legal holidays. A paid vacation date input unit is provided for entering the paid vacation date notified for each worker,
The date attribute discriminating unit of the working hour calendar creation unit discriminates the date attribute of the input paid vacation date as paid vacation,
14. The working hours calculation according to any one of claims 1 to 13, wherein the overtime hours totaling unit separately totals the total daily working hours for the dates determined as the paid holidays as paid vacation hours. system. 15. The working hours calculation system according to claim 14, wherein the paid vacation date input section allows selective input of only one of morning only, afternoon only, and all morning and afternoon as the form of acquisition of the paid vacation time. a substitute holiday information input unit for inputting substitute holiday information notified for each worker;
2. The working hour calendar creation unit has a date attribute transfer unit that transfers the date attribute of a target date between a predetermined working day and a holiday based on the content of the input substitute holiday information. The working time calculation system according to any one of claims 1 to 15. 17. The working hour calculation system according to any one of claims 1 to 16, wherein the information on the aggregated overtime hours output by the working hour calculation system includes a wage for overtime work per predetermined hour A salary calculation system characterized by including calculating overtime pay by multiplying a unit price . 17. A computer program that causes a computer to function as each function implementation part of the working time calculation system according to any one of claims 1 to 16. A computer program that causes a computer to function as each function implementation unit of the payroll accounting system according to claim 17.

Images