JP7078268B2 - Worker selection equipment, systems, methods, and programs - Google Patents

Description

The present invention relates to a worker selection device, a system, a method, and a program for selecting a worker in charge of maintenance work.

When a failure occurs in a device or system, find a worker who has a free schedule, check whether the found worker has knowledge and experience in disaster recovery work, and have knowledge and experience in disaster recovery work. A worker was selected as a worker for disaster recovery work. Whether or not they had knowledge and experience was confirmed by confirming whether or not they had past work history and whether or not they had attended education related to disaster recovery work. If there is no worker who has knowledge and experience regarding disaster recovery work, the presence or absence of past experience similar to the knowledge and experience regarding disaster recovery work (for example, history of inspection work and adjustment work of the same equipment and system) , I was selecting the worker who seemed to be the most suitable.

Further, regarding the technique of selecting a worker in charge of maintenance work, Patent Documents 1 and 2 refer to the information about the worker when the order information (case) is received by the server, and use the order information as the order information. A system for determining suitable workers for the conditions included is disclosed.

Japanese Unexamined Patent Publication No. 2005-122570 Japanese Unexamined Patent Publication No. 10-07566

The following analysis is given by the inventor of the present application.

However, in the systems of Patent Documents 1 and 2, if there is no worker who has knowledge and experience regarding the disaster recovery work, it may not be possible to select the worker. When the system cannot select a worker, the schedule of each worker is adjusted within the responsible base based on the experience of the administrator who manages the worker, but it is necessary to wait for the worker's schedule to become available. It took a lot of time to select a worker for disaster recovery work. In addition, when the schedule of each worker could not be adjusted within the site in charge and the worker at another site was requested to perform the failure recovery work, it took more time to select the worker for the failure recovery work. ..

A main object of the present invention is to provide a worker selection device, system, method, and program that can contribute to efficient worker selection for disaster recovery work.

The worker selection device according to the first viewpoint includes a storage unit for storing data and a control unit for controlling the storage unit and performing predetermined information processing. The storage unit has a failure response database associated with device names, failure details, parts names, and skill points, a maintenance contract database associated with maintenance contract numbers and customer address information, customer address information, responsible base names, and responsible warehouse names. Maintenance base database associated with, parts inventory database associated with parts name, warehouse name, inventory quantity, worker skill database associated with worker name, affiliation base, device name, skill points, start date and time, completion date and time , Remember the work schedule database associated with the worker name. The control unit has a process of acquiring work request information including a customer name, an apparatus name, a request content, a failure content, a work start date and time, and a work completion date and time, and whether the request content of the work request information is a failure recovery work. Refer to the failure response database, the maintenance contract database, the maintenance base database, and the parts inventory database based on the work request information and the process of determining whether or not the request is for failure recovery work. Then, the process of determining whether or not the part name corresponding to the device name of the work request information is in stock by the responsible warehouse name, and the device name of the work request information by the responsible warehouse name. When the part name corresponding to the above is in stock, the person in charge base is referred to the trouble response database and the worker skill database based on the acquired base name in charge and the work request information. The name, the device name of the work request information, the process of determining whether or not there is the worker name satisfying the skill point condition of the worker skill database, and the worker name satisfying the condition are If there is, there is a space between the work start date and time and the work completion date and time of the work request information with reference to the work schedule database based on the worker name and the work request information. A process of determining whether or not there is a worker name, and a process of determining the worker name to the worker in charge of the request content of the work request information when there is the worker name with a vacancy. I do.

The worker selection system according to the second viewpoint includes a worker selection device according to the first viewpoint and a worker terminal communicably connected to the worker selection device.

The worker selection method according to the third viewpoint is a failure response database associated with device name, failure content, part name, and skill point, a maintenance contract database associated with maintenance contract number, customer address information, and customer address information. A maintenance base database that associates the name of the base in charge and the name of the warehouse in charge, a parts inventory database that associates the parts name, warehouse name, and inventory quantity, and a worker skill database that associates the worker name, affiliated base, device name, and skill points. This is a worker selection method for selecting a worker using a device that stores a work schedule database associated with a start date / time, a completion date / time, and a worker name. The worker selection method includes a step of acquiring work request information including a customer name, an apparatus name, a request content, a failure content, a work start date and time, and a work completion date and time, and the request content of the work request information is a failure recovery work. The step of determining whether or not there is, and when the request content is a failure recovery work, the failure response database, the maintenance contract database, the maintenance base database, and the parts inventory database are based on the work request information. With reference to the step of determining whether or not the part name corresponding to the device name of the work request information is in stock by the responsible warehouse name, and the above-mentioned work request information by the responsible warehouse name. When the part name corresponding to the device name is in stock, the trouble response database and the worker skill database are referred to based on the acquired base name in charge and the work request information. A step of determining whether or not there is a worker name that satisfies the conditions of the base in charge, the device name of the work request information, and the skill points of the worker skill database, and the worker who satisfies the conditions. If there is a name, there is a space between the work start date and time and the work completion date and time of the work request information with reference to the work schedule database based on the worker name and the work request information. A step of determining whether or not there is a certain worker name, and a step of determining the worker name as the worker in charge of the request content of the work request information when there is a vacant worker name. And, including.

The program related to the fourth viewpoint includes a failure response database that associates device names, failure details, parts names, and skill points, a maintenance contract database that associates maintenance contract numbers and customer address information, customer address information, and the name of the base in charge. , Maintenance base database associated with responsible warehouse name, parts inventory database associated with parts name, warehouse name, inventory quantity, worker skill database associated with worker name, affiliation base, device name, skill points, and start. It is a program to be executed by the device that stores the work schedule database associated with the date and time, the completion date and time, and the worker name. The program is a process of acquiring work request information including a customer name, an apparatus name, a request content, a failure content, a work start date and time, and a work completion date and time, and whether or not the request content of the work request information is a failure recovery work. If the request content is a failure recovery work, the failure response database, the maintenance contract database, the maintenance base database, and the parts inventory database are referred to based on the work request information. Then, the process of determining whether or not the part name corresponding to the device name of the work request information is in stock by the responsible warehouse name, and the device name of the work request information by the responsible warehouse name. When the corresponding part name is in stock, the person in charge name is referred to the failure response database and the worker skill database based on the acquired base name in charge and the work request information. , The device name of the work request information, the process of determining whether or not there is the worker name satisfying the skill point condition of the worker skill database, and the worker name satisfying the condition. In this case, based on the worker name and the work request information, the work schedule database is referred to, and the work has a space between the work start date and time and the work completion date and time in the work request information. A process of determining whether or not there is a person's name, and a process of determining the worker's name as the worker in charge of the request content of the work request information when there is the worker's name with a vacancy. Let it run.

The program can be recorded on a computer-readable storage medium. The storage medium may be a non-transient such as a semiconductor memory, a hard disk, a magnetic recording medium, or an optical recording medium. Further, in the present disclosure, it is also possible to embody it as a computer program product. The program is input to the computer device via an input device or an external communication interface, stored in the storage device, drives the processor according to a predetermined step or process, and outputs the process result including the intermediate state as necessary. Each stage can be displayed via a display device, or can communicate with the outside via a communication interface. Computer devices for that purpose typically include, for example, a processor, a storage device, an input device, a communication interface, and, if necessary, a display device that can be connected to each other by a bus.

According to the first to fourth viewpoints, it is possible to contribute to efficient selection of workers for disaster recovery work.

It is a block diagram which shows typically the structure of the worker selection system which concerns on Embodiment 1. FIG. It is an image diagram schematically showing an example of the data structure of the reception work database used in the worker selection system which concerns on Embodiment 1. FIG. It is an image diagram schematically showing an example of the data structure of the maintenance contract database used in the worker selection system according to the first embodiment. It is an image diagram schematically showing an example of the data structure of the apparatus configuration database used in the worker selection system which concerns on Embodiment 1. FIG. It is an image diagram schematically showing an example of the data structure of the component life database used in the worker selection system according to the first embodiment. It is an image diagram schematically showing an example of the data structure of the work schedule database used in the worker selection system which concerns on Embodiment 1. FIG. It is an image diagram schematically showing an example of the data structure of the parts inventory database used in the worker selection system according to the first embodiment. It is an image diagram schematically showing an example of the data structure of the worker skill database used in the worker selection system which concerns on Embodiment 1. FIG. It is an image diagram schematically showing an example of the data structure of the trouble response database used in the worker selection system according to the first embodiment. It is an image diagram schematically showing an example of the data structure of the maintenance base database used in the worker selection system according to the first embodiment. It is a 1st flowchart which schematically shows the operation of the control part of the worker selection apparatus in the worker selection system which concerns on Embodiment 1. FIG. It is a 2nd flowchart which schematically shows the operation of the control part of the worker selection apparatus in the worker selection system which concerns on Embodiment 1. FIG. It is a 3rd flowchart which schematically shows the operation of the control part of the worker selection apparatus in the worker selection system which concerns on Embodiment 1. FIG. It is a 4th flowchart which schematically shows the operation of the control part of the worker selection apparatus in the worker selection system which concerns on Embodiment 1. FIG. FIG. 5 is a fifth flowchart illustrating the operation of the control unit of the worker selection device in the worker selection system according to the first embodiment. FIG. 6 is a sixth flowchart illustrating the operation of the control unit of the worker selection device in the worker selection system according to the first embodiment. It is a block diagram which shows typically the structure of the worker selection apparatus which concerns on Embodiment 2. FIG. It is a block diagram which shows the structure of a hardware resource schematically.

In the present disclosure described below, the worker selection device according to the mode 1 and the modification mode thereof can be appropriately selected and combined.

As the worker selection device according to the mode 1, a storage unit for storing data and a control unit for controlling the storage unit and performing predetermined information processing are provided, and the storage unit has a device name and a failure content. , Part name, failure response database associated with skill points, maintenance contract database associated with maintenance contract number, customer address information, maintenance base database associated with customer address information, responsible base name, responsible warehouse name, and part name. , Warehouse name, parts inventory database associated with inventory quantity, worker skill database associated with worker name, affiliation base, device name, skill points, and work schedule database associated with start date / time, completion date / time, and worker name. And, the control unit has a process of acquiring work request information including a customer name, a device name, a request content, a failure content, a work start date and time, and a work completion date and time, and the request content of the work request information. The process of determining whether or not it is a failure recovery work, and when the request content is a failure recovery work, based on the work request information, the failure response database, the maintenance contract database, the maintenance base database, and With reference to the parts inventory database, the process of determining whether or not the part name corresponding to the device name in the work request information is in stock by the responsible warehouse name, and the work by the responsible warehouse name. If the part name corresponding to the device name in the request information is in stock, refer to the failure response database and the worker skill database based on the acquired base name in charge and the work request information. Then, the process of determining whether or not there is the name of the person in charge, the name of the device in the work request information, and the name of the worker who satisfies the conditions of the skill points in the worker skill database, and the conditions. If there is the worker name to be satisfied, the work start date and time and the work completion date and time of the work request information are referred to with reference to the work schedule database based on the worker name and the work request information. The process of determining whether or not there is a worker name with a vacancy, and if there is a worker name with a vacancy, the worker name is the worker in charge of the request content of the work request information. It is possible to have a worker selection device that performs the process of determining the database.

As a modification mode of the worker selection device according to the mode 1, the maintenance base database is associated with the customer address information, the responsible base name, the responsible warehouse name, at least one suburban base name, and at least one warehouse name. In the process of determining whether or not the part name corresponding to the device name in the work request information is in stock in the warehouse name in charge, the process is based on the device name and the failure content in the work request information. Then, referring to the failure response database, the maintenance contract database is created based on the process of acquiring the device name, the component name corresponding to the failure content, and the skill points, and the maintenance contract number of the work request information. Refer to the process of acquiring the customer address information corresponding to the maintenance contract number, and based on the acquired customer address information, refer to the maintenance base database and refer to the name of the base in charge corresponding to the customer address information and Based on the process of acquiring the warehouse name in charge and the acquired parts name and the warehouse name in charge, the parts inventory database is referred to to see if there is inventory of the parts name corresponding to the parts name in the warehouse name. It can include a process of determining whether or not.

As a modification mode of the worker selection device according to the mode 1, the maintenance base database contains the customer address information, the responsible base name, the responsible warehouse name, the at least one suburban base name, and the at least one suburban warehouse name. , The acquisition time from the suburban warehouse name to the responsible warehouse name is associated, and the control unit acquires the part name when the part name corresponding to the part name is not in stock in the responsible warehouse name. Based on the above, the process of determining whether or not the part name corresponding to the part name is in stock in the suburban warehouse name by referring to the maintenance base database and the parts inventory database, and the suburban warehouse name. If there is an inventory of the part name corresponding to the part name, the warehouse related to the suburban warehouse name is used to perform the failure recovery work based on the acquired part name and the acquired warehouse name in charge. The process of instructing the replenishment of parts to the warehouse related to the name of the warehouse in charge, referring to the maintenance base database, acquiring the acquisition time from the name of the suburban warehouse to the name of the warehouse in charge, and the work of the work request information. The process of calculating the post-addition work start date and time and the post-addition work completion date and time by adding the acquired acquisition time to the start date and time and the work completion date and time, and the post-addition work start date and time and the post-addition work completion date and time were calculated. After that, based on the acquired base in charge name and the work request information, the trouble response database and the worker skill database are referred to, and the charge base name and the device name of the work request information are referred to. , And the process of determining whether or not there is the worker name satisfying the skill point condition of the worker skill database, and if there is the worker name satisfying the condition, the worker name is calculated. There is a vacancy between the post-addition work start date and time and the post-addition work completion date and time with reference to the work schedule database based on the post-addition work start date and time and the post-addition work completion date and time. A process of determining whether or not there is a worker name, and a process of determining the worker name to the worker in charge of the request content of the work request information when there is the worker name with a vacancy. Can be done further.

