Office of Pesticide Programs PPIS Data Dictionary


Office of Pesticide Programs
PPIS Data Dictionary
S3
O 1
March 3, 2020

-------
Environmental Protection Agency
PPIS Data Dictionary
Table	of Contents
1	FIFRA Section 3 and 24C pesticide registration data files and vocabularies	4
1.1	AGENT.TXT	4
1.2	ALT PROD Wl.TXT	5
1.3	CHEMCAS.TXT	5
1.4	CHEMNAME.TXT	6
1.5	CHMNTYPE.TXT	6
1.6	C OMP ANY. TXT	7
1.7	CTREASON.TXT	8
1.8	DIST.TXT	8
1.9	I OR YIN AMI:.TXT	9
1.10	FORMULA.TXT	9
1.11	NAMETYPE.TXT	10
1.12	PESTCAT.TXT (similar file exists: TYPENAME.TXT)	10
1.13	PESTNAME.TXT	10
1.14	PRODMGR.TXT	11
1.15	PRODPEST.TXT	11
1.16	PRODSITE.TXT	12
1.17	PROD TYPE. TXT	12
1.18	PRODUCT.TXT	13
1.19	PRODXFER. TXT	14
1.20	SITENAME.TXT	14
1.21	TYPENAME.TXT (similar file exists: PESTCAT.TXT)	15
2	FIFRA section 24(c) pesticide registration data files and vocabularies	16
2.1	I ORY124C.TXT	16
2.2	PEST24C.TXT	16
2.3	PROD24C.TXT	17
2.4	SITE24C.TXT	19
2.5	TYPE24C.TXT	19
3	PDMS PROCESS	20
3.1	PDMS_A_YYYYMMDD.TXT	20
3.2	PDMS_B_YYYYMMDD.TXT	21
3.3	PDMS B1 YYYYMMDD.TXT	22
Office of Pesticide Program
2
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary
3.4	PDMS_B2_20180604.TXT	22
3.5	PDMS_C_YYYYMMDD.TXT	23
3.6	PDMS_D_YYYYMMDD.TXT	24
3.7	PDMS_E_YYYYMMDD.TXT	24
3.8	PDMS_G_YYYYMMDD.TXT	25
4 RI PROCESS	27
4.1	RFCLUF.TXT	27
4.2	RFCNDLUF.TXT	27
4.3	RFMPRF.TXT	28
4.3	RFMPRY2K.TXT	29
4.4	RI PM .TXT	31
4.5	RFSCCNF.TXT	32
4.6	RFSPFR.TXT	32
Office of Pesticide Program
3
May 17, 2018

-------
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
1
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
6

1
6
2
CO NAME
First line of registrant, agent, or distributor name.
Character
60

7
66
3
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
60

67
126
4
CO STREET
Street address of registrant, agent or distributor
Character
60

127
186
5
COCITY
City address of pesticide registrant, agent or
distributor.
Character
50

187
236
6
CO STATE
State code of registrant, agent or distributor.
Character
2

237
238
7
CO ZIP
5-digit zip code of registrant, agent or distributor.
Character
5

239
243
8
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
40

244
283
Office of Pesticide Program
4
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary

some cases be missing or out of date.)

9
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
10

284
293
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
1
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
11

1
11
2
Product
Alternate
Name
Registration product name. A registration can have
multiple product names
Characte
r
70

12
81
3
Product
Alternate
Name Type
Product name status type. The values are: Active,
Inactive and Alternate
Characte
r
10

82
91
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
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
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
10

7
16
Office of Pesticide Program
5
May 17, 2018

-------
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
253

27
278
4.
DISPLAYIND
Indicates if the chemical name is used as the
display name
Character
1

279
279
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
6
May 17, 2018

-------
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 COMPANY.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
1
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
6

1
6
2
CO NAME
First line of registrant, agent, or distributor name
Character
60

7
66
3
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
60

67
126
4
CO STREET
Street address of registrant, agent or distributor
Character
60

127
186
5
COCITY
City address of pesticide registrant, agent or
distributor.
Character
50

187
236
6
CO STATE
State code of registrant, agent or distributor
Character
2

