JP5184952B2 - HR information processing system - Google Patents

Description

  The present invention relates to a personnel information processing system applied to, for example, a business system that handles personnel information.

  In the business application implemented in the business system that handles personnel information, items and extraction for various business data managed in the business database, such as personnel information such as employee number, name, department, job title, announcement information, etc. In many cases, a search function for setting and searching for conditions is usually provided.

  In this business application, the search result using the search function is often managed as a history. When extracting various types of data with the search function, processing is performed by specifying not only the items but also the point in time of data to be extracted by key input.

As a conventional technique of this type, for example, a screen for designating the year / month / day as a search condition is displayed, and a symbol for designating the next month or a symbol for designating the previous month is entered in the designated area of the month of the screen There is a system configured to calculate a month corresponding to the next month or the previous month from the current date, search a database for an individual whose calculated month corresponds to the birth month, and output information of the searched individual (for example, Patent Literature) 1).
Japanese Patent Laid-Open No. 2002-32395

  By the way, many companies have different business days (closed days) from the normal calendar. For example, you want to search for employee information after 5 business days next month. You may want to specify a search range.

  However, in the case of the conventional technology, in order to specify the date and time of the search range among the data extraction conditions, there is only a function of specifying the year, month, day, etc. in units of months, and employees in the company In terms of the information search function, it was not as convenient for the operator, and work efficiency was poor.

  The present invention has been made to solve such a problem, and provides a personnel information processing system capable of improving work efficiency when searching database information by specifying a date in a search range. Objective.

In order to solve the above problems, personnel information processing system of the present invention, the employee information about the employees belonging to the company, are stored in association with the change date of the employee information database, one When searching the database , a business day master storing business day information corresponding to information indicating the business days and closed days of the company in the calendar of the year, a display unit for displaying a screen related to the database search, and An input section for inputting a necessary search reference date, a search item and its search condition, and a relative date specification screen for specifying the search reference date as a relative date as a condition for searching for employee information is displayed. relative date designation unit for displaying the part, with the relative date designation screen, when a relative date showing a search range specified, the business day master business day from the specified relative date Calculates the date by referring to broadcast, the search and relative date generation unit for setting the date, the said search date is input from the input unit or the relative date set the search date by generator If, by the search condition and the search item key retrieves the information of the database, it characterized by comprising a search unit for outputting a search result to the screen.

  ADVANTAGE OF THE INVENTION According to this invention, the work efficiency at the time of searching the information of a database by designating the date of a search range can be improved.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a block diagram showing a configuration of a personnel information processing system according to an embodiment of the present invention.

  As shown in FIG. 1, a personnel information processing system includes a client computer 2 (hereinafter referred to as “client 2”) and a server computer 1 (hereinafter referred to as “business device 1”) connected via a network such as a LAN 3, for example. It is a thing. This personnel information processing system is a system for electronically processing a series of personnel management processes.

  The client 2 is a general-purpose computer including a CPU, a memory, an input device (input unit), a display device (display unit), a hard disk device, and the like, and is operated by a user. The display device (display unit) functions as a display unit that displays a screen related to the search of the database 10.

  Browsing software such as a browser 21 is installed in the hard disk device. When the business apparatus 1 is accessed (logged in) from the browser 21, a screen for using the personnel management database 10 of the business apparatus 1 is displayed on the display device.

  The business apparatus 1 includes a personnel management database 10, a business processing unit 16, a search unit 17, a relative date generation unit 18, a memory 19, and the like. The business apparatus 1 functions as a personnel information processing system by installing an application program for the personnel information processing system in a general-purpose computer. In addition, the business device 1 may be configured as a device incorporating a dedicated circuit component (hardware).

  The computer is, for example, a central processing unit (hereinafter referred to as “CPU”), a storage device such as a memory or a hard disk device, an input / output interface device such as a LAN, an input device such as a keyboard or a mouse, a liquid crystal display, a CRT display, etc. The display device is provided. The memory 19 stores a program for realizing the operation of this system. The program is a program for causing a computer to execute the processing of this system.

  The CPU reads the program code from the memory 19 upon activation of the computer and starts the process, or reads the program code from the storage device by a software activation operation from the activated computer screen and executes the process. The memory 19 functions as a calendar storage unit in which a yearly calendar is stored. The expression “unit” is not limited to a function as hardware, but includes a meaning as a function of software or a function of a combination of hardware and software.

  For example, the database 10 for personnel management includes a basic database 11, a business day master 12, a search condition detail master 13, a search condition main master 14, and a number of databases and master groups such as an organization master, post master, and qualification master. Is stored.

  The database 10 is a database in which basic information of employees (hereinafter referred to as “employees”) and employee personal information are stored. Basic employee information is employee information such as date of employment, title, qualification, department, salary, etc., and the date when the information became effective (such as date of transfer) ). The date of change is the date (announcement date) when the change became effective, such as “April 1, 2003”. The title is, for example, the title of the employee (information indicating the position in the company), such as “branch manager”, for distinguishing general employees from officers.

  Employee personal information is employee personal information such as employee age, gender, address, telephone number, and family structure. This database also stores employee transfer information.

  As shown in FIG. 2, the basic database 11 is a personal information storage unit in which employee identification codes, employee names, addresses, current organization codes, current prefecture codes, and the like are associated.

  The employee identification code is an employee code such as “employee 0001”, “employee 0002”... The current organization code is a code for identifying the organization (department, department, etc.) in the company, such as “A28” by the sales department. The current prefecture code is a code for identifying a prefecture such as “13” for Tokyo and “12” for Chiba.

  That is, the database 10 including the basic database 11 is a database that stores incidental information related to employees and the date when the incidental information is validated in association with each other.

