Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1999-08-04
2003-03-18
Homere, Jean R. (Department: 2177)
Data processing: database and file management or data structures
Database design
Data structure types
C717S109000, C717S113000, C345S215000, C345S215000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
06535883
ABSTRACT:
FIELD OF THE INVENTION
The present invention generally relates to a system and method for validating data collected by application software, and more particularly to a graphical user interface for creating validation rules which confirm the validity of data collected by application software used in mobile workforce management.
BACKGROUND OF THE INVENTION
In many industries which employ a large mobile workforce, such as utilities, taxi companies, and large equipment repair services, the efficiency with which mobile workers can be scheduled and dispatched to customers can have a great impact on customer satisfaction as well as on a service provider's bottom line. From the customer satisfaction standpoint, it is not uncommon for a customer to call a cable television company, or other service provider, to request service only to be told to choose a four-hour service window on good days, or an “all day” service window on bad days. Even when the customer is “lucky” enough to request service on a “good” day, the worker dispatched by the service provider typically will arrive well after the window has closed, or the customer will have waited, and wasted, most of the day for what should typically only be a half-hour service call. This situation arises from an inability of the service provider to accurately predict when a particular worker will complete a given task and how long it will take for the worker to reach the next service location.
From the financial standpoint, inefficient scheduling and dispatching results in fewer service calls being performed each day, potentially resulting in lower earnings per worker-hour, as well as possible additional expenditures required for hiring and training additional workers. To improve scheduling and dispatching, many service providers have implemented a documentation process for collecting information pertinent to a service request. Each business typically has its own unique set of paper service forms, each having a number of relevant fields in which the worker inputs data as the service job is being performed. As with the collection of any kind of information, certain types, formats, and/or ranges of information are expected for certain fields. For instance, a field for “arrival time” must be completed with a time of day, and would be expected to fall during or near normal work hours. When workers complete the paper forms, the worker must remember certain rules or guidelines for filling out the fields. If the rules are followed properly, the forms are correctly filled out and the service provider is given accurate information with which to analyze its business, e.g., modify schedules, dispatch additional workers, etc. Often, however, the worker makes mistakes when filling out the forms which are only discovered after the worker returns to a business site (e.g., a dispatch office) at the end of the day, turns in the forms for the day's service requests, and the forms are reviewed. By the time the errors are discovered, many hours or even days may have passed, making it difficult to correct the errors and perhaps invalidating any scheduling or dispatching adjustments previously made based on the incorrect information.
More recently, computerized systems have been developed which have replaced the paper forms with electronically stored and implemented forms. Typically, in such systems, a centralized server computer including all business logic and having access to the necessary databases communicates via a wireless or other type network with a mobile client computer carried by a worker. Both paper forms and their electronic equivalents have fields for entering data desired for a particular service task, as well as a heading labeling each field and perhaps some instructional information. The mobile computer includes application software, such as a mobile pen application (MPA), which electronically implements the service forms of a particular service provider to allow the worker to enter various data concerning each service job. The MPA for electronically implementing a particular form includes fields for entering data, the heading for each field of the form and any instructional information. Data entered into the fields is sent back to the centralized server computer where the worker's schedule may be updated, if necessary, based on such factors as whether a job took more or less time than anticipated, or whether an emergency service must be scheduled for a worker who is geographically near the emergency service site. The mobile computer typically also includes Global Positioning System (GPS) capabilities to allow the central computer to precisely track the geographic location of the worker.
In order to ensure the validity of the data entered by the worker, some or all of the fields will have an associated validation rule. A validation rule is simply a logical sequence of operators and operands for performing one or more tests or comparisons on data in one or more fields to make sure the data is valid. The MPA implements a particular form using a set of validation rules to ensure correct entry of data. The validation rules are loaded into the MPA, and validation rules associated with fields in the rules file are associated with the corresponding field names in the MPA. The validation rules test the contents of each field entered by the user to ensure that the field is filled out correctly, either after the worker enters data into a the field, or after the form is transmitted back to a centralized server computer. Either way, errors are caught before the worker leaves the service site.
Due to each service provider having its own unique set of service forms, each service provider must undergo a lengthy, inefficient process for determining the validation rules appropriate for each form and for the MPA in which the forms are implemented. Typically, this has meant that an MPA analyst, an engineer or project manager, will go to the service provider's business site, and work with the employees of the service provider to specify, for each field of a form any rules, which may include rules of thumb, that a worker follows when filling out the fields. The MPA developer, a programmer who writes code for implementing the validation rules, then takes the specified rules and creates a set of validation rules in MPA-compatible code which is saved as a rules file for the form. This validation rule creation process can take several weeks and require many hours from the MPA developer and from the employees of the service provider.
Consequently, what is needed is a user-friendly, computer-based system and method for quickly and easily creating sets of validation rules to thereby shorten the validation rules creation process. The system and method should be independent of the type or nature of both the form being validated as well as the particular MPA being implemented. As explained in the following, the present invention provides a method and apparatus that meets these criteria and solves other problems in the prior art.
SUMMARY OF THE INVENTION
The present invention is a user-friendly, computer-based system and method for quickly and easily creating sets of validation rules for forms. A graphical user interface (GUI) is provided which may be used at a business site by the service provider's employees to develop sets of validation rules using a natural language. The GUI of the present invention displays a representation of a form as a tree structure, with the root node representing the name of the form, and the leaf nodes for representing fields of the form. The user begins by selecting a form template, which is a template for creating and completing a set of validation rules for fields for a form. A form template is a text file including the name of the form and the names of the used fields for the form. The names in the form template are used by the GUI to display the tree representation. The number of field names is used to determine the number of leaf nodes for the tree. The system of the present invention loads in a selected form temp
Brown Michael Shane
Lee Joo-Hyung
Roesler Randolph D.
Dorsey & Whitney LLP
Homere Jean R.
MDSI Software Srl
Wassum Luke S
LandOfFree
System and method for creating validation rules used to... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for creating validation rules used to..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for creating validation rules used to... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3036198