237
238
7
CO ZIP
5-digit zip code of registrant, agent or distributor
Character
5

239
243
8
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
40

244
283
9
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
Character
10

284
293
Office of Pesticide Program
7
May 17, 2018

-------
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
1
CTCODE
Cancellation or transfer reason code. (NOTE:
Link to the CTREASON file using 'CT CODE' to
obtain the associated description in 'CT DESC'.)
Character
2

1
2
2
CTDESC
Cancellation or transfer description associated
with each'CT CODE'.
Character
78

3
80
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
1
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
11

1
11
2
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-333333 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
6

12
17
3
APPLDATE
The application date associated with a distributor
product registration request. The APPL DATE is
provided in the format CCYYMMDD.
Date
8

18
25
4
CANDATE
The cancellation or transfer date of a pesticide
product registration. The CAN DATE is provided
in the format CCYYMMDD.
Date
8

26
33
5
PRODNAME
The pesticide product name as identified to EPA by
the registrant or distributor.
Character
70

34
103
Office of Pesticide Program
8
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary
6
DIST STATUS
Product Name Status: Inactive, Alternate, or Active
Character
11

104
114
7
RIST STATUS
Product Status Description
Character
20

115
135
8
RIST DATE
Product Status Date
Date
8

136
143
1.9 FORMNAME.TXT
Description. FORMNAME.TXT describes the product FORMCODE.
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
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
2

1
2
2
FORMDESC
The descriptive name associated with a pesticide
product physical form (i.e. granular, dust, liquid).
Character
78

3
80
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
1
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
11

1
11
2
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

12
17
3
PCPCT
The 'PC CODE' percentage appearing in the pesticide
product formulation.
Numeric
7
4
18
24
Office of Pesticide Program
9
May 17, 2018

-------
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
10
May 17, 2018

-------
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'.)

2
PESTDESC
The pest name description associated with each
'PEST CODE'.
Character
100

10
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
CO',T,'273','475','67778','9') 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
1
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
2

1
2
2
PM NAME
The product manager (PM) name.
Character
30

3
32
3
PM PHONE
The product manager (PM) telephone number.
Character
13

33
45
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 status: Approved and Cancelled.
No.
Column
Name
Column Description
Data Type
Length
Dec
Start
End
1
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
11

1
11
2
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
9

12
20
Office of Pesticide Program
11
May 17, 2018

-------
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 status: Approved and Cancelled.
No.
Column
Name
Column Description
Data Type
Length
Dec
Start
End
1
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
11

1
11
2
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
9

12
20
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
1
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
11

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

12
13
Office of Pesticide Program
12
May 17, 2018

-------
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 blank CT_CODE and 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
1
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
11

1
11
2
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
2

12
13
3
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
1

14
14
4
APPRDATE
The pesticide product registration approval date.
The APPR DATE is provided in the format
CCYYMMDD
Date
8

15
22
5
CANDATE
The cancellation or transfer date of a pesticide
product registration. The CAN DATE is
provided in the format CCYYMMDD.
Date
8

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

31
32
7
PRODNAME
The pesticide product name as identified to EPA
by the registrant or distributor.
Character
70

33
102
8
RUPFLAG
Identifies if the product is a restricted use
product. The field values are 'T' for true and 'F'
for false.
Character
1

103
103
9
PMCODE
The PM team number that is associated with the
product
Character
2

104
105
10
COND FLAG
Identifies if the product was conditionally
Character
1

106
106
Office of Pesticide Program
13
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary

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
1
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
11

1
11
2
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
11

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

23
24
4
XFER DATE

Date
8

25
32
1.20 SITENAME.TXT
Description. SITENAME.TXT describe the site code.
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
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
9

1
9
2
SITEDESC
The site name description associated with each
'SITE CODE'.
Character
100

10
109
Office of Pesticide Program
14
May 17, 2018

-------
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
15
May 17, 2018

-------
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
1
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
8

1
8
2
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

9
14
3
PCPCT
The 'PC CODE' percentage appearing in the
pesticide product formulation.
Numeric
7
4
15
21
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
1
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
8

1
8
2
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
9

9
17
Office of Pesticide Program
16
May 17, 2018

