JP7452002B2 - Attendance management system, attendance management method, and attendance management program - Google Patents

Description

The present invention relates to an attendance management system, an attendance management method, and an attendance management program for managing attendance such as overtime working hours.

Overtime working hours are managed in order to comply with the so-called 36 Agreement stipulated in Article 36 of the Labor Standards Act. Therefore, a system for notifying related parties of attendance information such as attendance records and attendance predictions is being considered (see, for example, Patent Document 1). The system described in this document includes a business database that stores business data related to attendance and attendance, and a management master database that stores execution timing of notice occurrence processing, notice occurrence conditions, notification destination, and other notice information. Furthermore, this system includes an input means for inputting noticed information, a display means for displaying noticed information, and a control means for controlling each part of the device. Then, when it is determined that the notification generation condition is met using the business data and the management master, the notification data is created and distributed or displayed according to the notification notification destination and the notification notification method.

JP2011-65486A

However, since the difference between overtime working hours and the upper limit time changes depending on the daily overtime hours, it is difficult to accurately grasp the difference. In particular, when there are multiple people to be managed with different work situations and maximum working hours, it is difficult to grasp the status of overtime and remaining capacity from a list.

The attendance management system that solves the above problems consists of a contract storage unit that stores information regarding the upper limit of overtime hours for employees, a labor record storage unit that stores actual working hours for each employee, and a control unit that is connected to a display unit. The control unit specifies the permissible overtime hours of the target employee using the upper limit time recorded in the contract storage unit, and specifies the permissible overtime hours of the target employee, and Calculate the difference between the overtime working hours of the target employee obtained from the work record storage unit, and if the overtime working hours are less than the allowable time, calculate the difference time with respect to the allowable time. displaying a bar graph in the form of subtracting the overtime hours on the display section, and when the overtime working hours exceed the allowable time, the difference time is accumulated with respect to the allowable time. A bar graph indicated by is displayed on the display section.

According to the present invention, attendance status can be efficiently grasped.

FIG. 1 is an explanatory diagram illustrating the configuration of an attendance management system in an embodiment. FIG. 2 is an explanatory diagram illustrating the hardware configuration of the embodiment. It is an explanatory diagram explaining the data structure in each storage part of an embodiment, and (a) is an office information storage part, (b) is an employee information storage part, (c) is a dispatch agency information storage part, and (d) is an explanatory diagram explaining the data structure in each storage part. is the labor performance memory section. 5 is a flowchart illustrating a processing procedure for overtime warning processing in the embodiment. 2 is a flowchart illustrating a processing procedure for calculating overtime hours for the current month in the embodiment. 5 is a flowchart illustrating a processing procedure for specifying the current month's allowable time in the embodiment. 5 is a flowchart illustrating the processing procedure of overtime confirmation processing in the embodiment. FIG. 3 is an explanatory diagram of screens displayed in the overtime confirmation process in the embodiment, in which (a) is a top screen, (b) is an office information display screen, and (c) is an overtime time display screen. 12 is a flowchart illustrating the processing procedure of overtime confirmation processing in a modified example. 12 is a flowchart illustrating a processing procedure for specifying the current month's allowable time in a modified example. FIG. 6 is an explanatory diagram of the overtime time display screen in a modified example, where (a) is a screen including a bar graph in which warning time is displayed, and (b) is a screen where the current month's allowable time is shorter than the monthly upper limit time due to past overtime work results. A screen containing a graph.

An embodiment of an attendance management system, an attendance management method, and an attendance management program will be described below with reference to FIGS. 1 to 8. In this embodiment, an attendance management system for managing overtime hours of employees will be described. Here, overtime hours mean overtime working hours other than statutory working hours and overtime working hours other than prescribed working hours determined by an employment contract.

As shown in FIG. 1, in this embodiment, a plurality of user terminals 15 are connected to an attendance management server 20 via an in-house network. Each user terminal 15 is a terminal used by a staff member. The attendance management server 20 manages the attendance status of employees.

(Hardware configuration)
The hardware configuration of the information processing device H10 that constitutes the user terminal 15 and the attendance management server 20 will be explained using FIG. 2. The information processing device H10 includes a communication device H11, an input device H12, a display device H13, a storage unit H14, and a processor H15. Note that this hardware configuration is just an example, and it can also be implemented using other hardware.

The communication device H11 is an interface that establishes a communication path with other devices and executes data transmission and reception, and is, for example, a network interface card, a wireless interface, or the like.

The input device H12 is a device that receives input from staff members, and is, for example, a mouse, a keyboard, or the like.
The display device H13 is a display or the like that displays various information.
The storage unit H14 is a storage device that stores data and various programs for executing various functions of the user terminal 15 and the attendance management server 20. Examples of the storage unit H14 include ROM, RAM, hard disk, and the like.

The processor H15 controls each process in the user terminal 15 and the attendance management server 20 using programs and data stored in the storage unit H14. Examples of the processor H15 include a CPU, an MPU, and the like. This processor H15 expands programs stored in a ROM or the like into a RAM and executes various processes in the user terminal 15 and the attendance management server 20.

