United States Environmental Protection Agency
Office of Pesticide Programs
PESTICIDE PRODUCT INFORMATION SYSTEM
DATA STANDARD
22 April 2015
Office of Pesticide Programs
Attention: The PPIS XML is currently under consideration.
-------
Pesticide Product Information System
Data Standard
Contents
1 INTRODUCTION 4
1.1 Filename format 4
1.2 Management of PPIS 4
1.3 Contacts 4
2 PPIS SCHEMA DEFINITION 4
2.1 Overview 4
2.2 Filename Format 5
2.3 Boilerplate for element description 5
2.3.1 Child Elements 5
2.4 Elements 6
2.4.1 EPAPRODUCTIONINFORMATION 6
2.4.1.1 Child Elements 6
2.4.2 Product 6
2.4.2.1 Child Elements 6
2.4.3 ALTBRANDNAMELIST 7
2.4.3.1 Child Element 7
2.4.4 Company 7
2.4.4.1 Child Elements 8
2.4.5 Agent 8
2.4.5.1 Child Elements 9
2.4.6 DistributorList 9
2.4.6.1 Child Elements 10
2.4.7 FormulationList 10
2.4.7.1 Child Elements 10
2.4.8 PestList 10
2.4.8.1 Child Elements 11
2.4.9 SiteList 11
2.4.9.1 Child Elements 11
2.4.10 ProductManagerList 11
2.4.10.1 Chile Elements 12
2.4.11 TransferList 12
2.4.11.1 Child Elements 12
2 | P a g e
-------
Pesticide Product Information System
Data Standard
2.4.12 TypesList 13
2.4.12.1 Child Elements 13
3 APPENDIX 13
3.1 Glossary of Terms 13
3.2 Version History 14
3 | P a g e
-------
Pesticide Product Information System
Data Standard
1 INTRODUCTION
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, signal word, product names, distributor brand names, site/pest uses, pesticidal type,
formulation code, and registration status.
These Extensible Markup Language (XML) 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.
1.1 Filename format
The PPIS format specification (this document) is versioned using a version numbering schema of
type XX-XX-XXXX. It is composed of a date format, MM-DD-YYYY. The file name convention of the
PPIS format specification is therefore
PPIS-Data-Standard-XX-XX-XXXX.
for example
PPIS-Data-Standard-01-02-2015.pdf
1.2 Management of PPIS
All of PPIS files and documents are available on the OPP website at:
http://www2.epa.gov/ingredients-used-pesticide-products/pesticide-product-information-
system-ppis
1.3 Contacts
Any entity needing assistance regarding the PPIS should contact the OPP at
OPPChemicalSerach(a)epa.gov. The OPP will then direct questions to responsible for the
maintenance or data quality of the PPIS.
2 PPIS SCHEMA DEFINITION
2.1 Overview
This chapter provides a technical reference for the PPIS XML schema definition, as defined in the
PPIS XSD schema file.
4 | 3 a g e
-------
Pesticide Product Information System
Data Standard
2.2 Filename Format
The PPIS format specification (this document) is versioned using a version numbering schema of
type XX-XX-XXXX. It is composed of a date format, MM-DD-YYYY. The file name convention of the
PPIS format specification is therefore
PPIS-SEC3-XX-XX-XXXX.
PPIS-SEC24C-XX-XX-XXXX.
for example
XML:
Section 3: PPIS-SEC3-01-02-2015.xml
Section 24(c): PPIS-SEC24C-01-02-2015.xml
XSD: PPIS-01-02-2015.xsd
2.3 Boilerplate for element description
This chapter contains the boilerplate for the subsequent documentation of the XSD elements
including an explanation of the description template.
Please note that this specification contains only main aspects of the actual XSD definition.
2.3.1 Child Elements
This chapter defines the child elements of the element in focus in the form of a table:
Element Name
Xpath
Diagram
Child Element
Definition
Description
Child Element Table - boilerplate sample: child elements definition:
• The row Xpath contains the Xpath expression of the element in an instance.
• The cell next to "Diagram" shows a graphics representation of the element and its direct child
elements.
• The rows below "Child Element" contains the child elements of the element in focus. The order of
child elements in the parent element is of no significance.
• The column "Definition" contains the definition of the element.
• The column "Description" contains the description of the element.
5 | P a g e
-------
Pesticide Product Information System
Data Standard
2.4 Elements
2.4.1 EPAPRODUCTION IN FORMATION
The EPAPRODUCTIONINFORMATION element is the root element of the complete XL backbone
file.
2.4.1.1 Child Elements
Element Name
EPAPRODUCTIONINFORMATION
Xpath
EPAPRODUCTIONINFORMATION
Diagram
Child Element
Definition
Description
Product
2.4.2 Product
Contains basic information for each EPA registration number such as the product name, status,
approval date, physical form, and signal word.
2.4.2.1 Child Elements
Child elements definition
"or element PRODUCT.
Element Name
Product
Xpath
EPAPRODUCTION IN FORMATION/PRODUCT
Diagram
lc) PRODUCT
+1 t PRODUCTNAME
+1 C E PARE GISTRATIONNUMBER
+1 C CASNUMBER
+1 C PESTICIDE FORM
+1 C APPRDVEDDATE
C CANCELTRANSFEREATS
+1 C RESTRICTEDUSEPRODUCT
+1 C C ONE IT IONAL L YFL AG
+1 C SIGNAL WORD
Child Element
Definition
Description
PRODUCTNAME
xs:string
The pesticide product name as identified to EPA by the
registrant or distributor.
EPAREGISTRATIONNU
MBER
xs:string
EPA assigned pesticide product registration number.
CASNUMBER
xs:string
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.
6 | P a g e
-------
Pesticide Product Information System
Data Standard
PESTICIDEFORM
xs:byte
The descriptive name associated with a pesticide product
physical form (i.e. granular, dust, liquid).
APPLICATIONDATE
xs:date
The application date associated with a distributor product
registration request. The application date is provided in
the format YYYY-MM-DD.
APPROVEDDATE
xs:date
The pesticide product registration approval date. The
approved date is provided in the format YYYY-MM-DD.
CANCELTRANSFERDATE
xs:date
The cancellation or transfer date of a pesticide product
registration. The date is provided in the format YYYY-MM-
DD.
RESTRICTEDUSEPRODU
CT
xs:string
Identifies if the product is a restricted use product.
CONDITIONALLYFLAG
xs:string
Identifies if the product was conditionally registered
under FIFRA 3(c)(7) or unconditionally registered under
FIFRA 3(c)(5). The field values are 'T' for true
(conditionally registered) and 1F1 for false (unconditionally
registered).
SIGNALWORD
xs:string
A word ("Caution," "Warning," or "Danger") that indicates
the most severe toxicity category assigned to the five
acute toxicity studies, or the presence of methanol in
concentrations of 4 percent or more.
2.4.3 ALTBRANDNAMELIST
List the alternative brand name associated to its product. This list can be null.
2.4.3.1 Child Element
Child elements definition for element ALTBRANDNAMELIST.
Element Name
AltBrandNameList
Xpath
EPAPRODUCTIONINFORMATION/PRODUCT/ALTBRANDNAMELIST
Diagram
Q ALT3HANBNAM2LIST
- ¦¦¦£> ALTBRANDNAME
[±] C ALTS PANENAME
Child Element
Definition
Description
ALTBRANDNAME
xs:string
Alternative brand name of its product.
2.4.4 Company
Contains name and address information for all companies which have been assigned an EPA
company number.
7 | P a g e
-------
Pesticide Product Information System
Data Standard
2.4.4.1 Child Elements
Child elements definition
:or element COMPANY.
Element Name
Company
Xpath
EPAProductionlnformation/Product/Company
Diagram
£3 COMPANY
0 C COMPANYNUMBER
El C COMPANYNAME
+1 C DIVISIONNAME
+1 C MAILINGSTREET
1j C MAILINGCITY
|j C MAILINGSTATE
+1 C MAILINGZIPCODE
+ 1 L CONTACT
S C TELEPHONENUMBER
El L ZLICTRCNICAEERESS
Child Element
Definition
Description
EPACOMPANYNUMBER
xs:byte
EPA assigned number for each registrant or distributor.
COMPANYNAME
xs:string
First line of registrant, agent, or distributor name.
DIVISIONNAME
xs:string
Division name
MAILINGSTREET
xs:string
Street address of registrant, agent, or distributor.
MAILINGCITY
xs:string
City address of pesticide registrant, agent, or
distributor.
MAILINGSTATE
xs:string
State code of registrant, agent, or distributor.
MAILINGZIPCODE
xs:int
Digit zip code of registrant, agent, or distributor.
CONTACT
xs:string
Company contact person.
TELEPHONENUMBER
xs:string
Company phone number.
ELECTRONICADDRESS
xs:string
E-mail address of first line of registrant, agent, or
distributor.
2.4.5 Agent
Contains the registrant's designed agent name and address information.
8 | P a g e
-------
Pesticide Product Information System
Data Standard
2.4.5.1 Child Elements
Child elements definition for element AGENT.
Element Name
Agent
Xpath
EPAProductionlnformation/Product/Agent
Diagram
¦£3 AGENT
El C COMPANYNUMBER
E C COMPANYNAME
El L divisi
o
+ C MAILINGSTREET
E C MAILINGCITY
E C MAILINGSTATE
E C MAILINGZIPCODE
E t CONTACT
E C TELEPHONENUMBER
+ C ELECTRCNICAEDRESS
Child Element
Definition
Description
EPACOMPANYNUMBER
xs:byte
EPA assigned number for each registrant or
distributor.
COMPANYNAME
xs:string
First line of registrant, agent, or distributor name.
DIVISIONNAME
xs:string
Division name
MAILINGSTREET
xs:string
Street address of registrant, agent, or
distributor.
MAILINGCITY
xs:string
City address of pesticide registrant, agent, or
distributor.
MAILINGSTATE
xs:string
State code of registrant, agent, or distributor.
MAILINGZIPCODE
xs:int
5-digit zip code of registrant, agent, or
distributor.
CONTACT
xs:string
Company contact person
TELEPHONENUMBER
xs:string
Company phone number.
ELECTRONICADDRESS
xs:string
E-mail address of first line of registrant, agent,
or distributor.
2.4.6 DistributorList
Contains information about companies who market section 3 registrations under a distributor
brand name. This list can be null.
9 | P a g e
-------
Pesticide Product Information System
Data Standard
2.4.6.1 Child Elements
Child elements definition for element DISTRIBUTORLIST.
Element Name
Distri butorList
Xpath
EPAProductionlnformation/Product/DistributorList
Diagram
O DISTRIBUTCRLIST
- ^ DISTRIBUTOR
[±] C DISTRIBUTORNDMBER
+ C APPLICATIONDATE
l±] C CANCELDATE
1+1 C PRODUCTNAME
Child Element
Definition
Description
DISTRIBUTORN UMBER
xs:string
EPA assigned number for each distributor.
APPLICATIONDATE
xs:date
The application date associated with a distributor
product registration request.
CANCELDATE
xs:date
The cancellation date of a pesticide product
registration.
PRODUCTNAME
xs:string
Product name of each distributor.
2.4.7 FormulationList
Provide formulation percentage of each active ingredient.
2.4.7.1 Child Elements
Child elements definition for element FORMULATIONLIST.
Element Name
FormulationList
Xpath
EPAProduction Information/Product/Formulation List
Diagram
O FORMULATIONLIST
- |£) FORMULATION
+ C EPAPCCODE
+ C PCPERCENTAGE
Child Element
Definition
Description
EPAPCCode
xs:string
EPA assigned pesticide chemical code also commonly
referred to as active ingredient code, Shaughnessy code, and
chemical code.
PCPercentage
xs:string
The percentage appearing in the pesticide product
formulation.
2.4.8 PestList
Contains information about the pests for which a particular pesticide product is registered.
10 | Page
-------
Pesticide Product Information System
Data Standard
2.4.8.1 Child Elements
Child elements definition for element PESTLIST.
Element Name
PestList
Xpath
EPAProductionlnformation/Product/PESTLIST
Diagram
¦ED PESTLIST
- PEST
+ C PESTCCDE
El C PESTDESCRIPTICN
Child Element
Definition
Description
PESTCODE
xs:string
EPA assigned code for each pest associated with a
pesticide product.
PESTDESCRIPTION
xs:string
The pest name description associated with each
'PestCode'.
2.4.9 SiteList
Contains the site code and description for each site for which a pesticide product is registered.
2.4.9.1 Child Elements
Child elements definition for element SITELIST.
Element Name
SiteList
Xpath
EPAProductionlnformation/Product/SiteList
Diagram
¦£) SITELIST
- -£3 SITE
m C SIT3CCE3
El L SITEEESCRIPTICN
Child Element
Definition
Description
SITECODE
xs:ing
EPA assigned code for each site associate with a
pesticide product.
SITEDESCRIPTION
xs:string
The site name description associated with each
'SiteCode'.
2.4.10 ProductManagerList
Contact information of Product Manager who manage the product.
11 | Page
-------
Pesticide Product Information System
Data Standard
2.4.10.1 Chile Elements
Child elements definition for element PRODUCTMANAGERLIST.
Element Name
ProductManagerList
Xpath
EPAProductionlnformation/Product/SiteList/ProductManagerList
Diagram
(r^ PRODUCTMANAGERLIST
0 ED PRODUCTMANAGER
+ C PRODUCTMANAGERCODE
El- C PRODUCTMANAGERNAME
El C PRODUCTMANAGERTELEPHONE
El C P RC DUC TMANAGE RT SAM
+ C P RC DUCTMANAGERE L S CMAIL
Child Element
Definition
Description
PRODUCTMANAGER
xs:byte
The product manager (PM) code.
CODE
PRODUCTMANAGER
xs:string
The product manager (PM) name.
NAME
PRODUCTMANAGER
xs:string
The product manager (PM) telephone number
TELEPHONE
PRODUCTMANAGER
xs:string
The assigned code for each product manager (PM).
TEAM
PRODUCTMANAGER
xs:string
The product manager (PM) email address.
ELECMAIL
2.4.11 TransferList
Contains product transfer information with the previous registration number, transfer reason,
and transfer date.
2.4.11.1 Child Elements
Child elements definition for element TRANSFERLIST.
Element Name
TransferList
Xpath
EPAProductionlnformation/Product/TransferList
Diagram
O TRANSFERLIST
B Q TRANSFER
El C PREVIOUSREGNUMBER
El L> TRANSFERDATE
Child Element
Description
PREVIOUSREGNUMBER
EPA assigned pesticide product registration number
TRANSFERDATE
The effective date of a pesticide product registration transfer
action.
12 | Page
-------
Pesticide Product Information System
Data Standard
2.4.12 TypesList
Contains the type code and description indicating product type as insecticide, rodenticide,
fungicide, etc.
2.4.12.1 Child Elements
Child elements definition for element TYPESLIST.
Element Name
Type
Xpath
EPAProduction Information/Product/Types List
Diagram
TYPESLIST
- £3 TYPES
l±] C TYPECODE
+1 C TYPE DESCRIPTION
Child Element
Description
TYPECODE
The type of pesticide product expressed as a code (i.e. insecticide, fungicide,
rodenticide, etc...).
TYPEDESCRIPTION
The type of pesticide product description associated with each 'TypeCode'.
3 APPENDIX
3.1 Glossary of Terms
The definitions used in this documents are for the purpose of the PPIS only.
Terms
Definitions
EPA
Environmental Protection Agency
OPP
Office of Pesticide Programs
PPIS
Pesticide Product Information System
Registrant
Company, company representative, or
individual who holds the registration for an
active product.
Registration
The process to apply, assess and register a
pesticide.
XML
Extensible Markup Language
XSD
XML Schema Definition
13 | P a g e
-------
Pesticide Product Information System
Data Standard
3.2 Version History
The following Change History log contains a record of changes made to this document. The last column
also contains information whether a new version of this PPIS specification.
Version #
Date
Author
Nature of Change / Affected PPIS components
01.00.00
February 2015
OPP
Initial publication of this document
01.01.00
March 2015
OPP
Updated XML elements and its description
01.02.00
April 2015
OPP
Added 'XSD'
01.03.00
April 2015
OPP
Minor changes in Site Element
14 | Page
------- |