Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This dictionary describes the contents of each column on each of the four PRL forms, its data type, maximum width and whether the column is required.


Include Page
_FormColumns
_FormColumns

Address

Report the street address including the building or lot number where the pesticide was applied or the purchaser intended to apply.  We cannot accept P.O. Boxes in this column. 

Forms: 26, 27

Reporting Column - required

Applications Indicator

Indicate whether or not this applicator made pesticide applications in the report year. 

Forms: 26A

Option C File Types: All

Reporting Column - required

Note

This column is also required on text files that were generated by third-party applications or manually.  On form 25 and 27 it indicates whether a sales permittee made sales during the report year.

 

Applicator First Name

First name and middle name (if reported) of the  commercial applicator, technician, or anti-fouling paint applicator employed by the registered business, privately-owned golf course, cemetery, greenhouse or private school.

Forms: 26A

Reporting Column - required

Applicator Last Name

Last name of the  commercial applicator, technician, or anti-fouling paint applicator employed by the registered business, privately-owned golf course, cemetery, greenhouse or private school.

Forms: 26A

Reporting Column - required

Business Registration Number

The ID number issued to pesticide application businesses by the DEC.  The field must contain 5 numeric digits (e.g. 52197).

Forms: 26A

Reporting Column - In most cases this field is required. An exception was made to this requirement to allow privately-owned golf courses, cemeteries, greenhouses and private schools to report using form 26A.

Certification ID Number

Excerpt Include
Glossary
Glossary
nopaneltrue

Forms: 26A

Reporting Column - required

Container Size Quantity

The numeric component of the container size for the containers that were sold. For example, if you sold 10 containers that were 2.5 gallons a piece, the Container Size Quantity is 2.5. Use only numbers and, if applicable, a decimal point in this column.

Forms: 25

Reporting Column - required

Containers Sold

The number of containers of the product that were sold.  For example, if you sold 10 containers that were 2.5 gallons a piece, the Containers Sold is 10.  Integers only; do not include decimal digits in this column.

Warning

Do not report the number of cases sold or how many containers are in the cases.

Forms: 25

Reporting Column - required

County Code

Forms 26 and 27 have a column for County Code.  A list of county codes is included in the appendix. As an added convenience, a county codepopup dialog is available to help you select the correct county code. 

Forms: 26, 27

Reporting Column - required

Date(s)

The date of application (Form 26) or the date the product was sold (Form 27). Date values must be entered in one of these formats (where mm=month, dd=day, yyyy=year):

  • mm/dd/yyyy
  • mm-dd-yyyy
  • mm-dd
  • mm/dd
     
Note

Two-digit years are also accepted.  If the year is omitted, the application will use the report year.

 

Form 26 includes an End Date column that is used to specify the end of a date range where the Apply Date is the beginning of the range.  This column is for automated applications (e.g. cooling towers, water treatment facilities). Leave this column blank if you do not make automated applications.

Forms: 26, 27

Reporting Column - required

Dosage Rate

Enter the amount of pesticide used for a given application; e.g., 1 fluid ounce/gallon (FL/GL); 1 gram/12 inches (GM/IN), etc. (This is the premix or final mix dosage rate listed on the pesticide label.)

Forms: 26

Record Keeping Column - optional

EPA Registration Number

Report the EPA Registration Number, exactly as it appears on the product label. It is a two or three part number in which the parts are separated by hyphens or dashes (e.g. 3125-474-538 or 3125-474).

Warning
titleImportant

Be sure to enter the EPA Registration Number. and not the EPA Establishment NumberEstablishment Numbers have a state abbreviation as the second part of the number (e.g. 99999-NY-002).

 

This column and the Product Name can be filled in by selecting a product in the EPA Reg Number List or by typing in the cell. 

Forms: 25,26, 27

Reporting Column - required

Method of Application

Method used to apply the pesticide (broadcast, hand placement, aerial, etc.)

Forms: 26

Record Keeping Column - optional

Municipality

Report the village, town or city where the pesticide was applied or the purchaser intended to apply the pesticide.  The municipality name should match the zip code (e.g., 11375 should be Forest Hills and not Queens).

Forms: 26, 27

Reporting Column - required

Place of Application

Enter location where the pesticide was applied (greens 3 & 7 of golf course; front lawn area, restaurant kitchen, etc.)

Forms: 26

Record Keeping Column - optional

Product Name

Report the registered product name (not the active ingredient name).  This column and the EPA Registration Number can be filled in by selecting a product in the EPA Reg Number List or by typing in the cell. 

Forms: 25,26, 27

Reporting Column - required

Quantity Applied

The undiluted amount of pesticide applied; that is the amount of product used out of the manufacturer’s container.  Convert all fractions to decimals (e.g. 3/4 = 0.75).

Forms: 26

Reporting Column - required

Quantity Sold

The size of the container sold multiplied by the number of containers.  Convert all fractions to decimals (e.g. 3/4 = 0.75).

Forms: 27

Reporting Column - required

Target Organism(s)

Enter the name of the targeted pest(s). The targeted pest or organism must be listed on the pesticide label.

Forms: 26

Record Keeping Column - optional

Units or Container Size Units

The unit of measure applicable to the quantity applied or sold. The Units column on Forms 26 and 27 and the Container Size Units column on Form 25have a drop-down list for easy entry of units. To use the list, click or tab into the cell, then click the  downward-pointing arrowhead and select one of the units.

 

Expand
titleAccepted Units of Measure...

FL - Fluid Ounces

GL - Gallons      

GM - Grams        

KG - Kilograms    

L  - Liters        

LB - Pounds       

MG - Milligrams   

ML - Milliliters  

OZ - Dry Ounces   

QT - Quart

Warning

Only the units listed in the drop-down list can be accepted.  Please do not enter non-measurements such as "each" or "case".

 

Forms: 25,26, 27

Reporting Column - required

Zip Code

The undiluted amount of pesticide applied or sold. 

Forms: 26, 27

Reporting Column - required

 

 

 

 

Data Type Descriptions

  • Character: Any printable ASCII character(s).
  • Date: One of these formats (where m = month, d = day, y = year)
    • mm/dd/yyyy
    • mm-dd-yyyy
    • mm/dd
    • mm-dd
  • Numeric: 0 – 9
  • Decimal: 0 – 9 and an optional decimal point (“.”).
    For numeric fields that include decimals, a decimal point and up to 4 digits to the right of the decimal point are accepted.