-------
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.
• Link TOX_CODE to the TOXNAME file to convert the code to a descriptive name.
Note:
• All registrations on this file are currently active.
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
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
8

1
8
2
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
6

9
14
3
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
11

15
25
4
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
2

26
27
5
TOXCODE
Code associated with the toxicity (signal word) of
each pesticide product. (NOTE: Link to the
TOXNAME file using 'TOX CODE' to obtain the
associated descriptive toxicity name in field
'TOX DESC'.)
Numeric
1

28
28
6
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
Character
9

29
37
Office of Pesticide Program
17
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary


captured for each registration.)







A - To permit use of a new product.







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, or N 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
18
May 17, 2018

-------
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
1
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
8

1
8
2
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
9

9
17
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
1
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
8

1
8
2
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

9
10
Office of Pesticide Program
19
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary
3 PDMS PROCESS
The Pesticide Document Management System (PDMS)Database resided on an Oracle server located at
the Environmental Protection Agency (EPA). The files sent to the DPR public FTP site are extracts of the
Oracle data and are presented in ASCII fixed format to enable interested parties to access them using a
variety of database and spreadsheet software.
The following document contains file structures, arranged initially by importance, ten lookup tables by
file name. Each data element is described in the table where the format is presented.
3.1 PDMS A YYYYMMDD TXT
Description. This file contains the basic information for each document submitted to EPA including the
master record identifier (MRID), citation, author, and trade secret status.
Note:
• MRID is the unique identifier that ties basic product information to the other tables whose names
begin with "PDMS ".
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
MIRD
An 8-digit code assigned by EPA to
uniquely identify a document. MRIDs
assigned prior to 1987 begin with zero; after
1987, MRIDs begin with the number 4
except for re-registration documents which
begin with number 9.
Character
8

1
8
2
RECTYPE
Code distinguishing record types. Values
used include:
A: citation and trade secret status;
B: lab id and project No.;
C: submitter;
D: chemical;
E: subject;
G: related MRID.
Character
1

9
9
3
RECSEQ
Number distinguishing multiple occurrences
of single record type. Some fields have all
zeroes for the Record Sequence Number.
Numeric
3

10
12
4
CITATION
Bibliographic citation of the document.
May identify inert ingredients.
Character
1005

13
1017
5
KEYTYPE
Code to distinguish document formats and
includes: 1: published;
2: published monograph
3: correspondence
4: submittal
Character
1

1018
1018
6
KEYAUTHER
Last name(s) and first initial(s) of the
document author(s) in all capitals,
punctuated by slashes and terminated (if
less than 20 characters) by an asterisk. No
asterisk for studies after OPPIN conversion.
Character
20

1019
1028
7
KEYDATE
The date of the document's creation, in the
form 'YYbbbb' for published documents
and unpublished monographs, or
Character
6

1039
1044
Office of Pesticide Program
20
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary


'YYMMDD'for correspondence. Maybe
blank.





8
KEYTITLE
First twenty cliaracters of the tile of the
document, in all capitals or numerals,
punctuated by slashes.
Character
20

1045
1064
9
KEY NAME COUN
T
The count of the number of proper names
appearing on the title page of unpublished
documents.
Character
2

1065
1066
10
KEYPAGECOUNT
The number of pages in a document of
unpublished monographs
Character
5

1067
1071
11
KEYPARACOUNT
The number of paragraphs on the last page
of an unpublished monograph.
Character
2

1072
1073
12
KEYLINEl
For unpublished monographs, this element
contains the first 20 characters of the first
line on the last page of the document. For
correspondence-form documents, this
element contains the first 18 characters of
the first line of the first full paragraph in the
body of the document.
Character
20

1074
1093
13
KEYVOL
The volume number of the periodical in
which a published document appeared.
Character
5

1094
1098
14
KEYISSUE
The issue of the periodical in which a
published document appeared.
Character
5

1099
1103
15
KEYSTARTPAGE
The number of the page on which a
published document begins.
Character
5

1104
1108
16
KEYENDPAGE
The number of the page on which a
published document ends.
Character
5