As shown in FIG. 3, the business day master 12 holds a year-end calendar indicating a business day, a business day of the company, and a year flag indicating the start of the year in the calendar for one year. In the business day master 12, a non-business day flag, a year flag, etc. are set corresponding to the date which is a calendar date.
For example, when “1” is set as the closed day flag, it indicates a closed day, and when “1” is set as the year flag, it indicates the beginning of the year.
In this company, when acquiring the first business day of January 2008, the first business day is 2008/1/7 because 2008/1/7 is the first weekday.

  As shown in FIG. 4, the search condition main master 13 includes a search condition name, a search reference date, a relative expression, a panel for the search condition number so that the search condition once created and searched can be reused. Information such as name, incumbent / retirement, etc. is stored. The relative expression is stored as, for example, this year: April: 5 business days. The panel name is stored as an input name so that the searcher (user) can easily determine what kind of search is performed.

As shown in FIG. 5, the search condition detail master 14 stores sheet names, row numbers, join conditions, search items, comparison target values, operators, and the like. That is, the search condition detail master 14 stores specific information (contents displayed on the relative date designation screen 50 (see FIG. 7)) that further refines the search condition.
That is, the search condition main master 13 and the search condition detail master 14 function as a search condition storage unit that can name and save a search condition used at the time of search as a search history.

  The business processing unit 16 performs processes such as personnel management in the database 10 and registration and update of information related to company business.

  The search unit 17 includes, for example, an input device such as a keyboard and a mouse, a graphic user interface screen (hereinafter referred to as “GUI screen”) displayed on the browser 21 and the like, buttons displayed on the GUI screen, input fields, and the like. It is realized by. In response to a search screen display request from the client 2, the search unit 17 displays a search screen 40 (see FIG. 6), which is one of GUI screens, on the screen of the browser 21.

  The search unit 17 has a function of searching and displaying personnel information in the database 10 using the search reference date specified on the search screen 40 and the search conditions as keywords. The search screen 40 functions as an input unit for inputting a search reference date, search items, and search conditions necessary for searching the database 10.

