JP2002304503A - Working data management system and its method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a system capable of accurately and easily realizing the unitary management of the working data of staffs. SOLUTION: In this working data management system having a terminal for inputting working data, a data base and a server, the terminal and the data base and the server are connected to a network, and the server is constituted of a Web server and a Web application, and the data base is classified into a plurality of masters, and the matching of the data inputted to the terminal and the data stored in the data base is confirmed, and the approved data are stored in the data base.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention manages employee work data using data (affiliation group, work contents, working hours, paid holidays, transfer holidays, etc.) on all employees registered in a database. The present invention relates to a system and a method for managing employment data.

[0002]

2. Description of the Related Art Conventionally, management of employee employment data (application items such as working hours, working forms, late / early leave, etc.)
A method in which each employee enters his / her own employment data in the distributed employment data entry form, and the employee who specializes in clerical work approves and manages the consistency of the employment data. A method of collecting personal data in a bar code in advance and inputting work data as described in Japanese Patent Application Laid-Open No. Hei 5-274508, and inputting the data into a database storing work rules. Methods such as confirmation and judging the validity of the data have been adopted.

[0003] However, if the number of employees decreases or the need to adopt various forms of work arises in business, the management method as described above complicates understanding and management of employee's work data. It takes time to check the consistency. In addition, when managing work data in writing, it is necessary to keep the written data in order to protect the data, and when the number of employees increases, it is necessary to secure resources and a storage place for the written data. was there. The employment data itself must be accurately managed because it is also used for salary and bonus calculations.

[0004] Even when managing work data with a computer (for example, a personal computer), if the work data management system is incorporated in each computer as software, the version of the management system is updated. In this case, it is necessary to update the software of the new employment data management system to all terminals that input employment data, and if the number of terminals increases with the number of employees, the system of all terminals will be updated. Takes a lot of time and effort.

[0005] Further, it is conceivable that the work place is scattered not only in one place but also in various places in the whole country. If employment data cannot be centrally managed in this way, employment data of employees who work in each branch must be compiled for each branch, and then approved, confirmed, counted, and stored again at the head office. However, there is a problem that it takes time and effort.

[0006]

SUMMARY OF THE INVENTION In order to solve the above-mentioned problems, an object of the present invention is to provide a system which can more accurately and easily manage employment data of employees in a unified manner.

[0007]

The present invention relates to an employment data management system having a terminal for inputting employment data, a database and a server, wherein the terminal, the database and the server are connected to a network, The server is composed of a Web server and a Web application, and the database is classified into an employee data master, a transfer attendance master, a department master, a job type master, a work data list master, a work management department master, a paid leave master, and a company holiday master. And confirming and approving in the Web application the consistency between the data input at the terminal and the data stored in the database, and storing the approved data in a database. Management system .

[0008] In the above-mentioned employment data management system, the terminal can input employment data by using any personal computer having a Web browser.

[0009] In the work data management system, the network may be a LAN (Local Area Network).
k) or a WAN (Wide Area Network).

[0010] Further, the employment data management system is characterized in that employment data and application items can be inputted and referred to without any terminal as long as the terminal is connected to the network.

Further, the present invention provides a first method for inputting a User ID and a password from a terminal connected to a network.
Step, by the User ID and password, identify the employee from the data stored in the database,
A second step of approving the consistency of the processing contents operable by the employee, a third step of displaying a screen for prompting entry of employment data on the terminal, confirming the consistency of the entered employment data and approving If it is determined that the employment data is possible, a fourth step of storing the employment data in the employment data list master and a fifth step of storing the employment data for which the approval authority processing operation has been completed in the employment data list master are included. It is a management method.

Also, the present invention provides a first method for inputting a User ID and a password from a terminal connected to a network.
Step, by the User ID and password, identify the employee from the data stored in the database,
A second step of approving the consistency of the process contents operable by the employee, a third step of displaying a screen prompting daily input processing of the work data on the terminal, and confirming the consistency of the inputted work data. If it is determined that approval is possible, the fourth step of storing the employment data in the employment data list master, the fifth step of storing the employment data for which the approval authority processing operation has been completed in the employment data list master, the data of which the month-end processing operation has been completed A sixth step of storing the data on which the end-of-month approval authority processing operation has been completed in the employment management section master; a seventh step of storing the data on which the end-of-month approval authority processing operation has been completed on the employment management section master. The ninth step of storing the data on which the final protection processing operation has been completed in the employment management department master. A work data management method, which comprises a.

