JPH0417062A - Device and method for managing personnel information - Google Patents

Abstract

PURPOSE:To read out the attending state, leave taking state, etc., of all staffs of a company from any terminal provided in the company while the secrecy is protected by making access to a host computer from the terminal and inputting and outputting personnel information to and from the host computer. CONSTITUTION:A host computer 1, plural terminals 2, and a storage device 3 are provided and the computer 1 is accessible from the terminals for inputting and outputting personnel information to and from the computer 1. Then, such personnel information data as attending inputs, etc., are inputted from the terminals 2 by using a file library and such personnel information data as the attending state of all staffs., etc., are read out by using relational software. Such a judgment that which file library or relational software is released among numerous kinds of file libraries or relational software provided in accordance with importance is made by means of a code contained in frame data. Therefore, the attending state, leave taking state, of all staffs of a company can be read out while the secrecy is protected from any terminal provided in the company.

Description

[Detailed Description of the Invention] [Industrial Application Field] The present invention relates to organizational information management of organizations, etc., and particularly to a personnel information management device and method.

[Prior Art] Conventionally, personnel information management systems for organizations such as companies have been mainly carried out using time cards. Each employee enters their attendance and attendance using a time card, and the computer that reads the time card tallies the information.

Data about all employees was stored in a computer database, and the necessary data was later read out from a terminal as needed.

[Problems to be solved by the invention] However, in the conventional personnel management system, it is difficult for each person in the same department to know the distribution of leave, and for managers to understand the dispatch status of the entire company. The problem was that I had to go to the room where the personnel management terminal was located and press the key.

This invention was made in order to solve the above problems, and aims to provide a personnel information management system that can read company-wide dispatch status, leave distribution, etc. from any terminal in the company while protecting confidentiality. The purpose is

[Means for Solving the Problems] The present invention includes a host computer, a plurality of terminals connected to the host computer via communication lines, and a storage device connected to the host computer and forming a database, The host computer is accessed from the terminal to input and output personnel management information.

Furthermore, a step of connecting a terminal to the host computer according to a predetermined communication procedure, a step of transmitting the frame data from the terminal, and a step of the host computer comparing the code in the frame data with a judgment code stored in itself. a step of releasing one of the plurality of writing file libraries and reading relational software based on the comparison result;
inputting personnel information data from the terminal using the opened file library; storing the personnel information data in the storage device as a database; and inputting the personnel information data from the database using the opened relational software. The system consists of a step of reading personnel information data and a step of displaying the read personnel information data on the terminal.

[Operation] Use the file library to input personnel information data such as dispatch input from a terminal, and use relational software to read personnel information data such as dispatch status for the entire company. The code in the frame data determines which of the many file libraries and relational software that are set up depending on the level of importance is released, so it can be accessed from any terminal within the company while protecting confidentiality. You can read the situation, vacation distribution, etc.

[Example] The present invention will be described below with reference to the drawings. FIG. 1 is a conceptual diagram showing an entire embodiment of the present invention. In the figure, a host computer 1 installed in a calculation center S is connected to a storage device 3 consisting of a large-capacity disk device, etc., and a terminal 2. This host computer l is
Multiple terminals 2 installed at the head office H and local branches and sales offices, etc., via dedicated lines, public lines, etc.
is connected to. As the terminal 2, a personal computer or an equivalent device is used.

FIG. 2 shows a detailed configuration of the host computer 1, which includes a file table 5 and a working memory 7.

File table 5 has relational software 5
FI-3F3, qualification code P, and file libraries F1 to F3, reading code R1, and writing code W are stored in advance. A database DB consisting of various data is stored in the storage device 3. The relational software SFI to SF3 joins data from the database DB and extracts relational data in a predetermined format. The qualification codes P and I are for determining the qualification of the terminal user's class type, and the file libraries F1 to F3 are for linking with the input data from the terminal 2 and editing the accumulated data into a predetermined file format. be. The read code R1 and the write code W are used to determine whether input data is in a write mode or a read mode.

