All EPA (Label) Products For Counties Using Text Files

Back to Permit/Use Reporting Computer Program Updates

Instructions for Using Update files product.exe and prodsite.exe

It may be helpful to print out these instructions.

Download Help

To download a file to your hard drive or to a floppy drive, click on the file name. In the "Save As" dialog box, select the
drive and directory location where the file should be saved.

Download zip files:

product.exe (794 kb) Updated 05/02/08
prodsite.exe (1.8 mb) Updated 05/02/08
prodchem.exe (425 kb) Updated 05/02/08

Download text files:

chem.txt (112 kb) Updated 05/02/08
compadd.txt (791 kb) Updated 05/02/08
prodtype.txt (819 kb) Updated 05/02/08
site.txt (89 kb) Updated 05/02/08
typepest.txt (1 kb) Updated 05/02/08

Description

These files contain all the records in the label files: PRODUCT.DAT and PRODSITE.DAT.

FORMATS FOR LABEL FILES

Format for file PRODUCT.DAT

Field Name	Format	Length
MFG_FIRMNO	INTEGER	7
LABEL_SEQ_NO	INTEGER	5
REVISION_NO	ALPHA	2
REG_FIRMNO	INTEGER	7
PRODSTAT_IND	ALPHA	1
DRYLIQUID_SW	ALPHA	1
FORMULA_CD	ALPHA	2
PRODUCT_NAME	ALPHA	40
FUMIGANT_SW	ALPHA	1
RODENT_SW	ALPHA	1
CONFID_SW	ALPHA	1
AGRICCOM_SW	ALPHA	1
PRODNO	INTEGER	7

Format for file PRODSITE.DAT

Field Name	Format	Length
PRODNO	INTEGER	7
MFG_FIRMNO	INTEGER	7
LABEL_SEQ_NO	INTEGER	5
SITE_CODE	INTEGER	6

Format for file PRODCHEM.DAT

Field Name	Format	Length
PRODNO	INTEGER	7
CHEM_CODE	INTEGER	5
PRODCHEM_PCT	INTEGER	9

Format for file CHEM.DAT

Field Name	Format	Length
CHEM_CODE	INTEGER	5
CHEMNAME	ALPHA	170

Format for file PRODTYPE.DAT

Field Name	Format	Length
PRODNO	INTEGER	7
TYPEPEST_CD	ALPHA	2

Format for file COMPADD.DAT

Field Name	Format	Length
FIRMNO	ALPHA	7
MAIL_NAME	ALPHA	100
ADDRESS	ALPHA	50
CITY	ALPHA	20
STATE	ALPHA	2
ZIP	ALPHA	5
ZIP4	ALPHA	4

Format for file TYPEPEST.DAT

Field Name	Format	Length
TYPEPEST_CD	ALPHA	2
TYPEPEST_CAT	ALPHA	50

Popular Links