[0013] In the above employment data management method,
The second step is characterized by including a step of displaying a screen dedicated to approval authority on a terminal input by an employee determined to be capable of performing approval authority processing in addition to the work data input processing.

[0014] In the above work data management method,
The second step is characterized by including a step of displaying a screen dedicated to general affairs authority on a terminal input by an employee determined that the approval authority processing operation and the final protection operation are possible.

Further, the present invention is characterized in that work data can be managed from any terminal connected to any network and having a Web browser, regardless of operable processing contents. I have.

[0016] In this specification, a Web application refers to data input by a Web browser.
The received data is received via the web server and stored in a database or recorded in a file to construct necessary data, and the constructed data is transmitted to the web server via the web server.
b Refers to an application for returning to the browser.

[0017]

DESCRIPTION OF THE PREFERRED EMBODIMENTS (Embodiment 1) In this embodiment, management in an employment data management system according to the present invention will be described by taking an example of an employee who has performed normal business and overtime for two hours.

This work data management system has a terminal 1 (a plurality of terminals are connected to a network 6) for inputting work data, a database 2, and a server 3, and is connected to the network 6. . The server 3
Has a Web server 4 and a Web application 5. The terminal 1 includes a display unit, an input unit (keyboard,
Mouse) and a Web browser. Each employee:
1. Enter personal employment data from the terminal 1. Although FIG. 1 shows the database 2 and the server 3 separately, the database 2 can be incorporated in the same server 3. In the present invention, the database 2 includes an employee data master, a transfer attendance master, a department (group) master, a job type master, an employment data list master, an employment data list 2 master, an employment management section master, a paid master, and a company holiday. Classified as Master. In the present invention, there is no problem even if the number of terminals for inputting data is smaller than the number of employees.

The work data of the employee (who does not have the approval authority) on January 26, 2001 shown in the present embodiment is as follows: "Work form: regular work (for example, 9:00 to 17:
45), Overtime: 18:00 to 20:00, Break: 17: 00
45 to 18:00 ”.

The employee connects to the page of the employment data management system using the Web browser of a terminal connected to the network 6 (s1 in FIG. 2). Then, on the displayed screen (FIG. 3), an employee number (User ID) and password set in advance are input (s2 in FIG. 2). Based on the User ID and password entered by the employee, can the data stored in the database 2 (employee data master, department master, job type master) be consistent?
b. Confirmation in the application 5 (s3 in FIG. 2), and when it is confirmed that the employee is an employee who does not have special authority such as approval, a screen for selecting a month for inputting employment data (FIG. 4). Is displayed. Here, if it is determined that the employee has special authority, a special screen for special authority is displayed.

When the screen shown in FIG. 4 is displayed, a month for which employment data is to be input is selected. For example, when the user wants to input data on January 26, 2001, the user selects January in this screen. Subsequently, a work card display button (FIG. 4) is selected to display a list of work data, and the screen of FIG. 11 is displayed. Subsequently, a day button (FIG. 11) for inputting employment data, for example, a day button on the 26th is selected to display an employment data input screen as shown in FIG. 5 (FIG. 2).
s4).

First, a work mode is selected (in this embodiment,
Normal work is selected), work start time and work end time are input, and break time is selected. Break time is 15
The selection can be made in minute increments, but in this case, the practitioner may appropriately determine and set. However, when the regular work is selected in the work form, the start time of overtime work (18:00 in this embodiment) is automatically input. Input of the overtime end time (in this embodiment, 20: 0
0), selection of break time (00:15 in this embodiment)
And select the registration correction button (s5 in FIG. 2).

The work mode includes shift work, transfer work, and work on holidays in addition to the normal work, and the work start time and the work end time are input, and the break time is selected. Items that need to be input (work style, etc.) according to the work rules can be changed as appropriate. Further, when it is necessary to take a transfer holiday after overtime of 8 hours, in addition to the input of the work start time and the work end time and the selection of the break time, the transfer holiday scheduled date is also required to be input.

