JP2013200753A - Workflow management system, workflow management method, and workflow management program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To create a workflow in consideration of a schedule of an approver.SOLUTION: A workflow management system comprises: an application matter table 107 for storing matter information on a matter applied by a user; an application route assignment table 108 for storing route information in order of approval of matters; a matter route master 119 for storing route setting of each matter information; an employee master 110 for storing employee information including information on employees and approvers; an organization master 111 for storing organization information; a role master 112 for storing a role as a role number; and an employee open schedule management master 116 for storing open schedule information of employees. In the system, approvers satisfy an approval buffer required for approval and a cumulative processing time required for a workflow, and from a list of the approvers, an approver having an open schedule is extracted.

Description

  The present invention relates to a workflow management system, a workflow management method, and a workflow management program that allow information and work between related parties to flow smoothly by defining a processing procedure of a work procedure as a workflow, and in particular, an approval procedure for an approver. The present invention relates to a workflow management system, a workflow management method, and a workflow management program that can prevent a workflow from being expired due to a delay in time.

  In recent enterprises and the like, in order to perform a work smoothly by sharing a large number of work by a large number of workers, the processing procedure of each work procedure is managed by a computer system. As a document describing a workflow management technique according to the prior art, the following Patent Document 1 can be cited. In the Patent Document 1, a workflow server performs predetermined workflow processing of an electronic document by an approval / decisioner of the next work. The staying electronic document exceeding the staying deadline is detected, and on the delivery route of the detected staying electronic document, the approval / approver's schedule, which is the superior of the approval / approval of the next work, is referred to. Even if there is no official official in charge of the workflow, by determining the superior to be delegated as the decision-making agent based on the reference approval and decision-maker's schedule and the stay deadline Is described in order to satisfy the desired completion date of approval.

JP 2007-156678 A

  Although the technique described in Patent Document 1 described above can continue the workflow by the settlement manager's senior decision even when there is no settlement person in charge of work that has exceeded the stay deadline, However, there is a problem in that it is not considered to obtain an excessive decision from the settlement officer, and the deadline may be exceeded before the workflow is approved. In addition, in the conventional technology, in a system having a general workflow function, when creating a workflow, the system automatically follows the higher organization of the organization to which the applicant belongs, and assigns the authorized person to the approver. Since the time required for performing the approval act is not taken into account, there is a problem that the schedule of the approver is clogged and it may be difficult to implement or an unrealizable workflow may be created.

  Furthermore, in the prior art, when a workflow that is difficult or impossible to implement is created, the approver is required to respond more quickly than usual, and if there is no prior communication from the applicant, the approver is delayed. When there is a problem that it is difficult to notice or when a delay occurs, it is necessary to coordinate with the approver and take urgent action, but information on whether or not it is impossible to realize with the conventional mechanism is not provided There was a problem that I had to check the approver's schedule. In addition, even when a workflow with sufficient schedule is created, the conventional technology uses up the buffer (margin period) before reaching the final approver if the approver exists across multiple steps. As a result, there is a problem that the deadline cannot be kept, and the response when the workflow starts to be delayed for this reason is generally triggered by the stay information, so that there is a case where it cannot be recovered because it is a post response.

  SUMMARY OF THE INVENTION An object of the present invention is to solve the above-described problems of the prior art, and a workflow management system and workflow capable of creating a workflow that takes into account the time required to perform an approval action and the approver's schedule A management method and a workflow management program are provided.

