Work status verification device, work status verification method, and work status verification program

Abstract

To allow for reducing the burden on a verifier by simplifying verification of an attendance state.SOLUTION: A result confirmation worksheet to which attendance result data and theoretical value data are to be inputted is generated. The attendance result data is data indicating an attendance result of an employee and includes data of respective items of at least working day, holiday division indicating that the working day is a weekday or a holiday, and actual working hours, and the theoretical value data includes data of respective items of actual working hours being a reference in each working day of the employee and the holiday division and indicates a work system being a reference. An execution unit executes a theoretical value update module to input the theoretical value data to the result confirmation worksheet and executes a work result update module to input the work result data and difference information indicating that there is a difference between the theoretical value data and the work result data, to the result confirmation worksheet. In addition, all data of the result confirmation worksheet is acquired by executing a verification module and is outputted to an external device by control, so that it is possible to simplify verification of an attendance state and reduce the burden on a verifier.SELECTED DRAWING: Figure 10

Description

[Technical Field]

[0001] The present invention relates to a work status verification device, a work status verification method, and a work status verification program. [Background technology]

[0002] The payroll calculation agent processing method disclosed in Patent Document 1 (JP Patent Publication No. 2003-263540) transmits daily employee attendance data from a personal computer to a server device and records it. At the end of each month, the payroll officer of the company, or an external company that has been entrusted with payroll calculations, tally up the attendance data for each employee for the current month that is recorded on the server device.

[0003] The external vendor sends the payroll source data to a computer, imports the data into the package payroll system, performs calculations, and then creates electronic forms after verifying and confirming the results.The external vendor also sends the created electronic forms to a server device for recording.The payroll staff retrieves the electronic forms from the server device and performs payroll work.

[0004] This allows the server device that manages attendance and the payroll system that performs calculations to be connected via a communications network in employee payroll calculation agency work, making it possible to improve the efficiency of payroll calculation agency work and to propose new services such as this. [Prior art documents] [Patent documents]

[0005] [Patent Document 1] Japanese Patent Application Laid-Open No. 2003-263540 Summary of the Invention [Problem to be solved by the invention]

[0006] Here, each worker has a different working style depending on, for example, the type of work they do or their position, etc. Therefore, when verifying working conditions, it is necessary to input the actual working hours and overtime hours, etc., according to each worker's working style, which places a heavy burden on the verifier.

[0007] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a work status verification device, a work status verification method, and a work status verification program that simplify the verification of work status and reduce the burden on the verifier. [Means for solving the problem]

[0008] In order to solve the above-mentioned problems and achieve the object, the work status verification device according to the present invention is a data showing the work performance of a worker, and includes work performance data including at least data on the work day, the holiday classification indicating whether the work day is a weekday or a holiday, and data on each item of actual working hours, and theoretical value data showing a standard working system including data on each item of actual working hours and holiday classification that are the standard for each work day of the worker. A result confirmation work is a storage area where input and storage are performed, and a result confirmation work including items set in the item selection master is generated in the storage unit. Result confirmation work generation part and result confirmation work Read from memory Theoretical data Enter and save Theoretical value update module is generated using a given scripting language. Theoretical value update module generation part and result confirmation work Read from memory Work performance data Input and save it, Difference information showing the difference between the theoretical value data and the actual work data Generate and store Work performance update module is generated using a given scripting language. Work performance update module generation unit and verification module that acquires all data of result confirmation work and controls output to external devices is generated using a given scripting language. The verification module generation part and the theoretical value update module are executed to check the results. Then, the data read from the memory unit is Theoretical data Enter and save , execute the work performance update module and go to the result confirmation work , read from the memory unit Work performance data , and compare the theoretical data with the actual work data for each item, and if there is a difference between the two, indicate the difference. Difference information Generate and store Run the verification module and check the results. In order to enable comparison and verification of the theoretical value data and the work performance data for each item, the theoretical value data and the work performance data are placed side by side, and an execution unit that controls output to an external device.