1109
1113
17
TS_STATUS
A code indicating the results of preliminary
or subsequent determinations of the
releasability of a document to the public,
based on the presence of absence of content
considered to be trade secret or privileged
commercial or financial information. Codes
described in PDBS TS STATUS.
Character
2

1114
1115
3.2 PDMS B YYYYMMDD.TXT
Description: This table provides information on the laboratory project number.
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
MIRD
An 8-digit code assigned by EPA to uniquely
identify a document. MRIDs assigned prior to
1987 begin with zero; after 1987, MRIDs begin
with the number 4 except for re-registration
documents which begin with number 9.
Character
8

1
8
2
RECTYPE
Code distinguishing record types. Values used
include:
A: citation and trade secret status;
B: lab id and project No.;
C: submitter;
D: chemical;
E: subject;
G: related MRID.
Character
1

9
9
Office of Pesticide Program
21
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary
3
RECSEQ
Number distinguishing multiple occurrences of
single record type. Some fields have all zeroes
for the Record Sequence Number.
Numeric
3

10
12
4
LABID
EPA Company Number identifying a
laboratory in which the work reported in the
document was performed. EPA does not
include laboratories in the EPA Name &
Address file that is available publicly.
Laboratories begin with the number 9.
Character
6

13
18
5
LABPROJNR
Code by which the laboratory in LAB ID
identified their work and raw data records.
May occur multiple times for a single MRID.
Character
20

19
38
3.3 PDMS B1 YYYYMMDD.TXT
Description: This table provides information on the laboratory project number.
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
MIRD
An 8-digit code assigned by EPA to uniquely
identify a document. MRIDs assigned prior to
1987 begin with zero; after 1987, MRIDs begin
with the number 4 except for re-registration
documents which begin with number 9.
Character
8

1
8
2
RECTYPE
Code distinguishing record types. Values used
include:
A: citation and trade secret status:
B: lab id and project No.;
C: submitter;
D: chemical;
E: subject;
G: related MRID.
Character
1

9
9
3
RECSEQ
Number distinguishing multiple occurrences of
single record type. Some fields have all zeroes
for the Record Sequence Number.
Numeric
3

10
12
4
LABPROJNR
Code by which the laboratory in LAB ID
identified their work and raw data records.
May occur multiple times for a single MRID.
Character
20

13
32
3.4 PDMS B2 20180604.TXT
Description: This table provides information on the laboratory number.
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
MIRD
An 8-digit code assigned by EPA to uniquely
identify a document. MRIDs assigned prior to
1987 begin with zero; after 1987, MRIDs begin
with the number 4 except for re-registration
documents which begin with number 9.
Character
8

1
8
2
RECTYPE
Code distinguishing record types. Values used
include:
A: citation and trade secret status:
B: lab id and project No.;
C: submitter;
Character
1

9
9
Office of Pesticide Program
22
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary


D: chemical;
E: subject;
G: related MRID.





3
RECSEQ
Number distinguishing multiple occurrences of
single record type. Some fields have all zeroes
for the Record Sequence Number.
Numeric
3

10
12
4
LABID
EPA Company Number identifying a
laboratory in which the work reported in the
document was performed. EPA does not
include laboratories in the EPA Name &
Address file that is available publicly.
Laboratories begin with the number 9.
Character
6

13
18
3.5 PDMS C YYYYMMDD.TXT
Description: This table provides information on the submitter.
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
MIRD
An 8-digit code assigned by EPA to uniquely
identify a document. MRIDs assigned prior to
1987 begin with zero; after 1987, MRIDs
begin with the number 4 except for re-
registration documents which begin with
number 9.
Character
8

1
8
2
RECTYPE
Code distinguishing record types. Values
used include:
A: citation and trade secret status;
B: lab id and project No.;
C: submitter;
D: chemical;
E: subject;
G: related MRID.
Character
1

9
9
3
RECSEQ
Number distinguishing multiple occurrences
of single record type. Some fields have all
zeroes for the Record Sequence Number.
Numeric
3

10
12
4
SBMTR
EPA Company Number identifying a firm or
other source for a submission of the
document.
Numeric
6

13
18
5
SBMSNDATE
The date associated with a submission of the
document. EPA uses 999999 for unknown
dates.
Numeric
6

