Workflow management system and method

• US 7,899,679 B2
• Filed: 05/03/2007
• Issued: 03/01/2011
• Est. Priority Date: 04/07/2000
• Status: Expired due to Term

• Current Assignee: JP Morgan Chase Bank, N.A. (JP Morgan Chase & Co)
• Original Assignee: JP Morgan Chase Bank, N.A. (JP Morgan Chase & Co)
• Inventors: McCarthy, Eileen, Reschke, Eric, MacKay, Thomas
• Primary Examiner(s): PATEL, JAGDISH
• Application Number:
  US11/743,796
• Publication Number:
  US 20070208606A1
• Time in Patent Office: 1,398 Days
• Field of Search: 705/1, 705 7- 9
• US Class Current: 705/1.1
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/063114 Status monitoring or status determination for a person or group
• CPC Class Codes: G06Q 10/063118 Staff planning in a project environment
• CPC Class Codes: G06Q 10/06316 Sequencing of tasks or work
• CPC Class Codes: G06Q 20/10 specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes

Abstract

A computerized method and system involves creating an underlying database structure for recording the processing steps and other information required for each transaction, entering the necessary setup information by selection from lists of pre-stored information about processing functions, associated workflow events and milestones for the queues, mapping the data structures of the subsystem databases and the workflow management database to provide transparent interfacing and convenient manual entry of data were necessary, displaying for the user the workflow status of all transactions, permitting menu driven initiation of required actions and automatically updating the database records for the universe of deals being managed by the system.

Claims

1. A computerized method of workflow management for concurrently handling complex multiple step projects, the method comprising:

implementing at least one computer processing unit executing workflow management software to perform steps including;

creating in a database, a project setup record uniquely characterizing each of the projects;

recording workflow status information for each of the projects in a database;

providing access for a user to a computer generated workflow status display generated at least in part from the project setup information records and the workflow status information, the workflow status display permitting access to workflow status for selected projects;

providing prompts for the user through the workflow status display including tasks to be completed;

providing task selection interface tools permitting the user to initiate tasks; and

automatically updating the workflow status record in the database whenever there is a change in the status of a project resulting from the tasks initiated by the user.

2. The method described in claim 1 further including the steps of:

automatically performing required tasks according to the information stored in the project setup record for each of the projects; and

automatically updating the workflow status record in the database whenever there is a change in the status of a project resulting from automatic performance of required tasks.

3. The method described in claim 1, wherein the step of recording workflow status information includes the step of entering information in database fields which identify basic functions involved in executing the project, workflow queues associated with the basic functions and milestones associated with the workflow queues.

4. The method described in claim 1, further including the steps of:

receiving information required for execution of the projects electronically from a source external to the workflow management software;

electronically transmitting information for performance of data processing tasks to at least one module external to the workflow management software; and

electronically receiving data from the external module representing the result of the data processing tasks performed.

5. The method described in claim 4, wherein the information from the external source is in the form of database records, and further including the step of providing an interface which remaps the database structure of the information for compatibility with the workflow management software.

6. The method described in claim 1, further including the step of electronically disseminating reports and other data compilations concerning the execution of the project.

7. The method described in claim 1, in which the status information is displayed in terms of basic functions associated with management of each of the projects, workflow queues associated with the basic functions and milestones associated with the workflow queues.

8. The method described in claim 1, further including the steps of:

prompting the user to review data at predetermined stages of the projects;

permitting the user to take action based on the review; and

changing the workflow status of the projects in accordance with the actions taken.

9. The method described in claim 8, further including the steps of:

requiring entry of supporting information by the user on a data entry screen before changing the workflow status of each project, for at least some actions taken by the user; and

storing the supporting information in a database record.

10. The method described in claim 1, wherein the workflow status display presents a list of projects, and wherein the method further includes the step of providing an actions list containing the actions available to the user as a pop-up selection screen on the active deals display which appears when one of the listed projects is selected.

11. The method described in claim 1, further including the step of generating a selection screen having a plurality of active elements thereon from which a user may initiate tasks by selection of the active elements.

12. The method described in claim 1, wherein the step of creating the project setup record includes:

allowing a user to select pertinent information concerning a particular project from lists stored in at least one database record for entry in fields on a plurality of data entry screens;

automatically filling in data in additional fields based on a selection made for another field; and

allowing the user to create records for new information not contained in an existing database record by entering data in the fields of at least one data entry screen.

13. The method described in claim 12, wherein the step of creating the project setup record further includes permitting the user to edit existing database records by entering new information in the fields of at least one data entry screen.

14. The method described in claim 13, further including the step of allowing the user to make selections for at least some of the fields in a data entry screen from drop-down lists created from stored database records.

15. The method described in claim 14, further including the step of determining the content of at least one of the lists as a function of a data selection made for another field.

16. The method described in claim 15, further including the step of scrolling at least some of the lists on the basis of partial entries in text boxes for the lists.

17. The method described in claim 1, wherein the step of creating the project set up record includes the steps of:

allowing a user to access and enter data into the fields of a series of data input screens, each screen providing for entry of a particular type of data related to the projects; and

storing the data entered by the user in the database in response to a save command.

18. The method described in claim 17, further including the step of permitting the user to access specific data entry screens by selecting tabs appearing on all of the screens in the series.

19. The method described in claim 1, wherein the step of creating the project setup record further includes the step of permitting the user to specify workflow path changes in accordance with predetermined contingencies.

20. The method described in claim 3, further including the steps of:

permitting the user to access a list of predefined data verification tests;

permitting a user to select at least one verification test from the list; and

permitting the user to specify a queue and milestone at which the selected verification test is to be performed.

21. The method described in claim 1, wherein the step of permitting verification test selection includes permitting concurrent selection of more than one item from the list.

22. A workflow management system for handling complex multiple step projects comprising:

an electronic workflow management database which stores project setup information, including organizational information concerning the projects, and the sequence of workflow required to execute the project;

a first data processing module which receives raw data required to execute each project from at least one outside source, and processes the raw data;

a first interface which receives the processed raw data from the first data processing software module, and transmits the data electronically;

a workflow management software module for receiving the data transmitted from the first interface and for generating a computer display, the computer display showing work flow status information concerning the projects, providing prompts for the user through the workflow status display including tasks to be completed, and providing task selection interface tools permitting the user to initiate tasks;

a second data processing software module which receives the processed raw data, and responds to commands from the workflow management software module to perform computations using the processed raw data;

a second interface for transmitting data generated from the second data processing software module;

a third data processing software module which receives the data generated from the second data processing software module through the second interface, and responds to commands from the workflow management software module to process the received data; and

at least one computer processor for accessing the electronic workflow management database and for implementing the workflow management software module and the first, second, and third data processing modules.

23. The system described in claim 22, further including a data handling device responsive to data and commands from the workflow management software module, the data handling device being operative to electronically disseminate reports and other data compilations.

24. The system described in claim 22, wherein the processed raw data is in database form, and wherein the first interface maps the database structure of the processed raw data for compatibility with the second data processing software module.

25. The system described in claim 24, wherein the data produced by the second data processing software module is in database form, and wherein the second interface maps the database structure of the data provided the second data processing software module for compatibility with the third data processing software module.

26. The system described in claim 24, wherein the computer display is based at least in part on recorded setup information in the electronic database.

27. The system described in claim 22, wherein the workflow management software module is operative to update the workflow status database in response to actions initiated by users, and work completed.