A terminal 2 at a business office, etc. is connected to a data bus 10 of a host computer 1 via an interface I/F from a public line.
It becomes possible to connect to. This data bus 10 includes qualification code judgment circuits 11 to 13, reading judgment circuits 14 and 15, and CP.
U6 is connected. Each determination signal R, W from the reading determination circuits 14 and 15 is given to the selector 16 as a switching control signal. Judgment signals G1, G2, G3 from the qualification code judgment circuits 11, 12 and 13 are sent to the selector 16.
is applied as an input signal to the selector 16, and is selectively output from either the terminal RO or the terminal WO of the selector 16. Terminal R
The output signals G1, G2, G3 from O are respectively applied to gates 18, 19, 20 groups consisting of unidirectional buffers. In addition, output signals G1, G2, G from terminal WO
The other gates 21, 22 . 3 also consist of unidirectional buffers.
Each will be given to 23 groups.

Now, relational software SFI for reading
For example, is a program to understand the dispatch status of the entire company, relational software SF2 is a program to understand the list of overtime work by department, and relational software SF3 is a program to understand the intra-curricular leave schedule. . The codes P, and T indicating qualifications are, for example, P for the top level qualification and the president, K for the middle level qualification for the section manager, and ■ for the general level qualification for the employee.

The writing file library F3 corresponds to, for example, a time card for a dispatch program, which is linked to a narrow range of data, and can be input by all employees. Next, the file library F2 is linked to medium-range data, and is, for example, a management program, including a dispatch program, in which a manager such as a section manager inputs the arrival and departure of part-time workers. File library F
1 is an umbrella program that links a wide range of data, including dispatch programs and management programs, such as registering board approvals and important organizational changes.

The frame format of input data transferred from the terminal 2 to the host computer 1 is shown in FIG. Frame format FF is source code S indicating the source
A. Mode code MC indicating write mode or read mode
There are qualification codes CC, information I, and other codes that indicate the qualifications of the first layer type. mode code MC
Either reading code R1 or writing code W is set for qualification code CC, code P for president, code K for section manager, and code E for general employee.

Employees of companies using this system are given a password bar and a code for employees below the president, section manager code, president code, etc.
I is added to P, respectively.

Next, the operation will be explained according to the flowchart shown in FIG. First, in step S1, an employee from terminal 2 of office M, etc.
When the host computer 1 is accessed, step S2
Terminal 2 is connected to host computer 1 using a predetermined protocol. This connection is established manually using an employee code and password, similar to normal data communication procedures. In step s3, the host computer 1 checks the frame format FF of the terminal 2 and determines whether it is in the read mode or the write mode.

The operation in step S3 is performed as follows.

The mode code MC in the frame format FF is simultaneously input to reading judgment circuits 14 and 15.

The reading code R1 and the writing code W are input independently from the file table 5 to the reading judgment circuits 14 and 15, and the reading judgment circuits 14 and 15 compare these, respectively. If the mode code MC is reading code R, the reading judgment circuit 14 reads 'l゛, and the other reading judgment circuit 15 reads '°0'.
Output ゛°. Conversely, if the mode code MC is the writing code W, the reading determination circuits 14 and 15 output degrees O゛° and °1°, respectively.

When 1 is output from the reading judgment circuit 15, the selector 6 connects the input terminal U to the terminal WO on the writing side, and when 1 is input from the reading judgment circuit 14, the selector 6 connects the input terminal U to the terminal WO on the reading side. is selectively connected to the terminal RO of the terminal RO.

In step S3, if the mode code MC is written as code W, the process advances to step S4; otherwise, the process advances to step S20.

In step S4, the host computer 1 checks the qualification code CC in the file format FF to determine whether it is the qualification president code P of the highest hierarchy, and if it is the president code P, the process proceeds to step S5.

The judgment operation in step S4 is performed as follows. The first qualification determination circuit 11 inputs the code P from the file table 5 and the qualification code CC from the data bus 10 and compares them. If the qualification code CC is the president code P (code match), the qualification determination circuit 11 simultaneously outputs a signal "1" to the three circuits G1, G2, and G3, and provides it to the selector 6.