19
24
6
ADMINNRTYPE
A code indicating the type of administrative
case in support of which the document was
submitted. Used to determine the edit mask
for displaying the Administrative Number.
Types include EPA Registration Numbers
(section3), Experimental Use Permits, Special
Local Needs, and Tolerance Petitions.
Character
1

25
25
7
ADMINNR
The identifier of the administrative case in
support of which the document was submitted.
Not all studies where submitted in support of
administrative cases.
Character
11

26
36
8
ACCSN
The six-digit identifier assigned to the
physical volume in which the document was
submitted. For MRID beginning with 4 or
Numeric
6

37
42
Office of Pesticide Program
23
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary


greater, the accession number is the first 6
digits of the MRID. No longer sent for new
studies as the Accession Number is the first 6
numbers of the MRID after 1987.





9
SFX
Code indicating the location of the document
within the physical volume in which it was
submitted. No longer sent for new studies.
Character
2

43
44
3.6 PDMS D YYYYMMDD.TXT
Description. This table provides information on the chemical subject(s) of the document.
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
MIRD
An 8-digit code assigned by EPA to uniquely
identify a document. MRIDs assigned prior to
1987 begin with zero; after 1987, MRIDs begin
with the number 4 except for re-registration
documents which begin with number 9.
Character
8

1
8
2
RECTYPE
Code distinguishing record types. Values used
include:
A: citation and trade secret status;
B: lab id and project No.;
C: submitter;
D: chemical;
E: subject;
G: related MRID.
Character
1

9
9
3
RECSEQ
Number distinguishing multiple occurrences of
single record type. Some fields have all zeroes
for the Record Sequence Number.
Numeric
3

10
12
4
SUBSCLASS
Code indicating the role of chemicals indexed
as subjects of the document, whether they are
single substances, mixtures, etc. After OPPIN,
all values are "S" for single substance.
Character
1

13
13
5
FORM
EPA Formulation Code describing the physical
form of the substance described in the
document.
Character
2

14
15
6
CHEM
Code(s) indicating the chemical subject(s) of
the document, taken from EPA Chemical
Dictionary. PC Code list is available at EPA's
PPIS download webpage.
Numeric
6

16
21
7
REGNR
EPA Registration Number of a pesticide
product which is the subject of a document.
Occurs when the subject of the document is the
product itself, a contaminant of an identified
product, or an inert ingredient explicitly linked
to a product.
Character
11

22
32
3.7 PDMS E YYYYMMDD.TXT
Description . This table provides information on the subject(s) of the document.
No. Column Name
Column Description
Data Type Length Dec Start End
Office of Pesticide Program
24
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary
1
MIRD
An 8-digit code assigned by EPA to uniquely
identify a document. MRIDs assigned prior to
1987 begin with zero; after 1987, MRIDs begin
with the number 4 except for re-registration
documents which begin with number 9.
Character
8

1
8
2
RECTYPE
Code distinguishing record types. Values used
include:
A: citation and trade secret status;
B: lab id and project No.;
C: submitter;
D: chemical;
E: subject;
G: related MRID.
Character
1

9
9
3
RECSEQ
Number distinguishing multiple occurrences of
single record type. Some fields have all zeroes
for the Record Sequence Number.
Numeric
3

10
12
4
CONTCAT
Code indicating the general nature of the
document. Distinguishes experimental from
survey or review reports; methods news
reports, commentaries, etc.
Character
2

13
14
5
DTCODE
Value from EPA's Discipline/Topic Code
Vocabulary used to describe the subject matter
of the document.
Character
14

15
28
6
ROOTDT
The stem or root of the full DT code, derived
from the full code but with qualifying terms
from related vocabularies extracted.
Character
12

29
40
7
TESTORGN
Code from PDMS vocabulary of test organisms
indicating, for toxicological and related test
reports, the class of organism used for the
testing. Embedded with the full DT code.
Character
2

41
42
8
COMMOD
Code from the PDMS vocabulary of food and
feed commodities indicating, for residue
chemistry reports, the commodity in which
residues were found. Embedded within the full
DT code.
Character
4

43
46
9
DTSITE
An entry from the EPA site Vocabulary
qualifying certain ranges of the Root DT Code.
Embedded within the full DT Code.
Character
5

