JP2022106219A - Information management device, information management method, and information management program - Google Patents

Abstract

To provide an information management device capable of reducing errors which occur when a user sets a personnel evaluation system, an information management method, and an information management program.SOLUTION: In a personnel evaluation support system, a personnel evaluation support server 2 (information management device) comprises a storage device 22, and a setting management unit 241. The storage device stores a combination of identification information for uniquely identifying records and display names corresponding to the identification information, and information containing the information associated with the combination. The setting management unit outputs a file for displaying and updating the information associated with the combination via a spreadsheet held by a user's device. The file stores the identification information and the display names, and displays the identification information and the display names in one column in a switchable manner corresponding to the information associated with the combination.SELECTED DRAWING: Figure 2

Description

The present invention relates to an information management device, an information management method, and an information management program.

Conventionally, a server / client system constructed by having an appraisal server and a client connected to this server so as to be communicable via a network, and an appraiser's job evaluation items via the network are evaluated. A system including an evaluation means has been proposed (for example, Patent Document 1). In this system, the appraisal system table draft creation screen is displayed for the personnel department specific client, and the approval route is determined for each appraiser through this screen, and the medical record basic items and appraisal system determined in this way are It can be modified using an appropriate application such as Excel, and the modified basic chart items and appraisal system are stored in the appraisal server through the chart basic item table draft import screen and the appraisal system table draft import screen. Etc. are described.

Japanese Unexamined Patent Publication No. 2001-243338

In an organization such as a company, the evaluation method and organizational structure to be adopted are different, and the format of the evaluation viewpoint set by the group or individual and the content of the goal are also different. However, it has not been easy for a user who is not familiar with the system to set the general-purpose personnel evaluation system according to the organization.

Therefore, an object of the present invention is to provide a technique for reducing errors when a user makes settings for a personnel evaluation system.

The information management device is associated with a combination of identification information for uniquely identifying a record, a display name corresponding to the identification information, and a storage device for storing information including information associated with the combination. It is provided with a setting management unit that outputs a file for displaying and updating the received information via the table calculation software held by the user's device. In addition, the file stores the identification information and the display name, and displays the identification information and the display name in one column in a switchable manner in association with the information associated with the combination. The information management device is a personnel evaluation support device that manages information related to personnel evaluation, the display name is the name of an employee, and the information associated with the combination may be information used for personnel evaluation.

By displaying the display name and identification information in a single column, the master data can be maintained by referring to the display name that is easy for users who are not familiar with the system to understand, and the same display name can be displayed. If it exists, it will be possible to refer to the identification information that can uniquely identify the record. Therefore, it is possible to reduce erroneous registration of master data. Further, even when the display area of the user's device is not sufficiently wide, the two pieces of information can be confirmed without scrolling the screen by the above switching, which improves convenience.

The personnel evaluation support device acquires information representing the format of the personnel evaluation table including the input fields for the evaluation items, associates the columns provided in advance in the database table with the input fields, and stores the information indicating the correspondence. Based on the information related to the setting registration unit to be stored in the database and the information related to the self-evaluation input by the plurality of first users who are the evaluated persons and representing the items to be described in the input field, and the information indicating the correspondence relationship. , The data registration unit that registers the information representing the items to be described in the field of the column associated with the input field, and the information that is read and read out from the information registered in the field, or the information that aggregates the read information is evaluated. It is provided with an output control unit that outputs to the device of a second user who is a person.

Based on the correspondence between the column provided in the database table and the input field of the personnel evaluation table, the items described in the input field of the personnel evaluation table can be registered in the field of the corresponding column. That is, based on the correspondence between the column and the input field, the information input by the evaluated person in the personnel evaluation table can be registered in the corresponding column, read out, and output to the evaluator. Therefore, even if the format of the personnel evaluation table is changed, the change is completed by modifying the correspondence between the input field and the column. That is, it is possible to provide a general-purpose personnel evaluation system in which a user can freely and easily define a format according to, for example, the business of the company.

Further, the setting registration unit acquires information representing a period and information representing a second user who evaluates the first user in the period, and stores the information in the storage device, and the output control unit is the first user. The information regarding the self-evaluation in a certain period input by is output to the device of the second user to evaluate the first user in the period, and the data registration unit is the first user input by the second user. Further acquire the information indicating the items to be described in the input field, which is the information related to the evaluation in the period of, and register the information representing the items to be described in the field of the column associated with the input field based on the information indicating the correspondence. You may do so. In this way, when the organizational structure is changed in units of a predetermined period, the correspondence between the evaluated person and the evaluator can be appropriately extracted and input for the desired period. ..

Further, the setting registration unit acquires a plurality of second users who evaluate the first user and information indicating the evaluation order and stores them in the storage device, and the data registration unit is based on the information indicating the order. Then, when the information is input in the field to be input by the second user to be evaluated first, the input of the information may be accepted from the second user to be evaluated later. In this way, it is possible to realize a system that follows the workflow of a general organization's business, in which the boss evaluates in stages. The setting management unit further acquires the setting for skipping at least a part of the order and stores it in the storage device, and the data registration unit receives information from the second user to be evaluated later even if the setting for skipping is made. You may accept the input of.

Further, the setting registration unit further acquires information representing at least one of the job type and personnel position of the first user, stores it in the storage device, and inputs the information to the evaluation item by the first user. The information about the self-evaluation entered or the information about the evaluation of the first user entered by the second user includes a numerical value indicating the degree of the evaluation, and the data registration department is at least one of the job type and the personnel position. The weight for each evaluation item set for is multiplied by a numerical value to obtain information representing the evaluation for the first user. For example, it is possible to change the weight by multiplying a numerical value that indicates the degree of evaluation in advance by a predetermined weight, whether performance is emphasized or behavior is emphasized according to at least one of the job type and personnel position. can.