The search unit 17 searches the database 10 using the specified information as a key when a search condition and a reference date are specified for at least one of the plurality of search items on the search screen 40 and a search execution operation is performed. It has a function as an interface.
The search unit 17 searches the information in the database 10 by using the key input from an input unit such as a keyboard or the search reference date set from the relative date designation screen 50, the input search item and the search condition as keys. The search result is output to the browser 21 screen.

  As shown in FIG. 6, the search screen 40 is stored in the memory 19 in a search reference date specification field 41, a relative date specification button 42, a panel name selection field 43, an input field 44 for specifying a search condition, and the memory 19. This is a screen provided with a capture condition name input field 45 for capturing the retrieved search conditions, a condition capture button 46, a search button 47, and the like.

  The search reference date designation field 41 is a field in which the date is entered. In this field, it is possible to input directly by key operation, and the search reference date calculated with the relative date specified from the relative date specifying screen is input (set).

  The search reference date designation field 41 includes, for example, “April 1, 2007” (today: system date), and “April 1, 2006” (one year ago) earlier than today, from today. In addition, “time point” is designated for each of them, such as “April 1, 2008” (one year later).

  In the search reference date specification field 41, the current (today: system date) date is set as an initial value, and the search from today is performed by inputting a search item and a search condition, thereby performing a search with a plurality of conditions. Can be searched without specifying a date for each condition.

  The relative date designation button 42 is a button that serves as a trigger for starting the relative date generation processing unit 18. In the panel name selection field 43, search conditions previously saved in the memory 19 are displayed in a pull-down menu.

  The search condition input field 44 is provided with a plurality of search item fields, a comparison target field and an operator field set for each search item, and various search conditions can be designated. .

  For example, a search can be performed by specifying “employee code” in the search item column, “10” in the comparison target column, “includes” as an operator, and the like.

  The operator column has a pull-down menu. In addition to “contains”, phrase search conditions such as “equal to” and “does not contain” can be selected and specified from the pull-down menu.

  The search unit 17 searches the information in the basic database 11 and the masters 12, 13, and 14 according to the plurality of search reference dates specified in the plurality of search reference date specification fields 41, and outputs the search results. That is, the search unit 17 searches the database 10 using a plurality of search conditions and reference dates specified on the search screen 40 as keys, and outputs search results (adapted information).

  The relative date generation processing unit 18 is activated when the relative date designation button 42 on the search screen 40 is clicked, and displays the relative date designation screen 50 (see FIG. 7). When the relative date is specified on the relative date specification screen 50, the relative date generation processing unit 18 calculates the search reference date from the specified relative date according to the arithmetic program stored in the memory 19 in advance, and the search screen 40 The search reference date designation field 41 is set.

  As shown in FIG. 7, the relative date designation screen 50 includes a column 51 for directly inputting a relative reference date, and columns 52, 53, 53 for selecting and inputting a relative year, a relative month, and a relative date from a pull-down menu. 54, a radio button 55 for designating a date format, an execution button 56 for starting calculation of the date from the relative date, a relative expression display field 57, an application date display field 58, and a confirmation button 59 Is provided. The condition input to the relative reference date column 51 and the relative year, relative month, and relative date columns 52 to 54 can be selected and specified from a pull-down menu.

  The date format (year / month / day (YYYYMMDD), year / month (YYYYMM), year (YYYY), etc.) means how to display the date. The relative reference date is a reference date (system date, direct date input, etc.) that is a basis for generating a date. The relative year means the target year (current year, current year, one year ago, etc.). The relative month is the target month (current month, one month later, etc.). Relative day means the target day (current day, last day, last business day, etc.).

  The relative date generating unit 18 displays a relative period (how many years ago / after and / or how many months ago / after and / or how many business days ago) indicating the search range from a certain date on the relative date designation screen 50. When “after” is designated, the business day information of the business day master 12 is calculated from the designated relative period, and the date is calculated and set as the search reference date.

The operation of this personnel information processing system will be described below with reference to the flowchart of FIG.
In the case of this personnel information processing system, necessary information is retrieved from the personnel information of the basic database 11 and each of the masters 12 to 14 based on information designated as a search keyword.
In this case, after the user activates the browser 21 on the client 2 and specifies the network address of the business device 1 to access and log in to the business device 1, the search unit 17 displays the search screen 40 shown in FIG. The