As a modification mode of the worker selection device according to the mode 1, the control unit has acquired the part name and the acquired person in charge when the part name corresponding to the part name is not in stock in the suburban warehouse name. Based on the warehouse name and the process of instructing the replenishment of parts from the outside to the warehouse related to the warehouse in charge before the failure recovery work and acquiring the acquisition time from the outside to the warehouse, and the work request information. The process of calculating the post-addition work start date and time and the post-addition work completion date and time by adding the acquired acquisition time to the work start date and time and the work completion date and time, and the post-addition work start date and time and the post-addition work completion date and time. Based on the acquired base in charge name and work request information, the trouble response database and the worker skill database are referred to to obtain the name of the base in charge and the work request information. The process of determining whether or not there is the worker name satisfying the device name and the skill point condition of the worker skill database, and the worker name if there is the worker name satisfying the condition. With reference to the work schedule database based on the calculated post-addition work start date and time and the post-addition work completion date and time, there is a space between the post-addition work start date and time and the post-addition work completion date and time. The process of determining whether or not there is the worker name, and if there is the worker name with a vacancy, the worker name is determined as the worker in charge of the request content of the work request information. Processing and can be done further.

As a modification mode of the worker selection device according to the mode 1, the control unit acquires the customer address information when there is no worker name satisfying the above conditions or when there is no vacant worker name. Based on the process of acquiring the suburban base name by referring to the maintenance base database, the acquired suburban base name, and the work request information, the failure response database and the worker. With reference to the skill database, a process of determining whether or not there is a worker name that satisfies the conditions of the suburban base name, the device name of the work request information, and the skill points of the worker skill database. If there is a worker name that satisfies the above conditions, the work schedule database is created based on the worker name, the work request information, the calculated post-addition work start date and time, and the post-addition work completion date and time. With reference to the work request information, there is a worker name having a space between the work start date and time and the work completion date and time, or between the post-addition work start date and time and the post-addition work completion date and time. It is possible to further perform a process of determining whether or not, and a process of determining the worker name to the worker in charge of the request content of the work request information when there is a vacant worker name. can.

As a modification mode of the worker selection device according to the mode 1, the storage unit further stores a reception work database in which past work request information is stored, and the control unit does not have the worker name satisfying the above conditions. If, or if there is no vacant worker name, the acquired worker name and the work start date and time and the work completion date and time of the work request information, or the work start date and time after the addition and the addition Based on the work completion date and time, referring to the work schedule database and the reception work database, between the work start date and time and the work end date and time of the work request information, or the work start date and time after the addition and the addition. The process of determining whether the request content corresponding to the worker name whose work schedule has already been decided between the post-work completion date and time is other than the failure recovery work, and the case where the request content is other than the failure recovery work. , The process of determining the worker name to the worker in charge of the request content of the work request information can be further performed.

As a modification mode of the worker selection device according to the mode 1, when the request content is a failure recovery work, the control unit determines to postpone the work start date and time until a worker who can perform the failure recovery work appears. Further processing can be performed.

In the present disclosure, as the worker selection system according to the mode 2, it is possible to include a worker selection device according to the mode 1 and a worker terminal communicably connected to the worker selection device.

In the present disclosure, as a worker selection method according to mode 3, a failure response database associated with a device name, a failure content, a part name, and a skill point, a maintenance contract database associated with a maintenance contract number, and customer address information, and a customer address are used. A maintenance base database that associates information, the name of the base in charge, and the name of the warehouse in charge, a parts inventory database that associates the parts name, warehouse name, and inventory quantity, and a worker that associates the worker name, affiliation base, device name, and skill points. It is a worker selection method that selects a worker using a device that stores a skill database, a work schedule database that associates a start date / time, a completion date / time, and a worker name. A step of acquiring work request information including a failure content, a work start date and time, and a work completion date and time, a step of determining whether or not the request content of the work request information is a failure recovery work, and a step of determining whether the request content is a failure recovery work. In the case of work, based on the work request information, the work request information is referred to by the responsible warehouse name with reference to the failure response database, the maintenance contract database, the maintenance base database, and the parts inventory database. The step of determining whether or not the part name corresponding to the device name is in stock, and the case where the part name corresponding to the device name in the work request information is in stock in the responsible warehouse name are acquired. Based on the person in charge base name and the work request information, the trouble response database and the worker skill database are referred to, and the person in charge base name, the device name of the work request information, and the above. The step of determining whether or not there is the worker name satisfying the skill point condition of the worker skill database, and if there is the worker name satisfying the condition, the worker name and the work request information Based on, a step of referring to the work schedule database to determine whether or not there is a worker name having a space between the work start date and time and the work completion date and time of the work request information. When there is the worker name with the vacancy, it is possible to include a step of determining the worker name to the worker in charge of the request content of the work request information.

In this disclosure, as a program related to mode 4, a failure response database associated with a device name, a failure content, a part name, and a skill point, a maintenance contract database associated with a maintenance contract number and customer address information, a customer address information, and a person in charge A maintenance base database associated with the base name and the name of the warehouse in charge, a parts inventory database associated with the parts name, warehouse name, and inventory quantity, and a worker skill database associated with the worker name, affiliated base, device name, and skill points. , Start date and time, completion date and time, work schedule database associated with worker name, and a program to be executed by the device that stores the customer name, device name, request content, failure content, work start date and time, work completion date and time. A process of acquiring work request information including, a process of determining whether or not the request content of the work request information is a failure recovery work, and a process of determining whether the request content is a failure recovery work, based on the work request information. Then, referring to the failure handling database, the maintenance contract database, the maintenance base database, and the parts inventory database, the inventory of the parts name corresponding to the device name of the work request information in the responsible warehouse name is used. The process of determining whether or not there is, and when the part name corresponding to the device name of the work request information is in stock in the responsible warehouse name, the acquired base in charge name and the work request information. Based on, the failure response database and the worker skill database are referred to, and the conditions of the responsible base name, the device name of the work request information, and the skill points of the worker skill database are set. Refer to the work schedule database based on the process of determining whether or not there is the worker name to be satisfied, and if there is the worker name satisfying the conditions, the worker name and the work request information. Then, there is a process of determining whether or not there is a worker name having a vacancy between the work start date and time and the work completion date and time of the work request information, and a case where there is the worker name having a vacancy. , The process of determining the worker name by the worker in charge of the request content of the work request information can be executed.

Hereinafter, embodiments will be described with reference to the drawings. It should be noted that the reference numerals to the drawings in the present application are provided solely for the purpose of assisting understanding, and are not intended to be limited to the illustrated embodiments. Further, the following embodiments are merely examples, and do not limit the present invention. Further, the connecting line between blocks such as drawings referred to in the following description includes both bidirectional and unidirectional. The one-way arrow schematically shows the flow of the main signal (data), and does not exclude bidirectionality. Further, in the circuit diagram, block diagram, internal configuration diagram, connection diagram, etc. shown in the disclosure of the present application, although not explicitly stated, an input port and an output port exist at the input end and the output end of each connection line, respectively. The same applies to the input / output interface. The program is executed via the computer device, the computer device comprises, for example, a processor, a storage device, an input device, a communication interface, and a display device as needed, and the computer device is in the device or through the communication interface. It is configured to be able to communicate with external devices (including computers) regardless of whether it is wired or wireless.

[Embodiment 1]
The worker selection system according to the first embodiment will be described with reference to the drawings. FIG. 1 is a block diagram schematically showing the configuration of the worker selection system according to the first embodiment.

The worker selection system 1 is a system that selects the optimum worker according to the work mode and changes in the situation (see FIG. 1). The worker selection system 1 includes a worker selection device 10, a network 20, a worker terminal 30, and a customer terminal 50. In FIG. 1, only one worker terminal 30 and one customer terminal 50 are used for simplification of the explanation, but one or both of the worker terminal 30 and the customer terminal 50 may be present. Details of the work mode and the selection conditions of the worker will be described later.

The worker selection device 10 is a device that selects the optimum worker according to the work mode and changes in circumstances (see FIG. 1). As the worker selection device 10, an information processing device (computer) such as a workstation server or a personal computer installed in a maintenance support department or the like can be used. The worker selection device 10 is communicably connected to the worker terminal 30 and the customer terminal 50 via the network 20. The worker selection device 10 performs predetermined information processing by executing a program. The worker selection device 10 includes a communication unit 11, a control unit 12, an input unit 13, an output unit 14, and a storage unit 15.

The communication unit 11 is a functional unit that communicates predetermined information, data, or signals between the worker selection device 10, the worker terminal 30, and the customer terminal 50 (see FIG. 1). The communication unit 11 is communicably connected to the worker terminal 30 and the customer terminal 50 via the network 20. The communication unit 11 transmits and receives under the control of the control unit 12. For the communication unit 11, for example, a network interface such as a LAN (Local Area Network) card, a network adapter, or a network interface card can be used.

The control unit 12 is a functional unit that controls the communication unit 11, the input unit 13, the output unit 14, and the storage unit 15 (see FIG. 1). For the control unit 12, for example, a unit such as a CPU (Central Processing Unit) or an MPU (Micro Processor Unit) can be used, and not only one unit but also a plurality of units may be used. The control unit 12 is electrically connected (or bus connection is also possible) to the communication unit 11, the input unit 13, the output unit 14, and the storage unit 15. The control unit 12 controls the communication unit 11 to send and receive information to the worker terminal 30 and the customer terminal 50. The control unit 12 controls the input unit 13 to take in the information input from the input unit 13. The control unit 12 controls the output unit 14 to output information to the output unit 14. The control unit 12 inputs / outputs information to / from the storage unit 15, and writes / reads data to / from the databases 41 to 49 stored in the storage unit 15. The control unit 12 reads a program (including the worker selection program 40) stored in the storage unit 15, loads it into the main memory, and executes it to perform predetermined information processing.

The input unit 13 is a functional unit for inputting information (see FIG. 1). The input unit 13 is controlled by the control unit 12, and information is input by the operation of the user of the worker selection device 10. For the input unit 13, for example, a keyboard, a mouse, a touch panel, a microphone, or other input means can be used, and even if an information terminal having an input unit that is communicably connected via a communication unit (not shown) is used. good.

The output unit 14 is a functional unit that outputs information (for example, display, audio output, printing, etc.) (see FIG. 1). The output unit 14 outputs under the control of the control unit 12. For the output unit 14, for example, a display for displaying, a printer for printing, mail transmission, or other output means can be used, and an information terminal having an output unit communicably connected via a communication unit (not shown). Etc. may be used.

The storage unit 15 is a functional unit that stores information such as data, a database, and a program (see FIG. 1). Here, the program can be downloaded via the network or updated using a storage medium in which the program is stored. The storage unit 15 inputs / outputs information and writes / reads data to / from databases 41 to 49 under the control of the control unit 12. For the storage unit 15, for example, a RAM (Random Access Memory), a hard disk device, an externally connected RAID (Redundant Arrays of Independent Disks) device, or the like can be used, and any storage device may be used. The storage unit 15 includes a worker selection program 40, a reception work database 41 (see FIG. 2), a maintenance contract database 42 (see FIG. 3), a device configuration database 43 (see FIG. 4), and parts as main information. Life database 44 (see FIG. 5), work schedule database 45 (see FIG. 6), parts inventory database 46 (see FIG. 7), worker skill database 47 (see FIG. 8), and fault response database 48 (see FIG. 8). 9) and the maintenance base database 49 (see FIG. 10) are stored. Details of databases 41 to 49 will be described later.

The worker selection program 40 is a program for selecting an optimum worker according to a work mode and a change in circumstances. The worker selection program 40 is executed by the control unit 12. The details of the operation of the control unit 12 when the worker selection program 40 is executed will be described later.

The network 20 is an information communication network that communicably connects the worker selection device 10, the worker terminal 30, and the customer terminal 50 (see FIG. 1). The network 20 may be an intranet, a local network, or the like, and may include one or both of a wired network and a wireless network.

The worker terminal 30 is an information terminal used by the worker (see FIG. 1). As the worker terminal 30, for example, a personal computer, a notebook terminal, a tablet terminal, a smartphone, or the like can be used. The worker terminal 30 is communicably connected to the worker selection device 10 via the network 20. The worker terminal 30 performs predetermined information processing by executing a program. The worker terminal 30 has a communication unit 31, a control unit 32, an input unit 33, an output unit 34, and a storage unit 35 as main components.

The worker terminal 30 only needs to be able to input and output data to and from the worker selection device 10, and is not an essential component of the present invention, but is an input unit 13 and an output unit 14 of the worker selection device 10 and is a worker terminal 30. You may substitute the function of.

The communication unit 31 is a functional unit that transmits / receives predetermined information, data, or a signal between the worker terminal 30 and the worker selection device 10 (see FIG. 1). The communication unit 31 is communicably connected to the network 20 and communicates under the control of the control unit 32. For the communication unit 31, for example, a network interface such as a LAN (Local Area Network) card, a network adapter, or a network interface card can be used.

The control unit 32 is a functional unit that controls the communication unit 31, the input unit 33, the output unit 34, and the storage unit 35 (see FIG. 1). For the control unit 32, for example, a unit such as a CPU (Central Processing Unit) or an MPU (Micro Processor Unit) can be used, and not only one unit but also a plurality of units may be used. The control unit 32 is electrically connected (or bus connection is also possible) to the communication unit 31, the input unit 33, the output unit 34, and the storage unit 35. The control unit 32 controls the communication unit 31 to send and receive information to and from the worker selection device 10. The control unit 32 controls the input unit 33 to take in the information input from the input unit 33. The control unit 32 controls the output unit 34 to cause the output unit 34 to output information. The control unit 32 writes and reads information from the storage unit 35. The control unit 32 reads out the program stored in the storage unit 35, loads it into the main storage unit, and executes it to perform predetermined information processing.

The input unit 33 is a functional unit for inputting information (see FIG. 1). The input unit 33 is controlled by the control unit 32, and information is input by the operation of the user of the worker terminal 30. For the input unit 33, for example, a keyboard, a mouse, a touch panel, a microphone, or other input means can be used, and even if an information terminal having an input unit that is communicably connected via a communication unit (not shown) is used. good.

The output unit 34 is a functional unit for outputting information (display, audio output, printing, etc.) (see FIG. 1). The output unit 34 outputs under the control of the control unit 32. For the output unit 34, for example, a display for displaying, a printer for printing, or other output means can be used, and an information terminal or the like having an output unit communicably connected via a communication unit (not shown) is used. You may.

The storage unit 35 is a functional unit that stores information such as data, a database, and a program (see FIG. 1). The storage unit 35 writes and reads information under the control of the control unit 32. Here, the program can be downloaded via the network or updated using a storage medium in which the program is stored. For the storage unit 35, for example, a RAM (Random Access Memory), a hard disk device, an externally connected RAID (Redundant Arrays of Independent Disks) device, or the like can be used, and any storage device may be used.