Further, the data acquired by the data registration unit may be input to the spreadsheet software held by the first user or the second user's device and transmitted to the personnel evaluation support device according to the user's operation. good. By doing so, the files of the spreadsheet software conventionally used in the organization can be continuously used. You can also enter information about the rating offline and send it online.

Further, the output control unit outputs a tabulation list that displays a list of information related to the evaluation of a plurality of first users to the device of the second user, and outputs information related to the evaluation of the first user to a predetermined value of the spreadsheet software. The data registration unit collectively acquires the information representing the evaluation of the plurality of first users input by the second user via the spreadsheet software, and registers the information in the storage device. You may do so. By doing so, when the evaluator evaluates a plurality of evaluated persons, the information related to the plurality of evaluations input on the spreadsheet software can be collectively registered, and the operability is improved.

The contents described in the means for solving the problem can be combined as much as possible without departing from the problem and the technical idea of the present invention. Further, the content of the means for solving the problem can be provided as a device such as a computer or a system including a plurality of devices, a method executed by the computer, or a program executed by the computer. A recording medium for holding the program may be provided.

According to the present invention, it is possible to provide a technique for reducing errors when a user makes settings for a personnel evaluation system.

FIG. 1 is a diagram showing an example of a system configuration according to the present embodiment. FIG. 2 is a block diagram showing an example of the configuration of the personnel evaluation support server and the user terminal. FIG. 3 is a processing flow diagram showing an example of a form registration process for registering a form such as a personnel evaluation table. FIG. 4 is a diagram showing an example of master data. FIG. 5 is a diagram showing an example of master data. FIG. 6 is a diagram showing an example of master data. FIG. 7 is a diagram showing an example of a performance evaluation sheet. FIG. 8 is a diagram showing an example of a weight master. FIG. 9 is a diagram showing an example of a competency sheet. FIG. 10 is a diagram showing an example of an evaluation list sheet. FIG. 11 is a diagram showing an example of a table of a general-purpose database stored in the storage device of the personnel evaluation support server. FIG. 12 is a diagram showing an example of data showing the correspondence between the column of the table of the general-purpose database stored in the storage device of the personnel evaluation support server and the information input field provided in the format data. FIG. 13 is a diagram showing an example of personnel evaluation support processing. FIG. 14 is a diagram showing an example of a user information table stored in advance in the storage device of the personnel evaluation support server. FIG. 15 is a diagram showing an example of a user terminal displaying a web page.

Hereinafter, embodiments for carrying out the present invention will be described with reference to the drawings.

<System configuration>
FIG. 1 is a diagram showing an example of a system configuration according to the present embodiment. The system 1 according to the present embodiment includes a personnel evaluation support server 2 and a user terminal 3 (3A to 3C in FIG. 1), and these configuration requirements are connected via a network 4 such as the Internet. The user terminal 3 is a general computer such as a PC (Personal Computer) or a smartphone. Further, the user terminal 3 is used by a user who is an evaluator or an evaluator of personnel evaluation in an organization such as a company. For example, the user inputs information about evaluation into an electronic file (hereinafter, also simply referred to as "file") read / written by spreadsheet software (spreadsheet software) executed by the user terminal 3, and the input information is For example, it is transmitted to the personnel evaluation support server 2 by a script executed by spreadsheet software, for example, by HTTPS.

The personnel evaluation support server 2 is, for example, a cloud server, and functions of a web server, an application server, and a DB (Database) server are provided on a predetermined OS (Operating System). At this time, one or more personnel evaluation support servers 2 perform the processing according to the present embodiment as a so-called cloud service. The personnel evaluation support server 2 may be provided in a LAN (Local Area Network) in the organization. The personnel evaluation support server 2 is information on formats such as a personnel evaluation table (personnel evaluation table), a list for aggregation, and other settings from a user terminal 3 of an administrative user who is an administrator such as a personnel person in charge or a system person in charge. Is acquired and stored in the DB. Further, the personnel evaluation support server 2 acquires information representing the user's goal, information representing the evaluation of oneself or another person, and the like from the user terminal 3 of the user to be the evaluated person or the evaluator, and stores the information in the DB. Further, the personnel evaluation support server 2 creates a list of information related to personnel evaluation and a total result based on the information stored in the DB, and outputs the list to the user terminal 3 of the user who is the evaluator, for example.

<Device configuration>
FIG. 2 is a block diagram showing an example of the configuration of the personnel evaluation support server 2 and the user terminal 3.

<Personnel evaluation support server>
The personnel evaluation support server 2 includes a communication I / F (Interface) 21, a storage device 22, an input / output device 23, and a processor 24, and these components are connected via a bus 25.

The communication I / F 21 is, for example, a network card or a communication module, and communicates with the user terminal 3 via the network 4 based on a predetermined protocol.

The storage device 22 includes a main storage device (primary storage device) such as RAM (Random Access Memory) and ROM (Read Only Memory), and auxiliary storage such as HDD (Hard-disk Drive), SSD (Solid State Drive), and flash memory. It is a device (secondary storage device). The main memory secures a work area for the processor and temporarily stores programs read by the processor and information transmitted and received by the processor. The auxiliary storage device stores programs executed by the processor and information sent and received.

The input / output device 23 is a user interface such as an input device such as a keyboard and a mouse, an output device such as a monitor, and an input / output device such as a touch panel.

