CROSS REFERENCES TO RELATED APPLICATIONS This application claims the priority of U.S. Provisional Patent Application No. 60/218,684, filed on Jul. 17, 2000 and entitled “SYSTEM AND METHOD OF CONTROLLING REGULATED PESTICIDE AND FERTILIZER PRODUCTS,” U.S. patent application Ser. No. 09/603,737, filed on Jun. 23, 2000, and entitled “METHOD AND SYSTEM OF TRACKING AND REPORTING PESTICIDE SALES,” and U.S. patent application Ser. No. 09/662,492, filed on Sep. 15, 2000, and entitled “SYSTEM AND METHOD OF PROVIDING AGRICULTURAL PESTICIDE INFORMATION AND FACILITATING SALES OF PESTICIDE PRODUCTS,” the entirety of each of which is hereby incorporated by reference for all purposes as if fully set forth herein.
BACKGROUND OF THE INVENTION 1) Field of the Invention
The present invention relates generally to the field of agriculture and more particularly to a method and system for managing agricultural information, and for facilitating the controlled sale, distribution, and use of agricultural products, including pesticides and fertilizers.
2) Description of the Related Art
The U.S. Department of Agriculture regulates agricultural products, weights and measures, and dealers and applicators of agricultural products. As used herein, the term “agricultural products” is understood to refer generally to pesticide products and fertilizers, feeds (e.g., dog food, cattle feed, etc.), seeds, dairy products, and crops, including specifically but without limitation, regulated pesticide and fertilizer products.
Though often misunderstood to refer only to insecticides, the term “pesticide” also applies to herbicides, fungicides, and various other substances used to control pests. As broadly used herein, pests include insects, mice and other animals, unwanted plants (weeds), fungi, or microorganisms like bacteria and viruses. Pesticides are useful to society because of their ability to kill potential disease-causing organisms, control insects, weeds, and other pests. At the same time, by their very nature, most pesticides create some risk of harm to humans, animals, or the environment because they are designed to kill or adversely affect living organisms.
Accordingly, in many countries, the sale and/or use of agricultural products is regulated by various government agencies.
Within the United States, the Environmental Protection Agency (EPA) provides a federal or national level of regulation of pesticide products. The EPA defines a pesticide as any substance or mixture of substances intended for preventing, destroying, repelling or mitigating any pest. Under United States law, a pesticide is also any substance or mixture of substances intended for use as a plant regulator, defoliant, or desiccant. Drugs used to control diseases of humans or animals (such as livestock and pets) are not legally considered pesticides. Fertilizers, nutrients, and other substances used to promote plant survival and health are not considered plant growth regulators and thus are not pesticides.
The EPA regulates pesticides by developing and implementing policies which require testing to assess pesticide safety, as well as requiring registration and proper labeling of pesticides. The EPA further maintains a database of federally registered pesticide products and assigns an EPA identification code (EPA ID) to each federally registered pesticide product. For each federally registered pesticide product, the EPA database includes the EPA ID, pesticide type (e.g., herbicide, fungicide, insecticide, disinfectant, etc.), and a list of active ingredients in the pesticide product.
Also, for certain restricted use pesticide (RUP) products, the federal government requires each state to license all dealers and applicators. RUP products may not be legally sold to or used by individuals who are not licensed or certified. Similarly, RUP products may only be sold within a state by a dealer which has been licensed in the state. Generally, these RUP products include pesticides intended for widespread agricultural or industrial use and which may, if used improperly, present a serious threat to public health and/or the environment.
The states, on a state-by-state basis, provide a second level of regulation of pesticides by requiring approval for the sales and use of pesticides. Different states have their own procedures for approval and registration of pesticide products. Also, various states require all dealers and applicators to be licensed for certain state restricted use pesticide (S-RUP) products and state limited use products (SLUP). SLUP includes products which may be legally purchased & used in small quantities (e.g., 16 oz or less) but which require a license to be purchased and used in large quantities. There are also special local need (SLN) products which are pesticides intended to address a specific crop or problem in a specific area and which may, if used improperly, present a serious threat to public health and/or the environment. S-RUP and SLN products may not be legally sold to or used by unlicenced individuals within these states.
This invention is directed toward improved methods and systems of managing agricultural product information, and for facilitating the controlled sale, distribution, and use of agricultural products, including pesticide products. The systems and methods disclosed herein are especially useful for governmental entities (e.g., states) and their designated agencies to administer the registration and renewals of approved agricultural products, the licensing of dealers and applicators, the tracking and reporting of pesticide usage, field inspection and enforcement of agricultural product control laws, facilitating the sale of restricted use pesticide (RUP) products, reporting and disseminating information to interested parties, and tax collection (e.g., feeds, fertilizer, seeds, etc.).
SUMMARY OF THE INVENTION It is an object of the present invention to provide a method and system for managing agricultural product information, and for facilitating the controlled sale, distribution, and use of agricultural products.
Other objects and advantages will become apparent to those skilled in the art from a review of the ensuing description which proceeds with reference to the following illustrative drawings.
BRIEF DESCRIPTION OF THE DRAWINGSFIG. 1 is a block diagram of a computer network for illustrating one or more aspects of the present invention;
FIG. 2A is a block diagram of an agricultural product management computer system;
FIG. 2B is a block diagram illustrating a preferred embodiment of the memory associated with a CPU of the agricultural product management computer system;
FIG. 3 is a top level diagram illustrating interrelationships between various components of a system managing agricultural product information, and for facilitating the controlled sale, distribution, and use of agricultural products;
FIG. 4 is a flowchart of a preferred embodiment process of field inspection and enforcement of registration requirements for agricultural products;
FIG. 5 is a flowchart of a preferred embodiment process of reporting pesticide use;
FIG. 6 is a flowchart of a preferred embodiment process of licensing pesticide dealers and pesticide applicators;
FIG. 7 is a flowchart of a preferred embodiment process for renewing registrations of agricultural products;
FIG. 8 is a flowchart of a preferred embodiment process for submitting new agricultural products for registration;
FIG. 9 is a flowchart of a preferred embodiment process for managing documents of an agricultural product management computer system;
FIG. 10 is a flowchart of a preferred embodiment of an automated back-end process for verifying pesticide dealer and applicator licenses in support of Internet pesticide sales;
FIG. 11 is a flowchart of a preferred embodiment process for a state or other government agency to register pesticide products;
FIG. 12 is a flowchart of a preferred embodiment process for a state or other government agency to register fertilizer products;
FIGS.13A-C show various databases used in a preferred embodiment system and process for managing agricultural product information, and for facilitating the controlled sale, distribution, and use of agricultural products;
FIG. 14 is a diagram showing a database structure and interrelationships of government environmental protection agency (EPA) pesticide data in the database;
FIG. 15 is a flowchart showing how UPC data may be updated in a state product database.
DESCRIPTION OF THE PREFERRED EMBODIMENTS As used herein, the term “plant” is understood to broadly describe a variety of forms of plant life, including plants, trees, shrubs, grasses, vines, flowers, and the like.
The term “pest(s)” as used herein is understood to include insects, mice and other animals, unwanted plants (weeds), fungi, or microorganisms like bacteria and viruses. A “pesticide” is understood to include insecticides, herbicides, fungicides, and other substances used to control pests. “Agricultural products” are understood to include pesticides, fertilizers, feeds (e.g., dog food, cattle feed, etc.), seeds, dairy products, and crops, including specifically but without limitation, regulated pesticide and fertilizer products.
The present invention will be discussed with reference to preferred embodiments in the form of a computer program. Numerous specific details, such as specific user queries, the order of the queries, etc. are set forth in order to provide a thorough understanding of the present invention. The preferred embodiments described herein are for the purposes of illustration only and should not be understood to limit the invention.
The embodiment(s) will be discussed with reference to flowcharts. The flowcharts make numerous mentions of querying a user for information. This act may be performed in a number of different ways. For example, in a preferred embodiment, the methods and systems described herein are practiced via an Internet site. In such an embodiment, the act of querying is performed by presenting a user with a number of choices that the user may “click” on to indicate a response. Such choices may be presented textually, such as by providing a number of hypertext links that move the user to a different portion of a hypertext document or different documents; or graphically. Many other embodiments are also contemplated.
Also, the preferred embodiments are discussed with respect to the operations of a state government agency in the United States. In other countries, the methods and systems described herein for managing agricultural product information, and for facilitating the controlled sale, distribution, and use of agricultural products may be operated by different governmental bodies (provinces; municipalities; etc.) and government agencies, as the laws in those areas dictate. Accordingly, the broad applicability and scope of the invention should not be limited to the existing governmental regulatory framework in the United States.
A preferred embodiment of acomputer network100 which may be used to manage agricultural product information, and for facilitating the controlled sale, distribution, and use of agricultural products according to one or more aspects of the present invention is shown inFIG. 1. Thecomputer network100 includes a plurality ofuser computers110 connected by theInternet120 with an agricultural productmanagement computer system130.
Auser computer110 preferably includes a central processing unit (CPU), memory, a communication device such as a modem, and data input/output device(s), such as a display monitor, a keyboard/keypad, a mouse, a speaker, etc. Theuser computer110 may operate and be connected in a separate computer network, such as a corporate intranet. Theuser computer110 may be a standalone multipurpose computer, such as a MACINTOSH™ or WINDOWS™ based personal computer (PC), but it may take a variety of other forms as well. For example, theuser computer110 may be an Internet appliance, a television-based Internet access system, a cellular telephone, a personal digital assistant, or any other suitable intelligent peripheral which may allow a user to access information via a computer network.
FIG. 2A is a block diagram of an agricultural productmanagement computer system130. In a preferred embodiment, the agricultural productmanagement computer system130 includes at least oneCPU205 having associated therewithmemory210 and a massdata storage device215, and optionally adisplay device220, a data input device225 (e.g., keyboard; mouse), and anetwork connection device230, all connected to each other via acommunication bus235. Thedata storage device215 includes nonvolatile data storage means, such magnetic disk drive units, optical disk drive units, removable disk drive units, tape media, or any combination thereof. Thenetwork connection device230 includes hardware and software for establishing a data link connection between the agricultural productmanagement computer system130 anduser computer110 via theInternet120. Preferably, theinterconnection circuitry120 is the Internet and thenetwork connection device230 includes circuitry to tie directly to the Internet via T1, T4 or similar high bandwidth data lines as would be understood by one skilled in the art.
The agricultural productmanagement computer system130 may include two or more integrated computer units, each having aseparate CPU205 having associated therewithmemory210 and/or a massdata storage device215, and optionally adisplay device220 and a data input device (e.g., keyboard; mouse)225. Thecommunication bus235 may include two or more internal buses for integrated computer units, together with an external bus connecting two or more integrated computer units.
FIG. 2B is a block diagram illustrating a preferred embodiment of thememory210 associated with aCPU205 of the agricultural productmanagement computer system130. Thememory210 includes modules of a software application for hosting an agricultural product management Web site. The software application and its modules may also be stored on another computer readable medium associated with the agricultural productmanagement computer system130, such as compact disc read-only memory (CD-ROM) devices, tapes, or similar non-volatile devices.
Thememory210 is in communication with thecommunication bus235, and preferably comprises anoperating system252, including akernel254, acommunication module256, aWeb server module258, adatabase administration module260, and any desiredapplication programs262. Thememory210 is preferably a random access memory, but may also include read-only memory.
Theoperating system252 preferably is WINDOWS NT®, but may be UNIX, DOS, MACINTOSH® Operating System, LINUX, SOLARIS®, or any other suitable operating system. Thememory210 also may include a variety of different application programs272, including for example, word processing programs, spreadsheet programs, database programs, etc.
Thecommunication module256 facilitates communications between the agricultural productmanagement computer system130 and one ormore user computers110 vianetwork connection device230 and theInternet120. In that case, the communication module266 preferably includes a File Transfer Protocol (FTP)proxy server282, a Simple Mail Transfer Protocol (SMTP)proxy server284, and a Hyper Text Transfer Protocol (HTTP)proxy server286.
TheWeb server module258 may host a plurality of Web pages and provide these Web pages to a Web browser resident on auser computer110 via theHTTP proxy server286.
Thedatabase administration module260 preferably manages databases such as a pest database, a plant database, a pesticide product database, a fertilizer product database, a seed product database, a dealer database, an applicator database, an ingredients database, etc. at the agricultural product management Web site. The database may be SQL, Oracle, Access, or other convenient format. The databases may be stored in the massdata storage device215 and/or thememory210.
FIG. 3 illustrates interrelationships between various components of a system for managing agricultural product information, and for facilitating the controlled sale, distribution, and use of agricultural products.FIG. 3 illustrates that an agricultural product management computer system preferably includes both intranet and extranet components.
As shown inFIG. 3, actual initial pesticide product approvals, registration enforcement, licensing, and use reporting may preferably be accomplished via an intranet component of the agricultural product management computer system. Access to such an intranet portion may be limited to authorized employees or agents of the state government. Preferably, the intranet components are only accessible over a private computer network and are well isolated from extranet components so that hackers may not obtained unauthorized access to these intranet components.
Meanwhile, license renewals, product registration renewals, and validation of licensing information in support of on-line (e.g., Internet) sales of pesticide products, and other functions may preferably be accomplished via an extranet component of the agricultural product management computer system. In the preferred embodiment, these functions and associated software components may be accessible via the Internet.
FIG. 4 is a flowchart of apreferred embodiment process400 of field inspection and enforcement of registration requirements for agricultural products. According to one feature, government (e.g., state) field inspectors may update a master agricultural products database by scanning universal product code (UPC) bar codes on the packages of pesticide products he/she finds on retailer shelves during field inspections. The process includes safeguards to prevent erroneous data entries and includes a self-learning update process, as described below.
In thepreferred embodiment process400, UPCs for agricultural products are “learned” and a master agricultural products database stored at the agricultural productsmanagement computer system130 is automatically updated to include new agricultural product information obtained during field inspections.
In afirst step402, a field inspector downloads product and UPC data stored in databases to a portable data terminal or data processing device, such as a laptop computer, personal digital assistant, palmtop device, or similar device having a processor, memory and data input/output device(s) (e.g, keypad, keyboard, display, etc.). Preferably, there are separate linked databases for products and UPCs—an agricultural products portable database and a product UPC portable database. The agricultural products portable database comprises data records for agricultural products, including registered and approved agricultural products, pending agricultural products, cancelled agricultural products, etc. In a preferred embodiment, the agricultural products portable database includes several data fields for each data record, including an ID field, a Product Name field, an EPA ID field, product status field and an expiration date field. The agricultural products portable database is linked to the product UPC portable database with each entry having an ID field, a UPC field, and a size field. Hereafter the linked agricultural products portable database and product UPC portable database are jointly referred to as the portable database.
The portable database may be downloaded to the portable data terminal from the agricultural productsmanagement computer system130. In a preferred embodiment, the agricultural productsmanagement computer system130 includes a master agricultural products database which may be the product UPC (PRODUPC)database1330 shown inFIG. 13A. The portable database may be downloaded by e-mail, by direct computer network connection, by wireless data link, or by other suitable means. Preferably, periodically (e.g., daily) the field inspector downloads either a completely new (updated) portable database, or a supplement of additional records from the product UPC (PRODUPC)database1330.
In astep404, the field inspector uses an optical bar code reader to scan a UPC bar code of an agricultural product on a store shelf. The bar code reader is connected with the portable data terminal and communicates the bar code UPC to the portable data device for further processing by the processor in the portable data terminal.
In astep406, the bar code UPC is looked-up in the portable database. If the UPC is found in the portable database, then the corresponding product is determined to be an approved product and the process continues at the step430 below.
If the bar code UPC is not found in the portable database, then it is still possible that the agricultural product already exists in the portable database, but the database record does not include a UPC in the UPC field. Therefore, in astep408, the first six (6) digits of the bar code UPC are checked to determine whether they match the first six (6) digits of any of the UPCs stored in the product UPC database. The first six digits of a UPC correspond to a manufacturer code. Accordingly, if there is a match for the first six digits with a product in the portable database, then the manufacturer can be determined. The manufacturer may be used to locate the agricultural product corresponding to the bar code UPC in the portable database, if it exists there.
If there is no match for the first six (6) digits of the bar code UPC, then the process continues at thestep416, described below.
If there is a match for the first six (6) digits of the bar code UPC, then the database record or records containing the match are accessed to identify a corresponding manufacturer for the product. Then, the portable database is accessed to determine all agricultural products listed for the identified manufacturer.
Then, in astep410, the portable data processing device presents to the field inspector a list of all agricultural products from the identified manufacturer which are included in the portable database. The list may be displayed on an LCD display screen or other suitable data output device. Preferably, for each agricultural product, the list may include a product name, EPA ID, and/or other suitable identifying data.
Next, in astep412, the field inspector reads the list and compares the listed agricultural products with the agricultural product on the store shelf whose package has been scanned.
If there is a match, then the field inspector indicates which particular agricultural product in the list matches the scanned bar code UPC. This may be done by clicking a mouse button next to the correct agricultural product listing, by highlighting the correct agricultural product listing and typing “enter,” or by other well-known means.
In that case, in astep414, the portable database is updated to add the scanned bar code UPC into the UPC field for the selected product.
Then, the process continues at the step430 as described below.
If there is no match for the scanned product among the list of all agricultural products from the identified manufacturer in the portable database, then, in astep416, the portable data terminal presents to the field inspector a list of Company EPA IDs. This list is built from searching through the Company EPA ID fields of each data record in the portable database.
Next, in astep418, the field inspector reads the list and compares the listed Company EPA IDs with a Company EPA ID which is printed on the package of the scanned agricultural product which the field inspector is checking.
If there is no match for the Company EPA ID in the database, then in astep420 the field inspector manually enters data for the scanned product into the portable database. Preferably, the portable data terminal presents to the field inspector a data entry form on a display screen whereby the field inspector may manually enter product data, including a product name, an EPA ID, and/or other suitable identifying data. In that case, the field inspector enters the product name, the Company EPA ID, the EPA ID, the product size, and other appropriate data for the scanned product. At that time, the UPC is automatically added and a flag is also set for the new data record in the portable database, indicating that the corresponding data item is a completely new record in the database. That insures that a follow-up check is later performed to determine whether the product is approved for sale in the state or not, so that a “Stop-Sale” notice may be later sent to the retailer and/or the manufacturer if the product is determined to be unapproved.
Then the process continues in thestep434 as described below.
If there is a match for the Company EPA ID in the database, then the field inspector indicates which particular Company EPA ID matches the scanned product. This may be done by clicking a mouse button next to the correct agricultural product listing, by highlighting the correct agricultural product listing and typing “enter,” or by other well-known means.
In that case, in astep422, the portable data unit presents to the field inspector a list of agricultural products from the company having the selected Company EPA ID. This list is built from searching through all data records in the portable database to identify all data records having the selected Company EPA ID in the Company EPA ID field. The list may be displayed on an LCD display screen or other suitable data output device. Preferably, for each agricultural product, the list may include a product name, EPA ID, and/or other suitable identifying data.
Next, in astep424, the field inspector reads the list and compares the listed agricultural products with the agricultural product on the store shelf whose package has been scanned.
If there is no match for the scanned product among the list of all agricultural products from the identified manufacturer in the portable database, then, in thestep420, the field inspector manually creates a new data record for the selected product, as described before.
If there is a match for the scanned product, then the field inspector indicates which particular agricultural product in the list matches the scanned bar code UPC. This may be done by clicking a mouse button next to the correct agricultural product listing, by highlighting the correct agricultural product listing and typing “enter,” or by other well-known means.
In that case, in thestep414, the portable database is updated to add the scanned bar code UPC into the UPC field for the selected product.
Then, in a step430, the data record for the scanned product is checked to determine whether or not the product is currently approved for sale within the state. The status may be determined by checking whether a flag is entered into a product status, or “Active,” field for the data record in the portable database.
If the product is determined not to be approved (i.e., canceled, expired, or pending), then in astep432, a warning is displayed to the field inspector, indicating that the product is expired or canceled.
Next, in astep434, the UPC of the scanned product is written to a log of scanned products.
Then, in astep436, the portable data terminal displays the product name, EPA ID, and product status to the field inspector.
At this point, the field inspector may check another product in which case the process returns to thestep404.
In the case of some bulk agricultural products, there may not be a package with a UPC printed thereon. In that case, in astep450, the field inspector searches data records in the portable database for any matches to the product name or EPA ID.
In astep452, the portable data terminal determines whether there are multiple data records for different products matching the product name or EPA ID submitted for search by the field inspector in thestep450. If not, then the process continues at thestep458 below.
If there are multiple data records for different products matching the product name or EPA ID submitted for search by the field inspector in thestep450, then in astep454, the portable data unit presents to the field inspector a list of agricultural products matching the product name or EPA ID. The field inspector then selects the correct product from the list.
Next, in thestep458, the portable data unit checks a status field in the data record for the product to determine whether it is currently “Approved.” If not, then in astep460, a warning is displayed to the field inspector, indicating that the product is expired or canceled.
Next, in astep462, the UPC of the scanned product is written to a log of scanned products.
Periodically, after the field inspector has scanned products for one or more stores, in astep438, the field inspector communicates the log of scanned UPC products to the agricultural productsmanagement computer system130. During this process, the new UPCs which have been learned by the process and added to the portable database are communicated to the master agricultural products database, so that the UPCs for agricultural products are “learned” and the master agricultural products database is automatically updated.
The log may be communicated via the Internet by e-mail, or by connecting to a server of the agricultural productsmanagement computer system130 through a standard network connection.
The agricultural products-management computer system130 executes a software routine to automatically update the master agricultural products database with new UPC information provided by field inspectors.
The process includes safeguards to prevent erroneous data entries to the master agricultural products database. Preferably, when a new UPC is communicated to the agricultural productsmanagement computer system130, a flag is set to identify the new UPC. The new UPC is not confirmed until it is communicated again a second time during a subsequent update of the database.
FIG. 5 is a flowchart of a preferred embodiment process500 for reporting pesticide use. The process is especially useful for tracking and reporting the use of pesticide products sold to residential users, or household consumers, through retail channels.
Further details regarding a preferred embodiment for a process for reporting pesticide use may be found in U.S. patent application Ser. No. 09/603,734, filed on Jun. 23, 2000 in the names of J. Keith Kelly and Peter Stuart Edmondson, and entitled “METHOD AND SYSTEM OF TRACKING AND REPORTING PESTICIDE SALES” the entirety of which is incorporated by reference.
FIG. 6 is a flowchart of apreferred embodiment process600 of licensing pesticide dealers and pesticide applicators. The process is automated and stores licensing information on a centrally accessible database or databases. The licensing data may be viewed (but not altered) via the Internet by systems and individuals in need of verifying pesticide dealer or pesticide applicator credentials before making a sale of a restricted use pesticide (RUP) product, or locating dealers or applicators, or verifying continuing education units (CEUs).
In astep605, a prospective pesticide dealer registers for an Internet-based dealer licensing course. The registration is preferably performed by establishing an Internet connection between the dealer'suser computer110 and an agricultural product management Web site hosted by the agricultural productmanagement computer system130. The prospective dealer supplies a name and address (street address, city, county, state, etc.).
In astep610, the agricultural product management Web site accepts on-line payment for course materials for the dealer licensing course.
Next, in the preferred embodiment, in astep615 the agricultural product management Web site hosts an on-line dealer licensing course, whereby the prospective dealer receives and interacts with all course materials with his/heruser computer130 via an Internet connection. Preferably, at the end of the course, the agricultural product management Web site administers a licensing test for the prospective dealer.
If the dealer passes the licensing test, then in astep620, a dealer license is automatically generated by the agricultural productmanagement computer system130 and sent to the newly-licensed dealer.
In astep625, a Dealer database at the agricultural productmanagement computer system130 is updated to include a new data record having the name, address, state, license number, and expiration date for the newly-licensed dealer. Anexemplary Dealer database1350 is shown inFIG. 13B. The dealer license data stored in thedealer database1350 may be accessed (read-only) via the Internet. Thus, theDealer database1350 may be used to support a process of controlling the sale of pesticide products over the Internet, as described in more detail below with respect toFIG. 10.
Similarly, in astep655, a prospective pesticide applicator registers for an Internet-based applicator licensing course. The registration is preferably performed by establishing an Internet connection between the applicator'suser computer110 and an agricultural product management Web site hosted by the agricultural productmanagement computer system130. The prospective applicator supplies a name and address (street address, city, county, state, etc.).
In astep660, the agricultural product management Web site accepts on-line payment for course materials for the applicator licensing course.
Next, in the preferred embodiment, in astep665 the agricultural product management Web site hosts an on-line applicator licensing course, whereby the prospective applicator receives and interacts with all course materials with his/heruser computer130 via an Internet connection.
Preferably, at the end of the course, the agricultural product management Web site administers a licensing test or a certification for the prospective applicator. In that case, in astep670, the agricultural product management Web site automatically scores the test results.
If the prospective applicator passes the licensing test, then in astep675, a data record for the prospective applicator is updated in an applicator licensing database associated with the agricultural productmanagement computer system130 to reflect that the prospective applicator has passed the course and received the corresponding number of credit hours.
Once the prospective applicator has passed the initial course or attended enough courses to satisfy the state's credit hour requirements for an applicator's license, then in astep680, an applicator license is automatically generated by the agricultural productmanagement computer system130 and sent to the newly-licensed applicator. Note that there are many different categories for applicator licensees depending on the types of products to be applied, where product is to be applied, etc. and therefore agricultural productmanagement computer system130 tracks the tests taken by a licensee or prospective licensee against each license category to determine whether the appropriate requirements have been satisfied.
In astep685, an Applicator database at the agricultural productmanagement computer system130 is updated to include a new data record having the name, address, state, license number, and expiration date for the newly-licensed applicator. Anexemplary Applicator database1355 is shown inFIG. 13B. The applicator license data stored in theApplicator database1355 may be accessed (read-only) via the Internet. Thus, theApplicator database1355 may be used to support a process of controlling the sale of pesticide products over the Internet, as described in more detail below with respect toFIG. 10.
Also, whenever an applicator's license is scheduled to expire, the agricultural product management Web site sends a notification that the license will expire, and that the applicator has a period of time (e.g. 120 days) to satisfy the credit hour requirements to keep his/her license current. The Applicator may then complete the course requirements on-line according to the process described above upon the completion of which the Applicator database at the agricultural productmanagement computer system130 is updated to include the new expiration date for the licensed applicator.
FIG. 7 is a flowchart of aprocess700 for renewing registrations of agricultural products. The process automates the generation of forms compliant with the various requirements of multiple government (state) agencies. A universal username/password pair may be used to access a database of username/password pairs for many different states where a user needs to register an agricultural product.
In astep702, the agricultural productmanagement computer system130 executes a software routine to automatically generate product registration renewal notices which may be sent (by mail, e-mail, fax, etc.) to companies with registered agricultural products, and their agents.
In asubsequent step704, it is determined whether the company or agent has an e-mail address. If so, then in astep706 the agricultural productmanagement computer system130 automatically sends a renewal notification e-mail message to the company or agent. In that case, in astep708, the company or agent receives the renewal notification e-mail message. In the preferred embodiment, the message includes a hypertext link to one-stop product renewal log-in Web form of the agricultural product management Web site hosted by the agricultural productmanagement computer system130, whereby the company or agent may renew their product registration(s). Then, the process continues at thestep724 as described below.
If, in thestep704, it is determined that the company or agent does not have an e-mail address, then in a step710 it is determined whether the company or agent has a facsimile number. If so, then in astep712 the agricultural productmanagement computer system130 automatically sends a renewal notification and renewal form by facsimile transmission to the company or agent. In the preferred embodiment, the renewal notification includes an Internet address for a one-stop product renewal home Web page of the agricultural product management Web site hosted by the agricultural productmanagement computer system130, whereby the company or agent may renew their product registration(s).
If, in the step710, it is determined that the company or agent does not have a facsimile number, then in astep714, the agricultural productmanagement computer system130 automatically prints a renewal form and mails a renewal notification and the renewal form to the company or agent. In the preferred embodiment, the renewal notification includes an Internet address for a one-stop product renewal home Web page of the agricultural product management Web site hosted by the agricultural productmanagement computer system130, whereby the company or agent may sign up to renew their product registration(s).
In astep716, the company or agent receives the paper renewal notice—whether by facsimile or by regular mail. At this point, the company or agent may decide to access the one-stop product renewal home Web page to perform a product renewal. In that case, the company or agent connects auser computer110 to the agricultural product management Web site and loads the one-stop product renewal home Web page into a Web browser installed on theuser computer110. Preferably, the one-stop product renewal home Web page includes a hypertext link to a Web form whereby the company or agent may sign-up with the one-stop product renewal service. Once the company or agent signs up, it is assigned a universal username and universal password for accessing the service. Then the process continues at thestep724 as described below.
If the company or agent decides to perform a paper-based renewal, then in astep718, the company or agent manually fills in the renewal form. Then, in astep720, the company or agent sends the completed renewal form back to the state agency, either by mail or by facsimile transmission. Finally, in astep722, the state agency prints and mails a product approval certificate to the company or agent. If the renewal includes e-mail or fax addresses, then the certificate may be e-mailed or faxed.
Typically, a company may have many agricultural products for which it must renew registrations. Moreover, the company may have registrations for each product in all 50 U.S. states. Therefore, there may a large amount of paperwork involved in annual renewals.
Accordingly, a one-stop product renewal system and process has been developed by the present inventors. Through the one-stop product renewal system and process, a company or agent may renew registrations for one or more of its products in a plurality of states (hereinafter referred to as “the participating states”) through a single log-in process.
In a preferred embodiment system and process disclosed herein, the agricultural productmanagement computer system130 hosts the agricultural product management Web site, including a one-stop product renewal log-in Web form which allows a company or agent to renew registrations for one or more of its products in the participating states through a single submission. The one-stop product renewal log-in Web form operates in conjunction with a multi-state database. The multi-state database includes a data record for each company or agent which renews product registrations through the agricultural product management Web site. Each data record includes a universal username field, a universal password field, and a plurality of state username fields and state password fields corresponding to each participating state for which a company or agent may renew a product registration through the one-stop product renewal process. Through the multi state database, a company or agent may supply a single username and password, and the agricultural productmanagement computer system130 hosting the agricultural product management Web site may thereby obtain the usernames and passwords for each participating state in which the company or agent has registered products.
In accordance with this embodiment, in a step724 a company or agent establishes an Internet connection between auser computer110 and the agricultural productmanagement computer system130 hosting the agricultural product management Web site. The agricultural productmanagement computer system130 transmits a one-stop product renewal log-in Web form to theuser computer110. At this time, the company or agent enters into the one-stop product renewal log-in Web form a universal username and a universal password which is used to access a data record in the multi-state database. The one-stop product renewal log-in Web form is then transmitted back from theuser computer110 to the agricultural productmanagement computer system130.
Advantageously, the universal username and a universal password allow the agricultural productmanagement computer system130 hosting the agricultural product management Web site to authenticate the user for performing on-line product renewals for all of the participating states.
In a step726, the multi-state database is searched to find a data record having the universal username and universal password. If the universal username and universal password is not found in the multi state database, then the process returns to thestep724 wherein the company or agent supplies a new universal username and universal password.
If the universal username and universal password is found in the multi-state database, then in astep728, a product registration Web form, listing all products registered by the company or agent, is generated and transmitted to the company or agent'suser computer110. In the case of an agent, a company registration Web form, listing all companies having products registered by the agent, may first be generated and transmitted to the agent'suser computer110, and the agent can then select a company from the list, and then the product registration Web form for the selected company is generated and transmitted to the agent'suser computer110.
Next, in astep729, the company or agent selects and indicates a state in which it wants to renew and/or discontinue product registrations.
Next, in astep730, the company or agent selects all of the products which it desires to renew, discontinue, or cancel for the participating state.
Then, in astep731, an information form is transmitted from the agricultural productmanagement computer system130 hosting the agricultural product management Web site to the company or agent for supplying a change of address or other changes of information.
If the address of the company or agent is not correct, then in astep732, the agent enters an address correction and submits this information back to the agricultural productmanagement computer system130 hosts the agricultural product management Web site.
In astep733, the company or agent indicates whether there are additional states for which it desires to renew, discontinue, or cancel product registrations.
If there are additional states, then the process returns to thestep729 where the company or agent indicates the next state.
If there are no more additional states, then the process continues at astep734, wherein the company or agent supplies credit card information against which the charges for the state registration renewals may be billed. Preferably, the credit card is entered into appropriate data entry boxes of a Web form supplied by agricultural product management Web site to auser computer110 for the company or agent.
In astep735, the one-stop renewal process automatically bills a registration renewal fee or fees against the company's or agent's credit card. Preferably, the Applicant receives e-mail confirmation of the renewal requests and the credit card charges.
Meanwhile, in astep736, the registration renewal data is submitted to the selected participating state(s) according to the product registration(s) being renewed in the state(s). Preferably, the multi-state database is accessed to retrieve the state username(s) and/or state password(s) for the company or agent for each participating state in which a product or products are being renewed, discontinued, etc. Using this username and password, the agricultural productmanagement computer system130 may automate a process of logging-in to the selected participating state's renewal system and submitting on behalf of the company or agent the product renewal application and at least a subset of the renewal data supplied by the company or agent. For each selected participating state, a state agent reviews and approves the renewal application.
Preferably, the renewal data is submitted in a standardized format accepted by the state, for example in a standard (e.g., MICROSOFT EXCEL) spreadsheet or standard (e.g., MICROSOFT ACCESS) database.
This review and approval process may be performed according to theprocesses1100 or1200 (depending upon whether the product is a pesticide or fertilizer) as will be described in more detail below with respect toFIGS. 11 and 12.
Finally, in astep738, an appropriate agency for the participating state sends to the company or agent an e-mail message containing one or more product approval certificates.
Then, the process returns to thestep728 and is repeated for each participating state. It is understood that the order of the steps in theprocess700 may be rearranged without departing from the present invention.
FIG. 8 is a flowchart of anapplication process800 for submitting pesticide products for initial approval and registration in one or more states. Theprocess800 allows the simultaneous application for approval and registration of one or more new pesticide products by many different jurisdictions (states).
In astep805, product data for a pesticide product being submitted for approval and registration is entered into a new product registration application form provided by an agricultural productmanagement computer system130. Product data may be manually entered into the new product registration application form by an approved operator, or may be submitted to the agricultural productmanagement computer system130 by an applicant company or agent in a Web-based new product registration application form via the Internet.
In astep810, the operator keys into the new product registration application form an EPA ID for the pesticide product to be approved and registered.
In astep815, the agricultural productmanagement computer system130 checks to determine whether the EPA ID is found in an EPA database, which may be the EPA database1400 illustrated inFIG. 14. If not, then the process continues in astep830 described below.
If the EPA ID is found in the EPA database, then in astep820, the EPA database is checked to determine whether there are multiple pesticide products having the same EPA ID. If not, then there is only one pesticide product having the EPA ID, and in astep835, data for the pesticide product from the EPA database is assembled into the new product registration application form. Such data preferably includes, applicant company data, a pesticide type, etc. Then the process continues at thestep840 described below.
If multiple pesticide products having the same EPA ID are found in the EPA database, then in astep825 the agricultural productmanagement computer system130 presents to the operator a list of all pesticide products matching the EPA ID. The operator reads the list and determines whether the new pesticide product being submitted for approval and registration is found in the list. If so, then the process continues at thestep835 described above.
If the operator does not find the new pesticide product being submitted for approval and registration in the list, then in astep830 the agricultural productmanagement computer system130 asks the operator to supply all applicable information. Then the process continues in thestep835, wherein the operator manually enters all applicable information into the new product registration application form. Such information may include a product name, a pesticide type, active ingredients, etc.
Typically, a company may have many new pesticide products which it must register. Moreover, the company may want to register a new pesticide product in all 50 U.S. states.
Accordingly, a one-stop new product application system and process has been developed by the present inventors. Through the one-stop new product application system and process, a company or agent may submit one or more new products for approval and registration in a plurality of states (hereinafter referred to as “the participating states”) through a single submission.
Accordingly, in astep840, the operator identifies each state where the applicant company wants to submit the new pesticide product for approval and registration.
Then, in astep845, the agricultural productmanagement computer system130 automatically adds a new record to a state product database for each selected state where the new pesticide product is to be submitted. At the same time, a “Status” field for the record is marked with a “Pending” status. The record will subsequently be reviewed by a state agent in each selected state who, upon product approval, will change the status field from “Pending” to “Approved.” This review and approval process may be performed according to theprocess1100 as will be described in more detail below.
In astep850, the agricultural productmanagement computer system130 asks the operator to provide one or more UPCs by which the pesticide product may be sold. In response, the operator enters the requested information.
Then, in astep855, the agricultural productmanagement computer system130 asks the operator to provide various documents pertaining to the new product being submitted, for example, a material safety data sheet (MSDS), a product label, etc. In a preferred embodiment, the operator may download electronic copies of the documents to the agricultural productmanagement computer system130. The electronic copies may be formatted in a standard file format, such as ADOBE® ACROBAT®.
Next, in astep860, the agricultural productmanagement computer system130 asks the operator whether there are other new pesticide products to be submitted for approval and registration. If so, then the process returns to thestep810.
If there are no more new pesticide products to be submitted, then in astep865 the agricultural productmanagement computer system130 asks the operator to provide billing data, such as credit card data, virtual checks, paypal, etc. which can be billed for the registration of the new product(s). In response, the operator enters the requested information.
Finally, in astep865, the agricultural productmanagement computer system130 automatically sends a confirmation message to the company which has submitted the new product(s) for approval and registration. Preferably, the confirmation is transmitted via an e-mail message.
Although theprocess800 described above applies particularly to pesticide products, a similar process may be used to submit other new non-pesticide agricultural products for initial approval and registration in one or more states. In that case the process is the same, except that the steps of looking-up and cross-referencing an EPA ID in steps810-825 are not performed, and instead the operator may manually supply the all applicable information, such as in thestep830. Also, when the product is a fertilizer instead of a pesticide, the review and approval performed in thestep845 may be performed according to theprocess1200.
FIG. 9 is a flowchart of a process for managing documents of an agricultural product management computer system.
In a step905 a state agent at a state agency reviews a product label.
In astep910, the agent may indicate a desire to compare a current version or revision to a label with a previous revision. In that case, in astep915, the agent may view new and old versions of a product label side-by-side on a display monitor of the agricultural productmanagement computer system130.
In astep920, for a specific product label, the agent assimilates site and pest data from an EPA database for a specific EPA ID. The EPA database may be the EPA database1400 illustrated inFIG. 14.
Then, in astep925, the agent un-marks those sites and/or pests that have been removed from the EPA Label to generate an In-Commerce label. Preferably, an electronic copy of the In-Commerce label is stored at the agricultural productmanagement computer system130. The electronic copy may be formatted in a standard file format, such as ADOBE® ACROBAT®.
Finally, in astep930, the EPA Label, In-Commerce Label, the MSDS, and other data are now available for research by consumers, farmers, extension services, etc. via the Internet. A researcher may cross-reference this data with the EPA database to provide the researcher with other product information, such as ingredients, pesticide types and formulations.
FIG. 10 is a flowchart of an automated back-end process1000 for verifying pesticide dealer and applicator licenses in support of Internet pesticide sales.
Further details regarding a preferred embodiment for a back-end process for verifying pesticide dealer and applicator licenses in support of Internet pesticide sales may be found in U.S. patent application Ser. No. 09/662,492, filed on Sep. 15, 2000 in the names of J. Keith Kelly and Peter Stuart Edmondson, and entitled “SYSTEM AND METHOD OF PROVIDING AGRICULTURAL PESTICIDE INFORMATION AND FACILITATING SALES OF PESTICIDE PRODUCTS” the entirety of which is incorporated by reference.
FIG. 11 is a flowchart of a process for a state or other government agency to approve and register pesticide products. The process allows a government agency to provide a final check or gate before an agricultural product is approved for sale.
In afirst step1105, a company or agent submits a new product application for approval and registration. The submission may be accomplished through a one-stop new product application system and process such as theprocess800 described above with respect toFIG. 8.
In anext step1110, a state agent physically reviews the new product application and determines whether it will be approved.
If the new product application is rejected, then in a step1115 a rejection notice is sent to the company or agent.
If the new product application is approved, then in a step1120, the state agent updates a status field from “Pending” to “Approved” in a record for the new product in a state product database.
Prior to a time when the product's registration is due for renewal, in astep1125, the state agency sends a renewal notification to the responsible company or agent. Preferably, such notification is sent electronically, via an e-mail message, for example.
Then, in thesteps1130 through1145, the company or agent may connect a user computer with an agricultural product management Web site to renew the product registration and, where necessary, submit new or update labels, sales data, or other information. At that time, the company or agent pays a renewal fee. Preferably, the renewal process may be performed according to the one-stop product renewal system and process described above with respect toFIG. 7.
FIG. 12 is a flowchart of a process for a state or other government agency to register fertilizer products. The process allows a government agency to provide a final check or gate before user-supplied data is entered into government databases.
In afirst step1205, a company or agent submits a new product application for approval and registration. The submission may be accomplished through one-stop new product application system and process such as theprocess800 described above with respect toFIG. 8.
In anext step1210, a state agent physically reviews the new product application and determines whether it will be approved.
Once the agent approves the product, then in astep1215, the state agent updates a status field from “Pending” to “Approved” in a record for the new product in a state product database. At that time, the sate agent also assigns an expiration date to the product registration, and enters that date into a corresponding field for the record for the new product in the state product database.
Prior to a time when the product's registration is due for renewal, in astep1220, the state agency sends a renewal notification to the responsible company or agent. Preferably, such notification is sent electronically, via an e-mail message, for example.
Then, in thesteps1225 through1240, the company or agent may connect a user computer with an agricultural product management Web site to renew the product registration and, where necessary, submit new or update labels, sales data, or other information. At that time, the company or agent pays a renewal fee. Preferably, the renewal process may be performed according to the one-stop product renewal system and process described above with respect toFIG. 7.
Meanwhile, in astep1245, periodically (e.g., quarterly) the state agency sends a notification to the responsible company or agent requesting that it supply sales volume data, for example, the tonnage of product sold during the previous quarter.
In response to the notification, in astep1250 the company or agent may connect a user computer with an agricultural product management Web site to submit the quarterly sales/tonnage data. Preferably, the company or agent logs-in to a secure part of the agricultural product management Web site using a pre-assigned username and password.
In a preferred embodiment, a company or agent may submit quarterly sales/tonnage data for a plurality of participating states through a one-stop reporting process. In that case, the company or agent may access a one-stop reporting portion of the agricultural product management Web site by submitting a universal username and universal password, as was described before with respect to theprocess700 illustrated inFIG. 7.
Next, in astep1255, the company or agent pays a tonnage tax on the fertilizer product.
In astep1260, renewal fees and/or tonnage taxes are automatically collected by the agricultural productmanagement computer system130 against a credit card account or other electronic account supplied by the company or agent. A portion of the fees are retained as a service charge by a host of the agricultural productmanagement computer system130, and the balance are forwarded to the appropriate state agency.
FIGS.13A-C illustrate interrelationships of databases used in a system and process for managing agricultural product information, and for facilitating the controlled sale, distribution, and use of agricultural products. The databases shown in FIGS.13A-C are managed by adatabase administration module260 of the agricultural productmanagement computer system130.
Illustrated inFIG. 13A are a status history (STATHIST) database1305 maintains an audit trail on all changes made to a product through its history, a product label (PROBLBL)database1310, an ingredients (INGREDIENTS)database1315, a co-packaging (COPACK) ortwinpack database1320, a product status (STATPROD)database1325, a product UPC (PRODUPC)database1330, a product (PRODUCT)database1335, a company (COMPANY)database1340, a dealers (DEALERS)database1345, a product experimental use permit (PRODEUP)database1350, a product special local need (PRODSLN)database1355, a product Section 2EE (PROD2EE)database1360, a stop-sale (STOPSALE)database1365, an agents (AGENTS)database1370, and a territory (TERR)database1375.
Illustrated inFIG. 13B are an applicator (APPLICATOR)database1380 and a dealer (DEALERS)database1382.
Illustrated inFIG. 13C are internal databases used by the agricultural productmanagement computer system130, including an edit log (EDITLOG)database1384, an account (ACCOUNT)database1386, an alternate brand names (ALTBR2)database1388, a rejection reasons (REASONS)database1390, a user (USER)database1392, a default parameters (DEFAULTS)database1394, and a container size (CONTSIZE)database1396.
FIG. 14 is a diagram showing a database structure and interrelationships of government environmental protection agency (EPA) pesticide data in such database. EPA data is automatically cross-referenced with state data to manage agricultural product information, and to facilitate the controlled sale, distribution, and use of agricultural products.
Illustrated inFIG. 14 are a toxic name (TOXCODE)database1402, an ingredient (INGRED) database1404, an ingredient chemical abstract society (INGCAS)database1406, an ingredient SLN (section 24) (INGRED24)database1408, an ingredient names (INGNAMES)database1410, a registered pest SLN (REGPST24)database1412, a formulation name (FORM NAME)database1414, a first product (PRODUCT)database1416, a second product (PRODUCT2)database1418, a product SLN (PROD24C)database1420, a registered site (REGSIT24)database1422, a master pest list (PESTLIST)database1424 which lists all pests covered by any product, a registered pest (REGPEST)database1426, a company (COMPANY)database1428, a pesticide types (TYPE)database1430, a pesticide type name (TYPENAME)database1432, a pesticide types SLN (TYPE24)database1434, a registered site (REGSITE)database1436, and a master site list (SITELIST)database1438 of all sites and crops to which agricultural products can be applied.
As shown inFIG. 15, a state agent may select an existing product which is registered in the state and submit multiple UPCS that correspond to that product to be entered into appropriate databases as shown inFIG. 14.
While preferred embodiments are disclosed herein, many variations are possible which remain within the concept and scope of the invention. Such variations would become clear to one of ordinary skill in the art after inspection of the specification, drawings and claims herein. The invention therefore is not to be restricted except within the spirit and scope of the appended claims.