In order to achieve the above object, the present invention includes a case for registering an approval route of a work item registration and an approval person and a route charge information registration processing part, and a control part for performing an empty schedule process for managing an employee schedule, A workflow management system that creates workflow information based on request information from system users,
Approver search that specifies whether to search for the applicant's name number, application date / time, applicant organization number, approval deadline date / time, approver processing time, search target organization number, and approver in the upper organization direction An application matter table for storing matter information including a method, an application route charge table for storing route information indicating an approval order for obtaining approval when performing a plurality of operations included in the matter information, and the matter information are retained. Execute the workflow with the matter master that stores the information associated with the type of matter to be executed, the matter route master that stores the route settings for each matter information, and the employee master that stores the employee information including the employee who performs the work and the approver The organization master that stores the organization information to be stored, the role master that stores the role based on the job system as the role number, and the employee that stores the association information between the employee and the organization to which the employee belongs Comprising a woven master, and employee roll master for storing string pickled information of said role information, and employee schedule management master for storing schedule information employees, and employees empty schedule management master for storing empty schedule information for employees,
A first step in which the control unit calculates a cumulative processing time required for processing a plurality of cases based on the application date and time and the approval deadline date and time stored in the application case table;
The approver processing time stored in the application matter table and the role number of the approver stored in the role master are extracted as the first approver role number, and the approver buffer corresponding to the first approver role number is A second step of calculating and allocating a period excluding the total processing time among the period from the application date to the approval deadline date;
A third step of setting a higher or lower search target organization number of the organization designated by the approver search method stored in the application matter table;
A fourth step of extracting, from the role master, a higher or lower second approver role number for the applicant's name number stored in the application matter table starting from the search target organization number set in the third step;
An approver of an approver who satisfies the approver buffer and the approval deadline date and time based on the first and second approver role numbers, the application date and time, the accumulated processing time, the search target organization number and the approver buffer. A fifth step of creating a list;
A first feature is to execute a sixth step of inputting the empty schedule information stored in the employee empty schedule management master and the approver list and extracting an approver having an empty schedule from the approver list. .

  In the first step of the workflow management system of the first feature, the present invention calculates a total processing time required for processing for each case based on the application date and time and the approval deadline date and time stored in the application case table, When the total processing time based on the application date / time is determined not to satisfy the approval deadline date / time, the second feature is to execute a seventh step of warning the user, and the workflow management of any of the above features In the third step of the system, when it is determined that the approver search method stored in the application matter table is higher, and in the third step, the applicant organization number is determined as the search target organization. When the third step is set as a number, and it is determined that it is not a higher rank in the third step, the third step is executed to set the search starting point number as a search target organization number. And features.

Further, the present invention includes a case for registering a work item and an approval route of the person in charge of approval and a route charge information registration processing unit, and a control unit for performing an unoccupied schedule process for managing an employee schedule. A workflow management method in a computer system for creating workflow information based on request information,
Whether or not to search the computer system for the name of the applicant to whom the user applies, the application date / time, the applicant organization number, the approval deadline date / time, the approver processing time, the search target organization number, and the approver in the upper organization direction An application matter table for storing matter information including an approver search method to be designated, an application route charge table for storing route information indicating an approval order for obtaining approval when performing a plurality of operations included in the matter information, A matter master that stores information associated with the type of matter that holds the matter information, a matter route master that stores route settings for each matter information, and an employee master that stores employee information including employees and approvers who perform work An organization master that stores organization information for performing a workflow, a role master that stores a role based on a job system as a role number, an employee and an organization to which the employee belongs Employee organization master for storing linking information, employee role master for storing linking information of the role information, employee schedule management master for storing employee schedule information, and employee vacancy schedule for storing employee vacancy schedule information With a management master,
A first step of calculating a cumulative processing time required for processing a plurality of cases based on the application date and time and the approval deadline date and time stored in the application case table in the control unit;
The approver processing time stored in the application matter table and the role number of the approver stored in the role master are extracted as the first approver role number, and the approver buffer corresponding to the first approver role number is A second step of calculating and allocating a period excluding the total processing time among the period from the application date to the approval deadline date;
A third step of setting a higher or lower search target organization number of the organization designated by the approver search method stored in the application matter table;
A fourth step of extracting, from the role master, a higher or lower second approver role number for the applicant's name number stored in the application matter table starting from the search target organization number set in the third step;
An approver of an approver who satisfies the approver buffer and the approval deadline date and time based on the first and second approver role numbers, the application date and time, the accumulated processing time, the search target organization number and the approver buffer. A fifth step of creating a list;
A fourth feature is that the sixth step of executing the empty schedule information stored in the employee empty schedule management master and the approver list as input and extracting an approver having an empty schedule from the approver list is executed. .

  In the first step of the workflow management method of the fourth feature, the present invention calculates a total processing time required for processing for each case based on the application date and time and the approval deadline date and time stored in the application case table, A workflow management method according to any one of the above-mentioned features is characterized in that a seventh step of warning a user is executed when it is determined that the total processing time based on the application date / time does not satisfy the approval deadline date / time. In the third step, the eighth step of determining whether or not the approver search method stored in the application matter table is higher, and when it is determined higher in the third step, the applicant organization number is set as the search target organization number. And when the third step is determined not to be higher, the sixth step is to execute the ninth step of setting the search origin number as a search target organization number. That.