[0009] In order to solve the above problems and achieve the object, the present invention provides The work status verification method of the work status verification device includes: The data showing the work performance of the worker includes at least the work day, the holiday classification indicating whether the work day is a weekday or a holiday, and the data for each item of actual working hours, and theoretical value data showing the standard working system including the data for each item of actual working hours and holiday classification that are the standard for each work day of the worker. A result confirmation work is a storage area where input and storage are performed, and a result confirmation work including items set in the item selection master is generated in the storage unit. The result confirmation work generation step and the theoretical value update module generation part are Read from memory Theoretical data Enter and save Theoretical value update module is generated using a given scripting language. The theoretical value update module generation step and the work performance update module generation part are in the result confirmation work. Read from memory Work performance data Input and save it, Difference information showing the difference between the theoretical value data and the actual work data Generate and store Work performance update module is generated using a given scripting language. A work performance update module generation step, and a verification module in which the verification module generation unit acquires all data of the result confirmation work and controls output to an external device. is generated using a given scripting language. A verification module generation step, an execution unit executes the theoretical value update module to perform a result confirmation work Then, the data read from the memory unit is Theoretical data Enter and save , execute the work performance update module and go to the result confirmation work , read from the memory unit Work performance data , and compare the theoretical data with the actual work data for each item, and if there is a difference between the two, indicate the difference. Difference information Generate and store Run the verification module and check the results. In order to enable comparison and verification of the theoretical value data and the work performance data for each item, the theoretical value data and the work performance data are placed side by side, and an execution step of controlling output to an external device.

[0010] In order to solve the above-mentioned problems and achieve the object, the work status verification program of the present invention is a program for verifying work status by inputting a computer to: data showing the work performance of a worker, the data including at least work days, holiday classifications indicating whether the work day is a weekday or a holiday, and data on each item of actual working hours; and theoretical value data showing a standard work system, including data on each item of actual working hours and holiday classifications that serve as a standard for each work day of the worker. A result confirmation work is a storage area where input and storage are performed, and a result confirmation work including items set in the item selection master is generated in the storage unit.Result confirmation work generation part and result confirmation work Read from memory Theoretical data Enter and save Theoretical value update module is generated using a given scripting language. Theoretical value update module generation part and result confirmation work Read from memory Work performance data Input and save it, Difference information showing the difference between the theoretical value data and the actual work data Generate and store Work performance update module is generated using a given scripting language. Work performance update module generation unit and verification module that acquires all data of result confirmation work and controls output to external devices is generated using a given scripting language. The verification module generation part and the theoretical value update module are executed to check the results. Then, the data read from the memory unit is Theoretical data Enter and save , execute the work performance update module and go to the result confirmation work , read from the memory unit Work performance data , and compare the theoretical data with the actual work data for each item, and if there is a difference between the two, indicate the difference. Difference information Generate and store Run the verification module and check the results. In order to enable comparison and verification of the theoretical value data and the work performance data for each item, the theoretical value data and the work performance data are placed side by side, It functions as an execution unit that controls output to external devices. [Effects of the Invention]

[0011] The present invention can simplify the verification of work status and reduce the burden on the verifier. [Brief explanation of the drawings]

[0012] [Figure 1] FIG. 1 is a block diagram showing a hardware configuration of a working status verification device according to an embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of work performance data. [Figure 3] FIG. 3 is a diagram showing an example of theoretical value data by work type. [Figure 4] FIG. 4 is a diagram illustrating an example of the item selection master. [Figure 5] FIG. 5 is a diagram illustrating an example of the work performance master. [Figure 6] FIG. 6 is a diagram illustrating an example of the input layout table. [Figure 7]FIG. 7 is a diagram showing an example of the result confirmation work in a state where theoretical value data has been input. [Figure 8] FIG. 8 is a diagram showing an example of the work status verification screen. [Figure 9] FIG. 9 is a diagram showing an example of a result confirmation work in which theoretical value data and actual work data are input and the difference between the two is verified. [Figure 10] FIG. 10 is a diagram showing an example of the work status verification screen in which each data item of the result confirmation work is displayed. DETAILED DESCRIPTION OF THE INVENTION

[0013] Hereinafter, a working status verification device according to 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 the following embodiment.

[0014] (overview) When introducing an employment system, various work patterns are entered into the work schedule and it is verified that the hours and days are counted correctly. For example, for a worker who works 7.5 hours (with a 1-hour break) between 9:00 and 17:30, the verifier: Whether the work performed in excess of the standard working hours (7.5 hours) is less than the legal working hours of 8 hours, · Whether or not work exceeds legal working hours, · Whether or not you work late at night (from 22:00), ·Whether you work beyond 12:00 AM until the next day, · Whether the next day is a scheduled holiday or not · Whether the next day is a statutory holiday, · Whether or not you are working on a holiday, Many patterns such as these need to be verified.

[0015] In addition, the verifier must verify many patterns, such as whether or not leave is taken in one-day units, half-day units, or hourly units, as well as whether or not overtime is worked. Furthermore, the verifier must also verify working systems such as reduced-hours workers or hourly wage workers.

[0016] Because verification of such a large number of patterns is required, pattern verification of the work schedule (verification of work status) places a heavy burden on the verifier.

[0017] On the other hand, because the time and day items managed by the employment system differ from company to company, the layout of the work schedule also differs from company to company. Furthermore, even within the same company, the layout of the work schedule may differ between the management department and the field department, or between part-time workers and hourly wage employees, etc.