47
51
10
DTPEST
An entry from the EPA Pest Vocabulary
qualifying certain ranges of the Root DT Code.
Embedded within the full DT Code.
Character
5

52
56
11
DTST
A standard FIPS state code qualifying certain
ranges of the full DT Code.
Character
2

57
58
12
DTYR
A date in the form YY qualifying certain
ranges of the Root DT. Embedded within the
full DT Code.
Character
2

59
60
13
GDLN
Coded reference to the entry in the Guidelines
for Registering Pesticides, describing specific
requirements for data to support pesticide
registration. Derived from the DT Code
Character
8

61
68
3.8 PDMS G YYYYMMDD.TXT
Description. This table provides information on related documents.
Office of Pesticide Program
25
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
MIRD
An 8-digit code assigned by EPA to uniquely
identify a document. MRIDs assigned prior to
1987 begin with zero; after 1987, MRIDs begin
with the number 4 except for re-registration
documents which begin with number 9.
Character
8

1
8
2
RECTYPE
Code distinguishing record types. Values used
include:
A: citation and trade secret status;
B: lab id and project No.;
C: submitter;
D: chemical;
E: subject;
G: related MRID.
Character
1

9
9
3
RECSEQ
Number distinguishing multiple occurrences of
single record type. Some fields have all zeroes
for the Record Sequence Number.
Numeric
3

10
12
4
RELCODE
Code indicating nature of relationship between
MRIDs.
Character
2

13
14
5
REL MRID
Identifies MRIDs related to each other.
Character
8

15
22
Office of Pesticide Program
26
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary
4 RF PROCESS
4.1 RFCLUF.TXT
Description: This table provides information on the PC code and related risk management PM numbers.
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
CASWELL NR

7
13
3
PMCODE
The PM team number that is associated with
the product
Character
2

14
15
4
RM CODE
*** this field is blank
Character
8

16
23
5
CM CODE
*** this field is blank
Character
4

24
27
6
UPDATE DATE
*** this field is blank
Date
8

28
35
4.2 RFCNDLUF.TXT
Description: This table provides the company information for company address types that are not
"Company Address" or "Alternate Laboratory Address".
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
RECTYPE
EPA assigned company record type based on
the company address types.
Official Mailing = 'A'
Agent = 'B'
Other = ''
Character
1

1
1
2
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
6

2
7
7
D B NUMBER
*** this field is blank
Character
9

8
16
4
CONAME
First line of registrant, agent, or distributor
name.
Character
60

17
76
5
COLINE2
Second line of registrant, agent, or distributor
name
Character
60

77
136
6
CO STREET
Street address of registrant, agent or distributor
Character
60

137
196
7
COCITY
City address of pesticide registrant, agent or
distributor.
Character
50

197
246
8
CO STATE
State code of registrant, agent or distributor.
Character
2

247
248
9
FRN CTRY
A 3-character country code
Character
3

249
251
10
CO_ZIP
5-digit zip code of registrant, agent or
distributor.
Character
9

252
260
11
COPOBOX
PO box number of registrant, agent or
distributor.
Character
15

261
275
12
CO CONTACT
Company contact person. (The Agency makes
Character
40

276
315
Office of Pesticide Program
27
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary

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.)

13
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
14

316
329
14
AGENTFLG
Check if the address is an agent. If true then 1,
else 0.
Numeric
1

330
330
15
CONSRT FLG
If 'Y' then 1, else 0.
Numeric
1

331
331
16
CO TYPE1
If 'Y' then 1, else 0.
Numeric
1

332
332
17
COACT FLG1
If 'Y' then 1, else 0.
Numeric
1

333
333
18
CO TYPE2
If 'Y' then 1, else 0.
Numeric
1

334
334
19
COACT FLG2
If 'Y' then 1, else 0.
Numeric
1

335
335
20
CO TYPE3
If 'Y' then 1, else 0.
Numeric
1

336
336
21
COACT FLG3
If 'Y' then 1, else 0.
Numeric
1

337
337
22
UNDELIFLG
If the address is undeliverable, then it is
marked as 1, else 0.
Numeric
1