The present invention also includes a case for registering work items and an approval route for the person in charge of approval and a route charge information registration processing unit, and a control unit for performing an empty schedule process for managing the employee schedule. A workflow management program for a computer system that creates workflow information based on the request information of
Whether the computer system searches the applicant's name number, application date / time, applicant organization number, approval deadline date / time, approver processing time, search target organization number, and approver in the direction of the organization. An application matter table for storing matter information including an approver search method to be designated, an application route charge table for storing route information indicating an approval order for obtaining approval when performing a plurality of operations included in the matter information, A matter master that stores information associated with the type of matter that holds the matter information, a matter route master that stores route settings for each matter information, and an employee master that stores employee information including employees and approvers who perform work An organization master that stores organization information for performing a workflow, a role master that stores a role based on a job system as a role number, an employee and an organization to which the employee belongs Employee organization master for storing linking information, employee role master for storing linking information of the role information, employee schedule management master for storing employee schedule information, and employee vacancy schedule for storing employee vacancy schedule information With a management master,
A first step of calculating a cumulative processing time required for processing a plurality of cases based on the application date and time and the approval deadline date and time stored in the application case table in the control unit;
The approver processing time stored in the application matter table and the role number of the approver stored in the role master are extracted as the first approver role number, and the approver buffer corresponding to the first approver role number is A second step of calculating and allocating a period excluding the total processing time among the period from the application date to the approval deadline date;
A third step of setting a higher or lower search target organization number of the organization designated by the approver search method stored in the application matter table;
A fourth step of extracting, from the role master, a higher or lower second approver role number for the applicant's name number stored in the application matter table starting from the search target organization number set in the third step;
An approver of an approver who satisfies the approver buffer and the approval deadline date and time based on the first and second approver role numbers, the application date and time, the accumulated processing time, the search target organization number and the approver buffer. A fifth step of creating a list;
A seventh feature is that the sixth step of executing, from the empty schedule information stored in the employee empty schedule management master and the approver list, the approver having an empty schedule is extracted from the approver list. .

  In the first step of the workflow management program of the seventh feature, the present invention calculates a total processing time required for processing for each case based on the application date and time and the approval deadline date and time stored in the application case table, The workflow management program according to any one of the above-mentioned features is characterized in that when a total processing time based on an application date / time is determined not to satisfy the approval deadline date / time, a seventh step of warning a user is executed. In the third step, the eighth step of determining whether or not the approver search method stored in the application matter table is higher, and when it is determined higher in the third step, the applicant organization number is set as the search target organization number. And when it is determined that it is not a higher rank in the third step, the ninth step of setting the search origin number as a search target organization number is executed. It is a feature of the 9.

  A workflow management system, a workflow management method, and a workflow management program according to the present invention input empty schedule information stored in an employee empty schedule management master and the approver list, and extract approvers with an empty schedule from the approver list. In addition, by adding the time necessary for performing the approval action, a workflow that takes into consideration the approval time and schedule of the approver can be created.

1 is a configuration diagram of a workflow management system according to an embodiment of the present invention. The figure which shows the workflow management flow by this embodiment. The figure which shows the workflow management flow by this embodiment. The figure which shows the workflow management flow by this embodiment. The figure which shows the workflow management flow by this embodiment. The figure which shows the workflow management flow by this embodiment. The figure which shows the workflow management flow by this embodiment. The figure which shows the workflow management flow by this embodiment. The figure which shows the empty schedule creation process flow by this embodiment. The figure which shows the table structure by this embodiment. The figure which shows the table structure by this embodiment. The figure which shows the correlation of each table by this embodiment.