The processor H15 is not limited to performing software processing for all processes that it executes. For example, the processor H15 may include a dedicated hardware circuit (for example, an application-specific integrated circuit: ASIC) that performs hardware processing for at least part of the processing that it executes. That is, the processor H15 includes (1) one or more processors that operate according to a computer program (software), (2) one or more dedicated hardware circuits that execute at least some of various processes, or ( 3) It can be configured as a circuit including a combination thereof. A processor includes a CPU and memory, such as RAM and ROM, where the memory stores program codes or instructions configured to cause the CPU to perform processing. Memory or computer-readable media includes any available media that can be accessed by a general purpose or special purpose computer.

(Functions of attendance management server 20)
Next, the functions of the attendance management server 20 will be explained using FIGS. 1 and 3. In this embodiment, attendance management is performed for each construction office that manages a construction site.

The attendance management server 20 shown in FIG. 1 is a computer system that manages working hours, including overtime hours, of employees. The attendance management server 20 includes a control section 21 , an office information storage section 22 , an employee information storage section 23 , a dispatch agency information storage section 24 , and a labor record storage section 25 . In this embodiment, the office information storage section 22 and the dispatch agency information storage section 24 correspond to the contract storage section.

The control unit 21 includes a control means (CPU, RAM, ROM, etc.), and performs the processes described below (work time recording stage, notification stage, overtime time calculation stage, allowable time identification stage, overtime display stage, etc.). . For this purpose, by executing the attendance management program stored in the memory (storage unit H14), the control unit 21 controls the working time recording unit 211, the notification unit 212, the overtime time calculation unit 213, the allowable time identification unit 214, and the overtime management program. It functions as a display section 215.

The working hours recording unit 211 executes a process of recording each employee's working hours in the labor record storage unit 25.
The notification unit 212 performs a process of notifying the employee's user terminal 15 when the current month's overtime hours are close to the overtime hours allowed for that month (current month allowable time). For this reason, the notification unit 212 stores a notification reference time used for determining whether to notify. For example, 10 hours is stored as this notification reference time. Then, the notification unit 212 issues a notification when the remaining time of the current month's allowable time (remaining allowable time) becomes less than the notification reference time.

The overtime work time calculation unit 213 executes processing to calculate the overtime work time of the employee for the current month. For this reason, the overtime calculation unit 213 stores the predetermined working hours and break times, which are working hours within regular working hours. Scheduled working hours are hours that are less than legal working hours and are determined by the employment contract. In this embodiment, the prescribed working hours are recorded as 8 hours, which is the same as the legal working hours. The break time is recorded according to the employee's working hours and time zone conditions.

The allowable time specifying unit 214 executes a process of specifying the allowable time of the employee for the current month.
The overtime display unit 215 executes a process of displaying overtime hours of employees. If the overtime hours are less than the current month's allowable time, the overtime display section 215 displays a bar graph that shows the current month's allowable hours as a whole and shows the overtime hours and the grace period during which overtime is still available. Furthermore, if overtime hours exceed the allowable time for the current month, the overtime display section 215 calculates the overtime by subtracting the allowable time for the month from the overtime hours, and displays a bar graph stacking the overtime on top of the allowable time for the current month. Display.

As shown in FIG. 3(a), the office information storage unit 22 stores office information 220 regarding the construction office where the employee works. Office information 220 is recorded when a construction office is registered. The office information 220 includes information regarding an office identifier, office jurisdiction, office address, director's name, telephone number, facsimile number, and labor contract.

The office identifier data area records data regarding an identifier for identifying each construction office.
The office jurisdiction data area records data regarding the branch that has jurisdiction over this construction office. Here, bases in Sapporo, Tohoku, Tokyo, etc. are recorded as branches under jurisdiction.

The office address data area records data regarding the address of this construction office.
Data regarding the director's name, telephone number, and facsimile number of this construction office are recorded in the director's name data area, telephone number data area, and facsimile number data area, respectively.

The labor contract data area records data regarding labor contracts with employees of the construction office, excluding temporary employees. This labor contract data includes data on 36 agreements and special clauses.

In the 36 agreement data area, data regarding upper limit hours (monthly upper limit hours and half-year upper limit hours) for normal overtime work in one month and six months is recorded.
The special clause data area records data regarding special clauses, which are temporary conditions that temporarily extend the upper limit of overtime hours during busy seasons. This special clause data area records data regarding the upper limit of overtime hours (monthly upper limit and half-year upper limit) for one month and six months. Note that if no special clauses are specified, this special clause data area will be left blank.

As shown in FIG. 3(b), the staff information storage unit 23 stores staff information 230 regarding staff members belonging to each construction office. This employee information 230 is input and recorded when an employee is assigned to a new construction office. The staff information 230 includes information regarding staff identifiers, staff names, office identifiers, staff attributes, and email addresses.

