AU2013201445A1 - Computer system and method for facilitating and managing the project bid and requisition process - Google Patents

Computer system and method for facilitating and managing the project bid and requisition process Download PDF

Info

Publication number
AU2013201445A1
AU2013201445A1 AU2013201445A AU2013201445A AU2013201445A1 AU 2013201445 A1 AU2013201445 A1 AU 2013201445A1 AU 2013201445 A AU2013201445 A AU 2013201445A AU 2013201445 A AU2013201445 A AU 2013201445A AU 2013201445 A1 AU2013201445 A1 AU 2013201445A1
Authority
AU
Australia
Prior art keywords
bid
buyer
vendor
project
user
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Abandoned
Application number
AU2013201445A
Inventor
Andrew A. Cullen Iii
Ivan Danilov
Leonid Zilberman
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
IQNavigator Inc
Original Assignee
IQNavigator Inc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Priority claimed from AU2010200800A external-priority patent/AU2010200800A1/en
Application filed by IQNavigator Inc filed Critical IQNavigator Inc
Priority to AU2013201445A priority Critical patent/AU2013201445A1/en
Publication of AU2013201445A1 publication Critical patent/AU2013201445A1/en
Assigned to IQNAVIGATOR, INC reassignment IQNAVIGATOR, INC Request for Assignment Assignors: VOLT INFORMATION SCIENCES, INC
Abandoned legal-status Critical Current

Links

Abstract

A paperless web enabled electronic billing and payment method including purchase-order processing by a buyer and supplier; voucher/payment request processing by a supplier; voucher/payment request processing by the buyer; and billing data extract and payment processing by the buyer.

Description