[0018] In particular, in multi-business companies, the layout of work schedules can differ for each work system. For this reason, work schedule pattern verification (work status verification) must be carried out using multiple work schedule layouts, and multiple patterns must be input to match each layout and compared for verification.

[0019] For these reasons, verifying work schedule patterns (verifying work status) places a heavy burden on the verifier.

[0020] Furthermore, if work schedule patterns are not verified accurately, working hours or working days will not be calculated correctly, making it difficult to calculate working hours for the purposes of labor-management agreements (the so-called 36 Agreement) or health management as stipulated in Article 36 of the Labor Standards Act. Linking incorrect hours or days to the payroll system could result in incorrect payments and undermine the trust of workers.

[0021] Furthermore, if a defect is discovered in the calculation logic after performing a pattern verification of the work schedule (verification of work status), the defective calculation logic must be corrected and then the pattern verification of the work schedule (verification of work status) must be performed again. In this case, correcting the calculation logic may result in another defect. For this reason, after correcting the calculation logic, it is necessary to review the correctness of all items, including items that were correct in the previous verification.

[0022] In the embodiment, the work status verification device first imports theoretical values ​​(correct number of days or hours, etc.) into the work status verification device. The work pattern to be verified (actual work data) is then input into the work status verification device, which then performs calculation processing. The imported theoretical values ​​and the values ​​calculated by the work status verification device are then extracted, and a comparison is made between the two to check for any discrepancies.

[0023] Since the layout of work schedules differs depending on the company and work system, there is a concern that it may be difficult to capture theoretical values. However, in the case of the work status verification device of the embodiment, by processing using the column names of the work schedule as a key, it is possible to accommodate various work schedule layouts.

[0024] The format of the work schedule is also free-form, making it easy to create and manage theoretical values. It also allows for comparative verification of work schedules with layouts for each company or work system. Furthermore, by displaying the results of a comparison between the theoretical values ​​and actual work data (the difference information described below), the burden on the verifier who re-verifies the data after correcting any flaws in the calculation logic is reduced.

[0025] (Hardware configuration) As shown in FIG. 1, the working status verification device 1 of the embodiment includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 corresponds to a display unit such as a monitor device (including a home television), a printing device, or a speaker device. The input device 6 may be a keyboard device, a mouse device, a microphone device, or a monitor device that functions as a pointing device in cooperation with a mouse device. The communication interface unit 4 is connected to a network, for example, a wide area network such as the Internet or a private network such as a local area network (LAN).

[0026] A storage device such as a ROM (Read Only Memory), RAM (Random Access Memory), HDD (Hard Disk Drive), or SSD (Solid State Drive) can be used as the storage unit 2. The storage unit 2 stores a work status verification program that simplifies the verification of work status and reduces the burden on the verifier.

[0027] The storage unit 2 also stores an item selection master 11, a work performance master 12, an input layout table 13, and a result confirmation work 14. The storage unit 2 also stores theoretical value data and work performance data set or input by a verifier, etc. The storage unit 2 also stores a table script, a work performance update module, a theoretical value update module, and a verification module, each of which is generated by a script generation unit 26, which will be described later.

[0028] Work performance data is data that shows the work performance of a worker, and as shown in Figure 2, it includes items such as attendance company code, employee code, work date, arrival time, departure time, break time, holiday classification, all-day reason, actual working hours, statutory holiday hours, number of special work shifts, and remarks.

[0029] "Notes" represents a verification pattern, and is used to check whether the intended work has been entered by comparing the theoretical value data with the notes of the work performance data.

[0030] Although not shown in Figure 2, the work performance data also includes a long-term business trip allowance item, which is paid by multiplying the daily rate when a long-term business trip occurs. In this long-term business trip allowance item, "1" is entered when a long-term business trip occurs (the default value is "0 (no long-term business trip)").

[0031] "Holiday classification" is information indicating whether the workday is a weekday or a holiday, and is entered as "legal holiday" or "weekday" as shown in Figure 2, as an example.

[0032] The actual working hours are calculated by the working status verification device 1 as "actual working hours = working time - working time - break (1 hour)" and automatically input.

[0033] The non-legal working hours are calculated by the working status verification device 1 as "non-legal working hours = actual working hours - 8:00 <rounded up to 0 if negative>" and automatically input.

[0034] In addition, for managerial workers, instead of accruing non-statutory hours and statutory holiday hours, special work allowances are paid according to the number of times they work six hours or more on holidays (special work count). For this reason, the work performance data for managerial workers includes a field for entering the "number of special work counts."

[0035] The items of attendance company code, employee code, working date, and holiday classification are automatically input by the system side, which is the working status verification device 1 of the embodiment.