The employee identifier data area records data regarding an identifier for identifying each employee.
The employee name data area records data regarding the employee's name.
The affiliated office identifier data area records data regarding an identifier for specifying the construction office to which this employee belongs.

The employee attribute data area records data regarding the attributes of this employee. As attributes, the employee's position, the employee's job type, and if the employee is dispatched, the dispatch source identifier that identifies the dispatch source, etc. are used.
The e-mail address data area records data regarding the e-mail address of this employee. By using this email address, it is possible to notify the staff.

As shown in FIG. 3(c), the dispatch agency information storage unit 24 records dispatch agency information 240 regarding the dispatch agency to which the dispatched employee is dispatched. This dispatch agency information 240 is recorded when a dispatched employee is registered. The dispatch agency information 240 includes information regarding a dispatch agency identifier, dispatch agency name, dispatch agency contact information, and dispatch agency labor contract information.

The dispatch source identifier data area records data regarding an identifier for specifying each dispatch source.
The dispatch source name data area and the dispatch source contact information data area record data regarding the name and contact information of the dispatch source. For contact information, use the dispatcher's address, telephone number, facsimile number, etc.

The dispatch agency labor contract information data area records data regarding the labor contract of the staff of this dispatch agency. This labor contract includes data regarding the upper limit of overtime hours for one month and six months (monthly upper limit and half-year upper limit) regarding the 36 Agreement.

As shown in FIG. 3(d), the work performance storage unit 25 records work performance information 250 regarding the working hours actually worked by each staff member. This work performance information 250 is recorded when information regarding the employee's working hours is acquired. The work performance information 250 includes information regarding employee identifiers, work dates, work start times, and work end times.

In the employee identifier data area, data related to an identifier for identifying the employee who worked is recorded.
In the work date data area, the work start time data area, and the work end time data area, data regarding the year, month, and day when the employee actually worked, the work start time, and the work end time on that day are recorded.

<Attendance management processing>
Next, the attendance management process executed using the above-mentioned attendance management server 20 will be explained. Here, the attendance management process includes a work time registration process, an overtime work time warning process, and an overtime work confirmation process.

(Working hours registration process)
First, the working hours registration process will be explained. This process is executed when the daily working hours of the staff members are acquired. A staff member inputs work time information (work date, work start time, and work end time) using the user terminal 15. The attendance management server 20 then obtains the user's staff identifier, work start time, and work end time from the user terminal 15. Note that the attendance management server 20 may use a time recorder to obtain the work start time and work end time of each employee.

Then, the control unit 21 of the attendance management server 20 executes a work time recording process. Specifically, the working hours recording unit 211 of the control unit 21 generates work performance information 250 including the received working hours information and staff identifier, and records it in the working performance storage unit 25.

(Overtime warning processing)
Next, overtime warning processing will be described using FIG. 4. This process is executed, for example, at a predetermined time.

In this process, first, the control unit 21 of the attendance management server 20 executes a process for calculating overtime hours for the current month (step S1-1). Details of this processing will be described later.
Next, the control unit 21 of the attendance management server 20 executes a process for specifying the allowable time for the current month (step S1-2). Details of this processing will be described later.

Then, the control unit 21 of the attendance management server 20 executes a process of calculating the remaining allowable time (step S1-3). Specifically, the notification unit 212 of the control unit 21 calculates the remaining allowable time by subtracting the overtime hours from the specified allowable time for the current month. Note that if the overtime hours exceed the allowable hours for the current month, the overtime hours warning process is terminated.

Then, the control unit 21 of the attendance management server 20 executes a process of determining whether the calculated remaining allowable time is less than the notification reference time (step S1-4). Specifically, the notification unit 212 of the control unit 21 compares the remaining allowable time and the notification reference time.

Here, if the remaining allowable time is less than the notification reference time ("YES" in step S1-4), the control unit 21 of the attendance management server 20 executes the notification process (step S1-5). . Specifically, the notification unit 212 of the control unit 21 extracts the employee information 230 including the employee identifier of this employee from the employee information storage unit 23, and sends the email address of this employee information 230 the remaining allowable time for the current month. Send an email with a message saying you're short on time.
On the other hand, if the calculated remaining allowable time is equal to or greater than the notification reference time ("NO" in step S1-4), the notification unit 212 of the control unit 21 ends the overtime warning process.

(Calculation process for overtime hours)
Next, using FIG. 5, details of the calculation process for overtime hours for the current month (step S1-2) will be explained.
The control unit 21 of the attendance management server 20 repeatedly executes the following process for each working day in the calculation period (current month).

First, the control unit 21 of the attendance management server 20 executes work time acquisition processing (step S2-1). Specifically, the overtime time calculation unit 213 of the control unit 21 calculates the employee to be processed, the work start time and work end time of each work day in the calculation period, in the work performance information 250 recorded in the work performance storage unit 25. get.