When the employee enters the employment data and selects the registration correction button, the Web server checks the consistency between the entered data and the data registered in the database such as the group to which the employee belongs and the job type ( FIG. 2s6). When the registration correction button is selected, the consistency is confirmed, and the employment data is approved, the employment data entered by the employee is
Stored in the work data list master.

If the number of overtime hours exceeding the prescribed number of overtime hours (for example, within 50 hours per month) is entered, or if there are missing items to be entered, the data entered by the employee is not consistent. In this case, an error message is displayed (FIG. 2s
7). If an error message is displayed, input the employment data again.

When the consistency is confirmed, a message is displayed indicating that the data registration has been completed. When the OK button is selected, a list of the employment data is displayed (FIG. 2s).
8).

Next, the manager of each department (having the approval authority for the employees belonging to the department, hereinafter referred to as the superior) approves the daily work data entered by each employee. The method will be described.

The superior connects to the employment data management system from the Web browser of a terminal connected to the company network. In the displayed screen (FIG. 3), input a preset employee number (User ID) and a password (FIG. 2s2), and enter a database (Employee Data Master,
Department master, job type master)
When the web application 5 confirms that the user has the superior authority (s3 in FIG. 2), the screen shown in FIG. 6 dedicated to the superior is displayed (s10 in FIG. 2).

When the superior selects the approval operation screen button (FIG. 6) for the supervisor's seal, the superior check processing screen (FIG. 7)
(A)) is displayed. Here, an employee name belonging to the department and an employment data list reference button are selected, and the employment data input by the selected employee is confirmed. If the data can be checked and approved on a daily basis, the supervisor selects the work data approval button shown in FIG. 7B and saves the work data of the employee. As a result, the employment data of the employee is stored in the employment data list master in a state where the supervisor has received the seal. Up to this point are daily work data input and approval authority operations.

Next, the processing operation at the end of the month will be described. After confirming that the input of all the employment data for the month has been completed at the end of the month, the employee selects the identity confirmation button shown in FIG. 4 (month-end processing operation). When the identity confirmation button is selected, a check is entered in the identity confirmation column (FIG. 2s9), and furthermore, it becomes impossible for even the employee himself to correct the employment data. The data so far is stored in the employment management department master.

Whether or not the data in which the employee has filled in the personal identification mark as the month-end processing operation is stored in the employment management department master is displayed on the display screen of the superior authority. The manager checks whether there is a month-end processing operation, and if there is no personal identification mark, urges the employee to perform the month-end processing operation as the month-end processing. The user selects the month-end approval authority processing button in FIG. 7 (A) to perform protection processing so that data inputted thereafter cannot be changed (hereinafter, the processing will be described later).
Locking is also the process of protecting data from being changed.) Further, when the superior selects the month end approval authority processing operation button, a check is entered in the upper seal check box of the employment data list display screen (month end approval authority processing operation). This data is stored in the employment management department master. The superior performs the above approval process for each employee. If the manager finds an erroneous entry in the employee's employment data and determines that the employee cannot approve the input, he or she selects the unlock button shown in FIG. 7A to unlock the employee.
It is possible to have the employee input the employment data again.
Then, the re-entered employment data is stored in the employment management section master.

Then, when the processing operation at the end of the month is completed to the superior of each department, the department for confirming and managing the working status of the employees (hereinafter referred to as the general affairs department) performs the final confirmation and the operation for protecting the data. Will be described.

A person having the authority of the work management department uses a Web browser of a terminal connected to the company network to
Connect to the employment data management system page. Enter the employee number (User ID) and password set in advance on the displayed screen (Fig. 3), and enter the database 2 (Employee master, department master, job type master)
If the Web application 5 determines that the employee has the employment management department authority from the data accumulated in the, the screen shown in FIG. 8 dedicated to the employment management department authority is displayed (s10 in FIG. 2).

The fact that the data of the end of the month-end processing operation by the superior of each department is stored in the employment management department master is because a message is displayed on the display screen of the general affairs department authority. Select the data list reference processing button.

If an erroneous input by an employee or a supervisor is found, the lock is released by selecting the lock release button (FIG. 9) of the employment management department authority, and the employee and the supervisor re-enter and re-approve. Get the operation.