[0036] In contrast, the items of arrival time, departure time, break time, reason for all-day work, and remarks are items that are input by the verifier, etc. via the work performance input screen displayed by the display control unit 28.

[0037] In addition, the actual working hours, the hours on statutory holidays, and the number of special working hours are items that are calculated and input by the system side, which is the working status verification device 1 of the embodiment.

[0038] Theoretical value data is data that indicates a standard work system. Figure 3 shows an example of this theoretical value data. Of these, Figure 3(a) is theoretical value data for a regular employee with a fixed labor contract (general position), and is composed of the following fields: working company code, employee code, working day, holiday classification, all-day reason, actual working hours, non-legal hours, statutory holiday hours, and remarks. The working company code, employee code, and working day fields are fixed and required fields, and are used as conditions for internal joins with the work performance table described below. The other fields, namely, holiday classification, all-day reason, actual working hours, non-legal hours, statutory holiday hours, and remarks, are free-format fields.

[0039] Furthermore, "Notes" represents a verification pattern, and is used to check whether the intended work has been entered by comparing the theoretical value data with the notes of the work performance data.

[0040] Figure 3(b) shows theoretical data for a managerial employee with a fixed labor contract (general position), and includes the following fields: company code, employee code, working day, holiday category, all-day reason, actual working hours, statutory holiday hours, special working hours, and remarks. As mentioned above, "special working hours" is a special working allowance paid according to the number of times a managerial employee works six hours or more on a holiday (special working hours). The number of times a managerial employee works six hours or more on a holiday (special working hours) is entered in the "special working hours" field.

[0041] In this theoretical data for managerial employees with fixed labor contracts (general positions), the fields for company code, employee code, and work date are fixed and required, and are used as conditions for internal joins with the work performance table described below. Furthermore, the other fields, such as holiday classification, all-day reason, actual working hours, statutory holiday hours, special work count, and remarks, are free-format fields.

[0042] Figure 3(c) shows theoretical data for regular employees with variable labor contracts (technical positions), and includes the following items: company code, employee code, working day, shift, scheduled working hours, actual working hours, overtime, number of dangerous work tasks, and remarks. In the case of variable labor, the scheduled working hours per day vary depending on the working day, and the number of dangerous work tasks is counted according to the shift, and allowances are paid accordingly.

[0043] In this theoretical data for regular employees with modified labor contracts (technical positions), the fields for company code, employee code, and work date are fixed and required, and are used as conditions for internal joins with the work performance table described below. Furthermore, the other fields, such as shift, scheduled working hours, actual working hours, overtime, number of dangerous work assignments, and remarks, are free-format fields.

[0044] The item selection master 11 is a master that is combined with an input layout table that is generated by using the item names of the theoretical value data as column header names, as will be described later, and is created by an administrator or a verifier, etc. As shown in Fig. 4, this item selection master 11 includes items such as table name, field name, item name, and type. The value of each item is set in advance by an administrator or a verifier, etc.

[0045] "Type" indicates the input format (notation format) for each item. In the example of Figure 4, for example, "Number" input is set for the "Attendance Company" item, "Character" input is set for the "Employee" item, "Date" input is set for the "Workday" item, and "Number" input is set for the "Actual Working Hours" item.

[0046] The work performance master 12 is configured to include the following items: field name, type, whether or not NULL is allowed (Nullable), and default value (Default), as shown in Fig. 5. Whether or not NULL is allowed (Nullable) is data indicating whether or not NULL data, which indicates that no value is in the type, can be set for the item of that field name, and is set to either "False (not allowed)" or "True (allowed)."

[0047] (Functional configuration of the work status verification device) Next, the control unit 3 executes the work status verification program stored in the memory unit 2, and thereby functions as a data generation unit 21, an acquisition unit 22, a combination processing unit 23, an identification unit 24, a judgment unit 25, a script generation unit 26, a script execution unit 27, and a display control unit 28, as shown in FIG. 1.

[0048] The data generation unit 21, the acquisition unit 22, the combination processing unit 23, the identification unit 24, the determination unit 25, and the script generation unit 26 are an example of a result confirmation work generation unit. This result confirmation work generation unit generates result confirmation work into which the above-mentioned work performance data, which is data indicating the work performance of a worker, and theoretical value data indicating a standard work system are input.

[0049] The script generation unit 26 is an example of a theoretical value update module generation unit, a work performance update module generation unit, and a verification module generation unit. The script generation unit 26 functions as a theoretical value update module generation unit to generate a theoretical value update module that inputs theoretical value data into the result confirmation work. The script generation unit 26 also inputs work performance data into the result confirmation work and generates a work performance update module that inputs difference information indicating that there is a difference between the theoretical value data and the work performance data. The script generation unit 26 also functions as a verification module generation unit to generate a verification module that acquires all data from the result confirmation work and controls output to an external device.