Next, the control unit 21 of the attendance management server 20 executes a calculation process of actual overtime hours (step S2-2). Specifically, the overtime calculation unit 213 of the control unit 21 calculates the break time according to the acquired working hours from the work start time to the work end time. Then, the overtime work time calculation unit 213 subtracts the break time from the time from the work start time to the work end time to calculate the actual work time. Next, the overtime calculation unit 213 subtracts the stored predetermined working hours (statutory working hours) from the actual working hours to calculate actual overtime hours.
The above process is repeatedly executed for each working day in the calculation period.

Next, the control unit 21 of the attendance management server 20 executes overtime calculation processing (step S2-3). Specifically, the overtime work time calculation unit 213 of the control unit 21 calculates the overtime work time in the calculation period by summing up the actual overtime work hours on the calculated working days, and stores it in the memory in association with the employee identifier.

(Specifying processing of allowable time for the current month)
Next, the details of the process for specifying the allowable time for the current month described above will be explained using FIG. 6.
Here, the control unit 21 of the attendance management server 20 executes a process of determining whether or not the employee to be processed is a temporary employee (step S3-1). Specifically, the allowable time specifying unit 214 of the control unit 21 determines whether the dispatch source identifier is recorded in the employee attribute information of the employee information 230 that includes the employee identifier of the employee to be processed.

Here, if the dispatch source identifier is recorded in the employee attribute ("YES" in step S3-1), the control unit 21 of the attendance management server 20 executes the process of acquiring the monthly maximum hours of the dispatch source. (Step S3-2). Specifically, the allowable time specifying unit 214 of the control unit 21 acquires the dispatcher labor contract information of the dispatcher information 240 including the recorded dispatcher identifier from the dispatcher information storage unit 24. Then, the monthly upper limit hours in the 36 Agreement included in this dispatch agency labor contract information are obtained.

On the other hand, if the dispatch source identifier is not recorded in the employee attribute (“NO” in step S3-1), the control unit 21 of the attendance management server 20 executes a process of determining whether there is a special clause. (Step S3-3). Specifically, the allowable time specifying unit 214 of the control unit 21 specifies the office information 220 that includes the office identifier of the employee information 230 of the employee to be processed, and uses the labor contract information of this office information 220 as the office information. The location information is acquired from the location information storage unit 22. Then, the allowable time specifying unit 214 determines whether a special clause is recorded in the labor contract information.

Here, if the special clause is not recorded ("NO" in step S3-3), the control unit 21 of the attendance management server 20 executes the process of acquiring the monthly upper limit time under the 36 Agreement (step S3-3). 4). Specifically, the allowable time specifying unit 214 of the control unit 21 obtains the monthly upper limit time recorded in the 36 agreement data area of the labor contract information of the office information 220 from the office information storage unit 22.

On the other hand, if the special clause is recorded (“YES” in step S3-3), the control unit 21 of the attendance management server 20 executes the process of acquiring the monthly maximum hours in the special clause of the labor contract information ( Step S3-5). Specifically, the allowable time specifying unit 214 of the control unit 21 obtains the monthly upper limit time recorded in the special information data area of the labor contract information of the office information 220 from the office information storage unit 22.

(Overtime confirmation process)
Next, the overtime work confirmation process will be explained using FIGS. 7 and 8. This process is executed, for example, when a manager who manages a construction office, such as the director of the office, wants to know the overtime hours of the employees he or she supervises.

First, as shown in FIG. 7, the control unit 21 of the attendance management server 20 executes a process for identifying employees who belong to the office to be displayed (step S4-1). Specifically, an overtime confirmation instruction is input at the user terminal 15. In this case, the overtime display section 215 of the control section 21 displays the top screen on the display device H13 of the user terminal 15.

As shown in FIG. 8(a), the top screen 500 displays the location of the office on a map. The overtime display unit 215 obtains this map from a map site (not shown) and displays office icons according to the address of the office information 220. On the top screen 500, on the right side of the office location map, the respective jurisdictional areas (Sapporo, Tohoku, Tokyo, etc.) to which each construction office belongs are displayed side by side. Then, by selecting the title of the jurisdiction area of the office you wish to view, a list of construction offices under the jurisdiction of this jurisdiction area will be displayed as a pull-down menu. In this case, a map of the selected jurisdiction is obtained from a map site. On this map, office icons for each office included in this jurisdiction are arranged according to address. Then, from among the listed construction offices, select the construction office to which the employee whose overtime work status you wish to view belongs.

In this case, as shown in FIG. 8(b), the control unit 21 of the attendance management server 20 displays an office information screen 510 regarding the selected construction office on the display device H13 of the user terminal 15. This office information screen 510 includes basic organizational information and map information. The basic organizational status includes the office identifier, office address, director's name, telephone number, and facsimile number of the office information 220. In this case, a map of the surrounding area of the office obtained from a map site according to the address is displayed as the map information.

Then, when the administrator selects the overtime management button among the management items on the office information screen 510, the control unit 21 of the attendance management server 20 extracts the staff information 230 in which the office identifier of this construction office is recorded. do.