The customer terminal 50 is an information terminal used by the customer (see FIG. 1). As the customer terminal 50, for example, a personal computer, a notebook terminal, a tablet terminal, a smartphone, or the like can be used. The customer terminal 50 is communicably connected to the worker selection device 10 via the network 20. The customer terminal 50 performs predetermined information processing by executing a program. The customer terminal 50 has a communication unit 51, a control unit 52, an input unit 53, an output unit 54, and a storage unit 55 as main components.

The communication unit 51 is a functional unit that transmits / receives predetermined information, data, or a signal between the customer terminal 50 and the worker selection device 10 (see FIG. 1). The communication unit 51 is communicably connected to the network 20, and communicates under the control of the control unit 52. For the communication unit 51, for example, a network interface such as a LAN (Local Area Network) card, a network adapter, or a network interface card can be used.

The control unit 52 is a functional unit that controls the communication unit 51, the input unit 53, the output unit 54, and the storage unit 55 (see FIG. 1). For the control unit 52, for example, a unit such as a CPU (Central Processing Unit) or an MPU (Micro Processor Unit) can be used, and not only one unit but also a plurality of units may be used. The control unit 52 is electrically connected (or bus connection is also possible) to the communication unit 51, the input unit 53, the output unit 54, and the storage unit 55. The control unit 52 controls the communication unit 51 to send and receive information to and from the worker selection device 10. The control unit 52 controls the input unit 53 to take in the information input from the input unit 53. The control unit 52 controls the output unit 54 to cause the output unit 54 to output information. The control unit 52 writes and reads information from the storage unit 55. The control unit 52 reads out the program stored in the storage unit 55, loads it into the main storage unit, and executes it to perform predetermined information processing.

The input unit 53 is a functional unit for inputting information (see FIG. 1). The input unit 53 is controlled by the control unit 52, and information is input by the operation of the user of the customer terminal 50. For the input unit 53, for example, a keyboard, a mouse, a touch panel, a microphone, or other input means can be used, and an information terminal or the like having an input unit that is communicably connected via a communication unit (not shown) may be used. good.

The output unit 54 is a functional unit for outputting information (display, audio output, printing, etc.) (see FIG. 1). The output unit 54 outputs under the control of the control unit 52. For the output unit 54, for example, a display for displaying, a printer for printing, or other output means can be used, and an information terminal or the like having an output unit communicably connected via a communication unit (not shown) is used. You may.

The storage unit 55 is a functional unit that stores information such as data, a database, and a program (see FIG. 1). The storage unit 55 writes and reads information under the control of the control unit 52. Here, the program can be downloaded via the network or updated using a storage medium in which the program is stored. For the storage unit 55, for example, a RAM (Random Access Memory), a hard disk device, an externally connected RAID (Redundant Arrays of Independent Disks) device, or the like can be used, and any storage device may be used.

Next, the reception work database (41 in FIG. 1) used in the worker selection system according to the first embodiment will be described with reference to the drawings. FIG. 2 is an image diagram schematically showing an example of the data structure of the reception work database used in the worker selection system according to the first embodiment.

The reception work database 41 is a database for managing information related to the work for which the request has been received (see FIG. 2). The reception work database 41 stores the reception number, maintenance contract number, work request, customer name, device name, request content, work start date and time, work completion date and time, replacement parts, and parts acquisition time in association with each other. The maintenance contract number and the device name are information that identifies the device to be worked on. The work start date and time and the work completion date and time may be desired dates and times. The content of the request includes the content of the failure if the request is recovery from the failure. When receiving information for requesting work (work request information), various information included in the work request information (corresponding to the configuration information of the reception work database 41) is registered in the reception work database 41 in association with each other.

Next, the maintenance contract database (42 in FIG. 1) used in the worker selection system according to the first embodiment will be described with reference to the drawings. FIG. 3 is an image diagram schematically showing an example of the data structure of the maintenance contract database used in the worker selection system according to the first embodiment.

The maintenance contract database 42 is a database for managing information related to maintenance contracts (maintenance contract information) (see FIG. 3). The maintenance contract database 42 stores the customer name, the maintenance contract number, the customer number, the customer telephone number, the customer e-mail address, the customer address information, the contract start date, and the final inspection date in association with each other. Here, if the regular inspection is not contracted, the contract start date and the final inspection date are the same day. The maintenance contract database 42 is used for confirming the existence of a maintenance contract, confirming whether or not it is within the maintenance contract period, and confirming the name, contact information, location information, etc. of the customer who has made a maintenance contract.

Next, the device configuration database (43 in FIG. 1) used in the worker selection system according to the first embodiment will be described with reference to the drawings. FIG. 4 is an image diagram schematically showing an example of the data structure of the device configuration database used in the worker selection system according to the first embodiment.

The device configuration database 43 is a database for managing the configuration of devices for which maintenance contracts have been made (see FIG. 4). The device configuration database 43 stores the maintenance contract number, the device name, the device number, and the part number / last replacement date in association with each other. The device number is a number corresponding to the maintenance contract number and the device name. Even if the maintenance contract number is the same, the device number will be different if there are a plurality of the same devices. The part number is the number of the part constituting the device. In the example of the device configuration database (43 in FIG. 1), when confirming the part numbers constituting the device having a certain maintenance contract number, the maintenance contract number A111111 indicates all the device names "AAAAA" associated with the maintenance contract. The device number "01" is obtained, the part numbers "00001" and "00002" corresponding to the obtained device numbers are obtained, and the final replacement date "2018/4/20" of the part number "00001" is obtained.

Next, the component life database (44 in FIG. 1) used in the worker selection system according to the first embodiment will be described with reference to the drawings. FIG. 5 is an image diagram schematically showing an example of the data structure of the component life database used in the worker selection system according to the first embodiment.

The component life database 44 is a database for managing the lifetime of components of each device (see FIG. 5). The part life database 44 stores the device name, the part number, the recommended replacement elapsed time, the required elapsed time for replacement, and the order lead time in association with each other. Here, the recommended replacement elapsed time is the elapsed time after the previous replacement that recommends the replacement of the parts, and can be the elapsed time after the operation of the device if there is no replacement history of the parts. The recommended replacement elapsed time may differ depending on the customer's device operating conditions, usage start time, region, etc., even if the device name is the same. Further, the required replacement time is the elapsed time after the previous replacement in which the parts need to be replaced, and can be the elapsed time after the operation of the device if there is no replacement history of the parts. The order lead time is the time required from ordering the parts to obtaining them. In the example of the part life database (44 in FIG. 1) of FIG. 5, the part number “20000” is recommended to be replaced after the elapsed time after the operation of the device is 12000 hours, so that the elapsed time has passed during the inspection work. If so, replace the part during inspection work. The parts life database 44 is used when instructing parts to be replaced at the time of periodic inspection and instructing to obtain the parts to be replaced.

Next, the work schedule database (45 in FIG. 1) used in the worker selection system according to the first embodiment will be described with reference to the drawings. FIG. 6 is an image diagram schematically showing an example of the data structure of the work schedule database used in the worker selection system according to the first embodiment.

The work schedule database 45 is a database for managing the work schedule for each worker (see FIG. 6). The work schedule database 45 stores the month, day, start time, completion time, reception number, worker name, and remarks in association with each other. In the example of the work schedule database of FIG. 6 (45 of FIG. 1), the work is scheduled for January 1, and the worker "○○○○" is from "00:00" to "11:00". There is a work schedule for the reception number "1111111".

Next, the parts inventory database (46 in FIG. 1) used in the worker selection system according to the first embodiment will be described with reference to the drawings. FIG. 7 is an image diagram schematically showing an example of the data structure of the parts inventory database used in the worker selection system according to the first embodiment.

The parts inventory database 46 is a database for managing the inventory quantity for each part. The parts inventory database 46 stores a part name, a part number, a warehouse name, and an inventory quantity in association with each other. The warehouse name is information that identifies the warehouse that stores the parts. In the example of the parts inventory database of FIG. 7 (46 of FIG. 1), when the part number “00001” constituting the device name “AAAAAA” is obtained from the device configuration database (43 of FIG. 1; see FIG. 4), the parts inventory is obtained. From the database (46 in FIG. 1; see FIG. 7), the warehouse name “aa11” and the inventory quantity “01” corresponding to the part number “00001” can be obtained.

Next, the worker skill database (47 in FIG. 1) used in the worker selection system according to the first embodiment will be described with reference to the drawings. FIG. 8 is an image diagram schematically showing an example of the data structure of the worker skill database used in the worker selection system according to the first embodiment.

The worker skill database 47 is a database for managing skills for each worker (see FIG. 8). The worker skill database 47 stores the worker code, the worker name, the affiliation base, the device name, and the skill points in association with each other. In the example of the worker skill database of FIG. 8 (47 of FIG. 1), the worker “○○○○” has a skill point “500” for the device name “AAAAAA”. Skill points are information that quantifies the degree of work skill of a worker for a device. Skill points can be given according to the education attendance history, the number of work times, the work difficulty level, etc. for each device, and can also be determined by a predetermined calculation formula from such information.

Next, the failure response database (48 in FIG. 1) used in the worker selection system according to the first embodiment will be described with reference to the drawings. FIG. 9 is an image diagram schematically showing an example of the data structure of the failure response database used in the worker selection system according to the first embodiment.

The failure response database 48 is a database for managing information when responding to past failure recovery work (see FIG. 9). The failure response database 48 stores the device name, the failure content, the failure cause, the component name, and the skill point in association with each other. The part name is the name of the part that caused the failure. The part name may be a part number. The skill point here is the minimum value information that quantifies the degree of work skill. In the example of the failure response database (48 in FIG. 1) of FIG. 9, when confirming the failure cause and the failure component corresponding to the failure content "event A" of the device name "AAAAAA", the failure content "event A" is selected. Then, the cause of failure "cause A", the part name "ABC111", and the skill point "300" can be obtained. The skill points here are determined for each work target device and work content. No skill points are required for planning work. Skill points are set for each device for on-site adjustment work and regular inspection work. Each skill point of the on-site adjustment work and the periodic inspection work may be the same skill point. Skill points for disaster recovery work are determined according to the equipment and the nature of the failure that occurred.

Next, the maintenance base database (49 in FIG. 1) used in the worker selection system according to the first embodiment will be described with reference to the drawings. FIG. 10 is an image diagram schematically showing an example of the data structure of the maintenance base database used in the worker selection system according to the first embodiment.

The maintenance base database 49 is a database for managing information about maintenance bases (see FIG. 10). The maintenance base database 49 includes customer address information, the base in charge, the first suburb base, the second suburb base, the warehouse in charge, the acquisition time from the warehouse in charge, the acquisition time from the first suburb warehouse and the first suburb warehouse, and the second suburb. The acquisition time from the warehouse and the second suburban warehouse is stored in association with each other. The maintenance base database 49 can be used, for example, when there is no worker at the base in charge when responding to planning work, when searching for a worker who can handle at the first suburb base or the second suburb base, or parts in the warehouse in charge. If there is no, it can be used when searching for parts that can be procured in the first suburban warehouse or the second suburban warehouse. The first suburban base corresponds to the first suburban warehouse, and the second suburban base corresponds to the second suburban warehouse. The number of suburban bases and suburban warehouses that substitute for the responsible base and the responsible warehouse is two, but the number is not limited to this, and at least one may be sufficient.

Next, the details of the working mode will be described. There are four types of work: planning work, on-site adjustment work, periodic inspection work, and failure recovery work.

(1-1) Planned work The planned work is the work in which the work contents are predetermined. In the planned work, the work plan and the work contents are defined. In planning work, there is no work depending on the situation. Knowledge and experience are required only in the event of work mistakes or failure in setting up the device. However, work can be done if the person has the basic ability to perform predetermined work such as installation of products and predetermined settings. The planning work defined here only requires skills that allow easy parts replacement, and does not require knowledge or experience skills. The planning work is an easy work that does not require skill because it is possible to learn the method of replacing only the parts to be replaced in the planning work at that time with a margin before the work. It is often wasteful to select a worker who has higher knowledge and experience in consideration of work mistakes and troubles when setting the equipment, so work mistakes and equipment settings It is sufficient to send a worker with more knowledge and experience to the work site after the failure occurs, or to listen to the situation by communication means such as telephone and give instructions by a worker with more knowledge and experience. be. Therefore, the level of knowledge and experience required for planning work is low. Knowledge of the device, etc. (including system construction including the network) that is the target of the work is not essential, and it is sufficient if the instructed work content can be understood.

(1-2) Necessary conditions for planned work Select a worker whose free time matches the schedule and time zone planned in advance for the work. It suffices to have the basic ability to perform the specified work. Therefore, the level of knowledge and experience required is low. In the installation (including cable connection) work, if you make a mistake when installing the software, setting the software, or setting the network, or if you follow the work procedure but it does not work, the target device, etc. Knowledge and experience are required. However, these are the same as in the case of the above-mentioned work mistake or failure in setting the device. Therefore, the required knowledge and experience may not be necessary, and here, the knowledge and experience are treated as unnecessary work. Select a new worker who has basic ability (that is, no skill (knowledge or experience) is required) to perform the specified work. However, only when the work schedule overlaps with the previously set work schedule and the new work schedule, a worker whose work schedule and time zone are matched with the worker's free time is selected.

(2-1) On-site adjustment work On-site adjustment work is work in which the work content is determined in advance. Compared to planning work, on-site adjustment work requires not only pre-determined work, but also knowledge and experience regarding product settings (product assembly and software installation, etc.) specified for each product. be. The on-site adjustment work defined here does not require parts replacement or the like. Therefore, the on-site adjustment work does not include the replacement of parts and the like. As for the knowledge about the equipment (including the system) that is the target of the on-site adjustment work, it is necessary to have the knowledge to the extent that the adjustment work is possible, such as the setting of the newly installed network on the site. However, on-site adjustment work is work that occurs within a fixed work range, and the level of knowledge and experience required is moderate among planning work, on-site adjustment work, periodic inspection work, and failure recovery work. be.