[0050] The script execution unit 27 is an example of an execution unit. The execution unit executes a theoretical value update module to input theoretical value data into the result confirmation work, and executes a work performance update module to input work performance data and difference information into the result confirmation work. The execution unit then executes a verification module to obtain all data from the result confirmation work and controls output to an external device.

[0051] The external device corresponds to the output device 7 shown in Fig. 1. When the result confirmation work is to be displayed, the result confirmation work is output to and displayed on the output device 7, which is a display unit. When the result confirmation work is to be printed, the result confirmation work is output to and printed on the output device 7, which is a printer. When the result confirmation work is to be output as audio, audio data of the result confirmation work is output to the output device 7, which is a speaker device, and audio output is obtained.

[0052] The data generation unit 21, acquisition unit 22, combination processing unit 23, identification unit 24, judgment unit 25 and script generation unit 26, which are examples of result confirmation work generation units, generate result confirmation work in which an optional item is connected so that it follows an item in the before-after category into which pre-information indicating that the input data is theoretical value data or post-information indicating that the input data is work performance data is input, and a difference item into which the above-mentioned difference information is input.

[0053] The script generation unit 26 functions as a theoretical value update module generation unit, and when theoretical value data is input into the result confirmation work, it inputs previous information indicating that the input data is theoretical value data into the items in the previous and next categories of the result confirmation work.

[0054] In addition, the script generation unit 26 functions as a work performance update module generation unit, and when entering work performance data into the result confirmation work, enters post-information indicating that the entered data is work performance data into the items in the pre- and post-categories of the result confirmation work.

[0055] The script execution unit 27, which is an example of an execution unit, controls the output of result confirmation work by rearranging the theoretical value data and work performance data so that related theoretical value data and work performance data are adjacent to each other when controlling the output of result confirmation work.

[0056] (Work status verification operation) Next, we will explain the verification operation of the work status in the work status verification device 1 of this embodiment. The control unit 3 of the work status verification device 1 executes the work status verification program stored in the storage unit 2, thereby functioning as the data generation unit 21 to the display control unit 28, etc., and realizing the verification operation of the work status described below.

[0057] First, the verifier specifies verification of work status via the input device 6 and selects the worker whose work status will be verified. As an example, let's assume that a managerial employee with a fixed labor contract (career track) and employee code "100002" is selected through this selection operation. In this case, the control unit 3 functions as the acquisition unit 22 based on the work status verification program, and acquires the theoretical value data of the managerial employee with a fixed labor contract (career track) and employee code "100002" shown in FIG. 3(b) from the theoretical value data shown in FIG. 3.

[0058] The data generation unit 21 acquires the column header names of the acquired theoretical value data and generates an input layout table 13 with the column header names entered, as shown in Fig. 6. In this example, the column header names acquired from the theoretical value data of a managerial employee with a fixed labor contract (general position) are the column header names for attendance company, employee, working day, holiday classification, all-day reason, actual working hours, statutory holiday hours, special working count, and remarks. The data generation unit 21 generates an input layout table 13 with these column header names entered, as shown in Fig. 6.

[0059] Next, the merge processing unit 23 merges the items set in the item selection master 11 with the input layout table 13, using the merge condition "column header name of input layout table 13 = item name in item selection master 11 of FIG. 4." The identification unit 24 identifies the table name, field name, and type of the item. The identification unit 24 also references the work performance master 12 shown in FIG. 5 and identifies whether NULL is allowed (Nullable).

[0060] Next, the determination unit 25 refers to the work performance master 12 based on the acquired table name and field name, and determines whether each item has a Nullable or Default constraint.

[0061] Next, the script generation unit 26 generates a table script for the result confirmation work from this information. As an example, the script generation unit 26 generates the table script for the result confirmation work using a script language such as "JavaScript (registered trademark)," "Python (registered trademark)," "Ruby," or "Hypertext Preprocessor (PHP)." The generated table script is stored in the storage unit 2.

[0062] Next, the script execution unit 27 executes the table script stored in the storage unit 2 to generate the result confirmation work 14 shown in Fig. 7. Specifically, as shown in Fig. 7, the script execution unit 27 generates the result confirmation work 14 by adding three items, "row number (row No.)," "before / after classification," and "difference," following the fixed and required items of working company code, employee code, and working date. Then, following these three items, the optional items of holiday classification, all-day reason, actual working hours, statutory holiday hours, special working count, and remarks are added to generate the result confirmation work 14.