Next, as shown in FIG. 7, the control unit 21 of the attendance management server 20 repeatedly executes the following process for each specified display target person.
Here, similarly to steps S1-1 and S1-2, the control unit 21 of the attendance management server 20 performs processing for calculating overtime hours for the current month (step S4-2) and processing for specifying allowable time for the current month (step S4-3). ).

Next, the control unit 21 of the attendance management server 20 executes a process of determining whether the allowable time for the current month has been exceeded (step S4-4). Specifically, the overtime display unit 215 of the control unit 21 compares the current month's allowable time and the current month's overtime time, and calculates the difference time between the two. Then, if the current month's overtime hours are longer than the current month's allowable time, the overtime display unit 215 determines that the current month's allowable time has been exceeded.

Here, if it is determined that the allowable time for the current month has not been exceeded ("NO" in step S4-4), the control unit 21 of the attendance management server 20 executes the remaining time display process (step S4-5). ). Specifically, the overtime display section 215 of the control section 21 generates a band graph showing overtime hours with respect to the current month's allowable hours. In this bar graph, above the overtime hours displayed in green, the total monthly allowable time is displayed in the form of subtracting the gray difference time from the current month's allowable time.

On the other hand, if it is determined that the allowable time for the current month has been exceeded ("YES" in step S4-4), the control unit 21 of the attendance management server 20 executes an overtime display process (step S4-6). Specifically, the overtime display unit 215 of the control unit 21 generates a bar graph in a form in which the difference time (excess time) is piled up above the current month's allowable time. In this bar graph, the allowable time for the current month is displayed in green, and the excess time is displayed in red.
The above process is repeated for each display target person.

Then, the control unit 21 of the attendance management server 20 executes a process of displaying a list of overtime statuses (step S4-7). Specifically, the overtime display section 215 of the control section 21 displays an overtime display screen based on the overtime display screen data on the display device H13 of the user terminal 15. This overtime display screen data includes an overtime status list display in which bar graphs or band graphs generated corresponding to each staff member are arranged horizontally, and information on each staff member to be displayed.

As shown in FIG. 8C, the overtime display screen 520 includes the generated band graphs or bar graphs of each person to be displayed, along with the name of each person to be displayed. Furthermore, the overtime display screen 520 includes the employee identifier, name, attribute, allowable hours of the current month, overtime hours of the current month, and remaining allowable time of the current month of the person to be displayed.

In this overtime display screen 520, the allowable time for this month for all employees is shown as 60 hours. Range A1 displays a band graph G1 of employees whose overtime hours do not exceed the allowable hours for the current month. Since the overtime hours are less than the current month's allowable hours, the band graph G1 showing the current month's allowable hours includes the current month's overtime hours G1a in green and the difference time G1r in gray.

Furthermore, in the range A2, a bar graph G2 of employees whose overtime hours exceed the allowable hours for the current month is displayed. The entire bar graph G2 indicates the overtime hours of this employee for the current month. In the bar graph G2, the current month's allowable time G2a at the bottom is displayed in green, and the excess time G2e above the current month's allowable time G2a is displayed in red.

(effect)
On the overtime display screen 520, for employees whose overtime hours are less than the current month's allowable hours, a bar graph G1 showing the current month's allowable hours is displayed. Furthermore, for employees who have exceeded the allowable time for the current month, a bar graph G2 is displayed in which the excess time G2e is piled up on the allowable time for the month G2a. This makes it possible to display the excess time and remaining capacity for each employee over the current month's allowable time.

According to this embodiment, the following effects can be obtained.
(1) In the present embodiment, the control unit 21 of the attendance management server 20 executes the remaining time display process (step S4) if the allowable time for the current month has not been exceeded (“NO” in step S4-4). -5). If the allowable time for the current month has been exceeded (“YES” in step S4-4), the control unit 21 executes an excess time display process (step S4-6). As a result, it is possible to accurately grasp whether or not the allowable time for the current month has been exceeded, the remaining allowable time, and the exceeded time.

(2) In the present embodiment, if there is a special clause (“YES” in step S3-3), the control unit 21 of the attendance management server 20 executes a process to obtain the monthly upper limit of the special clause. (Step S3-5). This makes it possible to calculate the current month's allowable time by taking special provisions into account.

(3) In the present embodiment, if the employee is a temporary employee, the control unit 21 of the attendance management server 20 executes a process for acquiring the monthly upper limit of the dispatch agency (step S3-2). As a result, the work status of dispatched staff can be managed in consideration of the dispatch source.

(4) In this embodiment, if the remaining allowable time becomes less than the notification reference time ("YES" in step S1-4), the control unit 21 of the attendance management server 20 executes the notification process (step S1-5). This makes it possible to alert employees who are nearing the end of their permissible hours for the month.

(5) In the present embodiment, the control unit 21 of the attendance management server 20 executes a process for identifying employees belonging to the office to be displayed (step S4-1), and executes a process for displaying a list of overtime status (step S4-1). S4-7). This makes it possible to understand the working situation by taking into account the special provisions set for each construction office.