Hereinafter, an embodiment of a workflow management system employing a workflow management method and program according to the present invention will be described in detail with reference to the drawings.
The workflow management system according to the present invention includes a process step (minimum unit work, hereinafter referred to as a step) associated with each work item registered as a master and a role necessary for performing approval at each step (a “role”). ) And the processing time for each step and the vacant schedule information of all users, by creating a workflow based on the vacant schedule based on the approver, assumed processing time, buffer, and approval deadline for each step. A workflow that takes into consideration the approval time and schedule of the approver can be created, and the received information is distributed to all approvers so that all approvers are clearly aware of their workload, time delay, and approval deadline. To prevent delays in approval and exhaustion of all subsequent approver buffers, as detailed below. .

  In general, a role defines a rule for identifying a user. For example, the role definition of “applicant” is “logged in user” and the role definition of “section manager” is The role definition of “Applicant Affiliation Division” and role name “General Manager” is a conversion rule definition from “Role (Role)” to “Employee (User)” such as “General Manager of Applicant Affiliation Department”. A process step refers to a minimum unit of work when performing business.

[Constitution]
As shown in FIG. 1, the workflow management system 103 according to the present embodiment creates workflow information based on request information received from the system user 101 via the network 102, and registers and approves work items. A control unit 117 having a case and route charge information registration processing unit 105 for registering the approval route of the person in charge and an empty schedule creation processing unit 106 for managing the employee schedule, and a number of tables accessed by the control unit 117 And a database (DB) 118 having a master.

  The database 118 includes an application item table 107 that stores item information (also referred to as an application item, which includes an application date and an approval deadline date) to be applied by the user, and route information of the application item (performs a plurality of operations). The application route person in charge table 108 for storing the order of the approver who obtains the approval, for example, including the name of the applicant at each step of the application case n), and the type of the case that holds the case information A case master 109 for storing information, a route master 119 for storing route settings for each case information, an employee master 110 for storing employee information including employees and approvers who perform work, and a company that executes this workflow. Organization master 111 for storing organization information such as, and a role for storing role information which is a definition of a conversion rule from “role (role)” to “employee (user)” A store 112, an employee organization master 113 that stores association information between an employee and the organization to which the employee belongs, an employee role master 114 that stores association information of employee role information, and employee schedule information. An employee schedule management master 115 and an employee schedule management master 116 for storing employee schedule information are provided.

  As shown in FIG. 4A and FIG. 4B, each table and master of the database 118 includes items of item information of “case number”, “case type number”, “application date / time”, and “approval date / time”. The application route charge table 108 includes item information of “case number”, “name number”, “route order”, “processing deadline”, and “message”, and the case master 109 includes “case type number”. -Each item information of "Matter type name" includes the item route master 119, "Matter type number", "Route order", "Approver processing time" indicating the time required for approval by the approver-Processing person in charge Included in each item information of “approver search method” and “approver role number” indicating the target organization in the bottom-up or bottom-down, the employee master 110 has “name number”, “last name”, “first name” Each item The organization master 111 includes each item information of “organization number”, “organization name” and “higher organization number” such as a section, and the role master 112 uniquely identifies a role. Each item information of “Role Name” indicating the name (job system) associated with the “No.” and role number is included, and the employee organization master 113 stores each item information of “Name Number”, “Organization Number”, and “Concurrent”. The employee role master 114 includes item information of “name number” and “role number”, and the employee schedule management master 115 includes “name number”, “schedule number”, “title”, “start date”, Each item information of “end date and time” is included, and the employee empty schedule management master 116 is configured to include item information of “name number”, “empty schedule number”, “start date and time”, and “end date and time”. To have.

  Further, as shown in FIG. 5, each table and master of the database 118 is associated with the case number of the application route table 108 and the name number of the application route table 108 is the employee master 110. The employee number 110 can be associated with the employee role master 114, the employee schedule management master 115, the employee empty schedule management master 116, and the employee organization master 113, and all tables and masters It is configured to be linked by common items.