[0063] In other words, the script execution unit 27 inserts the three items "line number (line No.)", "preceding and following division", and "difference" before the optional items to generate the result confirmation work 14. In this way, by making the three items "line number (line No.)", "preceding and following division", and "difference" and onwards optional items, the logic for generating the table script can be simplified, and the table script can be automatically generated quickly.

[0064] Next, the script generation unit 26 generates a "theoretical value update module," which is a script that inputs theoretical value data into the generated result confirmation work 14, and stores the generated module in the storage unit 2. The script language used to generate the "theoretical value update module" is, as described above, a script language such as "JavaScript (registered trademark)" or "Python (registered trademark)."

[0065] The script execution unit 27 executes the generated "theoretical value update module" and inputs the values ​​of the theoretical value data (in this example, the values ​​of each item in FIG. 3(b)) into the result confirmation work 14, as shown in FIG. 7. At this time, the script execution unit 27 automatically assigns and inputs the line number of the theoretical value data into the line number field. Also, since the data input at this stage is theoretical value data, the script execution unit 27 inputs "previous information" into the fields in the before and after category. At this stage, since the comparison between the theoretical value data and the actual work data described below has not yet been made, the script execution unit 27 leaves the difference field "blank" and inputs the values ​​of the corresponding items of the theoretical value data into the other fields.

[0066] Next, the script generation unit 26 refers to the item selection master 11 shown in Figure 4 to generate a "work performance update module," which is a script that adds and updates the work performance data shown in Figure 2 to the result confirmation work 14, and stores it in the memory unit 2.

[0067] In addition, the script generation unit 26 refers to the item selection master 11 shown in Figure 4 to generate a ``verification module,'' which is a script that acquires all records of the result confirmation work 14 and data for all items, and stores it in the memory unit 2.

[0068] Next, the verifier operates the input device 6 to specify the display of the work status verification screen. As a result, the display control unit 28 displays the work status verification screen shown in Fig. 8 via the output device 7. This work status verification screen includes a display button 50 for specifying the display of verification data, and a display area for the verification data.

[0069] When the verifier operates the display button 50 on this work status verification screen, the script execution unit 27 executes the work performance update module and obtains the work performance data corresponding to the theoretical value data previously entered from the work performance table shown in Fig. 2. Then, as shown in Fig. 9, the script execution unit 27 generates a result confirmation work 14 by connecting each record of the work performance data in the column direction following the record of the theoretical value data.

[0070] Specifically, the script execution unit 27 refers to the data table storing the work performance data shown in Fig. 2 using three conditions: "work performance company code," "employee code," and "work date." Then, it internally joins the acquired work performance data to generate the result confirmation work 14 shown in Fig. 9.

[0071] In this way, by using "work date" as a condition for the internal join between the result confirmation worksheet 14 and the data table of the work performance data, the period to be compared is limited to the period entered in the theoretical value data. Therefore, the work status verification device 1 can be used by narrowing down the patterns not only when the embodiment of the work status verification device 1 is introduced, but also when systems are revised after the introduction of time off or the start of teleworking, etc.

[0072] Furthermore, the script execution unit 27 updates the line number with the line number of the result confirmation work 14 when the internal join is performed, and updates the item of the before / after category with "after."

[0073] Furthermore, the script execution unit 27 compares the values ​​of each field of the result confirmation work 14 when the internal join is performed with the work performance data, and if there is a difference, it inputs predetermined difference information such as "x" into the corresponding difference information item, as shown in Fig. 9. In the example of Fig. 9, the value of the special work frequency item in the theoretical value data is "1 (times)", while the value of the special work frequency item in the work performance data is "0 (times)", so there is a difference between the two values. In such a case, the script execution unit 27 inputs difference information of "x" into the input field for the difference item of the theoretical value data and the input field for the difference item of the work performance data.

[0074] Next, the script execution unit 27 executes the verification module and acquires data for all records and all items of the result confirmation work 14 into which the theoretical value data and corresponding work performance data have been input, as shown in Fig. 9. The script execution unit 27 also generates a result confirmation work 14 in which the theoretical value data and work performance data have been rearranged so that related theoretical value data and work performance data are adjacent to each other. The script execution unit 27 then displays this rearranged result confirmation work 14 as verification data in the verification data display area of ​​the work status verification screen, as shown in Fig. 10.

[0075] That is, when the script execution unit 27 acquires data for all records and all items of the result confirmation work 14 into which theoretical value data and corresponding actual work data have been input, it generates a result confirmation work 14 in which a theoretical value data record in which the number of special work hours is "1 (times)" and difference information of "x" has been input in the difference field and a work result data record related to this in which the number of special work hours is "0 (times)" and difference information of "x" has been input in the difference field are rearranged so that they are adjacent to each other in the column direction, as shown in Fig. 10. The script execution unit 27 also rearranges other related records in the same way to generate the result confirmation work 14.