This embodiment can be modified and implemented as follows. This embodiment and the following modified examples can be implemented in combination with each other within a technically consistent range.
- In the above embodiment, the control unit 21 of the attendance management server 20 grasps the overtime work status based on the current month's overtime hours and the monthly upper limit time. In the 36 Agreement and special provisions, not only the monthly maximum hours but also the maximum overtime hours over a six-month period (semi-annual maximum hours) are set. Therefore, the overtime status may be displayed taking into account the half-year upper limit. In this case, the control unit 21 stores the calculation start month of the current term, which is within the half-year upper limit time in the 36 Agreement or the special clause.

In this case, the overtime confirmation process shown in FIG. 9 is executed.
In this overtime confirmation process, the control unit 21 of the attendance management server 20 executes a process for specifying employees belonging to the office to be displayed (step S5-1), similarly to step S4-1.

Then, the control unit 21 of the attendance management server 20 repeatedly executes the following process for each display target person.
Here, the control unit 21 of the attendance management server 20 executes a process of calculating overtime hours for the current month and current period (step S5-2). In this process, the control unit 21 executes the process of calculating overtime hours for the current month as shown in FIG. Furthermore, the control unit 21 performs a process of acquiring working hours and a process of calculating overtime actual hours (step S2-1 and S2-2) are executed to calculate the current term's overtime hours by summing up the current term's actual overtime hours, and store it in the memory in association with the employee identifier.

Then, the control unit 21 of the attendance management server 20 executes the process of specifying the allowable time for the current month (step 5-3). Details of this processing will be described later.
Next, as in steps S4-4 to S4-6, the control unit 21 of the attendance management server 20 performs a process of determining whether or not the allowable time for the current month has been exceeded (step S5-4), a process of displaying remaining time (step S5-5), and an excess time display process (step S5-6) is executed.

After executing the remaining time display process (step S5-5), the control unit 21 of the attendance management server 20 executes a process for determining whether the average allowable time has been exceeded (step S5-7). Specifically, the overtime display unit 215 of the control unit 21 calculates the average allowable time by dividing the half-year upper limit time of the person to be displayed by the number of months in the current term “6”. The overtime display section 215 then compares the overtime hours for the current month with the average allowable time.

Here, if the current month's overtime hours exceed the average permissible time ("YES" in step S5-7), the control unit 21 of the attendance management server 20 executes a warning time display process (step S5-8). ). Specifically, the overtime display section 215 of the control section 21 calculates the warning time by subtracting the average allowable time from the overtime hours of the current month. The overtime display section 215 generates a bar graph in which the warning time is displayed in orange above the overtime hours.
Note that if the current month's overtime hours are less than or equal to the average allowable time ("NO" in step S5-7), the warning time display process (step S5-8) is skipped.

After repeating the above process for each person to be displayed, a process for displaying a list of overtime statuses is executed in the same manner as step S4-7 (step S5-9).
As a result, as shown in FIG. 11(a), a bar graph G11 is displayed corresponding to the employee who has executed the warning time display process (step S5-8). This bar graph G11 includes the current month's overtime hours G1a shown at the bottom and the difference time G1r shown at the top. Of the overtime hours G1a, the warning time G1b that exceeds the average allowable time is displayed in orange, and the remaining overtime hours G1n are displayed in green. This makes it possible to understand the current month's overtime work status, taking into account the half-year upper limit.

(Calculation process of allowable time for the current month)
Next, with reference to FIG. 10, the process for calculating the current month's allowable time (step S5-3) will be explained.

First, the control unit 21 of the attendance management server 20 performs a process of determining whether or not the employee is a dispatched employee (step S6-1), and a process of acquiring the monthly upper limit of the dispatch agency, as in steps S3-1 and S3-2. (Step S6-2) is executed. Further, the control unit 21 of the attendance management server 20 performs a process of determining whether or not there is a special clause (step S6-3) and a process of obtaining the monthly upper limit of the 36 agreement, similarly to steps S3-3 to S3-5. (Step S6-4) and processing for acquiring the monthly upper limit time of the special clause (Step S6-5) are executed.

Next, the control unit 21 of the attendance management server 20 executes a process of calculating overtime hours for the current term (step S6-6). Specifically, as in step S5-2, the overtime calculation unit 213 of the control unit 21 calculates the actual overtime hours for each working day included in the current term, adds them up, and calculates the overtime hours for the current term. calculate.

Then, the control unit 21 of the attendance management server 20 executes a process of calculating the remaining allowable time for the current period (step S6-7). Specifically, the remaining allowable time for the current term is calculated by subtracting the overtime hours for the current term from the half-year upper limit.

Next, the control unit 21 of the attendance management server 20 executes a process of determining whether the remaining allowable time for the current term is less than the monthly upper limit time (step S6-8). Specifically, the overtime calculation unit 213 of the control unit 21 compares the remaining allowable time for the current period with the monthly upper limit.

Here, if the remaining allowable time for this term is equal to or greater than the monthly upper limit time ("NO" in step S6-8), the control unit 21 of the attendance management server 20 executes a process to specify the monthly upper limit time (step S6-8). S6-9). Specifically, the overtime calculation unit 213 of the control unit 21 uses the monthly upper limit time as the current month's allowable time.