The processor 24 is an arithmetic processing unit such as a CPU (Central Processing Unit), and performs each process according to the present embodiment by executing an application. In the example of FIG. 2, a functional block is shown in the processor 24. That is, the processor 24 functions as a setting management unit 241, a data management unit 242, and an output control unit 243. The setting management unit 241 registers or changes the setting information about the organization or the user in the storage device 22 based on the information received from the user terminal 3. The setting information includes information representing a personnel evaluation system such as a personnel evaluation table and a list for tabulation, and for users belonging to an organization, the affiliation, job type, position, grade, evaluator and evaluated person related to the user. It may include master data representing the above, information representing access rights to the information to be held, security requirements, and the like. The data management unit 242 registers or changes the information representing the user's evaluation in the storage device 22 based on the information received from the user terminal 3. The output control unit 243 reads out the information held by the storage device 22 and transmits it to the user terminal 3 for presenting to the user, for example, as a personnel evaluation table or a tabulation list.

<User terminal>
The user terminal 3 is a general computer such as a PC, a smartphone, or a tablet. The user terminal 3 includes a communication I / F 31, a storage device 32, an input / output device 33, and a processor 34, and these constituent requirements are connected via a bus 35.

The communication I / F 31 is, for example, a network card or a communication module, and communicates with another computer based on a predetermined protocol.

The storage device 32 is a main storage device such as RAM and ROM, and an auxiliary storage device such as HDD, SSD, and flash memory. The main memory temporarily stores information about programs and personnel evaluations read by the processor, and secures a work area for the processor. The auxiliary storage device stores information related to programs executed by the processor and personnel evaluation.

The input / output device 33 is a user interface such as an input device such as a keyboard and a mouse, an output device such as a monitor, and an input / output device such as a touch panel. For example, the user registers information representing the evaluation of oneself or another person in the personnel evaluation support server 2 via the input / output device 33, or displays the information held by the personnel evaluation support server 2.

The processor 34 is an arithmetic processing unit such as a CPU, and performs each process according to the present embodiment by executing a program. The user terminal 3 also shows a functional block in the processor 34. The processor 34 functions as a setting registration unit 341, a display control unit 342, and a data input unit 343. The setting registration unit 341 receives input of setting information such as the above-mentioned information representing the personnel evaluation system, master data, and information representing access rights and security requirements according to the user's operation on the input / output device 33, and communicates I. It is transmitted to the personnel evaluation support server 2 via / F31. The display control unit 342 causes the input / output device 33 to display a personnel evaluation table and a tabulation list in a predetermined format acquired from the personnel evaluation support server 2. Information representing the evaluation by the user himself / herself or his / her superior or the like is input into the personnel evaluation table or the like, and is held in the personnel evaluation support server 2. This information is mapped to a personnel evaluation table or the like displayed by the display control unit 342 and presented to the user. The data input unit 343 receives input such as information representing the user's own goal and evaluation, information representing the evaluation of another person to be evaluated by the user, and the like in response to the user's operation on the input / output device 33, and the communication I / F 31. It is transmitted to the personnel evaluation support server 2 via. The processor 34 cooperates with the personnel evaluation support server 2 to realize these functional units. Further, the setting registration unit 341 may be provided only in the user terminal 3 of the management user.

<Registration process>
FIG. 3 is a processing flow diagram showing an example of a registration process for registering formats such as master data and personnel evaluation table. The setting registration unit 341 of the user terminal 3 accepts the operation of a management user such as a personnel person via the input / output device 33, and sets the master data of the user who uses the system as an evaluator or an evaluated person. Or, create data showing the format of personnel evaluation table, tabulation list, etc. (Fig. 3: S1). In this step, the management user maintains the master data in a predetermined format such as a file that can be read and written by general spreadsheet software, and creates a format that serves as a template for documents. That is, when updating the master data, the management user can modify the row of the user in the spreadsheet software. In addition, when creating data representing formats such as personnel evaluation tables and tabulation lists, the user uses table calculation software to create a personnel evaluation table that includes fields that the evaluated person and the user who is the evaluator should enter. Create and specify the input fields for the evaluated person and the evaluator to enter information.

FIG. 4 is a diagram showing an example of master data downloaded in advance in the format of spreadsheet software. The master data is recorded in a database table held by the personnel evaluation support server 2, and the setting management unit 241 writes the table records to a sheet (spreadsheet) of a file that can be read and written by spreadsheet software. Have the terminal 3 download it. The sheet of FIG. 4 includes a "register" button, a "check" button, and a table showing master data of the user. The table includes attributes such as "change flag", "employee number", "organization", "concurrent affiliation 1", ..., "Job title", "Job title", "Grade name", and so on. In the change flag field, you can enter a flag to specify the record to be updated. The name of the employee is displayed in the field corresponding to the "employee number". In the field corresponding to "organization", the name of the organization to which the employee registered in each record (each line) belongs is displayed. In the field corresponding to "concurrent affiliation 1", the name of the organization is displayed when each employee also belongs to another organization. The job title of each employee is displayed in the field corresponding to the "job title". The job type of each employee is displayed in the field corresponding to the "job type name". The grade of each employee is displayed in the field corresponding to the "grade name". Although not shown, one or more evaluators who evaluate the employee can be registered for the employee registered in each record.

Here, the underlined attribute name in FIG. 4 indicates that the content to be displayed in the column can be switched. FIG. 5 is a diagram showing an example of master data after switching the display. That is, in FIG. 4, the name of the employee is displayed in the field corresponding to the "employee number", but when the user clicks or taps the attribute name "employee number", the field corresponds to as shown in FIG. The employee number associated with each employee is displayed in. The employee number is identification information for uniquely identifying each employee in this system. Further, when the user clicks the attribute name "name" in FIG. 5, the name of the employee is displayed in the field as shown in FIG. Similarly, in the columns of the organization, the concurrent affiliation 1 and the like, the Japanese name and the identification information assigned to each of them can be switched.