When it is confirmed that the employment data that has completed the month-end processing operation of all employees and the month-end approval authority processing operation by the superior are correctly input, the general affairs approval processing mark button shown in FIG. 9 is clicked. Select (Work management department month end approval authority processing operation). As a result, a check is entered in the employment management section stamp box, and this data is stored in the employment management section master.

When all the operations up to this point are completed, the final lock button (FIG. 9) is selected to lock the data for final protection (final protection operation processing), and the final data is stored in the work management department master. . After this time, data entry or correction of working hours is not possible,
Only reference can be made.

By selecting the employment data input screen button on the screen shown in FIG. 6, the employment data of the superior can be input. If the user selects the employment data input screen button on the screen shown in FIG. 8, the employment data of the employee having the employment management section authority can be input. The method of inputting the employment data for the authorized employee is the same as the input method described above.

As described above, the work data management system disclosed in the present invention is executed on the Web application 5 of the server 3 and approves the consistency of the data input using the data stored in the database 2. Since the input data is stored in the database 2 for centralized management, it is connected to the network 6 and
Any terminal having a browser can input, confirm, approve, and refer to employment data. In addition, the consistency of whether or not the data is entered by the user is also confirmed by the User ID and password preset for each employee. Regardless of the authority, the user can input or approve employment data.

In addition, most of the input data is selectable. If all items to be input are not input, the input data will not be consistent and will not be approved, so that erroneous input and omission of input by employees will be minimized. Can be suppressed.

(Embodiment 2) In this embodiment, a method of inputting daily work data when various work modes are employed will be described.

First, a description will be given of a case where transfer work is performed. In the present embodiment, it is assumed that the transfer attendance is a day corresponding to a holiday in the company holiday data, and is applied when the actual working (working) time is 8 hours or more.

The employee accesses the employment data management system from the terminal (FIG. 10s1), inputs the User ID and password (FIG. 10s2), checks the consistency in the database (FIG. 10s3), and If it is determined that the employee does not have the authority, the displayed work data input screen (FIG. 5) is opened (FIG. 10s4), and the transfer work is selected as the work mode.

As the work data, the work start time, the work end time, and the break time are input as in the first embodiment, and then the scheduled date of the transfer holiday (also referred to as a holiday) is input (s5 in FIG. 10). If, for some reason, a transfer holiday is first obtained before a transfer work, the scheduled transfer work date may be input.

After making the above input, the user selects the registration correction button and confirms the consistency in the database 2 (employee data master, transfer attendance master, company holiday master, work data list master) (FIG. 10s6).
The data whose consistency has been approved is stored in the employment data list master. If we determine that integrity cannot be approved,
An error message is displayed.

If the transfer holiday or transfer attendance cannot be executed on the scheduled date entered at the time of application and is carried over to the next month, the new scheduled date is re-entered on the application screen (FIG. 5), and the transfer is made. Rewrite the database 2 for work or transfer holidays. The consistency of the subsequent transfer holiday and transfer attendance will be confirmed using the newly rewritten scheduled date.

Next, a case where a shift work is performed will be described. On the work data input screen shown in FIG. 5, shift work is selected, work start time, work end time, and break time (midnight break time) are input.
After inputting the necessary items, select the registration correction button to check the consistency in database 2 (employee data master, department master, job type master, employment data list master) and store the approved data in the employment data list master Is done. If you are not approved (for example, if the time entered is less than the time specified in the rules),
Since an error message is displayed, enter it again until it is approved.

In shift work, since a work start time and a work end time are input, it is possible to cope with a case where a flextime system is introduced.

Next, regarding a case where the employee goes to work on a holiday,
explain. On the work data input screen, select work on holiday. The work on holiday is a day corresponding to a holiday in the company holiday data, and is applied when the actual working (working) time is less than 8 hours. Enter work start time, work end time, and select break time. After inputting the necessary items, when the registration correction button is selected, the consistency with the data stored in the database 2 (employee data master, company holiday master, employment data list master) is confirmed in the Web application 5 and approved. Data is stored in the employment data list master. If it is not approved, an error message will be displayed. Enter it again until it is approved.

These work rules may be determined appropriately by the practitioner of the present invention, and the method of checking the consistency of the database 2 and data can be changed in accordance with the work rules.