On the other hand, if the remaining allowable time for this term is less than the monthly upper limit time ("YES" in step S6-8), the control unit 21 of the attendance management server 20 executes a process to specify the remaining allowable time for this term ( Step S6-10). Specifically, the overtime calculation unit 213 of the control unit 21 uses the remaining allowable time of the current term as the allowable time of the current month.

For example, if the current month is the last month (sixth month) of the current term and there have been many overtime hours in the past five months, the remaining allowable time for the current term may be shorter than the monthly upper limit. In this case, as shown in the band graph G12 and bar graph G22 shown in FIG. 11(b), the current month's allowable time that is shorter than the monthly upper limit time (for example, 50 hours) is displayed.

For example, in the fifth bar graph G12 from the left, the allowable hours for the current month for other employees only extend to 30 hours, which is shorter than the monthly upper limit of 50 hours. The lower part and the upper part of this band graph G12 are the overtime hours G1a and the difference time G1r of this employee.

Furthermore, the seventh bar graph G12 from the left extends only up to 20 hours, indicating that the employee corresponding to this bar graph G12 has only 20 hours of permissible time this month. Furthermore, the eighth bar graph G22 from the left is a graph in which the excess time G2e is stacked against the current month's allowable time G2a, which is the same as the seventh bar graph from the left.
As a result of the above, it is possible to accurately and quickly grasp the overtime status of employees, taking into account the half-year upper limit.

- In the above embodiment, each element such as allowable overtime hours, overtime hours, overtime hours, etc. is displayed in different colors (green, red, gray) in the band graph G1 and the bar graph G2. In bar graphs and band graphs, the display format is not limited to changing colors as long as each element can be identified. For example, other colors may be used, or distinction may be made by shading, hatching, etc.

- In the above embodiment, overtime hours excluding legal working hours (prescribed working hours) are managed. Management of overtime hours is not limited to managing scheduled working hours of 8 hours, which is the same as legal working hours; for example, overtime working hours other than scheduled working hours, which are shorter than legal working hours, and allowable working hours according to internal regulations. It is also possible to manage overtime hours relative to allowable hours using time. In this case, the overtime calculation unit 213 stores the prescribed working hours separately from the legal working hours. Furthermore, instead of the monthly upper limit of the 36 Agreement or special provisions, or the monthly upper limit of the 36 Agreement of the dispatching agency, the permissible time according to the company regulations is stored. Furthermore, the overtime status of overtime hours according to legal working hours and the overtime status of overtime hours according to internal standard hours may be switched and displayed according to the administrator's designation.
- In the above embodiment, overtime work status for one month is managed, but the period for managing overtime hours is not limited to one month. For example, overtime hours may be managed in any period of time, such as one week, two weeks, or two months.

- In the above embodiment, the control unit 21 of the attendance management server 20 executes a process of displaying a list of overtime statuses (step S4-7). In this case, the employee graphs may be rearranged in order of increasing overtime hours or decreasing overtime hours, and then displayed on the overtime display screen. Specifically, the control unit 21 sorts the employees in order of increasing overtime hours or decreasing overtime hours, and displays a bar graph or a bar graph of the employees on the screen.

Next, technical ideas that can be understood from the above embodiment and other examples will be additionally described below.
(a) The control unit includes:
Specify the current month's allowable time as the allowable time,
Specify the overtime working hours in a month as the overtime working hours,
Obtaining the half-yearly upper limit of overtime hours for the target employee over a six-month period from the contract storage unit;
Obtain the current working hours for the current period including the current month from the labor performance storage unit,
Calculate the current term's allowable hours by subtracting the current term's working hours from the half-year upper limit hours,
3. The attendance management system according to claim 1, wherein if the current term allowable time is less than the monthly upper limit time of the target employee, the current term allowable time is specified as the current month's allowable time.
(b) The control unit:
Specify the current month's allowable time as the allowable time,
Specify the overtime working hours in a month as the overtime working hours,
Calculate the average allowable time for one month of the half-year upper limit of overtime work for the target employee over a six-month period,
If the overtime working hours for the current month are less than the allowable hours for the current month, compare the overtime working hours for the current month with the average allowable hours,
If the overtime working hours for the current month exceed the average allowable time, calculate the warning time by subtracting the average allowable time from the overtime working hours for the current month,
3. Attendance according to claim 1 or 2, wherein the band graph is displayed on the display terminal in a state in which the warning time is subtracted from the difference time. management system.

A1, A2... Range, G1, G11, G12... Band graph, G2, G22... Bar graph, G1a... Overtime work time, G1b... Warning time, G1n... Remaining overtime time, G1r... Difference time, G2a... Allowable time for the current month, G2e ...excess time, 15...user terminal, 20...attendance management server, 21...control unit, 22...office information storage unit, 23...employee information storage unit, 24...dispatch information storage unit, 25...work record storage unit, 211...Working time recording section, 212...Notification section, 213...Overtime time calculation section, 214...Permissible time specification section, 215...Overtime display section, 220...Office information, 230...Staff information, 240...Dispatch source information, 250 ...Labor performance information, 500...Top screen, 510...Office information screen, 520...Overtime display screen.