FIG. 6 is a diagram showing an example of master data held in another sheet. As shown in FIG. 6, the combination of the identification information and the data before and after the switching such as the name is stored in a table format on another sheet (sheet such as "DL user" in FIGS. 4 and 5) included in the same file, for example. Will be done. In addition, the employee number, etc., which is identification information uniquely representing the employee, etc., is held in a column (not shown) set to be hidden on the sheet of spreadsheet software as shown in FIGS. 4 and 5. It shall be. Then, in the columns displayed in FIGS. 4 and 5, the name or employee number corresponding to each employee is displayed.

As described above, by displaying the Japanese name and the identification information on the system in one column, users such as personnel personnel can understand even users who are not familiar with the system. Master data can be maintained by referring to information such as easy Japanese names, and if there are users with the same surname and same name, it is possible to refer to information such as employee numbers that can uniquely identify the user. become able to. Further, even if the display area of the user terminal 3 of the management user is not sufficiently wide, the management user can check the two pieces of information (without scrolling the screen) by clicking the attribute name or the like, which improves convenience. do.

FIG. 7 is a diagram showing an example of a performance evaluation sheet. The performance evaluation sheet is provided as a sheet (spreadsheet) of files that can be read and written by spreadsheet software. In addition, the performance evaluation sheet is a personnel evaluation table in which users enter their own goals (evaluation items) and their evaluations. For example, one sheet is created for each user who is an employee of the company and for each predetermined period. .. In the example of FIG. 7, user information, goals, information representing evaluation, and the like are input to some items for convenience, but in S1 of FIG. 3, a format that serves as a template for the performance evaluation sheet is created. Further, although one sheet is shown in the example of FIG. 7, the items to be input and the buttons used for the operation may be divided into a plurality of sheets and provided as a plurality of sheets.

The performance evaluation sheet of FIG. 7 has a save button for storing data in the personnel evaluation support server 2, an interview date display column, an information display column for the user who is the evaluated person, and an entry column for the user's goal and evaluation. Includes a display field for information on bonuses and an entry field for transfer requests. The save button includes two buttons, "temporary save" and "confirmed save". For example, the temporary save button temporarily saves the contents entered by the user in the personnel evaluation support server 2, and the confirmed save button allows the user to temporarily save the contents. The entered contents are saved in the personnel evaluation support server 2, and the input of the self is terminated, so that the subsequent evaluators can input the data. The information about the user is the name of the user who is the evaluated person (“USER1” in the example of FIG. 7), the affiliation, the job type, the grade, the job title, the name of the user who is the primary evaluator (USER2), and the secondary evaluator. Each display column of the name of a user (USER3) and the name of the user who is the final evaluator (USER4) is included. In S1 of FIG. 3, these display columns are arranged on the sheet, and the information to be displayed in each column is associated with the master data held by the personnel evaluation support server 2. The user's goal and evaluation entry fields are serial number (No.), goal, achievement criteria, weight, difficulty level, reflection, self-evaluation, primary boss comment, primary evaluation, secondary evaluation, and secondary comprehensive input field. including. For example, the viewpoint shown in the goal column may be preset in common to a plurality of users in S1 of FIG. 3, and each user may freely input his / her goal in the achievement criterion column in a later step. In addition, each target column may be identifiable as to whether it is an item related to behavioral evaluation or an item related to performance evaluation. For example, in the evaluation item, a column for inputting a goal related to behavioral evaluation and a column for inputting a target related to performance evaluation may be predetermined. In S1 of FIG. 3, for example, the number of input fields for evaluators is set according to the personnel evaluation system of the organization to which the user belongs, and for each input field, the evaluated person, the primary evaluator, and the secondary evaluation are set. Who can enter the data, such as the person or the final evaluator. Further, for example, in the weight column, a value representing a weight to be multiplied by the score of each viewpoint listed as a target is set in association with the job title, grade, and job title of the user who is the evaluated person. You may do so. Further, the final score and the evaluation word in the bonus column may be determined based on the sum of the values obtained by multiplying the score representing the evaluation by the weight. The weight value may be predetermined for each type of evaluation item such as the above-mentioned behavior evaluation and performance evaluation in association with at least one of the user's job type and personnel position. Further, the transfer request column is provided with an input field that can be freely described by, for example, a user who is an evaluated person or a boss user who is an evaluator.

FIG. 8 is a diagram showing an example of a weight master. The weight master is a table that determines the ratio that emphasizes behavioral evaluation and performance evaluation in association with at least one of the user's job type and personnel position. In the table of FIG. 8, values representing weights for evaluation items are registered in association with job titles, which are an example of a personnel position. Such a definition can be stored in the storage device 22 in advance and uniformly applied to users belonging to the organization. The personnel position may be a post, a grade, or the like determined within the organization. Further, different weight masters may be defined for each job type such as sales position, R & D position, and clerical position, and in one weight master, a value representing the weight for the evaluation item is associated with the job type instead of the job title. It may be registered. For example, it is assumed that the higher the position, the more weight is set so that the performance evaluation is more important than the behavior evaluation. Further, for example, the sum of the values obtained by multiplying the points representing each evaluation by the corresponding weights can be obtained and used as a standard for bonuses and salary increases.

FIG. 9 is a diagram showing an example of a competency sheet. Competency sheets are also provided as sheets of files that can be read and written by spreadsheet software. Further, the competency sheet is a personnel evaluation table in which each user fills in an evaluation for an evaluation item commonly applied to users. For example, one sheet is provided for each user who is an employee of a company and for each predetermined period. Will be created. In the example of FIG. 9, user information and the like are input to some items for convenience, but in S1 of FIG. 3, a format that serves as a template for the performance evaluation sheet is created. Further, although one sheet is shown in the example of FIG. 9, one sheet may be provided as a plurality of sheets, or one sheet may be provided in combination with the above-mentioned performance evaluation sheet. ..