(2-2) Necessary conditions for on-site adjustment work In on-site adjustment work, a worker who matches the customer's requested schedule and time zone of the work with the free time of the worker is selected. On-site adjustment work requires knowledge and experience of adjustment work. Therefore, the level of knowledge and experience required is moderate in planning work, on-site adjustment work, periodic inspection work, and disaster recovery work. On-site adjustment work may not require flexible work, and the level of knowledge and experience required is moderate among planning work, on-site adjustment work, periodic inspection work, and disaster recovery work. The knowledge and experience of on-site adjustment work will be treated as the same level of work as the regular inspection work below.

(3-1) Periodic inspection work The periodic inspection work has the following characteristics in addition to the characteristics of the planned work. Periodic inspection work is work in which a work plan and its work contents are determined in advance. However, the periodic inspection work is not a one-off operation, but carries out the inspection targets and inspection items predetermined at intervals predetermined by contracts and the like. Periodic inspection work requires knowledge and experience regarding inspection contents. For periodic inspection work, detailed knowledge about the equipment, etc. (including system construction including the network) that is the target of the work is not essential, and it is sufficient if the contents of the inspection work can be understood.

(3-2) Necessary conditions for periodic inspection work In the periodic inspection work, a worker who matches the customer's requested schedule and time zone of the work with the free time of the worker is selected. Regular inspection work requires knowledge and experience of inspection work. Therefore, the level of knowledge and experience required is moderate in planning work, on-site adjustment work, periodic inspection work, and disaster recovery work. Periodic inspection work may not require flexible work, and the level of knowledge and experience required is moderate among planning work, on-site adjustment work, periodic inspection work, and failure recovery work. The knowledge and experience of regular inspection work is treated as the same level of work as the above-mentioned on-site adjustment work.

(4-1) Failure recovery work The failure recovery work is the work of recovering a device or the like in which a failure has occurred within a predetermined time or as soon as possible. In the disaster recovery work, knowledge and experience of the disaster recovery work are required because the process from the confirmation of the failure contents to the recovery work is performed. The failure recovery work includes the work of identifying the parts that are the cause of the failure. In the failure recovery work, there are cases where the cause of the failure is simply determined from the content of the failure, and there are cases where it is relatively easy to recover from the failure, and there are cases where it is not easy to understand the cause of the failure. Disaster recovery work requires a wide range of knowledge and experience regarding the equipment targeted for disaster recovery work. In the failure recovery work, it is necessary to determine the degree of knowledge and experience required for the worker for each device in which the failure has occurred, and to select the worker based on the knowledge, experience, and achievements for each failure content.

(4-2) Necessary conditions for disaster recovery work Since disaster recovery work occurs suddenly due to a failure, select a worker whose schedule and time requested by the customer match the free time of the worker. Since the failure recovery work is a flexible work, the required value of knowledge and experience of the failure recovery work depends on the device that caused the failure and the content of the failure, but the level of knowledge and experience is high. Disaster recovery work requires detailed knowledge and a lot of experience depending on the device that caused the failure and the content of the failure. In disaster recovery work, the schedule and start time are specified, and the worker requires a high level of knowledge and experience, so the work is limited to those who can handle it, and it may be difficult to select the worker. In the disaster recovery work, a worker who can perform the disaster recovery work is selected from the work being performed or scheduled to be performed in the other three work forms, and the work of the worker who has been transferred from the other work form is performed. It is necessary to assign another worker who meets the conditions for performing the work. Therefore, disaster recovery work may require flexible work, knowledge, and experience, and the level of knowledge and experience required for disaster recovery work is planning work, on-site adjustment work, periodic inspection work, and failure recovery. It is the largest in the work. In the other three work modes, necessary parts and the like can be prepared in advance, but in the failure recovery work, it is necessary to obtain replacement parts and the like of parts having different failures depending on the content of the failure. In the disaster recovery work, if necessary, tools, etc. and information necessary for the failure recovery work (instruction manual for the device that caused the failure, replacement procedure manual for the parts that are estimated to have failed, setting information that disappears due to replacement, etc.) Also included) is required. In the failure recovery work, it takes time to obtain in the order of the worker's possession, the inventory of the base where the worker is waiting, the inventory of the warehouse, and the order from the manufacturer, and the work schedule is after the acquisition of the parts and the like. In the disaster recovery work, it is necessary to match the acquisition time of parts, etc., the work date and time, and the work startable date and time (worker's free time, after obtaining parts, etc.). That is, in the failure recovery work, the work can be performed only after the work startable date and time after the parts and the like are obtained. The conditions for obtaining parts, etc. are added to the conditions for selecting workers (worker's free time, etc. after obtaining parts, etc.) only when the worker for disaster recovery work is selected.

The selection conditions of the worker according to each work form are shown below.

[1] Knowledge and experience It is essential to have the essential knowledge and experience required of workers according to each work form. Select a worker who has the required essential knowledge and experience according to each work form. Select a worker whose skill points corresponding to the target work mode are equal to or higher than a predetermined value. Skill points are numerical values representing knowledge and experience that are judged to be capable of performing work corresponding to the target work form. The predetermined value is set for each work. Workers with high skill points can do any work, and the number of workers is limited. Workers with low skill points have a limited number of possible tasks and a large number. When there is a shortage of workers whose skill points corresponding to the target work form are equal to or higher than the predetermined value, workers whose skill points are lower than the predetermined value are assigned to the work corresponding to the target work form.

[2] Substitute Work mode work without a substitute is prioritized over work mode work with a substitute. However, the substitute must have the knowledge and experience necessary for the work form of the work, and the worker who does not have the necessary knowledge and experience cannot be the substitute.

[3] Priority between work modes Work modes with high priority between work modes are prioritized. Of the planning work, on-site adjustment work, periodic inspection work, and failure recovery work, the failure recovery work has the highest priority. The priorities of planning work, periodic inspection work, and on-site adjustment work, for which work days are set in advance, shall be the same.

[4] Change of substitute and change of work schedule Change of substitute and change of work schedule are performed depending on whether or not there is a worker who can perform the work with the work schedule. If there is no substitute, another form of work with more knowledge and experience, and the planned worker is a worker capable of the work, the worker has more knowledge and experience. Change to another work, and assign another worker to the work that the worker was supposed to do, or change the work schedule if there is no substitute. That is, when there is an alternative candidate, when the work schedule can be changed, when the work schedule overlaps with the work of the original plan, or when another worker becomes an alternative candidate for the difficult work. Take turns working with alternative candidates. If the work schedule overlaps with the work of the original plan, change it to a work schedule that does not overlap with the work schedule of other work.

[5] Whether or not substitution is possible between each work form of the worker It is a condition that the worker has the knowledge and experience that the work of the work form of the alternative destination can be carried out. The level of knowledge and experience required for the work of the alternative work form increases in the order of planning work, on-site adjustment work, periodic inspection work, and disaster recovery work, and here, it is necessary for on-site adjustment work and periodic inspection work. The level of knowledge and experience is the same.

Next, the operation of the control unit of the worker selection device in the worker selection system according to the first embodiment will be described with reference to the drawings. 11 to 16 are flowcharts schematically showing the operation of the control unit of the worker selection device in the worker selection system according to the first embodiment. Please refer to FIG. 1 for the components of the worker selection system.

Before going into the description of FIGS. 11 to 16, the basic concept of the operation of the control unit 12 of the worker selection device 10 will be outlined.

The (real-time) update of the worker is input by the input unit 13 of the worker selection device 10, whether or not it is a failure recovery work as a work form, the work schedule, request information of the target device, etc., and other than the failure recovery work. Select a worker who meets the conditions from the work type, schedule, time zone, and work place every time the conditions change.

If there is no worker who meets the above conditions at the base, among the other workers planned at the same time as this work and selected for other work with a lower priority than this work. Select a worker who meets the knowledge and experience level to perform this work.

A worker who satisfies the above conditions is assigned to another worker who can perform the work as an alternative worker who performs the work planned by the worker in the time zone of the selected worker, and the work is performed. Replace the person.

The priority of worker replacement is that workers with a high degree of knowledge and experience are in short supply, and workers with a high degree of knowledge and experience are replaced with work that requires that knowledge and experience. Is appropriate, and if the worker's schedule and time zone are available, the worker who meets the above conditions is selected as it is.

However, in the case of a worker whose schedule and time are not open, if the work to be performed by the worker is a work that requires less knowledge and experience than the knowledge and experience possessed by the worker, or if the work is planned to be carried out. If the work is being done, the required level of the knowledge and experience is higher, and the work is replaced with the work that requires the knowledge and experience.

If a worker with a high degree of knowledge and experience moves to another work with a higher level of knowledge and experience, the missing worker will be available on the requested schedule and time according to the conditions. Select from workers.

Select and replace the work of the worker who is performing or planning to perform good work with less knowledge and experience than the worker has, and the level of knowledge and experience of the work is equal to or lower than that. Allocate to work that requires knowledge and experience.

If there is no such worker, select a worker who satisfies the above conditions from the workers at the base or the base where the travel time to the customer is short.

In the first selection, the worker is selected as the worker at the base in charge of the work occurrence location, but if there is a shortage or not, the travel time to that base (or work location) is short, etc. Select from the workers at the base.

If the schedule or time is exceeded, the next schedule of each worker is canceled and the work is continued, and the worker is selected for each work of the next schedule according to the above-mentioned priority.

For worker selection, prepare a correspondence table with each worker in advance for knowledge and experience.

In addition, it is desirable to check the schedule and time zone availability of each worker on the schedule table, and to memorize the work form, place, and knowledge experience as work information for the schedule and time zone filled with work. ..

Subsequently, FIGS. 11 to 16 will be described in detail.

First, the control unit 12 of the worker selection device 10 acquires work request information (step A1 in FIG. 11).

Here, the work request information includes the maintenance contract number, the work request, the customer name, the device name, the work content, the work start date and time, and the work completion date and time. The work request information can be acquired from the customer terminal 50 by e-mail, telephone, FAX (facsimile), an input form, or the like. If the work request information is voice, the work request information can be obtained from the text data converted into text by voice recognition, and if the work request information is e-mail, the work request information can be obtained from the text data of the e-mail body, and FAX. In the case of, the work request information can be acquired from the text data obtained by the character recognition by the image recognition. As the work request information, a character string that matches a plurality of character strings registered in advance may be recognized, and work request information corresponding to the recognized character string may be acquired. As the work request information, the receptionist inputs the information obtained from the e-mail, telephone, FAX, and input form by operating the input unit 13 of the worker selection device 10, but inputs the information into a predetermined standard form by e-mail. The software may determine the work request information and acquire the input information or the information input in the input form without human intervention. The device name may be obtained by referring to the device configuration database 43 by the maintenance contract number of the work request information acquired by e-mail, FAX, or the like. The customer name may be acquired by referring to the maintenance contract database 42 by the maintenance contract number of the work request information acquired by e-mail, FAX, or the like. When inputting to the input form, a pull-down menu method, a radio button method, or a text input method may be used.

Next, the control unit 12 of the worker selection device 10 confirms whether or not the same information as the information (for example, telephone number, e-mail address) in the acquired work request information exists in the maintenance contract database 42. , Determine whether or not there is a maintenance contract (step A2 in FIG. 11). If there is a maintenance contract (YES in step A2), the process proceeds to step A5.

When there is no maintenance contract (NO in step A2), the control unit 12 of the worker selection device 10 acquires maintenance contract information and device configuration information, registers the acquired maintenance contract information in the maintenance contract database 42, and acquires the information. The device configuration information is registered in the device configuration database 43 (step A3 in FIG. 11).

Here, the maintenance contract information includes a customer name, a maintenance contract number, a customer number, a customer telephone number, a customer e-mail address, a customer address information, a contract start date, and a final inspection date. Further, the device configuration information includes a maintenance contract number, a device name, and a part number. The maintenance contract information and the device configuration information can be acquired from the worker terminal 30 or the input unit 13 of the worker selection device 10.

Next, the control unit 12 of the worker selection device 10 registers the part number in the parts inventory database 46 based on the part number of the device configuration information registered in the device configuration database 43 in step A3 (step 11 in FIG. 11). A4).

In step A4, the part name is registered, the warehouse and the inventory quantity are determined, and the parts of the determined inventory quantity are stocked in the determined warehouse.

If there is a maintenance contract (YES in step A2), or after step A4, the control unit 12 of the worker selection device 10 registers the work request information acquired in step A1 in the reception work database 41 (FIG. 11). Step A5).

Next, the control unit 12 of the worker selection device 10 determines whether or not the request content of the work request information acquired in step A1 is a planned work (step A6 in FIG. 11). If the content of the request is planning work (YES in step A6), the process proceeds to step B1.

When the request content is not planned work (NO in step A6), the control unit 12 of the worker selection device 10 determines whether or not the request content of the work request information acquired in step A1 is a failure recovery work (FIG. Step A7 of 11. If the content of the request is disaster recovery work (YES in step A7), the process proceeds to step C1.

If the request content is not a failure recovery work (NO in step A7), the control unit 12 of the worker selection device 10 determines whether the request content of the work request information acquired in step A1 is the on-site adjustment work (NO). Step A8 in FIG. 11). If the content of the request is on-site adjustment work (YES in step A8), the process proceeds to step A14.

When the request content is not the on-site adjustment work (NO in step A8), the control unit 12 of the worker selection device 10 determines that the request content of the work request information acquired in step A1 is the periodic inspection work (FIG. 11). Step A9).

After step A9 or after step C23, the control unit 12 of the worker selection device 10 sets the skill points required for the work to A (step A10 in FIG. 11).

Here, skill point A indicates the minimum level of skills that can be performed on-site adjustment work and periodic inspection work, which are determined for each work target device.

Next, the control unit 12 of the worker selection device 10 refers to the reception work database 41, the maintenance contract database 42, the device configuration database 43, and the component life database 44 based on the work request information acquired in step A1. , It is determined whether or not the parts need to be replaced during the periodic inspection work (step A11 in FIG. 11). If the parts do not need to be replaced during the periodic inspection work (NO in step A11), the process proceeds to step A16.

