Agranova
[Home]

The Agranova
Ag Chem Base Help File

Overview : read me first!
Getting Started
Printing Reports, Copying and Pasting Data
Start-up Screen Main Menu
Ag Chem Base data fields: description of contents and coding conventions used

Dockable Menu-bars:
The Ag Chem Base System Menu
The Search Menu
The Report Menu

Overview

The Ag Chem Base is a self-contained information package, designed for installation on single-user PCs. In order to facilitate periodic data table upgrades and to ensure data integrity, it has separate data and interface program components. After installation, all program and data files are resident on the C: drive - the CD-Rom is not required to be present in order to run the Ag Chem Base.

The Ag Chem Base interface has been designed with a view to providing the user with maximum utility using minimum effort. In addition to several index search options, advanced user-query facilities are also provided.

Actions performed by the program are limited to choices available by clicking on self-explanatory command buttons. Allowable system actions (like Page Setup) are provided on dockable Menu Bars. Menu Bars may be moved around the screen - just click and drag, or they may be "docked" to sit, out of the way, along the edge of the screen.  The program remembers where you last put Menu Bars - they will appear in the same place next time.

The Ag Chem Base can be queried by using a variety of search utilities. Of these, the easiest to use are the index search utilities, which are accessed by clicking on command buttons which appear on the left hand side of the Start-up screen. These are most useful when looking for a single active ingredient -  by querying the generic name/trade name/code or the CAS number indexes. An index search by Company is provided - but this will usually retrieve several to many active ingredients (useful for browsing), as will the Search by Chemical Name fragment option.

Where more than one active ingredient is likely to be retrieved, i.e. in searches by Company or by Chemical Name, the user may pre-set whether the results will be displayed in "Text on Top" or "Structure on Top" mode for browsing - this is to accommodate differing user requirements as to what data is most desirable at a first glance. Commercially orientated users will be more interested in market (text) data, whereas chemists generally prefer to look at structures. In either case, the "other view" is available by clicking a button.

The Advanced User-Search screen is designed to enable completely flexibility for searching in all data fields (not covered by the index search options), and for more complex queries involving the specification of multiple criteria.   In contrast to the index searches, the Advanced User-Search may require a little practice to start with, but this powerful tool will enable you to query the database in subtle ways in order to get the results which you want.

A pre-set report generator is available from all search screens. Use any search method to find the a.i. in which you are interested, and then press the appropriate button to either preview the report, or to print it.

The List Generator / previewer uses a query interface similar to that of the Advanced User-Search. It can be toggled between Form and Datasheet views to enable either a pre-set, or a customised report to be printed.

Do you have Ag Chem information retrieval needs which require more flexibility?
Contact Agranova Sales to discuss your requirements and to find out more about the availability of power-user versions of our e-products.

Top of Page| Start-up Screen Main Menu

Start-up Screen Main Menu

Click on underlined items below to read more about each option.

Certain fields in the Ag Chem Base contain codes, some of which are not immediately obvious. Click here to read the Ag Chem Base field descriptions and code definitions.

Find a.i. by name/code

Clicking on this button takes you straight to the search screen which is furnished with an indexed list of all generic names, tradenames and experimental codes present in the Ag Chem Base. To find an item, open the scroller list at the top of the screen, and type in, or select from the list the item in which you are interested. Read more about how to use the scroller list in Getting Started.

Top of Page| Start-up Screen Main Menu

Find a.i. by company

Clicking on this button takes you to an intermediate "Text-on-Top" or "Structure-on-Top" selector screen. Click one of these options to go on to the search screen which is furnished with an indexed list of Companies present in the Ag Chem Base. To find an item, open the scroller list at the top of the screen, and type in, or select from the list the Company in which you are interested. Read more about how to use the scroller list in Getting Started.

You are likely to retrieve more than one record when using this search option. Use the video buttons in the bottom left hand corner of the screen to browse multiple records. Note that the sort-order for multiple retrieved records in this search mode is in descending order of Entry Year (this order cannot be changed by the user). If you require a more specific search of chemicals within a Company's portfolio, use the Advanced User-Search.

Top of Page| Start-up Screen Main Menu

Find chemical a.i. by CAS no.

Clicking on this button takes you straight to the search screen which is furnished with an indexed list of all CAS Registry Numbers present in the Ag Chem Base. To find an item, open the scroller list at the top of the screen, and type in, or select from the list the CAS no. in which you are interested. Read more about how to use the scroller list in Getting Started.