Claims (3)

a contract storage unit that stores labor contract information corresponding to the affiliation of the employee who belongs to the construction office, including information regarding the upper limit for overtime work and the upper limit for this term in special provisions ;
A labor record storage unit that stores actual working hours for each employee;
An attendance management system comprising a control unit connected to a display unit,
The control unit includes:
Identify multiple target employees belonging to the construction office,
specifying, in the contract storage unit, an upper limit for overtime work of the target employee included in labor contract information corresponding to the affiliation of the target employee;
If a special clause is recorded in the contract storage unit, obtain the current term upper limit time in the special clause of the labor contract information,
Using the labor performance storage unit, calculate the overtime hours for this term by summing the actual overtime hours for each working day included in the current term;
Calculate the remaining allowable time for this term by subtracting the overtime hours for this term from the upper limit time for this term,
As the permissible overtime hours of the target employee, the time less than the maximum overtime hours of the target employee included in the labor contract information corresponding to the target employee's affiliation and the remaining allowable time of the current term. identify ,
Calculating the difference time between the allowable time and the overtime working hours of the target employee acquired from the work performance storage unit,
If the overtime working hours are less than or equal to the allowable time, generating a graph in a display format in which the display of the difference time is piled up against the display of the actual working hours in the display of the allowable time ;
If the overtime working hours exceed the permissible time, generate a graph in a display format in which the display of the difference time is piled up against the display of the permissible time;
An attendance management system characterized in that the vertical axis represents overtime working hours, and the graphs corresponding to the target employees are displayed on the display section in a horizontal manner . a contract storage unit that stores labor contract information corresponding to the affiliation of the employee who belongs to the construction office, including information regarding the upper limit for overtime work and the upper limit for this term in special provisions ;
A labor record storage unit that stores actual working hours for each employee;
A method of managing attendance using an attendance management system comprising a control unit connected to a display unit, the method comprising:
The control unit includes:
Identify multiple target employees belonging to the construction office,
specifying, in the contract storage unit, an upper limit for overtime work of the target employee included in labor contract information corresponding to the affiliation of the target employee;
If a special clause is recorded in the contract storage unit, obtain the current term upper limit time in the special clause of the labor contract information,
Using the labor performance storage unit, calculate the overtime hours for this term by summing the actual overtime hours for each working day included in the current term;
Calculate the remaining allowable time for this term by subtracting the overtime hours for this term from the upper limit time for this term,
As the permissible overtime hours of the target employee, the time less than the maximum overtime hours of the target employee included in the labor contract information corresponding to the target employee's affiliation and the remaining allowable time of the current term. identify ,
Calculating the difference time between the allowable time and the overtime working hours of the target employee acquired from the work performance storage unit,
If the overtime working hours are less than or equal to the allowable time, generating a graph in a display format in which the display of the difference time is piled up against the display of the actual working hours in the display of the allowable time ;
If the overtime working hours exceed the permissible time, generate a graph in a display format in which the display of the difference time is piled up against the display of the permissible time;
An attendance management method characterized in that the vertical axis represents overtime working hours, and the graphs corresponding to the target employees are displayed on the display section in a horizontal manner . a contract storage unit that stores labor contract information corresponding to the affiliation of the employee who belongs to the construction office, including information regarding the upper limit for overtime work and the upper limit for this term in special provisions ;
A labor record storage unit that stores actual working hours for each employee;
A program for managing attendance using an attendance management system comprising a control unit connected to a display unit,
The control section,
Identify multiple target employees belonging to the construction office,
specifying, in the contract storage unit, an upper limit for overtime work of the target employee included in labor contract information corresponding to the affiliation of the target employee;
If a special clause is recorded in the contract storage unit, obtain the current term upper limit time in the special clause of the labor contract information,
Using the labor performance storage unit, calculate the overtime hours for this term by summing the actual overtime hours for each working day included in the current term;
Calculate the remaining allowable time for this term by subtracting the overtime hours for this term from the upper limit time for this term,
As the permissible overtime hours of the target employee, the time less than the maximum overtime hours of the target employee included in the labor contract information corresponding to the target employee's affiliation and the remaining allowable time of the current term. identify ,
Calculating the difference time between the allowable time and the overtime working hours of the target employee acquired from the work performance storage unit,
If the overtime working hours are less than or equal to the allowable time, generating a graph in a display format in which the display of the difference time is piled up against the display of the actual working hours in the display of the allowable time ;
If the overtime working hours exceed the permissible time, generate a graph in a display format in which the display of the difference time is piled up against the display of the permissible time;
The attendance management program is characterized in that the program functions as a means for displaying the graphs corresponding to the target employees in a horizontal direction on the display section, with the vertical axis representing overtime working hours .