In step S5, the president can add and write data to all files, and can also change all files. That is, it can be input into files such as one's own time card in a dispatch program, a part-time worker's attendance and leaving management program, and a general program for registering company organizational changes.

The operation in step S5 is performed as follows.

Three circuit signals G1, G2, output from the write side terminal WO,
The G3 signal "1" opens the gates 21, 22, and 23, and the file libraries F1, F2, and F3 for writing are read from the file table 5 and provided to the working memory 7. The president can view input screens based on these file libraries F1, F2, and F3 on the terminal 2. On this input screen, input data can be linked to file libraries F1, F2, and F3, and personnel transfers throughout the company can be written, minutes of board meetings, and organizational changes can be registered.

Next, in step S6, the data written and registered in step S5 is displayed on the terminal 2 in a format such as a list of various types, and is also stored in the storage device 3 as a database DB.

Now, if the president code is not P in step S4, the process proceeds to step S7, where it is determined whether the section manager code is K, and if it is the section manager code, the process proceeds to step S8.

The judgment operation in step S7 is performed as follows. The second qualification determination circuit 12 inputs the code K from the file table 5 and the qualification code CC from the data bus 10 and compares them. If the qualification code CC is the section chief code K (code match), the qualification judgment circuit 12 sends a signal ゛°1 to two circuits G2 and G3.
°° is simultaneously output and given to the selector 6.

In step S8, the section manager can write data to the medium range file. In other words, it can be input into files such as one's own time card in a dispatch program, a part-time worker's attendance management program, etc.

The operation in step S8 is performed as follows.

The signals "1" of the two circuits G2 and G3 output from the write side terminal WO open the gates 21 and 22, respectively, and the file libraries F1 and F for writing are output from the file table 5.
2 is read out and given to working memory 7. The section manager can view the manual screen based on these file libraries F1 and F2 on the terminal 2. On this manpower screen, the user can link the file library F1 and F2 manpower data and write in the overtime table for the department under his supervision and his own time card. And step SS6
Proceed to.

If the code is not found in step S7, the process proceeds to step S9 to determine whether the code is an employee code, and if it is an employee code, the process proceeds to step S10.

The judgment operation in step S9 is performed as follows. The third qualification determination circuit 13 inputs the code ■ from the file table 5 and the qualification code CC from the data bus 10 and compares them. If these match, the qualification determination circuit 13 outputs a signal ``1°'' to only one circuit G3 and supplies it to the selector 6.

In step SIO, only the file software F1 authorized by the general class employee is displayed on the display screen, and data can be written and changed within that range. That is, it can be input into a small file such as one's own time card in the dispatch program.

Then, the process advances to step S6.

Now, from step S3, read code R and step S20
Proceeding to step S4, here, the qualification code CC in the frame format FF is checked as in step S4. If it is the qualification president code P of the highest hierarchy, the process advances to step S21, and the president can read all the data in the storage device 3. All databases DB can be joined using relational software SFI, SF2, and SF3.

The operation of step S21 is performed as follows. Three circuits G1, G2, G3 obtained as a result of the judgment in step S20
The signal °°1'' is output from the read-side terminal RO.

These signals °°1°" open the gates 18, 19, and 20, read out the relational software SFI, SF2, and SF3 for reading from the file table 5, and provide them to the working memory 7. The president joins these relational software SFI, SF2, and SF3 to data throughout the database DB.

Next, in step S22, the results edited by joint, ie, the dispatch status, overtime status, current personnel status, etc. for the entire company, are displayed on the terminal 2 and can be printed.

If the president code is not P in step S20, step 2
Proceeding to step 3, it is determined whether the section manager code is K or not, as in step s7. If the code is an intermediate manager code, the process advances to step S24, where the manager can read data in the intermediate area (range of authority) in the storage device 3. Data in the intermediate area of database DB can be joined using relational software SFI and SF2. Extract and restore the dispatch status, overtime status, personnel status, etc. within the department obtained through jointing. And step S22
Proceed to.