The competency sheet of FIG. 9 has a save button for storing data in the personnel evaluation support server 2, a display column for information about a user who is an evaluated person, and a statistical display column for information indicating an evaluation for a predetermined viewpoint. Includes a radar chart that graphs the evaluation, and an input field for information that represents the evaluation for a predetermined subdivided viewpoint. The save button and information about the user are the same as the performance evaluation sheet shown in FIG. 7. In the statistical display field of the evaluation for a predetermined viewpoint, the points input by the user are displayed, for example, by averaging. On the radar chart, the averaged values for a predetermined viewpoint are drawn as a graph. Statistical processing such as average calculation can be performed by the function provided in the spreadsheet software. In addition, the input fields for information indicating the evaluation for a predetermined viewpoint that has been subdivided are the serial number (No.), viewpoint, item, content, self-evaluation comment, self-evaluation (score), primary evaluation comment, and primary evaluation (1st evaluation). Includes an input field for points). In each input field of viewpoints and items, for example, the number and contents of viewpoints are set in S1 of FIG. 3 according to the personnel evaluation system adopted by the organization, the scope of business, and the scope of user's work. Further, in the input fields for comments and scores of the self and the evaluator, the number and titles of the fields are set in S1 of FIG. 3, and each user is made to input the contents in a later step. In addition, which of the evaluated person, the primary evaluator, and the like can input data to each input field is determined.

FIG. 10 is a diagram showing an example of an evaluation list sheet. The evaluation list sheet is also provided as a sheet of files to be read and written by spreadsheet software. Further, the evaluation list sheet is a tabulation list that is set to be viewable by a user who is an evaluator and displays a list of users who are evaluated. Further, the evaluation list sheet is created, for example, for all employees of the company or for each department and for each predetermined period, but the evaluation list sheet is not limited to this and displays a list of arbitrary evaluated persons. May be defined in multiple types. In the example of FIG. 10, information representing the user's evaluation is input to some items for convenience, but in S1 of FIG. 3, a format that serves as a template for the evaluation list sheet is created. In addition, in the evaluation list sheet, for example, using the function of existing spreadsheet software, search is performed based on the status indicating the stage in the evaluation work process, the affiliation of the evaluated person, the evaluator, the job type, the grade, and the like. , The evaluated person to be displayed may be narrowed down.

The evaluation list sheet of FIG. 10 has a registration button for storing information input to the spreadsheet software in the personnel evaluation support server 2, a table showing statistics for the range of points, and a table showing a list of users who are evaluated. including. When the registration button is pressed, the contents entered or changed by the user are saved in the personnel evaluation support server 2. In the table showing statistics for the range of points, for any evaluation item, the distribution showing the range of points, the number of evaluated persons who were given the points, and the ratio of the users who were given the points in the range to the whole. The rate is calculated and displayed. It should be noted that such statistical processing can also be realized by the function provided in the spreadsheet software. In the table showing the list of users who are evaluated, the score given to the status, name, job type, grade, affiliation, primary evaluator, secondary evaluator, and evaluation items related to performance evaluation and competency is given. Each display column is provided. Then, the information of the user who is the evaluated person is displayed in one record for one person. In the status display column, information indicating the evaluation process of the evaluated person indicated by the record is displayed. The information representing the evaluation process is stepwise by a plurality of users who are evaluated, such as "self-evaluation", "primary evaluation", "secondary evaluation", and "final evaluation". Information that represents the stage of evaluation work performed in. Information on the evaluated person indicated by the record is displayed in each display column of the name, job type, grade, affiliation, primary evaluator, and secondary evaluator. In addition, the points given by the evaluated person or the evaluator are displayed in each display column of the points given to the evaluation items related to the performance evaluation and the competency. In addition, a user who is an evaluator who is authorized to view the evaluation list can input or change the value of the score on the evaluation list sheet and update the information held by the personnel evaluation support server 2. And. For example, each user who is a primary evaluator, a secondary evaluator, and a final evaluator has a user who is an evaluator to be evaluated by himself / herself, and the information of the evaluator to be evaluated by himself / herself is defined. The viewing authority and the point modification authority may be set.

In S1 of FIG. 3, for example, a management user such as a personnel person in charge or a system person in charge creates a format used for inputting information for personnel evaluation as illustrated in FIGS. 7 to 10 using spreadsheet software. .. That is, the management user can determine the number and contents of input items, the number of evaluation work processes, and the like according to the personnel evaluation system of the organization to which he / she belongs. Note that the files that can be read and written by the spreadsheet software may not be created by the management user, but may be provided with a template. Further, in the input field provided on each sheet, the data type and contents of the information that can be input may be determined in advance by the management user. For example, in the score input field, only numerical values in a predetermined range are allowed to be input. Further, the content that can be input may be selected from predetermined options, for example, in a pull-down format.

Then, the setting registration unit 341 of the user terminal 3 transmits the format data created in S1 to the personnel evaluation support server 2 via the communication I / F 31 (FIG. 3: S2). In this step, a file as illustrated in FIGS. 7 to 10 is transmitted.

On the other hand, the setting management unit 241 of the personnel evaluation support server 2 receives the format data from the user terminal 3 via the communication I / F 21 (FIG. 3: S3). Then, the setting management unit 241 associates the information input field provided in the format data with the column provided in advance in the table of the general-purpose database stored in the storage device 22 in advance, and information indicating the correspondence relationship. Is held in the storage device 22 (FIG. 3: S4).