338
338
23
HI PRODNO
If 'Y' then 1, else 0.
Numeric
1

339
339
4.3 RFMPRF.TXT
Description. This table provides the active ingredient and associated information.
Note:
• This file contains only those registrants with a registered FIFRA section 3, section 24(c) pesticide
product.
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
BARCODE

2
CASETYPE
Registration type for Section 3 and 24C:
'R' = Section 3
'L' = 24C

3
IDNR
EPA assigned number for each registrant or
distributor.
Character
12

4
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.

5
PROD NAME
Product name of the registration

6
PMCODE
The PM team number that is associated with the
product

7
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'.)

8
TOXICCAT
Toxic Category:
If signal word is 'Danger' then TOXIC CAT =
1;

Office of Pesticide Program
28
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary


If signal word is 'Warning' then TOXIC CAT
= 2;
If signal word is "Cancer" then TOXIC CAT =
3





9
STATUS
Status of the registration:
If "Active" then 'A';
If Cancelled" then "C";
If "Withdrawn" then "W"

1



10
SUSPFLG
If the status of the registration is "Suspended",
then the flag is set to 1, else 0.





11
TRANSFLG
If the registration is a transfer, then SUSP FLG
= 1





12
REGIST DT
The date that the chemical is registered
character
8



13
CANCELDT
If current status of the registration is
"Canceled", the CANCEL DT is the current
status date.
Character
8



14
CAN CODE

Character
2



15
STOCKS DT
Existing stock's CHANNEL OF TRADE DT.
Character
8



16
TR FOOD CR






17
TR FEED CR






18
TR NFC CPR






19
AO FOOD CR






20
AO NF OUTD






21
AO NF INDS






22
AO NF RESI






23
GR FOOD CR






24
GR NF CROP






25
FOREST USE






26
RES OUTDR






27
INDOOR FOO






28
INDOOR NF






29
INDOOR MED






30
INDOOR RES






31
NONPEST FL






32
DISINF FLG






33
FUNGAL FLG






34
INVERT FLG






35
NEMATOD FL






36
PLANT FLG






37
VERT FLG






38
CANMO CODE






39
RSUFLG
If current status of the registration is "RUP" then
the flag is set to 1, else 0.





40
LABEL DATE






41
COND U FLG






42
REREG FLG






43
CH R P FLG






44
SP REV FLG






45
ORGAPRV DT
In 'YYYYMMDD' format
Character
8



4.3 RFMPRY2K.TXT
Office of Pesticide Program
29
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
BARCODE






2
CASETYPE
Registration type for Section 3 and 24C:
'R' = Section 3
'L' = 24C
1




3
IDNR
EPA assigned number for each registrant or
distributor.
12




4
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.
6




5
PROD NAME
Product name of the registration
70




6
PMCODE
The PM team number that is associated with
the product
2




7
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'.)
2




8
TOXICCAT
Toxic Category:
If signal word is 'Danger' then TOXIC CAT
= 1;
If signal word is 'Warning' then TOXIC CAT
= 2;
If signal word is "Cancer" then TOXIC CAT
= 3
1




9
STATUS
Status of the registration:
If "Active" then 'A';
If Cancelled" then "C";
If "Withdrawn" then "W"
1




10
SUSPFLG
If current status of the registration is
"Suspended", then the flag is set to 1, else 0.





11
TRANSFLG
If the registration is a transfer, then SUSP FLG
= 1





12
REGIST DT
The active registration's earliest registered date





13
CANCELDT
If current status of the registration is
"Canceled", the CANCEL DT is the current
status date.





14
CAN CODE






15
STOCKS DT
Existing stock's CHANNEL OF TRADE DT.





16
TR FOOD CR






17
TR FEED CR






18
TR NFC CPR






19
AO FOOD CR






20
AO NF OUTD






21
AO NF INDS






22
AO NF RESI






23
GR FOOD CR






24
GR NF CROP






25
FOREST USE






26
RES OUTDR






27
INDOOR FOO






28
INDOOR NF






29
INDOOR MED






Office of Pesticide Program
30
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary
30
INDOOR RES

31
DISINF FLG

32
FUNGAL FLG