In order to specify the search reference date as a relative date on the displayed search screen 40, a relative date generation instruction button is clicked (step S101 in FIG. 8).
Then, the relative date generation unit 18 displays the relative date designation screen 50 shown in FIG.

  When a relative year, a relative month, a relative date, etc. are selected from the pull-down menu on the relative date designation screen 50 and a period is designated by the relative date, the execution button 56 is clicked (Yes in step S102). The relative date generation unit 18 calculates the search reference date (year / month / day) from the specified relative date with reference to the business day information of the business day master 12 (step S103), and the search reference on the relative date specification screen 50. Set in the day field 51.

  The user confirms the date set in the search reference date field 51 and clicks the confirm button 59 if it is OK.

  Then, the relative date generation unit 18 passes the date data set in the search reference date field 51 to the search unit 17. As a result, the date is displayed in the search reference date field 41 of the search screen 40.

  Here, when the user inputs a search item, a comparison target, an operator, and the like in the search condition input field 44 of the search screen 40 and clicks the search button 47 (Yes in step S104), the search unit 17 sets the setting. The information in the database 10 is searched by using the search reference date, the search item, and the search condition as a key (step S105), the search result information is acquired from the database 10 (step S106), and is output to the browser 21 screen. To do. Thereby, a list of search results is displayed (step S107).

  The search unit 17 stores a search condition (including a search reference date, a search item, a comparison target, an operator, a relative date, etc.) after a list is displayed, by a search condition saving operation, or automatically after a predetermined time has elapsed. The ten search condition main masters 13 and the search condition detail masters 14 are stored (step S108). During the search condition saving operation, the search unit 17 displays a dialog box for inputting a panel name to prompt the user to input a panel name, and the user decides and saves the file name.

Next, the operation of the relative date generation unit 18 will be described in detail with reference to the flowcharts of FIGS. In the relative date designation screen 50 in this example, the search start date of the relative reference date is “system date that is the operation date” (system date is April 1, 2008), the relative year is “current year”, and the relative month is Assume that “one month later” and the relative date is designated as “10 business days later”.
Here, the target date (search reference date) is generated according to the relative date calculation rule set in the relative date generation unit 18 of the business device 1. The relative date generation unit 18 accesses a special table (business day master 12) of the database 10 when an item related to a business year and a business day is selected on a relative year. As a result, the start of a company's fiscal year and business days are determined and the date is calculated.

First, the relative date generation unit 18 determines whether or not an item that requires input of a value is selected on the displayed relative date designation screen 50 (step S201 in FIG. 9).
When an item that requires input of a value is selected (Yes in step S201), the relative date generation unit 18 performs a null check and a date check (steps S202 and S203).

If there is an error in the value as a result of this check (False in steps S202 and S203), the relative date generation unit 18 displays an error (step S204).
If the value is correct (True in steps S202 and S203) as a result of the check, or if an item that requires input of a value is not selected (No in step S201), the relative date generation unit 18 uses the relative date. The relative date and date format input on the designation screen 50 are stored in the memory 19 (steps S205 and S206), and the relative date and date format data are passed to the search unit 17 (step S207).

Further, the relative date generation unit 18 determines whether the set relative date in the search reference date column 51 is “date” that is directly keyed, “current processing date”, or “operation date”. Is determined (step S208 in FIG. 10). That is, the relative reference date is determined. In this example, since the search start date is the operation date (system date), the process proceeds to S210.
As a result of this determination, when the relative date is “date” in which the key is directly input (direct date input in step S208), the relative date generation unit 18 acquires the date from the relative date designation screen 50 (step S209).

  When the relative date is “operation date” (system date) (operation date in step S208), the relative date generation unit 18 is the clock of the database 10 or the operating system of the business device 1 (hereinafter referred to as “OS”). Today's date (such as system date or OS calendar information) is acquired from the function (step S210). Here, the system date (April 1, 2008) is acquired.

  Furthermore, when the relative date is “current processing date” (operation date in step S208), the relative date generation unit 18 acquires the current processing date from the database 10 or the clock function (step S211).

  Subsequently, the relative date generating unit 18 determines whether or not a condition is input in the relative year, relative month, and relative date fields 52 to 54, calculates the year according to the determination result, and performs a search criterion. Determine the “year” of the date. In this case, the relative date generating unit 18 firstly inputs the conditions “current year”, “year later”, “year ago”, “year”, “current year”, “after year”, “year before”, One of the “year” is determined (step S212). In this example, the process proceeds to step S207 by designating the relative year (current year).

  When the input condition is “current year”, the relative date generation unit 18 uses the system date as a search reference date as it is.

If the input condition is “years after”, “years before”, or “years”, the relative date generation unit 18 calculates the year (step S213).
Furthermore, when the input condition is “current year”, the relative date generating unit 18 calculates a year flag (step S214).

  If the input condition is “after year”, “before year”, or “year”, the relative date generating unit 18 performs the year calculation (step S215) and then calculates the year flag (step S215). S216).