FIG. 11 is a diagram showing an example of a general-purpose database table stored in the storage device of the personnel evaluation support server 2. The data structure of the table shown in this embodiment is an example, and can be implemented by normalizing or denormalizing as appropriate. The table of FIG. 11 is provided with a plurality of columns (attributes) for registering a user and a period, and columns capable of holding desired information. It is assumed that each column is, for example, a character string type and has a sufficient data size for inputting a personnel evaluation table.

FIG. 12 is a diagram showing an example of data showing the correspondence between the column of the general-purpose database table stored in the storage device of the personnel evaluation support server 2 and the information input field provided in the format data. .. The table shown in FIG. 12 has database and format columns. The identification information of the general-purpose database column illustrated in FIG. 11 is registered in the database column. In the form column, information indicating input items of the form data exemplified in FIGS. 7 to 10 is registered. The information indicating the input items of the format data may be represented by the identification information represented by the rows and columns on the spreadsheet software or the identification information such as the label attached to the cell on the spreadsheet software. good. In the example of FIG. 12, for convenience, the names of the sheet and the input items are shown.

In S4 of FIG. 3, information representing the correspondence as shown in FIG. 12 is stored. When the personnel evaluation support server 2 receives the information related to the personnel evaluation input to the table calculation software on the user terminal 3 together with the identification information of the input field in which the information is input, the column of the table of the database and the format. Based on the data representing the correspondence with the information input field provided in the data, it can be stored in the corresponding column of the general-purpose table as shown in FIG. This completes the form registration process shown in FIG.

<Personnel evaluation support processing>
FIG. 13 is a diagram showing an example of personnel evaluation support processing. The personnel evaluation support process is started when an information reference request is transmitted from the user terminal 3 operated by the evaluated person or the evaluator to the personnel evaluation support server 2 in the core process of the evaluation work.

The display control unit 342 of the user terminal 3 requests the personnel evaluation support server 2 to refer to the information related to the personnel evaluation via the communication I / F 31 (FIG. 13: S11). In this step, a request is transmitted for the user who is the evaluated person to download information for inputting his / her own goal and evaluation in the form of, for example, a file of spreadsheet software.

On the other hand, the output control unit 243 of the personnel evaluation support server 2 receives a request from the user terminal 3 via the communication I / F 21 (FIG. 13: S12). Then, it is determined whether or not the user who uses the user terminal 3 has the right to view the data (FIG. 13: S13). It should be noted that the presence or absence of viewing authority may be determined by further using the range of other users who can browse, such as a predetermined department or group company. Further, the setting of whether or not to perform the authentication process at the time of request, and the security requirements including the character type and data length of the password that can be used for the authentication process may be separately determined.

FIG. 14 is a diagram showing an example of a user information table stored in advance in the storage device 22 of the personnel evaluation support server 2. The table shown in FIG. 14 has columns for name, affiliation, occupation, grade, job title, primary evaluator, secondary evaluator, final evaluator, and period. Each information of the user who is the evaluated person is registered in each column of name, affiliation, job type, grade, and job title. Further, in each column of the primary evaluator, the secondary evaluator, and the final evaluator, the identification information of the user who is the evaluator who evaluates the user who is the evaluated person is registered. In addition, information indicating the start and end of the period is registered in the period column. The user information table is updated via the sheets shown in FIGS. 4-6. Further, in S13 of FIG. 12, if the user who requested browsing is the person himself / herself or the user is an evaluator for a desired period, he / she has the authority to browse information related to the personnel evaluation of the user in S13. Is judged.

If it is determined that the user does not have viewing authority, information regarding personnel evaluation is not transmitted to the user terminal 3 (not shown). On the other hand, if it is determined that the user has viewing authority, the output control unit 243 transmits, for example, a spreadsheet software file as shown in FIGS. 7 to 10 in response to a request (FIG. 13: S14). In addition, the viewing authority may be set for each sheet such as the performance evaluation sheet, competency sheet, evaluation list sheet, etc., and the sheet with the viewing authority may be the transmission target, or the viewing authority may be set for each item included in these sheets. , You may create a sheet that has information only for items for which you have viewing authority. In the file transmitted in this step, information indicating the evaluated person and the evaluator is input in a predetermined input field and transmitted. Further, it may be determined in advance whether or not to encrypt the communication when sending and receiving the file, and whether or not to set a password for the file and compress it. If the user terminal 3 has downloaded the personnel evaluation table or the like in the past, for example, the presence or absence of the update is determined based on the version information, the time stamp, etc. attached to the file such as the personnel evaluation table, and the update is performed. If so, the output control unit 243 may transmit the file.

On the other hand, the display control unit 342 of the user terminal 3 receives a file from the personnel evaluation support server 2 via the communication I / F 31 (FIG. 13: S15). Then, the data input unit 343 of the user terminal 3 accepts the input of information from the user (FIG. 13: S16). In this step, information representing the user's goals and evaluations is input. Since the file of the spreadsheet software is used in this embodiment, the user can save the information being input in the storage device 32 of his / her own user terminal 3 at an arbitrary timing.

Further, the data input unit 343 transmits the information input in the file input field to the personnel evaluation support server 2 via the communication I / F 31 in response to the user's operation (FIG. 13: S17). In this step, when the temporary save button or the confirmed save button of FIGS. 7 and 9 or the registration button of FIG. 10 is pressed, the data input unit 343 is, for example, the identification information of the user who is the evaluated person and the evaluation target. During the period, the combination of the identification information in the input field and the input information is transmitted to the personnel evaluation support server 2.