Here, it can be determined as follows whether or not the parts need to be replaced in the periodic inspection work. First, based on the work request information acquired in step A1, the scheduled work date is acquired by referring to the work start date and time and the work completion date and time of the reception work database 41. Next, based on the work request information acquired in step A1, the maintenance contract number is acquired with reference to the maintenance contract database 42. Next, based on the acquired maintenance contract number, the part number is acquired with reference to the device configuration database 43. Next, based on the acquired part number, the previous replacement date is acquired with reference to the component life database 44. Next, the operating time elapsed from the time of the previous parts replacement is calculated from the difference between the acquired scheduled work date and the acquired previous replacement date. Next, based on the acquired part number, the recommended replacement elapsed time is acquired with reference to the component life database 44. Next, the acquired recommended replacement elapsed time is compared with the calculated operating time. If the operating time is longer than the recommended replacement time, it is determined that the part with the relevant part number needs to be replaced during this periodic inspection work. Even if the operating time is shorter than the recommended replacement time, if the difference time is within a predetermined time, it may be determined that the part with the part number needs to be replaced during the periodic inspection work. .. For example, assuming that the elapsed time after the device operation of the part number "20000" is 12000 hours, the operating time from the previous replacement date is the same as the recommended replacement elapsed time. It is the recommended elapsed time for replacement of parts, etc., and it is judged that the part with the relevant part number needs to be replaced during this periodic inspection work.

When parts need to be replaced during the periodic inspection work (YES in step A11), the control unit 12 of the worker selection device 10 determines whether or not it is necessary to replenish the replacement parts to the warehouse in charge before the periodic inspection work. (Step A12 in FIG. 11). If it is not necessary to replenish the replacement parts to the warehouse in charge by the time of the periodic inspection work (NO in step A12), the process proceeds to step A16.

Here, since the timing of the periodic inspection work is known, the maintenance contract database 42 and the maintenance base database are based on the replacement parts to be replaced during the periodic inspection work and the maintenance contract number of the work request information acquired in step A1. With reference to 49 and the parts inventory database 46, the inventory quantity of the warehouse in charge is acquired, and the acquired inventory quantity is equal to or greater than the sum of the predetermined appropriate inventory quantity and the required quantity of parts to be replaced during periodic inspection work. Judging whether or not there is, if the inventory quantity is more than the sum, it is judged that it is not necessary to replenish the replacement parts to the warehouse in charge, and if the inventory quantity is less than the sum, the replacement parts to the warehouse in charge are Judge that replenishment is necessary.

If it is necessary to replenish the replacement parts to the warehouse in charge before the periodic inspection work (YES in step A12), the control unit 12 of the worker selection device 10 will supply the replacement parts to the warehouse in charge before the periodic inspection work. Instruct replenishment (output instruction information) (step A13 in FIG. 11). Then, the process proceeds to step A16.

Here, the instruction to replenish the shortage quantity of replacement parts is to order the shortage quantity of replacement parts from the warehouse in charge so that the replacement parts will reach the warehouse in charge by the time of periodic inspection work. Make up for the shortage quantity. At this time, the acquisition time until the replacement part is acquired is acquired.

When the request content is on-site adjustment work (YES in step A8), or after step C27, the control unit 12 of the worker selection device 10 sets the skill points required for the work to A (step 11 in FIG. 11). A14).

Next, the control unit 12 of the worker selection device 10 sets the component acquisition time of the reception work database 41 to 0 hours (step A15 in FIG. 11). Then, the process proceeds to step A16.

Here, in the case of on-site adjustment work, since the parts necessary for the work are unnecessary, the parts acquisition time is set to 0 hours. The on-site adjustment work defined in the present invention is a work that does not require parts replacement or the like. Therefore, the work does not include parts replacement.

If parts replacement is not required during the periodic inspection work (NO in step A11), if replacement parts do not need to be replenished to the responsible warehouse before the periodic inspection work (NO in step A12), after step A13, or in step. After A15, the control unit 12 of the worker selection device 10 acquires the customer address information by referring to the maintenance contract database 42 based on the customer name of the work request information acquired in step A1, and the acquired customer address. Based on the information, the maintenance base database 49 is referred to to acquire the responsible base (step A16 in FIG. 11).

Next, the control unit 12 of the worker selection device 10 determines the responsible base acquired in step A16, the device name of the work request information acquired in step A1, the skill point A set in step A9 or step A14, and the skill point A. Based on, with reference to the worker skill database 47, is there a worker who satisfies the affiliation base that matches the responsible base, the device name that matches the device name, and the skill point conditions of the skill point A or higher? It is determined whether or not (step A17 in FIG. 12). If there is no worker who satisfies the conditions of the assigned base, the device, and the skill point (NO in step A17), the process proceeds to step A24.

When there is a worker who satisfies the conditions of the responsible base, the device, and the skill point (YES in step A17), the control unit 12 of the worker selection device 10 refers to the worker skill database 47, and the responsible base, the device, And acquire the worker name that satisfies the conditions of skill points (step A18 in FIG. 12).

Next, the control unit 12 of the worker selection device 10 refers to the work schedule database 45 based on the worker name acquired in step A18 and the work start date and time of the work request information acquired in step A1. , It is determined whether or not there is a worker who has a vacancy between the work start date and time and the work completion date and time of the work request information (step A19 in FIG. 12). If there is no worker with a vacancy (NO in step A19), the process proceeds to step A24.

Here, the determination of whether or not there is a worker who has a vacancy between the work start date and time and the work completion date and time of the work request information matches the worker name acquired in step A18 with reference to the work schedule database 45. It is determined whether or not the conditions of the worker name and the date and time (month, day, start time, and completion time) that conflict between the work start date and time and the work completion date and time of the work request information are satisfied. If the conditions of the worker name and the date and time are satisfied, it is determined that there is no worker with a vacancy, and if the conditions of the worker name and the date and time are not satisfied, it is determined that there is a worker with a vacancy.

When there is a vacant worker (YES in step A19, YES in step A27, YES in step B6, YES in step B10, YES in step C11, or YES in step C15), the control unit of the worker selection device 10. 12 is a worker name obtained in step A18, step A26, step B5, step B9, step C10, or step C14, which has a vacancy, based on a predetermined standard set in advance. The worker in charge of the work of the work request information acquired in step A1 is determined (step A20 in FIG. 12).

Here, a predetermined standard is set according to the situation, for example, the worker with the highest skill point is selected among the workers with vacancy, or the skill point is selected among the workers with vacancy. Can select the lowest worker.

After step A20, after step A29, after step A32, after step C17, after step C21, or after step C25, the control unit 12 of the worker selection device 10 has acquired the work request in step A1. Work schedule information is generated based on the information, the maintenance contract database 42, the worker name if the worker has been determined, and the postponement if the work start date and time has been postponed (step A21). ..

Here, the work schedule information includes the worker name, work request, customer name, device name, request content, work start date and time, work completion date and time, replacement parts, inventory quantity, parts acquisition time, customer telephone number, and customer e-mail address. , And information including customer address information. In the case of failure recovery work, the work schedule information can further include the details of the failure, the location where the failure occurred, the parts where the failure occurred, and the skill points.

Next, the control unit 12 of the worker selection device 10 outputs the work schedule information generated in step A21 (step A22).

Here, the work schedule information is output not only from the output unit 14 of the worker selection device 10 (display, printing, voice output, mail transmission, etc.) but also by the information terminal of the transmission destination of the worker selection device 10. It may be output (display, audio output, printing, etc.) or may be transmitted to the worker terminal 30.

Finally, the control unit 12 of the worker selection device 10 updates the work schedule database 45 based on the work schedule information generated in step A21 (step A23), and then ends.

When there is no worker who satisfies the conditions of the assigned base, the device, and the skill point (NO in step A17), or when there is no worker who has a vacancy (NO in step A19), the control unit 12 of the worker selection device 10 Acquires a suburban base (first suburban base, second suburban base) with reference to the maintenance base database 49 based on the customer address information acquired in step A16 (step A24 in FIG. 12).

Next, the control unit 12 of the worker selection device 10 determines the suburban base acquired in step A24, the device name of the work request information acquired in step A1, the skill point A set in step A9 or step A14, and the skill point A. Based on, referring to the worker skill database 47, the affiliation base that matches the suburban base (first suburban base, second suburban base), the device name that matches the device name, and the skill point A or higher. It is determined whether or not there is a worker who satisfies the skill points of (step A25 in FIG. 12). If there is no worker who meets the conditions of the suburban base, the device, and the skill point (NO in step A25), the process proceeds to step A32.

When there is a worker who satisfies the conditions of the suburban base, the device, and the skill point (YES in step A25), the control unit 12 of the worker selection device 10 refers to the worker skill database 47, and the suburban base, the device, And acquire the worker name that satisfies the conditions of skill points (step A26 in FIG. 12).

Next, the control unit 12 of the worker selection device 10 refers to the work schedule database 45 based on the worker name acquired in step A26 and the work request information acquired in step A1, and the work request is made. It is determined whether or not there is a worker who has a vacancy between the work start date and time and the work completion date and time of the information (step A27 in FIG. 12). If there is a vacant worker (YES in step A27), the process proceeds to step A20. If there is no worker with a vacancy (NO in step A27), the process proceeds to step A28.

Here, the determination of whether or not there is a worker who has a vacancy between the work start date and time and the work completion date and time of the work request information matches the worker name acquired in step A26 with reference to the work schedule database 45. It is determined whether or not the conditions of the worker name and the date and time (month, day, start time, and completion time) that conflict between the work start date and time and the work completion date and time of the work request information are satisfied. If the conditions of the worker name and the date and time are satisfied, it is determined that there is no worker with a vacancy, and if the conditions of the worker name and the date and time are not satisfied, it is determined that there is a worker with a vacancy.

When there is no worker with a vacancy (NO in step A27), the control unit 12 of the worker selection device 10 sets the worker name acquired in step A18 or step A26 and the work request information acquired in step A1. Based on this, with reference to the work schedule database 45 and the reception work database 41, the request content corresponding to the worker whose work schedule has already been determined between the work start date and time and the work end date and time of the work request information is the planning work. (Step A28 in FIG. 12). If the request content is not planned work (NO in step A28), the process proceeds to step A32.

When the request content is planned work (YES in step A28), the control unit 12 of the worker selection device 10 is among the worker names acquired in step A18 or step A26 based on a predetermined standard set in advance. Therefore, a worker in charge of the work of the work request information acquired in step A1 is determined (step A29 in FIG. 12), and then the process proceeds to steps A21 and A30.

After step A29, the control unit 12 of the worker selection device 10 has already determined a work schedule between the work start date and time and the work end date and time of the work request information acquired in step A1 from the work schedule database 45. The work schedule information corresponding to the person is deleted (step A30 in FIG. 12).

Next, the control unit 12 of the worker selection device 10 acquires the work request information corresponding to the work schedule information (month, day, start time, completion time) deleted in step A30 (step A31 in FIG. 12). Then, the process proceeds to step B1.

If there is no worker who meets the conditions of the suburbs, equipment, and skill points (NO in step A25), if the request content is not planned work (NO in step A28), or if the request content is not on-site adjustment work (step). C24 NO), the control unit 12 of the worker selection device 10 determines to postpone the work start date and time until a worker who can perform periodic inspection work or on-site adjustment work appears (step A32 in FIG. 12), and then a step. Proceed to A21.

When the request content is planned work (YES in step A6), after step A31 or after step C19, the control unit 12 of the worker selection device 10 sets the skill points required for the work to 0 (YES in step A6). Step B1) in FIG.

Here, since the planning work is a predetermined work, knowledge and experience skills are not required.

Next, the control unit 12 of the worker selection device 10 sets the component acquisition time of the reception work database 41 to 0 hours (step B2 in FIG. 13).

Here, in the case of planned work, since the parts necessary for the work are prepared in advance, the parts acquisition time is set to 0 hours.

Next, the control unit 12 of the worker selection device 10 refers to the maintenance contract database 42 based on the customer name of the work request information acquired in step A1 or step A31, and the customer address information corresponding to the customer name. Is acquired, and based on the acquired customer address information, the maintenance base database 49 is referred to, and the responsible base corresponding to the customer address information is acquired (step B3 in FIG. 13).

Next, the control unit 12 of the worker selection device 10 refers to the worker skill database 47 based on the responsible base acquired in step B3 and the device name of the work request information acquired in step A1 or step A31. Then, it is determined whether or not there is a worker who satisfies the condition of the affiliated base that matches the responsible base and the device name that matches the device name (step B4 in FIG. 13). If there is no worker who meets the conditions of the site in charge and the device (NO in step B4), the process proceeds to step B7.

When there is a worker who satisfies the conditions of the responsible base and the device (YES in step B4), the control unit 12 of the worker selection device 10 refers to the worker skill database 47 and determines the conditions of the responsible base and the device. Acquire the worker name to be satisfied (step B5 in FIG. 13).

Next, the control unit 12 of the worker selection device 10 refers to the work schedule database 45 based on the worker name acquired in step B5 and the work request information acquired in step A1 or step A31. It is determined whether or not there is a worker who has a vacancy between the work start date and time and the work completion date and time of the work request information (step B6 in FIG. 13). If there is no worker with a vacancy (NO in step B6), the process proceeds to step B7.

If there is no worker who satisfies the conditions of the site in charge and the device (NO in step B4), or if there is no worker with a vacancy (NO in step B6), the control unit 12 of the worker selection device 10 steps. Based on the customer address information acquired in B3, the suburban bases (first suburban base, second suburban base) are acquired with reference to the maintenance base database 49 (step B7 in FIG. 13).

Next, the control unit 12 of the worker selection device 10 refers to the worker skill database 47 based on the suburban base acquired in step B7 and the device name of the work request information acquired in step A1 or step A31. Then, it is determined whether or not there is a worker who satisfies the conditions of the affiliated base that matches the suburban base (first suburban base, second suburban base) and the device name that matches the device name (step in FIG. 13). B8). If there is no worker who meets the conditions of the suburban base and the device (NO in step B8), the process proceeds to step A32.

When there is a worker who satisfies the conditions of the suburban base and the device (YES in step B8), the control unit 12 of the worker selection device 10 refers to the worker skill database 47 and determines the conditions of the suburban base and the device. Acquire the worker name to be satisfied (step B9 in FIG. 13).

Next, the control unit 12 of the worker selection device 10 refers to the work schedule database 45 based on the worker name acquired in step B9 and the work request information acquired in step A1 or step A31. It is determined whether or not there is a worker who has a vacancy between the work start date and time and the work completion date and time of the work request information (step B10 in FIG. 13). If there is a vacant worker (YES in step B10), the process proceeds to step A20. If there is no worker with a vacancy (NO in step B10), the process proceeds to step A32.

