Working hour management system, working hour management method, and working hour management program
The work hour management system addresses the challenge of tallying irregular working hours spanning multiple days by recalculating and aggregating scheduled hours, ensuring compliance and reducing administrative burden.
Patent Information
- Application Number
- JP2022120931
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2022-07-28
- Publication Date
- 2025-12-09
- Estimated Expiration
- 2042-07-28
AI Technical Summary
Conventional systems fail to accurately tally scheduled working hours when employee arrival and departure times span multiple days, making it cumbersome to compile weekly or monthly working hours, particularly in industries like long-distance transportation.
A work hour management system and method that utilizes a control unit to access a non-statutory calculation master, input daily report data, and recalculate scheduled working hours by day, aggregating them on a weekly basis, while considering the company's stipulated working hours and overtime, and displaying any discrepancies.
Enables easy and accurate tallying of scheduled working hours for a week or month, reducing administrative workload and preventing violations of labor laws by ensuring compliance with stipulated working hours.
Smart Images

Figure 0007783143000001 
Figure 0007783143000002 
Figure 0007783143000003
Abstract
Description
[Technical Field]
[0001] The present invention relates to a work hour management system, a work hour management method, and a work hour management program. [Background technology]
[0002] For example, in the long-distance transportation industry, crew members' working hours are irregular and may span multiple days, such as departing early in the morning and returning early the next morning, or departing late at night and returning the morning after that. When a single operation spans multiple dates, calculating the scheduled working hours for each calendar day requires human judgment, making the compilation of scheduled working hours for a week or month cumbersome. A conventional system for managing scheduled working hours is disclosed, for example, in Patent Document 1. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2011-59823 Summary of the Invention [Problem to be solved by the invention]
[0004] However, Patent Document 1 does not describe anything about tallying up scheduled working hours when the arrival and departure times of employees span multiple days.
[0005] The present invention has been made in consideration of the above, and aims to provide a work hour management system, work hour management method, and work hour management program that can easily tally up scheduled work hours for a week or month, even when arrival and departure times span multiple days. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides a work hour management system equipped with a control unit, the control unit being configured to be able to access a non-statutory calculation master that registers the week starting day, the scheduled work hours per day, and the scheduled weekly work hours in association with each other, and is characterized by comprising: a daily report input means for inputting daily report data including daily report number, crew member, departure time, return time, actual working hours, scheduled work hours, overtime hours, scheduled work hours for the next month, and overtime hours for the next month; and a scheduled work hour recalculation means for recalculating the scheduled work hours for each crew member by day based on the daily report data and by referring to the non-statutory calculation master, and aggregating the scheduled work hours on a weekly basis from the week starting day.
[0007] According to another aspect of the present invention, if the condition that the departure time of the daily report data is greater than or equal to the first day of the month and the condition that the return time of the daily report data is less than or equal to the last day of the month is met, the scheduled work hour recalculation means sets the scheduled work hours of the daily report data to the allocation source scheduled work hours and the maximum scheduled work hours for one day to the scheduled work hours for one day in the non-statutory calculation master, and for each day of the month from the departure time to the return time of the daily report data, sets the allocation start date to the date of the departure time, and allocates the maximum scheduled work hours for one day from the allocation source scheduled work hours in order, and if the remaining number of the allocation source scheduled work hours falls below the maximum scheduled work hours for one day, allocates the remaining number of the allocation source scheduled work hours.
[0008] According to another aspect of the present invention, if the condition that the departure time of the daily report data is greater than or equal to the first day of the current month is not met and the condition that the return time of the daily report data is less than or equal to the last day of the current month is met, the scheduled work hour recalculation means sets the scheduled work hours for the following month of the daily report data to the allocation source scheduled work hours and the maximum scheduled work hours for one day to the scheduled work hours for one day in the non-statutory calculation master, and for each day of the current month from the departure time to the return time of the daily report data, the allocation start date is set to "the 1st", and the maximum scheduled work hours for one day are allocated in order from the scheduled work hours of the allocation source, and if the remaining number of the scheduled work hours of the allocation source becomes less than the maximum scheduled work hours for one day, the remaining number of the scheduled work hours of the allocation source may be allocated.
[0009] Furthermore, according to one aspect of the present invention, if the condition that the departure time of the daily report data is greater than or equal to the first day of the current month is met, but the condition that the return time of the daily report data is less than or equal to the last day of the current month is not met, the scheduled work hour recalculation means sets the scheduled work hours of the daily report data - the scheduled work hours of the next month as the allocation source scheduled work hours, and the maximum scheduled work hours for one day in the non-statutory calculation master, and for each day of the current month from the departure time to the return time of the daily report data, sets the allocation start date to the date of the departure time, and allocates the maximum scheduled work hours for one day in order from the scheduled work hours of the allocation source, and if the remaining number of the scheduled work hours of the allocation source falls below the maximum scheduled work hours for one day, it may allocate the remaining number of the scheduled work hours of the allocation source.
[0010] According to another aspect of the present invention, the predetermined working hours recalculation means may display the difference between the aggregated weekly predetermined working hours and the weekly predetermined working hours in the non-statutory calculation master as an adjustment time on a display unit.
[0011] According to another aspect of the present invention, the control unit may be configured to be able to access a predetermined work hour pattern master in which year and month, predetermined number of days, and monthly predetermined work hours are registered in association with each other, and the predetermined work hour recalculation means may add up the aggregated weekly predetermined work hours on a monthly basis, and display on the display unit the difference between the added-up monthly predetermined work hours and the monthly predetermined work hours for the corresponding month in the predetermined work hour pattern master as an adjustment time.
[0012] According to another aspect of the present invention, the crew may include a long-distance driver.
[0013] Furthermore, in order to solve the above-mentioned problems and achieve the object, the present invention provides a work hour management method executed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a non-statutory calculation master that registers the week starting day, the scheduled work hours per day, and the scheduled weekly work hours in association with each other, and the method includes: a daily report input process executed by the control unit, which inputs daily report data including the daily report number, crew member, departure time, return time, actual working hours, scheduled work hours, overtime hours, scheduled work hours for the next month, and overtime hours for the next month; and a scheduled work hour recalculation process that refers to the non-statutory calculation master based on the daily report data, recalculates the scheduled work hours for each crew member by day, and aggregates the scheduled work hours on a weekly basis from the week starting day.
[0014] Furthermore, in order to solve the above-mentioned problems and achieve the object, the present invention provides a work hour management program to be executed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a non-statutory calculation master that registers the week starting day, the scheduled work hours per day, and the scheduled weekly work hours in association with each other, and the control unit executes a daily report input process in which daily report data including the daily report number, crew member, departure time, return time, actual working hours, scheduled work hours, overtime hours, scheduled work hours for the next month, and overtime hours for the next month, and a scheduled work hour recalculation process in which, based on the daily report data, the non-statutory calculation master is referenced, and the scheduled work hours are recalculated for each crew member by day, and the scheduled work hours are totaled in one-week units from the week starting day. [Effects of the Invention]
[0015] According to the present invention, it is possible to easily tally up the prescribed working hours for a week or a month even when the arrival and departure times of employees span multiple days. [Brief explanation of the drawings]
[0016] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a working hours management system according to this embodiment. [Figure 2]FIG. 2 is a diagram illustrating an example of the configuration of the non-legal calculation master. [Figure 3] FIG. 3 is a diagram showing an example of the configuration of the predetermined working hours pattern master. [Figure 4] FIG. 4 is a diagram showing an example of the overall processing flow of the control unit of the working hour management system according to the present embodiment. [Figure 5] FIG. 5 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the working hour management system according to the present embodiment. [Figure 6] FIG. 6 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the working hour management system according to the present embodiment. [Figure 7] FIG. 7 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the working hour management system according to the present embodiment. [Figure 8] FIG. 8 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the working hour management system according to the present embodiment. [Figure 9] FIG. 9 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the working hour management system according to the present embodiment. [Figure 10] FIG. 10 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the working hour management system according to the present embodiment. [Figure 11] FIG. 11 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the working hour management system according to the present embodiment. [Figure 12] FIG. 12 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the working hour management system according to the present embodiment. DETAILED DESCRIPTION OF THE INVENTION
[0017] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this embodiment.
[0018] [1. Overview] For example, in the long-distance transportation industry, crew members' working hours are irregular and may span multiple days, such as departing early in the morning and returning early the next morning, or departing late at night and returning the morning after. When a single operation spans multiple dates, human judgment is required to calculate the scheduled working hours for each calendar day, making it cumbersome to tally up scheduled working hours for a week or month.
[0019] Here, the term "prescribed working hours" refers to the working hours stipulated in the contract, specifically the time from the start of work to the end of work (excluding breaks) as stipulated in the work regulations or employment contract. Prescribed working hours can be freely set by the company within the legal working hours (8 hours per day, 40 hours per week) set out in the Labor Standards Act.
[0020] In this embodiment, even if the arrival and departure times span multiple days, the scheduled working hours registered in the daily report data can be recalculated for each crew member by referencing the master that registers the scheduled working hours specified by the company, making it possible to easily tally up the scheduled working hours for each week or month. This reduces the workload of the person in charge of operations, and by using it to check the scheduled working hours for more than 40 days per week or month, it is possible to prevent violations of laws and regulations and unpaid overtime.
[0021] The working time management system of the present invention can be widely applied to industries where employee arrival and departure times span multiple days, such as the land transportation industry. In the following example, we will explain the case where the system is applied to the land transportation industry, assuming that employees are crew members (including long-distance drivers), but this is not limited to this, and the system can be widely applied to other industries where employee arrival and departure times span multiple days.
[0022] [2. Configuration] An example of the configuration of a working hour management system according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of a working hour management system according to this embodiment.
[0023] The working hour management system 100 is a commercially available desktop personal computer. Note that the working hour management system 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.
[0024] The working hour management system 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit of the working hour management system 100 is connected to each other so as to be able to communicate with each other via any communication path.
[0025] The communication interface unit 104 communicatively connects the working hour management system 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of exchanging data with other devices via the communication line. Here, the network 300 has a function of communicatively connecting the working hour management system 100 with the server 200, field staff terminals 400..., payroll staff terminals 500..., crew terminals (not shown), etc., for example, the Internet or a LAN (Local Area Network).
[0026] The field staff terminals 400... are terminals used by field staff (for example, staff at a sales office) and are configured to be capable of data communication with the working hour management system 100. The field staff of the field staff terminals 400 input daily report data on a daily report input screen provided by the working hour management system 100.
[0027] The payroll staff terminals 500... are terminals used by payroll staff (e.g., staff in the accounting department) and are configured to be capable of data communication with the working hour management system 100. The payroll staff using the payroll staff terminals 500... perform recalculation of the prescribed working hours on the prescribed working hours simulation screen provided by the working hour management system 100.
[0028] The crew terminal (not shown) is a terminal used by the crew, and is configured to be capable of data communication with the working hour management system 100. On the crew terminal, the crew can input time card data (daily report number, crew member, departure time, return time, actual working hours) by punching the start time and end time of work on the time card screen provided by the working hour management system 100.
[0029] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that functions as a pointing device in cooperation with a mouse. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.
[0030] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.
[0031] The storage unit 106 also includes a non-legal calculation master 106a, a prescribed working hours master 106b, and a data table 106c. Figure 2 is a diagram showing an example of the configuration of the non-legal calculation master 106a. Figure 3 is a diagram showing an example of the configuration of the prescribed working hours pattern master 106b.
[0032] The non-statutory calculation master 106a is a table that registers the daily and weekly prescribed working hours stipulated by the company in accordance with the Labor Standards Act, and is set on a monthly basis. For example, as shown in Figure 2, the non-statutory calculation master 106a can be configured as a table that registers the week starting day, the prescribed working hours per day, and the prescribed working hours per week in association with each other. In the example shown in the figure, the first row contains the week starting day "1: Tuesday," the prescribed working hours per day "8," and the prescribed working hours per week "40."
[0033] The prescribed working hours pattern master 106b is a record of the prescribed monthly working hours stipulated by the company in accordance with the Labor Standards Act. As shown in Figure 3, the prescribed working hours pattern master 106b can be configured as a table that associates and registers the year and month, the prescribed number of days, and the prescribed working hours. In the example shown in the figure, the first row contains the year and month "2021 / 4," the prescribed number of days "24," and the prescribed working hours "192."
[0034] The data table 106e is a table for storing various data such as time card data, daily report data, and crew member daily predetermined time aggregation results.
[0035] The daily report data may include the daily report number, crew member, departure time (time to arrive at work), return time (time to return to work), actual working hours, scheduled working hours, overtime hours, scheduled working hours for the next month, and overtime hours for the next month.
[0036] The results of the daily scheduled work hours summary for each crew member may include the recalculated scheduled work hours for each day of the target year and month for each crew member, the total recalculated scheduled work hours on a weekly basis, and the total recalculated scheduled work hours on a monthly basis.
[0037] Returning to Figure 1, the control unit 102 is a CPU or the like that performs overall control of the working hour management system 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processes based on these stored programs.
[0038] The control unit 102 is configured to be able to access the non-legal calculation master 106a, the predetermined working hours pattern master 106b, and the data table 106c stored in the storage unit 106. The non-legal calculation master 106a, the predetermined working hours pattern master 106b, and the data table 106c may be provided in another location (for example, the server 200) as long as the control unit 102 is able to access them.
[0039] The control unit 102 conceptually includes a daily report input unit 102a, a predetermined working time recalculation unit 102b, a master maintenance unit 102c, and a screen display control unit 102d.
[0040] In response to a request from the field staff terminal 400, the daily report input unit 102a provides a daily report input screen to the field staff terminal 400, inputs daily report data in response to the input operation of the field staff on the daily report input screen of the field staff terminal 400, and stores the data in the data table 106c.
[0041] In response to a request from the payroll officer terminal 500, the scheduled work hours recalculation unit 102b provides a scheduled work hours simulation screen to the payroll officer terminal 500, and in response to the operation of the payroll officer on the scheduled work hours simulation screen of the payroll officer terminal 500, recalculates the scheduled work hours by day for each crew member and by daily report number based on the daily report data, with reference to the non-statutory calculation master 106a, and generates a crew member daily scheduled work hours aggregation result including the result of aggregating the scheduled work hours on a weekly basis from the week starting day of the week, and stores this in the data table 106c.
[0042] In this case, if the condition that the departure time of the daily report data is greater than or equal to the first day of the current month and the condition that the return time of the daily report data is less than or equal to the last day of the current month (when the month does not span multiple months) is met, the scheduled work hour recalculation unit 102b sets the scheduled work hours of the daily report data to the allocation source scheduled work hours and the maximum scheduled work hours for one day to the scheduled work hours for one day in the non-statutory calculation master 106a, and for each day of the current month from the departure time of the daily report data to the return time, sets the allocation start date to the date of the departure time, and allocates the maximum scheduled work hours for one day from the scheduled work hours of the allocation source in order, and if the remaining number of the scheduled work hours of the allocation source falls below the maximum scheduled work hours for one day, the remaining number of the scheduled work hours of the allocation source may be allocated.
[0043] Furthermore, if the condition that the departure time of the daily report data is greater than or equal to the first day of the current month is not met and the condition that the return time of the daily report data is less than or equal to the last day of the current month is met (if it spans the previous month), the scheduled work hour recalculation unit 102b sets the scheduled work hours for the following month of the daily report data to the allocation source scheduled work hours and the maximum scheduled work hours for one day to the scheduled work hours for one day in the non-statutory calculation master 106a, and for each day of the current month from the departure time of the daily report data to the return time of the daily report data, the allocation start date is set to "the 1st" and the maximum scheduled work hours for one day are allocated in order from the scheduled work hours of the allocation source, and if the remaining number of the scheduled work hours of the allocation source falls below the maximum scheduled work hours for one day, the remaining number of the scheduled work hours of the allocation source may be allocated.
[0044] Furthermore, if the condition that the departure time of the daily report data is greater than or equal to the first day of the current month is met, but the condition that the return time of the daily report data is less than or equal to the last day of the current month is not met (if the period spans a subsequent month), the scheduled work hour recalculation unit 102b sets the scheduled work hours of the daily report data - the scheduled work hours of the next month as the scheduled work hours of the allocation source, and the maximum scheduled work hours for one day in the non-statutory calculation master 106a, and for each day of the current month from the departure time of the daily report data to the return time, sets the allocation start date to the date of the departure time and allocates the maximum scheduled work hours for one day from the scheduled work hours of the allocation source in order, and if the remaining number of the scheduled work hours of the allocation source falls below the maximum scheduled work hours for one day, the remaining number of the scheduled work hours of the allocation source may be allocated.
[0045] Furthermore, the prescribed working hours recalculation unit 102b may display the difference between the collected weekly prescribed working hours and the weekly prescribed working hours in the non-statutory calculation master 106a as an adjustment time on the prescribed working hours simulation screen.
[0046] In addition, the scheduled work hours recalculation unit 102b may add up the collected scheduled work hours on a weekly basis on a monthly basis, and display the difference between the added monthly scheduled work hours and the monthly scheduled work hours for the corresponding month in the scheduled work hours pattern master 106b as an adjustment time on the scheduled work hours simulation screen.
[0047] The master maintenance unit 102c performs settings such as inputting, adding, deleting, and editing data for the non-statutory calculation master 106a and the predetermined working hours pattern master 106b, for example, in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.
[0048] The screen display control unit 102d controls the display of various screens (for example, a master maintenance screen) displayed on the monitor 114 and the inputs therefor.
[0049] [3. Specific Examples] A specific example of the processing of the working hour management system 100 in this embodiment will be described with reference to Figures 1 to 12. Figures 4 to 11 are diagrams for explaining a specific example of the processing of the working hour management system 100 in this embodiment.
[0050] (3-1. Overall processing) An example of the overall processing of the control unit of the working hour management system 100 in this embodiment will be described with reference to Fig. 4. Fig. 4 is a diagram showing an example of the flow of the overall processing of the control unit of the working hour management system 100 in this embodiment.
[0051] The daily report input unit 102a executes a daily report input process (step S1). Specifically, in the daily report input process, the daily report input unit 102a provides a daily report input screen to the on-site staff terminal 400 in response to a request from the on-site staff terminal 400, inputs daily report data in response to an input operation on the daily report input screen of the on-site staff terminal 400 by the on-site staff member, and stores the data in the data table 106c.
[0052] The scheduled work hour recalculation unit 102b executes the scheduled work hour recalculation process (step S2). Specifically, in the scheduled work hour recalculation process, in response to a request from the payroll officer's terminal 500, the scheduled work hour recalculation unit 102b provides a scheduled work hour simulation screen to the payroll officer's terminal 500, and in response to an operation on the scheduled work hour simulation screen of the payroll officer on the payroll officer's terminal 500, recalculates the scheduled work hours by day for each crew member and by daily report number based on the daily report data with reference to the non-statutory calculation master 106a, and generates a crew member daily scheduled work hour aggregation result including the aggregation result of the scheduled work hours for one week from the week starting day of the week, and stores this in the data table 106c.
[0053] In this case, if condition (1): the dispatch time of the daily report data is equal to or greater than the first day of the current month, and condition (2): the return time of the daily report data is equal to or less than the last day of the current month (when the month does not span multiple months), the scheduled work hour recalculation unit 102b sets the scheduled work hours of the daily report data to the allocation source scheduled work hours and the maximum scheduled work hours for one day to the daily scheduled work hours in the non-statutory calculation master 106a, and for each day of the current month from the dispatch time to the return time of the daily report data, sets the allocation start date to the date of the dispatch time, and assigns the maximum scheduled work hours for one day from the allocation source scheduled work hours in order, and if the remaining number of the allocation source scheduled work hours falls below the maximum scheduled work hours for one day, assigns the remaining number of the allocation source scheduled work hours (see Figure 9).
[0054] Furthermore, if the condition (1): the dispatch time of the daily report data ≧ the first day of the current month is not met, and the condition (2): the return time of the daily report data ≦ the last day of the current month is met (if the previous month is spanned), the scheduled work hour recalculation unit 102b sets the scheduled work hours of the following month of the daily report data to the allocation source scheduled work hours and the maximum scheduled work hours for one day to the scheduled work hours for one day in the non-statutory calculation master 106a, and for each day of the current month from the dispatch time of the daily report data to the return time of the daily report data, the allocation start date is set to "the 1st," and the maximum scheduled work hours for one day are assigned in order from the scheduled work hours of the allocation source, and if the remaining number of the scheduled work hours of the allocation source becomes less than the maximum scheduled work hours for one day, the remaining number of the scheduled work hours of the allocation source is assigned (see Figure 8).
[0055] Furthermore, if the condition (1): the dispatch time of the daily report data ≧ the first day of the current month is met, and the condition (2): the return time of the daily report data ≦ the last day of the current month is not met (if the next month is spanned), the scheduled work hour recalculation unit 102b sets the scheduled work hours of the daily report data − the scheduled work hours of the next month as the scheduled work hours of the allocation source, and the maximum scheduled work hours for one day as the scheduled work hours of the non-statutory calculation master 106a, and for each day of the current month from the dispatch time of the daily report data to the return time, sets the allocation start date to the date of the dispatch time, and allocates the maximum scheduled work hours for one day from the scheduled work hours of the allocation source in order, and if the remaining number of the scheduled work hours of the allocation source falls below the maximum scheduled work hours for one day, allocates the remaining number of the scheduled work hours of the allocation source (see Figure 11).
[0056] Furthermore, the prescribed working hours recalculation unit 102b may display the difference between the collected weekly prescribed working hours and the weekly prescribed working hours in the non-statutory calculation master 106a as an adjustment time on the prescribed working hours simulation screen.
[0057] In addition, the scheduled work hours recalculation unit 102b may add up the collected scheduled work hours on a weekly basis on a monthly basis, and display the difference between the added monthly scheduled work hours and the monthly scheduled work hours for the corresponding month in the scheduled work hours pattern master 106b as an adjustment time on the scheduled work hours simulation screen.
[0058] (3-2. Sample data) 5 to 12 are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the working hour management system 100 according to the present embodiment. A specific example of the processing by the control unit 102 of the working hour management system 100 according to the present embodiment will be explained with reference to FIGS. 5 to 12.
[0059] (S1: Daily report input processing) A specific example of the daily report input process will be described with reference to Figures 5 and 6. In response to a request from the field staff terminal 400, the daily report input unit 102a provides a daily report input screen to the field staff terminal 400, inputs daily report data in response to an input operation on the daily report input screen of the field staff terminal 400 by the field staff member, and stores the data in the data table 106c.
[0060] FIG. 5 is a diagram showing an example of a daily report input screen. Daily report data is registered on the daily report input screen by specifying the daily report number, crew member, departure date and time, return date and time, actual working hours, scheduled working hours, overtime hours, scheduled working hours for the following month, and overtime hours for the following month. For example, when a site manager inputs a daily report number on the daily report input screen, the site manager may use the daily report number as a key to obtain the crew member, departure date and time, return date and time, and actual working hours from time card data, and then input the scheduled working hours, scheduled working hours for the following month, and overtime hours for the following month. Since there is a risk of input errors if the crew member inputs the scheduled working hours, scheduled working hours for the following month, it is preferable that the site manager input them. Overtime hours may be automatically calculated and displayed as the actual working hours minus the scheduled working hours. The scheduled working hours for the following month and overtime hours for the following month can only be input if the departure date and time and the return date and time span across months (the previous month or the following month).
[0061] FIG. 5(A) shows an example in which the departure date and time and the return date and time span across months, and FIG. 5(B) shows an example in which the departure date and time and the return date and time do not span across months.
[0062] FIG. 6 is a diagram showing an example of daily report data. The daily report data may include the following fields: daily report number, crew member, departure from warehouse, return from warehouse, actual working hours, scheduled working hours, overtime hours, scheduled working hours for the next month, and overtime hours for the next month. In the example shown in the figure, the first line contains the daily report number "N010010," crew member "A00001," departure from warehouse "2022 / 1 / 29 14:00," return from warehouse "2022 / 2 / 3 10:00," actual working hours "24:00," scheduled working hours "16:00," overtime hours "8:00," scheduled working hours for the next month "10:00," and overtime hours for the next month "4:00."
[0063] (S2: Scheduled working hours recalculation process) A specific example of the prescribed work hours recalculation process will be described with reference to Figures 7 to 12. In response to a request from the payroll officer's terminal 500, the prescribed work hours recalculation unit 102b provides a prescribed work hours simulation screen to the payroll officer's terminal 500, and in response to the payroll officer's operation on the prescribed work hours simulation screen on the payroll officer's terminal 500, references the non-statutory calculation master 106a based on the daily report data, recalculates the prescribed work hours by day for each crew member and by daily report number, and generates crew member daily prescribed work hours aggregation results including the results of aggregating the prescribed work hours for each week from the week starting day of the week, and stores these in data table 106c.
[0064] FIG. 7 shows an example of the prescribed working hours simulation screen. The prescribed working hours simulation screen includes a condition specification area for specifying the target year / month and crew member, a Calculate Prescribed Working Hours button, and a calculation result display area that displays the aggregated results of the recalculated prescribed working hours (cumulative daily report data). The calculation result display area displays the weekly starting date, prescribed working hours, and adjustment time on a weekly basis, and the total month, prescribed working hours, and adjustment time on a monthly basis. When the target year / month and crew member are specified in the condition specification area and the Calculate Prescribed Working Hours button is pressed, the prescribed working hours recalculation unit 102b recalculates the daily prescribed working hours for the specified target year / month and crew member by referencing the corresponding daily report data in the data table 106c, and displays the aggregated results for each week and month on the prescribed working hours simulation screen.
[0065] When recalculating the scheduled working hours, the scheduled working hours registered in the daily report data are allocated to each crew member and each day. If there are scheduled working hours carried over from the previous month, the "scheduled next month" hours from the end of the previous month's daily report are allocated from the beginning of the month. In addition, the scheduled working hours per day set in the non-legal calculation master 106a are allocated from the departure date of the daily report as the maximum value.
[0066] Below, we will explain an example of the recalculation process when the target year and month "2022 / 02" and crew member "A00001 XX XX" are specified. All of the daily report numbers "N010010" to "N020007" in the corresponding daily report data in Figure 6 will be recalculated, but here we will explain the daily report numbers "N010010", "N020001", "N020002", and "N020007" as representative examples.
[0067] (In the case of daily report number "N010010") An example of recalculation for daily report number "N010010" will be described with reference to Figure 8. As shown in Figure 8(A), the daily report data for daily report number "N010010" has crew member "A00001," departure time "2022 / 1 / 29 14:00," return time "2022 / 2 / 3 10:00," actual working hours "24:00," scheduled working hours "16:00," overtime hours "8:00," scheduled working hours for the next month "10:00," and overtime hours for the next month "4:00."
[0068] As shown in Figure 8(B), condition (1): Delivery time "1 / 29 14:00" ≥ first day of the current month "2 / 1" is not met ("X"), and condition (2): Return time "2 / 3 10:00" ≤ last day of the current month "2 / 28" is met ("○"), so the allocation source scheduled working hours are set to the scheduled working hours for the next month "10" and the allocation start date is set to the system date "1st." Since the scheduled working hours per day are "8" according to the non-statutory calculation master 106a, the maximum daily allocation time is set to "8." Allocation hours are calculated from 2 / 1.
[0069] For the first day, the allocation source scheduled working hours "10" is greater than or equal to the daily allocated hours "8", so the scheduled working hours are assigned "8". The allocation source scheduled working hours are then 2 (= allocation source scheduled working hours "10" - maximum allocated hours for 1 day "8").
[0070] On the 2nd, the original scheduled working hours of "2" are less than the maximum daily allocated hours of "8", so "2" is assigned to the scheduled working hours and processing ends.
[0071] Figure 8(C) is an example of a calendar, and Figure 8(D) is a diagram showing the results of tallying the scheduled working hours by day for crew members, where the scheduled working hours for 2 / 1 (Tue) are "8" and the scheduled working hours for 2 / 2 (Wed) are "2".
[0072] (For daily report number "N020001") A calculation example for daily report number "N020001" will be described with reference to Figure 9. As shown in Figure 9(A), the daily report data daily report number "N020001" has crew member "A00001", departure time "2022 / 2 / 3 12:00", return time "2022 / 2 / 5 11:00", actual working hours "24:00", scheduled working hours "16:00", and overtime hours "8:00".
[0073] As shown in Figure 9(B), condition (1): departure time "2022 / 2 / 3 12:00" ≥ first day of the current month "2 / 1" is met, so the result is "○", and condition (2): return time "2022 / 2 / 5 11:00" ≤ last day of the current month "2 / 28" is met, so the result is "○", the allocation source working hours are set to the scheduled working hours of "16", and the allocation start date is set to the departure time date "2 / 3". Since the scheduled daily working hours are "8" according to the non-statutory calculation master 106a, the maximum daily allocation time is set to "8". The allocation time is calculated based on the departure time date "2 / 3".
[0074] On the 3rd, the allocation source scheduled working hours of "16" is greater than or equal to the daily allocated hours of "8", so the scheduled working hours are assigned as "8". The allocation source scheduled working hours are 8 (= allocation source scheduled working hours "16" - maximum allocated hours for one day "8").
[0075] On the 4th, the ratio-based scheduled working hours of "8" is greater than or equal to the daily allocated hours of "8", so "8" is assigned to the scheduled working hours. The allocation-based scheduled working hours is 0 (= allocation-based scheduled working hours of "8" - maximum allocated hours for 1 day of "8"). Since the allocation-based scheduled working hours is "0", processing ends.
[0076] As shown in Figures 9(C) and (D), the scheduled working hours for February 3rd (Thursday) are set to "8", and the scheduled working hours for February 4th (Friday) are set to "2".
[0077] (For daily report number "N020002") A calculation example for daily report number "N020002" will be described with reference to Figure 10. As shown in Figure 10(A), the daily report data daily report number "N020002" has crew member "A00001", departure time "2022 / 2 / 6 12:30", return time "2022 / 2 / 10 14:30", actual working hours "34:30", scheduled working hours "29:00", and overtime hours "5:00".
[0078] As shown in Figure 10(B), condition (1): departure time "2022 / 2 / 6 12:30" ≥ first day of the current month "2 / 1" is met, so the result is "○", and condition (2): return time "2022 / 2 / 10 14:30" ≤ last day of the current month "2 / 28" is met, so the result is "○", the allocation source working hours are set to the scheduled working hours of "29", and the allocation start date is set to the date of departure time "2 / 6". Since the scheduled working hours per day are "8" according to the non-statutory calculation master 106a, the maximum daily allocation time is set to "8". The allocation time is calculated based on the departure time date of "2 / 6".
[0079] On the 6th, the allocation source scheduled working hours "29" is greater than or equal to the daily allocated hours "8", so the scheduled working hours are assigned "8". The allocation source scheduled working hours are 21 (= allocation source scheduled working hours "29" - maximum allocated hours for one day "8").
[0080] On the 7th, the proportion-based scheduled working hours of "21" is greater than or equal to the daily allocated hours of "8", so the scheduled working hours are assigned "8". The allocated scheduled working hours are 13 (= allocated scheduled working hours of "21" - maximum allocated hours for one day of "8").
[0081] On the 8th, the proportion-based scheduled working hours of "13" is greater than or equal to the daily allocated hours of "8", so the scheduled working hours are assigned "8". The allocated scheduled working hours are 5 (= allocated scheduled working hours of "13" - maximum allocated hours for one day of "8").
[0082] On the 9th, the ratio-based scheduled work hours of "5" is not greater than or equal to the daily allocated hours of "8", so the remaining number of allocation-based scheduled work hours, "5", is allocated to the scheduled work hours, and processing ends.
[0083] As shown in Figures 10(C) and (D), the scheduled working hours for February 6th (Sunday) are "8," the scheduled working hours for February 7th (Monday) are "8," the scheduled working hours for February 8th (Tuesday) are "8," and the scheduled working hours for February 9th (Wednesday) are "5."
[0084] (For daily report number "N020007") A calculation example for daily report number "N020007" will be explained with reference to Figure 11. As shown in Figure 11(A), the daily report data for daily report number "N020007" has crew member "A00001," departure time "2022 / 2 / 26 13:30," return time "2022 / 3 / 3 18:30," actual working hours "41:00," scheduled working hours "32:00," overtime hours "9:00," scheduled working hours for the next month "8:00," and overtime hours for the next month "4.0."
[0085] As shown in Figure 11(B), condition (1): departure time "2022 / 2 / 26 13:30" ≥ first day of the current month "2 / 1" is met, so the result is "○", and condition (2): return time "2022 / 3 / 3 18:30" ≤ last day of the current month "2 / 28" is not met, so the result is "×". The allocation source scheduled working hours are set to scheduled working hours "32" - scheduled working hours for the next month "8", and the allocation start date is set to the date of departure time "2 / 26". Since the scheduled working hours per day are "8" according to the non-statutory calculation master 106a, the maximum daily allocation time is set to "8". The allocation hours are calculated using the departure time date "2 / 6".
[0086] For the 26th, the original scheduled working hours "24" is greater than or equal to the daily allocated hours "8", so the original scheduled working hours are assigned "8", and the original scheduled working hours are set to 16 (= original scheduled working hours "24" - maximum daily allocated hours "8").
[0087] For the 27th, the proportion-based scheduled working hours of "16" is greater than or equal to the daily allocated hours of "8", so the scheduled working hours are assigned "8", and the allocated scheduled working hours are set to 8 (= allocated scheduled working hours of "16" - maximum allocated hours for one day "8").
[0088] For the 28th, the ratio-based scheduled work hours of "8" is greater than or equal to the daily allocated time of "8", so "8" is assigned to the scheduled work hours, and the allocation-based scheduled work hours is set to 0 (= allocation-based scheduled work hours of "8" - maximum allocated time for one day of "8"). Since the allocation-based scheduled work hours are "0", processing ends.
[0089] As shown in Figures 11(C) and (D), a calendar is shown in which the working hours for 2 / 26 (Saturday) are "8", the scheduled working hours for 2 / 27 (Sunday) are "8", and the scheduled working hours for 2 / 28 (Tuesday) are "8". Note that Figures 11(C) and (D) also show the scheduled working hours for other days assigned to other daily report numbers whose explanations are omitted.
[0090] Figure 12 shows an example of the aggregated results displayed on the scheduled work hours simulation screen as a result of the recalculation. The calculation result display area (cumulative daily report data) displays the weekly aggregated results, including the weekly starting date, the total scheduled work hours for that week, and the adjustment time calculated by subtracting the total scheduled work hours for that week from the scheduled weekly work hours in the non-statutory calculation master 106a. For example, in the example shown in Figure 12, the first line displays the weekly starting date "2 / 1 / 2022," the total scheduled work hours for that week "42," and the scheduled adjustment time for that week "2 (=42-40)."
[0091] Additionally, the monthly aggregation results include the total month, the scheduled working hours calculated by adding up the scheduled working hours for that month, and the adjustment time calculated by subtracting the scheduled working hours for that month from the monthly scheduled working hours in the scheduled working hours pattern master 106b. For example, the total month is "2022 / 2," the scheduled working hours calculated by adding up the scheduled working hours for that month are "170.3," and the adjustment time is "2.3 (=170.3-168)."
[0092] Payroll personnel can check the weekly adjustment hours and the monthly total adjustment hours, and adjust the scheduled working hours in the daily report data from the daily report input screen.
[0093] As described above, this embodiment includes a non-statutory calculation master 106a that associates and registers the week starting day, daily scheduled work hours, and weekly scheduled work hours; a daily report input unit 102a that inputs daily report data including the daily report number, crew member, departure time, return time, actual working hours, scheduled work hours, overtime hours, scheduled work hours for the next month, and overtime hours for the next month; and a scheduled work hour recalculation unit 102b that references the non-statutory calculation master based on the daily report data and recalculates the scheduled work hours for each crew member on a daily basis, and totals the scheduled work hours for one week from the week starting day. This makes it possible to easily total the scheduled work hours for a week or a month even if the arrival and departure times of work span multiple days.
[0094] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.
[0095] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.
[0096] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.
[0097] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0098] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.
[0099] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.
[0100] Furthermore, with regard to the working hour management system 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.
[0101] For example, all or any part of the processing functions of the working hour management system 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or by hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing programmed instructions for causing an information processing device to execute the processes described in this embodiment, and is mechanically read by the working hour management system 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to issue instructions to the CPU and perform various processes. The computer program is executed by being loaded into RAM and cooperates with the CPU to form the control unit.
[0102] In addition, this computer program may be stored in an application program server connected to the working hour management system 100 via any network, and all or part of it may be downloaded as needed.
[0103] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.
[0104] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.
[0105] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.
[0106] The working hour management system 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as an information processing device connected to any peripheral device. The working hour management system 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.
[0107] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]
[0108] 100 Working Hours Management System 102 Control section 102a Daily report input section 102b Scheduled Working Hours Recalculation Department 102c Master Maintenance Department 102d Screen display control unit 104 Communication interface unit 106 Storage section 106a Non-statutory calculation master 106b Scheduled working hours pattern master 106c Data Table 106f Work Table 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network 400 Field staff terminal 500 Payroll Officer Terminals
Claims
1. A working time management system equipped with a control unit, The control unit It is configured to be accessible to non-statutory calculation master data that is registered in association with the starting day of the week, the prescribed working hours per day and the prescribed working hours per week as determined by company regulations. a daily report input means for inputting daily report data including a daily report number, a crew member, a departure time, a return time, actual working hours, regular working hours, overtime hours, regular working hours for the next month, and overtime hours for the next month; a predetermined working hours recalculation means for recalculating the predetermined working hours for each crew member on a daily basis based on the daily report data, even when the arrival and departure times of the crew members span multiple days, by referring to the non-statutory calculation master, and aggregating the predetermined working hours for each week from the week starting day; Equipped with A work hour management system characterized in that, if the condition that the departure time of the daily report data is greater than or equal to the first day of the month and the condition that the return time of the daily report data is less than or equal to the last day of the month is met, the prescribed work hour recalculation means sets the prescribed work hours of the daily report data to the allocation source prescribed work hours and the maximum prescribed work hours for one day to the daily prescribed work hours in the non-statutory calculation master, and for each day of the month from the departure time of the daily report data to the return time, sets the allocation start date to the date of the departure time and allocates the maximum prescribed work hours for one day from the allocation source prescribed work hours in order, and if the remaining number of the allocation source prescribed work hours becomes less than the maximum prescribed work hours for one day, allocates the remaining number of the allocation source prescribed work hours.
2. 2. The work hour management system according to claim 1, wherein, if the condition that the departure time of the daily report data is not equal to or greater than the first day of the current month and the condition that the return time of the daily report data is equal to or less than the last day of the current month is met, the predetermined work hour recalculation means sets the predetermined work hours for the following month of the daily report data to the allocation source predetermined work hours and the maximum predetermined work hours for one day to the predetermined work hours for one day in the non-statutory calculation master, and for each day of the current month from the departure time of the daily report data to the return time of the daily report data, the allocation start date is set to "the 1st", and the maximum predetermined work hours for one day are assigned in order from the allocation source predetermined work hours, and if the remaining number of the allocation source predetermined work hours becomes less than the maximum predetermined work hours for one day, the remaining number of the allocation source predetermined work hours is assigned.
3. 2. The work hour management system according to claim 1, wherein, if the condition that the departure time of the daily report data is equal to or greater than the first day of the current month is met but the condition that the return time of the daily report data is equal to or less than the last day of the current month is not met, the prescribed work hour recalculation means sets the prescribed work hours of the daily report data - the prescribed work hours of the next month as the allocation source prescribed work hours and the maximum prescribed work hours for one day as the prescribed work hours for one day in the non-statutory calculation master, and for each day of the current month from the departure time of the daily report data to the return time, sets the allocation start date to the date of the departure time and allocates the maximum prescribed work hours for one day from the allocation source prescribed work hours in order, and if the remaining number of the allocation source prescribed work hours becomes less than the maximum prescribed work hours for one day, allocates the remaining number of the allocation source prescribed work hours.
4. The work hour management system according to claim 1, characterized in that the predetermined work hour recalculation means displays the difference between the aggregated weekly predetermined work hours and the weekly predetermined work hours in the non-statutory calculation master as adjustment time on the display unit.
5. The control unit The system is configured to be able to access a predetermined working hours pattern master that associates and registers the year and month, the predetermined number of days, and the predetermined monthly working hours, 5. The work hour management system according to claim 4, wherein the predetermined work hour recalculation means sums up the aggregated weekly predetermined work hours on a monthly basis, and displays the difference between the summed monthly predetermined work hours and the monthly predetermined work hours for the corresponding month in the predetermined work hour pattern master as an adjustment time on the display unit.
6. 6. The working time management system according to claim 1, wherein the crew includes a long-distance driver.
7. A working time management method executed by an information processing device having a control unit, The control unit It is configured to be accessible to non-statutory calculation master data that is registered in association with the starting day of the week, the prescribed working hours per day and the prescribed working hours per week as determined by company regulations. The control unit executes a daily report input step of inputting daily report data including a daily report number, a crew member, a departure time, a return time, actual working hours, regular working hours, overtime hours, regular working hours for the next month, and overtime hours for the next month; a prescribed working hours recalculation process for recalculating the prescribed working hours for each crew member on a daily basis based on the daily report data, even when the arrival and departure times of the crew members span multiple days, by referring to the non-statutory calculation master, and aggregating the prescribed working hours on a weekly basis from the week starting day; Including, a work hour management method characterized in that, in the prescribed working hour recalculation step, if the condition that the departure time of the daily report data is greater than or equal to the first day of the current month is met and the condition that the return time of the daily report data is less than or equal to the last day of the current month is met, the prescribed working hours of the daily report data are set to the allocation source prescribed working hours and the maximum daily prescribed working hours are set to the daily prescribed working hours of the non-statutory calculation master, and for each day of the current month from the departure time of the daily report data to the return time, the allocation start date is set to the date of the departure time, and the maximum daily prescribed working hours are assigned in order from the allocation source prescribed working hours, and if the remaining number of the allocation source prescribed working hours becomes less than the maximum daily prescribed working hours, the remaining number of the allocation source prescribed working hours is assigned.
8. A work time management program to be executed by an information processing device having a control unit, The control unit It is configured to be accessible to non-statutory calculation master data that is registered in association with the starting day of the week, the prescribed working hours per day and the prescribed working hours per week as determined by company regulations. The control unit a daily report input step of inputting daily report data including a daily report number, a crew member, a departure time, a return time, actual working hours, regular working hours, overtime hours, regular working hours for the next month, and overtime hours for the next month; a prescribed working hours recalculation process for recalculating the prescribed working hours for each crew member on a daily basis based on the daily report data, even when the arrival and departure times of the crew members span multiple days, by referring to the non-statutory calculation master, and aggregating the prescribed working hours on a weekly basis from the week starting day; It is a work time management program to implement A work hour management program characterized in that, in the prescribed work hour recalculation step, if the condition that the departure time of the daily report data is greater than or equal to the first day of the current month is met and the condition that the return time of the daily report data is less than or equal to the last day of the current month is met, the prescribed work hours of the daily report data are set to the allocation source prescribed work hours and the maximum prescribed work hours for one day are set to the daily prescribed work hours of the non-statutory calculation master, and for each day of the current month from the departure time of the daily report data to the return time, the allocation start date is set to the date of the departure time, and the maximum prescribed work hours for one day are assigned in order from the allocation source prescribed work hours, and if the remaining number of the allocation source prescribed work hours becomes less than the maximum prescribed work hours for one day, the remaining number of the allocation source prescribed work hours is assigned.
Citation Information
Patent Citations
Automatic creation system for daily running report
JP2003196355A
Device, system and method for managing labor time
JP2011059823A
Labor management system and computer program
JP2019067322A
Crew working hours calculation system
JP2021128486A
Working hours calculation system, salary calculation system and computer program
JP2021174476A