Option A Getting Started Guide
Option D with Control Center User Guide
Options D and O Spreadsheets User Guide
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. If or files if your report consists of files created by a third-party application , the dictionary lists the file type(s) for each column. Include Page
Div | ||
---|---|---|
| ||
|
Scroll office ignore |
---|
Record LayoutsFor the record layouts of files created by third-party software or manually, see the Text File Specifications. |
Div | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||
|
Scroll office only |
---|
Column Descriptions
|
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
Option C/Third-Party Software File TypesFiles: 26, 27
Required: yes
Column Type: reporting
Maximum Width: 50
Data Type: Character
Indicates whether or not this applicator made pesticide applications in the report year.
Forms: 26A
Option C/Third-Party Software File TypesFiles: 26, 26A
Required: yes
Column Type: reporting
Maximum Width: 1
Data Type: Numeric
Domain: Option A: check the box if no applications were made.
Option B: “Y” if applications were made; “N” if no applications were made.
Third-Party Software
Enter a “0” in this fieldFiles: “0” if applications were made
in the report year OR a; “3” if no applications were made. If
“3” (No Applications)column set to “3”, all other fields except Certification ID and Business Registration must be empty.
Required: yes
Column Type: reporting
Maximum Width: 1
Data Type: Numeric
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
Option C/Third-Party Software File TypesFiles: 26, 26A
Required: yes
Column Type: reporting
Maximum Width: 15
Data Type: Character
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
Option C/Third-Party Software File TypesFiles: 26A
Required: yes
Column Type: reporting
Maximum Width: 25
Data Type: Character
The ID number issued to pesticide application businesses or agencies by the DEC. The field must contain 5 numeric digits (e.g. 52197).
Forms: 26A
Option C/Third-Party Software File TypesFiles: 26, 26A
Required: 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.
Column Type: reporting
Maximum Width: 5
Data Type: Numeric
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
Forms: 26A
Option C/Third-Party Software File TypesFiles: 26, 26A
Required: yes
Column Type: reporting
Maximum Width: 8
Data Type: Character
The ID number issued to the Commercial Sales Permittee by the DEC. The field must contain the letter “R” followed by 5 numeric digits. (e.g. R00001).
Forms: none
Option C/Third-Party Software File TypesFiles: 25, 27
Required: yes
Column Type: reporting
Maximum Width: 6
Data Type: Character
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
Option C/Third-Party Software File TypesFiles: 25
Required: yes
Column Type: reporting
Maximum Width: 6
Data Type: Decimal
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.
Scroll office ignore | |||||||||
---|---|---|---|---|---|---|---|---|---|
|
Forms: 25
Option C/Third-Party Software File TypesFiles: 25
Required: yes
Column Type: reporting
Maximum Width: 8
Data Type: Numeric
Scroll office only | ||
---|---|---|
|
The county where the application was made (Form 26) or where the private applicator intends to apply the pesticide (Form 27). A list of county codes is included in the appendix. As an added convenience, a county codepopup dialog is available in Options A and B to help you select the correct county code. .
For applications that cross a county, municipality, township, or zip code boundaries, you must enter complete information for each location where the pesticide application occurred or will occur. Do this by entering a new row for each separate location. Distribute the total amount applied (or intended to be applied) among the rows, making your best estimate for how much was or will be applied in each location.
Forms: 26, 27
Option C/Third-Party Software File TypesFiles: 26, 27
Required: yes
Column Type: reporting
Maximum Width: 2
Data Type: Numeric
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):
Scroll office ignore |
---|
|
|
Scroll office only |
---|
-> mm/dd/yyyy -> mm-dd-yyyy -> mm-dd -> mm/dd |
Form 26 includes an End Date column that is used to specify the end of a date range where the Application 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
Option C/Third-Party Software File TypesFiles: 26, 27
Required: Application Date, Sales Date: yes; End Date: no
Column Type: reporting
Maximum Width: 10
Data Type: Date
Scroll office only | ||
---|---|---|
|
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
Option C/Third-Party Software File TypesFiles: none
Required: no
Column Type: record keeping
Maximum Width: 50
Data Type: Character
Indicates whether the sales on Form 25 are to other commercial permit holders for resale or to certified applicators for end use.
Forms: 25
Third-Party Software Files: 25
Required: yes
Column Type: reporting
Maximum Width: 1
Data Type: Character
Domain: Third-Party Software Files - there are separate fields for each indicator. Enter "X" in either the end use or resale field, but not both.
Option A & B - click the radio button that corresponds to the appropriate sales type.
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). The first part may have up to six digits, the second up to five, and the third optional part up to six. Do not include any leading zeroes (e.g. 3125-474, not 003125-00474).
Scroll office ignore | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
This column and the Product Name can be filled in by selecting a product in the EPA Reg Number List (Options A & B) or by typing in the cell.
Forms: 25, 26, 27
Option C/Third-Party Software File TypesFiles: 25, 26, 27
Required: yes
Column Type: reporting
Maximum Width: 24
Data Type: Character
Scroll office only | |||||
---|---|---|---|---|---|
|
Method used to apply the pesticide (broadcast, hand placement, aerial, etc.)
Forms: 26
Option C/Third-Party Software File TypesFiles: none
Required: no
Column Type: record keeping
Maximum Width: 50
Data Type: Character
Report the village, town or city where the pesticide was applied (Form 26) or the purchaser intended to apply the pesticide (Form 27). The municipality name should match the zip code (e.g., 11375 should be Forest Hills and not Queens).
For applications that cross a county, municipality, township, or zip code boundaries, you must enter complete information for each location where the pesticide application occurred or will occur. Do this by entering a new row for each separate location. Distribute the total amount applied (or intended to be applied) among the rows, making your best estimate for how much was or will be applied in each location.
Forms: 26, 27
Option C/Third-Party Software File TypesFiles: 26, 27
Required: yes
Column Type: reporting
Maximum Width: 30
Data Type: Character
Enter the specific location where the pesticide was applied (e.g. greens 3 & 7 of golf course; front lawn area, restaurant kitchen, etc.)
Forms: 26
Option C/Third-Party Software File TypesFiles: none
Required: no
Column Type: record keeping
Maximum Width: 50
Data Type: Character
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 (Option A & B) or by typing in the cell.
Forms: 25, 26, 27
Option C/Third-Party Software File TypesFiles: 25, 26, 27
Required: yes
Column Type: reporting
Maximum Width: 65
Data Type: Character
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
Option C/Third-Party Software File TypesFiles: 26
Required: yes
Column Type: reporting
Maximum Width: 13
Data Type: Decimal
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
Option C/Third-Party Software File TypesFiles: 27
Required: yes
Column Type: reporting
Maximum Width: 13
Data Type: Decimal
Indicates whether a pesticide sales permittee made sales during the report year.
Forms: none
Option C/Third-Party Software File TypesFiles: 25, 27
title | Option C/Third-Party Software |
---|
Required: yes
Column Type: reporting
Maximum Width: 1
Data Type: Numeric
Domain: “0” if sales were made
in the report year OR a; “3” if no sales were made.
IfNotes: If column set to “3” (No Sales), all other fields
exceptexcept Commercial Permit Number must be empty.
Required: yes
Column Type: reporting
Maximum Width: 1
Data Type: Numeric
Enter the name of the targeted pest(s). The targeted pest or organism must be listed on the pesticide label.
Forms: 26
Option C/Third-Party Software File TypesFiles: none
Required: no
Column Type: record keeping
Maximum Width: 50
Data Type: Character
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.
Div | |||||
---|---|---|---|---|---|
| |||||
|
In Options A, B and D 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.
Scroll office ignore | ||||
---|---|---|---|---|
|
|
|
Forms: 25,26, 27
Option C/Third-Party Software File TypesFiles: 25, 26, 27
Required: yes
Column Type: reporting
Maximum Width: 2
Data Type: Character
Scroll office only | ||
---|---|---|
|
The five-digit zip code where the pesticide was applied (Form 26) or where the applicator intended to apply the pesticide (Form 27).
For applications that cross a county, municipality, township, or zip code boundaryboundaries, you must enter complete information for each location where the pesticide application occurred or will occur. Do this by entering a new row for each separate location. Distribute the total amount applied (or intended to be applied) among the rows, making your best estimate for how much was or will be applied in each location.
Forms: 26, 27
Option C/Third-Party Software File TypesFiles: 26, 27
Required: yes
Column Type: reporting
Maximum Width: 5
Data Type: Numeric