Subsequently, the relative date generation unit 18 determines whether “current month” is selected, “month later”, “month earlier”, and “month” are selected (step S217 in FIG. 11). In this example, the process proceeds to step S218 by specifying the relative month (after months).
As a result of this determination, in the case of the current month, the system date is used as it is. On the other hand, when “after month”, “month before”, and “month” are selected, the month is calculated (step S218). In this example, since one month later, the search reference date is changed to May 1, 2008.

  Next, the relative date generation unit 18 performs a day calculation. In this case, the relative date generation unit 18 first selects “current day”, “last day”, “after day”, “day before”, “day”, or “last business day”. Whether “after business day”, “before business day”, or “business day” is selected (step S219). In this example, the process proceeds to step S224 by specifying the relative date (after 10 business days).

When “current day” is selected, the relative date generating unit 18 takes the “date” of the system date as it is. If “last day” is selected, the relative date generation unit 18 reads the last day of the month from the calendar information of the OS (step S220).
Further, when “after day”, “before day”, and “day” are selected, the relative date generating unit 18 calculates the day from the calendar of the OS (step S221).

  If the “last business day” is selected, the relative date generation unit 18 refers to the business day master 12 to obtain the business day (step S222), and obtains the last business day of the month (step S222). S223).

  Furthermore, when “after business day”, “before business day”, and “business day” are selected, the relative date generation unit 18 refers to the business day master 12 to acquire the business day (step S224), and the business day. The number of days is calculated (step S225). Here, as a result of referring to the business day master 12, 10 days after the business day is calculated. For example, if 5/15/6, 5/10, 5/11, 5/17, and 5/18 are non-business days (closed days), the search base date is 2008, because after 10 business days it will be 5/20. It will be changed on May 20th.

Next, the relative date generation unit 18 checks the year flag indicating the year of the search reference date obtained by calculation (step S226). In this example, since year designation is not performed, the process proceeds to step S227.
If the year flag matches the year flag stored in the database 10 (True in step S226), the relative date generation unit 18 checks the date (step S227). Since the date is valid in this example, the process proceeds to step S228.
If the date is correct (True in step S227), the relative date generating unit 18 calculates the year on the date of the calculation result (step S228). In this example, since the year is not specified, the process proceeds to step S229.

Then, the relative date generation unit 18 sets “year” of the date calculated in the year as the search reference date in the memory 19 (step S229). The search reference date is set (determined) on May 20, 2008.
On the other hand, if there is an error in the year flag check result (false in step S226), or if there is an error in the date check result (false in step S227), the calculated year and date may straddle the year. Therefore, the relative date generation unit 18 returns to the process of S207 and executes recalculation.

Here, an example of the search result when the target data is extracted based on the search conditions generated by the search unit 17 and the relative date generation unit 18 will be given.
When the contents of the business day master 12 are as shown in FIG. 3, for example, at the stage of April 2008, the employee code “0001” and “work schedule” are specified as the search conditions of the search screen 40, and the relative date is specified. On the screen 50, a relative reference date is specified such as relative year “not specified”, relative month “3 months ago”, and relative date “business day” to generate a search reference date. When the attendance time of “” is extracted, as shown in FIG. 12, employee work information is obtained as a search result.

Further, when searching for the address of the same employee on January 1, the employee January 1 address information as shown in FIG. 13 can be obtained simply by specifying the relative date without specifying the year.
In addition, the following business scenes can be used by using the last day or business day. For example, if the target person's extraction at the end of March, salary / bonus transfer request form is deadline of the 4th business day, the person who has no information by the deadline will be extracted. For example, in the case of deadlines for business days, unapproved people are extracted by the due date.

  As described above, according to the personnel information processing system of this embodiment, when searching for personnel information in the database 10 by designating a period range in consideration of the company's business days and holidays, the search reference date is displayed on the search screen 40. If you do not know exactly the year / month / day to be entered, you can call the relative date specification screen 50 and specify the relative year, relative month, and relative date from a certain date. It is possible to reliably specify the search range on the brink of whether or not, and to obtain a correct search result that satisfies the condition.