[0076] Then, the script execution unit 27 displays the generated result confirmation work 14 as verification data in the verification data display area of ​​the work status verification screen shown in Fig. 10. This makes it possible to easily recognize and compare differences between the theoretical value data and the actual work performance data.

[0077] (Effects of the embodiment) As is clear from the above explanation, the work status verification device 1 of the embodiment imports theoretical values ​​(correct number of days or hours, etc.) and also imports the input work pattern to be verified (actual work data), and performs calculation processing. The imported theoretical values ​​and the values ​​in the table calculated by the work status verification device are then extracted, and the two are compared to verify whether any discrepancies have occurred. This simplifies the verification of work status and reduces the burden on the verifier.

[0078] Furthermore, by processing using the column names of the roster as a key, it is possible to accommodate various roster layouts. The roster format can also be free-form, making it easier to create and manage theoretical values. It also makes it possible to compare and verify roster layouts for each company or work system.

[0079] In addition, by displaying the results of a comparison between the theoretical value and the actual work performance data (the difference information described below), the burden on the verifier who re-verifies the data after correcting any defects in the calculation logic can be reduced.

[0080] Furthermore, by using "work days" as a condition when internally joining the result confirmation worksheet 14 and the data table of the work performance data, the period to be compared can be limited to the period entered in the theoretical value data. Therefore, the work status verification device 1 can be used by narrowing down the patterns not only when the embodiment of the work status verification device 1 is introduced, but also when systems are revised after the introduction of time off or the start of teleworking, etc.

[0081] [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 Goals 8 and 9 of the SDGs.

[0082] 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.

[0083] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to Goal 16 of the SDGs.

[0084] [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.

[0085] 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.

[0086] 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.

[0087] Furthermore, with regard to the working status verification device 1, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0088] For example, all or any part of the processing functions of the work status verification device 1, particularly the control unit 3 and the processing functions performed by the control unit 3, may be implemented by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be implemented as 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 work status verification device 1 as needed. That is, a storage unit such as a ROM or HDD stores a computer program that works with the OS to issue instructions to the CPU and perform various processes. The computer program is executed by being loaded into RAM, and works with the CPU to constitute the control unit 3.

[0089] In addition, the work status verification program of this work status verification device 1 may be stored in another server device connected to the work status verification device 1 via any network, and all or part of it may be downloaded as needed.

[0090] The work status verification program for executing the process described in this embodiment may be stored on 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), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical Disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray Disc (Blu-ray Disc).

[0091] Furthermore, a "program" is a data processing method written in any language or description method, and does not matter whether it is in source code, binary code, or other format. Note that a "program" is not necessarily limited to a single structure, but also includes a distributed structure consisting of multiple modules or libraries, or a structure that achieves its function by working in conjunction with a separate program, such as an OS. Note that the specific structure and reading procedure for reading a recording medium in the work status verification device 1 described in the embodiment, as well as the installation procedure after reading, can use well-known structures and procedures.

[0092] The memory unit 2 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, and web page files used for various processes and providing websites.

[0093] The working status verification device 1 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 information processing device may also be realized by installing software (including programs or data) that realizes the processing described in this embodiment.

[0094] 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 according to various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

[0095] The present invention is suitable for application to industries such as IT (Information Technology) media and construction work, for example. [Explanation of symbols]

[0096] 1. Work status verification device 2 Storage section 3. Control Unit 4. Communication interface section 5 Input / output interface section 6 Input Devices 7 Output Devices 11 Item Selection Master 12 Work performance master 13 Input Layout Table 14 Result confirmation work 21 Data Generation Unit 22 Acquisition Department 23. Joint processing section 24 Specific section 25 Judgment section 26 Script Generation Section 27 Script execution section 28 Display control unit 50 Display button

Claims

1. a result confirmation work generating unit that generates in the storage unit a result confirmation work that includes items set in the item selection master; a result confirmation work that is a memory area into which is input and stored data indicating the work performance of a worker, the work performance data including at least the work day, the holiday classification indicating whether the work day is a weekday or a holiday, and data for each item of actual working hours, and theoretical value data indicating a standard working system, including the standard actual working hours for each work day of the worker and data for each item of the holiday classification; and a theoretical value update module generation unit that generates, using a predetermined script language, a theoretical value update module that inputs and stores the theoretical value data read from the storage unit into the result confirmation task; a work performance update module generation unit that uses a predetermined script language to generate a work performance update module that inputs and stores the work performance data read from the storage unit into the result confirmation work, and generates and stores difference information indicating that there is a difference between the theoretical value data and the work performance data; a verification module generation unit that generates a verification module that acquires all data of the result confirmation work and controls output to an external device using a predetermined script language; an execution unit that executes the theoretical value update module to input and store the theoretical value data read from the storage unit into the result confirmation work, executes the work performance update module to input and store the work performance data read from the storage unit, and compares the theoretical value data with the work performance data for each item in the result confirmation work, and if there is a difference between the two, generates and stores the difference information indicating the difference, and executes the verification module to control output of the theoretical value data and the work performance data to an external device in a state where they are adjacent to each other so as to enable comparison and verification of the theoretical value data and the work performance data for each item in the result confirmation work; A work status verification device having the above.