On the other hand, the data management unit 242 of the personnel evaluation support server 2 receives information from the user terminal 3 via the communication I / F 21 (FIG. 13: S18). Then, the data management unit 242 updates the general-purpose table of the storage device 22 using the received information (FIG. 13: S19). In this step, the data management unit 242 receives information based on the data representing the correspondence between the column of the database table and the information input field provided in the format data stored in the storage device 22. In a field in a generic database table. The received information is stored in association with the identification information of the user who is the evaluated person and the period of the evaluation target. In this step, the data management unit 242 receives information from the user who evaluates later when the information is input in the field to be input by the user who evaluates first, based on the information indicating the order in the process of the evaluation work. You may provide a workflow that accepts the input of. That is, when the user who should input in the previous process presses the confirm save button in FIGS. 7 and 9 to store the information, the process of the previous user is completed in the workflow of this system, and is shown in FIG. The user who should input in the next process, such as the primary evaluator and the secondary evaluator, can input the information. In the workflow, it may be possible to set so that the evaluation in the subsequent process can be input without waiting for the approval in the previous process (skipping). In addition, when the evaluator in multiple processes of evaluation work is the same, it is set so that evaluations in multiple processes on the workflow can be input in any order (in other words, skipping the previous process). It may be something that can be done.

As described above, when the personnel evaluation support server 2 receives the information related to the personnel evaluation input to the table calculation software on the user terminal 3 together with the identification information of the input field in which the information is input, the personnel evaluation support server 2 and the column of the database table , Based on the data representing the correspondence with the information input field provided in the form data, it can be stored in the corresponding column of the general-purpose table as shown in FIG. This completes the personnel evaluation support process shown in FIG.

<Change of style>
When the management user changes the format as shown in FIGS. 7 to 10, the same setting registration process as in FIG. 3 is performed. That is, the information representing the changed format in S1 of FIG. 3 is created, for example, in the form of a spreadsheet software file. For example, the number of targets to be entered in the business evaluation sheet shown in FIG. 7 may be increased or decreased, or the viewpoints and items preset in the competency sheet shown in FIG. 9 may be changed. Then, the number and contents of the evaluation items listed in the evaluation list sheet shown in FIG. 10 are changed so as to be consistent with FIGS. 7 and 9.

Then, in S4 of FIG. 3, the changed input field is associated with the column of the general-purpose database table. The information representing the correspondence shown in FIG. 12 is created each time the format is changed, for example, in association with the information indicating the period. In this way, for example, when the personnel evaluation system is changed from a new period, the user can easily change the personnel evaluation system.

Further, in S14 of FIG. 13, a file according to the changed format is transmitted. Then, the evaluated person or the user who is the evaluator can input the information regarding the personnel evaluation in the changed file.

<Effect>
According to the system according to the present embodiment, the management user creates a desired personnel evaluation table, and by designating the fields to be input by the evaluated person and the user who is the evaluator and their contents, the personnel evaluation support server 2 Corresponds the column provided in advance in the database table with the input field of the personnel evaluation table. Therefore, it is possible to define a personnel evaluation table according to the personnel evaluation system and store the input information in the database table based on the correspondence between the column and the input field without performing large-scale system development. .. Further, based on the correspondence between the column and the input field, the information stored in the table can be mapped and displayed on the personnel evaluation table or the summary list, or can be aggregated and displayed. In addition, since the evaluator can input the evaluation collectively on the spreadsheet software and register it at once for the tabulation list that displays the records of multiple evaluated persons as a list, the number of people to be evaluated. Input work is easy even when there are many.

Further, for example, as shown in FIG. 14, since the relationship between the evaluated person and the evaluator is stored in association with the period, a user who should be evaluated by himself / herself, such as a subordinate, can be appropriately evaluated for a desired period. It will be possible to extract and let the user input. Further, based on the information indicating the evaluation order such as self-evaluation, primary evaluation, secondary evaluation, ..., When the input of the user to be evaluated first is completed, the input from the user to be evaluated later is input. By accepting, it is possible to realize a system that is in line with the business workflow. In addition, by displaying the status indicating the stage in the process of evaluation work such as self-evaluation, primary evaluation, secondary evaluation, and so on, the processing status and the subject to be processed by oneself are displayed. It becomes easier for the user to recognize the evaluator.

Further, since the file of the spreadsheet software is used for the interface with the user, the user can save the information being input in his / her own user terminal 3 at an arbitrary timing. Therefore, for example, a user who is an evaluator can move to a conference room or a private room to input an evaluation offline, return to his / her own seat, and register the evaluation online. By doing so, it is possible to prevent the evaluated person from seeing the content during the input work. Also, unlike when entering information on a web page, the communication session does not time out during the entry process.

<Others>
The configurations of the embodiments and modifications are exemplary, and the present invention is not limited to the configurations described above. Further, the configurations shown in the embodiments and modifications can be combined as much as possible without departing from the problems and technical ideas of the present invention.

<Browser input>
Instead of the file of the spreadsheet software, the user may be made to input the evaluation or the like by using the web page for inputting the goal or the evaluation. FIG. 15 is a diagram showing an example of a user terminal 3 that displays a web page. In the example of FIG. 15, the input items shown in FIG. 7 are performance evaluation sheet input screens for smartphones and tablets, and if the user terminal 3 is equipped with an Internet browser, even if the user terminal 3 does not have spreadsheet software. Input is possible. The web page can be displayed by the Internet browser of the user terminal 3. It should be noted that, instead of the web page, application software for the user to input an evaluation or the like may be provided. That is, the same data held by the personnel evaluation support server 2 is mapped to both the interface using the spreadsheet software and the interface using the Internet browser, and the same data held by the personnel evaluation support server 2 is obtained using both. It can be referenced and updated. By doing so, for example, a user who is an employee can input information on personnel evaluation from a rented PC using spreadsheet software, and a user who is a part-time job or a part-time worker can use a shared PC or his / her own mobile terminal. It can be used to input information related to personnel evaluation.