When the request content is a failure recovery work (YES in step A7), the control unit 12 of the worker selection device 10 uses the failure response database 48 based on the device name and the failure content of the work request information acquired in step A1. With reference to this, the device name, the component name corresponding to the failure content, and the skill point B are acquired (step C1 in FIG. 14).

Here, the skill point B acquired in step C1 is a value larger than the skill point A set in step A10 or step A14.

Next, the control unit 12 of the worker selection device 10 refers to the maintenance contract database 42 based on the maintenance contract number of the work request information acquired in step A1, and obtains the customer address information corresponding to the maintenance contract number. Acquire (step C2 in FIG. 14).

Next, the control unit 12 of the worker selection device 10 refers to the maintenance base database 49 based on the customer address information acquired in step C2, and provides information on the responsible base and the responsible warehouse corresponding to the customer address information. (Step C3 in FIG. 14).

Next, the control unit 12 of the worker selection device 10 refers to the parts inventory database 46 based on the part name acquired in step C1 and the information related to the warehouse in charge acquired in step C3, and is in charge of the part. It is determined whether or not the required quantity of parts corresponding to the part name is in stock in the warehouse (step C4 in FIG. 14). If the required quantity of the corresponding parts is in stock at the warehouse in charge (YES in step C4), the process proceeds to step C9.

When the required quantity of the corresponding parts is not in stock at the warehouse in charge (NO in step C4), the control unit 12 of the worker selection device 10 refers to the parts inventory database 46 based on the parts name acquired in step C1. Then, it is determined whether or not the required quantity of parts corresponding to the part names is in stock in the warehouse other than the warehouse in charge acquired in step C3 (step C5 in FIG. 14). If the required quantity of the corresponding parts is in stock at a warehouse other than the warehouse in charge (YES in step C5), the process proceeds to step C7.

When the corresponding parts are not in stock in a warehouse other than the warehouse in charge (NO in step C5), the control unit 12 of the worker selection device 10 is assigned to the part name acquired in step C1 and the warehouse in charge acquired in step C3. Based on the relevant information, the external (for example, parts trading company, etc.) instructs the warehouse in charge to replenish the replacement parts (outputs the instruction information) and obtains the acquisition time of the replacement parts before the failure recovery work (for example, the parts trading company). Step C6 in FIG. 14). Then, the process proceeds to step C8.

Here, the instruction to replenish the replacement parts is to replenish the replacement parts to the warehouse in charge so that the replacement parts will reach the warehouse in charge by the time the failure recovery work is performed, such as by ordering the warehouse in charge to replenish the replacement parts. I will do it. At this time, the acquisition time until the replacement part is acquired is acquired. In addition, the time to obtain replacement parts includes information necessary for tools and other disaster recovery work (for example, a manual for the device that has failed, a procedure manual for replacing parts that are estimated to have failed, and settings that will be lost by replacement. Information etc.) acquisition time is included.

In addition, in the three work modes other than the failure recovery work, necessary materials can be prepared in advance, but the failure recovery work requires replacement parts, etc. corresponding to the parts in which the failure has occurred, which are different depending on the content of the failure. It takes time to obtain the parts in the order of the worker's possession, the inventory of the base where the worker is waiting, the inventory of the warehouse, and the manufacturer's order. It is necessary to match the date and time with the date and time when the work can be started (after the worker's free time, parts, etc. are obtained). That is, the failure recovery work can be performed only after the work start date and time after the replacement parts and the like are obtained.

When the corresponding parts are in stock in a warehouse other than the warehouse in charge (YES in step C5), the control unit 12 of the worker selection device 10 puts the part name acquired in step C1 and the warehouse in charge acquired in step C3. Based on the relevant information, the warehouse other than the warehouse in charge is instructed to replenish the replacement parts to the warehouse in charge (instruction information is output), and the acquisition time of the replacement parts is acquired (FIG. 14). Step C7). Then, the process proceeds to step C8.

Here, the instruction to replenish the replacement parts is in charge so that the replacement parts arrive at the warehouse in charge by the time of the failure recovery work, such as instructing the warehouse in charge to replenish the replacement parts from a warehouse other than the warehouse in charge. Replenish the warehouse with replacement parts. At this time, the acquisition time until the replacement part is acquired is acquired by referring to the maintenance base database 49. In addition, the time to obtain replacement parts includes information necessary for tools and other disaster recovery work (for example, a manual for the device that has failed, a procedure manual for replacing parts that are estimated to have failed, and settings that will be lost by replacement. Information etc.) acquisition time is included.

After step C6 or after step C7, the control unit 12 of the worker selection device 10 obtains the work request information acquired in step A1 at the work start date and time and the work completion date and time acquired in step C6 or step C7. The post-addition work start date and time and the post-addition work completion date and time after adding the time are calculated (step C8 in FIG. 14).

When the corresponding parts are in stock at the responsible warehouse (YES in step C4), or after step C8, the control unit 12 of the worker selection device 10 acquires the responsible base acquired in step C3 and the acquired base in step A1. Based on the device name of the work request information and the skill point B acquired in step C1, the worker skill database 47 is referred to, and the affiliation site that matches the responsible site and the device name that matches the device name. , And, it is determined whether or not there is a worker who satisfies the condition of the skill point of the skill point B or higher (step C9 in FIG. 15). If there is no worker who satisfies the conditions of the assigned base, the device, and the skill point (NO in step C9), the process proceeds to step C12.

When there is a worker who satisfies the conditions of the responsible base, the device, and the skill point (YES in step C9), the control unit 12 of the worker selection device 10 refers to the worker skill database 47, and the responsible base, the device, And acquire the worker name that satisfies the conditions of skill points (step C10 in FIG. 15).

Next, the control unit 12 of the worker selection device 10 has the worker name acquired in step C10, the work start date and time and the work completion date and time of the work request information acquired in step A1 (the work start date and time after addition in step C8 and the work start date and time). When the post-addition work completion date and time is calculated, the work start date and time and the work completion date and time of the work request information are referred to based on the post-addition work start date and time and the post-addition work completion date and time). It is determined whether or not there is a worker who has a space between the two (step C11 in FIG. 15). If there is a vacant worker (YES in step C11), the process proceeds to step A20.

Here, it is determined whether or not there is a worker who has a vacancy between the work start date and time and the work completion date and time of the work request information (or between the work start date and time after addition and the work completion date and time after addition). With reference to the schedule database 45, the worker name that matches the worker name acquired in step C10, and the date and time (month, day, start) that conflicts between the work start date and time and the work completion date and time of the work request information. Judge whether or not the conditions of (time and completion time) are satisfied. If the conditions of the worker name and the date and time are satisfied, it is determined that there is no worker with a vacancy, and if the conditions of the worker name and the date and time are not satisfied, it is determined that there is a worker with a vacancy.

Here, a predetermined standard is set according to the situation, for example, the worker with the highest skill point is selected among the workers with vacancy, or the skill point is selected among the workers with vacancy. Can select the lowest worker.

When there is no worker who satisfies the conditions of the assigned base, the device, and the skill point (NO in step C9), or when there is no worker who has a vacancy (NO in step C11), the control unit 12 of the worker selection device 10 Acquires a suburban base (first suburban base, second suburban base) with reference to the maintenance base database 49 based on the customer address information acquired in step C2 (step C12 in FIG. 15).

Next, the control unit 12 of the worker selection device 10 is based on the suburban base acquired in step C12, the device name of the work request information acquired in step A1, and the skill point B acquired in step C1. With reference to the worker skill database 47, the affiliation base that matches the suburban base (first suburban base, second suburban base), the device name that matches the device name, and the skill points of skill point B or higher It is determined whether or not there is a worker who satisfies the condition (step C13 in FIG. 15). If there is no worker who meets the conditions of the suburban base, the device, and the skill point (NO in step C13), the process proceeds to step C16.

When there is a worker who satisfies the conditions of the suburban base, the device, and the skill point (YES in step C13), the control unit 12 of the worker selection device 10 refers to the worker skill database 47, and the suburban base, the device, And acquire the worker name that satisfies the conditions of skill points (step C14 in FIG. 15).

Next, the control unit 12 of the worker selection device 10 has the worker name acquired in step C14, the work start date and time and the work completion date and time of the work request information acquired in step A1 (the work start date and time after addition in step C8 and the work start date and time). When the post-addition work completion date and time is calculated, the work start date and time and the work completion date and time of the work request information are referred to based on the post-addition work start date and time and the post-addition work completion date and time). It is determined whether or not there is a worker who has a space between the two (step C15 in FIG. 15). If there is a vacant worker (YES in step C15), the process proceeds to step A20.

Here, it is determined whether or not there is a worker who has a vacancy between the work start date and time and the work completion date and time of the work request information (or between the work start date and time after addition and the work completion date and time after addition). With reference to the schedule database 45, the worker name that matches the worker name acquired in step A26, and the date and time (month, day, start) that conflicts between the work start date and time and the work completion date and time of the work request information. Judge whether or not the conditions of (time and completion time) are satisfied. If the conditions of the worker name and the date and time are satisfied, it is determined that there is no worker with a vacancy, and if the conditions of the worker name and the date and time are not satisfied, it is determined that there is a worker with a vacancy.

When there is no worker who satisfies the conditions of the suburban base, the device, and the skill point (NO in step C13), or when there is no worker who has a vacancy (NO in step C15), the control unit 12 of the worker selection device 10 Is the case where the worker name acquired in step C10 or C14 and the work start date and time and the work completion date and time of the work request information acquired in step A1 (when the work start date and time after addition and the work completion date and time after addition are calculated in step C8). Refers to the work schedule database 45 and the reception work database 41 based on the post-addition work start date and time and the post-addition work completion date and time) between the work start date and time and the work end date and time of the work request information ( Alternatively, it is determined whether or not the request content corresponding to the worker whose work schedule has already been determined between the post-addition work start date and time and the post-addition work completion date and time is the planned work (step C16 in FIG. 16). .. If the request content is not planned work (NO in step C16), the process proceeds to step C20.

When the request content is planned work (YES in step C16), the control unit 12 of the worker selection device 10 is among the worker names acquired in step C10 or step C14 based on a predetermined standard set in advance. Therefore, a worker in charge of the work of the work request information acquired in step A1 is determined (step C17 in FIG. 16), and then the process proceeds to steps A21 and C18.

After step C17, the control unit 12 of the worker selection device 10 determines between the work start date and time and the work end date and time of the work request information acquired in step A1 from the work schedule database 45 (the work start date and time after addition in step C8). And when the post-addition work completion date and time is calculated, the work schedule information corresponding to the worker whose work schedule has already been determined between the post-addition work start date and time and the post-addition work completion date and time is deleted (FIG. 16). Step C18).

Next, the control unit 12 of the worker selection device 10 acquires the work request information corresponding to the work schedule information (month, day, start time, completion time) deleted in step C18 (step C19 in FIG. 16). Then, the process proceeds to step B1.

When the request content is not planned work (NO in step C16), the control unit 12 of the worker selection device 10 has the worker name acquired in step C10 or step C14 and the work start date and time of the work request information acquired in step A1. And the work completion date and time (when the work start date and time after addition and the work completion date and time after addition are calculated in step C8, the work start date and time after addition and the work completion date and time after addition), and the work schedule database 45 and the reception work. A worker whose work schedule has already been determined between the work start date and time and the work end date and time (or between the post-addition work start date and time and the post-addition work completion date and time) with reference to the database 41. It is determined whether or not the content of the request corresponding to the above is the periodic inspection work (step C20 in FIG. 16). If the requested content is not periodic inspection work (NO in step C20), the process proceeds to step C24.

When the request content is periodic inspection work (YES in step C20), the control unit 12 of the worker selection device 10 has the worker name acquired in step C10 or step C14 based on a predetermined standard set in advance. From among them, a worker in charge of the work of the work request information acquired in step A1 is determined (step C21 in FIG. 16), and then the process proceeds to step A21 and step C22.

After step C21, the control unit 12 of the worker selection device 10 determines between the work start date and time and the work end date and time of the work request information acquired in step A1 from the work schedule database 45 (the work start date and time after addition in step C8). And when the post-addition work completion date and time is calculated, the work schedule information corresponding to the worker whose work schedule has already been determined between the post-addition work start date and time and the post-addition work completion date and time is deleted (FIG. 16). Step C22).

Next, the control unit 12 of the worker selection device 10 acquires the work request information corresponding to the work schedule information (month, day, start time, completion time) deleted in step C22 (step C23 in FIG. 16). Then, the process proceeds to step A10.

If the request content is not periodic inspection work (NO in step C20), the control unit 12 of the worker selection device 10 starts work of the worker name acquired in step C10 or step C14 and the work request information acquired in step A1. Work schedule database 45 and reception based on the date and time and work completion date and time (when the post-addition work start date and time and the post-addition work completion date and time are calculated, the post-addition work start date and time and the post-addition work completion date and time). With reference to the work database 41, work for which a work schedule has already been determined between the work start date and time and the work end date and time of the work request information (or between the work start date and time after addition and the work completion date and time after addition). It is determined whether or not the content of the request corresponding to the person is the on-site adjustment work (step C24 in FIG. 16). If the content of the request is not on-site adjustment work (NO in step C24), the process proceeds to step A32.

When the request content is on-site adjustment work (YES in step C24), the control unit 12 of the worker selection device 10 has the worker name acquired in step C10 or step C14 based on a predetermined standard set in advance. From among them, a worker in charge of the work of the work request information acquired in step A1 is determined (step C25 in FIG. 16), and then the process proceeds to steps A21 and C26.

After step C25, the control unit 12 of the worker selection device 10 determines between the work start date and time and the work end date and time of the work request information acquired in step A1 from the work schedule database 45 (the work start date and time after addition in step C8). And when the post-addition work completion date and time is calculated, the work schedule information corresponding to the worker whose work schedule has already been determined between the post-addition work start date and time and the post-addition work completion date and time is deleted (FIG. 16). Step C26).

Next, the control unit 12 of the worker selection device 10 acquires the work request information corresponding to the work schedule information (month, day, start time, completion time) deleted in step C26 (step C27 in FIG. 16). Then, the process proceeds to step A14.

The first embodiment is as described above, but can be modified as follows.

