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 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 1 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. 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; 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 42 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 ------- |