----------------------------------------------------------------------- (Print this document with a monospaced font for most effective use.) U.S. Food and Drug Administration Pestrak Data Update Date: [date] CHANGES TO DATA SINCE PREVIOUS (November 2001) VERSION: none CHANGES TO STRUCTURE SINCE PREVIOUS VERSION: none ----------------------------------------------------------------------- The four computer files in this set (Chems.txt, OthNames.txt, Recvrs.txt, and GCDat.txt) each contain selected information from Pestrak, FDA's data base of information about pesticides used on foods and the capabilities of FDA's methods to determine residues of these pesticides. Each file is a text file, specially formatted for import by database or spreadsheet software. Each can be opened with word processing software, but is not meant to be read that way; each file contains a tab between fields and a carriage return plus line feed between records. For example, a typical line from the Chems.txt file is: 22936863[tab]cyprazine[tab]670[tab]CR-1615[tab]180.306[tab][tab] [tab][tab]C9H14ClN5[tab]herbicide[tab]parent[tab][tab] Instead of trying to read these, use software designed to create a database. Use one of the common database or spreadsheet programs, and "open" or "import" each of these files, one at a time, to create four databases. (Relational database software can be used to create a single database; each record contains a CAS number field that can be used to link files.) The Chems.txt file contains one record per chemical; the other three files, OthNames.txt, Recvrs.txt, and GCDat.txt, may contain multiple records per chemical. Not all records in Chems.txt have corresponding records in the other files, but each record in OthNames.txt, Recvrs.txt, and GCDat.txt has a corresponding record in Chems.txt. The following lists the data fields in the order they appear in each of the four files. Explanations for codes used in specific fields are supplied where needed. Note that absence of data results in a blank field or a field containing a zero (0). Trailing blanks or 0s are not included. ----------------------------------------------------------------------- File: Chems.txt (1604): (Records of individual pesticides or related chemicals; contains one record per chemical. Maximum lengths refer to data records; some entries in the first record, which contains names of fields, are longer.) Field Name Max Length Explanation CAS Number 9 Chemical Abstracts Service number Name 80 Preferred name used by FDA LMS Code 3 Code used by FDA to report residues Std. No. 7 Reference standard from EPA Repository or ULTRA Scientific CRADA Catalog 40 CFR 180 25 Section(s) of Code of Federal Regulations (CFR) that lists tolerances on foods; or "revoked" or "none" as appropriate 40 CFR 185 28 Section(s) of CFR that lists food additive tolerances 40 CFR 186 17 Section(s) of CFR that lists tolerances in animal feeds [CAVEAT: FDA maintains this data base to provide information useful to successful application of the agency's pesticide multiresidue methodology and to track aspects of its analytical methods research. Information related to regulations (CFR references to tolerances published by the Environmental Protection Agency) is taken from secondary sources, and the user is cautioned not to use this data base as authoritative for purposes of determining compliance with existing regulations.] Other Status 20 Indication of pending or temporary tolerances or known/suspected foreign use Molecular Formula 18 Use 32 Insecticide, herbicide, etc. Blank for metabolites and other related chemicals Category 17 Parent, metabolite, etc. Special Review 1 Status in EPA Special Review program Explanation of codes used in Special Review field: P undergoing pre-Special Review exam. R Special Review initiated (PD 1 issued). D preliminary determination issued. C completed process; most (or primary) uses retained; also chemicals returned to registration process. L completed process; most or all uses cancelled; also chemicals voluntarily cancelled by manufacturer. H completed Special Review; suspension or intent to cancel published. A undergoing reassessment following original decision. CCPR Number 3 Codex Committee on Pesticide Residues number for chemical ----------------------------------------------------------------------- File: OthNames.txt (7913) (Records for alternate names for the chemicals in Chems. Maximum lengths refer to data records; some entries in the first record, which contains names of fields, are longer.) Field Name Max Length Explanation CAS Number 9 Chemical Abstracts Service number Pref Name 80 FDA preferred name; same as Chems.txt Name Oth Name 160 Alternate name Type 5 Type of name Explanation of codes used in Type field: 9CI Chemical Abstracts Service 9th Collective Index name ANSI common name of American National Standards Institute Committee K61 ISO common name of International Standards Organization Trade trade name; list is not all-inclusive Other other common name, chemical name, manufacturer codes, etc. ----------------------------------------------------------------------- File: Recvrs.txt (2492) (Data on recoveries of chemicals through FDA pesticide multiresidue methods. Maximum lengths refer to data records; some entries in the first record, which contains names of fields, are longer.) Field Name Max Length Explanation CAS Number 9 Chemical Abstracts Service number Pref Name 80 FDA preferred name; same as Chems.txt Name Method 17 Pesticide Analytical Manual Vol. I 3rd ed. (PAM I) section or other reference that describes the multiresidue method. Recovery 12 Summary of test results through method Explanation of codes used in Recovery file: C complete (>80%) recovery P partial (50-80%) recovery S small (<50%) recovery V variable recovery (but at least 40%) R recovered, but no quantitative data available NR not recovered Mixed Ethers 7 Eluate(s) in which chemical elutes from Florisil using PAMÊI 303 C1 or 304 C1/C3 Explanation of codes used in Mixed Ethers field: 6 eluted in 6% ethyl ether/petroleum ether (EE/PE) 6+15 split between 6 and 15% EE/PE 6+15+50 split among all three eluates 15 15% EE/PE 15+50 split between 15 and 50% EE/PE 50 50% EE/PE [NOTE: when chemical is not recovered through method, this field indicates which eluates were tested.] MeCl2 5 Eluate(s) in which chemical elutes from Florisil using PAMÊI 303 C2 or 304 C2/C4 Explanation of codes: same style as in Mixed Ethers field, with references to eluates 1, 2, and 3. Notes 80 As needed to provide additional information about recovery tests ----------------------------------------------------------------------- File: GCDat.txt (3449): (GLC relative retention times and responses, on systems used by FDA. Maximum lengths refer to data records; some entries in the first record, which contains names of fields, are longer.) Field Name Max Length Explanation CAS Number 9 Chemical Abstracts Service number Pref Name 80 FDA preferred name; same as Chems.txt Name GC Column 6 Column, at operating conditions described in PAM I Section 302 DG modules; see Appendix I (PESTDATA) Detector 6 Detector used, at operating conditions described in PAM I, Section 302 DG modules; see Appendix I (PESTDATA) Explanation of codes used in Detector field: FP flame photometric detector, phosphorus mode FP(WB) FP, with a wide bore capillary column FS flame photometric detector, sulfur mode HN electroconductivity detector, nitrogen mode HN(WB) HN, with a wide bore capillary column HX electroconductivity detector, halogen mode HX(WB) HX, with a wide bore capillary column NI 63Ni electron capture detector NI(WB) NI, with a wide bore capillary column NP N/P detector NP(WB) N/P, with a wide bore capillary column TI thermionic detector TR 3H (tritium) electron capture detector Rrt 4 Retention time relative to chlorpyrifos Ng 5 Amount (ng) of chemical required to cause detector response of 50% Full Scale Deflection For further information, contact Carolyn Makovi, CMakovi@fda.hhs.gov, or Mark Wirtz, MWirtz@fda.hhs.gov, FDA Division of Pesticides and Industrial Chemicals, 5100 Paint Branch Parkway, College Park, MD 20740.