Top of Page| Start-up Screen Main Menu

Chemical name fragment search

Clicking on this button takes you to an intermediate "Text-on-Top" or "Structure-on-Top" selector screen. Click one of these options to activate a text box which will prompt you for a text string.  It is important that text strings are enclosed in asterisks (*) - no asterisks = no retrieved records!  You are likely to retrieve many records when using this search screen. Use the video buttons in the bottom left hand corner of the screen to browse multiple records. Note that the sort-order for multiple retrieved records in this search mode is firstly, in ascending order of Company followed by ascending order of Entry Year for more than one a.i. retrieved for a given Company (this order cannot be changed by the user). If you require more sophisticated searching / reporting of chemical name fragment queries, use the Advanced User-Search screen.

Top of Page| Start-up Screen Main Menu

List Generator : a mini-tutorial

List printing options | Tips and exercises

The discussion below only outlines the basics for using the List Generator. Don't be afraid to experiment: the system is read-only -  there is no risk of changing or overwriting the underlying data.

Clicking on the List Generator button takes you straight to the List Generator Set-up Form. The Search Menu, which you will require to configure the List, will also be visible , either as a free-floating window somewhere on the screen , or docked, as a toolbar along one of the edges of the screen.

When opened, the List Generator Set-up Form tells you that no filter is being applied (red OFF indicator in the bottom left corner). If the box to the right of this indicator contains text, the Form has saved a previously applied filter, and the text displays the filter query in SQL language format (you do NOT need to know SQL to use the form, but the displayed text is useful for troubleshooting queries which do not seem to give the results which you require). The video button record counter should be indicating "1 of x" where x is the total number of records in the database.

To apply the filter, click on the Apply Filter option in the Search Menu. The video button record counter should now be indicating "1 of y (Filtered)" where y is the total number of records retrieved from the database, and meeting the criteria expressed in the SQL text box. The blue filter ON indicator (above the video record counter) will now be active. To disable the filter, click on the Remove Filter/Sort option on the Search Menu.  The List Generator Set-up Form will return to its unfiltered state, as described in the previous paragraph.

Next, configure the filter to whatever query you want to perform. Click on the Filter by Form option on the Search Menu. The display now changes to display the same Form, but in a format, in which you can edit / customise the filter.   The video controls have been replaced by Look For and Or tabs, and the Report Preview and Exit buttons are disabled.