[Operation]
As shown in FIGS. 2A and 2B, the workflow management system 103 configured as described above has an initial process when the route charge information registration processing unit 105 of the control unit 117 registers the route charge information of the workflow, as shown in FIGS. 2A and 2B. Based on the session 201 from the user 101, the step S 201 stores the session and name number as a variable of the name number 285 in a work memory (not shown), and the case type and application organization number based on the request 203 from the user 101. Approval expiration date / time, message, search origin organization number, search start time, and search end time are acquired, and the case type 211, applicant organization number 213, approval expiration date / time 215, message 217, search origin organization number 251 and search start time. 287 and search end time 589 as variables in a work memory (not shown) Steps S202 to 206, Steps S211 to S212, and the maximum value of the case number obtained from the application case table 107, and the value incremented by 1 (counted up) is stored in the work memory (not shown) as a variable of the case number 218 S213, the application date 220 stored in the work memory (not shown) as a variable based on the system date of the computer, and the information 207 stored in the work memory by the above step is stored in the application item table 107 as a new record. It operates to execute step S215.

  Next, as shown in FIG. 2B, the workflow management system 103 sets the route order “1” and the processing time limit “NULL” in the request route charge table 108 based on the name number and message input from the user 101. The applicant information is registered by executing step S216 for storing the user as a new record, and as shown in FIG. 2C, the item route master 119 (the item type number, the route order, the approver processing time, the approver search method, the approver Step S 221 for acquiring the case list 246 of all records linked to the case type from the role number (stored), and the time “0” is added to initialize the composite processing time value required for the workflow of the case to “0” Step S222 stored in the work memory (not shown) as the processing time 221 and the processing time of the applicant are not counted. A step S223 for starting the processing loop of the case list with the counter (cnt) value set to “1”, and a total processing time through all routes of the case list 246 are calculated as a total processing time, and the calculation is performed. The step S225 of storing the total processing time 221 as a variable in a work memory (not shown) and the step S226 of repeating between the step S223 until the calculation and storage of the total processing time 221 for all cases are completed.

  Further, the present system inputs the sum 235 of the total processing time 221 and the application date / time stored in step S225 and the approval deadline information 235, and determines whether or not the sum of the application date / time and the total processing time has passed the approval date / time (assuming It is difficult for the user 101 to finish in time here by executing step S227 that performs error processing 300 when it is determined that the process is completed in time or not. Yes, it can be recognized that the schedule needs to be adjusted, and after that, it may be possible to manually set a person in charge who can make adjustments by telephone or the like without using this system.

  Furthermore, when the workflow management system 103 according to the present embodiment determines in step S227 that the sum of the application date and time and the total processing time has not passed the approval deadline date and time, as shown in FIG. Step S231 for initializing the accumulated processing time to “0”, Step S232 for starting the case list processing loop with the value of the counter (cnt) 2 being “1”, and approval of the corresponding step from the case list 246 Approver processing time, approver search method and approver role number of the first candidate are acquired, and the approver processing time 239, approver search method 240, approver role number 242 and approver buffer 245 of the case number cnt are variables By executing steps S233 to S236 stored in a work memory not shown as Approver against nt th it is possible to get the approver buffer is the time required for approval within the deadline. The calculation of the approver buffer in step S236 is performed from the application date and time to the approval date and time by a calculation formula of “((approval date / time−application date / time) −total processing time) × (approver processing time / total processing time)”. Of these periods, a period excluding the total processing time is calculated by allocating to each step, and a longer buffer is assigned to a step having a longer work time.

  Next, in the present embodiment, as shown in FIG. 2E, step S241 for determining whether or not the approver search method is bottom-up (a search process for searching the top of the organization), and the bottom-up determination in step S241. In step S242, the applicant organization number 213 is substituted for the search target organization number and stored in the work memory as the search target organization number 268. If it is determined in step S241 that it is not bottom-up, the search origin organization number 251 is set. In step S243, which is substituted for the search target organization number and stored in the work memory as the search target organization number 275, the second candidate approver role number corresponding to the search target organization number stored in the work memory in step S242 or 243 Substitute cnt of list and approver role number of matter map To run and step S244.

  Note that the bottom-up process in step S242 is suitable for projects that require approval from the immediate manager of his / her immediate area. For example, evaluation of work contents every six months is generally approved by his / her section manager / department manager. This is because such a case is suitable for bottom-up in which the organization belongs to the higher organization. The top-down processing that is not bottom-up in step S243 is suitable for a case where a person in charge is selected because the top-down straddles departments or divisions in units of business units. In general, the person in charge / responsible is selected among the persons selected from the above, but such a case is suitable for top-down tracing from any upper organization to a lower organization, according to the above-described step S241. Approvers suitable for the matter contents can be set by the judgment process.

  Furthermore, as shown in FIG. 2F, the workflow management system 103 according to the present embodiment searches the information of the employee role master 114, the employee organization master 113, and the employee schedule vacancy management master 115 in association with each other, and acquires the information obtained in the above steps. 263 (search target organization number, approver role number, application date / time, accumulated processing time, approver processing time, approver buffer, search range start / search range end information) and approver's name number list A step S251 for extracting an approver name number list for the case number cnt, a step S252 for determining whether or not an approval authority holder exists in the designated organization, and a transition to a later-described step S261 if there exists, When it is determined in step S252 that the file does not exist, the process is divided based on the search method. Therefore, in step S253 for determining whether or not the search method is bottom-up, and when it is determined that the search method is bottom-up in step S253, the higher-order organization number is compared with the applicant organization number from the organization master 111. Step S254 for substituting for and when it is determined that it is not bottom-up (top-down), by executing step S255 for substituting the search origin organization number from the organization master 111 to the search target organization number, bottom-up according to the work content Alternatively, a top-down approver can be set as a search target.

  Next, as shown in FIG. 2G, the present system starts step S261 for starting the case list processing loop in which the value of the counter (cnt) 3 is “0”, and the acquired information (case number / approver name list). Step S262 for additionally storing the application date / time, accumulated processing time, approver processing time, and information of the approver buffer) as a new record in the application route charge table 108 as input and repeating the processing described later following Step S262 Step S263 to be started, Step S264 for accumulating the cumulative approval time, the person-in-charge processing time, and the approver buffer time of the cases stored in the application route charge table 108 and storing them in the work memory as the total processing time 281; Step S264 is completed until the target case is completed (end of processing for assigning a person in charge of processing to all steps). By executing the repeat step S264, the route charge information registration processing unit 105 of the control unit 117 according to the present embodiment considers the application information, the approver authority (bottom-up, bottom-down), and the vacant schedule of the approver. A workflow can be created.

  Further, as shown in FIG. 4, the empty schedule creation processing unit 106 extracts and sorts all employee records from the employee schedule management master 115, sorts them, and stores them in a work memory (not shown) as an employee schedule list 900; An initial value of the counter cnt is set to “0”, an end condition is set when the counter reaches the total number of records −1, and a process of repeating the subsequent processing is started, step S302, the name number of the record pointed to by the counter, Step S303 for determining whether or not the name number of the record of the counter +1 is equal, and Step S304 for registering the schedule information of the employee schedule list 900 in the employee empty schedule management master 115 when it is determined that they are equal in Step S303 At the end By operating to perform a step S305 to end the process by repeating the steps S303 and 304, it is possible to apply the free schedule of employees in this system.

101 users, 102 networks, 103 workflow management systems,
105 route charge information registration processing unit, 106 schedule creation processing unit,
107 Application matter table, 108 Application route charge table, 109 Case master,
110 employee master, 111 organization master, 112 role master,
113 employee organization master, 114 employee role master,
115 employee schedule management master, 116 employee empty schedule management master,
117 control unit, 118 database, 119 matter route master,
213 Applicant organization number, 215 Approval deadline date, 217 message,
218 case number, 220 application date and time, 221 total processing time,
239 Approver processing time, 240 Approver search method, 242 Approver role number,
245 Approver buffer, 246 Item list, 251 Search origin organization number,
268 Search target organization number, 275 Search target organization number, 281 Cumulative processing time,
285 name number, 287 search start time, 300 error handling,
589 Search End Time, 900 Employee Schedule List

Claims (9)

It is equipped with an item and route manager information registration processing unit for registering work items and approval routes for approval personnel, and a control unit that performs idle schedule processing to manage employee schedules, based on request information from system users A workflow management system for creating workflow information,
Approver search that specifies whether to search for the applicant's name number, application date / time, applicant organization number, approval deadline date / time, approver processing time, search target organization number, and approver in the upper organization direction An application matter table for storing matter information including a method, an application route charge table for storing route information indicating an approval order for obtaining approval when performing a plurality of operations included in the matter information, and the matter information are retained. Execute the workflow with the matter master that stores the information associated with the type of matter to be executed, the matter route master that stores the route settings for each matter information, and the employee master that stores the employee information including the employee who performs the work and the approver The organization master that stores the organization information to be stored, the role master that stores the role based on the job system as the role number, and the employee that stores the association information between the employee and the organization to which the employee belongs Comprising a woven master, and employee roll master for storing string pickled information of said role information, and employee schedule management master for storing schedule information employees, and employees empty schedule management master for storing empty schedule information for employees,
A first step in which the control unit calculates a cumulative processing time required for processing a plurality of cases based on the application date and time and the approval deadline date and time stored in the application case table;
The approver processing time stored in the application matter table and the role number of the approver stored in the role master are extracted as the first approver role number, and the approver buffer corresponding to the first approver role number is A second step of calculating and allocating a period excluding the total processing time among the period from the application date to the approval deadline date;
A third step of setting a higher or lower search target organization number of the organization designated by the approver search method stored in the application matter table;
A fourth step of extracting, from the role master, a higher or lower second approver role number for the applicant's name number stored in the application matter table starting from the search target organization number set in the third step;
An approver of an approver who satisfies the approver buffer and the approval deadline date and time based on the first and second approver role numbers, the application date and time, the accumulated processing time, the search target organization number and the approver buffer. A fifth step of creating a list;
A workflow management system that executes the sixth step of extracting, from the approver list, an approver having a free schedule, by inputting the free schedule information stored in the employee free schedule management master and the approver list. .   In the first step, the total processing time required for processing for each case based on the application date and time and the approval deadline date stored in the application case table is calculated, and the total processing time based on the application date and time is the approval deadline date and time The workflow management system according to claim 1, wherein a seventh step of warning a user when it is determined that the condition is not satisfied is executed.   In the third step, when it is determined that the approver search method stored in the application matter table is higher, and in the third step, the applicant organization number is determined as the search target organization number. The workflow management system according to claim 1 or 2, further comprising: a ninth step of setting the search origin number as a search target organization number when it is determined that the search origin number is not higher in the third step. It is equipped with an item and route manager information registration processing unit for registering work items and approval routes for approval personnel, and a control unit that performs idle schedule processing to manage employee schedules, based on request information from system users A workflow management method in a computer system for creating workflow information,
Whether or not to search the computer system for the name of the applicant to whom the user applies, the application date / time, the applicant organization number, the approval deadline date / time, the approver processing time, the search target organization number, and the approver in the upper organization direction An application matter table for storing matter information including an approver search method to be designated, an application route charge table for storing route information indicating an approval order for obtaining approval when performing a plurality of operations included in the matter information, A matter master that stores information associated with the type of matter that holds the matter information, a matter route master that stores route settings for each matter information, and an employee master that stores employee information including employees and approvers who perform work An organization master that stores organization information for performing a workflow, a role master that stores a role based on a job system as a role number, an employee and an organization to which the employee belongs Employee organization master for storing linking information, employee role master for storing linking information of the role information, employee schedule management master for storing employee schedule information, and employee vacancy schedule for storing employee vacancy schedule information With a management master,
A first step of calculating a cumulative processing time required for processing a plurality of cases based on the application date and time and the approval deadline date and time stored in the application case table in the control unit;
The approver processing time stored in the application matter table and the role number of the approver stored in the role master are extracted as the first approver role number, and the approver buffer corresponding to the first approver role number is A second step of calculating and allocating a period excluding the total processing time among the period from the application date to the approval deadline date;
A third step of setting a higher or lower search target organization number of the organization designated by the approver search method stored in the application matter table;
A fourth step of extracting, from the role master, a higher or lower second approver role number for the applicant's name number stored in the application matter table starting from the search target organization number set in the third step;
An approver of an approver who satisfies the approver buffer and the approval deadline date and time based on the first and second approver role numbers, the application date and time, the accumulated processing time, the search target organization number and the approver buffer. A fifth step of creating a list;
A workflow management method, comprising: inputting empty schedule information stored in the employee empty schedule management master and the approver list; and executing a sixth step of extracting an approver having an empty schedule from the approver list. .   In the first step, the total processing time required for processing for each case based on the application date and time and the approval deadline date stored in the application case table is calculated, and the total processing time based on the application date and time is the approval deadline date and time The workflow management method according to claim 4, further comprising: executing a seventh step of warning the user when it is determined that the condition is not satisfied.   In the third step, when it is determined that the approver search method stored in the application matter table is higher, and in the third step, the applicant organization number is determined as the search target organization number. The workflow management method according to claim 4 or 5, further comprising: executing the ninth step of setting the search origin number as a search target organization number when it is determined that the search origin number is not a higher rank in the third step. It is equipped with an item and route manager information registration processing unit for registering work items and approval routes for approval personnel, and a control unit that performs idle schedule processing to manage employee schedules, based on request information from system users A workflow management program for a computer system for creating workflow information,
Whether the computer system searches the applicant's name number, application date / time, applicant organization number, approval deadline date / time, approver processing time, search target organization number, and approver in the direction of the organization. An application matter table for storing matter information including an approver search method to be designated, an application route charge table for storing route information indicating an approval order for obtaining approval when performing a plurality of operations included in the matter information, A matter master that stores information associated with the type of matter that holds the matter information, a matter route master that stores route settings for each matter information, and an employee master that stores employee information including employees and approvers who perform work An organization master that stores organization information for performing a workflow, a role master that stores a role based on a job system as a role number, an employee and an organization to which the employee belongs Employee organization master for storing linking information, employee role master for storing linking information of the role information, employee schedule management master for storing employee schedule information, and employee vacancy schedule for storing employee vacancy schedule information With a management master,
A first step of calculating a cumulative processing time required for processing a plurality of cases based on the application date and time and the approval deadline date and time stored in the application case table in the control unit;
The approver processing time stored in the application matter table and the role number of the approver stored in the role master are extracted as the first approver role number, and the approver buffer corresponding to the first approver role number is A second step of calculating and allocating a period excluding the total processing time among the period from the application date to the approval deadline date;
A third step of setting a higher or lower search target organization number of the organization designated by the approver search method stored in the application matter table;
A fourth step of extracting, from the role master, a higher or lower second approver role number for the applicant's name number stored in the application matter table starting from the search target organization number set in the third step;
An approver of an approver who satisfies the approver buffer and the approval deadline date and time based on the first and second approver role numbers, the application date and time, the accumulated processing time, the search target organization number and the approver buffer. A fifth step of creating a list;
A workflow management program for executing the sixth step of extracting, from the approver list, an approver having a free schedule, based on the free schedule information stored in the employee free schedule management master and the approver list. .   In the first step, the total processing time required for processing for each case based on the application date and time and the approval deadline date stored in the application case table is calculated, and the total processing time based on the application date and time is the approval deadline date and time 8. The workflow management program according to claim 7, wherein a seventh step of warning the user is executed when it is determined that the condition is not satisfied.   In the third step, when it is determined that the approver search method stored in the application matter table is higher, and in the third step, the applicant organization number is determined as the search target organization number. The workflow management program according to claim 7 or 8, wherein when the third step is determined not to be a higher rank, the ninth step of setting the search origin number as a search target organization number is executed.

Images