In addition to the mode of selection according to the situation of the worker as in the first embodiment, the operation of the maintenance target device in the area corresponding to each base can determine the probability of occurrence of the failure recovery work that requires knowledge and experience. The time from the start, or only when it is measurable, but depending on the operating rate (mainly the operating time ratio of the hard disk or the cumulative number of writes and reads), the failure rate corresponding to the value of the operating time, etc. From the data, a value indicating the degree of failure of any of the maintenance target devices in the area corresponding to the site may be calculated. At the same time, the increase in the failure rate data may be added for the schedule and time zone such as the end of consecutive holidays, where failures are likely to occur.

In addition, in the schedule and time zone where the value of the degree of failure is equal to or higher than the threshold value, if there is only one scheduled vacancy of the worker who has the knowledge and experience of the failure recovery, the worker who has the knowledge and experience of the failure recovery , Planning work, on-site adjustment work, periodic inspection work, may not be assigned. That is, if there is a possibility that a worker who has the skill to perform disaster recovery work may be required, and a worker who has a vacant work schedule at the base and has the skill to perform disaster recovery work, In the case of one person, considering the possibility that workers with skills capable of disaster recovery work will pay out to that base, assign workers with skills capable of disaster recovery work from other bases in the suburbs. May be good.

Furthermore, it may be planned not to set on-site adjustment work or planned work in the schedule time zone when the work schedule time zone is known, the periodic inspection work is performed, and the number of workers is insufficient due to the number of workers. ..

According to the first embodiment, it is possible to realize an efficient worker selection that increases the actual work rate of the worker according to various work modes. In particular, even in the event of an unexpected failure such as disaster recovery work, it is possible to efficiently select workers and contribute to the maximum implementation of the work plan.

[Embodiment 2]
The worker selection device according to the second embodiment will be described with reference to the drawings. FIG. 17 is a block diagram schematically showing the configuration of the worker selection device according to the second embodiment.

The worker selection device 10 is a device that selects the optimum worker according to the work mode and changes in circumstances (see FIG. 17). The worker selection device 10 includes a storage unit 15 for storing data, and a control unit 12 for controlling the storage unit 15 and performing predetermined information processing.

The storage unit 15 stores a maintenance contract database 42, a work schedule database 45, a parts inventory database 46, a worker skill database 47, a failure response database 48, and a maintenance base database 49.

The maintenance contract database 42 is a database in which the maintenance contract number and the customer address information are associated with each other. The work schedule database 45 is a database in which a start date / time, a completion date / time, and a worker name are associated with each other. The parts inventory database 46 is a database in which a parts name, a warehouse name, and an inventory quantity are associated with each other. The worker skill database 47 is a database in which a worker name, a affiliation base, a device name, and skill points are associated with each other. The failure response database 48 is a database in which a device name, a failure content, a component name, and a skill point are associated with each other. The maintenance base database 49 is a database in which the customer address information, the name of the base in charge, and the name of the warehouse in charge are associated with each other.

The control unit 12 performs a process of acquiring work request information including a customer name, an apparatus name, a request content, a failure content, a work start date and time, and a work completion date and time. The control unit 12 performs a process of determining whether or not the request content of the work request information is a failure recovery work. When the request content is a failure recovery work, the control unit 12 refers to the failure response database 48, the maintenance contract database 42, the maintenance base database 29, and the parts inventory database 46 based on the work request information, and refers to the warehouse name. Performs a process of determining whether or not the part name corresponding to the device name in the work request information is in stock. When the control unit 12 has the stock of the part name corresponding to the device name of the work request information in the warehouse name, the control unit 12 has the trouble response database and the worker skill based on the acquired base name and the work request information. With reference to the database, a process of determining whether or not there is a base name, a device name of work request information, and a worker name satisfying the skill points of the worker skill database 47 is performed. When there is a worker name satisfying the condition, the control unit 12 refers to the work schedule database 45 based on the worker name and the work request information, and sets the work start date and time and the work completion date and time of the work request information. Performs the process of determining whether or not there is a worker name with a space between. If there is a vacant worker name, the control unit 12 performs a process of determining the worker name to the worker in charge of the request content of the work request information.

According to the second embodiment, even when an unexpected failure such as a failure recovery work occurs, it is possible to efficiently select a worker and contribute to the maximum implementation of the work plan.

The worker selection device according to the first and second embodiments can be configured by so-called hardware resources (information processing device, computer), and one having the configuration illustrated in FIG. 18 can be used. For example, the hardware resource 100 includes a processor 101, a memory 102, a network interface 103, and the like, which are connected to each other by an internal bus 104.

The configuration shown in FIG. 18 is not intended to limit the hardware configuration of the hardware resource 100. The hardware resource 100 may include hardware (for example, an input / output interface) (not shown). Alternatively, the number of units such as the processor 101 included in the device is not limited to the example of FIG. 18, and for example, a plurality of processors 101 may be included in the hardware resource 100. For the processor 101, for example, a CPU (Central Processing Unit), an MPU (Micro Processor Unit), or the like can be used.

For the memory 102, for example, a RAM (Random Access Memory), an HDD (Hard Disk Drive), an SSD (Solid State Drive), or the like can be used.

For the network interface 103, for example, a LAN (Local Area Network) card, a network adapter, a network interface card, or the like can be used.

The function of the hardware resource 100 is realized by the above-mentioned processing module. The processing module is realized, for example, by the processor 101 executing a program stored in the memory 102. In addition, the program can be downloaded via a network or updated using a storage medium in which the program is stored. Further, the processing module may be realized by a semiconductor chip. That is, the function performed by the processing module may be realized by executing the software on some hardware.

Some or all of the above embodiments may also be described, but not limited to:

[Appendix 1]
In the present invention, the form of the worker selection device according to the first viewpoint is possible.

[Appendix 2]
The maintenance base database is associated with the customer address information, the responsible base name, the responsible warehouse name, at least one suburban base name, and at least one suburban warehouse name.
In the process of determining whether or not the part name corresponding to the device name in the work request information is in stock in the warehouse name in charge.
Based on the device name and the failure content of the work request information, the process of acquiring the device name, the component name corresponding to the failure content, and the skill point by referring to the failure response database, and
A process of acquiring customer address information corresponding to the maintenance contract number by referring to the maintenance contract database based on the maintenance contract number of the work request information.
Based on the acquired customer address information, the process of acquiring the responsible base name and the responsible warehouse name corresponding to the customer address information by referring to the maintenance base database, and
Based on the acquired part name and the warehouse name in charge, the process of referring to the parts inventory database and determining whether or not the part name corresponding to the part name is in stock in the warehouse name.
including,
The worker selection device according to Appendix 1.

[Appendix 3]
The maintenance base database includes the customer address information, the responsible base name, the responsible warehouse name, the at least one suburban base name, the at least one suburban warehouse name, and the acquisition time from the suburban warehouse name to the responsible warehouse name. Is associated with
The control unit
If the part name corresponding to the part name is not in stock in the warehouse name in charge, the maintenance base database and the parts inventory database are referred to based on the acquired part name, and the suburban warehouse name is used. The process of determining whether or not the part name corresponding to the part name is in stock, and
If the part name corresponding to the part name is in stock in the suburban warehouse name, the suburban warehouse name is obtained before the failure recovery work is performed based on the acquired part name and the acquired warehouse name in charge. Instructing the replenishment of parts from the warehouse related to the warehouse to the warehouse related to the warehouse name in charge, referring to the maintenance base database, and acquiring the acquisition time from the warehouse name in the suburbs to the warehouse name in charge.
The process of calculating the post-addition work start date and time and the post-addition work completion date and time by adding the acquired acquisition time to the work start date and time and the work completion date and time of the work request information.
After calculating the post-addition work start date and time and the post-addition work completion date and time, refer to the failure response database and the worker skill database based on the acquired base name in charge and the work request information. Then, the process of determining whether or not there is the name of the person in charge, the name of the device in the work request information, and the name of the worker who satisfies the conditions of the skill points in the worker skill database.
If there is a worker name satisfying the above conditions, the addition is performed with reference to the work schedule database based on the worker name, the calculated post-addition work start date and time, and the post-addition work completion date and time. A process for determining whether or not there is a worker name having a space between the post-work start date and time and the post-addition work completion date and time, and
When there is the worker name with a vacancy, the process of determining the worker name to the worker in charge of the request content of the work request information, and
Do more,
The worker selection device according to Appendix 2.

[Appendix 4]
The control unit
If the part name corresponding to the part name is not in stock in the suburban warehouse name, the warehouse in charge is externally used before the failure recovery work based on the acquired part name and the acquired warehouse name in charge. The process of instructing the replenishment of parts to the warehouse and acquiring the acquisition time from the outside to the warehouse,
The process of calculating the post-addition work start date and time and the post-addition work completion date and time by adding the acquired acquisition time to the work start date and time and the work completion date and time of the work request information.
After calculating the post-addition work start date and time and the post-addition work completion date and time, refer to the failure response database and the worker skill database based on the acquired base name in charge and the work request information. Then, the process of determining whether or not there is the name of the person in charge, the name of the device in the work request information, and the name of the worker who satisfies the conditions of the skill points in the worker skill database.
If there is a worker name satisfying the above conditions, the addition is performed with reference to the work schedule database based on the worker name, the calculated post-addition work start date and time, and the post-addition work completion date and time. A process for determining whether or not there is a worker name having a space between the post-work start date and time and the post-addition work completion date and time, and
When there is the worker name with a vacancy, the process of determining the worker name to the worker in charge of the request content of the work request information, and
Do more,
The worker selection device according to Appendix 3.

[Appendix 5]
The control unit
If there is no worker name that satisfies the above conditions, or if there is no vacant worker name, the suburban base name is acquired by referring to the maintenance base database based on the acquired customer address information. Processing and
Based on the acquired suburban base name and work request information, the trouble response database and the worker skill database are referred to, and the suburban base name, the device name of the work request information, and the device name of the work request information are referred to. , The process of determining whether or not there is the worker name satisfying the condition of the skill point in the worker skill database, and
If there is a worker name that satisfies the above conditions, the work schedule database is referred to based on the worker name, the work request information, the calculated post-addition work start date and time, and the post-addition work completion date and time. Then, is there a worker name having a space between the work start date and time and the work completion date and time in the work request information, or between the post-addition work start date and time and the post-addition work completion date and time? The process of determining whether or not
When there is the worker name with a vacancy, the process of determining the worker name to the worker in charge of the request content of the work request information, and
Do more,
The worker selection device according to Appendix 4.

[Appendix 6]
The storage unit further stores the reception work database that stores the past work request information.
The control unit
If there is no worker name that satisfies the above conditions, or if there is no vacant worker name, the acquired worker name, the work start date / time and the work completion date / time in the work request information, or the work completion date / time, or Based on the post-addition work start date and time and the post-addition work completion date and time, with reference to the work schedule database and the reception work database, between the work start date and time and the work end date and time of the work request information, or , The process of determining whether the request content corresponding to the worker name whose work schedule has already been determined between the post-addition work start date and time and the post-addition work completion date and time is other than the failure recovery work.
When the request content is other than the failure recovery work, the process of determining the worker name to the worker in charge of the request content of the work request information, and
Do more,
The worker selection device according to Appendix 5.

[Appendix 7]
When the request content is a failure recovery work, the control unit further performs a process of determining postponement of the work start date and time until a worker who can perform the failure recovery work appears.
The worker selection device according to Appendix 6.

[Appendix 8]
In the present invention, the form of the worker selection system according to the second viewpoint is possible.

[Appendix 9]
In the present invention, the form of the worker selection method according to the third viewpoint is possible.

[Appendix 10]
In the present invention, the form of the program according to the fourth viewpoint is possible.

The disclosures of the above patent documents shall be incorporated into this document by citation. Within the framework of all disclosures (including claims and drawings) of the present invention, embodiments or examples can be changed or adjusted based on the basic technical idea thereof. Further, various combinations or selections (necessary) of various disclosure elements (including each element of each claim, each element of each embodiment or embodiment, each element of each drawing, etc.) within the framework of all disclosure of the present invention. (Not selected) is possible. That is, it goes without saying that the present invention includes all disclosures including claims and drawings, and various modifications and modifications that can be made by those skilled in the art in accordance with the technical idea. In addition, regarding the numerical values and numerical ranges described in the present application, it is considered that arbitrary intermediate values, lower numerical values, and small ranges are described even if they are not specified.

1 Worker selection system 10 Worker selection device 11 Communication unit 12 Control unit 13 Input unit 14 Output unit 15 Storage unit 20 Network 30 Worker terminal 31 Communication unit 32 Control unit 33 Input unit 34 Output unit 35 Storage unit 40 Worker selection Program 41 Reception work database 42 Maintenance contract database 43 Equipment configuration database 44 Parts life database 45 Work schedule database 46 Parts inventory database 47 Worker skill database 48 Failure response database 49 Maintenance base database 50 Customer terminal 51 Communication unit 52 Control unit 53 Input unit 54 Output 55 Storage 100 Hardware resources 101 Processor 102 Memory 103 Network interface 104 Internal bus

Claims (8)