The input screen as shown in FIG. 15 can be created by the management user via an Internet browser. That is, by associating the input items defined in the file of the table calculation software in advance with the controls such as the text box, the radio button, the check box, and the pull-down menu laid out on the input screen by using the GUI, FIG. 15 shows. It may be possible to create an input screen as shown.

<Analysis report>
The evaluation result may be displayed in combination with other indicators. For example, eNPS, training taken by the evaluated person, acquired qualifications, evaluations obtained from business partners, etc. are displayed in combination.

In addition, the aggregated result of the evaluation for the individual and the evaluation for the organization created separately may be combined and displayed for easy comparison.

In addition, information on evaluations from recruitment to retirement may be associated and stored for each employee so that a series of information can be referred to at the time of personnel evaluation or at any analysis. Further, the content of the interview regarding the evaluation may be recorded on, for example, the personnel evaluation support server 2 or an arbitrary cloud by video or audio so that it can be referred to in a later process.

The present invention includes a computer program that performs the above-mentioned processing. Further, a computer-readable recording medium on which the program is recorded also belongs to the category of the present invention. For the recording medium on which the program is recorded, the above-mentioned processing can be performed by causing a computer to read and execute the program of the recording medium.

Here, the computer-readable recording medium means a recording medium that can store information such as data and programs by electrical, magnetic, optical, mechanical, or chemical action and can be read from a computer. Among such recording media, those that can be removed from the computer include flexible disks, magneto-optical disks, optical disks, magnetic tapes, memory cards, and the like. Further, as the recording medium fixed to the computer, there are a hard disk drive, a ROM, and the like.

1 Personnel evaluation support system 2 Personnel evaluation support server 241 Setting management unit 242 Data management unit 243 Output control unit 3 User terminal 341 Setting registration unit 342 Display control unit 343 Data input unit

Claims (8)

A storage device that stores information including a combination of identification information for uniquely identifying a record, a display name corresponding to the identification information, and information associated with the combination.
A setting management unit that outputs a file for displaying and updating the information associated with the combination via the spreadsheet software held by the user's device.
It is an information management device equipped with
The file is an information management device that stores the identification information and the display name, and displays the identification information and the display name in one column in association with the information associated with the combination. The display name is the name of the employee
The information management device according to claim 1, wherein the information associated with the combination is information used for personnel evaluation. The setting registration unit acquires information representing the format of a personnel evaluation table including an input field for an evaluation item, associates a column provided in advance in a database table with the input field, and stores information indicating a correspondence relationship. To remember
Information on self-evaluation input by a plurality of first users who are evaluated, and information representing items to be described in the input field is acquired, and the input field is supported based on the information representing the correspondence relationship. A data registration unit that registers information representing the above-mentioned items in the attached fields of the column, and
An output control unit that reads the information registered in the field and outputs the read information or the aggregated information of the read information to the device of the second user who is the evaluator.
Further prepare
The information representing the description items acquired by the data registration unit is input to the spreadsheet software held by the device of the first user or the second user, and the input information corresponds to the operation of the user. Is sent to the information management device by a script executed by the spreadsheet software.
The output control unit outputs a tabulation list that displays a list of information related to the evaluation of the plurality of first users to the device of the second user, and calculates the information related to the evaluation of the first user. Map it to the specified display position of the software and display it.
The data registration unit collectively acquires information representing the evaluation of a plurality of the first users input by the second user via the tabulation list of the spreadsheet software, and registers the information in the storage device. The information management device according to claim 1 or 2. The setting registration unit acquires information representing a period and information representing the second user who evaluates the first user in the period, and stores the information in the storage device.
The output control unit outputs information regarding self-evaluation in a certain period input by the first user to the device of the second user to evaluate the first user in the period.
The data registration unit further acquires information regarding the evaluation of the first user in the period, which is input by the second user and represents the items to be described in the input field, and obtains the information representing the correspondence relationship. The information management device according to claim 3, wherein the information representing the items to be described is registered in the field of the column associated with the input field. The setting registration unit acquires a plurality of the second users who evaluate the first user and information indicating the order of evaluation and stores them in the storage device.
Based on the information representing the order, the data registration unit inputs information from the second user to be evaluated later when the information is input to the field to be input by the second user to be evaluated first. The information management device according to claim 3 or 4. The setting management unit further acquires a setting for skipping at least a part of the order and stores it in the storage device.
The information management device according to claim 5, wherein the data registration unit accepts input of information from the second user to be evaluated later even when the skip setting is made. The computer
Information associated with the combination for a storage device that stores information including the combination of the identification information for uniquely identifying the record and the display name corresponding to the identification information, and the information associated with the combination. Is output via the spreadsheet software held by the user's device to display and update the file.
An information management method for updating information stored in the storage device based on information transmitted from the user's device via the spreadsheet software.
The file is an information management method for storing the identification information and the display name, and displaying the identification information and the display name in one column in association with the information associated with the combination. On the computer
Information associated with the combination for a storage device that stores information including the combination of the identification information for uniquely identifying the record and the display name corresponding to the identification information, and the information associated with the combination. Is output as a file for display and update via the spreadsheet software held by the user's device.
An information management program for updating information stored in the storage device based on information transmitted from the user's device via the spreadsheet software.
The file is an information management program that stores the identification information and the display name, and displays the identification information and the display name in one column in association with the information associated with the combination.

Images