33
INVERT FLG

34
NEMATOD FL

35
PLANT FLG

36
VERT FLG

37
CANMO CODE

38
RSUFLG
If current status of the registration is "RUP"
then the flag is set to 1, else 0.

39
LABEL DATE

40
COND U FLG

41
NONPEST FL

43
REREGFLG
If current status of the registration is
"Reregistered", then this flag is set to 1, else 0.

44
CH R P FLG

45
SPREVFLG
If current status of the registration is one of the
following (No Longer Active, Special Review
or Retired), then is flag is set to 1, else 0.

4.4 RFPNF.TXT
Description . This table provides information on the product types and associated status.
Note:
• This file contains only those registrants with a registered FIFRA section 3, section 24(c) pesticide
product or Distributor product.
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
CASETYPE
Registration type for Section 3 and 24C:
'R' = Section 3
'L' = 24C
'D' = distributor
Character
1

1
1
2
IDNR
EPA assigned number for each registrant or
distributor.
Character
12

2
13
3
DISTNR
Distributor number of the product. If the
CASE TYPE IS 'R' OR 'L', then DIST NR is
NULL.
Character
6

14
19
4
ACCESSNR
The identifier assigned to the physical volume
in which the document was submitted.
Character
7

20
26
5
PNAMETYPE
It is a mapping between the registration types
and the product name status.
If 'D' then PNAME TYPE = 1;
If registration type is Section 3 or 24C and the
product name status is "Alternate" or
"Inactive" then PNAME TYPE = 2;
If registration type is Section 3 or 24C and the
product name status is "Active" then
PNAME TYPE = 1.
Character
1

27
28
6
NMSTARTDT
Current registration status date in
'YYYYMMDD' format.
Numeric
8

29
36
Office of Pesticide Program
31
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary
7
STATUS
Current status of the registration
Character
1

37
37
8
PROD NAME
Product name of the registration
Character
70

38
107
4.5 RFSCCNF.TXT
Description . This table provides information on the chemical PC CODE and associated chemical types.
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'.)
Character
6

1
6
2
CHEMNTYPE
Chemical types are assigned based on the
chemical types:
If chemical name is used for display, then
CHEM NTYPE = " ;
If chemical type is 'ANSI', then
CHEMNTYPE = C'
If chemical type is 'Trade' then
CHEMNTYPE = 'T';
All other types then CHEM NTYPE = 'S'.
Character
1

7
7
3
SEQNUMBER
SEQ NUMBERS are assigned based on the
chemical types:
If chemical name is used for display or
chemical type is 'ANSI', then SEQ NUMBER
is 1;
If chemical type is 'Trade' or others, then SEQ
NUMBER can be 1 or greater than 1.
Character
3

8
10

4
CHEM PREFX
*** This field is blank
Character
15

11
25
5
CHEM_NAME
Chemical name associated with the PC Code.
If no chemical name list, Cas No. will be used.
Character
253

26
278
6
QUAL NOTES
*** This field is blank
Character
160

279
438
7
UPDATEDATE
*** This field is blank (format is
"YYYYMMDD').
Character
8

439
446
4.6 RFSPFR.TXT
Description . This table provides company information and associated active ingredient information.
Note:
• This file contains only those registrants with a registered FIFRA section 3, section 24(c) pesticide
product.
• The file contains only the active and Inactive products.
No.
Column Name
Column Description
Data Type
Length
Dec
Start
End
1
CASETYPE
Registration type for Section 3 and 24C:
'R' = Section 3
'L' = 24C
Character
1

1
1
2
ID NR
EPA assigned number for each registrant or
Character
12

2
13
Office of Pesticide Program
32
May 17, 2018

-------
Environmental Protection Agency
PPIS Data Dictionary


distributor.





3
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.
Character
6

14
19
4
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'.)
Character
6

20
25
5
PCPCT
The 'PC CODE' percentage appearing in the
pesticide product formulation.
Character
6

26
31
6
GDE VALID
If it's true then 1, else 0.
Character
1

32
32
7
RESTR USE
If it is a "RUP" then 1, else 0.
Character
1

33
33
Office of Pesticide Program
33
May 17, 2018

-------