The operation in step S24 is performed as follows. 2-way G2 and G3 signals obtained as a result of the judgment in step 323"
1'' is outputted from the terminal RO on the reading side. These signals °°1°° open the gates 19 and 20, respectively, read the relational software SFI and SF2 for reading from the file table 5, and apply them to the working memory 7.

Next, in step S22, as a result of editing using the joint, the dispatch status within the division, etc. is displayed on the terminal 2 and can be printed.

If it is not the section manager code in step S23, step S2
The process proceeds to step S5, where it is determined whether the employee code is I or not in the same manner as step S9. If the employee code is I, the process proceeds to step S26, where it is possible to read out data in a narrow range of authority of general-level employees, and also to display these data on the screen of the terminal 2 by jointing them with the relational software SFI. I can do it. Then, the process advances to step S22.

The operation in step S26 is performed as follows. The signal "1" of the 1st path G3 obtained as a result of the determination in step S25 is outputted from the read-side terminal RO. This signal "1" opens the gate 20, reads only the relational software SFI for reading from the file table 5,
Give to working memory 7.

Next, in step S22, as a result of editing using the joint, the user's past dispatch status, vacation rotation within the group, etc. are displayed on the terminal 2 and can be printed.

For example, the following items correspond to the writing file libraries F1 to F3.

Fl Dispatch input P, to, I sales staff dispatch manpower P, K, 1 Overtime work manpower P, to, IF F2 Absence leave input P, part-time worker attendance input P, K F3 Regular personnel transfer manpower P Retired manpower P For reading Relational software SFI ~ SF
As an example, the following items correspond to 3.

SF1 Individual's dispatch status P, K, ■Person's status on leave P, K, ■ Vacation group status P, K, 1 Overtime work status P, K, ■ SF2 Availability status of others P, K Leave status of others P, K Other people's overtime work status P, K SF3 Company-wide dispatch status P Company-wide vacation status P Company-wide overtime work status P An example of the display in step S6 above is the file library Fl for writing, dispatch input is March 7 Sun 8:21 00 System Center Patent Attorney Tabe *** Received dispatch input ***.

[Effects of the Invention] As described above, according to the present invention, a host computer is accessed from a terminal to input and output personnel management information. In addition, the scope of use of file libraries and relational software is specified according to qualifications, so employees can press time cards and make turns from desk terminals in the office. In addition, while protecting Fumitsu, the company-wide dispatch status and vacation distribution can be read as needed. What's more, it also has the effect of making employees throughout the company familiar with the terminal's personal computers, making it easier to use them.

[Brief explanation of drawings]

FIG. 1 is a diagram showing the overall configuration of the present invention, FIG. 2 is a diagram showing the detailed configuration of the main part of FIG. 1, FIG. 3 is a configuration diagram of the frame format, and FIG. This is a flowchart. 1...Host computer, 2...
Terminal, 3... Storage device, 5... File table, 7... Working memory, I/F... Interface, 10...
・Data bus, 11-13... Qualification judgment circuit, 14.15...
...Reading judgment circuit, 16...Selector,
18-23...Gate, CC...Qualification code, FF...Frame format, F1-F3.
...File library, DB...Database, H...Head office, L...Dedicated line, public line, etc., M...Branch or sales office Place, etc., P, ni, I... code, R... reading code, S... calculation center SFI~SF3... relational software, W...・・・
・Written code. 21,1 Figure L-12" Figure 3.

Claims (2)

[Claims] (1) A host computer, a plurality of terminals connected to the host computer through a communication line, and a storage device connected to the host computer and forming a database, and the host computer can be accessed from the terminal to perform personnel management. A personnel information management device characterized by inputting and outputting management information. (2) A step of connecting a terminal to a host computer using a predetermined communication procedure, a step of transmitting frame data from the terminal to the host computer, and a step of determining whether the host computer stores the code in the frame data in its own memory. a step of comparing with the code; a step of releasing one of a plurality of writing file libraries and reading relational software to the terminal based on the comparison result; inputting personnel information data into the host computer, storing the personnel information data as a database in the host computer, and reading the personnel information data from the database using the released relational software. and displaying the read personnel information data on the terminal.