2. the result confirmation work generation unit stores in the result confirmation work, as items of the work performance data and the theoretical value data, items of a previous / next classification into which previous information indicating that the data input by the theoretical value update module is theoretical value data or items of subsequent information indicating that the data input by the work performance update module is work performance data, and optional items connected so as to follow the difference items into which the difference information is input; 2. The working status verification device according to claim 1,

3. When the theoretical value update module generation unit inputs and stores the theoretical value data in the result confirmation work, it inputs and stores previous information indicating that the input data is theoretical value data in the items of the previous and next classification of the result confirmation work, the work performance update module generation unit, when inputting and storing the work performance data into the result confirmation work, inputs and stores subsequent information indicating that the input data is work performance data into the items of the previous and next classification of the result confirmation work; 3. The working status verification device according to claim 2, wherein:

4. when controlling the output of the theoretical value data and the work performance data of the result confirmation work, the execution unit rearranges and controls the output of the theoretical value data and the work performance data so that the theoretical value data and the work performance data including the difference information are adjacent to each other; 4. The working status verification device according to claim 3,

5. A result confirmation work generation step in which the result confirmation work generation unit generates in the memory unit a result confirmation work that is a memory area into which is input and stored data showing the work performance of a worker, the work performance data including at least the work day, the holiday category indicating whether the work day is work on a weekday or a holiday, and data for each item of actual working hours, and theoretical value data showing a standard working system including the actual working hours that serve as the standard for each work day of the worker and data for each item of the holiday category, and the result confirmation work that has items set in the item selection master; a theoretical value update module generation step in which a theoretical value update module generation unit generates, using a predetermined script language, a theoretical value update module that inputs and stores the theoretical value data read from the storage unit into the result confirmation task; a work performance update module generation step in which a work performance update module generation unit uses a predetermined script language to generate a work performance update module in which the work performance data read from the storage unit is input into the result confirmation work and stored, and difference information indicating that there is a difference between the theoretical value data and the work performance data is generated and stored; a verification module generating step in which a verification module generating unit generates, using a predetermined script language, a verification module that acquires all data of the result confirmation work and controls output to an external device; an execution step in which an execution unit executes the theoretical value update module to input and store the theoretical value data read from the storage unit into the result confirmation work, executes the work performance update module to compare the work performance data read from the storage unit and the theoretical value data with the work performance data for each item in the result confirmation work, and if there is a difference between the two, generates and stores the difference information indicating the difference, and executes the verification module to control output of the theoretical value data and the work performance data to an external device in a state where they are adjacent to each other so as to enable comparison and verification of the theoretical value data and the work performance data for each item in the result confirmation work; A work status verification method for a work status verification device having the above-mentioned features.

6. Computer, a result confirmation work generating unit that generates in the storage unit a result confirmation work that includes items set in the item selection master; a result confirmation work that is a memory area into which is input and stored data indicating the work performance of a worker, the work performance data including at least the work day, the holiday classification indicating whether the work day is a weekday or a holiday, and data for each item of actual working hours, and theoretical value data indicating a standard working system, including the standard actual working hours for each work day of the worker and data for each item of the holiday classification; and a theoretical value update module generation unit that generates, using a predetermined script language, a theoretical value update module that inputs and stores the theoretical value data read from the storage unit into the result confirmation task; a work performance update module generation unit that uses a predetermined script language to generate a work performance update module that inputs and stores the work performance data read from the storage unit into the result confirmation work, and generates and stores difference information indicating that there is a difference between the theoretical value data and the work performance data; a verification module generation unit that generates a verification module that acquires all data of the result confirmation work and controls output to an external device using a predetermined script language; execute the theoretical value update module to input and store the theoretical value data read from the storage unit into the result confirmation work, execute the work performance update module to input and store the work performance data read from the storage unit, and compare the theoretical value data with the work performance data for each item into the result confirmation work, and if there is a difference between the two, generate and store the difference information indicating the difference, execute the verification module to function as an execution unit that controls output to an external device with the theoretical value data and the work performance data adjacent to each other so as to enable comparison and verification of the theoretical value data and the work performance data for each item in the result confirmation work, A work status verification program featuring:

Images