A storage unit that stores data and
A control unit that controls the storage unit and performs predetermined information processing,
Equipped with
The storage unit is
A failure response database that associates device names, failure details, part names, and skill points,
Maintenance contract database associated with maintenance contract number and customer address information,
A maintenance base database that associates customer address information, the name of the base in charge, and the name of the warehouse in charge,
A parts inventory database that associates part names, warehouse names, and inventory quantities,
A worker skill database that associates worker names, affiliation bases, device names, and skill points,
A work schedule database that associates the start date and time, the completion date and time, and the worker name,
Remember,
The control unit
Processing to acquire work request information including customer name, device name, request content, failure content, work start date and time, work completion date and time,
A process for determining whether or not the request content of the work request information is a failure recovery work, and
When the content of the request is a failure recovery work, the name of the warehouse in charge is changed to the name of the warehouse in charge by referring to the failure response database, the maintenance contract database, the maintenance base database, and the parts inventory database based on the work request information. The process of determining whether or not the part name corresponding to the device name in the work request information is in stock, and
When the part name corresponding to the device name in the work request information is in stock in the warehouse name in charge, the trouble response database and the failure response database are based on the acquired base name in charge and the work request information. With reference to the worker skill database, whether or not there is a worker name that satisfies the condition of the person in charge, the device name of the work request information, and the skill points of the worker skill database. Judgment process and
When there is the worker name satisfying the above conditions, the work start date and time and the work completion of the work request information are referred to with reference to the work schedule database based on the worker name and the work request information. The process of determining whether or not there is a worker name with a space between the date and time, and
When there is the worker name with a vacancy, the process of determining the worker name to the worker in charge of the request content of the work request information, and
And
The maintenance base database is associated with the customer address information, the responsible base name, the responsible warehouse name, at least one suburban base name, and at least one suburban warehouse name.
In the process of determining whether or not the part name corresponding to the device name in the work request information is in stock in the warehouse name in charge.
Based on the device name and the failure content of the work request information, the process of acquiring the device name, the component name corresponding to the failure content, and the skill point by referring to the failure response database, and
A process of acquiring customer address information corresponding to the maintenance contract number by referring to the maintenance contract database based on the maintenance contract number of the work request information.
Based on the acquired customer address information, the process of acquiring the responsible base name and the responsible warehouse name corresponding to the customer address information by referring to the maintenance base database, and
Based on the acquired part name and the warehouse name in charge, the process of referring to the parts inventory database and determining whether or not the part name corresponding to the part name is in stock in the warehouse name.
Including
The maintenance base database includes the customer address information, the responsible base name, the responsible warehouse name, the at least one suburban base name, the at least one suburban warehouse name, and the acquisition time from the suburban warehouse name to the responsible warehouse name. Is associated with
The control unit
If the part name corresponding to the part name is not in stock in the warehouse name in charge, the maintenance base database and the parts inventory database are referred to based on the acquired part name, and the suburban warehouse name is used. The process of determining whether or not the part name corresponding to the part name is in stock, and
If the part name corresponding to the part name is in stock in the suburban warehouse name, the suburban warehouse name is obtained before the failure recovery work is performed based on the acquired part name and the acquired warehouse name in charge. Instructing the replenishment of parts from the warehouse related to the warehouse to the warehouse related to the warehouse name in charge, referring to the maintenance base database, and acquiring the acquisition time from the warehouse name in the suburbs to the warehouse name in charge.
The process of calculating the post-addition work start date and time and the post-addition work completion date and time by adding the acquired acquisition time to the work start date and time and the work completion date and time of the work request information.
After calculating the post-addition work start date and time and the post-addition work completion date and time, refer to the failure response database and the worker skill database based on the acquired base name in charge and the work request information. Then, the process of determining whether or not there is the name of the person in charge, the name of the device in the work request information, and the name of the worker who satisfies the conditions of the skill points in the worker skill database.
If there is a worker name satisfying the above conditions, the addition is performed with reference to the work schedule database based on the worker name, the calculated post-addition work start date and time, and the post-addition work completion date and time. A process for determining whether or not there is a worker name having a space between the post-work start date and time and the post-addition work completion date and time, and
When there is the worker name with a vacancy, the process of determining the worker name to the worker in charge of the request content of the work request information, and
Do more,
Worker selection device. The control unit
If the part name corresponding to the part name is not in stock in the suburban warehouse name, the warehouse in charge is externally used before the failure recovery work based on the acquired part name and the acquired warehouse name in charge. The process of instructing the replenishment of parts to the warehouse related to the name and acquiring the acquisition time from the outside to the warehouse, and
The process of calculating the post-addition work start date and time and the post-addition work completion date and time by adding the acquired acquisition time to the work start date and time and the work completion date and time of the work request information.
After calculating the post-addition work start date and time and the post-addition work completion date and time, refer to the failure response database and the worker skill database based on the acquired base name in charge and the work request information. Then, the process of determining whether or not there is the name of the person in charge, the name of the device in the work request information, and the name of the worker who satisfies the conditions of the skill points in the worker skill database.
If there is a worker name satisfying the above conditions, the addition is performed with reference to the work schedule database based on the worker name, the calculated post-addition work start date and time, and the post-addition work completion date and time. A process for determining whether or not there is a worker name having a space between the post-work start date and time and the post-addition work completion date and time, and
When there is the worker name with a vacancy, the process of determining the worker name to the worker in charge of the request content of the work request information, and
Do more,
The worker selection device according to claim 1 . The control unit
If there is no worker name that satisfies the above conditions, or if there is no vacant worker name, the suburban base name is acquired by referring to the maintenance base database based on the acquired customer address information. Processing and
Based on the acquired suburban base name and work request information, the trouble response database and the worker skill database are referred to, and the suburban base name, the device name of the work request information, and the device name of the work request information are referred to. , The process of determining whether or not there is the worker name satisfying the condition of the skill point in the worker skill database, and
If there is a worker name that satisfies the above conditions, the work schedule database is referred to based on the worker name, the work request information, the calculated post-addition work start date and time, and the post-addition work completion date and time. Then, is there a worker name having a space between the work start date and time and the work completion date and time in the work request information, or between the post-addition work start date and time and the post-addition work completion date and time? The process of determining whether or not
When there is the worker name with a vacancy, the process of determining the worker name to the worker in charge of the request content of the work request information, and
Do more,
The worker selection device according to claim 2 . The storage unit further stores the reception work database that stores the past work request information.
The control unit
If there is no worker name that satisfies the above conditions, or if there is no vacant worker name, the acquired worker name, the work start date / time and the work completion date / time in the work request information, or the work completion date / time, or Based on the post-addition work start date and time and the post-addition work completion date and time, with reference to the work schedule database and the reception work database, between the work start date and time and the work end date and time of the work request information, or , The process of determining whether the request content corresponding to the worker name whose work schedule has already been determined between the post-addition work start date and time and the post-addition work completion date and time is other than the failure recovery work.
When the request content is other than the failure recovery work, the process of determining the worker name to the worker in charge of the request content of the work request information, and
Do more,
The worker selection device according to claim 3 . When the request content is a failure recovery work, the control unit further performs a process of determining postponement of the work start date and time until a worker who can perform the failure recovery work appears.
The worker selection device according to claim 4 . The worker selection device according to any one of claims 1 to 5 .
A worker terminal that is communicably connected to the worker selection device,
To prepare
Worker selection system. A failure response database that associates device names, failure details, part names, and skill points,
Maintenance contract database associated with maintenance contract number and customer address information,
A maintenance base database that associates customer address information, the name of the base in charge, and the name of the warehouse in charge,
A parts inventory database that associates part names, warehouse names, and inventory quantities,
A worker skill database that associates worker names, affiliation bases, device names, and skill points,
A work schedule database that associates the start date and time, the completion date and time, and the worker name,
It is a worker selection method that selects a worker using a device that stores
Steps to acquire work request information including customer name, device name, request content, failure content, work start date and time, work completion date and time, and
A step of determining whether or not the request content of the work request information is a failure recovery work, and
When the content of the request is a failure recovery work, the name of the warehouse in charge is changed to the name of the warehouse in charge by referring to the failure response database, the maintenance contract database, the maintenance base database, and the parts inventory database based on the work request information. The step of determining whether or not the part name corresponding to the device name in the work request information is in stock, and
When the part name corresponding to the device name in the work request information is in stock in the warehouse name in charge, the trouble response database and the failure response database are based on the acquired base name in charge and the work request information. With reference to the worker skill database, whether or not there is a worker name that satisfies the condition of the person in charge, the device name of the work request information, and the skill points of the worker skill database. Steps to judge and
When there is the worker name satisfying the above conditions, the work start date and time and the work completion of the work request information are referred to with reference to the work schedule database based on the worker name and the work request information. A step to determine if there is a worker name with a space between the date and time, and
If there is a worker name with a vacancy, the step of determining the worker name to the worker in charge of the request content of the work request information, and
It is a worker selection method including
The maintenance base database is associated with the customer address information, the responsible base name, the responsible warehouse name, at least one suburban base name, and at least one suburban warehouse name.
In the step of determining whether or not the part name corresponding to the device name in the work request information is in stock in the warehouse name in charge.
Based on the device name and the failure content of the work request information, the step of acquiring the device name, the part name corresponding to the failure content, and the skill point by referring to the failure response database, and
Based on the maintenance contract number of the work request information, the step of acquiring the customer address information corresponding to the maintenance contract number by referring to the maintenance contract database, and
Based on the acquired customer address information, the step of acquiring the responsible base name and the responsible warehouse name corresponding to the customer address information by referring to the maintenance base database, and
Based on the acquired part name and the warehouse name in charge, the step of referring to the parts inventory database and determining whether or not the part name corresponding to the part name is in stock in the warehouse name, and
Including
The maintenance base database includes the customer address information, the responsible base name, the responsible warehouse name, the at least one suburban base name, the at least one suburban warehouse name, and the acquisition time from the suburban warehouse name to the responsible warehouse name. Is associated with
The worker selection method is
If the part name corresponding to the part name is not in stock in the warehouse name in charge, the maintenance base database and the parts inventory database are referred to based on the acquired part name, and the suburban warehouse name is used. Steps to determine if the part name corresponding to the part name is in stock, and
If the part name corresponding to the part name is in stock in the suburban warehouse name, the suburban warehouse name is obtained before the failure recovery work is performed based on the acquired part name and the acquired warehouse name in charge. Instructing the replenishment of parts from the warehouse related to the warehouse to the warehouse related to the warehouse name in charge, referring to the maintenance base database, and acquiring the acquisition time from the warehouse name in the suburbs to the warehouse name in charge.
A step of calculating the post-addition work start date and time and the post-addition work completion date and time by adding the acquired acquisition time to the work start date and time and the work completion date and time of the work request information.
After calculating the post-addition work start date and time and the post-addition work completion date and time, refer to the failure response database and the worker skill database based on the acquired base name in charge and the work request information. Then, a step of determining whether or not there is the name of the person in charge, the name of the device in the work request information, and the name of the worker who satisfies the conditions of the skill points in the worker skill database.
If there is a worker name satisfying the above conditions, the addition is performed with reference to the work schedule database based on the worker name, the calculated post-addition work start date and time, and the post-addition work completion date and time. A step of determining whether or not there is a worker name having a space between the post-work start date and time and the post-addition work completion date and time, and
If there is a worker name with a vacancy, the step of determining the worker name to the worker in charge of the request content of the work request information, and
Including,
Worker selection method. A failure response database that associates device names, failure details, part names, and skill points,
Maintenance contract database associated with maintenance contract number and customer address information,
A maintenance base database that associates customer address information, the name of the base in charge, and the name of the warehouse in charge,
A parts inventory database that associates part names, warehouse names, and inventory quantities,
A worker skill database that associates worker names, affiliation bases, device names, and skill points,
A work schedule database that associates the start date and time, the completion date and time, and the worker name,
It is a program to be executed by a device that stores
Processing to acquire work request information including customer name, device name, request content, failure content, work start date and time, work completion date and time,
A process for determining whether or not the request content of the work request information is a failure recovery work, and
When the content of the request is a failure recovery work, the name of the warehouse in charge is changed to the name of the warehouse in charge by referring to the failure response database, the maintenance contract database, the maintenance base database, and the parts inventory database based on the work request information. The process of determining whether or not the part name corresponding to the device name in the work request information is in stock, and
When the part name corresponding to the device name in the work request information is in stock in the warehouse name in charge, the trouble response database and the failure response database are based on the acquired base name in charge and the work request information. With reference to the worker skill database, whether or not there is a worker name that satisfies the condition of the person in charge, the device name of the work request information, and the skill points of the worker skill database. Judgment process and
When there is the worker name satisfying the above conditions, the work start date and time and the work completion of the work request information are referred to with reference to the work schedule database based on the worker name and the work request information. The process of determining whether or not there is a worker name with a space between the date and time, and
When there is the worker name with a vacancy, the process of determining the worker name to the worker in charge of the request content of the work request information, and
Is a program that executes
The maintenance base database is associated with the customer address information, the responsible base name, the responsible warehouse name, at least one suburban base name, and at least one suburban warehouse name.
In the process of determining whether or not the part name corresponding to the device name in the work request information is in stock in the warehouse name in charge.
Based on the device name and the failure content of the work request information, the process of acquiring the device name, the component name corresponding to the failure content, and the skill point by referring to the failure response database, and
A process of acquiring customer address information corresponding to the maintenance contract number by referring to the maintenance contract database based on the maintenance contract number of the work request information.
Based on the acquired customer address information, the process of acquiring the responsible base name and the responsible warehouse name corresponding to the customer address information by referring to the maintenance base database, and
Based on the acquired part name and the warehouse name in charge, the process of referring to the parts inventory database and determining whether or not the part name corresponding to the part name is in stock in the warehouse name.
To execute,
The maintenance base database includes the customer address information, the responsible base name, the responsible warehouse name, the at least one suburban base name, the at least one suburban warehouse name, and the acquisition time from the suburban warehouse name to the responsible warehouse name. Is associated with
The program
If the part name corresponding to the part name is not in stock in the warehouse name in charge, the maintenance base database and the parts inventory database are referred to based on the acquired part name, and the suburban warehouse name is used. The process of determining whether or not the part name corresponding to the part name is in stock, and
If the part name corresponding to the part name is in stock in the suburban warehouse name, the suburban warehouse name is obtained before the failure recovery work is performed based on the acquired part name and the acquired warehouse name in charge. Instructing the replenishment of parts from the warehouse related to the warehouse to the warehouse related to the warehouse name in charge, referring to the maintenance base database, and acquiring the acquisition time from the warehouse name in the suburbs to the warehouse name in charge.
The process of calculating the post-addition work start date and time and the post-addition work completion date and time by adding the acquired acquisition time to the work start date and time and the work completion date and time of the work request information.
After calculating the post-addition work start date and time and the post-addition work completion date and time, refer to the failure response database and the worker skill database based on the acquired base name in charge and the work request information. Then, the process of determining whether or not there is the name of the person in charge, the name of the device in the work request information, and the name of the worker who satisfies the conditions of the skill points in the worker skill database.
If there is a worker name satisfying the above conditions, the addition is performed with reference to the work schedule database based on the worker name, the calculated post-addition work start date and time, and the post-addition work completion date and time. A process for determining whether or not there is a worker name having a space between the post-work start date and time and the post-addition work completion date and time, and
When there is the worker name with a vacancy, the process of determining the worker name to the worker in charge of the request content of the work request information, and
To execute further,
program.

Images