This system has a search reference date specification function from the past history in addition to the search reference date specification function from the relative date as described above.
In this case, when the relative date (relative period indicating the search range) from the desired date is designated on the relative date designation screen 50, the relative date generation unit 18 operates from the designated relative date. The date of the business date information of the date master 12 is calculated or the date on the calendar stored in advance in the memory 19 is calculated and set as the search reference date. The calendar is not only stored in the memory 19 in advance, but, for example, an OS calendar function may be used.

  In this case, the search unit assigns a name to the search condition (each search parameter) used at the time of search and saves it as a search history in the search condition main master 13 and the search condition detail master 14 of the database 10. If desired, the retrieval condition name is entered in the retrieval condition name field 45 of the retrieval screen 40 and the condition retrieval button 46 is clicked, so that the retrieval unit 17 can retrieve the retrieval condition main master 13 and the retrieval condition detail master in the database 10. 14, the past search conditions (search history) stored in these masters are read, the search start date in the past search conditions is replaced with the current system date, and a new search condition is obtained. To the search screen 40.

  Thus, the user obtains the search reference date based on the past search conditions (search history) from the current date and time without starting the relative date designation screen 50 from the search screen 40 and selecting and inputting the search reference date one by one. This can reduce the labor of input operation.

  As a result, once a date according to the rule is created even in a routine search operation, it is possible to save time and effort for input thereafter. That is, the search conditions once searched are stored (stored or stored) in the search condition main master 13 and the search condition detail master 14 respectively, and any one of the acquisition condition name, sheet name, panel name, etc. is designated. Since the search process can be repeated again under the same conditions, the work efficiency can be improved.

  That is, it is possible to provide an easy-to-use personnel information processing system that can specify a search condition in consideration of a company working day.

  In addition, this invention is not limited only to the said embodiment, You may deform | transform a component in the range which does not deviate from the summary in an implementation stage. In addition, various inventions can be configured by appropriately combining a plurality of constituent elements disclosed in the above embodiment, or by deleting a part of the configuration described in the embodiment.

It is a figure which shows the structure of the personnel information processing system of one Embodiment of this invention. It is a figure which shows the structure of a basic database. It is a figure which shows an example of a business day master. It is a figure which shows an example of a search condition main master. It is a figure which shows an example of a search condition main master. It is a figure which shows a search screen. It is a figure which shows a relative date designation | designated screen. It is a flowchart which shows the search operation by relative date designation | designated of a personnel information processing system. It is a flowchart which shows detailed operation | movement of a relative date production | generation unit. It is a flowchart which shows detailed operation | movement of a relative date production | generation unit. It is a flowchart which shows detailed operation | movement of a relative date production | generation unit. It is a figure which shows employee work information as an example of a search result. It is a figure which shows employee January 1 address information as an example of a search result.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 1 ... Business apparatus (server), 2 ... Client computer (client), 3 ... LAN, 10 ... Database for personnel management, 11 ... Basic database, 12 ... Business day master, 13 ... Search condition main master, 14 ... Search condition Detail master, 16 ... business processing unit, 17 ... search unit, 18 ... relative date generation unit, 21 ... browser.

Claims (2)

A database in which employee information related to employees belonging to a company is stored in association with the change date of the employee information;
A business day master in which business day information corresponding to information indicating the business day and the closed day of the company is stored in a calendar for one year;
A display unit for displaying a screen related to the database search;
An input unit for inputting a search reference date, a search item, and a search condition necessary for searching the database;
A relative date designating unit for displaying a relative date designating screen for designating the search reference date as a relative date as a condition for retrieving employee information on the display unit;
When a relative period indicating a search range is specified on the relative date specification screen, the date is calculated with reference to the business day information of the business day master from the specified relative period, A relative date generator to set the search reference date;
Search the database information using the search reference date input from the input unit or the search reference date set by the relative date generation unit, the search item and its search condition as keys, and the search result A personnel information processing system comprising a search unit for outputting to a screen. A search condition storage unit that can save the search conditions used at the time of naming and save them.
The search unit
Name the search condition and save it as a search history in the search condition storage unit. When a capture condition name is input as desired at the next search, past search conditions stored in the search condition storage unit are stored. read, personnel information processing system according to claim 1, wherein the search start date in the past search conditions on substituted on the current date, and sets a new search condition.

Images