As described above, the operation of the supervisor's approval authority processing after inputting the employment data in various work modes is as described in the first embodiment, and therefore the description is omitted here.

As shown in the present embodiment, the present invention is an employment data management system that can cope with various work modes.

Embodiment 3 Next, in this embodiment, a method of inputting application items (paid application and the like) other than employment data will be described.

The employee connects to the page of the work data management system using the Web browser of a terminal connected to the company network (s1 in FIG. 10). Then, on the displayed screen (FIG. 3), a preset employee number (User ID) and password are input (s2 in FIG. 10).
In Web application 5, input by employee
From the User ID and the password, check whether the data (Employee Data Master, Department Master and Job Type Master) is consistent with the data stored in it (Fig. 10s).
3) If it is approved that the employee is correct (it is the person) and does not have special authority, a screen (FIG. 4) for selecting a month for inputting employment data is displayed. Here, if it is determined that the employee has special authority, a special screen for special authority is displayed.

Next, a month and a day for inputting the application items are selected, and an application item input screen shown in FIG. 5 is displayed. If the application is late, drop out or leave early, select the application and enter the respective start time and end time,
Fill in the reason for applying. If a special vacation is selected, select the reason for the special vacation.

When the input up to this point is completed, the user selects the registration correction button to save the data. Entered data and database 2 (company holiday master, job master,
The consistency of the data stored in the paid master, the transfer attendance master, and the work data list master) is confirmed in the Web application 5, and if the consistency is not ensured, an error is displayed. If an error message is displayed, the employee inputs again. The application data for which the consistency has been approved is stored in the employment data list 2 master. The employment data list 2 master is used when storing data of application items that are unlikely to be input daily by employees.

After the employee has input the application items, the superior confirms and approves the application items. The supervisor selects the application item approval button in FIG. 7B if the content is acceptable.

When the supervisor approves the seal, a message is displayed so that the employee can know that the application has been approved. The data subjected to the stamp processing operation is stored in the employment data list 2 master.

When the application is approved, the employee is notified that User I
Screen displayed after entering D and password (Fig. 3)
To be output as a message.

If the contents of the application are judged not to be approved by the superior, the application item approval delete button shown in FIG. 7B is selected, and the employee's application data is discarded.

In the general affairs department, at the time of the general affairs month end approval authority processing operation, the application also confirms whether the supervisor's approval authority processing operation and the month end approval authority processing operation have been completed with respect to the application matter. Perform the operation and store the data in the general affairs department check master. Next, a lock button for final protection is selected for final protection of the application data, and stored in the check master of the general affairs department.

(Embodiment 4) In this embodiment, a case where a terminal for inputting by an employee is connected to a device other than the in-house LAN will be described.

The employment data management system of the present invention has a We
It is executed using the b server 4 and the Web application 5, and is used as a terminal for inputting a terminal having a Web browser. Therefore, not only a terminal connected to the company LAN but also an employee at a remote branch office, for example, can input employment data via a WAN (for example, the Internet). The employee can also approve and protect the employee's employment data.

In the terminal connected to the network,
By starting the Web browser and accessing the address of the work data management system set in advance, even if there are factories etc. all over the country, it is possible to connect to the work data management system managed by the head office. Employees can enter and view employment data.

Even if the employment data management system is updated, it is not necessary for each terminal to perform the update operation if the server 3 performs the update processing. If the terminal is connected to a WAN represented by the Internet, input, reference,
Authority operations can be performed.

(Embodiment 5) In this embodiment, a case where the registered data of an employee is corrected or changed will be described.

When the registered data of an employee is changed due to a change in personnel, or when the number of employees is increased and new registered data of an employee is created, correction of the registered data or the like is performed with authority of the general affairs department. Do. In the present invention, the right of modification is set so that only the general affairs department has, but may be reset by an implementer as appropriate.

An employee who has the authority of the general affairs department can connect to the employment data management system from any terminal connected to the network 6 and perform a correction operation on the database 2.

In the employment data management system disclosed in the present invention, all data is stored in the database 2 connected to the network 6, and if the employee forgets the password, a special authority is required. Even without this, a new password can be set on the password input screen.

[0070]

According to the present invention, since the number of work data input by the employee himself is reduced, erroneous input of work data can be reduced and management can be performed accurately.