IF the form has a previously-used query, the filter parameters should now be visible (surrounded by double-quote (") characters) in the appropriate fields.  You can remove a parameter simply by highlighting it with the mouse and then pressing the Backspace key (<-, normally situated in the top right hand corner of the main key area on your keyboard, above the carriage return key).

Clicking INSIDE a field will show a small down-pointing arrow at the right-hand end of the field. Depending on the field, clicking on this arrow will either show a drop-down list with indexed items relevant to that field, or else the two options : Is Null and Is Not Null.  You can choose an item from the scrolled list, or type in you own parameter(s).

If you do type in your own parameters, surround the string with asterisks (*) to enable searching of that string anywhere in the field.  So, after clicking in the Chemical Name field, type   *chloro* .  Then click on the Apply Filter option in the Search toolbar.  The display in the field momentarily changes to Like "*chloro*", and the Form reverts to normal Form View, to display 1 of x (Filtered) records (x will be 600+!).

Refine the search a little further: click on Remove Filter/Sort to re-initialise the Ag Chem Base, and then click on Filter by Form again. This time, click in the Company field, click the arrow at the end of the field to show the drop-down Company list, and click on AgrEvo. Click on Apply Filter.   The Form should now show 1 of x (Filtered) where x should be about 40.  So, AgrEvo has 40 active ingredients containing "chloro" in their chemical name fields.

Continue to refine the search: click on Filter by Form again, and select H (for herbicide) in the Type field, and C for Commercial in the Status field.  Click on Apply Filter. We now have about 9 records - AgrEvo herbicides, currently available commercially, and containing chlorine.  This is a good recordset for printing.

List printing options in the List Generator

The List Generator provides two report printing options:

• a pre-set list report with column contents sorting limited to, in order of pre-set priority: Company, Type and Entry Year.
• a user-configured listreport generator (using Datasheet view)

The pre-set list report is available for viewing at any time by clicking on the Report Preview button on the List Generator set-up screen. Use this report if it meets your requiremets. Try it! The sort order on the pre-set list is not user-adjustable, but the provided sort order is the most useful for general queries, and disallows mis-sorting of items when no entries are present in some fields.

The user-configured list report requires a little further setting-up. Click on Datasheet View in the Search Menu to view the list in "speadsheet" (tabular) format. You will have to scroll the window to see fields offscreen to the right. Click anywhere IN a column, and then click the Sort Ascending option to sort the contents of that column in ascending order. You may sort only one column at a time (obvious when you think about it). Grouping is not supported.

To view the resulting report, click on the Print Preview option on the Search Menu. Click anywhere inside the Report Preview screen to toggle Zoom In / Zoom Out: this allows you, in conjunction with the page video buttons, to check whether or not the list will print across one page width (this report is pre-configured to print in Landscpe mode). Click on the X in the top right-hand corner of the Preview window top return to Datasheet view.

You can adjust column widths within this view by clicking and dragging the column dividing line in the column titles row. Try it! Similarly, you can adjust row height, by clicking and dragging the row dividing lines in the left-hand margin of the spreadsheet. Try it! You will need to master this resizing in order to ensure that chemical names are fully visible in your printed listing! Note that, although columns mau=y be individually re-sized, rows can only be resized to a common height.

Adjust the cell sizes on the spreadsheet until the Report Preview indicated that the list is suitable for printing.

List Generator Tips and exercises: 

• don't be afraid to experiment: the system is read-only -  there is no risk of changing or overwriting the underlying data.
• there is a "shorthand" way of accessing the Search Menu directly from a field. Right-click inside a field to activate a "short version" of the Search Menu - it has an added box for entering search parameters.
• always, if you are not sure whether a search parameter will equal the whole field, to enter it between asterisks (*).
• Exercise: in Filter by Form, clear all query prameters, type *agr* in the Company field, type or select I in the Type field, and type or select C in the Status field. Apply the Filter, and work out why you retrieved what you did. Look at the list in Report Preview mode. Close Report Preview, and choose Datasheet View. Click in the Company column and the click Sort Ascending.

Top of Page| Start-up Screen Main Menu

Advanced user-search screen : how to get started | Tips

Some of the fields in the Ag Chem Base contain codes, some of which are not immediately obvious. Click here to read the Ag Chem Base field descriptions and code definitions.

The discussion below only outlines the basics for using the Advanced User-Search. Don't be afraid to experiment: the system is read-only -  there is no risk of changing or overwriting the underlying data.

Clicking on the Advanced User-Search button takes you straight to the query powerhouse of the Ag Chem Base - the Advanced User-Search Set-up Form. The Search Menu, which you will require for configuring queries, will also be visible, either as a free-floating window somewhere on the screen , or docked, as a toolbar along the top edge of the screen.

On opening the Advanced User-Search Set-up Form, no filter is active, and the video button record counter in the bottom left hand corner of the screen should be indicating "1 of x" where x is the total number of records in the database. The Form has, however, saved the previously applied filter. The parameters of the saved filter may be viewed by clicking on Filter by Form - the display now changes to display the same Form, but with the Preview and Exit buttons disabled, and with the video controls having been replaced by Look For and Or tabs.

To apply the filter, click on the Apply Filter option in the Search Menu. The video button record counter should now be indicating "1 of y (Filtered)" where y is the total number of records retrieved from the database, and which match the filter criteria visible when in Filter by Form mode. To disable the filter, click on the Remove Filter/Sort option on the Search Menu.  The Advanced User-Search Set-up Form will return to its unfiltered state, as described in the previous paragraph.

The next job is to configure the filter to whatever query you actually want to perform. Click on the Filter by Form option on the Search Menu. The display now changes as described earlier, and you can now edit / customise your filter.

IF the form had saved a previously-used query, the filter parameters should now be visible (surrounded by double-quote (") characters) in the appropriate fields.  You can remove a parameter simply by highlighting it and then pressing the Backspace key (<-, normally situated in the top right hand corner of the main key area on your keyboard, above the carriage return key). Clicking INSIDE a field will activate a small down-pointing arrow at the right-hand end of the field. Depending on the field, this will either show a drop-down list with indexed items relevant to that field, or else the two options : Is Null and Is Not Null.  You can choose an item from the scrolled lists, or type in you own parameters.  If you do type in your own parameters, surround the string with apostrophes (*) - this tells the program to search for that string anywhere in the field.  So, after clicking in the Chemical Name field, type   *chloro* .  Then click on the Apply Filter option in the Search toolbar.  The display in the field momentarily changes to Like "*chloro*", and the Form reverts to normal Form View, to display 1 of x (Filtered) records (x will be 600+!).

To refine the search a little further, click on Remove Filter/Sort to re-initialise the Form, and click Filter by Form again. Click in the Company field, click the arrow at the end of the field to show the drop-down Company list, and click on Agrevo. Click on Apply Filter.   The Form should now show 1 of x (Filtered) where x should be about 40.  So, AgrEvo has 40 active ingredients containing 'chloro' in their chemical names.

Click on Filter by Form again, and select H (for herbicide) in the Type field, and C for Commercial in the Status field.  Click on Apply Filter. We now have about 9 records - AgrEvo herbicides, currently available commercially, and containing chlorine.  Browse the search results by using the video buttons. Preview and print a record using the buttons on the search screen.

Let's try something smarter: Open up Filter by Form, and clear all the items. Type or select I in the Type field. Click in the Markets field and type *cotton*. Click in the Status field and select or type E (for experimental). Click Apply Filter to return to the search display screen, click in the Company field and click on Sort Ascending on the Search Menu.  Use the video buttons to scroll data on who's got experimental cotton insecticides in development, in ascending order of Company.

Advanced Search Tips:

• Don't be afraid to experiment: the system is read-only -  there is no risk of changing or overwriting the underlying data.
• Advanced searching depends on your ingenuity! The system supports very complex queries.
• you can enter search terms like >1990 , <1998 or >=1985 in date fields to select appropriate data
• use Boolean operators - OR and AND to refine queries. So, for example, try a search term like  *bromo* AND *chloro* in the Chemical Name field.  Likewise, use of OR is supported - try *Zeneca* OR *AgrEvo* in the Company field.
• use the Or tab sub-form to apply multiple criteria to one field. If a query is not working like it should, check whether there are 'forgotten' parameters lurking in one or more Or tab sub-forms.
• be familiar with the coding conventions used in some of the Ag Chem Base fields. Click here to read the Ag Chem Base field descriptions and code definitions.

Top of Page| Start-up Screen Main Menu

Getting started : Using the four index search screens

The instructions below do NOT apply to the List Generator and Advanced User-Search screens (see separately).

Access to data is by opening search screens (click on the appropriate buttons on the main Start-up Screen). The simplest to use are the four index search options on the left hand side of the Main Start-up Screen -

• Find a.i. by name/code
• Find a.i. by company
• Find a.i. by CAS no.
• Chemical name fragment search

In two cases (Search by name/code and Search by Chemical Name Fragment) there is an intermediate "Text-on-Top" or "Structure-on-Top" mode selector screen before you arrive at the actual search screen.

The Name/code, CAS no. and Company index search screens are provided with an index item scroll-bar selector (at the top of the screen).  On the other hand, the Chemical Name fragment search screen requires you to enter a text fragment to look for (always enclose the text fragment in asterisks (*)).

Using the scrolled selector display to retrieve records : To access data, you must first open the scrolled display list by clicking on the arrow on the right hand side of the box. When the drop-down list is visible, you may :

• EITHER scroll up and down the list (by using the vertical scroll-bar which appears on the right hand side of the list window)
• OR, click the mouse in the TOP LINE of the scroller display and, depending on which screen you are using, begin typing in the name / CASno / company name.The open item list will scroll as you type in text, and is case insensitive. If you type in a text string which is not found at the START of a list item, the displayed list will jump back to its starting position.

When the item you require is showing in the scroller list, CLICK on it to retrieve data.

The text typing method is recommended - it may be found that scrolling lists is not efficient (will be the case on slow computers). Thus, for, example, to quickly search for names/codes beginning with " W ", click the mouse IN the text box at the top of the scroller list, type in: W , and the index list will immediately go to the first item beginning with W. When you see the item you want, click on it, and the computer will retrieve the relevant record(s). Use the method which suits you best. If you type in text which does not match the start of an index entry, the list will jump back to the beginning. To RETRIEVE data, you must click on an index list item.

Don't be afraid to experiment: the system is read-only -  there is no risk of changing or overwriting the underlying data.

Viewing multiple records retrieved by the system : The computer may find MORE THAN ONE RECORD containing the information which you retrieve - e.g when you search by Company. To view multiple retrieved records, use the "video" buttons in the record scroller which appears in the bottom left hand corner of the record display (e.g. click on the > button to move through the records sequentially, or the >| button to go to the last record, etc.).

Viewing data retrieved by the system : Due to the fixed size of the display fields, the computer may not fully display all of the available data in e.g. the chemical name and CAS no. note fields. View extended data by clicking ON the field, and then using the <,>, Home and End keys on your keyboard to browse the contents of that field. Some fields are equipped with scroll-bars which become active when you click the field.

Top of Page| Start-up Screen Main Menu

Printing Reports, Copying and Pasting Data

Printing Reports : Report previewing and printing is available on all of the search result display screens. To generate a report you must have the item, for which you want to preview / print the report, showing in the display area. Separate report preview and print options are available by clicking on the appropriate picture buttons. To EXIT the Report Preview option, CLOSE the preview window (use the Close option on the Report Menu, or click on the X in the box in the top right-hand corner of the preview window) before continuing.

Report format : The report generator, as supplied, is configured to print on A4 paper - so correct printing should be obtained on both A4 and the US standard 8.5 x 11 inch paper. If report printing does not work satisfactorily, you will have to adjust the default paper size and / or margins by clicking on the Page Setup option on the Report Menu.

Chemical structures : All chemical structures are displayed in fixed-size screens, with no image-resizing facilities. This means that the more complex structures (or instances where more than one structure is presented) may not show up clearly when screen resolutions of greater than 800x600 are used. Viewing the structure using the report preview facility may aid clarity. Printed structures on hard-copy reports will in all cases be of high quality and fully legible.

Copying and pasting data to other applications :   Text and chemical structures displayed in the database browser screens and in the support documents may be copied and pasted into your own documents and reports. First, select the chemical structure (click on it) or text (click the mouse's left button at the start of the text, and whilst holding the left button down drag the mouse to select (highlight) the text you wish to copy). When the selection has been made, COPY the selection (using the CTRL-C key combination), and then PASTE it into the receiving application - e.g. Word (using the CTRL-V key combination). It helps to have the receiving application open prior to attempting Copy / Paste operations.

N.B. - you can only Copy/Paste from one field at a time (unless you have a multiple-item Clipboard utility installed).

Don't be afraid to experiment: the system is read-only -  there is no risk of changing or overwriting the underlying data.

Top of Page| Start-up Screen Main Menu

About

Click on this button to find out the version no. and contents statistics of the datatable installed with the program.  The action is the same as clicking on the About Ag Chem Base option on the Ag Chem Base System Menu.

Top of Page| Start-up Screen Main Menu

Quit

Click on this to Exit the program.  The action is the same as clicking on the Exit to Windows option on the Ag Chem Base System Menu.

Top of Page| Start-up Screen Main Menu

The Ag Chem Base System Menu

This Menu is displayed and is available for most of the time during program operation. It is not available during List Generation and Advanced User Search. Ag Chem Base Help - Click this item to access this Help File About Ag Chem Base - Click on this item to find out the datatable version installed with the program.  The action is the same as clicking on the About button on the Main Start-up Screen. Exit to Windows - Click on this to Exit the program.  The action is the same as clicking on the EXIT button on the Main Start-up Screen.

Top of Page| Start-up Screen Main Menu

The Search Menu

This Menu is displayed and is available for the List Generator and the Advanced User Search. It enables you to toggle the form to Filter by Form mode, apply and un-apply filters. In the case of the List Generator, both Form and Datasheet views are enabled to allow customised list set-up, preview and printing Filter By Form - Clicking this option toggles the current screen to filter criteria edit/viewing mode. In Filter by Form view, you can manually edit search criteria, remembering to enclose criteria in quotes ("), and using * when the criterion string might appear in the middle of a field. The Filter by Form view also enables you to check the criteria being used by the filter - useful for troubleshooting filters which appear not to be delivering expected information. Where applicable, fields in Filter by Form view have drop-down scroller lists (with type-ahead capability) to enable you to select exact items present in that field.  Fields not having this facility will show only Is Null or Is Not Null as selectable items - useful. Unlike in the index searches, you don't HAVE to select an item from these lists. A correctly typed search string will retrieve data to your own specification. Boolean operators may be used to build search criteria within a single field. Filter by Selection - After highlighting / clicking in a field, clicking on this option makes the filter add "equals the contents of the highlighted field" to its query statement. Use the List Generator to see how this works - when you click in a field and Filter by Selection, the contents of that field will be added to any pre-existing query statement already showing in the text box at the bottom of the List Generator screen. Apply Filter - Click on this to apply the current Filter. The video buttons in the bottom left hand corner of the screen will tell you how many records have been selected as a result of applying the filter. Remove Filter/Sort - Clicking this item removes the current filter (criteria). Note that the filter is still "resident" and may be re-activated by clicking on the Apply Filter menu item. The current filter criteria will also be saved along with the form when it is closed. This means that when you re-open the form to conduct a different search, you will have to re-edit the filter by using the Filter by Form facility. Sort Ascending - To sort the contents of a field in Ascending mode, first click IN that field on the form / spreadsheet, and then click on this item. Bear in mind that sorting is effective in only one field at a time. Sort Descending - To sort the contents of a field in Descending mode, first click IN that field on the form / spreadsheet, and then click on this item. Bear in mind that sorting is effective in only one field at a time. Find - After clicking IN a field in which to find a certain text string, click on this item to activate the Windows "Find" facility. Follow the instructions in the dialog to apply criteria. Useful for finding items in the Generic name, Tradename and Codes fields. Find supports the use of * and ? as Windows wildcard characters. Form View - This option is only applicable to the List Generator screen - it allows you to toggle back to Form View after looking at the Datasheet ("spreadsheet") view of the Form. N.B - you need to be in Form View to preview/print the pre-set list provided with the List Generator, and to Close the Form. Datasheet View - This option is only applicable to the List Generator screen - it allows you to toggle to Datasheet ("spreadsheet") view of the data retrieved by the Form. Print Preview - This option is available ONLY when you are in List Generator Datasheet view. This option permits you to check whether or not the spreadsheet-format list you are about to print will fit the page correctly. Page Setup - This option is available ONLY when you are in List Generator Datasheet view, and allows you to adjust page parameters to enable correct printing of a spreadsheet-format list from the List Generator. Clicking on this option will activate the Windows Page Setup dialog.  Use only if the pre-sets provided with program (pre-set to A4 paper) do not give satisfactory results. Follow the instructions in the dialog screen to make changes. Print - This option is available ONLY when you are in List Generator Datasheet ("spreadsheet") Preview mode, and enables you to print a single copy of the customised list. Ag Chem Base Help - opens this Help File.

Top of Page| Start-up Screen Main Menu

The Report Menu

This Menu is displayed only on activation of the Report Preview button present on all search screens.  From this menu you can re-size reports on screen, reset page margins for printing and print the visible document. Print Preview - You are in this mode when the Menu is showing Zoom - Click on this item to put the cursor arrow in magnify/reduce toggle mode: when you click/re-click in the visible Preview window, the document will enlarge/reduce within the display window. To enlarge/reduce the display window itself, either re-size it by clicking and dragging the window's edges and/or corners, or use the Maximise/Revert controls in the top right hand corner of the window margin. Use the scroller box below the Zoom option to either type in your own magnification, or select from the list. "Fit" to screen is useful for quick results. Close Preview - This has the same effect as clicking on the Close control (X) in the top right hand corner of the Report Preview window. Page Setup - Clicking on this option will activate the Windows Page Setup dialog.  Use only if the pre-sets provided with program (pre-set to A4 paper) do not give satisfactory results. Follow the instructions in the dialog screen to make changes. Print - This option enables you to print a single copy of the current Report without having to go back to the search screen. Ag Chem Base Help - opens this Help File.

Top of Page| Start-up Screen Main Menu

Ag Chem Base data fields: description of contents and coding conventions used

All of the fields in the Ag Chem Base are fully text-searchable, using the appropriate query interfaces. Some fields contain codes - these are described below.

Type: All active ingredients are classified as one of: F = fungicide, H = herbicide or I= insecticide

Subtype: This is a coded field, describing the pesticidal activity/usage in more detail. Currently used codes are: