Office of Pesticide Programs PPIS Data Dictionary January 12, 2021


Office of Pesticide Programs
PPIS Data Dictionary

&z.

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

Table of Contents

1	FIFRA Section 3 and 24C pesticide registration data files and vocabularies	3

1.1	AGENT.TXT	3

1.2	ALT PROD Wl.TXT	4

1.3	CHEMCAS.TXT	4

1.4	CHEMNAME.TXT	5

1.5	CHMNTYPE.TXT	5

1.6	C OMP ANY. TXT	6

1.7	CTREASON.TXT	7

1.8	DIST.TXT	7

1.9	I OR YIN AMI:.TXT	8

1.10	FORMULA.TXT	8

1.11	NAMETYPE.TXT	9

1.12	PESTCAT.TXT (similar file exists: TYPENAME.TXT)	9

1.13	PESTNAME.TXT	9

1.14	PRODMGR.TXT	10

1.15	PRODPEST.TXT	10

1.16	PRODSITE.TXT	11

1.17	PROD TYPE. TXT	11

1.18	PRODUCT.TXT	12

1.19	PRODXFER. TXT	13

1.20	SITENAME.TXT	13

1.21	TYPENAME.TXT (similar file exists: PESTCAT.TXT)	14

2	FIFRA section 24(c) pesticide registration data files and vocabularies	15

2.1	I ORY124C.TXT	15

2.2	PEST24C.TXT	15

2.3	PROD24C.TXT	16

2.4	SITE24C.TXT	18

2.5	TYPE24C.TXT	18

Office of Pesticide Program

2

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

The Pesticide Product Information System (PPIS) contains information concerning all Pesticide products
registered in the United States. It includes registrant name and address, chemical ingredients, toxicity
category, product names, distributor brand names, site/pest uses, pesticide type, formulation code, and
registration status.

The PPIS master file currently resides on an Oracle server located in Crystal City, Virginia. The files
located in this download area are extracts of the Oracle files and are presented in text file format to enable
interested parties to access them using a variety of database and spreadsheet software.

These files are being made available to the public to enable interested parties to download all or any part
of the pesticide product information and develop customized queries and reports. Organizations often
request that the Office of Pesticide Programs provide copies of these files in slightly different formats,
requiring OPP staff to perform time consuming special retrievals. By presenting these files in a standard
format, OPP is providing the same information in the same format to all interested parties.

The following file descriptions contain file structures, including the column names, column descriptions,
column date types, and formats and lengths of the data, arranged alphabetically by file name. There are
four sections listed below and each section addresses a specific type of registration or process

1 FIFRA Section 3 and 24C pesticide registration data files and vocabularies
1.1 AGENT.TXT

Description. Agent.TXT contains the registrant's designated agent name and address information.

Note:

• This file only contains agents for registrants registered FIFRA section 3, distributor products and
section 24(c) pesticide products.

• This file only contains active and inactive products.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

CONR

EPA assigned number for each registrant or
distributor. The first 6 digits of every pesticide
product registration number is the 'CO NR'.
Link to the COMPANY file using CO NR to
obtain the associated name and address
information.

Numeric

CO NAME

First line of registrant, agent, or distributor name.

Character

CONAME2

Second line of registrant, agent, or distributor
name. A COMPANY record of an agent is
reflected when the CO NAME2 begins with the
words "AGENT FOR:".

Character

126

CO STREET

Street address of registrant, agent or distributor

Character

127

186

COCITY

City address of pesticide registrant, agent or
distributor.

Character

187

236

CO STATE

State code of registrant, agent or distributor.

Character

237

238

CO ZIP

5-digit zip code of registrant, agent or distributor.

Character

239

243

CO CONTACT

Company contact person. (The Agency makes
every effort to ensure that this information is
accurate. However, because companies are not
required to provide this information, it may in

Character

244

283

Office of Pesticide Program

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

some cases be missing or out of date.)

COPHONE

Company phone number. (The Agency makes
every effort to ensure that this information is
accurate. However, because companies are not
required to provide this information, it may in
some cases be missing or out of date.)

Character

284

303

1.2 ALT PROD NM.TXT

Description: ALT_PROD_NM.TXT contains information about the registration's product name status.

NOTE:

• This file contains only FIFRA section 3 registrations.

• This file contains only registrations which have Active and Inactive status.

No.

Column
Name

Column Description

Data
Type

Length

Dec

Start

End

REGNR

EPA assigned pesticide product registration number.
When displaying this number, an edit mask of
7,77,77,9-7,777,9 or 999999-99999 should be used.
(NOTE: The first 6 digits of every pesticide product
registration number reflects the EPA assigned
registrant company number 'CO NR'.)

Numeric

Product

Alternate

Name

Registration product name. A registration can have
multiple product names

Characte
r

Product
Alternate
Name Type

Product name status type. The values are: Active,
Inactive and Alternate

Characte
r

1.3 CHEMCAS.TXT

Description: CHEMCAS.TXT provides a crosswalk between the OPP PCCODE and the Chemical
Abstract Service (CAS Number).

No.

Column
Name

Column Description

Data
Type

Length

Dec

Start

End

PCCODE

EPA assigned pesticide chemical code also commonly
referred to as active ingredient code, Shaughnessy
code, chemical code. (NOTE: Link to the
CHEMNAME file using PC CODE' to obtain the
associated chemical names infield 'PC NAME'.)

Numeric

CASNR

The Chemical Abstract Service Registry Number
associated with each of the EPA designated chemical
codes (PC CODE). A single 'CAS NR' may have
multiple associated 'PC CODE' and a single
'PC CODE' may have multiple associated 'CAS NR'.
The 10-digit field should be displayed in the format
ZZZZZZ9-99-9.

Numeric

Office of Pesticide Program

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

1.4 CHEMNAME.TXT

Description: CHEMNAME.TXT contains a list of chemical names along with their associated OPP
PCCODE. The file includes common names, synonyms, scientific, and preferred names for chemicals
which are or were regulated by OPP.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

1

PCCODE

EPA assigned pesticide chemical code also
commonly referred to as active ingredient code,
Shaughnessy code, chemical code. (NOTE: Link
to the CHEMNAME file using 'PC_CODE' to
obtain the associated chemical names infield
'PC NAME'.)

Numeric

6



1

6

2

CNAMETYPE

Pesticide category chemical Type can be:

•	ANSI

•	ISO

•	BSI

•	IUPAC

•	WASSA

•	ESA

•	ESJ

•	MAFJ

•	CSA

•	ICPC

•	FCH

•	JMAF

•	CAS 9CI

•	CAS 8CI

•	CAS 7CI

•	CAS 6CI

•	Other Common

•	Other Systematic

•	Trade

•	Discontinued Name

Character

20



7

26

3

PC NAME

Chemical name associated with each 'PC CODE'

Character

270



27

296

4.

DISPLAYIND

Indicates if the chemical name is used as the
display name

Character

1



297

297

1.5 CHMNTYPE.TXT

Description: CHMNTYPE.TXT contains the information for chemical name types.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

1

INTSEQ

EPA assigned number for each chemical name
type

Character

2



1

2

2

CNAMETYPE

Pesticide category chemical Type can be:

•	ANSI

•	ISO

•	BSI

•	IUPAC

•	WASSA

Character

100



3

102

Office of Pesticide Program

5

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

• ESA

• ESJ

• MAFJ

• CSA

• ICPC

• FCH

• JMAF

• CAS 9CI

• CAS 8CI

• CAS 7CI

• CAS 6CI

• Other Common

• Other Systematic

• Trade

• Discontinued Name

1.6 C OMP ANY. TXT

Description: COMPANY.TXT contains basic name and address information for all companies which
have been assigned an EPA company number.

NOTE:

• This file contains only those registrants with a registered FIFRA section 3 or section 24(c)
pesticide product.

• The file contains only the active and cancelled products.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

CONR

EPA assigned number for each registrant or
distributor. (NOTE: The first 6 digits of every
pesticide product registration number is the
'CO NR'. Link to the COMPANY file using
CO NR to obtain the associated name and
address information.)

Numeric

CO NAME

First line of registrant, agent, or distributor name

Character

CONAME2

Second line of registrant, agent, or distributor
name. (NOTE: A COMPANY record of an
agent is reflected when the CONAME2 begins
with the words "AGENT FOR:".)

Character

126

CO STREET

Street address of registrant, agent or distributor

Character

127

186

COCITY

City address of pesticide registrant, agent or
distributor.

Character

187

236

CO STATE

State code of registrant, agent or distributor

Character

237

238

CO ZIP

5-digit zip code of registrant, agent or distributor

Character

239

243

COCONTACT

Company contact person. (The Agency makes
every effort to ensure that this information is
accurate. However, because companies are not
required to provide this information, it may in
some cases be missing or out of date.)

Character

244

283

COPHONE

Company phone number. (The Agency makes
every effort to ensure that this infonnation is
accurate. However, because companies are not
required to provide this infonnation, it may in

Character

284

293

Office of Pesticide Program

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

some cases be missing or out of date.)

1.7 CTREASON.TXT

Description: CTREASON.TXT describes the cancellation code.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

CTCODE

Cancellation or transfer reason code. (NOTE:
Link to the CTREASON file using 'CT CODE' to
obtain the associated description in 'CT DESC'.)

Character

CTDESC

Cancellation or transfer description associated
with each'CT CODE'.

Character

1.8 DIST.TXT

Description . DIST.TXT contains information about companies who market section 3 registrations under a
distributor brand name. Information in this file includes the basic Section 3 Registration Number, EPA
company number associated with the distributor, and the name of the distributor brand product, and status
(Inactive, Alternate, or Active).

Note:

• This file only contains active and inactive products.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

REGNR

EPA assigned pesticide product registration
number. When displaying this number, an edit
mask of ZZZZZ9-ZZZZ9 or 999999-99999 should
be used. (NOTE: The first 6 digits of every
pesticide product registration number reflects the
EPA assigned registrant company number
'CO NR'.)

Numeric

DISTNR

EPA assigned number for each distributor. (NOTE:
The 'DIST NR' would appear on a distributor
product label following the second hyphen in the
product registration number. An example would be
111111 -22222-3 3 3 3 3 3 where 111111 is the EPA
registrant number, 111111-22222 the EPA pesticide
product registration number, 111111-22222-333333
the distributor product number, and 333333 the
EPA assigned distributor number 'DIST NR'. Link
to the COMPANY file using DISTNR/CONR to
obtain the associated name and address
information.)

Numeric

APPLDATE

The application date associated with a distributor
product registration request. The APPL DATE is
provided in the format YYYYMMDD.

Date

CANDATE

The cancellation or transfer date of a pesticide
product registration. The CAN DATE is provided
in the format YYYYMMDD.

Date

PRODNAME

The pesticide product name as identified to EPA by
the registrant or distributor.

Character

103

Office of Pesticide Program

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

DIST STATUS

Product Name Status: Inactive, Alternate, or Active

Character

104

113

RIST STATUS

Product Status Description

Character

114

134

RIST DATE

Product Status Date

Date

135

142

1.9 FORMNAME.TXT

Description: FORMNAME.TXT describes the product FORMCODE.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

FORMCODE

The pesticide product form reflected as a 2-digit
code. (NOTE: Link to the FORMNAME file using
'FORM CODE' to obtain the associated description
in 'FORM DESC'.)

Character

FORMDESC

The descriptive name associated with a pesticide
product physical form (i.e. granular, dust, liquid).

Character

1.10 FORMULA.TXT

Description: FORMULA.TXT contains the registration number, OPP PCCODE (chemical code), and
percentages of each active ingredient that is contained in the product.

Note:

• This file contains only FIFRA section 3 products.

• This file contains only products with 'Active" product name status

• This file contains only products with the following status:

• Conditionally Registered

• Registered

• Reinstated

• Canceled

• Reregistered

• Conditionally Reregistered active and inactive products.

• This file contains only products with PC CODE not starting with "7'. '8", or '9".

No.

Column
Name

Column Description

Data Type

Length

Dec

Start

End

REGNR

EPA assigned pesticide product registration number.
When displaying this number an edit mask of
ZZZZZ9-ZZZZ9or 999999-99999 should be used.
(NOTE: The first 6 digits of every pesticide product
registration number reflects the EPA assigned
registrant company number 'CO NR'.)

Numeric

PCCODE

EPA assigned pesticide chemical code also commonly
referred to as active ingredient code, Shaughnessy
code, chemical code. (NOTE: Link to the
CHEMNAME file using 'PC CODE' to obtain the
associated chemical names infield 'PC NAME'.)

Numeric

PCPCT

The 'PC CODE' percentage appearing in the pesticide
product formulation.

Numeric

Office of Pesticide Program

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

1.11 NAMETYPE.TXT

Description: NAMETYPE.TXT describes the Chemical Name Type code.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

1

CNAMETYPE

Pesticide category chemical Type can be:

ANSI

ISO

BSI

IUPAC

WASSA

ESA

ESJ

MAFJ

CSA

ICPC

FCH

JMAF

CAS 9CI

CAS 8CI

CAS 7CI

CAS 6CI

Other Common

Other Systematic

Trade

Discontinued Name

Character

1



1

1

2

CNAMEDESC

Pesticide category chemical name associated with
each chemical Type

Character

79



2

80

1.12 PESTCAT.TXT (similar file exists: TYPENAME.TXT)

Description. PESTCAT.TXT describes the pesticide category code.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

1

TYPECODE

The type of pesticide product expressed as a
code (i.e. insecticide, fungicide,
rodenticide). (NOTE: Link to the
TYPENAME file using 'TYPE CODE' to
obtain the associated descriptive type of
product name in field 'TYPE DESC'.)

Numeric

2



1

2

2

TYPE DESC

Pesticide category name description

Character

100



3

102

3

TYPENAMEDESC

Pesticide category name long description
(may not have data)

Character

1000



103

1002

1.13 PESTNAME.TXT

Description: PESTNAME.TXT describes the EPA Pesticide code.

No.

Column
Name

Column Description

Data Type

Length

Dec

Start

End

1

PEST CODE

EPA assigned code for each pest associated with a

Character

9



1

9

Office of Pesticide Program

9

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

pesticide product. (NOTE: Link to the PESTNAME
file using 'PESTCODE' to obtain the associated
descriptive pest name in field 'PEST DESC'.)

PESTDESC

The pest name description associated with each
'PEST CODE'.

Character

100

109

1.14 PRODMGR. TXT

Description: PRODMGR.TXT contains contact information about each Product Manager (PM). There
are additional PMTEAM values appearing on this table, and the file only contains the teams with
('0717273747576777879') as the second number. There may be multiple records (contacts) for the
same PM TEAM value.

No.

Column
Name

Column Description

Data Type

Length

Dec

Start

End

PM_TEAM

The assigned code for each product manager (PM).
A PM is primarily responsible for: processing
applications for new and amended product
registration, petitions for tolerances, experimental-
use permits, and special local need applications.
(NOTE: Link to the PRODMGR file using
'PM TEAM' to obtain the associated descriptive
product manager name in field 'PM NAME' and
telephone number in'PM PHONE'.)

Character

PM NAME

The product manager (PM) name.

Character

PM PHONE

The product manager (PM) telephone number.

Character

1.15 PRODPEST.TXT

Description: PRODPEST.TXT contains information about the pests for which a particular pesticide
product is registered.

Note:

• This file contains only FIFRA section 3 products.

• This file contains only products of these status: Conditionally Registered, Registered, Reinstated,
Cancelled.

• This file contains only products with these site statuses: Approved and Cancelled.

No.

Column
Name

Column Description

Data Type

Length

Dec

Start

End

REGNR

Numeric

PESTCODE

EPA assigned code for each pest associated with a
pesticide product. (NOTE: Link to the PESTNAME
file using 'PEST CODE' to obtain the associated
descriptive pest name in field 'PEST DESC'.)

Character

Office of Pesticide Program

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

1.16 PRODSITE.TXT

Description . PRODSITE.TXT contains the site code of each site for which a pesticide product is
registered.

Note:

• This file contains only FIFRA section 3 products

• This file contains only products of these status: Conditionally Registered, Registered, Reinstated,
Cancelled.

• This file contains only products with these site statuses: Approved and Cancelled.

No.

Column
Name

Column Description

Data Type

Length

Dec

Start

End

REGNR

Numeric

SITECODE

EPA assigned code for each site associated with a
pesticide product. (NOTE: Link to the SITENAME
file using 'SITE CODE' to obtain the associated
descriptive site name in field 'SITE DESC'.)

Numeric

1.17 PRODTYPE.TXT

Description . PRODTYPE.TXT contains the EPA registration number and a code indicating product type
such as insecticide, rodenticide, fungicide.

Note:

• This file contains only FIFRA section 3 products.

• This file contains only the products that have Active and Inactive product status as follows:

o Conditionally Registered
o Registered
o Reinstated
o Canceled
o Reregistered

• This file contains only the products that have Active product name status.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

REGNR

EPA assigned pesticide product registration
number. When displaying this number an edit
mask of ZZZZZ9-ZZZZ9or 999999-99999 should
be used. (NOTE: The first 6 digits of every
pesticide product registration number reflects the
EPA assigned registrant company number
'CO NR'.)

Numeric

TYPECODE

The type of pesticide product expressed as a code
(i.e. insecticide, fungicide, rodenticide). (NOTE:

Numeric

Office of Pesticide Program

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

Link to the TYPENAME file using 'TYPECODE'
to obtain the associated descriptive type of product
name in field 'TYPE DESC'.)

1.18 PRODUCT.TXT

Description: PRODUCT.TXT contains basic information for each EPA registration number such as the
product name, status (active/canceled), approval date, physical form, toxicity category, if product is
restricted in use, and the assigned product manager (PM).

Note:

• Active products have a CAN_DATE of 00000000.

• This file contains only FIFRA section 3 products.

• This file contains only the products that have Active and Inactive product status, and the status is
not Withdrawn.

• This file contains only the products that have Active product name status.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

REGNR

EPA assigned pesticide product registration
number. When displaying this number an edit
mask of ZZZZZ9-ZZZZ9or 999999-99999
should be used. (NOTE: The first 6 digits of
every pesticide product registration number
reflects the EPA assigned registrant company
number'CO NR'.)

Numeric

FORMCODE

The pesticide product form reflected as a 2-digit
code. (NOTE: Link to the FORMNAME file
using 'FORM CODE' to obtain the associated
description in'FORM DESC'.)

Numeric

TOXCODE

The signal word of the pesticide that is associated

with the product. The mapping is:

'Danger' = 1

'Warning' = 2

'Caution' = 3

'None' = 0

Numeric

APPRDATE

The pesticide product registration approval date.
The APPR D ATE is provided in the format
YYYYMMDD

Date

CANDATE

The cancellation or transfer date of a pesticide
product registration. The CAN DATE is
provided in the format YYYYMMDD.

Date

CTCODE

A reason code for the product status change.
(NOTE: Link to the CTREASON file using
'CT CODE' to obtain the associated description
in 'CT DESC'.)

Character

PRODNAME

The pesticide product name as identified to EPA
by the registrant or distributor.

Character

102

RUPFLAG

Identifies if the product is a restricted use
product. The field values are 'T' for true and 'F'
for false.

Character

103

PMCODE

The PM team number that is associated with the
product

Character

104

105

Office of Pesticide Program

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

COND FLAG

Identifies if the product was conditionally

Character

106

registered under FIFRA 3(c)(7) or

unconditionally registered under FIFRA 3(c)(5).

The field values are 'T' for true (conditionally

registered) and F' for false (unconditionally

registered).

1.19 PRODXFER. TXT

Description: PRODXFER.TXT contains product transfer information with the previous registration
number, new registration number, transfer reason, and transfer date.

Note:

• This file contains only FIFRA section 3 products.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

PREVREGNR

EPA assigned pesticide product registration
number (identical to REG NR except this field
designates the former pesticide product
registration number as part of a transfer action on
the PRODXFER file). When displaying this
number an edit mask of ZZZZZ9-ZZZZ9
or999999-99999 should be used. (NOTE: The
first 6 digits of every pesticide product
registration number reflects the EPA assigned
registrant company number 'CO NR'.)

Numeric

REGNR

EPA assigned pesticide product registration
number. When displaying this number an edit
mask of ZZZZZ9-ZZZZ9or 999999-99999
should be used. (NOTE: The first 6 digits of
every pesticide product registration number
reflects the EPA assigned registrant company
number'CO NR'.)

Numeric

CTCODE

Cancellation or transfer reason code. (NOTE:
Link to the CTREASON file using 'CT CODE' to
obtain the associated description in 'CT DESC'.)

Character

XFER DATE

Date

1.20 SITENAME.TXT

Description: SITENAME.TXT describe the site code.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

SITECODE

EPA assigned code for each site associated with a
pesticide product. (NOTE: Link to the
SITENAME file using 'SITE CODE' to obtain
the associated descriptive site name in field
'SITE DESC'.)

Numeric

SITEDESC

The site name description associated with each
'SITE CODE'.

Character

100

109

Office of Pesticide Program

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

1.21 TYPENAME.TXT (similar file exists: PESTCAT.TXT)

Description: TYPENAME.TXT describes the type code. There are additional TYPECODE values
appearing on this table.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

1

TYPECODE

The type of pesticide product expressed as a code
(i.e. insecticide, fungicide, rodenticide). (NOTE:
Link to the TYPENAME file using
'TYPE CODE' to obtain the associated
descriptive type of product name in field
'TYPE DESC'.)

Numeric

2



1

2

2

TYPEDESC

The type of pesticide product description
associated with each 'TYPE CODE'.

Character

78



3

80

Office of Pesticide Program

14

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

2 FIFRA section 24(c) pesticide registration data files and vocabularies
2.1 FORM24C.TXT

Description: FORM24C.TXT contains the special local need FIFRA section 24(c) registration,
PCCODE (OPP active ingredient code), and formulation percentage of each active ingredient.

Note:

• Link PC CODE to the CHEMNAME file for available chemical names.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

M24C_SLN

A special local need FIFRA section 24(c)
registration. The first two characters of the 24(c)
represent the state code, the next two digits
represent the year the24(c) registration was issued,
and the remaining four digits represent the
registration sequence number. The 24(c) may be
displayed as AL-98-0001 but is more often left as
AL980001.

Character

PCCODE

EPA assigned pesticide chemical code, also
commonly referred to as active ingredient code,
Shaughnessy code, chemical code. (NOTE: Link
to the CHEMNAME file using 'PC_CODE' to
obtain the associated chemical names infield
'PC NAME'.)

Numeric

PCPCT

The 'PC CODE' percentage appearing in the
pesticide product formulation.

Numeric

2.2 PEST24C.TXT

Description: PEST24C.TXT contains information about the pests for which a special local need FIFRA
section 24(c) is registered.

Note:

• Link PESTCODE to the PESTNAME file to convert the code to a descriptive pest name.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

M24C_SLN

Character

PESTCODE

EPA assigned code for each pest associated with a
pesticide product. (NOTE: Link to the
PESTNAME file using 'PEST CODE' to obtain
the associated descriptive pest name in field
'PEST DESC'.)

Character

Office of Pesticide Program

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

2.3 PROD24C.TXT

Description . Contains basic information on each special local need FIFRA section 24(c) registration such
as the registrant company number, underlying FIFRA section 3 product registration number, product
name, physical form, toxicity category, if the product is restricted in use, and the assigned product
manager (PM).

Note:

• Link CO_NR to the AGENT or COMPANY file for available registrant names and addresses.

• Link REG NRto the PRODUCT file for available information on the FIFRA section 3 pesticide
product.

• Link FORMCODE to the FORMNAME file to convert the code to a descriptive name.

• All registrations on this file are currently active.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

M24C_SLN

Character

CONR

Numeric

REGNR

EPA assigned pesticide product registration
number. When displaying this number an edit mask
of ZZZZZ9-ZZZZ9or999999-99999 should be
used. (NOTE: The first 6 digits of every pesticide
product registration number reflects the EPA
assigned registrant company number 'CO NR'.)

Numeric

FORMCODE

The pesticide product form reflected as a 2-digit
code. (NOTE: Link to the FORMNAME file using
'FORM CODE' to obtain the associated description
in'FORM DESC'.)

Numeric

TOXCODE

The signal word of the pesticide that is associated

with the product. The mapping is:

'Danger' = 1

'Warning' = 2

'Caution' = 3

'None' = 0

Numeric

SLNTYPE

Three 3-character values are displayed in this field:

The type of special local need FIFRA section 24(c)
registration is represented as one or more of the
following values: (NOTE: Up to 3 values are
captured for each registration.)

A - To permit use of a new product.

Character

Office of Pesticide Program

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary





To amend EPA registrations for one or more of the
following purposes:















B1 - To permit use on additional crops or animals.
B2 - To permit use at additional sites.
B3 - To permit use against additional pests.
B4 - To permit use of additional application
B5 - To permit use at different application rates.
B6 or C - Other.















On older registrations there may appear the
following:















To prescribe special label directions for one or both
of the following purposes:















B6A - Preventing unreasonable adverse effects on
man or the environment under local use conditions.















B6B - Providing for local use conditions affecting
pesticide efficacy.











7

SLNNEED

The nature of the special local need for the FIFRA
section24(c) registration is represented by one of
the following:

A - There is no pesticide product registered by EPA
for such use.

B - There is no EPA-registered pesticide product
which, under the conditions of use within the State,
would be as safe and/or as efficacious for such use
within the terms and conditions of EPA registration.

C - An appropriate EPA-registered pesticide
product is not available.

Character

1



38

38

8

SLNUSE

If this 24(c) special local need registration is an
amendment to an EPA-registered product, is it for a
"changed use pattern" as defined in 40 CFR
162.3(k)? The values for this field are blank, Y for
Yes, orN for No.

Character

1



39

39

9

RUPFLAG

Identifies if the product is a restricted use product.
The field values are 'T' for true and 'F' for false.

Character

1



40

40

10

PRODNAME

The pesticide product name as identified to EPA by
the registrant or distributor.

Character

55



41

95

11

SLN_NAME

To be used as an append to the 70-character product
name on special local need FIFRA section 24(c)
registrations. The 45-characters contain use site
information.

Character

45



96

140

12

PMCODE

The PM team number that is associated with the
product

Character

2



141

142

Office of Pesticide Program

17

January 12, 2021

-------
Environmental Protection Agency

PPIS Data Dictionary

2.4 SITE24C.TXT

Description: SITE24C.TXT contains information about the sites for which a special local need FIFRA
section 24(c) is registered.

Note:

• Link SITECODE to the SITENAME file to convert the code to a descriptive site name.

Note:

• All registrations on this file are currently active.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

M24C_SLN

Character

SITECODE

EPA assigned code for each site associated with a
pesticide product. (NOTE: Link to the SITENAME
file using 'SITE CODE' to obtain the associated
descriptive site name infield 'SITE DESC'.)

Numeric

2.5 TYPE24C.TXT

Description: TYPE24C.TXT File contains information about the type of special local need FIFRA
section 24(c) product, (i.e. insecticide, rodenticide, fungicide, etc.).

Note:

• Link TYPECODE to the TYPENAME file to convert the code to a descriptive product type
name.

No.

Column Name

Column Description

Data Type

Length

Dec

Start

End

M24C_SLN

Character

TYPECODE

The type of pesticide product expressed as a code
(i.e. insecticide, fungicide, rodenticide). (NOTE:
Link to the TYPENAME file using 'TYPE CODE'
to obtain the associated descriptive type of product
name in field 'TYPE DESC'.)

Numeric

Office of Pesticide Program

January 12, 2021

-------