1 The present invention relates to a computer system and method for electronically facilitating the project bid and requisition process, and specifically to electronically managing all aspects of the project bid and requisition process. Description of Related Art 5 Corporations, businesses and other types of enterprises regularly utilize third party providers (vendors) to handle various business functions, such as providing a good or service. Typically, these outsourced business functions are performed under a "project," "staff supplementation" or "consulting" (hereinafter collectively referred to as "project work") agreement between the buyer and the 10 vendor. The various tasks involved in project work, such as vendor engagement, project administration, resource management and project accounting, can be extremely complex, entailing the convergence of numerous buyer organizational departments, such as purchasing, finance, operations, legal, human resources, security and the project management organization. 15 Due to the complexity of project work, it has become standard in today's business environment to employ multiple systems and processes to facilitate the management of project work. For example, typically, separate systems and processes are used for one or more aspects of project work, such as vendor qualification, bid solicitation, bid response, bid evaluation, contract administration, 20 milestone/deliverable administration, payment vouchering and quality control. Currently, there exists on-line "bid" and "auction" systems for handling the bid solicitation and bid response processes, project management tracking systems for 2 providing the milestone/deliverable administration process and financial processing systems for administering the payment vouchering process. However, there does not exist a single system for managing all aspects of project work. 5 To overcome the deficiencies of the prior art, embodiments of the present invention provide a comprehensive, web-enabled computer system and method for facilitating and managing all aspects of project work, while synchronizing communications, data and transaction processing across multiple user platforms. To implement the web-embedded computer system and method, a bid item list is 10 utilized to create configurable and scalable customized bid templates premised on the specific type of project work required. Bid requests are generated from the customized bid templates for solicitation of vendor bid responses to the selected bid items included within the bid template. In further embodiments, utilizing a bid template for generation of buyer bid 15 requests and associated vendor bid responses enables efficient and effective analysis and comparison of vendor bid responses. One or more bid items within the vendor bid responses can be selected for vendor grading purposes, and comparison of the vendor bid responses can be conducted using the graded bid item responses. 20 In still further embodiments, upon award of the bid, project tracking parameters can be entered into the computer system for tracking the performance of the project. For example, the project tracking parameters can provide the ability 3 to track project milestones/deliverables, time keeping, expense/payment vouchering, project accounting and project close out. Advantageously, the computer system of the present invention facilitates the entire project work bid process, optimizes the project engagement and administrative processes and 5 protects the legal, business and financial interests of the buyer. In one aspect the present invention provides a paperless web enabled electronic billing and payment method including: purchase-order processing by a buyer and supplier; voucher/payment request processing by a supplier; 10 voucher/payment request processing by the buyer; and billing data extract and payment processing by the buyer. In another aspect the present invention provides a project-work risk management documentation method including: configuring an electronic temporary-laborer risk-management document 15 library; wherein the step of configuring the temporary-laborer risk-management document library includes: specifying a plurality of temporary-laborer risk-management documentation types, the plurality of documentation types being representative of documents 20 that may need to be executed or provided by a temporary laborer; specifying a plurality of temporary-laborer types such that a temporary laborer is classified into a single one of the plurality of temporary-laborer types; and mapping the plurality of temporary-laborer types to the plurality of 25 temporary-laborer risk-management documentation types to determine, for each temporary-laborer type, which ones of the plurality of document types must be provided or executed by temporary laborers belonging to the temporary-laborer type; configuring a plurality of bid templates according to at least one project 30 services type, the plurality of bid templates being usable for creation of buyer bid requests; wherein the configured plurality of bid templates comprise a plurality of pre-specified bid items associated with specific types of information to be solicited 3a from a vendor, the plurality of pre-specified bid items including the specified plurality of temporary-laborer types and plurality of temporary-laborer risk management documentation types; responsive to a bid request based on a particular bid template in the 5 plurality of bid templates, receiving, from a vendor, a temporary-laborer record; wherein receipt of the temporary-laborer record is conditioned on approval by at least one pre-configured approver, the approval being based, at least in part, on a pre-defined appropriate vendor response to at least one bid item of the particular bid template; 10 providing at least one temporary-laborer document; administering a temporary-laborer agreement; and wherein the step of configuring the temporary-laborer risk-management document library, the step of configuring the plurality of bid templates, the providing step, and the administering step are implemented by a computer 15 system. In a further aspect the present invention provides a method of managing a business process work flow, the method including: establishing defined functional user-role positions within a data processing environment; 20 enabling process specification via status code/condition management; mapping the user-role positions to at least one process; performing real-time process management; and enabling specific process transaction management. In still a further aspect the present invention provides a human resource 25 time keeping, expense management, and work acknowledgement method including: creating and storing by a buyer of a purchase order record; validating, by a supplier, of data of the purchase order record; enabling, by the buyer, of supplier human resource access to the voucher 30 system; enabling supplier human resource data input into a time keeping/work acknowledgement voucher tracking and submittal system; 3b enabling buyer review and disposition of a submitted supplier work acknowledgement voucher; and enabling an automated bill/pay function. BRIEF DESCRIPTION OF THE DRAWINGS 5 The disclosed invention will be described with reference to the accompanying drawings, which show important sample embodiments of the invention and which are incorporated in the specification hereof by reference, wherein: FIG. 1 is a high-level functional view of the project work bid process 10 involved in the present invention; FIG. 2A is a network diagram of the computer system of the present invention; FIG. 2B is an alternate network diagram of the computer system of the present invention implemented at the buyer network; 15 FIGs. 3A and 38 illustrate the physical network architecture of the computer system of the present invention; FIGs. 4A-4D are exemplary home web pages associated with each of the user modules shown in FIGs. 2A and 2B; FIG. 5 is a flowchart illustrating exemplary steps for engaging in a project 20 work bid process, in accordance with embodiments of the present invention; 4 FIG. 6 illustrates the electronic facilitation of a vendor qualification process for defining the type of project work a vendor provides and/or a buyer requires and qualifying vendors for buyers, in accordance with embodiments of the present invention; 5 FIG. 7 is a flow chart illustrating exemplary steps for qualifying a vendor for a buyer, in accordance with embodiments of the present invention; FIG. 8 illustrates sample information processing involved in responding to a bid request and various user roles responsible for the information processing; FIG. 9 is a flowchart illustrating exemplary steps for defining and assigning 10 the various resources involved in the project work process, in accordance with embodiments of the present invention; FIG. 10 is a database table view illustrating the definition and assignment of user roles, in accordance with embodiments of the present invention; FIG. 11 is an exemplary screen shot of the assignment of resources to user 15 roles; FIG. 12 is a flowchart illustrating exemplary steps for defining and assigning user roles during a bid or project transaction, in accordance with embodiments of the present invention; FIGs. 13A and 13B are flowcharts illustrating exemplary steps for managing 20 workflow pertaining to a bid or project transaction based on user roles, in accordance with embodiments of the present invention; 5 FIG. 14 is a flowchart illustrating exemplary steps for modifying user role assignments, in accordance with embodiments of the present invention; FIG. 15 a data flow diagram illustrating a bid template creation tool and bid request creation tool for generating a bid request for a particular project, in 5 accordance with embodiments of the present invention; FIGs. 16A-16D are flowcharts illustrating exemplary steps for creating a bid template, a bid request from the bid template and a bid response from the bid request; FIG. 17 is a database table view illustrating a hierarchical bid item list from 10 which bid templates can be created FIG. 18 is a flowchart illustrating exemplary steps for accessing the hierarchical bid item list to create a bid template; FIG. 19 is a screen shot illustrating the creation of a bid template; FIG. 20 is a flow chart illustrating exemplary steps for generating a bid 15 request utilizing a bid template, in accordance with embodiments of the present invention; FIGs. 21-22 are screen shots illustrating various types of bid items associated with the particular bid template that can be selected from to include in a bid of the bid template type; 20 FIG. 23 is a flowchart illustrating exemplary steps for administering the communication of a bid request to qualified vendors; 6 FIG. 24 is a screen shot illustrating the selection of qualified vendors to receive the bid request; FIG. 25 is a flowchart illustrating exemplary steps in a vendor bid response process, in accordance with embodiments of the present invention; 5 FIGs. 26-28 are screen shots illustrating the vendor bid response process; FIG. 29 is a database table view illustrating the interrelation between the bid request and vendor bid response data, in accordance with embodiments of the present invention; FIG. 30 is a screen shot illustrating the various bid processing features 10 provided to a buyer; FIG. 31 is a data flow diagram illustrating the electronic facilitation of vendor bid response grading, in accordance with embodiments of the present invention; FIGs. 32 and 33 are flowcharts illustrating exemplary steps for grading vendor bid responses, in accordance with embodiments of the present invention; 15 FIGs. 34A-34E are screen shots illustrating a sample bid response grading process; FIG. 35 is a database table views illustrating the interrelation between the bid request, vendor bid responses and grading of vendor bid responses, in accordance with embodiments of the present invention; 20 FIG. 36 is a flowchart illustrating a vendor re-quotation process based upon the vendor bid response grading, in accordance with embodiments of the present invention; 7 FIG. 37 is a flowchart illustrating exemplary steps in a project administration setup process, in which the project is awarded to a vendor and the terms and conditions of the project are finalized and entered into the computer system to track milestones and deliverables, in accordance with embodiments of the present 5 invention; FIG. 38 is a flowchart illustrating exemplary steps for approval of assigned resources to a project, in accordance with embodiments of the present invention; FIG. 39 is a screen shot illustrating exemplary buyer project administration features; 10 FIG. 40 is a screen shot illustrating exemplary vendor project administration features; FIG. 41 is a database table view illustrating various project administration components handled by the computer system of the present invention; FIG. 42 is a screen shot illustrating the types of liability issues that can be 15 managed by the computer system of the present invention; FIG. 43 is a flowchart illustrating exemplary steps for entering contractor time for a project, in accordance with embodiments of the present invention; FIGs. 44-46 are screen shots illustrating a sample time keeping process; FIG. 47 is a database table view illustrating the tracking of project 20 deliverables and vouchering, in accordance with embodiments of the present invention; 8 FIG. 48 illustrates the electronic facilitation of a payment vouchering process for submitting and approving payment vouchers and creating a payment voucher, in accordance with embodiments of the present invention; FIG. 49 is a flowchart illustrating a voucher payment process, in accordance 5 with embodiments of the present invention; FIG. 50 is a database table view illustrating the generation of payable vouchers, in accordance with embodiments of the present invention; and FIG. 51 is a screen shot illustrating project financial data. 10 The numerous innovative teachings of the present application will be described with particular reference to exemplary embodiments. However, it should be understood that these embodiments provide only a few examples of the many advantageous uses of the innovative teachings herein. In general, statements made in the specification of the present application do not necessarily 15 delimit any of the various claimed inventions. Moreover, some statements may apply to some inventive features, but not to others. In accordance with embodiments of the present invention, a vendor is any provider of goods and/or services, a buyer is any purchaser of goods and/or services, a contractor is a resource employed by a vendor for project work and an 20 administrator is a third-party system administrator or buyer-employed project administrator. Buyers can solicit bids from vendors for a particular good and/or service (hereinafter referred to as a project) in a form specified by the buyer using 9 a bid request generated from a pre-established list of bid items related to the project type. Therefore, the bid responses submitted from vendors all have the same form, enabling efficient and effective evaluation of the bid responses. Embodiments of the present invention further combine the bid process with project 5 management to enable the buyer, vendor, contractor and administrator to track the performance of the project after the bid is awarded. FIG. 1 is a high-level functional view of the bid process involved in the present invention. Bid request data 210 associated with a particular bid request 200 is provided from a buyer 50 to a project bid management system 30. The 10 buyer 50 can be an individual, business entity or any other type of buyer 50 that requires performance of a project. The bid request data 210 received at the project bid management system 30 is in a form pre-designated by the buyer 50. For example, the form can include one or more bid items selected from a configurable pre-established list of bid items for the particular project type, and the 15 bid request data 210 can be related to one or more of these selected bid items. The bid request data 210 is formatted by the project bid management system 30 and transmitted as a bid request 200 to one or more vendors 10a ... IOn for solicitation of respective bid responses 220. For example, the vendor 10 can be an individual 10a, business entity 1Ob or any other vendor 1On that is 20 capable of performing the requested project. Bid responses 220 are submitted from the vendors 10 to the project bid management system 30 for review prior to forwarding qualified bid responses 2201 to the buyer 50. For example, the project 10 bid management system 30 may be pre-configured to force vendor completion of required bid response items in a specific data format to enable the system 30 to perform some filtering of vendor bid responses 220. In this way, the system 30 can ensure that the buyer 50 only receives the bid responses 220 that have the 5 necessary data for bid evaluation. In accordance with embodiments of the present invention, the project bid management system 30 can be implemented within a computer system 100, as is shown in FIG. 2A. A user 5 enters the computer system 100 through a data network 40 via a web browser 20. A user 5 includes any person associated with a 10 vendor 10, buyer 50, administrator 80 (e.g., a third-party or buyer-employed administrator) or contractor 15 assigned to a project. By way of example, but not limitation, the data network 40 can be the Internet or an Intranet and the web browser 20 can be any available web browser or any type of Internet Service Provider (ISP) connection that provides access to the data network 40. Vendor 15 users 5 access the computer system through a vendor browser 20b, buyer users 5 access the computer system via a buyer browser 20a, contractor users 5 access the computer system via a contractor browser 20c and administrative users 5 access the computer system through an administrative browser 20d. The users 5 access the computer system 100 through a web server 120 or 125 capable of 20 pushing web pages to the vendor browser 20a, buyer browser 20b, contractor browser 20c and administrative browser 20d, respectively. A bid web server 120 enables vendors 10, buyers 50, contractors 15 and 11 administrators 80 to interface to a database system 150 maintaining data related to the vendors 10, buyers 50, contractors 15 and administrators 80. The data related to each of the vendors 10, buyers 50, contractors 15 and administrators 80 can be stored in a single database 155, in multiple shared databases 155 or in 5 separate databases 155 within the database server 150 for security and convenience purposes, the latter being illustrated. For example, the database system 150 can be distributed throughout one or more locations, depending on the location and preference of the buyers 50, vendors 10, administrators 80 and contractors 15. 10 The user interface to the vendor users 5 is provided by the bid web server 120 through a vendor module 115. For example, the vendor module 115 can populate web pages pushed to the vendor browser 20b using the data stored in the particular vendor database 155b. The user interface to the buyer users 5 is provided by the bid web server 120 through a buyer module 110. For example, 15 the buyer module 110 can populate web pages pushed to the buyer browser 20a using the data stored in the particular buyer database 155a. The user interface to the contractor users 5 is provided by the web server 120 through a contractor module 130. For example, the contractor module 130 can populate web pages pushed to the contractor browser 20c using the data stored in the contractor 20 database 155c. The user interface to the administrative users 5 is provided by the bid web server 120 through an administrative module 135. For example, the administrative module 135 can populate web pages pushed to the administrative 12 browser 20d using the data stored in the administrator database 155d. It should be noted that the vendor module 115, buyer module 110, contractor module 130 and administrative module 135 can each include any hardware, software and/or firmware required to perform the functions of the vendor module 115, buyer 5 module 110, contractor module 130 and administrative module 135, and can be implemented as part of the bid web server 120, or within an additional server (not shown). The computer system 100 further provides an additional user interface to administrative users 5 through an administrative web server 125. The 10 administrative web server 125 enables administrators 80 to interface to a top-level database 160 maintaining data related to the vendors 10, buyers 50 and contractors 15 registered with the computer system 100. For example, the top level database 160 can maintain vendor qualification data 162, buyer-defined vendor criteria data 164 and contractor re-deployment data 166. 15 To access information related to vendors 10, the administrative web server 125 uses a vendor module 145 to push web pages to the administrative browser 20d related to vendors 10. For example, the vendor module 145 can access vendor qualification information 162 to qualify vendors 10 for a particular buyer 50 or for a particular industry. Likewise, the administrative web server 125 can push 20 web pages to the administrative browser 20d related to the buyer-defined vendor criteria information 164 through a buyer module 140 in order to qualify vendors 10 for a particular buyer 50. A contractor module 148 enables administrators 80 to 13 access contractor re-deployment data 166 entered by contractors 15 through the bid server 120 and retrieved into the top-level database 160 from a contractor database 155. The re-deployment data 166 can include, for example, an indication of the mobility of the contractor, desired geographical areas, contractor 5 skills, desired pay and other contractor information that can be used to.assist administrators 80 in qualifying vendors 10 for buyers 50. In another embodiment, as shown in FIG. 2B, the computer system 100 can be implemented solely at the buyer network. In FIG. 2B, vendor users 5 enter the computer system 100 via a data network 40 through a vendor browser 20b, as in 10 FIG. 2A. However, the web server 120 in FIG. 2B is a buyer web server controlled and operated by a single buyer. The database system 150 stores only the buyer data related to that particular buyer and only the vendor, contractor and administrator data pertinent to that particular buyer. For example, the vendor qualification data for only those vendors that are qualified by the buyer is stored in 15 the database system 150. Referring now to FIG. 3A, exemplary physical network equipment for implementing the computer system 100 is shown. A vendor user, a buyer user, contractor user or an administrative user accesses the web server 120 of the computer system 100 by connecting a computer 60a, 60b, 60c or 60d, 20 respectively, to a data network 40. Each computer 60a-60d can be, for example, a personal computer, a laptop computer, a computer connected to a wireless device for remote access to the data network, a handheld wireless device providing a web 14 browser capable of accessing the data network or other type of machine implementing a web browser. The web server 120 can be, for example, a Microsoft Internet Information Services (IHS) server. The web server 120 connects to an appropriate database system 150, depending on the type of user. The 5 database system 150 can be implemented in, for example, one or more SQL servers. Turning now to FIG. 3B, exemplary functionality implemented in the physical network equipment of the computer system 100 is shown. A user computer 60 can access the data network 40 using a web browser 66 resident 10 within a storage medium 64 of the computer. For example, the storage medium can be a disk drive, random access memory (RAM), read-only memory (ROM), compact disk, floppy disk, tape drive or any other type of storage medium. A processor 62 (e.g., a microprocessor or microcontroller) within the computer 60 loads and runs the web browser 66 to access the data network 40. 15 Upon entering the Uniform Resource Locator (URL) of the web server 120 into a computer, a connection between the computer 60 and the web server 120 is created. The web server 120 pushes web pages 61 to the computer 60 for viewing by the user on a user interface device 65. In one embodiment, the user interface device 65 is a computer screen 15 connected to the computer 60. For 20 example, once a user has been validated (e.g., by entering a user name and password), the user can view one or more web pages 61 on the computer screen 65, each containing prompts for the user to enter various information into the 15 computer system 100. The user can enter the information into the computer 60 for transmission via the data network 40 to the web server 120 via an 1/0 interface 68 and any type of input device 70, such as, for example, a mouse, keyboard, light pen, touch screen (not shown) or voice recognition software (not shown). 5 At the web server 120, a processor (e.g., a microprocessor or microcontroller) loads and executes computer instructions resident in software modules 128 stored within a storage medium 124, which can be any type of storage medium, as discussed above in connection with storage medium 64. The computer instructions can be created using any type of programming technique, 10 including object-oriented programming techniques. For example, the software modules 128 may contain the computer instructions for the vendor modules, buyer modules, contractor modules and administrative modules (shown in FIGs. 2A and 2B) for populating web pages 61 for vendor users, buyer users, contractor users and administrative users, respectively. Based on the computer user log-in to the 15 web server 120, the processor 122 accesses the appropriate software module 128 to determine the database system 150 associated with the computer user and retrieves the data related to the computer user for population in web pages 61 for display on the computer screen 65 of the computer 60. In addition, the software modules 128 may further be configured to store data received from the computer 20 user within the database system 150. Examples of web pages 61 displayed to buyer users, vendor users, contractor users and administrative users are shown in FIGs. 4A-4D, respectively.
16 FIG. 4A illustrates a sample buyer home page 61a displayed to a buyer user upon log-in and authentication (e.g., a challenge and response authentication) of the buyer user. As can be seen in FIG. 4A, there are a number of system features available to the buyer user at the buyer home page 61 a. For example, the buyer 5 user can be provided links to update their personal profile in the system, create an RFP/RFQ (referred to herein as a bid request), administer current bid requests, approve a vendor bid response to award the bid (project) to a particular vendor, process a current project, view historical bid requests or access a voucher processing system to view various project related event tracking requests, such as 10 contractor time cards. The buyer user can further remain updated as to system modifications, receive instructions on how to maneuver through the system and contact a system administrator (e.g., a third-party administrator or buyer-employed administrator) for assistance through the buyer home page 61 a. In FIG. 4A, the buyer user is further provided with the current status of 15 pending bids and projects at the home page 61 a. However, it should be understood that the current activities can be displayed in subsequent web pages, instead of at the home page 61 a. For example, the buyer user can be provided with the number of open bid requests (submitted bid requests) and the number of temporarily saved bid requests (created but not yet submitted bid requests). By 20 clicking on the open bid request button, the buyer user can be linked to another web page displaying a list of the open bid requests with subsequent links to web pages that contain the actual open bid requests. Therefore, from the buyer home 17 page 61a, the buyer user can link to any information pertaining to bids or projects that the buyer user has access to. FIG. 4B illustrates a sample vendor home page 61 b containing a number of system features available to the vendor user. For example, the vendor home page 5 61b can provide links to update the vendor profile (e.g., the types of goods and/or services the vendor provides), respond to received bid requests, process current projects or access a voucher processing system to view existing project event completion requests or process new project event completion requests. In FIG. 4B, the vendor user is also provided with the current status of pending bids and 10 projects. For example, the vendor user can determine the number of bid requests that the vendor needs to respond to and the number of temporarily saved bid responses that the vendor has not yet completed. From the vendor home page 61 b, the vendor user can link to additional web pages to complete vendor bid responses or access a newly received bid request to begin the vendor bid 15 response. FIG. 4C illustrates a sample contractor home page 61c containing a number of system features available to the contractor. For example, the first time a contractor user enters the contractor home page 61 c, the contractor user may be directed to agree to various non-employee worker agreements before accessing 20 any other information in the system. Each of the non-employee worker agreements can be displayed to the contractor user, and the contractor user can be prompted to agree to or otherwise accept the terms of the agreements before is continuing. Once the contractor user has completed all of the agreements, the contractor user can access the time keeping system to enter contractor time, update their skills profile or provide re-deployment preferences. In addition, current activities associated with the contractor user may also be displayed to the 5 contractor user at the contractor home page 61 c, such as the number of interviews requested or interviews scheduled for additional projects. FIG. 4D illustrates a sample administrator home page 61 d containing a number of features available to an administrative user. For example, the administrative user can access information on buyers, vendors or contractors, link 10 to web pages containing bid requests that need to be approved, approve a bid response to award the bid to a particular vendor, process a current project or access a voucher processing system to view existing vendor/contractor requests for project activity approval, such as contractor time cards. In addition, the current activities of the administrative user can also be displayed on the administrator 15 home page 61d. For example, the number of bid requests awaiting approval, the number of new bid requests and the number of new vendor responses can be displayed to the administrative user. From the administrator home page 61d, the administrative user can link to any information pertaining to the bid process or project management that the administrative user has access to. For example, if 20 the administrative user is a third-party administrator, the administrative user may have access to the bids and projects of all buyers and vendors registered with the system. However, if the administrative user is a buyer-employed administrator, 19 the administrative user may only have access to bids and projects associated with the particular buyer. Exemplary steps in the bid/project process 500 handled by the project bid management systern of the present invention are shown in FIG. 5. There are 5 several aspects of the bid/project process that are handled prior to any bid requests being submitted (step 505). For example, a buyer may want to create a list of qualified vendors for particular bid requests types to reduce processing time during bid solicitation, as will be described in more detail below in connection with FIGs. 6 and 7. As another example, buyers, vendors and administrators may want 10 to designate particular personnel to handle different components of the bid/project process for efficient routing of messages and information during the bid/project process, as will be described in more detail below in connection with FIGs. 8-14. Once all of the pre-bid activity is completed (step 510), a buyer can create a bid request for a project (step 520), as will be described in more detail below in 15 connection with FIGs. 15-29, and submit the bid request to an administrator for approval (step 525), if necessary, as will be described in more detail below in connection with FIG. 20. Most companies require approval of bid requests for budgetary purposes. However, if the buyer is an individual or small business, the buyer user creating the bid request may not need approval from any other party to 20 submit the bid request. Once the bid request has been approved, the bid request is broadcast (e.g., made available to vendors via the system with optional notification via electronic 20 mail) to qualified vendors (step 530), as will be described in more detail below in connection with FIG. 23, to solicit a bid response from the vendors (step 535). Each of the bid responses is evaluated by the buyer, as will be described in more detail below in connection with FIGs. 32 and 33, to determine which vendor bid 5 response is the most qualified (step 540). After the buyer selects a particular vendor for the project, the buyer and vendor negotiate the final terms and conditions of the contract (step 545) and these terms and conditions can be loaded into the system for project tracking purposes (step 550), as will be described in more detail below in connection with FIG. 37. Thereafter, the vendor 10 selects the specific resources (contractors) for the project, and if the terms of the project require buyer approval of resources, the buyer approves all of the assigned resources before the project ensues (step 555), as will be described in more detail below in connection with FIG. 38. Once all of the bid activity is completed (step 515), the system is further 15 capable of handling post-bid activity (step 560) to track the performance of the project and payment of vouchers during the course of the project. For example, the vendor and contractors assigned to the project can enter time worked and expenses into the system (step 565) for the generation of payable vouchers to be submitted to the buyer through the system, as will be described in more detail 20 below in connection with FIG. 43. Upon receipt of the vouchers, the buyer and/or administrator can review and approve the vouchers for payment to the vendor (steps 570 and 575), as will be described in more detail below in connection with 21 FIG. 49. Other project tracking parameters can also be entered into the system to track the performance of the vendor through project closure (step 580), as will be described in more detail below in connection with FIGs. 39 and 40. Each of the main components of the bid/project process (pre-bid activity, bid activity and post 5 bid activity) will now be discussed separately hereinbelow. PRE-BID ACTIVITY As discussed above, a buyer 50 may want to pre-qualify vendors 10 for particular project types to reduce the amount of processing required for each bid 10 request submitted. Referring now to FIG. 6, to facilitate vendor qualification for buyers, the computer system 100 can enable buyers 50 to establish buyer-defined vendor criteria data 164 for vendors and store the buyer-defined vendor criteria data 164 within the top-level database 160 in a master buyer list 161. The computer system 100 can further acquire pertinent vendor qualification data 162 15 from vendors 10 and store the vendor qualification data 162 in the top-level database 160 in a master vendor list 163. For example, the vendor qualification data 162 can identify the specific goods and/or services that the vendor 10 provides and the specific geographical areas that the vendor 10 is capable of supplying these goods and/or services, 20 along with other vendor information, such as the size of the vendor, whether the vendor has insurance, whether the vendor is certified in certain industries, etc. The buyer-defined vendor criteria data 164 can identify the specific goods and/or 22 services that the buyer 50 desires, the specific geographical areas that the buyer 50 wants the goods and/or services and other buyer constraints, such as the preferred size of the vendor, requisite vendor insurance needs, requisite vendor certifications, etc. 5 Based on the vendor qualification data 162 and buyer-defined vendor criteria data 164, the computer system 100 can determine which vendors 10 have the requisite qualifications for buyers 50 and provide qualified vendor information 170 (e.g., name, address, and any other vendor information that the buyer needs) to the buyer 50 for review. If the buyer 50 or optionally the administrator 80 10 approves of the vendor 10, the buyer 50 can add the vendor information 170 to a vendor list 158, which is stored in the buyer database 155a. In addition, vendor information 172 for those vendors 10 that the buyer 50 previously qualified can also be stored in the vendor list 158. Furthermore, a master copy of the vendor list 158 (i.e., Master Vendor List for Buyers 165) can be stored in the top-level 15 database 160 for redundancy and updating purposes. Buyer information 174 (e.g., name, address and other information that the buyer agrees to provide) can also be downloaded to the vendor database 155b for storage in a buyer list 159 therein. In addition, a master copy of the buyer list 159 (i.e., Master Buyer Ust for Vendors 167) can be stored in the top-level database 20 160 for redundancy and updating purposes. However, it should be understood that if the computer system 100 is implemented solely at the buyer network, the top-level database 160 would not store master copies 165 and 167, and the buyer 23 50 would perform vendor qualification using only the vendor information 172 known to the buyer 50 or provided directly to the buyer 50 by the vendor 10. For a complete discussion of qualifying vendors 10 for buyers 50 based on vendor qualification data 162 and buyer-defined vendor criteria data 164, reference is 5 made to co-pending and commonly-assigned U.S. Patent Application Serial Number 10/141,801, which is hereby incorporated by reference in its entirety herein. Exemplary steps for qualifying vendors for buyers are shown in FIG. 7. Once the buyer-defined vendor criteria information is established (step 700) and 10 vendor qualification information from a vendor is received (step 710), the buyer defined vendor criteria information is compared to the vendor qualification information (step 720) to determine whether the vendor qualification information matches the buyer-defined vendor criteria information (step 730). If so, the vendor and buyer are notified of the match (step 740), and if the buyer approves of the 15 vendor, the vendor information associated with the vendor is stored in the buyer's vendor list for later use in preparing bid requests (step 750). In addition, the buyer information can be stored in the vendor's buyer list for reference when receiving bid requests and preparing bid responses (step 760). However, if the vendor qualification information does not match the buyer 20 defined vendor criteria information (step 730), the system determines whether additional vendor qualification information is needed to qualify the vendor for the buyer (step 770). If so, the vendor is requested to provide this additional vendor 24 qualification information (step 780) to qualify the vendor for the buyer (step 710). If not, the vendor is not qualified for the buyer (step 790), and the vendor is not added to the buyer list. In addition to qualifying vendors for buyers, vendors, buyers and 5 administrators may want to designate certain personnel to handle various aspects of the bid/project process to synchronize communications, data and transaction processing across multiple user platforms. For example, referring now to FIG. 8, the bid/project process typically requires the inclusion of a broad spectrum of information processing and functional departments to facilitate the administration 10 and management of the bid/project process. Such information processing can include, for example, bid request broadcasting, vendor bid responses, bid disposition (evaluation and award), resource submittal, time card submission, deliverables tracking and payment vouchering. Each of these information processing components may be handled by one or more different individuals or 15 departments, such as the COO, Human Resources department, Project Manager and Financial Processor. To meet this functional need, the computer system of the present invention can enable a shared work environment, where the buyer, vendor and/or administrator can specify multiple custom user roles that need to participate in the bid/project process and designate personnel (resources) to each 20 of the user roles for all bid/projects or for particular bid/projects. Referring now to FIG. 9, there is illustrated exemplary steps for specifying user role positions and assigning personnel to the user role positions for a vendor, 25 buyer or administrator. Initially, the vendor, buyer or administrator determine the specific user role positions that are needed for the bid/project process (step 900). For example, as shown in the sample buyer web page of FIG. 11, the buyer may determine that there is a need for several different user role categories, such as 5 financial approvers, non-financial approvers, time card reviewers, administrate delegates, project milestone administrators, financial coordinators and human resource partners during the project/bid process. The vendor, buyer or administrator may further determine that multiple user role positions within one or more of the user role categories are needed for the bid/project process. For 10 example, as shown in FIG. 11, the buyer may determine that there is a need for six financial approvers and two non-financial approvers. Referring again to FIG. 9, once the user role positions are determined, a data file for the pertinent personnel of the vendor, buyer or administrator is stored for use in selecting appropriate personnel for each of the user role positions (step 15 905). One or more key personnel of the vendor, buyer or administrator (e.g., the COO, Project Manager, etc.) can be selected to designate the particular personnel to be assigned to each of the user role positions (step 910), or alternatively, the system can assign personnel to user role positions based on the information contained in the personnel data file. In some companies, user role positions are 20 pre-designated (step 915), and in this case, the pre-designated personnel can be loaded into the system (step 920) and stored in a user role table (step 925). For example, for most vendors, personnel is pre-assigned to various user role 26 positions for all projects. In other companies, one or more of the user role positions may not be pre-designated at all or not pre-designated for a particular project (step 915), and in this case, the selected key personnel or the system can assign specific personnel to the user role positions. 5 To assign specific personnel to user role positions, the specific user role position is selected (step 930), and a list of personnel that can be assigned to that user role position, depending upon user role constraints, is determined from the personnel data file (steps 935, 940 and 945). For example, if a user role position requires a particular level manager, only those personnel at the particular manager 10 level or higher are included on the list. From the list of personnel for the user role position, one of the personnel is selected for the particular user role position (step 950) and the selected personnel is stored in the user role table (step 925). For example, as shown in FIG. 11, upon selecting a particular user role position (e.g., clicking on a user role position), the system can search for qualified personnel for 15 the user role position, and after a selection has been made, the selected personnel for the user role position can be displayed. Examples of data structures for selecting and assigning user role positions for a buyer are shown in Tables 1-9 hereinbelow. The data structures are illustrated for simplicity as being organized in a table format, with each table 20 including all of the fields necessary for defining and assigning user role positions for the buyer. The tables are related in a hierarchical and/or relational manner, so that all of the necessary information for user role positions can be accurately 27 stored and accessed, as will be described hereinbelow in connection with the exemplary database table structure 300 of FIG. 10. However, it should be understood that other buyer user role configurations can be included, and the system is not limited to the specific buyer user role configurations listed in Tables 5 1-9 or FIG. 10. Tables 1 and 2 below illustrate sample user role categories and user role positions within each of the user role categories, respectively, which can be stored in the database in tables "tbIHMPositionCategories" 305 and "tblHMPositions" 306, respectively, as shown in FIG. 10. In Table 1, each user role category is assigned 10 an identification number and a display order for display on a web page. The user role category identification numbers are used within the user role positions table (Table 2) to correlate the user role positions with the specific user role categories. However, it should be understood that there could be numerous additional categories and positions, depending on the needs of the buyer. When initially 15 selecting the user role positions, the user role categories can be displayed for the user to select from, with links to the specific user role positions within each of the categories. After all user role positions have been selected for the particular buyer, the selected user role positions and assigned personnel can be displayed as in FIG. 11. 20 TABLE 1 Exemplary User Role Categories (tblHMPositionCategories) 28 PositionCategoryI PositionCategoryName ASPCategoryDisplay_Ord D er 1 Financial Approvers 1 2 Non-Financial Approvers 2 3 Timecard Reviewers 3 4 Administrative Delegates 4 5 ProjectMilestoneAdministrato 5 rs 6 Financial Coordinators 6 7 Human Resource Partners 7 8 Security Partners 8 9 RegulatoryCompliance Partn 9 ____ ____ ____ ____ era 29 TABLE 2 Exemplary User Role Positions (tblHMPositions) Position ID Position Name Position CategoryID 1 MA FnancialIAproval Level 1 2 MB Financial Approval Level 1 3 MC Financial Approval Level 1_____ 4 MID Financial Approval Level 1_________ 5 ME Financial Approval Level 1 6 MF Fin ancialApprovalLevel 1______ 7 Non-Financial Approver 1 2 8No-inancial Appoverm 2 9 Timecard Reviewer 1 3 10 Timecard Reviewer 2 3 11 Administrative Delegate 1 4 12 Administrative Delegate 2 5 1 Reorject Milestone Administrator 14 Proict ilestone Administrator 2 5 15 Financial Coordinator 1 6 16 Financial Coordinator 2 6 17____ Human Resource Partner 1 7 18 Human Resource Partner 2 7 19 Project Bid Originator 4 20 SeuiyAmiitao 8 21 RegulatoryComplianceAdministra 9 ____ ___ ____ ___ ___ tor 5 Table 3 below illustrates sample data stored within the personnel date file for each user of the system, which can be stored in the database in table 'tblUser" 302, as shown in FIG. 10. From this user data, the qualified personnel for each user role position can be determined, and the requisite information for each assigned user for each user role position can be ascertained. One of the fields 10 within Table 3 is the business grade assigned to the particular user. The business 30 grade indicates the particular level of the user in the business system. For example, the user may be a level 3 manager, and this information would be stored in the user table. The available business grades can be mapped to the user role positions, as shown in Tables 4 and 5 below to indicate the business grade 5 required for the user assigned to each user role position which can be stored in the database in tables 'tblHMBusinessGrades" 303 and "tbHMPositiontoGradeMap" 304, as shown in FIG. 10. TABLE 3 Base System User Table (tblUser) 10 Column Data Type Length User ID int 4 Employee ID nvarchar 10 First Name nvarchar 50 Last Name nvarchar 50 Last Name 2 nd nvarchar 50 Middle Name nvarchar 10 SSN nvarchar 50 Business Title Description nvarchar 50 Business Grade Code nvarchar 10 Business Grade Description nvarchar 50 FinancialAroval Leve int 4 Birthdate datetime 8 Business Unit Name nvarchar 100 [Dept/Cost Centerl nvarchar 10 Dept Name nvarchar 50 Work Location Code numeric 9 Column Data Type Length Location Type nvarchar 50 Location Addressl nvarchar 50 Location Address2 nvarchar 50 Location City nvarchar 50 31 Location State nvarchar 50 Location Country nvarchar 50 Location Zip nvarchar 4 Country ID int 4 Work Phone Number nvarchar 50 Fax Number nvarchar 50 [E-Mail] nvarchar 50 User Name nvarchar 50 Password nvarchar 50 Active bit 1 Last Logged In datetime 8 Date Updated datetime 8 US Date Format bit 1 Currency ID int 4 TABLE 4 Base Business Grade Table (tbIlHMBusinessGrades) Column Name Data Type Length Business Grade Code nvarchar 10 Business Grade Description nvarchar 50 5 32 TABLE 5 User Role to Business Grade Mapping Table (tblHMPositiontoGradeMap) Column Name Data Type Length Position ID int 4 Business Grade Code nvarchar 10 Record ID int 4 5 Tables 6-9 below will be described in more detail hereinbelow in connection with FIG. 10. TABLE 6 Position/Role to Bid Template Mapping Table (tblHMPositIonsRFXMatrix) 10 Column Name Data Type Length Position ID int 4 RFX Template ID int 4 Position Required char 1 33 TABLE 7 Default User Role Mapping Table (tblHMPositions Relationships) Column Name Data Type Length User ID int 4 Position ID int 4 Relation ID int 4 Identifier int 4 5 TABLE 8 User Role to Bid Request Mapping Table (tblBidHMPositions) Column Name Data Type Length Bid Tracking ID int 4 User ID int 4 Position ID int 4 Relation ID int 4 Current Status ID int 4 Record ID int 4 TABLE 9 10 User Position/Role to Approval Level and Hierarchy Mapping (tblApproval Level) Column Name Data Type Length Position ID int 4 [Aroal Author money 8 Approval Routing Order numeric 9 Record ID int 4 34 As can be seen in FIG. 10, there is a concise relationship between all the fields necessary to enable configurable work sharing and specific workflow components for the buyer. The database structure 300 is scalable and configurable, so that even when operating within a less sophisticated database environment, the 5 functionality still exists as long as user role positions are specified and a personnel data file is available. It should be understood that similar database table structures are available to the vendor and administrator, which will be discussed in more detail hereinbelow. The database table structure 300 for the buyer takes as input personnel 10 data ("tblHRdata" 301) from the buyer and creates a personnel data file ("tIblUser" 302) including the specific personnel that may be involved in the shared work environment. The personnel data is shown as table "tblHRdata" 301 for simplicity purposes. However, it should be understood that the personnel data may be in any form, depending on the buyer database system. Periodic downloads from the 15 table "tblHRdata" 301 to the table 'tblUser 302 can be performed to update the system as to the current employees of the buyer to ensure that user role positions are properly assigned. The various business grades designated by the buyer can also be stored in table "tblHMBusinessGrades" 303 and mapped to table "tblUser" 302 for individual assignment of business grades, as discussed above in 20 connection with Tables 3 and 4. In addition, the business grades can be mapped to the selected user roles in table "tblHMPositiontoGrade" 304, as discussed above in connection with Tables 4 and 5.
35 The user role categories table ('tblHMPositionCategories" 305) and user role positions table ("tbIlHMPositions" 306), and their interrelation to the position grades and assigned personnel are also shown in FIG. 10. For example, table "tblHMPositionsRelationship" 307 includes the user ID of the assigned personnel 5 to each user role position. If user role positions are associated with specific bid template types (as described in more detail hereinbelow in connection with FIG. 15), the user role positions for each bid template type can be stored in table "tblHMPositionsRFXMatrix" 309. Furthermore, if user role positions are assigned specific to each bid transaction, the user ID of the assigned personnel to each 10 user role position for a specific transaction can be stored in table "tblBidHMPositions" 308. Exemplary steps for a buyer to assign personnel to user role positions during a transaction are shown in FIG. 12. Upon initiation of a transaction (step 1200) (e.g., creation of a bid template or bid request, broadcasting of the bid 15 request, receipt of bid response, evaluation of bid response, awarding of bid, payment of voucher, etc.), the system and/or key personnel determines whether all of the required user role positions for the transaction have been defined (step 1205). If not, the system and/or key personnel define the user role positions necessary for the transaction (step 1210). 20 Once the user role positions have been ascertained, the system and/or key personnel determines whether specific personnel (also referred to herein as users) have been pre-designated for the user role positions (step 1215) and whether any 36 of the pre-designated users need to be changed for the transaction (step 1220). If one or more user role positions do not have a pre-designated user or if one or more pre-designated users should be changed, the system and/or key personnel designates the appropriate user for all user role positions (step 1225) and stores 5 the identity of the designated users for the user role positions in the user role table (step 1230) (e.g., "tblBidHMPositions" in FIG. 10). If all users are pre-designated, the system stores the pre-designated personnel (step 1230), and if applicable, notifies the appropriate personnel of the transaction (step 1240). Referring again to FIG. 10, in addition to assigning users to specific user 10 role positions for a bid/project process, the database table structure 300 further provides the ability to designate transactions that require approving and specific approvers for a variety of reasons. Therefore, within a table "tblApprovalLevel" 310, certain user role positions can be classified as approval positions, and for each approval position, the routing order for approval can be specified. For 15 example, a user role position approver (Approver A) can be designated to approve all transactions generated by another user role position (User B), so that the system automatically routes all transactions from User B to Approver A. In addition, each user can be provided access rights to view and modify data within the system. For example, one user role position may have the 20 authority to modify or enter data in the system through a first web page, while another user role position may only have the authority to view the data through a second web page. Thus, although the information displayed on the web page may 37 be the same to both users, the actual web pages are different, depending on the approval level of the user role position. When a user logs in to the system, the system determines the approval level of the user and pushes the appropriate web pages to the user. An example of a data structure implementing user role to web 5 page access mapping is shown below in Table 10. TABLE 10 User Role to Web Page Access Mapping Table Column Name Data Type Length ASP Object ID int 4 Position ID int 4 Read Access char 1 Write Access char 1 Record ID int 4 10 In order to maintain the relationship between user role positions, internal personnel and specific transactions in an ongoing manner, the system of the present invention is further designed to account for shifts in organizational personnel and the business level and user authority of personnel. Referring now to FIG. 14, there is illustrated exemplary steps for modifying user role position 15 assignments, in accordance with embodiments of the present invention. A user role position can be re-assigned based on the user name or the transaction type (step 1400). If the modification is made based on the user name (step 1405), the change can be made globally to all user role positions held by the user or to only specific user role positions held by the user. For global changes (step 1410), a 38 new user is selected (step 1415) and the new user is substituted for the previous user for all user role positions held by the previous user (step 1420). This type of global change is necessary, for example, when an employee leaves the company, and a new employee takes the exiting employee's position within the company. 5 For specific user role position changes (step 1410), all of the user role positions held by the user can be displayed (step 1425), and one of the user role positions can be selected for changes (step 1430). A new user is chosen for that selected user role position (step 1435) and the new user is substituted for the previous user for that selected user role position (step 1440). This process can be 10 repeated for each user role position that requires a change (step 1445). Specific user role position changes may occur for a number of reasons, such as promotion, reorganization, employee status changes (e.g. full-time to part-time), etc. If the modification is made based on the transaction type (step 1405), a listing of all transaction types (e.g., bid request creation, bid request broadcasting, 15 bid request receipt, bid response generation, bid response receipt, bid evaluation, bid award, time keeping, vouchering payment, etc.) can be displayed (step 1450), and a particular transaction type is selected (step 1455). All of the user role positions associated with that particular transaction type can be displayed (step 1460) and the particular user role position to be modified is selected (step 1465). A 20 new user is chosen for that selected user role position (step 1470), and the new user is substituted for the previous user for that selected user role position (step 1475). Transaction type modifications may be beneficial, for example, when the 39 particular user for a user role position is unknown, but a change is required due to customer complaints. The user role position modifications can be applied to existing transactions or only to new transactions (step 1480), depending on the reason for the 5 modification and the need for continuity in existing transactions. If the modification is to be applied to existing transactions, the user role table is updated with the new user and the previous user record is modified to "outdated" (step 1485). However, if the modification is only to be applied to new transactions, the user role table is updated with the new user, but the previous user is not deleted, and the new user 10 is marked for new transactions only (step 1490). For the vendor, user role positions are typically pre-designated to limit access to qualified personnel. Examples of data structures implementing vendor user roles are shown in Tables 11-13 hereinbelow. As can be seen, the vendor personnel can be assigned a vendor contact type, which can be mapped to access 15 rights to view and modify data within the system, similar to that described above for the buyer in connection with Table 10. However, it should be understood that other vendor user role configurations can be included, and the system is not limited to the specific configurations listed in Tables 11-13. 20 40 TABLE 11 Exemplary Vendor Roles (tblVendorRofes) VendorContactTypelD Description ASP Display Order 1 CEO 1 2 CFO 2 3 COO 3 4 Financial Processing 6 Supervisor 5 Staffing Personnel 7 6 Account Manager 5 7 Project Manager 8 8 Chief Counsel 4 TABLE 12 5 Exemplary Vendor Contacts (tblVendorContacts) Column Name Data Type Length VendorContactlD int 4 vcVendorContactGU D uniqueidentifier 16 vcPermissionLevel int 4 vcContactTypelD int 4 vcFirstName varchar 50 vcLastName varchar 50 vcPositionTitle varchar 100 vcSalulation varchar 50 vcAddress1 varchar 50 vcAddress2 varchar 50 vcCity varchar 50 vcState varchar 50 vcCountrylD varchar 50 vcPostalCode varchar 20 vcEmail varchar 50 vcVendorlD int 4 vcLoginName varchar 50 vcPassword varchar 50 vcStatuslD int 4 vcDateExpire datetime 8 vcInternationalFlag varchar 50 41 TABLE 13 Exemplary Vendor Roles Permissions (tblVendorRolePermissions) Column Name [Data ype Length ASP Object ID int 4 VendorContactTypelD t 4 Write Access char 1 Read Access char 1 Current Status ID mt 4 LRecord ID P mt J4 5 For the administrator, user role positions can be defined to enable entire processing teams and team members to be specified In order to administer transactional activity associated with specific bid types and for specific locations. Referring now to FIGs. 13A-13B, exemplary steps for implementing an administrative processing team are shown. Initially, an administrative user table 10 for the administrator is established containing administrative user master data (step 1300). From the user table, various users can be assigned to one or more user groups and the mapping of users to user groups can be stored in a user group mapping table (step 1305). The user groups can be associated with business units within a company or transaction types or both. For each of the user 15 groups, the functional rights and responsibilities of each user within the user group can be defined in a user group rights table (step 1310). For example, each user can be assigned access rights (as discussed above in connection with FIG. 10) for the user group. Examples of data structures implementing user groups and user group rights for the administrator are shown in Tables 14-19 hereinbelow.
42 However, it should be understood that other administrator user role configurations can be included, and the system is not limited to the specific administrator user role configurations listed in Tables 14-19. 5 TABLE 14 Exemplary Administrative User Table Column Name Data Type Length_ Administrative ID mnt 4 m LastName varchar 50 mFirstName varchar 50 Middle Initial varchar 50 Job Title ID mnt 4 mloginName varchar 10 mPassword varchar -10 Permission varchar 50 Phone varchar 50 Fax varchar 50 mEmail varchar 50 Home Addressl varchar 50 Home Address2 varchar 50 city varchar 50 State varchar 50 Zip varchar 20 Home Phone varchar 50 Mobile Phone varchar 50 Location ID mnt 4 Date of Birth smalldatetime 4 Social SecuriiyN No varchar 20 Date Start with Administrator smalldatetime 4 Date Start with Buyer smalldatetime 4 Schooling-ID mnt 4 Column Name Data Type Length Technical Certifications varchar j 50 Primary Language ID mnt 4 Secondary [anguage ID int 4 MS Excel Proficiency int 4 43 MS Access Proficiency int 4 MS Word Proficiency int 4 MS PowerPoint Proficiency int 4 Application Efficiency int | 4 Communication Skills ID int 4 mActive char 1 Supervisor int 4 Last Eval Date smalldatetime 4 Next Eval Date smalldatetime 4 Employee Type ID int4 TABLE 15 Exemplary Administrative User Group Table Values 5 Admin User Group ID Admin User Group Name 1 General Administration 2 Business Support 3 Customer Service 4 RequisitionTransactionProces sors 5 Staff Management 6 Staff Professional 7 Supplier Management 8 Systems Admin 9 Application Support 10 Financial Processors 12 RFX Transaction Processors 10 44 TABLE 16 Exemplary Administrative User to User Group Mapping Table Column Name Data Type Length Administrative ID Int 4 User Group ID Int 4 Record ID int 4 Date Created datetime 8 Creator ID nt 4 Current Status ID int 4 Last Edit Date datetime 8 Last Edited By int 4 5 TABLE 17 Exemplary Administrative User Group Rights Table Column Name Data Tye Length ASP Page ID int 4 User Group ID int 4 Record ID int 4 Read Access char Write Access char 1 Once the user groups have been ascertained, as shown in FIG. 13B, 10 processing teams can be created within the user groups to handle specific transaction types (step 1315). All of the users within a particular user group can be mapped to specific processing teams and assigned a routing order for the particular transaction type (step 1320). Exemplary data structures for creating and mapping users to processing teams are shown in Tables 18 and 19 hereinbelow.
45 TABLE 18 Exemplary Administrative Processing Teams Table Column Name Data Type Length Team ID int 4 Team Name varchar 50 Staff Supplementation char 1 Project Work char 1 RFX Processing char 1 Requisition Processing char 1 Invoice Processing Char I HelpDesk Processing Char 1 Quality Assurance Processing Char 1 Created By Int 4 Last EditedBy Int 4 Last Edit Date Datetime 8 Current Status ID Int 4 TABLE 19 Exemplary Administrative Processing Teams to User Mapping Table Column Name Data Type Length Administrative ID Int 4 Team ID int 4 Date Created datetime 8 Record ID int 4 Created By int 4 Current Status ID int 4 Last Edited By int 4 Last Edit Date datetime 8 10 46 In addition, processing teams can be mapped to specific geographic regions, so that different processing teams can handle the same type of transaction in different regions (step 1325). Therefore, when a particular type of transaction is conducted in a particular location, the system can manage the 5 workflow to the appropriate users based on the transaction type and location (step 1330). For example, the appropriate users can be notified of the transaction via an e-mail and/or dashboard update. Thus, the user role management supported by the system of the present invention provides a flexible, scalable and robust work-sharing environment for the 10 entire bid/project process from bid creation to project completion. In addition, the system enables secure communications and transaction processing based upon user roles, which enables users to interface with the correct personnel at the right times while insuring that data view and access rights are limited to those users that have a functional need for the access. 15 BID ACTIVITY After the pre-bid activity is completed, a buyer can create and transmit a bid request to one or more vendors to solicit a bid response from the vendors for a particular project. To facilitate the bid process in the context of a complete 20 bid/project process, bid templates can be used for specific project types to solicit the requisite information from vendors for the specific project type in a uniform and 47 comprehensive manner to enable efficient and effective evaluation of bid responses. Exemplary functionality for creating a bid request utilizing a bid template is shown in FIG. 15. A bid template creation tool 180 and bid request creation tool 5 185 are illustrated in FIG. 15 for the creation of bid templates 240 and bid requests 200 from the bid templates 240, respectively, in accordance with embodiments of the present invention. The bid template creation tool 180 and bid request creation tool 185 can include any hardware, software and/or firmware required to perform the functions of the tools, and can be implemented within the web server 120 or an 10 additional server (not shown). Each buyer can create one or more bid templates 240, depending on the nature of project work outsourced by the buyer. For example, if the buyer has a need for staff supplementation in only one department, the buyer may create only one bid template 240 to handle the staff supplementation bid requests 200. 15 To create a bid template 240, the bid template creation tool 180 accesses the buyer database 155a to retrieve bid items 230 within a bid item list 194 and provides the buyer with the bid item list 230 via the buyer module 110, web server 120, data network 40 and buyer browser 20a for the buyer to choose from. The bid items 230 are associated with specific types of information to be solicited from 20 the buyer, vendor or both. From the list of bid items 230, the buyer selects and provides one or more bid item selections 235 for inclusion in a bid template 240. Depending on buyer configurations, one or more of the bid items 230 may be 48 mandatory for the bid template 240, such as the name of the buyer, location of the work to be performed and type of project work requested. For one or more of the mandatory bid items 230, in addition to including the mandatory bid items 230 in the bid template 240, the specific information associated with each of the 5 mandatory bid items 230 can also be included in fields associated with the mandatory bid items 230 within the bid template 240. For example, the buyer name and project work type can be stored in the bid template 240 for that project work type. Each bid template 240 created by the buyer is stored in the buyer database 155a within a bid template list 190 for later use in creating a bid request 10 200. To create a bid request 200, the bid request creation tool 185 accesses the buyer database 155a to retrieve the bid templates 240 stored within the bid template list 190 and provides a list of bid templates 240 to the buyer via the buyer module 110, web server 120, data network 40 and buyer browser 20a for the 15 buyer to choose from. Upon selecting an appropriate bid template 240, the buyer provides bid request data 210 to the bid request creation tool 185 for inclusion in a bid request 200 of the bid template 240 type. For example, the buyer can enter bid request data 210 into provided fields for each bid item selection 235 that requires information from the buyer within the bid template 240. By way of 20 example, but not limitation, the bid request data 210 could include the location of work to be performed, the timing of the project and the specific vendor qualifications necessary for the project.
49 The bid request creation tool 185 further interfaces with the buyer database 1 55a to access the vendor list 158 for the buyer and determine the appropriate vendors to receive the bid request. The appropriate vendors can be selected based on the bid template 240 type and any other vendor qualifications included 5 within the bid request 200 itself. Thus, the vendor list 158 can be separated into pre-qualified vendors for bid template 240 types to further reduce processing time when submitting bid requests 200. The bid request creation tool 185 further uses vendor contact information 250 associated with the selected vendors to broadcast (transmit) the bid request 200 to the appropriate vendors (as shown in FIGs. 1 and 10 2) via the vendor module 115, web server 120, data network 40 and vendor browser 20b, and stores the submitted bid request 200 in a bid request list 196 for the buyer. Vendor bid responses 220 received from solicited vendors (as shown in FIGs. 1 and 2) can further be stored in the buyer database 155a in a bid response 15 list 198 for later use in comparing and grading vendor bid responses 220. The vendor bid responses 220 are generated from the bid items included in the bid request 200. Specifically, the vendor populates data associated with the vendor and the bid response in data fields within enabled bid items in the bid request 200. Vendors access the bid request 200 via the vendor module 115 to view the bid 20 request and complete the vendor response and submit completed bid responses 220 via the vendor module 115 for storage in the buyer database 155a via the buyer module 110 (step not shown). The bid response 220 can include data retrieved from a vendor database 1 15b (not shown) and can be stored in the vendor database 155b during and after the bid response creation. Exemplary steps for creating a bid template, a bid request from the bid template and a bid response from the bid request from various system 5 perspectives are shown in FIGs. 16A-1 6D. The main processing steps performed at the system for bid template creation are shown in FIG. 16A. The system creates a bid template by providing a buyer user a list of predetermined bid items (step 1600). In response thereto, the system receives one or more bid item selections from the bid item list for inclusion within a bid template stored within the 10 system (step 1610). To create a bid request from the bid template, the system communicates the bid item selections within the bid template to the buyer user for generation of the bid request using the bid item selections (step 1620). In FIG. 16B, at the buyer side, upon receipt of the bid item list, to create the bid template, the buyer user selects one or more bid items to be included in the bid 15 template (step 1630). For subsequent generation of a bid request, the buyer user receives the bid template including the bid item selections (step 1635) and enters bid request data into fields associated with the bid item selections in the bid template to create the bid request (step 1640). After all applicable bid item selection fields have been completed by the buyer user, the bid request is 20 transmitted to the system for broadcasting to qualified vendors (step 1645). The main processing steps performed by the system for bid request generation and broadcasting are shown in FIG. 1 6C. After the creation of a bid 51 template and the storage of the bid item selections for the bid template (step 1650), the system generates a bid request using bid request data entered by the buyer user for the bid request of the bid template type (step 1660). Thereafter, the system transmits the generated bid request to qualified vendors for solicitation of a 5 bid response of the bid template type (step 1670). In FIG. 16D, at the vendor side, the vendor receives the bid request including the enabled bid item selections selected by the buyer (step 1680). To create a bid response, a vendor user enters bid response data into fields associated with the bid item selections included in the bid request (step 1685) to 10 create the bid response. After all applicable bid item selection fields have been completed by the vendor user, the bid response is transmitted to the system for forwarding to the buyer (step 1690). Examples of data structures used for creating the bid templates are shown in Tables 20-25 hereinbelow. The data structures are illustrated for simplicity as 15 being organized in a table format, with each table including all of the fields necessary for displaying bid items to the buyer user to select from and storing bid item selections for bid templates. The tables are related in a hierarchical and relational manner, as will be described hereinbelow in connection with FIG. 17. However, it should be understood that other bid template configurations can be 20 included, and the system is not limited to the specific bid template configuration shown in Tables 20-25 and FIG. 17.
52 TABLE 20 Base Bid Items Section Table (tblRFXBidSections) Column Name Data Type Length RFX Section ID int 4 RFX Section Varchar 255 ASP Section Display Order Numeric 9 Label Comments Varchar 1000 TABLE 21 5 Base Bid Items Category Table (tbiRFXBidCategories) Column Name Data Type Length RFX CategoryID Int 4 RFX Category Varchar 255 RFX Section ID Int 4 ASP Category Display Order Numeric 9 Label Comments Varchar 1000 TABLE 22 Base Bid Items Table (tblRFXBidltems) Column Name Data Type Length RFX Item ID Int 4 RFX Item Varchar 255 Disablement Allowed Char 1 Supplier Bid Display Char 1 Supplier Response Item Char I RFX Category ID Int 4 HM Data Type Varchar 255 HM Fleld Length Varchar 255 ASP Item Display Order Numeric 9 [AV Response Data Type Varchar 255 [AV Field Length Varchar 255 10 53 TABLE 23 Base Bid Template Type Table (tblRFXBidTemplates) RFX Template ID RFX Template 1 Project RFP 2 Project RFQ 3 Bulk Staffin RFQ 4 Regular Staff Supplementation TABLE 24 5 Base Bid Template To Bid Items Mapping Table (tblFRXTemplateltemMatrix) Column Name Data Type Length RFX Item ID Int 4 RFX Template ID int 4 TABLE 25 Base Client Bid Item Default Values Table (tblRFXBidltemsCDV) 10 Column Name Data Type Length RFX Item ID int 4 Client Default Value varchar 7500 Referring now to FIG. 17, a database table structure 400 illustrating the interrelation between each of the above Tables 20-25 is shown. The bid items 230 are shown organized into bid sections and bid categories for convenience and 15 logical business information processing segmentation when creating the bid templates 240. Thus, the buyer user is presented with bid sections 250, from 54 which the buyer user can select a bid category 255 to display the bid items 230 associated with that bid category 255. Breaking the bid items 230 down into bid categories 255 and bid sections 250 fosters a compartmentalized format that is easily understood by the buyer user, thereby enabling a more efficient and 5 effective bid template creation process. The table "tblRFXBidSections" 401, which has the form of Table 20 above, includes the bid section name and identification of each section 250 of bid items 230, along with an indication of the display order for each bid section 250 on a web page and any comments to be included with the bid section 250 on the web 10 page. Each bid section 250 can be stored as a separate record in table "tblRFXBidSections" 401, with each record having the form of Table 20. Within each bid section 250 are one or more bid categories 255. The table "tblRFXBidCategories" 402, which has the form of Table 21 above, includes the category name, the identification number of each bid category 255 and the 15 associated bid section 250 for each bid category 255. In addition, the table "tbIRFXBidCategories" 402 further includes the display order for each bid category 255 on a web page and any comments to be included with the bid category 255 on the web page. Each bid category 255 can be stored as a separate record in table "tbIRFXBidCategories" 402, with each record having the form of Table 21. 20 Each bid category 255 further includes one or more bid items 230 associated with the bid category 255. Therefore, the table "tblRFXBidItems" 403, which has the form of Table 22 above, includes the bid item name and 55 identification number, along with the bid category 255 associated with the bid item 230. A separate record for each bid item 230 can be stored in table "tblRFXBiditems" 403, with each record having the form of Table 22 above. The table 'tblRFXBidItems" 403 further includes additional information pertaining to the 5 bid item 230, such as whether or not disablement of the bid item 230 is allowed, whether the bid item 230 is displayed to the vendor, whether the bid item 230 requires a vendor response, the type of data entered by the buyer for the bid item 230, the field length for the data entered by the buyer for the bid item 230, the type of data entered by the vendor for the bid item 230 and the field length for the data 10 entered by the vendor for the bid item 230. For example, the following Table 26 illustrates sample bid items 230 in the table "tblRFXBidItem" 403 making up a bid item list 194, as shown in FIG. 15.
56 TABLE 26 RFX_it RFX Item Disable Vend Vendo RFX HM Data HM Fie item Di AV R AV Fi emiD ment All or Bi rRes Cat Type Id_Len splay espo old_Le owed d_Dis ponse egor gth Order nse ngth play _Item yID Data Type 1 Company/Organizat N Y N 1 LongTe 5000 5 I ion Information I xt 1 1 2 Purpose_of theRF N Y N 2 LongTe 5000 5 P xt 3 BusinessStrategy/ N Y N 3 LongTe 5000 5 Objectives xt 4 BusinessInfrastruc Y Y N 4 LongTe 5000 5 ture xt 5 BusinessProceses Y Y N 4 LongTe 5000 10 xt 6 BusinessSystems Y Y N 4 LongTe 5000 15 xt 7 Internal/ExternalCl Y Y N 4 LongTe 5000 20 ients xt 8 AffectedDepartme Y Y N 4 LongTe 5000 25 nts xt 9 Project Ownership/ N Y N 5 LongTe 5000 5 Management Consi xt derations 10 ProductOwnership N Y N 5 LongTe 5000 10 /LicensingConside xt rations 11 ProjectWorkLoca N Y N 5 LongTe 5000 15 tion Considerations xt 12 Project PhasingC Y Y N 5 LongTe 5000 20 onsdierations xt HM Hyperlin kto Sub Table 13 ProjectPhasingS Y Y N 5 ASP 25 chedule 14 Project Resource_ Y Y N 5 1 Long 5000 30 Considerations Text HM Hyperlin k to Sub i Table 15 HMStaffing Re N Y N 5 ASP 35 source Profiles I 57 16 Resource Backfill_ N Y IN 5 Text 1000 40 Considerations/Req uirements 17 ProjectResource N Y N 5 Text 1000 45 TravelConsideratio ns 18 HandlingOf Projec N Y N 5 LongTe 5000 50 t_Resource Expen xt ses Considerations 19 Regulatory/Industry Y Y N 5 LongTe 5000 55 _StandardsCompli xt ance_Consideration S RFX I RFX Item Disable Vend Vend RFX HMDat HM_Fi ItemD AV AVFi temI mentA orB orRe _Ca aType eld_Le isplay_ Resp eldL D Ilowed id_DI spons teg ngth Order onse length spia e-lte ory _Dat y m _ID aTy pe 20 Specific Equipment Y Y N 5 LongTe 5000 60 froolingConsiderat xt ions 21 Specific Economic Y Y N 5 LongTe 5000 5 Considerations xt 22 StatementOfWor N Y N 6 LongTe 5000 5 k xt 23 Non-Deliverable_ N Y N 7 LongTe 5000 5 Penalties x1 24 SupplierIncentive Y Y N 8 LongTe 5000 5 Bonus xt 25 StatementofConfi N Y N 9 LongTe 5000 5 dentiality xt 26 RFPOrganization/ Y Y N 10 LongTe 5000 5 Contacts xt 27 RFP ResponseRe N Y N 11 LongTe 5000 5 quirements xt 28 RFP Supplier Issu N Y N 12 date 5 dance Date time 29 SupplierAcknowle N Y N 12 date 10 dgment_ofConfide time ntiality Date 30 SupplierAcknowle Y Y N 12 date 15 dgment-ofRespon time se Intent Date 31 Supplier Submissio Y Y N 12 date 20 n_of_RFX_Questio time ns Date - I 32 ClientPostingof Y Y N 12 date 25 Answers Date i time 33 Supplier Submiss N Y N 12 date 30 58 ion_of_Completed time RFP_Response Date -- - --- 34 ClientSubmissio Y Y N 12 date 35 n ofRFP Respo time nse_QuestionsD ate 35 SupplierPosting- Y Y N 12 date 40 of Answers Date time 36 ClientRFXEva N Y N 12 date 45 uation_Completlo time n Date 37 Client Disposition N Y N 12 date 50 _to_SuppliersDa time __ _ te 38 RFX Instructions N Y N 13 LongTe 5000 5 39 Companyistory Y y Y 14 Text 1000 5 Long 5000 40 CompetitiveAnal Y Y Y 14 Text 1000 10 Long 5000 i iText 41 Product/Services_ . y Y 14 Text 1000 15 Long 5000 Heritage Review Tx 42 product/ServceS _ y y Y 14 Text 1000 20 Long 5000 Strategy xt REX_ REXjtem Disabi Ven Vend RF HM_Da HM_FI Item AV_ AV_F Item ement dor orR XR taTyp eldL Displa Res ield_ ID Allowe Bid espo Cat e ength yOrd pon Leng d Disp nseI ego er sea th lay tem ryl Data D -Ty 43 TechnologyVisio y Y Y 14 Text 1000 25 Long 5000 ____n ___ Text 44 Strategic_Technol Y y Y 14 Text 1000 30 AV ogyPartners Hyp erlin kto Sub Tab[ e ASP 45 TrackRecord Y y Y 14 Text 1000 35 AV Hyp erlin k to _ 59 Sub Tabl e ASP 46 Project Managem Y Y Y 14 Text 1000 40 Long 5000 ent Philosophy Text 1 47 PMICertified FT Y Y Y 14 Text 1000 45 Long 5000 Es ~ ~ Text 48 Customer Referenc Y Y Y 14 Text 1000 50 AV es Hype rlink to Sub Table ASP 49 ProposalNarrativ N Y Y 15 Text 1000 5 Long 5000 e ~ Text 50 ProjectPlanning/ N Y Y 15 Text 1000 10 Long 5000 Strategy Text 51 ProjectPhasing N Y Y 15 Text 1000 15 AV Hyp erlin k to Sub Tab[ e ASP 52 Resource-Model N Y Y 15 Text 1000 20 AV Hyp erlin k to Sub Tabl e ASP 53 Knowledge Trans Y Y Y 15 Text 1000 25 Long 5000 fer Plan Text 54 Deployment Plan N Y Y 15 Text 1000 30 Long 5000 - ___Text RFX Item ID RFX Item Disableme Vendor_ Vend RFX HM Dat HM Fi Item_ AV AV ntAllowed Bid Disp orRe Cat aType oldLe Displa _R _Fi lay spon egor ngth y_Ord esp eld sejte y_1D er on _Le m se_ ngt Dat h aT CN 15 Text 01000 35 Lon 50 60 cceptance_ 9 0 Model Tex t 56 ResourceL N Y Y 16 Text 1000 5 AV aborPricing Hy pearl ink to Su b Tab le AS P 57 ResourceL N Y Y 16 Text 1000 10 Cur aborPricing ren Amount cy 58 Equipment/ N Y Y 16 Text 1000 15 Lon 50C Tooling Pric g 0 ingConme Tex nts t 59 EquipmenV N Y Y 16 Text 1000 20 Cur Tooling_Pric ren - ing Amount cy 60 PhysicalSit N Y Y 16 Text 1000 25 Lon 50C e Pricing C g 0 omments Tex t 61 PhysicalSit N Y Y 16 Currenc 30 Cur ePricingA y ren mount I cy 62 Project-Man N Y Y 16 Text 1000 35 Lon 50C agementPr g 0 emiumCo Tex mments t 63 Project Man N Y Y 16 Currenc 40 Cur agement_Pr y ren emiumAro cy unt 64 Intellectual N Y Y 16 Text 1000 45 Lon SO( PropertyPr 9 0 emium Co Tex mments t 65 Intellectua N Y Y 16 Curren 50 Cu IProperty cy rre -Premium nc Amount Y 66 Miscellaneo N Y Y 16 Text 1000 55 Lon 501( us Project g l I Expenses I Tex 61 Comments t 67 Miscellaneo N Y Y 16 Text 60 Cur usProject_ ren ExpensesA Cy mount 68 Anticipated_ N Y Y 16 Text 1000 65 Cur Margin ren 69 TotalBidP N Y Y 16 Text 1000 70 Cur rice ren 70 Resource-T N Y Y 17 Text 1000 5 Lon 500 ravel Expan 9 0 ses Comm e Tex nts~ t 71 Resource U N Y Y 17 Text 1000 10 Lon 500 vingExpen g 0 ses Comme Tex nts~ t 72 Resource P N Y Y 17 Text 1000 15 Lon 500 er Diem Co g 0 moments Tex t 73 Resource_ N Y Y 17 Text 1000 20 Lon 500 MileageEx g 0 penseCorn Tex ments t RFX RFXItem Disable Vend Vend RFX HM Dat HM_Fi ItemD AV_ AV Ite mentA orB orRe _Ca a_Type eldLe isplay_ Resp Fiel m I Ilowed idDi spons tag ngth Order onse d_L D spla ejite ory _Dat eng y m _ID aTy th Pe 74 Reimbersable Mi N Y Y 17 Text 1000 25 Long 500 scellaneousExp Text 0 ense Comments 75 Capital RiskMo N Y Y 18 Long 5000 5 Long 500 del Comments Text -1 Text 0 76 Capital_Risk_Mo N Y Y 18 10 Curre del Amount ncy 77 RebateModelfo N Y Y 19 5 Long 500 rnon- Text 0 deployedinvest ment 78 SupplierPaymen N y Y 20 Text 1000 5 Long 500 t Release_Sched Text 0 ule 79 Notes toMSP Y N N 21 Long 5000 5 Text 80 Notes to Supplie Y Y N 22 Long 5000 5 | 62 r Text 81 ProjectPhasing_ N Y Y 15 16 Char I Acceptance 82 StatementOfW N Y Y 15 11 Char 1 ork Acceptance 83 StatementOfW N Y Y 15 12 Long 500 orkProposedC Text 0 hanges 84 Non-Deliverable_ Y Y Y 15 40 Char 1 PenaltiesAccept ance 85 Non-Deliverable_ Y Y Y 15 Long 5000 45 Long 500 Penalties Propos Text Text 0 ed Changes 86 Customer Accep Y Y Y 15 36 Char 1 tance ModelAgr cement 87 CustomerAccep Y Y Y 15 Long 5000 37 Long 500 tanceModelPro Text Text 0 posed Changes 88 Preferred Custo Y Y N 6 Long 5000 6 Long 500 merAcceptance Text Text 0 Model 89 AgreeToConfid N Y Y 14 Text 1000 1 Char I entiality Terms 90 IntentToRespo N Y Y 14 Text 1000 2 Char 1 nd 91 Materials-List Y Y Y 16 Text 1000 16 AV Hype rink to Sub Table ASP 92 MaterialsCost Y Y Y 16 Text 1000 17 Curre ._ ncy 93 DesiredAssignm N Y N 12 date 51 ent Start Date time 94 DesiredAssignm N Y N 12 date 52 ent End Date time Referring again to FIG. 17, each of the bid items 230 can be disabled or enabled for a particular bid template 240, depending on the type of project work 5 that the bid template 240 is created for. However, as discussed above in 63 connection with FIG. 15, there may be some bid items 230 that are required to be included in one or more bid template 240 types. Therefore, for the required bid items 230, disablement is not allowed. If an entire bid section 250 or bid category 255 is not applicable to a particular bid template 240, the database table structure 5 400 can be configured to allow the bid items 230 within entire bid sections 250 or bid categories 255 to be disabled, if all of the bid items 230 within that bid section 250 or bid category 255 can be disabled. Once all of the bid items 230 have been disabled or enabled (bid item selections 235 are enabled bid items) for a particular bid template 240, the bid 10 template 240 and associated bid item selections 235 can be stored in the database table structure 400. The table "tblRFXBidTemplates" 405, which has the form of Table 23 above, includes the bid template name and bid template identification number for use in associating bid item selections 235 with the bid template 240 in the table "tblRFXTemplateltemMatrix" 404, which has the form of 15 Table 24 above. A separate record for each bid template 240 can be stored in table "tblRFXBidTemplates" 405, with each record having the from of Table 23. In addition, a separate record for each bid item selection 235 included within a particular bid template 240 can be stored in table "tblfRFXTemplateltemMatrix" 404, with each record having the form of Table 24. 20 If there are specific bid items 230 that have a default value applicable to all bid templates 240, such as the buyer name, the default value for that particular bid item 230 can be stored in the table "tblRFXBiditemsCDV" 406, which has the form 64 of Table 25. A separate record for each default value associated with each bid item 230 can be stored in table "tbIRFXBidltemsCDV" 406, with each record having the form of Table 25. By providing selectable bid items in a structured, configurable and scalable format, any bid item 230 can be added or removed at 5 any time depending on the specific needs of the buyer. Exemplary steps for creating a bid template using the hierarchical and relational database table structure are illustrated in FIG. 18. To create a bid template, a buyer user enters a name for the template to create a record for the template in the database table structure (step 1800). Thereafter, the buyer user 10 selects a particular bid section from a list of bid sections (steps 1805 and 1810) and a particular bid category from a list of bid categories (steps 1815 and 1820) to begin the process of selecting bid items for inclusion in the bid template (step 1825). If one or more of the bid items in the selected bid category are required 15 (step 1830), the required bid selections are automatically included in the bid template (step 1835). Other bid items are selected based on the needs of the buyer user for the particular type of bid template (step 1840). This process is repeated for each bid category within the selected bid section (step 1845) and for each bid section within the list of bid sections (step 1850), until all bid items have 20 been reviewed and either enabled (selected) or disabled for the bid template. As discussed above, in other embodiments, all bid items within a bid section or bid category may be able to be disabled without individual bid item review if 55 disablement of all of those bid items is allowed. Once the bid item selections have been made for the bid template, the bid template is stored in the bid template list (step 1855) for later use in creating a bid request. A screen shot of an exemplary web page for creating a bid template is 5 shown in FIG. 19. Using one or more web pages (only one of which is shown), the buyer user can enter the bid template name 240, select a bid section 250 and select a bid category 255 to display specific bid items 230 within the bid category 255 that may be included in the bid template 240. For each bid item 230 within a displayed bid category 255, the buyer user can select to either enable or disable 10 that bid item 230. However, if a particular bid item 230 cannot be disabled, the disable button is ghosted to prevent the buyer user from disabling the bid item 230. In addition, if the option is available, the buyer user may also be allowed to disable all bid items 230 within a particular bid section 250 or bid category 255 by clicking on a disable button next to the bid section 250 or bid category 255 15 currently displayed. Once all of the bid items 230 have been enabled or disabled for the bid template 240, the buyer user can save the bid template 240. In some embodiments, the buyer user may be able to temporarily save the bid template 240 if all bid items selections 235 have not yet been completed. In other embodiments, the save button is ghosted until all bid items 230 have been 20 enabled or disabled. FIG. 20 illustrates exemplary steps for creating a bid request from a bid template, as shown in FIG. 15, using bid items organized in a hierarchical and 66 relational format, as shown in FIG. 17. initially, a bid template is selected by a buyer user from the bid template list for the bid request (step 2000). It should be understood that the bid template can be created immediately prior to generation of the bid request or the bid template can be created well in advance of the bid 5 request. After the particular bid template for the bid request is selected, the buyer user enters a bid request identifier for the bid request (step 2005), such as a bid request name or number. In addition, the system will assign a bid tracking number to refer to the bid as it applies throughout the system to the vendor, buyer, contractor and administrator. 10 All of the bid item selections in the bid template are displayed by bid section and bid category to the buyer user for review (step 2010). If one or more of the bid item selections in the bid template are not applicable to the particular bid request (step 2015), and the undesired bid item selections can be disabled (step 2020), the buyer user can disable those bid item selections that are not needed for the 15 particular bid request (step 2025). Thereafter, the buyer user enters the requisite bid request data into appropriate fields for the bid item selections enabled in the bid request (step 2030). For example, one or more bid item selections may contain a field for the buyer to enter data, such as the location of the work to be performed or the type of project work. These fields can be variable type data 20 fields, such as text-entry fields or selectable options fields with links to other web pages containing the selectable option.
87 An example of a selectable option field that may be displayed involves the selection of a particular type of project work for the bid request from a number of pre-established project types. To implement the project type selection process, a configurable and scalable database structure can be provided that enables the 5 buyer's specific project work business requirements to be classified in a non-prose fashion. By selecting from pre-established project work types, the buyer can ensure that vendor bid responses are synchronous with the buyer's project work requirements. The project work types can also be selected by the vendor when completing vendor qualification data (shown in FIG. 2) for selecting of vendors to 10 receive the bid request. Examples of data structures used for selecting the project work type are shown in Tables 27-29 hereinbelow. The data structures are illustrated for simplicity as being organized in a table format, with each table including all of the fields necessary for displaying the project work types to the buyer user to select from and storing the selected project work type within the field 15 of the associated bid item selection of the bid request. The tables are related in a hierarchical and relational manner, such that the tables are accessed in a particular order for displaying the project work types to the buyer user. Table 27 below illustrates sample project services types, such as consulting, staff supplementation and other project services. Within each of the 20 project services types may be one or more project sectors, as shown in Table 28, and within each of the project sectors may be one or more project families, as shown in Table 29. Therefore, to select a particular project work type (project 88 family) for the bid request, the buyer user can select a project services type and project sector type to display a list of project families to select from. It should be understood that other configurations and project types can be included and the system is not limited to the specific configurations and information listed in Tables 5 27-29.
69 TABLE 27 Project Services Type Table Project Work Type Name Services Type ID ASP Display Order Consulting 1 2 Staff Supplementation 2 3 Project Services 3 1 TABLE 28 5 Project Sector Type Table ProjectSectionID ProjectSectorName ASPDisplay_Order Project_ServicesI D 1 Consulting/Professional 2 1 Services 2 Engfneering/Constructlon 3 1 3 Technology 1 1 TABLE 29 Project Family Type Table ProjectFamil ProjectFamilyName ASPDisplay ProjectSecto y ID Order rID 7 Enterprise Resource Solutions 5 3 8 E-Business Solutions 10 3 9 Telecommunications Solutions 15 3 10 Technical Integration Solutions 15 3 11 Network Management Solutions 25 3 12 CustomSoftwareDevelopment/ 30 3 Engineering 13 BusinessStrategy/PlanningSol 5 1 utions 14 Human Resource Solutions 10 1 15 Audit/Assurance Solutions | 15 1 16 Financial Advisory Solutions | 20 1 17 Tax Solutions | 25 1 18 Risk Management Solutions j 30 1 70 19 Real Estate Services 35 1 20 Legal Services 40 1 21 Engineering Services 5 2 22 Building/Construction Services 10 2 23 Product Development 15 2 Referring again to FIG. 20, once the buyer user has entered the bid request data into all of the required bid item fields (step 2035), the bid request is complete. It should be understood that not all of the bid item fields require the user to enter 5 bid request data. For example, one or more of the bid item selections may be a vendor bid response bid item selection that only the vendor responds to. For the vendor bid response bid item selections, the buyer user can enable or disable that bid item selection, and does not enter any data into the field for that bid item selection except data that may assist the vendor in completing the bid response 10 for that bid item. For bid request completeness, every enabled bid item selection where the buyer user can enter bid request data is preferably filled out by the buyer user before the bid request is submitted. In many companies, bid requests must be approved prior to transmission to vendors. Therefore, if the bid request requires approval (step 2040), the originator 15 of the bid request submits the bid request to the appropriate approvers (step 2045). In exemplary embodiments, as discussed above in connection with FIGs. 9-14, the approval user role positions are pre-designated for all bid requests or for the particular bid request, so that the bid request is automatically routed to the appropriate approver. If the bid request is approved (step 2050), the originator is 71 informed of the bid request approval (step 2055), and the bid request is transmitted to qualified vendors (step 2060). However, if the bid request is not approved (step 2050), the originator is notified of the bid request declination (step 2065), and provided the opportunity to edit the bid request (step 2070), if possible. 5 For example, the originator may have disabled one or more bid item selections that need to be included in the bid request for approval purposes, or left blank one or more buyer-required data fields. If approval of the bid request is not required (step 2040), the bid request is transmitted to the qualified vendors for the bid request (step 2060). 10 FIGs. 21 and 22 are screen shots of exemplary web pages that can be provided to the buyer user for bid request creation. Using one or more web pages, the buyer user can enter the bid request name 200, select a bid section 250 and select a bid category 255 to display specific bid item selections 230 within the bid category 255 that may be included in the bid request 200. FIG. 21 shows an 15 overview of the status of the bid request 200 listing the number of bid item selections 235 in each section 250 and the number of bid item selections 235 in each section 250 that are completed or disabled. To complete or disable a bid item selection 235, the buyer user can click on the bid section 250 to display the bid categories 255 and bid item selections 235 within each of the bid categories 20 255. Once all of the bid item selections 235 have been completed or disabled, the buyer user can click on a submit completed bid request button for approval and/or transmission to qualified vendors.
72 As shown in FIG. 22, each bid item selection 235 in each bid category 255 within each bid section 250 can be reviewed to determine whether or not the bid item selection 235 should be disabled. Some of the bid item selections 235 in one or more of the categories 255 may also require bid request data 210 from the 5 buyer user. For each bid item selection 235 within a bid category 255, the buyer user can either enable or disable that bid item selection 235. However, if a particular bid item selection 235 cannot be disabled, the disable button is ghosted to prevent the buyer user from disabling the bid item selection 235. In addition, if the option is available, the buyer user may also be allowed to disable all bid item 10 selections 235 within a particular bid section 250 or bid category 255. If a bid item selection 235 is enabled and has a field 238 for entering bid request data 210, the buyer user can enter bid request data 210 into the associated data field 238. In addition, if the bid template contains default bid request data 210 for a particular bid item selection 235, the default data 210 can be displayed in the data field 238 15 and may or may not be allowed to be changed, depending on the template settings. FIG. 23 illustrates exemplary steps for reviewing and transmitting bid requests to qualified vendors, as shown in FIG. 15. The originator of the bid request can select appropriate qualified vendors from the vendor list based on bid 20 template type and entered bid request data or the bid request can be submitted to a project administrator to choose the qualified vendors, depending on buyer constraints. If the latter, the new bid requests can be displayed to an 73 administrative user (step 2300) to select the desired bid request for review and transmission (step 2305). During the review process, the administrative user may be allowed to edit the bid request for quality control purposes or may request the originator of the bid request to edit the bid request, if significant changes are 5 necessary (step 2310). Once the bid request is in a completed form, the administrative user accesses the vendor list (step 2315) to determine qualified vendors for the bid request based on the bid template type and entered bid request data (step 2320) (e.g., based on the project family in conjunction with the anticipated geographic 10 work location). If the list of qualified vendors is insufficient (step 2325), the administrative user may also query the top-level database (as shown in FIG. 6) for additional matching vendors to add to the qualified vendor list (step 2330). In addition to or instead of supplementing the qualified vendor list with matching vendors from the top-level database, the administrative user may also be provided 15 the option to include vendors that do notcompletely match all ofo the bid request data (steps 2335 and 2340). A screen shot of an exemplary web page displaying all of the potential vendors to be selected from to include on the qualified vendor list is shown in FIG. 24. The administrative user can select from buyer-contracted vendors that match 20 the bid request data, buyer-contracted vendors that do not completely match the bid request data and non-contracted vendors that match the bid request data provided by the top-level database. The administrative user can select vendors for 74 inclusion in the vendor qualification list based on any number of factors, including previous contract experience with the vendor, vendor reputation and vendor availability. Turning back to FIG. 23, once the list of qualified vendors is finalized (step 5 2345), the administrative user transmits the bid request to the qualified vendors (step 2350) and notifies the originator of the bid request of the bid request status (step 2355). For example, the originator can be notified of the particular vendors that received the bid request and any modifications made to the bid request prior to transmission. 10 Exemplary steps for generation and transmission of a vendor bid response, as shown generally in FIGs. 1 and 15 at 220, to a received bid request are shown in FIG. 25. In exemplary embodiments, bid requests are transmitted to vendors and routed to the appropriate vendor users, based on vendor user role configurations, as discussed above in connection with FIGs. 9-14. Upon receipt of 15 a bid request, an appropriate vendor user can access the bid request via a menu or dashboard control notification (step 2500). In further exemplary embodiments, the bid request is submitted with a bid confidentiality agreement binding the vendor user to maintain the contents of the bid request in confidence prior to displaying the bid request contents to the vendor user. If the vendor user 20 acknowledges the confidentiality agreement (e.g., by clicking on an accept button) (step 2505), the vendor user can gain access to the contents of the bid request (step 2515). Otherwise, the vendor user is notified that the bid contents will not be 75 accessible and the bid request is removed from the vendor user's view (step 2510). To limit the amount of time that vendors have to submit vendor bid responses, the bid request may also include a time frame that the vendor must 5 agree to respond within. If the vendor user cannot agree to respond within the time frame (e.g., by clicking on an accept button) (step 2520), the vendor user is notified that the contents of the bid request will no longer be available to the vendor user and the bid request is removed from the vendor user's view (step 2525). The buyer or project administrator is also notified of the vendors that do 10 not acknowledge the confidentiality agreement or time frame constraints, and based on the number of non-acknowledged vendors, the buyer or project administrator can add vendors to the qualified vendor list and transmit the bid request to the additional vendors to ensure that a sufficient number of vendor bid responses are received. 15 If the vendor user does agree to respond within the time frame (step 2520), the vendor is authorized to begin completion of the vendor bid response (step 2530). To respond to the bid request, the vendor user accesses the bid item selections by bid section and bid category that require vendor response data for review (step 2535). If the vendor user has any questions regarding the bid request 20 (e.g., the type or amount of vendor response data that is required) (step 2540), the vendor user can submit questions to the buyer for bid clarification within a buyer configured time frame (step 2545). An appropriate buyer user (e.g., the bid 78 request originator or project administrator) is notified of each question submitted by a vendor via e-mail and/or dashboard update (step 2550) and that buyer user is responsible for providing an answer to the submitted questions within applicable time constraints (step 2555). The vendors are notified of the buyer answers via e 5 mail and/or dashboard update (step 2560). For example, a bid message board can be provided by the system that both the vendors and the buyer can access for a particular bid request. A screen shot of an exemplary bid message board 600 is shown in FIG. 27. Only the buyer and the vendors responding to a particular bid request can access the bid message 10 board 600. All of the vendors may be provided access to all of the submitted questions and buyer answers, or only the vendor that submitted the question may be allowed to view the buyer answer, depending on the buyer settings. In addition, the vendor questions may be anonymous to the vendors and the buyer or only to the vendors, depending on the vendor and/or buyer preferences. 15 Turning back to FIG. 25, if the vendor user does not have any questions (step 2540) or all of the vendor questions have been answered (step 2560), the vendor user enters the requisite vendor response data into appropriate fields for the required bid item selections in the bid (step 2565). The vendor response data can include costing information including costing elements (e.g., resource 20 requirements, expense types, etc.) and associated pricing information (e.g., resource rates, expense amounts, etc.) and deliverables information including deliverables types (e.g., number of units to be completed, phasing information, 77 etc.) and completion information (e.g., project end date, phase end dates, etc.). Each of the costing elements and deliverables types is associated with a different bid item selection to enable effective comparison and grading of vendor bid responses. 5 The bid item fields can be of various data types, such as text/currency/numeric-entry fields and/or selectable options fields. In addition, the fields can have multiple levels of detail associated with a singular bid response item for different aspects of the project. For example, if a project has several phases, as determined by the buyer and/or vendor, the vendor response fields can 10 include a separate section for each phase of the project. Upon attempted submission of the vendor bid response, the system validates vendor completion of all necessary data fields for bid item selections in the vendor bid response (step 2570). If all required data fields are not completed (step 2575), the vendor user is provided a system message indicating the deficient vendor response bid item 15 selections, and is prompted to complete the required bid item selections prior to submitting the vendor bid response (step 2580). Once all required data fields for bid item selections are completed in a bid response (step 2575), the vendor (upon submission) is provided a message indicating that the vendor bid response has been submitted to the buyer or project administrator for review (step 2585) and the 20 appropriate buyer user is notified of a new vendor bid response via e-mail and/or dashboard update (step 2590).
78 FIGs. 26A and 26B are screen shots of exemplary web pages that can be provided to the vendor user for bid response generation. The vendor user is provided with web pages displaying the bid item selections within the bid request that require vendor response data. For example, as shown in FIG. 26A, the status 5 of the vendor bid response can be displayed to the vendor user listing the number of bid item selections 235 in each section 250, the number of bid item selections 235 in each section that the vendor user must complete and the number of bid item selections 235 in each section 250 that have been completed. In addition, the vendor user can access the bid message board to post vendor questions, view 10 the bid response in an on-line format that is easily readable or submit resumes of potential contractors to be included in the vendor bid response. Furthermore, once the vendor responses to all of the bid item selections 235 have been completed, the vendor user can click on the submit completed bid response button for approval and/or transmission to the buyer or project administrator. 15 To complete a vendor response to a bid item selection 235, as shown in FIG. 26B, the vendor user can click on the bid section 250 to display the bid categories 255 and bid item selections 235 within each of the bid categories 255. If a vendor response to a particular bid item selection is required, the vendor user can enter the vendor response data 215 into a data field 238 for the bid item 20 selection 235. As discussed above, the data field 238 can be a direct text-entry field or include links to other web pages for selection of the appropriate vendor response data 215 from pre-established vendor responses. In addition, the data 79 field 238 can have multiple levels, with links to web pages for each level. Furthermore, the data field 238 may be able to be directly populated from the vendor database with default vendor response data 215, such as vendor name and vendor address. For example, upon receipt of a bid request, the vendor 5 module can search for particular bid item selections 235 and populate the data fields 238 for those bid item selections 235 with the appropriate vendor response data 215. An example of vendor response data selected from pre-established vendor responses is shown in FIG. 28. If the bid request includes a bid item selection 10 requiring the vendor to provide resource requirement information for the project, along with, for example, the resource rates associated with the resource requirement information, the data field 238 can provide links to other web pages for selection of pre-established resource profile parameters. For example, each resource profile can indicate a particular resource type and associated skills 15 needed for the resource profile . To facilitate effective comparison of resource profiles and rates by the buyer, the vendor can select from a number pre established resource types and associated skills. To implement the resource type and skills selections, a configurable and scalable database structure can be provided that enables the vendor's specific resource requirements to be classified 20 in non-prose fashion. Examples of data structures used for selecting the resource type and associated skills are shown in Tables 30-37 hereinbelow. The data structures are 80 illustrated for simplicity as being organized in a table format, with each table including ai of the fields necessary for displaying the resource types and associated skills to the vendor user to select from and storing the selected resource profile within the data field of the associated bid item selection. The 5 tables are related in a hierarchical and relational manner, such that the tables are accessed in a particular order for displaying the resource types and associated skills to the vendor user, as will be described hereinbelow in connection with FIG. 29, which illustrates a database table structure 800 representing an exemplary data scheme associated with a complete vendor bid response the interrelation 10 between the vendor bid response and the buyer bid request. Table 30 below illustrates sample business sector categories, such as light industrial, management/professional, office and technical. Within each of the business sector categories are one or more business arenas, as shown in Table 31, and within each of the business arenas are one or more business families, as 15 shown in Table 32. Therefore, to select a particular business family associated with the resource type for the bid response, the vendor user can select a business sector category and business arena to display a list of business families to select from. Once the business family is selected, the various skills (general functions and business skills) associated with the resource type can be selected and 20 mapped to the particular resource type, as shown in Tables 33-37. For example, the general functions can identify the level of skill associated with the resource type, the skills category can identify the types of skills, training and experience that 81 the resource type possesses and one or more skills sets associated with each skills category can identify the specific experience associated with the resource type. In addition, certain skills sets can be emphasized over other skills sets by establishing a priority level for each of the skills sets of the resource type. It 5 should be understood that other resource type and skill selections can be provided, and the system is not limited to the particular configuration and information shown in Tables 30-37. For a more complete discussion of resource profiling, reference is made to co-pending and commonly assigned U.S. Patent Application Serial Number 10/128,751, which is hereby incorporate by reference in 10 its entirety herein. TABLE 30 Exemplary Business Sectors Table (tbIBusSector) Bus Sector Name Bus Section ID ASP Display Order Light Industrial 1 4 Mgmt/Professional 2 2 Office 3 3 Technical 4 1 15 82 TABLE 31 Exemplary Business Arenas Table (tbiBusArena) BusArenaID BusArenaName BusSectorID ASPDisplay Order 1 Administrative Support 3 5 2 Business Support 4 5 3 Communications Software 4 10 4 Controller 2 10 5 Enterprise Resource Appications 4 15 6 Finance 2 15 7 General Business Support 3 10 8 General Clerical 3 15 9 General Support 1 5 10 Human Resources 2 20 11 Legal 2 25 12 Logistics Support 1 10 13 Management information Systems 4 20 14 Manufacturinq 2 30 15 Materials Management 2 35 16 Network Engineerinq 4 25 17 Product Development 4 30 18 Production 1 15 21 Sales 2 40 22 Call Center 2 5 83 TABLE 32 Exemplary Business Families Table (tblBusFamily) BusFamily_ID BusFamilyName BusArenaID ASP Page Dis play 23 Maintenance 9 5 24 Driver/Courier 9 10 26 Shipping/Receiving 12 5 27 Oistribution 12 10 28 inventory Control 12 15 29 Light Assembly 18 5 30 Electronic Assembly 18 10 31 Quality Assurance/Control 18 15 32 Assets Management 4 5 33 Audit 4 10 34 Budgeting 4 15 35 Cost Center Accounting 4 20 36 Overheads 4 25 37 Product Costing 4 30 38 Profit Center Accounting 4 35 39 Profitability 4 40 40 Project Accounting 4 45 41 Taxaction 4 50 42 TreasuryCash Management 4 55 43 Accounts Payable 6 5 44 Accounts Receivable 6 10 45 Capital Investment 6 15 46 Consolidation 6 20 47 Credit/Collections 6 25 48 General Ledger 6 30 49 Other Ledgers 6 35 50 Benefits 10 5 51 Payroll 10 10 52 Personnel 10 15 53 Services 10 20 54 Antitrust Law 11 5 55 Contract Law 11 10 56 Corporate Law 11 15 57 Environmental Law 11 20 58 International Law 11 25 59 Labor Law 11 30 60 Real Estate Law 11 35 61 Taxation Law 11 40 62 Maintenance In Manufacturing 14 5 BusFamily_ID BusFamlly_Name BusArena ID ASPPage Dis _-play 84 63 Manufacturing Process -14 10 64 1 anfctrinqProductio . 14 15 65 Manufacturing Quality Control 14 20 66 Distrlburion/Transportation/War 15 25 housing 67 Materials Management 15 30 68 Purchasing 15 35 69 Sales Management- 21 5 70 Sales Operations 21 10 71 Customer Service 22 5 72 Operations 22 10 73 Sales/Marketing 22 15 74 Bookkeeping 75 75 Database Support 7 10 76 Desk Top Publoshing 7 15 77 Spreadsheet Support 7 20 20 General Clerical Support 8 5 21 Administrative Support 1 5 15 Business Analysis 2 5 19 Business Support 2 10 1 Network 16 5 -Design/Planning/Consulting 2 Network infrastructure 1610 3 N etwork 16 15 Operations/Admlnislratlon 4 OSPrgramig____ 3 15 5 -Application Development 3 5 6 Database Development 3 10 8 Product Management 17 10 9 Product Design/Development 17 5 10 OS Programming .13 9 11 Network Infrastructure Support 13 15 12 Application Deveomen 13 13 Network 13 20 Management/Administration 14 SAP 5 20 15 PeopleSoft 5 15 16 O -racle 5 10 17 Baan 5 5 78 Database Deveopment 13 10 85 TABLE 33 Exemplary Business General Functions Column Name Data Type Length Resource Profile Info Business Family ID Int 4 78 General Function ID Int 4 3 GeneralFunctionNa Nvarchar 100 Database Admin. me 5 TABLE 34 Skill Categories Table (tblCategory) Column Name Data Type Length Skills Category ID Int 4 Skills Cateay Nvarchar 255 TABLE 35 10 Skills By Category Table (tblSkillsMap) Column Name Data Type Length Skill ID int 4 Skill Name nvarchar 255 Skills Category nvarchar 255 Skills Category ID int 4 86 TABLE 36 Business Family to Skill Category Map (tblBusFamtoSkillCat) Column Name Data Type Length BusinessFamilylD int 4 Skills Category ID int 4 Skills Category_ nvarchar 255 Required char 1 Record ID int 4 5 TABLE 37 Exemplary Business Skills Priority Column Name Data Type Length Resource Profile Info Skill Priority ID Int 4 2 Skill Priority Name varchar 50 Critical Upon submission of the vendor bid response, all of the bid item selection 10 fields are populated with bid data (either bid request data or vendor response data), which is stored in system (buyer database and vendor database) as a bid in a hierarchical and relational manner, as shown in the database table structure 800 of FIG. 29. Exemplary data structures for storing the bid data are shown hereinbelow in Tables 38-55, which will be discussed in connection with FIG. 29. 15 Tables 38 and 39 below illustrate sample bid request data associated with a particular bid request that can be stored in the database in tables 'tbIRFX" 801 and "tblRFXSelectedBid Items" 802, as shown in FIG. 29, For example, in table 87 "tblRFX" 801, general information concerning the bid request can be stored, such as the bid tracking number assigned to the bid request by the system, the bid request name assigned by the originator, the identity of the bid request originator, the bid template type, the project type, project work location, budgeted expenditure 5 amount for the project, the status of the bid request (e.g., new, submitted, evaluated, awarded, etc.), whether or not top-level database vendors received the bid request and whether any approval was required. However, it should be understood that other bid information can also be included, and the system is not limited to the specific information shown in Tables 38 and 39. 10 The specific bid items selections included within the bid request and the bid request data (buyer comments) entered by the originator for each of the bid item selections can be stored in the table "tblRFXSelectedBidItems" 802. Each bid item selection can be stored as a separate record in "tblRFXSelectedBiditems" 802, with each record containing all of the fields shown in Table 39 below. Table 15 "tblfRFXSelectedBid Items" 802 is tied to the general bid request information table "tbIRFX" 801. As discussed above in connection with FIG. 10, the bid item selections contained within table "tblRFXSelectedBidItems" 802 are selected from the table "tblfRFXBidItems" 403 and associated with a particular bid template type stored within table "tblRFXBidTemplates" 405 through table 20 "tblRFXTemplateltemMatrix" 404.
88 TABLE 38 Master Bid Table (tblRFX - db structure view) Column Name Data Type Length RFX Tracking ID int 4 Originator User ID int 4 RFX Template ID int 4 Project Sector ID int 4 Project Family ID int 4 Project Type ID int 4 RFX Status ID int 4 Buyer Bid ID varchar 100 RFP Title varchar 100 RFX AdministrationLocationI numeric 9 D Primary Work Location ID numeric 9 External Work Location varchar 600 Solicit TLD Vendors char 1 Currency ID int 4 Budgeted Expenditure money 8 Assigned to ID int 4 RFQ Team Member int 4 Financial Approval Required char 1 NonFinancialApprovalRequir char 1 ed 89 TABLE 39 RFX Bid Items Table (tblRFXSelectedBidItems) Column Name Data Type Length RFX Tracking_ ID mnt 4 RFX Item ID int 4 RFX Item varchar 255 Disablement Allowed char 1 HM Disabled char 1 Buyer Comments varchar 8000 Vendor Bid Display char 1 Vendor Response Item char 1 Vendor Response Required char 1 Item Complete char 1 Identity Key mnt 4 5 Sample information pertaining to the posting (transmitting) of the bid request to qualified vendors is shown hereinbelow in Table 40, which can be stored in the database in table "tbIRFXPost" 803, as shown in FIG. 29. In exemplary embodiments, posting information is related to each particular vendor that received the bid request, and can include, for example, the date and time the 10 bid request was submitted (posted) to the qualified vendor, the identity of the administrative user that posted the bid request, the identity of the qualified vendor that received the bid request, the vendor bid response identifier and the score assigned to the vendor, as described below in connection with FIGs. 31-35. However, it should be understood that other information can be included, and the 15 system is not limited to the specific information shown in Table 40. A separate 90 record for each vendor that received the bid request can be stored in table "tbiRFXPost" 803, with each record including all of the fields shown hereinbelow. TABLE 40 5 tblRFXPost Column Name Data Type Length Bid Tracking ID int 4 Vendor ID int 4 Posting Record int 4 Post Time datetime 8 Admin Poster ID int 4 Response ID int 4 Score int 4 10 Sample information pertaining to the receipt of the bid request by the vendor and the submission of the vendor bid response is shown hereinbelow in Table 41, which can be stored in the database in table "tbFRFXResp" 804, as shown in FIG. 29. For example, such response submission information can include the vendor bid response identifier, the status of the vendor bid response, 15 the identity of the vendor, the vendor bid response submission date and the dates the vendor acknowledged the confidentiality and intend to respond agreements. Examples of the types of status information that can be included in the table "tblRFXResp" 804 are shown hereinbelow in Table 42, which can be stored in the database in table "tblRFXRespStatus" 805, as shown in FIG. 29. Tables 20 "tblRFXResp" 804 and "tblRFXRespStatus" 805 are tied to table "tblRFXPost" 803, 91 which in turn, is tied to "tbIRFX" 801 to associate the vendor response submission information to the bid posting information for the bid request. However, it should be understood that other information can be included, and the system is not limited to the specific information shown in Tables 41 and 42. A separate record for each 5 vendor bid response can be stored in 'tblRFXResp" 804, with each record containing the fields shown in Table 41 below. TABLE 41 10 tbIRFXResp Column Name Data Type Length Response ID int 4 RFX Resp Status ID int 4 Vendor ID int 4 ConfidentialityAcceptanceDat datetime 8 Intend to Respond Date datetime 8 RFX Resp Submit Date datetime 8 Last Edit Date datetime 8 15 92 TABLE 42 Exemplary Data from tblRFXRespStatus 1 New 2 Confidentiality Terms Accepted 3 ConfidentialityTerms Not Accepted 4 Response Intended 5 Response Declined 6 Temporarily Saved 7 Response Submitted 8 Bid Not Accepted 9 Awaiting Re-Bid 10 Re-Bid Declined 11 Bid Accepted 12 Bid On Hold 13 Waiting Bid Description 5 Table 43 below illustrates sample vendor bid response data submitted in a vendor bid response from a vendor to a buyer, which can be stored in the database in table "tblRFXRespMain" 806, as shown in FIG. 29. For example, such vendor bid response data can include the bid tracking number, the vendor 10 response identifier, the identity of the vendor, the particular bid item selection the vendor has responded to, the vendor response to that particular bid item selection, any bid request data (buyer comments) associated with that particular bid item selection, the record identifier for the vendor response to the particular bid item selection and any grade given to the vendor response by the buyer, as will be 15 described in mOre detail hereinbelow in connection with FiGs. 31-35. However, it should be understood that other information can be included, and the system is 93 not limited to the specific information shown in Table 43. A separate record for each bid item selection responded to by the vendor is stored in "tblRFXRespMain" 806, with each record containing the fields shown in Table 43 below. Table "tblRFXRespMain" 806 is tied to "tbiRFX" 801 and "tblRFXPost" 803 to associate 5 the vendor bid response with the bid request. TABLE 43 tblRFXRespMain 10 Column Name Data Type Length Bid Tracking ID int 4 Response ID int 4 Vendor ID int 4 Identity Key int 4 RFX Item ID int 4 RFX Item varchar 50 Vendor Response varchar 7000 Required item char 1 Buyer Comments varchar 7000 Resp Record ID int 4 Record Create Date datetime 8 Last Save Date datetime 8 Item Grade char 1 Associated with one or more of the vendor responses to bid item selections 15 may be one or more resource profiles of the particular resources (contractors) that the vendor identified as necessary to complete the project. The resource profiles can be created in advance or as part of the vendor bid response. The resource 94 profiles are generated using the business sector, business arena, business family, general functions and skills discussed above in connection with FIG. 28 and shown in Tables 30-37 above. Examples of resource profile information (resource type and skills) for 5 resource profiles are shown hereinbelow in Tables 44-46, which can be stored in the database in tables "tblResou rceProfile Master" 807, "tbi Resource Profile MasterSkills" 816 and "tblResourceProfileMasterGF's" 817, as shown in FIG. 29. The table "tblResourceProfileMaster" 807 stores the resource type of the resource profile (e.g., business sector, arena and family), while table 10 "tblResourceProfileMasterSkills" 816 stores the business skills (skills sets and skill sets priorities) associated with the resource type and table "tbResourceProfileMasterGF's" 817 stores the general functions of the resource type. However, it should be understood that other information can be included, and the system is not limited to the specific information shown in Tables 44-46, A 15 separate record for each resource profile is included in tables "tblResourceProfileMaster" 807, "tbiResourceProfl leMasterS kills" 816 and "tblResourceProfileMasterGF's" 817, with each of the records containing all of the fields shown below in Tables 45-46. The table "tblResourceProfileMaster" 807 is tied to tables 'tblResourceProfileMasterSkills" 816 and 20 "tblResourceProfileMasterGF's" 817 to associate the general functions and skills sets with the resource type of each resource profile.
95 TABLE 44 tblResourceProfileMaster (db structure view) Column Name Data Type Length Resource Profile ID int 4 Resource Profile Name varchar 255 User ID int 4 Vendor ID int 4 Bus Sector ID int 4 Bus Arena ID int 4 Bus Family ID int 4 User Notes varchar 1000 Record Date datetime 8 Profile Status char 4 5 TABLE 45 tblResourceProfileMasterGFs (db structure view) 10 Column Name Data Type Length Resource Profile ID int 4 General Function ID Int 4 Record ID int 4 96 TABLE 46 tblResourceProfileMasterSkills (db structure view) Column Name Data Type Length Resource Profile ID int 4 Skill ID int 4 Record ID int 4 Skill Priority int 4 Sample information relating to the particular selected resource profiles submitted with the vendor bid response is shown in Table 47 below, which can be 10 stored in table "tblRFXResourcePfoiles" 818 in FIG. 29. For example, such selected resource profile information can include the identity of the resource profile and the anticipated quantity of that particular selected resource profile that are needed to complete the project. However, it should be understood that other information can be included, and the system is not limited to the specific 15 information shown in Table 47. A separate record for each selected resource profile for the project is stored in "tblRFXResourceProfiles" 818, with each record containing all of the fields shown in Table 47 below. Table "tblRFXResourceProfiles" 818 is tied to table "tblRFXResourceProfileMaster" 807 to associate the particular resource type, skills and general functions with the 20 selected resource profile. Table "tblRFXResourceProfiles" 818 is further tied to table "tblRFXSelectedBiditems" 802 to associate the selected resource profiles with the particular bid item selections requesting the resource profiles.
97 TABLE 47 5 tblRFXResouceProfile (db structure view) Column Name Data Type Length Resource Profile ID int 4 Anticipated Quantity int 4 User ID int 4 Record Date datetime 8 Identity Key int 4 Record ID int 4 Depending on the bid request, as part of the vendor bid response to one or 10 more bid item selections, the vendor may also provide pricing information associated with the particular selected resource profiles for the project. Sample resource pricing information is shown in Table 48 below, which can be stored in the database in table "tblRFXResourcesProfilePricing" 819, as shown in FIG. 29. For example, such resource pricing information can include the resource profile 15 identifier, the identity of the vendor bid response record for the bid item selection requesting the resource profile and pricing information, the anticipated number of hours the resource associated with the resource profile will work, the billing rate associated with the resource profile and the anticipated billing amount of the resource associated with the resource profile. However, it should be understood 20 that other information can be included, and the system is not limited to the specific information shown in Table 48. A separate record for each resource associated 98 with one of the selected resource profiles is stored in table "tblRFXResourcesProfilePricing" 819, with each record containing the fields shown in Table 48 below. Table "tbiRFXResourcesProfilePricing" 819 is tied to table "tblRFXResourceProfiles" 818 to associate the resource pricing information for a 5 particular resource to a particular selected resource profile. In addition, table 'tbIRFXResourcesProfiiePricing" 819 is tied to table "tblRFXRespMain" 806 and table "tblRFXSelectedBidItems" to associate the resource pricing information and selected resource profile with the vendor bid response to a particular bid item selection. 10 TABLE 48 tbiRFXResourceProfilesPricing (db structure view) Column Name Data Type Length Resource Profile ID pct 4 Res- Record UD mt 4 Vendor ID Int 4 Anticipated Hours int 4 Bill Rate money 8 Anticipated Billin money 8 Record Date datetimne 8 Record ID 1t 4 1denti Ke mnt 4 15 In addition to the particular resource profiles and pricing, the vendor bid response may also include information related to the types of materials needed for the project. Sample material information is shown below in Table 49, which can 99 be stored in the database in table "tbRFXRespMaterials" 822, as shown in FIG. 29. For example, such material information can include the identity of the vendor bid response record for the bid item selection requesting the material information, the type of material and the cost of the material. However, it should be understood 5 that other information can be included, and the system is not limited to the specific information shown in Table 49. A separate record for each type of material is stored in table "tblRFXRespMaterials" 822, with each record containing the fields shown in Table 49 below. Table "tblRFXRespMaterials" 822 is tied to table "tblRFXRespMain" 806 and table "tblRFXSelectedBidltems" to associate the 10 material information with the vendor bid response to a particular bid item selection. TABLE 49 tblRFXRespMaterials (db structure view) 15 Column Name Data Type Length Resp Record ID int 4 Material Name varchar 100 Material Description varchar 500 Material Manufacturer- varchar 100 Unit Cost money 8 Unit Count numeric 9 Line Item Cost money 8 Record Date datetime 8 Record ID int 4 Identity Key int 4 100 The vendor bid response may also include information related to the phasing of the project. Sample phasing information is shown below in Table 50, which can be stored in the database in table "tblRFXRespPhase" 823, as shown in FIG. 29. For example, for each phase of the project, the phasing information can 5 include the identity of the vendor bid response record for the bid item selection requesting the phasing information, the number of the particular phase, a description of the phase, the anticipated duration of the phase and the project deliverables at the end of the phase (e.g., number of units to be completed or other project milestones). However, it should be understood that other information 10 can be included, and the system is not limited to the specific information shown in Table 50. A separate record for each phase is stored in table "tblRFXRespPhase" 823, with each record containing the fields shown in Table 50 below. Table 'tblRFXRespPhase" 823 is tied to table "tblRFXRespMain" 806 and table "tblRFXSelectedBidItems" to associate the phasing information with the vendor bid 15 response to a particular bid item selection. TABLE 50 tblRFXRespPhase (db structure view) 20 Column Name Data Type Length Resp Record ID nt 4 User ID int 4 Project Phase # numeric 9 Project Phase Description varchar 7000 Project Phase Duration Anticipated varchar 1000 101 Project Phase Deliverables varchar 7000 Record Date datetime 8 Record ID7 I t 4 Identi Ke int !4 All of the questions and answers posted by the vendor and buyer on the bid message board and any questions submitted to the vendor from the buyer 5 regarding the vendor bid response can also be stored in the system and associated with the particular vendor bid response. Sample question information is shown in Tables 51 and 52 below, which can be stored in the database in tables 'bl RFXQuestionsFromVendor" 820 and "tbl RFXQuestionsFrom Buyer" 821, as shown in FIG. 29. A separate record for each vendor question/buyer response 10 and buyer question/vendor response is stored in tables 'l RFXQuestionsFromVendor" 820 and "tblRFXQuestionsFromBuyer" 821, with each record containing the fields shown in Tables 51 and 52 below. In addition tables "tblRFXQuestionsFromVendor" 820 and "tblRFXQuestionsFromBuyer" 821 are tied to table "tblRFXRespMain" 806 to associate the questions with the 15 particular vendor bid response. TABLE 51 tbiRFXQuestionsfromVendor (db structure view) 20 Column Name Data Type Length Vendor ID int 4 {Vendor Question/Comment) varchar 8000 102 Question Post Date | datetime 8 Buyer Response varchar 8000 Buyer Answer Post Date datetime 8 Record ID int 4 Resp Record ID int 4 10 TABLE 52 tblRFXQuestionsfromBuyer (db structure view) Column Name Data Type Length Vendor ID Int 4 Identity Key int 4 [Buyer Question/Comnment] varohar 8000 Buyer Post Date datetirne 8 Vendor Response varchar 8000 Vendor Response Date datetime 8 [Record ID int 4 Resp Record ID mnt 4 5 The vendor bid response can also be associated with details about previous project work that has been performed by the vendor to aid in bid response process. Sample previous project work details are shown in Table 53 below, 10 which can be stored in the database in table "tblRFXRespTrackRecord" 824, as shown in FIG. 29. For example, such previous project work details can include the vendor bid response identifier, the project name, the name of the buyer, the value of the project, a description of the project, a discussion of deployed resources (contractors) for the project, a discussion of the performance of the vendor, the 15 project start date and the project end date. It should be understood that additional previous project work details can be stored, and the system is not limited to the specific previous project work details shown in Table 53.
104 TABLE 53 tbl RFXRespTrackRecord (db structure view) Column Name Data Type Length Response ID mnt 4 fipject Name Varchar 255 Buyer Name Varchar 255 Prsect Value money 8 Project Description varchar 7000 Deployed Resources varchar 7000 quptns Peeormancb varchar 7000 Projc taDat .. datetime 8 Project End Date datetime 8w Record ID f p t 4 Record Date datetime 8 5 Referring now to G. 30, a screen shot of a sample web page displaying options to the buyer for administration of the bid request and vendor bid responses is illustrated. From the bid request administration web page, the buyer user can 10 submit a completed bid request to an administrator (or to qualified vendors), view vendor bid responses to a bid request, grade vendor bid responses, submit questions to the vendor about the vendor bid response, request a re-quote from a vendor, request project interviews with vendors or resource interviews with potential resources (contractors) for a project, award the bid (project) to a 15 particular vendor, assign resources for a project or place a bid request on hold. Once the buyer has received one or more vendor bid responses to a particular bid request, the buyer can grade or otherwise compare the vendor bid 105 responses in order to determine which vendor will get awarded the project. With the use of pre-established bid items in the (bid request and bid responses, all vendor bid responses have the same format, enabling efficient and effective grading and comparison of vendor bid responses. Therefore, prior to begin 5 grading of the vendor bid responses, the buyer can select one or more bid items for grading purposes. Exemplary functionality for selecting graded bid items and grading vendor responses to the selected graded bid items is shown in FIG. 31. A grading tool 188 is illustrated in FIG. 31 for the selection of graded bid items and grading of 10 vendor bid responses, in accordance with embodiments of the present invention. The grading tool 188 can include any hardware, software and/or firmware required to perform the functions of the tools and can be implemented within the web server 120 or an additional server (not shown). At any time after the creation of the bid request, a grader (e.g. buyer user or 15 project administrator user) responsible for grading vendor bid responses can access the grading tool 188 to select one or more bid item selections 235 from the bid request for grading purposes. The grading tool accesses the bid item list 194 stored in the database 155, retrieves the bid item selections 235 from the bid item list 194 that are included within the particular bid request identified by the grader 20 and displays the bid item selections 235 to the grader via the buyer module 110, web server 120, data network 40 and buyer browser 20a to choose from. From 106 the bid item selections 235, the grader can select one or more graded bid items 236 and provide a list of the graded bid items 236 to the grading tool 188. Upon receipt of one or more vendor bid responses, the grading tool 188 can access a vendor bid response list 192 to retrieve the vendor response data 215 5 associated with one of the graded bid items 236 for one of the vendor bid responses in the list 192. The bid item response data 215 is displayed to the grader for grading purposes. Based on various factors (objective and subjective) regarding the quality and information included within the displayed bid item response data 215, the grader can assign a grade for that bid item response 215 10 and transmit a bid item response grade 260 to the grading tool 188. The grading tool 188 further interfaces with the database 155 to store the bid item response grade 260 for the vendor in a vendor grades list 198 that contains the bid item response grades 260 for all graded bid items 236 for each of the vendor bid responses in the vendor bid response list 192. In addition, based 15 on all of the bid item response grades 260 received by the grading tool 188 for all of the graded bid items 236 for a particular vendor bid response, the grading tool 188 can calculate an overall vendor score 265 for the particular vendor bid response and store the vendor score 265 in the vendor grades list 198. Exemplary steps for selecting graded bid items and grading vendor bid 20 responses using the graded bid items are shown in FIGs. 32 and 33. The main processing steps performed for bid response grading are shown in FIG. 32. Upon receipt of vendor bid responses (step 3200), the bid item selections to be used for 107 grading purposes are identified (step 3210). The bid item selections are associated with the bid request soliciting the vendor bid responses, and vendor bid response data is included within the bid item selections chosen for grading purposes. Using the vendor bid response data within the graded bid items, the 5 vendor bid responses are graded (step 3220). A more detailed grading process is shown in FIG. 33. After a bid request is created, a buyer user is provided a list of bid item selections associated with the bid request (step 3330). From the list of bid item selections, one or more graded bid items are chosen (step 3305), and each graded bid item may be assigned a 10 weighting factor (e.g., a weighting percentage) (step 3310) to weigh certain responses more heavily than other responses in the final score. It should be noted that in some embodiments, the weighting factors can be equal, thereby eliminating the requirement that the buyer user enter a specific weighting factor. The weighting factors for all the graded bid items must be complete before the vendor 15 bid responses can be graded (step 3315). Once all of the graded bid items have been chosen and assigned a weighting factor, the grader is provided a list of vendor bid responses (step 3320) and selects one of the vendor bid responses for grading purposes (step 3325). Thereafter, the grader selects one of the graded bid items (step 3330) to grade the 20 vendor bid response data included within the graded bid item (step 3335). The grader can grade the vendor bid response data using any mechanism available to the grader . In one embodiment, the grader can pre-establish grading criteria for a S08 particular graded bid item to enable the system to automatically grade the vendor response data. For example, to grade pricing information, the grader can pre assign grades to specific pricing ranges, and the system can automatically provide a grade for a pricing graded bid item based on the price submitted in the vendor 5 bid response. In other embodiments, the grader can compare all of the vendor bid response data for a particular graded bid item initially before assigning grades based on the relative differences between the vendor bid response data. In still further embodiments, the grader can pre-establish a checklist or thresholds for each grade to be assigned to a particular graded bid item. 10 The grade assigned to the vendor response data for the graded bid item is stored in the database (step 3340), and the process is repeated for each graded bid item until the vendor response data included within each graded bid item for a particular vendor bid response is graded (step 3345). Once all of the grades have been completed, the system calculates the vendor's total score based on the 15 individual grades assigned to each graded bid item (step 3350). For example, if the possible grades are A, B, C and 0, the vendor score can be calculated by assigning four points for an A, three points for a B, two points for a C and one point for a D. Each vendor bid response is graded in the same manner (step 3355) to 20 enable the vendor scores to be sorted into descending order (step 3360) for display to the buyer user (step 3365). In addition to the total score, the grader can also be provided with the individual grades for the graded bid items to determine if 109 any re-quotes are necessary. By providing the grader with the total scores and individual grades, the grader can visually determine which vendor had the highest overall score and which vendors had the highest grades for particular graded bid items in order to make a decision as to which vendor to award the project. 5 However, it should be understood that other bid response comparison techniques can be used with the system of the present invention, instead of the specific grading and scoring described herein. Screen shots of exemplary web pages 61 that can be displayed to the grader for selection of graded bid items and grading of vendor bid responses are 10 shown in FiGs. 34A-34E. In FIG. 34A, the web page contains a list of bid item selections 235 for the grader to select from. For each of the selected graded bid items 236, the grader can also enter a weighting percentage 850 for that graded bid item 236. The grader can adjust the weighting percentages 850 based on pre established criteria or personal preferences until the weighted percentage 850 15 total equals one-hundred percent. As discussed above, in other embodiments, all graded bid items 236 can be assigned equal weights, so that the weighting percentages 850 would not need to be displayed to or selected by the grader, In order to grade vendor bid responses, as shown in FIG. 34B, the grader can be provided a web page listing the particular graded bid item 236 and either 20 displaying the vendor bid response data 215 or providing a link to the vendor bid response data 215. For example, as shown in FIG. 34C, a link to the resource profile and associated resource pricing information can be provided into order to 110 grade a particular graded bid item. Referring again to FIG. 34B, the grader can further be provided a prompt to enter the grade 855 for the vendor bid response data 215 associated with the graded bid item 236. In other embodiments, the grades 855 may be automatically assigned by the system, based on pre 5 established grading criteria. Once a vendor bid response has been graded, as shown in FIG. 34D, the grader can be provided a web page displaying all of the graded bid items 236, the weighting percentages 850 assigned to the graded bid items 236 and the vendor grade 855 assigned to each of the graded bid items 236 by the grader. In 10 addition, the total vendor score 860 can also be displayed to enable the grader to determine the total quality of the vendor bid response. Referring now to FIG. 34E, vendor bid responses can be compared side-by-side based on the total vendor score 860 and individual grades 855 assigned to each of the graded bid items 236. Examples of the data structures used for selecting the graded bid items and 15 storing the vendor grades are shown in Tables 54-56 hereinbelow. The data structures are illustrated for simplicity as being organized in a table format, with each table including all of the fields necessary for displaying bid item selections to the buyer user to select from and storing grades and scores for vendor bid responses. The tables are related in a hierarchical and relational manner, as will 20 be discussed in connection with FIG. 35. Sample bid item selections that could be included in a bid request and associated vendor bid response are shown in Table 54 below. However, it should 111 be understood that other information can be included, and the system is not limited to the specific information shown in Table 54. For each bid item selection, there is an indication of whether or not that bid item selection is gradable. For example, not all of the bid item selections may include vendor response data to grade. 5 Therefore, only the gradable bid item selections are displayed to the buyer user to select from.
112 TABLE 54 Exemplary Vendor Listing of Potential Graded Bid Items (By Category) RFXCategory RFX Item Default_ AVResponse_ Gradable_ DataType ._________________ Item ________ Supplier General Information Agree To Confidentiality Terms Char Supplier General information Intent To Respond Char Supplier General Information Company History LongText Supplier General Information Competitive Analysis LongText Supplier General information Product/Services Heritage Review LongText Supplier General Information Product/Services StrateqY LongText Supplier General Information Technology Vision LonqText SupplierGeneralinformation StrategicTechnology_Partners AV Hyperlink to Sub-Table ASP SupplierGeneralinformation TrackRecord AV Hyperlink to Sub-Table ASP Supplier General Information Project Management Philosophy LongText Supplier General Information PMI Certified FTEs LongText SupplierGeneral-Information CustomerReferences AV Hyperlink to Sub-Table ASP Supplier Project Information Proposal Narrative Y LongText Supplier Project Information Project Planning/Strategy Y LongText Supplier Project Information Statement Of Work Acceptance Char Supplier Project information Statement OfWorkProposedChange LongText s SupplierProjectInformation ProjectPhasing Y AV Hyperlink to Sub-Table ASP Supplier Project Information Project Phasing Acceptance Char SupplierProjectInformation Resource Model Y AV Hyperhnk to Sub-Table ASP RFXCategory RFXItem Default_ AVResponse Gradable_ DataType Item Supplier Project Information Knowledge Transfer Plan Y LonqText Supplier Project Information Deployment Plan Y LonqText Supplier Proect Information Customer Acceptance Model Y LonqText SupplierProjectInformation CustomerAcceptanceModelAgreeme Char nt SupplierProject Information CustomerAcceptanceModelProposed LongText Changes Supplier Project Information Non-Deliverable Penalties Acceptance Char Supplier ProjectInformation Non- LongText DeliverablePenalties_Proposed Chang es SupplierProjectPricing ResourceLaborPricing AV Hyperlink to Sub-Table ASP 113 Supplier Project Pricing Resource Labor Pricing Amount Y Currency Supplier Project Pricing Equipment/Tooling Pricing Comments LonpText SupplierProjectPricing MaterialsList AV Hyperlink to Sub-Table ASP Supplier Project Pricing Materials Cost Y Currency Supplier Project Pricing Equipment/Tooling Pricing Comments Currency Supplier Project Pricing Physical Site Pricing Comments LongText Supplier Project Pricing Physical Site Pricing Amount Y Currency Supplier ProjectPricing ProjectManagementPremiumComme LongText nts Supplier Project Pricing Project Management Premium Amount Y Currency SupplierProjectPricing IntellectualPropertyPremiumCommen LongText ts Supplier Project Pricing Intellectual Property Premium Amount Y Currency Supplier ProjectPricing MiscellaneousProjectExpensesCom LongText ments SupplierProjectPricing Miscellaneous ProjectExpensesAmou Y Currency Supplier Project Pricing Anticipated Margin Y Currency Supplier Project Pricing Total Bid Price Y Currency SupplierResourceExpenses_ ResourceTravelExpense_Comments LongText Handling Default_ Gradable. AVResponse_ RFX Category RFX Item Item Data Type SupplierResourceExpenses_ ResourceLivingExpenseComments LongText Handling SupplierResource_Expenses_ ResourcePerDiemComments LongText Handling SupplierResourceExpenses_ ResourceMileageExpenseComments LongText Handling SupplierResouce_Expenses_ ReimbersableMiscellaneousExpense_ LongText Handling Comments Capital Risk Model Capital Risk Model Comments LongText Capital Risk Model Capital Risk Model Amount Y Currency SupplierRebateModel orN RebateModelfornon- Y LongText on-deployed Investment deployed investment Supplier PaymentRelease_ SupplierPaymentReleaseSchedule LongText Schedule _________________ _____ _______ A separate grade is stored for each of the graded bid items, as shown in Table 55 below, which can be stored in the database table structure 1100 in table 5 "tblRFXGradeltems" 825, as shown in FIG. 35. Along with the assigned grade 855 for a particular graded bid item 236, table "tblRFXGradeltems" 825 may also 114 include the identity of the buyer user grader, the weighting percentage 850 assigned to the graded bid item 236 and the vendor bid response identifier associated with the grade 855. However, it should be understood that other information can be included, and the system is not limited to the specific 5 information shown in Table 55. Each vendor grade 855 for each vendor is stored in a separate record in the table 'tbiRFXGradeltems" 825, with each record containing the fields shown below in Table 55. In addition, table "tblRFXGradeltems" 825 is tied to the table "tbiRFXRespMain" 806, which is tied to table "tbiRFX" 801, both of which are described above in connection with FIG. 29, 10 in order to associate the vendor grade 855 to the vendor bid response and bid request. In addition, the table "tblRFXGradeltems" 825 is tied to the table "tbiRFXSelectedBidItems" 802 to associate the vendor grade 855 to the particular bid item selection 235. 15 TABLE 55 Graded Bid Items Table (tblRFXGradeltems) 20 Column Name Data Type Length User ID Int 4 RFX Item Varchar 50 Weight Percent percent 4 Grade Record ID int 4 Record Date datetime 8 Grade char 1 Response ID int 4 115 The calculated scores 865 for each of the vendor grades 855 for each bid item 235 can be stored as shown below in Table 56, which can be stored in the database in table "RFXitemScoreVendor" 826, as shown in FIG. 35. A separate 5 record for each graded bid item for each vendor bid response is stored in table "tblRFXItemScoreVendor" 826, with each record containing the fields shown in Table 56. In addition, the total score 860 based on all of the vendor scores 865 stored in the table "tblRFXItemScoreVendor" 826 can also be stored as shown in Table 57 below, which can be stored in the database in table 10 'tbIRFXScoreVendor" 827, as shown in FIG. 35. A separate record for each vendor bid response is stored in table "tblRFXScoreVendor" 827, with each record containing the fields shown in Table 57. The table "tblRFXtemScoreVendor" 826 is tied to the table 'tblfRFXGradeltems" 825 to associate each score 865 with the pertinent grade 855 15 for all of the graded bid items 236 for a particular vendor bid response. In addition, the table "tblRFXScoreVendor" 827 is tied to the table "tblRFXltemScoreVendor" 826 to associate all of the scores 865 for all of the graded bid items 236 for a particular vendor bid response with the total score 860 for that particular vendor bid response. Furthermore, table "tblRFXScoreVendor" 827 is tied to table 20 "tbIRFXPost" 803, which is described above in connection with FIG. 29, to update the table "tblRFXPost" with the vendor score 860.
116 TABLE 56 Vendor Item Scoring Table (tblRFXItemScoreVendor) 5 Column Name Data Type Length Response ID Int 4 RFX Item Int 4 Score Numeric 4 Buyer User ID Int 4 Score Record ID Int 4 Identity Key Int 4 TABLE 57 10 Vendor Scoring Table (tblRFXScoreVendor) Column Name Data Type Length Response ID int 4 Total Score numeric 9 Buyer User ID int 4 Score Record ID int 4 Identity Key int 4 15 After a vendor bid response is received and graded, the buyer user may provide the opportunity for a vendor to submit a re-quote on one or more graded bid items to improve the vendor's score. For example, a vendor that the buyer user typically chooses or that has high grades on other graded bid items may have 20 a lower score than another vendor, and the buyer user may want to provide the 117 vendor the opportunity to revise the vendor bid response data for the one or more graded bid items that have low grades. Exemplary steps for facilitating the re-quote process are shown in FIG. 36. When the grader becomes aware of one or more low grades for a particular 5 vendor on one or more graded bid items, the grader can invite the vendor to re quote on one or more selected graded bid items (steps 3600 and 3610). The invitation to re-quote (step 3620) may identify only the particular graded bid items that the vendor is allowed to re-quote on to prevent the vendor from re-quoting on any other graded bid items that the grader does not want to re-grade. For 10 example, the re-quote can include a copy of the original vendor bid response and enable only those re-quoted bid items to be selected by the vendor user to input new vendor response data. The old vendor response data can be deleted or stored along with the new response data in the database for reference purposes. In addition, the re-quote invitation can indicate the vendor grade for each re 15 quoted bid item, along with the vendor ranking for each re-quoted bid item, and other similar information, such as the high and low vendor grades for the re-quoted bid item. If the vendor chooses to not re-quote within a buyer-constrained time frame (step 3630), the original vendor grading and scoring applies to the vendor bid 20 response (step 3640). However, if the vendor does re-quote on one or more of the re-quoted bid items (step 3630), the vendor user can enter new vendor response data into bid item fields for the selected re-quoted bid items (step 3650). Upon 118 receipt of the re-quote (step 3660), the grader grades the re-quoted bid items using the new vendor response data and modifies the vendor score accordingly (step 3670). Exemplary steps for awarding the bid and entering project tracking 5 parameters are shown in FIG. 37. Once all of the vendor bid response grading and scoring is completed (step 3700), the bid can be awarded to one of the vendors. If the buyer user has the authority to select the vendor based on vendor score and other factors (e.g., personal preferences, knowledge of vendor reputation, knowledge of vendor availability, etc.) (step 3705), the buyer user can 10 select the vendor for the project (step 3710). Otherwise, the vendor with the highest score is awarded the bid (step 3715). Once the vendor for the project has been selected, the system notifies both the project administrator (step 3720) and the awarded vendor of the bid award (step 3725). Thereafter, the awarded vendor and buyer enter into negotiations to 15 finalize the terms and conditions of the project, as conventionally done (step 3730). If the awarded vendor and buyer cannot agree on the terms and conditions of the project (step 3735), the buyer can re-open the bid process to select a new vendor based on existing vendor scores, based on new vendor bid responses or both (step 3740). However, if the terms and conditions are agreed to (step 3735), 20 the buyer and awarded vendor can load various project tracking parameters into the system (step 3745), such as the project start date, project end date, anticipated project expenditure (requisition amount), assigned resources, project 119 phasing schedule, project payment release schedule, project deliverables, project materials and project expenses to create a purchase requisition for the project. It should be understood that additional project tracking parameters can be loaded into the system to track the performance of the project, and the system is not 5 limited to the project tracking parameters described herein. Once the purchase requisition for the project is approved by the appropriate approval users for the project administrator and the vendor (step 3750), the project can begin. Screen shots of exemplary web pages 61 for the project administrator and vendor to load project tracking parameters 870 into the system are shown in FIGs. 10 39 and 40. For the project administrator, as shown in FIG. 39, various requisition information can be entered into the system, such as the purchase requisition create date, purchase requisition status (which can be updated automatically by the system), the purchase requisition amount, purchase requisition currency (e.g., U.S. dollars), project start date and project end date. In addition, the project 15 administrator can also enter into the system various project terms and conditions, such as the statement of work, project goods and services deliverables, project contract, project materials, assigned project resources and billable rates, project expenses, project phasing schedule and project payment release schedule. Furthermore, the project administrator can assign administrative users to various 20 administrative user roles that have not already been assigned for the project. Moreover, other financial project tracking parameters applicable to the project can 120. also be entered into the system, such as account assignments, ledger codes, cost center codes, project codes, tax codes and accounting plants. As shown in FIG. 40, the vendor can access the buyer-entered data to modify previously entered project tracking parameters 870 in the system and/or 5 enter new project tracking parameters 870 into the system as the project administrator. For example, the vendor can enter one or more of the project terms and conditions discussed above. The parties can agree on who is going to enter the project tracking parameters 870, or both parties can enter and/or modify the project tracking parameters 870, and the system can provide notification to both 10 parties if any changes are made. It should be understood that other project tracking parameters can be inserted into the system, and the system is not limited to those project tacking parameters shown in FIGs, 39 and 40. During the final negotiation, the buyer may request the vendor to submit resumes of resource candidates (actual contractors) for the buyer to approve to 15 ensure that the resource profile positions included in the vendor bid response are filled by actual candidates having the resource profiles. Exemplary data structures for the submission of resource candidates and the review of resource candidates are shown in Tables 58 and 59 below. Table 58 below illustrates sample resource candidate information that can 20 be submitted for each resource candidate selected by the vendor for a resource profile position in the project, For example, the resource candidate information can include the bid tracking number of the particular bid (bid request and bid 121 response) associated with the resource candidate, the identity of the resource profile for the resource candidate, personal resource candidate information, vendor information, the resume of the resource candidate and the status of the resource candidate submittal. Table 59 illustrates various resource submittal 5 status information that can be included in Table 58. However, it should be understood that other information can be included, and the system is not limited to the specific information shown in Table 58, 122 TABLE 58 Exemplary Resource Submittal Table (db structure view) Column Name Data Type Length Submittal ID int 4 Bid Tracking ID int 4 RFX Resource Profile ID int 4 Profile ID int 4 Candidate ID int 4 First Name varchar 50 Last Name varchar 50 Middle Name varchar 50 Name Suffix varchar 10 Citizenship Countryl int 4 Citizenship Country2 int 4 AuthorizedinWorkCountr char 1 y Authorization Description varchar 500 Resume Attachment char 1 Vendor ID int 4 Vendor Contact Name varchar 100 Vendor Contact Phone varchar 50 Vendor Contact Email varchar 100 Record Date datetime 8 Submittal Status ID int 4 5 123 TABLE 59 Exemplary Resource Submittal Status Table (data view) SubmittalStatus SubmittalStatus DisplayValue _ID 1 New Being Reviewed by_ Admin 2 On Hold byAdmin Admin Temporary Hold 3 DeclinedbyAdiL Candidate Declined by Admin 4 Submitted to buyer Fowre o ByrRve 5 Declined by Buyer Candidate Declined byBuyer 6 Interview Requested Interview Requested 7 Interview Scheduled Interview Scheduled 8 Interview Conducted Interview Conducted 9 Offer Tendered a Buyer Offer Tendered 10 Offer Accepted Vendor Offer Accepted 11 Cadate Enaed Candidate Assigned To Order 12 OnaHod by Byer Buyer Temiporary Hold 13 Withdrawn No Longer Available 5 Exemplary steps for approving resource candidates are shown in FIG. 38. For each resource profile included in the vendor bid response, the vendor submits a resume of a potential resource candidate for the resource profile position (step 10 3800). The buyer reviews all of the resumes and assigns qualified resource candidates to the resource profile positions (step 3810). If one or more of the resource candidates is not acceptable (e.g., the resume does not indicate that the resource candidate has the requisite skills for the resource profile) (step 3820), and there are no other acceptable candidates for 15 the resource profile position (step 3830), the buyer can re-open the bid process to 124 secure another vendor for the project that can provide the necessary resources (step 3840). However, if all resource profile positions can be filled by qualified resource candidates, the buyer and/or vendor enters resource information associated with each of the assigned resource candidates (contractors) into the 5 contractor database (step 3850). For example, personal information concerning the contractor, such as the contractor name, address, telephone numbers and employee number, can be entered into the contractor database. In addition, specific project-related contractor information, such as the total number of authorized billable hours, billable rate, the total amount and type of expenses 10 authorized and any agreements or documents that the contractor needs to execute or provide prior to beginning work, can be entered into the contractor database. Once the contractor information is entered, the system can authenticate the contractor for time keeping and system access purposes (step 3860). For 15 example, the system can provide a user name and password to the contractor for system log-in and authentication purposes. In addition, the system can require the contractor to execute one or more agreements (e.g., by acknowledging the terms of the agreements on-line) and/or provide one or more documents before being allowed access to the time keeping system. 20 A screen shot of an exemplary web page 61 displayed to a contractor upon initial log-in and authentication is shown in FIG. 42. The web page lists several documents that must be executed before the contractor can begin working on the 125 project. For example, the contractor may need to sign an Intellectual Property agreement, a Confidentiality agreement, a Code-of-Conduct agreement and an Acknowledgement of Temporary Work agreement. By clicking on each of the listed documents, a web page showing the agreement can be displayed to the 5 contractor and the contractor can click on an acceptance button to execute the agreement. Exemplary database structures for storing contractor information and ensuring that relevant documents are obtained from the contractor or agreed to by the contractor are shown in Tables 60-63 below. Table 60 lists various sample 10 documents that either need to be obtained from the contractor or that the contractor needs to execute at some point during the project. Table 60 also lists the time constraints for obtaining or executing such documents. Table 61 lists the contractor information, such as the identity of the contractor, the number of billable hours authorized, the amount of expenses authorized, the execution date of 15 various documents and the contractor type. Table 62 lists the particular document and identifies whether the contractor has executed or provided that document and the date of such execution or provision. It should be understood that a separate record for each document is stored having the format of Table 62. Table 63 illustrates various exemplary information identifying the type of contractors, such 20 as the number of days the contractor has and has not worked for the buyer. However, it should be understood that other information can be included, and the system is not limited to the specific information shown in Tables 60-63.
128 TABLE 60 Exemplary Contractor Documents Table Non- Document_ DueDiligenceMethod Time Constraint Employee_ Description Document ID 1 Confidentiality Electronic ProjectDuration Agreement Challenge/Acknowledgme nt 2 Intellectual Property Electronic ProjectDuration Rights Agreement Challenge/Acknowledgme nt 3 Code of Conduct Electronic ProjectDuration Agreement Challenge/Acknowledgme nt 4 Temporary Work Electronic ProjectDuration Assignment Challenge/Acknowledgme Agreement nt 5 Commercial Drivers Physical Copy/Purchasing License_Defined License (CDL) Database Approval 6 Drug Test Physical Copy/Purchasing 6 months Documentation Database Approval 7 USA Military Physical Copy/Purchasing Clearance Defined Clearance Database Approval 8 Bonded Physical Copy/Purchasing Notary Defined Database Approval 9 USA Technology Physical Copy/Purchasing ProjectDuration Export Compliant Database Approval Citizen 10 Independent Physical Copy/Purchasing ProjectDuration Contractor Qualified Database Approval 11 W-2 Verification Physical Copy/Purchasing 6 months Database Approval 12 Certified Union Physical Copy/Purchasing Certification Member Database Approval Defined 13 Right to Work Physical Copy/Purchasing Project Duration Country Database Approval 5 127 TABLE 61 Exemplary Contractor Table Column Name Data Type Length Requistion ID int 4 Buyer PO # varchar 20 Current Status ID int 4 Contractor ID int 4 Time Keeping Only char 1 Billable Hours Authorized int 4 Expenses Authorized money 8 Vendor ID int 4 User ID int 4 Record ID int 4 IP Agreement Date datetime 8 ATW Agreement datetime 8 Confidentiality Agreement datetime 8 Drug Screen datetime 8 Code Of Conduct datetime 8 Contractor Type int 4 Profile ID int 4 5 128 TABLE 62 Exemplary Contractor Execution Dates Table Column Name Data Type Length Contractor ID int 4 Non- int 4 Employee Liability Issue ID Agreement Executed char 1 Agreement Execution Date datetime Assessment Complete Date datetime 1 Assessment Disposition char 1 Assessment User ID int 4 Tickler Date datetime 5 TABLE 63 Exemplary ContractorTypes Table (db structure view) Column Name Data Type Length Contractor Type ID. Int 4 Contractor Type Varchar 50 Notes Varchar 500 Tenure Days Numeric 9 Separation Days Numeric 9 10 Examples of the data structures used for storing the project tracking parameters are shown in Tables 64-79 hereinbelow. The data structures are 15 illustrated for simplicity as being organized in a table format, with each table including all of the fields necessary for tracking the performance of the project.
129 The tables are related in a hierarchical and relational manner, as will be discussed in connection with FIG. 41. Table 64 below illustrates sample general purchase requisition information, which can be stored in the database in table 'tblPurchasefReq" 1000, as shown in 5 FIG. 41. For example, such general purchase information can include the identity assigned to the purchase requisition by the system, the buyer and the vendor, the requisition create date, the requisition amount, the bid tracking number for the bid (bid request and bid response) associated with the purchase requisition, the project start and end dates, along with any other pertinent purchase requisition 10 information. However, it should be understood that other information can be included, and the system is not limited to the specific information shown in Table 64. Referring now to the database table structure 1150 in FIG. 41, table "tblPurchaseReq" 1000 is shown tied to table "tblPurchaseReqContractors" 1012 and table "tblluContractorTypes" 1013, which include information in the data 15 structure format corresponding to Tables 61 and 63 above, respectively, to associate the assigned contractors to the purchase requisition.
130 TABLE 64 tblPurchaseReq Column Name Data Type Length Requisition ID mt 4 ReqCreated Date datetime 8 Req" Received Date datetime 8 RegPcess Date datetime 8 BdTackinlQI mnt 4 Requistion Amount money 8 Currency nt tha 4 Project Start datetime 8 Project, End datetime 8 Process Fee numeric 9 Vendor ID int 4 Buyer PR_ # varchar 20 PR Version numeric 9 Vendor PR #t varchar 20 Version Effective Date -datetime 8 Req- Processor mnt 4 Current Status ID int4 5 Tables 65-70 below illustrate sample specific purchase requisition information associated with tax codes, account plants, cost centers, project codes, account assignment and other similar buyer specific purchase requisition information, all of which can be stored in the database in respective tables 10 "tblPurchasefleqTaxCode" 1001, 'tblPurohaseReqAcctPlan" 1002, "tbl PuchaseReqAcctCostCenter" 1003, 'tb P urchasefleqProjectCodes" 1004, "tblPurchaseReqAcctGL' 1005 and "tblPurchasefleqAcctAssignment 1006, as shown in FIG. 41. However, it should be understood that additional tables and 131 information related to the purchase requisition can be included, depending on the purchase requisition requirements. Tables "tblPurchaseReqTaxCode" 1001, "tblPurchaseReqAcctPlant" 1002, "tbIPuchaseReqAcctCostCenter" 1003, "tblPurchaseReqProjectCodes" 1004, "tbIPurchaseReqAcctGL" 1005 and 5 "tblPurchaseReqAcctAssignment" 1006 are tied to the table "tbiPurchaseReq" 1000 to associate the specific purchase requisition information with the general purchase requisition information. TABLE 65 10 tblPurchaseReqTaxCodes Column Name Data Type Length Requistion ID int 4 Buyer PR # varchar 20 Tax Code varchar 10 Current Status ID int 4 Record iD int 4 15 TABLE 66 tblPurchaseReqAcctPlant Column Name Data Type Length Requisition ID int 4 Buyer PR # varchar 20 Accounting Plant varchar 10 Record ID int 4 Current Status ID int 4 132 TABLE 67 tbiPurchaseReqAcctCostCenter 5 Column Name Data Type Length Rquistion ID int 4 [Billable Dept/Cost Center] nvarchar 10 Buyer PR # varchar 20 Record ID int 4 Current Status ID int 4 10 TABLE 68 tblPurchaseReqProjectCodes Column Name Data Type Length Purchase Req ID int 4 Buyer PR # varchar 20 Project Code varchar 20 [Billable Dept/Cost Centerl nvarchar 20 Record ID int 4 Current Status ID int | 4 15 20 25 133 TABLE 69 tblPurchaseReqAcctGL Column Name Data Type Length Requisition ID int 4 Bu er PR # varchar 20 G L Account varchar 20 Record ID int 4 Current Status ID int 4 5 TABLE 70 tblPurchaseReqAcetAssignment 10 Column Name Data Type Length Requistion ID int 4 ~ Buyer PR # varchar 20 Account Assignment varchar 10 Current Status ID it 4 Record ID int4 Tables 71-75 below illustrate sample requisition payment information related to the purchase requisition. For example, such requisition payment 15 information can include payment amounts based on project deliverables (e.g., goods and services delivered at the end of the project or during phases of the project), payment amounts based on time frames, payment amounts based on the number of units completed, payment amounts based on project materials and payment amounts based on project expenses. In FIG. 41, the requisition payment 134 information is shown as stored in the database in tables "tblPurchaseReqPayDeliverable" 1007, "tbl PurchaseReqPayTimeS pan" 1008, "tbl PurchaseReq PayUnits" 1009, "tblPurchaseReqPayMaterials" 1010 and "tblPurchaseReqPayProjectExpenses" 1011. Each of the tables 5 "tblPurchaseReqPayDeliverable" 1007, "tblPurchaseReqPayTimeSpan" 1008, "tblPurchaseReqPayU nits" 1009, "tblPurchaseReqPayMaterials" 1010 and "tblPurchaseReqPayProjectExpenses" 1011 are shown tied to table "tblPurchaseReq" to associate the payment information with the general purchase requisition information. 10 It should be understood that additional tables or information may be included, depending on the purchase requisition requirements. In addition, it should be understood that one or more of the payment tables can be included, depending on the project. Furthermore, it should be understood that a separate record for each payment amount is included having the format of one of Tables 15 71-75 below.
135 TABLE 71 Exemplary tbiPurchaseReqPayDeliverable (db structure view) Column Name Data Type Length Requisition ID int 4 Buyer PR # varchar 20 Deiverable Descrtioi varchar 1000 AnticipatedCompletionDat datetime 8 Payment Amount money 8 Partial Payment Authorized char 1 Current Status ID int 4 Vendor ID int 4 User ID int 4 Record ID int 4 Record Date datetime 8 5 TABLE 72 Exemplary tblPurchaseReqPayTimeSpan (db structure view) Column Name Data Type Length Requisition ID int 4 Buyer PR Ivarchar 20 Current Status ID int 4 Work Start Date datetime 8 Payment Release Date Datetime 8 Payment Amount Money 8 Vendor ID int 4 User iD Int 4 Record ID Int 4 10 136 TABLE 73 Exemplary tblPurchaseReqPayUnits (db structure view) Column Name Data Type Length Requisition ID int 4 Buyer PR # varchar 20 Current Status ID int 4 Unit Completion Description varchar 1000 Unit Count numeric 9 Unit Cost money 8 Partial Payment Authorized char 1 Vendor ID int 4 User ID int 4 Record ID int 4 5- TABLE 74 Exemplary tblPurchaseReqPayMaterials (db structure view) Column Name Data Type Length Requisition ID nt 4 Buyer PR # Varchar 20 Vendor ID int 4 Material Name varchar 100 Material Description varchar 500 Material Manufacturer varchar 100 Unit Cost money 8 Unit Count numeric 9 Line item Cost money 8 Currency ID int 4 Current Status ID int 4 User ID int 4 Record ID int 4 Record Date datetime 8 10 137 TABLE 75 Exemplary tblPurchaseReqPayProjectExpenses (db structure view) Column Name Data Type Length Requisition ID int 4 Buyer PR # varchar 20 ProjectExpenseDescriptio varchar 500 n Maximum Threshold money 8 Currency ID int 4 User ID int 4 Vendor ID int 4 Current Status ID int 4 Record ID int 4 , Record Date datetime 8 Tables 77 and 77 below illustrate sample information associated with the pay rates for contractors assigned to the purchase requisition. For example, the contractor pay rate information can indicate the type of pay (e.g., hourly, fixed, 10 overtime, etc.) and the pay rate amount (e.g., billable rate per hour, billable rate per overtime hour, billable amount). The pay rate information can be stored in the database in tables "tblPurchaseReqPayRates" 1014 and "tbiluContractorPayRateTypes" 1015, which are shown in FIG. 41 tied to table "tblPurchaseReq" 1000 to associate the pay rate information with the purchase 15 requisition. It should be understood that a separate pay rate record for each pay rate type of each contractor can be stored in table "tblPurchaseReqPayRates" 138 1014. It should further be understood that additional tables or information can be included, depending on the purchase requisition requirements. TABLE 76 5 tblPurchaseReqPayRates (db structure view) Column Name Data Type Length Oequisition ID int 4 Buer IP # varchar 20 Current Status ID int 4 Contractor ID int 4 Pay Rate Type int 4 Pay Rate money 8 Currency ID int 4 User ID int 4 Vendor ID and 7 _Record ID n4 TABLE 77 10 tbiluContractorPayRateTypes (db structure view) Column Name Data Type Lengthhj Hour Type ID - int '4 Hour Type Descriptio-n - varchar j 50 Tables 78 and 79 below illustrate sample payment information associated with the contractor expenses for contractors assigned to the purchase requisition. 15 For example, the contractor expense information can indicate the type of expense and the maximum amount allocated for the expense. The contractor expense 139 information can be stored in the database in tables "tblPurchaseReqPayContractorExpenses" 1016 and "tbiluContractorPayExpenseTypes" 1017, which are shown in FIG. 41 tied to table "tblPurchaseReq" 1000 to associate the contractor expense information with the 5 purchase requisition. It should be understood that a separate contractor expense record for each contractor expense type of each contractor can be stored in table "tbiPurchaseReqPayContractorExpenses" 1016. It should further be understood that additional tables or information can be included, depending on the purchase requisition requirements. 10 TABLE 78 tblPurchaseReqPayContractorExpenses (db structure view) Column Name Data Type Length Requisition ID int 4 Buyer PR # varchar 20 Current Status ID int 4 Contractor ID int 4 Expense Type ID int 4 Maximum Threshold money 8 Currency ID int 4 User ID int 4 Vendor ID int 4 Record ID int 4 15 140 TABLE 79 tbliuContractorPayExpenseTypes (db structure view) Column Name Data Type Length ContractorExpenseTypeI int 4 D 5 Contractor Expense Type varchar 50 POST-BID ACTIVITY 10 Once the project has begun, the project administrator (or buyer) can monitor the progress of the project using a time keeping system, in which contractors enter time into time cards for project work performed. The time cards can be stored to assess project performance for requisition payment information 15 and/or to generate payment vouchers based on time worked, depending on the requisition payment information. For example, if the requisition payment amount was based, at least in part, on an anticipated number of billable hours of a particular contractor at a particular pay rate, and the contractor completed the project under the anticipated number of billable hours, the project administrator 20 and vendor may be able to re-negotiate the requisition payment amount that was initially set for payment based on deliverables, time frames or units. Referring now to FIG. 43, there are illustrated exemplary steps for implementing a time keeping system within the system of the present invention. After the contractor has completed all necessary documentation and is authorized 141 to enter the time keeping system, the contractor can enter the time keeping system (step 4300) to input time keeping information (step 4310) associated with the number of hours worked by the contractor into a time card (e.g., a time keeping record for the contractor). The time keeping information can be entered at 5 any time the time keeping system is accessible. For example, the time keeping system can be accessible only at specific times (e.g., the end of the week, the beginning of week, etc.) as determined by the project administrator or during times that the time keeping system is not off-line. Once the contractor has entered the time keeping information into the time 10 card, the time card is provided to the project administrator (step 4325) for review and approval (step 4330). If the time card is not approved (step 4340), the contractor and vendor are notified of the time card rejection (step 4350) and the contractor is instructed to access the time keeping system to modify the time card (step 4300). For example, if the contractor has not completely filled out the time 15 card, the time keeping information (e.g., number of hours) entered into the time card is out of the normal or unreasonable or the project administrator has knowledge that the time keeping information is incorrect, the time card may be rejected. if the time card is approved (step 4340), all applicable records within the system are updated with the time keeping information (step 4360) and any 20 payable vouchers associated with the time keeping information are extracted for invoice processing (step 4370). For example, if requisition payment is based on the number of hours worked within a particular time frame, a payable voucher may 142 need to be generated based on the time keeping information entered by the contractor. Screen shots of exemplary web pages 61 provided to the contractor through the time keeping system are shown in FIGs. 44 and 45. A sample time 5 keeping system home page is illustrated in FIG. 44. From the home web page, the contractor can create a new time card, recall temporarily saved time cards for completion purposes or view previously submitted time cards. in addition, if the contractor is allowed to enter contractor expenses (depending on the purchase requisition), the contractor can create a new expense voucher, recall a temporarily 10 saved expense voucher for completion or view previously submitted expense vouchers. To create a new time card (or complete a temporarily saved time card), as shown in FIG. 45, the contractor can enter various time keeping information 1150 into the time card 1100. For example, the contractor can enter the week ending 15 work date, project code for the project and cost center responsible for payment. In addition, the contractor can enter the number of regular hours worked each day and the number of overtime hours worked each day (at each overtime pay rate). It should be understood that other time keeping information can also be entered by the contractor, and the system is not limited to the particular time keeping 20 information shown in FIG. 45. A screen shot of a sample web page 61 displayed to the project administrator for review of the submitted time card is shown in FIG. 46. In addition 143 to the entered time keeping information, the project administrator may also be provided with other pertinent purchase requisition information associated with the time card, such as the current project phase, general ledger code, tax use code, account assignment code and account plant code. Based on the displayed time 5 keeping information, the project administrator can either reject the time card or approve the time card. If the project administrator rejects the time card, a pop-up window can be displayed for the project administrator to provide a reason for time card rejection. It should be understood that other information can be displayed to the project administrator for time card approval purposes, and the system is not 10 limited to the specific information shown in FIG. 46. Exemplary database structures for storing the time cards and contractor expense vouchers are shown in Tables 80-83 below. The data structures are illustrated for simplicity as being organized in a table format, with each table including all of the fields necessary for storing time cards and contractor expense 15 vouchers. The tables are related in a hierarchical and relational manner with other tables stored in the database, as will be discussed in connection with FIG. 47. Table 80 below illustrates sample general time keeping information, which can be stored in the database table structure 1160 in table "tbITimeCard" 1050, as shown in FIG. 47. For example, the time keeping information can include the time 20 card identifier, the associated purchase requisition identifier, the contractor identifier, the vendor identifier, an indication of whether or not the time entered is billable time for generation of a billing record, the week ending date associated 144 with the time card, the creation date, the review date and an indication of whether or not the time card has been approved. However, it should be understood that other information can be included, and the system is not limited to the specific information shown in Table 80. Table "tblTimeCard" 1050 is shown in FIG. 47 tied 5 to table "tbIPurchaseReqContractors" 1012, which is tied to table "tblPurchaseReq" 1000, both of which are discussed above in connection with FIG. 41, to associate the time card with the contractor and the purchase requisition, In addition, various other tables shown in FIG. 41 are illustrated in FIG. 47 to show the interrelation between the various purchase requisition tables 10 and the time card and contractor expense voucher tables. TABLE 80 Exemplary tblTimeCard (db structure view) Column Name Data Type Length Time Card ID mt 4 tcStatus ID nt 4 Re uisition ID int 4 Contractor ID int 4 Vendor ID 4 Billable Time nt 4 HM Submitter iD har Vendor Submitter ID int 4 Reviewer ID int 4 Week Ending Date ---- it 48 Record Create Date -datetime 8 Last Edit Date datetime8 Submit Date daeie8 Review Date datetime 8 Approval Date datetime 8 Date Rejected datetime 8 Contractor Notes varchar 100 lent Notes varchar 1000 145 The time card status identifier stored in the table "tblTimeCard" 1050 can be selected from a table "tbluTimeCardStatus" 1051, which stores time card status types (e.g., temporarily saved, submitted, approved, rejected, etc.) and their associated time card status identifiers. 5 Table 81 illustrates sample -detailed time keeping information, which can be stored in the database in table "tbiTimeCardDetails" 1052, as shown in FIG. 47. For example, such detailed time keeping information can include the number of hours entered as worked on a particular day for a particular pay rate type, the pay rate associated with the pay rate type and other detailed time keeping information. 10 Table "tblTimeCardDetails" 1052 is shown tied to table "tblTimecard" 1050 to associate the detailed time keeping information with the general time keeping information. In addition, table "tblTimeCardDetails" 1052 is tied to table "tbIluDayCode" 1053 to associate the day code stored in table "tIbTimeCard Details" 1052 with the particular day. It should be understood that a 15 separate record in the format of Table 81 is stored in table ' t blTimeCardDetails" 1052 for each pay rate type on each day for which the contractor enters time. It should further be understood that other tables and time keeping information can be included, and the system is not limited to the specific tables and time keeping information shown in FIG. 47. 20 146 TABLE 81 Exemplary tbfTimeCardDetails (db structure view) Column Name Data Type Length Time Card ID int 4 Record ID int 4 Pay Rate Type ID int 4 Day Code int 4 Quantity float 8 Account Assignment varchar 10 [Billable Dept/Cost Center nvarchar 10 Accounting Plant varchar 10 Project Code varchar 20 Tax Code varchar 10 G L Account varchar 20 5 Pay Rate money 8 5 Table 82 below illustrates sample general contractor expense voucher information, which can be stored in the database in table "tblContractorExpenseVoucher" 1054, as shown in FIG. 47. For example, such 10 general contractor expense voucher information can include the expense voucher identifier, the associated purchase requisition. identifier, the contractor identifier, the vendor identifier, the week ending date associated with the expense voucher, the creation date, the review date and an indication of whether or not the expense voucher has been approved. However, it should be understood that other 15 information can be included, and the system is not limited to the specific information shown in Table 82. Table 'tblContractorExpenseVoucher' 1054 is shown tied to table "tbiPurchaseReqContractors" 1012, which is tied to table 147 "tblPurchaseReq" 1000, both of which are discussed above in connection with FIG. 41, to associate the contractor expense voucher with the particular contractor and the purchase requisition. 5 TABLE 82 Standard tblContractorExpenseVoucher (db structure view) Column Name Data Type Length Requisition ID int 4 Expense Voucher ID int 4 tcStatus ID int 4 Contractor ID int 4 Vendor ID int 4 HM Submitter 1D int 4 Vendor Submitter ID int 4 Approver ID int 4 Week Endin Date datetime Record Create Date datetime Last Date datetime 8 Submit Date datetime8 Approval Date datetime 8 Date Rejected datetime 8 Contractor Notes varchar 1000 10 Client Notes varchar I 1000 Table 83 below illustrates sample detailed contractor expense voucher information, which can be stored in the database in table "tblContractorExpenseVoucherDetails" 1055, as shown in FIG. 47. For example, 15 such detailed expense voucher information can include the expense amount of a particular expense type on a particular day and other detailed expense voucher 148 information. Table "tblContractorExpenseVoucherDetaIs" 1055 is shown tied to table "tblContractorExpenseVoucher" 1054 to associate the detailed expense voucher information with the general expense voucher information. In addition, table "tblContractorExpenseVoucherDetails" 1055 is tied to table "tbiluDayCode" 5 1053 to associated the day code stored in table "tbIContractorExpenseVoucherDetails" 1055 with the particular day. It should be understood that a separate record in the format of Table 83 is stored in table "tblContractorExpenseVoucherDetails" 1055 for each type of expense on each day for which the contractor enters an amount. It should further be understood that 10 other tables and contractor expense voucher information can be included, and the system is not limited to the specific tables and contractor expense voucher information shown in FIG. 47. 15 TABLE 83 Stardard tblContractorExpenseVoucherDetails (db structure view) Column Name Data Type Length Expense Voucher ID mt 4 Record ID 4 Ex ense Type ID t4 Da Code mt 4 Ex ense Amount n 4 Account Assi nment varchar 10 Billable De t/Cost Centerl varchar 10 Accountin Plant varchar 10 Project Code varchar 20 Tax Code varchar 10 G L Account varchar 20 149 Referring now to FIG. 48, there are a number of different types of voucher information 1160 that can be entered into the system and stored in the database 155 for generation of a payable voucher 1180 to be paid by the buyer or project administrator to the awarded vendor. For example, the voucher information 1160 5 can include time keeping voucher information 11 60a, which includes the time keeping information 1150 (shown in FiG. 45 above) entered by the contractor and requisition payment information as determined by the entered project work tracking parameters 870 (shown in FIGs. 39 and 40 above) pertaining to the time keeping information. The voucher information can also include project expenses 10 voucher information 11 60b, project deliverables voucher information 11 60c, project materials voucher information 11 60d, contractor expensing voucher information 11 60e, project unit completion voucher information 11 60f and project timed payment release voucher information 1160g. The system can automatically generate payable vouchers 1180 based on voucher information 1160 previously 15 entered in other contexts (e.g., project tracking parameters entry, time keeping entry, contractor expense entry and/or project expense entry), or the vendor or buyer/project administrator can generate payable vouchers 1180 and enter various applicable portions of the voucher information 1160 (e.g., unit completion entry or deliverable completion entry) into the payable vouchers 1180. 20 Referring now to FIG. 49, exemplary steps involved in a voucher processing and payment system are illustrated. Initially, various project tracking parameters (e.g., purchase requisition information) are entered into the system (step 1400) 150 and all vendor responsibilities for goods and services, both billable and non billable are stored in the database (step 1410). When the vendor provides an authorized good or service (as determined by the entered vendor responsibilities) (step 1420), the vendor accesses the system to record the good or service 5 performed and request payment for the good or service (step 1430). In other embodiments, payment may be automatically requested by the system at certain time intervals. The system generates a voucher based on the project tracking parameters and other voucher information (e.g., timekeeping information, expenses, materials, etc.) (step 1440) and routes the voucher to the appropriate 10 buyer user or administrator user for approval of the voucher (step 1450). If the voucher is not approved (step 1460), the vendor is notified and provided the option of re-submitting the voucher (step 1470). If the voucher is approved (step 1460), the vendor is notified of the approval of the voucher (step 1480). If the voucher is a billable voucher (step 1490), the voucher is processed 15 for electronic invoicing based on prescribed scheduling (using system or buyer constraints) (step 1495). For example, the system can employ a batch process to collect all payment vouchers for the buyer (for one or more projects) approved during a pre-designated time period. All invoices can be generated in a format based on buyer specifications or in a system-defined format. The buyer receives 20 the invoice(s) (step 1498) and releases payment of the invoice(s) to the vendor(s) via a pre-configured method (e.g., EFI, check, etc.) (step 1499).
151 Exemplary database structures for storing the voucher information in payable vouchers and generating a paid voucher record are shown in Tables 84 92 below. The data structures are illustrated for simplicity as being organized in a table format, with each table including all of the fields necessary for storing 5 voucher information. The tables are related in a hierarchical and relational manner with other tables stored in the database, as will be discussed in connection with FIG. 49. Table 84 below illustrates sample general project unit completion voucher information, which can be stored in the database table structure 1170 in table 10 "tblVoucherUnits" 1060, as shown in FIG. 49. For example, the general project unit completion voucher information can include the unit voucher identifier, the associated purchase requisition identifier, an indication of whether all time cards associated with the unit completion have been approved, the vendor identifier, the week ending date associated with the voucher information, the creation date, the 15 review date and an indication of whether or not the voucher information has been approved. Table "tblVoucherUnits" 1060 is shown tied to table "tblPurchaseReq" 1000, which is discussed above in connection with FIG. 41, to associate the voucher information with the purchase requisition. In addition, various other tables shown in FIG. 41 are illustrated here in FIG. 49 to show the interrelation between 20 the various purchase requisition tables and the voucher tables. It should be understood that a separate record in the format of Table 84 is stored in table "tblVoucherUnits" 1060 for each payable unit voucher.
152 Furthermore, although not shown, the table "tbIContractorExpenseVouchee 1054, shown in FIG. 47, is also considered a voucher table for generation of a payable voucher. It should be understood that other tables and voucher information can be included, and the system is not limited to the specific tables 5 and voucher information shown in FIG. 49. TABLE 84 tblVoucherUnits (db structure view) 10 _ _ _ _ _ _ _ _ _ _ _ Column Name Data Type Length Requisition ID int 4 Unit Voucher ID int 4 tcStatus ID int 4 Vendor ID int 4 Week Ending Date datetime 8 Record Create Date datetime 8 Last Edit Date datetime 8 Submit Date datetime 8 Approval Date datetime 8 Review Date datetime 8 Date, Rejected datetime 8 Reviewer ID int 4 Vendor Notes varchar 1000 Buyer Notes varchar 1000 Table 85 below illustrates sample detailed project unit completion voucher information, which can be stored in the database in table "tblVoucherUnitsDetails" 15 1061, as shown in FIG. 49. For example, such detailed project unit completion voucher information can include a description of the unit completion, the number of 154 Billable Dept/Cost Center] nvarchar 10 Accounting Plant varchar 10 Project Code varchar 20 Tax Code varchar 10 G L Account varchar 20 Record ID in? 4 Table 86 below illustrates sample general time completion voucher information, which can be stored in the database in table 5 "tblVoucherTimePayment" 1062, as shown in FIG. 49. For example, the general time completion voucher information can include the time voucher identifier, the associated purchase requisition identifier, an indication of whether all time cards associated with the time completion have been approved, the vendor identifier, the week ending date associated with the voucher information, the creation date, the 10 review date and an indication of whether or not the voucher information has been approved. Table "tblVoucherTimePayment" 1062 is shown tied to table "tbIPurchaseReq" 1000, which is discussed above in connection with FIG. 41, to associate the voucher information with the purchase requisition. It should be understood that a separate record in the format of Table 86 is stored in table 15 "tblVoucherTimePayment" 1062 for each payable time voucher. 20 155 TABLE 86 tblVoucherTimePayment (db structure view) Column Name Data Type Length Reiuistion ID cet 4 Time Pay Voucher ID Gt 4 tcStatus ID nt 4 Vendor ID nt 4 Week EndingDate datetime 8 Record Create Date datetime 8 Last Edit Date datetime c Approval Date datetime 8 Date Rejected datetime 8 Review ID tt 4 Vendor Notes varchar 1 000 _Buyer_-Notes varchar 1000 5 Table 87 below illustrates sample detailed time completion voucher information, which can be stored in the database in table "tblVoucherTimePaymentDetals" 1063, as shown in FIG. 49. For example, such 10 detailed time completion voucher information can include the work start date, payment release date, payment amount and other detailed time completion voucher information. Table "tblVoucherTimeCompletionDetaIls" 1063 is shown tied to table 'tblVoucherTimePayment" 1062 to associate the detailed time completion voucher information with the general time completion voucher 15 information. In addition, table "tblVoucherTimePaymentDetails" 1063 is tied to table 'tbl PurchaseReq PayTimes pan" 1008 to associated the requisition time payment information with the time completion voucher information.
156 It should be understood that a separate record in the format of Table 87 is stored in table "tblVoucherTimePaymentDetails" 1063 for each payable unit voucher, It should further be understood that other tables and time completion voucher information can be included, and the system is not limited to the specific 5 tables and time completion voucher information shown in FIG. 49. TABLE 87 tblVoucherTimePaymentDetails (db structure view) Column Name Data Type Length Time Pay Voucher ID int 4 pptRecord ID int 4 Work Start Date datetime 8 Payment Release Date datetime 8 Payment Amount money 8 Account Assignment varchar 10 [Billable Dept/Cost Center] nvarchar 10 Accounting Plant varchar 10 Project Code varchar 20 Tax Code varchar 10 G L Account varchar 20 Record ID int 4 10 Table 88 below illustrates sample general project expense voucher information, which can be stored in the database in table "tblVoucherProjectExpense" 1064, as shown in FIG. 49. For example, the general project expense voucher information can include the project expense voucher 15 identifier, the associated purchase requisition identifier, an indication of whether all time cards associated with the project expense (if any) have been approved, the 157 vendor identifier, the week ending date associated with the voucher information, the creation date, the review date and an indication of whether or not the voucher information has been approved. Table "tblVoucherProjectExpense" 1064 is shown tied to table "tblPurchaseReq" 1000, which is discussed above in connection with 5 FIG. 41, to associate the voucher information with the purchase requisition. It should be understood that a separate record in the format of Table 88 is stored in table "tblVoucherProjectExpense" 1064 for each payable project expense voucher. TABLE 88 10 tblVoucherProjectExpense (db structure view) Column Name Data Type Length Requisition ID int 4 ProjectExpenseVoucherI int 4 D tcStatus ID int 4 Vendor ID int 4 Week Ending Date datetime 8 Record Create Dale datetime 1 8 Last Edit Date datetime 8 Submit Date datetime 8 Approval Date datetime 8 Date Rejected datetime 8 Reviewer ID int 4 Vendor Notes varchar 1000 Buyer Notes varchar 1000 15 Table 89 below illustrates sample detailed project expense voucher information, which can be stored in the database in table 158 "tblVoucherProjectExpenseDetails" 1065, as shown in FIG. 49. For example, such detailed project expense voucher information can include the date the expense was incurred, a description of the project expense, the amount of the project expense and other detailed project expense voucher information. Table 5 "tblVoucherProjectExpenseDetais" 1065 is shown tied to table "tblVoucherProjectExpense" 1064 to associate the detailed project expense voucher information with the general project expense voucher information. In addition, table "tblVoucherProjectExpenseDetails" 1065 is tied to table "tbiPurchaseReqPayProjectExpense" 1011 to associated the requisition project 10 expense payment information with the project expense voucher information. It should be understood that a separate record in the format of Table 89 is stored in table "tblVoucherProjectExpenseDetails" 1065 for each payable project expense voucher. It should further be understood that other tables and project expense voucher information can be included, and the system is not limited to the 15 specific tables and project expense voucher information shown in FIG. 49. TABLE 89 tblVoucherProjectExpenseDetails (db structure view) 20 Column Name Data Type Length ProjectExpenseVoucher-I int 4 D Expense Incurred Date datetime 8 ppeRecord ID int 4 LProject Expense Descriptio -varchar 500 159 n Project Expense Amount money 8 Account Assignment varchar 10 [Billable Dept/Cost Center] nvarchar 10 Accounting Plant varchar 10 Project Code varchar 20 Tax Code varchar 10 G L Account varchar 20 Record ID mnt 4 Table 90 below illustrates sample general material voucher information, which can be stored in the database in table "tbtVoucherMaterials" 1066, as shown 5 in FIG. 49. For example, the general material voucher information can include the material voucher identifier, the associated purchase requisition identifier, an indication of whether all time cards associated with the material (if any) have been approved, the vendor identifier, the week ending date associated with the voucher information, the creation date, the review date and an indication of whether or not 10 the voucher information has been approved. Table "tblVoucherMaterials" 1066 is shown tied to table 'tblPurchaseReq" 1000, which is discussed above in connection with FIG. 41, to associate the voucher information with the purchase requisition. It should be understood that a separate record in the format of Table 90 is stored in table "tblVoucherMaterial" 1066 for each payable material voucher. 15 160 TABLE 90 tblVoucherMaterials (db structure view) Column Name Data Type Length Regisition ID int 4 Material Voucher ID int 4 tcStatus ID int 4 Vendor ID int 4 Week Ending Date datetime 8 Record Create Date datetime 8 Last Edit Date datetime 8 Submit Date datetime 8 Approved Date datetime 8 Reviewed Date datetime 8 Date Rejected datetime 8 Reviewer ID int 4 Vendor Notes varchar 1000 Buyer Notes varchar 1000 5 Table 91 below illustrates sample detailed material voucher information, which can be stored in the database in table "tblVoucherMaterialsDetails" 1067, as shown in FIG. 49. For example, such detailed material voucher information can 10 include the date the material expense was incurred, the name of the material, a description of the material, the number of units of material purchased, the cost per unit of material and other detailed project expense voucher information. Table "tblVoucherMaterialsDetails" 1067 is shown tied to table "tblVoucherMaterials" 1066 to associate the detailed material voucher information with the general 15 material voucher information. In addition, table "tblVoucherMaterialsDetails" 1067 161 is tied to table "tblPurchasefReqPayMaterials" 1010 to associated the requisition material payment information with the material voucher information. It should be understood that a separate record in the format of Table 91 is stored in table "tblVoucherMaterialsDetails" 1067 for each payable material 5 voucher. It should further be understood that other tables and material voucher information can be included, and the system is not limited to the specific tables and material voucher information shown in FIG. 49. TABLE 91 10 tblVoucherMaterialsDetails (db structure view) Column Name Data Type Length Material Voucher ID mt 4 Expense Incurred Date datetime 8 ppmRecord ID mnt 4 Material Name varchar 100 Material Description varchar 500 Unit Count numeric 9 Unit Cost money 8 Line Item Cost money 8 [Billable Dept/Cost Center] nvarchar 10 Accounting Plant varchar 10 Project Code varchar 20 Tax Code varchar 1 G L Account varchar 20 Record ID mnt 4 15 Table 92 below illustrates sample general deliverables voucher information, which can be stored in the database in table "tbl VoucherDeliverables" 1068, as 162 shown in FIG. 49. For example, the general deliverables voucher information can include the deliverables voucher identifier, the associated purchase requisition identifier, an indication of whether all time cards associated with the deliverable (if any) have been approved, the vendor identifier, the week ending date associated 5 with the voucher information, the creation date, the review date and an indication of whether or not the voucher information has been approved. Table "tbiVoucherDeliverables" 1068 is shown tied to table "tblPurchaseReq" 1000, which is discussed above in connection with FIG. 41, to associate the voucher information with the purchase requisition. It should be understood that a separate 10 record in the format of Table 92 is stored in table "tblVoucherDeliverables" 1068 for each payable deliverables voucher. However, it should be understood that other information can be included, and the system is not limited to the specific information shown in Table 92. 15 TABLE 92 tblVoucherDeliverables (db structure view) Column Name Data Type Length Requisition ID int 4 Deliverable Voucher ID int 4 tcStatus ID int 4 Vendor ID int 4 Week Ending ID datetime 8 Record Create Date datetime 8 Last Edit Date datetime 8 Submit Date datetime 8 163 Approval Date daletime 8 Review Date datetime 8 Date Rejected datetime 8 Reviewer ID mnt 4 Vendor Notes varchar -1000 Buyer Notes varchar ~. i 1000 Table 93 below illustrates sample detailed deliverables voucher information, which can be stored in the database in table "tblVoucherDeliverablesnetails 1089, 5 as shown in FIG. 49. For example, such detailed deliverables voucher information can include a description of the deliverable, the anticipated completion date of the deliverable, the actual completion date of the deliverable, the payment amount requested and other detailed deliverables voucher information. Table "tblVoucherDeliverablesDetails" 1069 is shown tied to table 10 "tblVouchereliverables" 1068 to associate the detailed deliverables voucher information with the general deliverables voucher information. In addition, table "tblVouch erDeliverables Details" 1069 is tied to table 1bl Purchase ReqPayDeliverables" 1007 to associated the requisition deliverables payment information with the deliverables voucher information. 15 It should be understood that a separate record in the format of Table 93 is stored in table "tblVoucherDeliverablesDetails" 1069 for each payable deliverables voucher. It should further be understood that other tables and deliverables voucher information can be included, and the system is not limited to the specific tables and deliverables voucher information shown in FIG. 49. 20 164 TABLE 93 tblVoucherDeliverableExpenseDetails (db structure view) Column Name Data Type Length Deliverable Vendor ID int 4 ppdRecord ID int 4 Deliverable Description varchar 1000 AnticipatedCompletionDat datetime 8 e Actual Completion Date datetime 8 PaymentAmountRequeste money 8 d Account Assignment varchar 10 [Billable Dept/Cost Center] nvarchar 10 Accounting Plant varchar 10 Project Code varchar 20 Tax Code varchar 10 G L Account varchar 20 Record ID int 4 5 Table 94 below illustrates sample paid voucher information, which can be stored in the database as table "tbIPaidVoucherRecords" 1070, as shown in FIG. 49. For example, such paid voucher information can include the invoice number, 10 purchase requisition identities assigned by the buyer and vendor, the voucher approval date, the name of the approver, the type of voucher (e.g., time card, contractor expense, project expense, deliverable, time completion or unit completion) and associated voucher identifier, the invoice amount, the payment date and other paid voucher information.
165 Table "tblPaidVoucherRecords" 1070 is shown tied to table "tblPurchaseReq" 1000, which is discussed above in connection with FIG. 41, to associate the paid voucher information with the purchase requisition. It should be understood that a separate record in the format of Table 94 is stored in table 5 "tblPaidVoucherRecords" 1070 for each paid voucher. However, it should be understood that other information can be included, and the system is not limited to the specific information shown in Table 94. TABLE 94 10 Exemplary tblPaidVoucherRecords (db structure view) Column Name Data Type Length Invoice ID int 4 Buyer PR # varchar 20 PR Version numeric 9 Vendor PR # varchar 20 Approval Date datetime 8 Approver Name varchar 100 Approver Employee ID nvarchar 10 Time Card ID int 4 Expense Voucher ID int 4 Material Voucher ID int 4 ProjectExpenseVoucher_I int 4 D Deliverable Voucher ID int 4 Time Pay Voucher ID int 4 Unit Voucher ID int 4 Invoice Amount money 8 Account Assignment varchar 10 [Billable Dept/Cost Center] varchar 10 Accounting Plant varchar 10 Project Code varchar 20 166 Tax Code varchar 10 G L Account varchar 20 Currency ID int 4 File Extract Date datetime 8 Column Name Data Type Length EDI File Transmission Date datetime 8 Buyer Check Register Date datetime 8 Vendor Payment Date datetime 8 Vendor AP Register # varchar 20 Vendor Check # varchar 25 VendorCheck_IssuanceDa datetime 8 te Record ID int 4 Referring now to FIG. 51, there is illustrated a screen shot of an exemplary web page 61 showing the financial status of the project. This web page may be 5 accessible in one or more formats to the buyer, vendor and/or administrator, depending upon system constraints. As can be seen in FIG. 51, the different types of payment vouchers, and the estimated amount for each of the payment vouchers can be displayed. In addition, the actual amount expended for each of the payment voucher types and the estimated additional funds to be expended for 10 each of the payment voucher types can also be tracked. In this way, the buyer, vendor and/or administrator can maintain a working knowledge of the project performance from a financial perspective. However, it should be understood that other financial information can be displayed instead of or in addition to the specific financial information shown in FIG. 51. Furthermore, it should be understood that 15 other project tracking information (in lieu of or in addition to financial information) 167 can be displayed depending on the buyer, vendor, administrator and/or system configuration. As will be recognized by those skilled in the art, the innovative concepts described in the present application can be modified and varied over a wide range 5 of applications. Accordingly, the scope of patented subject matter should not be limited to any of the specific exemplary teachings discussed, but is instead defined by the following claims.

Claims (78)

1. A paperless web enabled electronic billing and payment method including: purchase-order processing by a buyer and supplier; voucher/payment request processing by a supplier; 5 voucher/payment request processing by the buyer; and billing data extract and payment processing by the buyer.
2. The method of claim 1, wherein the step of purchase-order processing further includes: creating, by a buyer, of a purchase order; and 10 wherein the purchase order is adapted to acquire and store line item specific elements of transactable commerce data.
3. The method of claim 2, wherein the step of the buyer creating the purchase order further includes acquiring and storing human resource labor types and associated rates, human resource expense types and associated spend 15 threshold, materials and associated costs, fixed price deliverables and associated costs, and unit-based deliverables and associated costs.
4. The method of claim 3, wherein the step of the buyer creating the purchase order further includes: the buyer designating partial or full financial data processing modes; 20 the buyer designating ancillary business data types and data values to be processed in conjunction with subsequent supplier voucher/payment request processing; and the buyer specifying approval routing schemas for subsequent submitted supplier voucher/payment line items. 25
5. The method of claim 2, wherein the step of the buyer creating the purchase order further includes: the buyer specifying an aggregate purchase order not-to-exceed spend threshold; the buyer specifying purchase order payment terms; 169 the buyer specifying purchase order active start and end dates; and the buyer specifying purchase order approval routing schema.
6. The method of claim 1, wherein the step of purchase-order processing further includes: 5 the buyer submitting a purchase order in process to a supplier; the supplier validating the accuracy of purchase order data; the supplier assessing and providing taxation data pertinent to purchase order line items; and the supplier submitting a supplier approved purchase order back to the 10 applicable buyer personnel.
7. The method of claim 6, wherein the step of purchase-order processing further includes: the buyer approving a supplier-validated purchase order; and the buyer making a purchase order active for supplier voucher/payment 15 request processing.
8. The method of claim 1, further including the supplier creating a voucher/payment request.
9. The method of claim 8, wherein the step of the supplier creating a voucher/payment request further includes: 20 systematically validating supplier input against purchase order line item data; the supplier inputting ancillary data as buyer configured; systematically validating buyer purchase-order specifyings; and the supplier submitting a systematic data validated voucher/payment 25 request to a buyer.
10. The method of claim 1, wherein the step of voucher/payment request processing by the supplier further includes systematically updating status and tracking of a submitted voucher/payment request. 170
11. The method of claim 1, wherein voucher/payment request processing by the buyer further includes systematically notifying a configured buyer user of a pending voucher payment request.
12. The method of claim 1, wherein the step of voucher/payment request 5 processing by the buyer further includes: the buyer approving or disapproving submitted voucher/payment request line items; and the buyer providing commentary regarding approval/rejection disposition
13. The method of claim 12, wherein the buyer voucher/payment request 10 disposition further includes systematically notifying the supplier regarding buyer voucher/payment disposition
14. The method of claim 12, wherein the buyer voucher/payment request disposition further includes: systematically updating individual voucher/payment request line items 15 status; and tracking of the individual voucher/payment request line items.
15. The method of claim 1, wherein the billing data extract and payment processing by the buyer further includes the buyer configuring the approved voucher/payment request line item data extract for subsequent creation of an 20 electronic billing/invoice file.
16. The method of claim 15, wherein the step of the buyer configuring the data extract further includes: the buyer specifying data extract frequency; the buyer specifying database fields for extract; 25 the buyer specifying database field extract format/layout; and the buyer specifying data record consolidation/separation premised upon acquired and stored transactional ancillary business data. 171
17. The method of claim 1, wherein payment processing by the buyer further includes specifying a financial data transfer protocol of the buyer.
18. The method of claim 17, wherein payment processing by the buyer further includes: 5 converting billing data file to the buyer's specified financial data transfer protocol; transmitting the converted billing file to buyer-specified personnel or data processing machine; uploading the converted billing file to a buyer financial system; 10 generating buyer payment; and the buyer systematically receiving the supplier payment record file
19. The method of claim 18, further including systematically utilizing full life cycle throughput data to enable perpetual purchase order and voucher/payment request data validation. 15
20. A project-work risk-management documentation method including: configuring an electronic temporary-laborer risk-management document library; wherein the step of configuring the temporary-laborer risk-management document library includes: 20 specifying a plurality of temporary-laborer risk-management documentation types, the plurality of documentation types being representative of documents that may need to be executed or provided by a temporary laborer; specifying a plurality of temporary-laborer types such that a temporary laborer is classified into a single one of the plurality of temporary-laborer types; 25 and mapping the plurality of temporary-laborer types to the plurality of temporary-laborer risk-management documentation types to determine, for each temporary-laborer type, which ones of the plurality of document types must be provided or executed by temporary laborers belonging to the temporary-laborer 30 type; 172 configuring a plurality of bid templates according to at least one project services type, the plurality of bid templates being usable for creation of buyer bid requests; wherein the configured plurality of bid templates comprise a plurality of 5 pre-specified bid items associated with specific types of information to be solicited from a vendor, the plurality of pre-specified bid items including the specified plurality of temporary-laborer types and plurality of temporary-laborer risk management documentation types; responsive to a bid request based on a particular bid template in the 10 plurality of bid templates, receiving, from a vendor, a temporary-laborer record; wherein receipt of the temporary-laborer record is conditioned on approval by at least one pre-configured approver, the approval being based, at least in part, on a pre-defined appropriate vendor response to at least one bid item of the particular bid template; 15 providing at least one temporary-laborer document; administering a temporary-laborer agreement; and wherein the step of configuring the temporary-laborer risk-management document library, the step of configuring the plurality of bid templates, the providing step, and the administering step are implemented by a computer 20 system.
21. The method of claim 20, wherein the at least one pre-configured approver is pre-defined according to user roles and characteristics of the at least one bid item on which approval is based.
22. The method of claim 20, wherein the step of specifying risk-management 25 temporary laborer documentation types includes: defining bid-template-based temporary-laborer executable agreements; and configuring bid-template-based temporary laborer executable agreement content. 173
23. The method of claim 20, wherein the step of providing the at least one temporary-laborer document includes providing pre-defined bid-template-based agreement and documentation requirements to a temporary laborer in accordance with the mapping of temporary-laborer types to temporary-laborer 5 documentation types.
24. The method of claim 23, further including: verifying that each of a plurality of documents of the provided pre-defined bid-template-based agreement and documentation requirements has been properly executed; 10 storing data regarding the effective date of each of the plurality of documents; and setting a tickler date for any of the plurality of documents that will need to be renewed in the future.
25. The method of claim 20, wherein the step of administering the temporary 15 laborer agreement includes: systematically storing and tracking temporary-laborer resource documentation transactional data; and based on the stored and tracked temporary-laborer resource documentation transactional data, periodically determining whether temporary 20 laborer resource-documentation requirements are being met.
26. The method of claim 25, wherein the storing and tracking step includes administering temporary-laborer resource system access and right-to-work permission based on the determining step indicating that a previously provided temporary-laborer document is no longer valid or needs to be renewed. 25
27. The method of claim 20, wherein: the project services type includes at least one of consulting, staff supplementation, and project services; and bid items included within a given bid template of the plurality of bid templates are selected in light of the project services type applicable to the given 30 bid template. 174
28. The method of claim 20, wherein the plurality of prespecified bid items comprise at least one mandatory bid item that includes at least a project-services type identifier.
29. The method of claim 20, wherein, provided pre-defined approvals are 5 obtained, any bid item may be added to or removed by a buyer soliciting bids using a bid template of the plurality of bid templates.
30. The method of claim 20, wherein the project services type is selected by the buyer from a pre-established plurality of project services types.
31. The method of claim 20, wherein the project services type is selected from 10 the group consisting of consulting, staff supplementation, and project services.
32. The method of claim 31, wherein each bid template is segmented into a plurality of project sector types, the plurality of project sector types defining a technical or professional discipline of project work to be performed pursuant to the bid template. 15
33. The method of claim 32, wherein each project sector type is segmented into a plurality of project family types, the plurality of project family types for each project sector type including a plurality of the following: enterprise-resource solutions; e-business solutions; 20 telecommunications; technical-integration solutions; network-management solutions; custom software development; business-strategy/planning solutions; 25 human-resource solutions; audit/assurance solutions; financial advisory solutions; tax solutions; risk-management solutions; 175 real-estate services; legal services; engineering services; building/construction services; and 5 product development.
34. The method of claim 20, wherein at least one of the plurality of bid items contains displayed default data.
35. The method of claim 20, wherein the plurality of pre-specified bid items are included within a given configured bid template according to project services type, 10 project sector type and project family type.
36. A method of managing a business process work flow, the method including: establishing defined functional user-role positions within a data processing environment; 15 enabling process specification via status code/condition management; mapping the user-role positions to at least one process; performing real-time process management; and enabling specific process transaction management.
37. The method of claim 36, wherein the step of establishing the defined 20 functional user-role positions further includes: creating user role positions; storing the user-role position records in a database; establishing personnel qualifier criteria for user role position authority; storing the personnel qualifier criteria in a database; 25 integrating personnel records into the user role system; wherein the personnel records contain at least one the personnel qualifier criteria; systematically mapping the personnel records to the user role positions based upon a qualifier data comparison between the user role qualifier criteria 30 and the personnel qualifier criteria; and 176 storing the affiliations in a database.
38. The method of claim 37, further including: manually affiliating the personnel records to the user role positions; and storing the affiliations in a database. 5
39. The method of claim 37, further including a shared work environment profile function, the shared work environment profile function including a user interface adapted to permit the user to: view a listing of all created user role positions in the environment; select a specific user role position; 10 view a listing of all users authorized to function in the user role position; and select a specific personnel record to be stored in the database as the default user role position personnel record to be used by the system while processing transactions associated with the user's shared work environment 15 profile.
40. The method of claim 36, wherein the step of enabling process specification further includes: establishing distinct legs for at least one of the following core work flow processes: 20 supplier business information review; supplier business insurance review; supplier agreements review; supplier provision capabilities review; human resource work qualification review; 25 human resource agreements review; RFx bid processing; RFx bid response processing; Rx bid response analysis/disposition; purchase requisition processing; purchase order processing; 30 work acknowledgement voucher processing; 177 electronic invoice file processing; and business configuration data processing; and storing the process legs in a database.
41. The method of claim 40, further including the steps of: 5 configuring a process status code/condition for each the process leg; configuring functional user actions that can be taken at each process leg; wherein each configured action taken by a user results in a process status designation; and configuring the functional user actions available for each dependent 10 process leg while the process leg is in a particular status; and storing all settings therein in a database.
42. The method of claim 36, wherein the step of mapping the user-role positions to at least one process further includes specifying user-role-position access rights and action permissions at individual work flow pages. 15
43. The method of claim 36, wherein the step of performing real-time process management further includes displaying, via an administrative dashboard, a current status of a specific process, current authorized actions relative to the process, and a listing of configured users permitted to take the authorized actions. 20
44. The method of claim 43, wherein the step of performing real-time process management further includes systematically notifying personnel serving as authorized user role positions for specific process transactions of pending actions available to be taken by the user with respect to the specific process transactions.
45. The method of claim 43, wherein the step of performing real-time process 25 management further includes providing to a user a chronological time review indicating total duration of the process legs of the process from start to current status and time frames to each processing leg associated with the process. 178
46. The method of claim 36, wherein the step of enabling specific process transaction management further includes: storing and tracking relationships between user role positions, personnel identity, and process transactions in the database; and 5 systematically displaying the relationships to users affiliated with the transactions.
47. The method of claim 46, wherein the step of enabling specific process transaction management further includes substituting the identity of specific users affiliated with specific transactions with alternate personnel meeting necessary 10 user-role qualification parameters.
48. The method of claim 47, wherein the step of substituting the identity of specific users further includes performing at least one of: substituting one personnel record for another respective to all user role positions respective to all applicable transactions; 15 substituting one personnel record for another respective to selected user roles in conjunction with all applicable transactions; substituting one personnel record for another respective to selected transactions and all applicable user roles; and substituting one personnel record for another respective to selected 20 transactions and selected applicable user role positions affiliated with the selected transactions.
49. The method of claim 48, wherein all of the user role position personnel modifications/updates are stored in a database.
50. The method of claim 46, further including: 25 reflecting the user role position personnel modifications in the administrative dashboard; and wherein affected user personnel records result in systematic messages to the personnel regarding their modified user role relationship to the process transactions. 179
51. A human resource time keeping, expense management, and work acknowledgement method including: creating and storing by a buyer of a purchase order record; validating, by a supplier, of data of the purchase order record; 5 enabling, by the buyer, of supplier human resource access to the voucher system; enabling supplier human resource data input into a time keeping/work acknowledgement voucher tracking and submittal system; enabling buyer review and disposition of a submitted supplier work 10 acknowledgement voucher; and enabling an automated bill/pay function.
52. The method of claim 51, further including associating a human resource labor assignment record with a supplier/contractor purchase order.
53. The method of claim 52, further including configurably specifying human 15 resource labor assignment attributes stored in the system in the form of at least one of purchase order line items and purchase order sub-line items.
54. The method of claim 53, further including configurably specifying: authorized human resource work assignment time related labor types; authorized human resource labor work assignment time related labor units; 20 authorized human resource labor cost rates applicable to authorized time related labor types; and whether the authorized time related labor type and cost record is billable or non-billable.
55. The method of claim 53, further including configurably specifying: 25 authorized human resource work assignment non-time related labor types; authorized human resource labor work assignment non-time related labor units; authorized human resource labor cost rates applicable to authorized non time related labor types; and 180 whether the authorized non-time related labor type and cost record is billable or non-billable.
56. The method of claim 53, further including configurably specifying: authorized human resource work assignment expense types; 5 configurable specification of authorized human resource maximum expense per occurrence applicable to authorized work assignment expense types; and authorized human resource aggregate maximum expense applicable to authorized work assignment expense types. 10
57. The method of claim 53, further including specifying ancillary data fields affiliated with at least one of purchase order line items and purchase order sub line items to be completed by the human resource laborer upon submission of a work acknowledgement voucher.
58. The method of claim 52, further including: 15 associating a human resource labor record with a skill profile; and wherein the resource skill profile attributes are selected from hierarchical pre-established lists of resource types and skills to classify the resource profiles in a non-prose fashion.
59. The method of claim 52, further including configurably specifying purchase 20 order attributes stored in the system.
60. The method of claim 58, further including specifying: a purchase order not to exceed currency threshold amount; purchase order activation start and end dates; and purchase order work acknowledgement voucher submittal frequency. 25
61. The method of claim 51, further including submitting, by a buyer/administrator, the purchase order record to the supplier/contractor for data validation and acceptance. 181
62. The method of claim 61, further including submitting, by a supplier/contractor, the validated purchase order record back to the buyer/administrator for purchase order activation.
63. The method of claim 62, further including activating, by a 5 buyer/administrator, the validated purchase order.
64. The method of claim 51, wherein the step of enabling further includes assigning system access credentials for the supplier human resource laborer(s) affiliated with the validated and active purchase order.
65. The method of claim 64, wherein the step of enabling further includes 10 transmitting the system access credentials to the human resource laborer(s)
66. The method of claim 51, further including: a supplier/contractor accessing the work acknowledgement voucher system; the supplier/contractor selecting from available active and authorized 15 purchase orders a specific record for data processing; and the supplier/contractor performing at least one of: selecting from authorized time related labor types a specific time related labor type record for data processing; selecting from authorized non-time related labor types a specific non-time 20 related labor type record for data processing; and selecting from authorized expense types a specific expense type record for data processing.
67. The method of claim 66, further including: supplier/contractor inputting work acknowledgement details applicable to at 25 least one of: time; deliverable completion; unit completion; and 182 expense incursion as configured applicable to the purchase order assignment attributes; and storing the settings in a database.
68. The method of claim 66, further including supplier/contractor submitting 5 the work acknowledgement voucher to the buyer/administrator for the purpose of processing the work acknowledgement voucher.
69. The method of claim 59, further including systematically validating data pertaining to configured purchase order attributes.
70. The method of claim 69, further including a step whereby a failure of the 10 system to validate the purchase order attributes respective of supplier/contractor data processing results in a negative submittal to the buyer/administrator wherein the supplier/contractor is notified of the validation failure.
71. The method of claim 70, further including modifying, by the supplier/contractor upon notification of the system to validate and submit the work 15 acknowledgement voucher, data input to reconcile the data validation failure.
72. The method of claim 51, further including: reviewing, by a buyer/administrator, a submitted work acknowledgement voucher; and performing, by the buyer/administrator, a step selected from the group 20 consisting of: approving the submitted work acknowledgement voucher; and declining the submitted work acknowledgement voucher.
73. The method of claim 72, further including buyer/administrator approval/declination disposition enablement for individual work acknowledgement 25 voucher line item entries and specification of partial credit/acceptance for individual work acknowledgement voucher line item entries. 183
74. The method of claim 73, further including buyer/administrator systematic notification to the supplier/contractor regarding work acknowledgement line item disposition.
75. The method of claim 72, further including buyer/administrator systematic 5 routing for additional approvals as business rule configured.
76. The method of claim 51, further including systematically extracting the approved work acknowledgment voucher line items on a configured/scheduled basis for the purposes of enabling a paperless bill/pay process.
77. The method of claim 76, further including: 10 systematically generating a billing/invoice file in a data format configured by the buyer/administrator; systematically transmitting the billing/invoice file in a specified format/protocol to a specified authorized Buyer financial data processor; and receiving from the buyer financial data processor a cash payment file in a 15 pre-configured format so as to systematically apply the cash payments to the work acknowledgement voucher and respective line items.
78. The method of claim 77, further including systematically utilizing full life cycle throughput data to enable perpetual work assignment and purchase order attribute data validation. 20 VOLT INFORMATION SCIENCES, INC WATERMARK PATENT & TRADE MARK ATTORNEYS P25258AU02
AU2013201445A 2002-04-10 2013-03-12 Computer system and method for facilitating and managing the project bid and requisition process Abandoned AU2013201445A1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU2013201445A AU2013201445A1 (en) 2002-04-10 2013-03-12 Computer system and method for facilitating and managing the project bid and requisition process

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US10/262,487 2002-09-30
AU2010200800A AU2010200800A1 (en) 2002-04-10 2010-03-03 Computer System and Method for Facilitating and Managing the Project Bid and Requisition Process
AU2013201445A AU2013201445A1 (en) 2002-04-10 2013-03-12 Computer system and method for facilitating and managing the project bid and requisition process

Related Parent Applications (1)

Application Number Title Priority Date Filing Date
AU2010200800A Division AU2010200800A1 (en) 2002-04-10 2010-03-03 Computer System and Method for Facilitating and Managing the Project Bid and Requisition Process

Publications (1)

Publication Number Publication Date
AU2013201445A1 true AU2013201445A1 (en) 2013-03-28

Family

ID=47919150

Family Applications (1)

Application Number Title Priority Date Filing Date
AU2013201445A Abandoned AU2013201445A1 (en) 2002-04-10 2013-03-12 Computer system and method for facilitating and managing the project bid and requisition process

Country Status (1)

Country Link
AU (1) AU2013201445A1 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113554324A (en) * 2021-07-28 2021-10-26 重庆允成互联网科技有限公司 Production process withdrawal method, system, equipment and storage medium

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113554324A (en) * 2021-07-28 2021-10-26 重庆允成互联网科技有限公司 Production process withdrawal method, system, equipment and storage medium
CN113554324B (en) * 2021-07-28 2022-02-25 重庆允成互联网科技有限公司 Production process withdrawal method, system, equipment and storage medium

Similar Documents

Publication Publication Date Title
AU2002318884B2 (en) Computer system and method for facilitating and managing the project bid and requisition process
US8204820B2 (en) Computer system and method for producing analytical data related to the project bid and requisition process
JP5172354B2 (en) Project information planning / scope change management information and business information synergy system and method
US7321864B1 (en) System and method for providing funding approval associated with a project based on a document collection
US7685013B2 (en) System and method for automatic financial project management
US8364557B2 (en) Method of and system for enabling and managing sub-contracting entities
US20040073507A1 (en) Method and system for providing international procurement, such as via an electronic reverse auction
US20080300933A1 (en) System and method for facilitating strategic sourcing and vendor management
US20010011222A1 (en) Integrated procurement management system using public computer network
WO2008069834A2 (en) System, method, and software for a business acquisition management solution
WO2001071546A2 (en) Using lead-times and usage rates to determine inventory reorder points and levels
US20040059583A1 (en) Temporary staff order and management system
WO2001025987A1 (en) System for hiring and engagement management of qualified professionals
AU2013201445A1 (en) Computer system and method for facilitating and managing the project bid and requisition process
AU2012202421A1 (en) Project Work Change in Plan/Scope Administrative and Business Information Synergy System and Method
Deshmukh The Expenditure Cycle
Note REQUEST FOR PROPOSAL STATE OF CONNECTICUT RFP Number

Legal Events

Date Code Title Description
PC1 Assignment before grant (sect. 113)

Owner name: IQNAVIGATOR, INC

Free format text: FORMER APPLICANT(S): VOLT INFORMATION SCIENCES, INC

MK4 Application lapsed section 142(2)(d) - no continuation fee paid for the application