Further, since the present invention is an employment data management system executed on a Web server, it is not necessary to move data to each terminal, and when updating the employment data management system, the update is performed on the server. For example, there is no need to perform the work for updating at each terminal. Also, any personal computer that has a Web browser can be used as a terminal, and employees can input and refer to employment data regardless of the processing that can be operated from any terminal. it can. If the user has the special authority, an approval operation and a protection operation can be performed.

The network connecting the terminal, the database and the server is not limited to the in-house LAN, but may be a WAN such as the Internet. For example, when a company has offices and the like all over the country, Even if terminals for inputting work data are scattered all over the country, if the terminal is connected to the Internet, you can access the address set in the work data management system,
The general affairs department of the head office can collectively approve, confirm, and protect employee employment data and application items in various locations.

[Brief description of the drawings]

FIG. 1 is a diagram showing an overall configuration diagram of an employment data management system disclosed in the present invention.

FIG. 2 is a diagram showing a flow of inputting work data in a work data management system disclosed in the present invention.

FIG. 3 is a diagram showing a screen for explaining work data input.

FIG. 4 is a diagram showing a screen for explaining work data input.

FIG. 5 is a diagram showing a screen for explaining work data input.

FIG. 6 is a diagram showing a screen for explaining input of work data.

FIG. 7 is a diagram showing a screen for explaining input of work data.

FIG. 8 is a diagram showing a screen for explaining input of work data.

FIG. 9 is a diagram showing a screen for explaining input of work data.

FIG. 10 is a diagram showing a flow of data input of the employment data management system disclosed in the present invention.

FIG. 11 is a diagram showing a screen for explaining input of work data.

Claims (8)

[Claims] 1. An employment data management system having a terminal for inputting employment data, a database and a server, wherein the terminal, the database and the server are connected to a network, and wherein the server is a Web server and a Web. The application, the database has at least one of employee data master, transfer attendance master, department master, job type master, employment data list master, employment management department master, paid leave master and company holiday master, An employment data management system, wherein the Web application confirms and approves the consistency between data input by the terminal and data stored in the database, and stores the approved data in a database. 2. An employment data management system according to claim 1, wherein said terminal can input employment data using any personal computer having a Web browser. 3. The network according to claim 1, wherein the network comprises:
LAN (Local Area Network) or WAN (Wide A)
rea Network). 4. The employment data management system according to claim 1, wherein, as long as the terminal is connected to the network, employment data and application items can be input and referenced without selecting the terminal. 5. A terminal connected to a network, comprising:
A first step of inputting an ID and a password; and a step of identifying an employee from the data stored in the database with the User ID and the password, and approving the consistency of processing contents operable by the employee. A second step, and a third step of displaying a screen prompting the terminal to input work data.
Step: checking the consistency of the input employment data, and if it is determined that the employment data can be approved, a fourth step of storing the employment data in the employment data list master; A fifth step of storing in the master; and a method for managing employment data. 6. A terminal connected to a network, comprising:
A first step of inputting an ID and a password; and a step of identifying an employee from the data stored in the database with the User ID and the password, and approving the consistency of processing contents operable by the employee. 2nd step, a third step of displaying a screen prompting daily input of employment data on the terminal, confirming the consistency of the input employment data, and if it is determined that approval is possible, the employment data is transferred to the employment data list master. A fourth step for storing, a fifth step for storing the employment data for which the approval authority processing operation has been completed in the employment data list master, a sixth step for storing the data for which the month-end processing operation has been completed in the employment management section master, and a month-end approval. A seventh step of storing the data on which the authority processing operation has been completed in the employment management section master; An employment data management method, comprising: an eighth step of storing completed data in the employment management section master; and a ninth step of storing final protection processing operation completed data in the employment management section master. . 7. An employment data management method according to claim 5 or 6, wherein in the second step, an employee who is determined to be able to perform an approval authority processing operation in addition to the employment data input processing is input. An employment data management method, comprising a step of causing a terminal to display a screen dedicated to approval authority. 8. The employment data management method according to claim 5, wherein in the second step, an employee who is determined to be able to perform an approval authority processing operation and a final protection operation is input to a terminal. A method for managing employment data, comprising the step of displaying a screen dedicated to general affairs authority.