1 / 14

What Type of Data Must Be Electronically Reported?

4th Annual CALIFORNIA CUPA CONFERENCE February 4-8, 2002 Santa Clara, California Electronic Reporting of UST Data Kevin Calcagno Sequoia Analytical. What Type of Data Must Be Electronically Reported?. AB2886 Electronic Data Deliverables. Begins September 1, 2001

nonnie
Download Presentation

What Type of Data Must Be Electronically Reported?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 4th AnnualCALIFORNIA CUPA CONFERENCEFebruary 4-8, 2002Santa Clara, CaliforniaElectronic Reportingof UST DataKevin CalcagnoSequoia Analytical

  2. What Type of Data Must Be Electronically Reported? AB2886 Electronic Data Deliverables Begins September 1, 2001 • Laboratory Soil and Groundwater Sample Results • Begins January 1, 2002 • Sample Locations (latitude/longitude) • Monitoring Well Elevation Data • Groundwater Well Data (DTW, free product & status) • Site Map

  3. AB2886 Electronic Reporting Electronic Reporting of Analytical Laboratory Data a.k.a. COELT or EDF Began September 1, 2001

  4. What Laboratory Data Is Required? • Soil • Groundwater For all UST samples

  5. Laboratory Sample Results-What is EDF? • A way to transfer laboratory and field information electronically • The electronic version of a laboratory report • Includes: • Chain-of custody information • Laboratory results • Quality assurance information • 3 “Flat” files or 6 files

  6. Examples of EDF Contents • Analytical Results • Laboratory Ids • Analysis Date • Preparation batch • Results • Chain-of-Custody Data • Global ID** • Field Point Name** • Sample IDs • Collection Date/Time • Preservation • **Client Provided • QA/QC data • Control Limits • Surrogates • Blanks • Spikes

  7. EDCC Error Checking Program • Format Errors • Fields submitted in incorrect order • Incorrect valid values • Logic Errors, such as… • Analysis date prior to sample date • Test without results • Content Errors • Detection limits greater than reporting limits

  8. Get Ready For Electronic Reporting • Verify that your analytical lab can produce EDF • Review/modify your laboratory contracts • Test your lab’s EDF format by using the desktop EDCC application from SWRCB AB2886 web site • Check GeoTracker “AB2886” link for new documents and information

  9. http://geotracker.swrcb.ca.gov/ Help Desk Support 1-800-506-3887

  10. EDF Development at Sequoia Analytical • Fields of Information and create EDF module (performed by our LIMS Co.) • Train all Project Managers on EDF Generation • Dry-run with select clients • Take a proactive approach with all UST clients

  11. How Laboratories Produce and Reporting EDF Data EDCC Program Client Analytical Data Hand-Entered or Uploaded into LIMS Six Flat EDF Files Hand-Entered or Uploaded into COELT Historical EDF Generation Process Client Analytical Data Uploaded into LIMS EDCC Program Six Flat EDF Files Sequoia EDF Generation Process

  12. Requirements for Successful EDF Generation • Notify your lab of your new EDF requirement • REQUEST EDF ON THE CHAIN-OF-CUSTODY (COC)!! • Provide Global ID and Field Point IDs on COC • Make sure “report to:” company/consultant has provided information to ArsenaultLegg, Inc.

  13. Results of EDF Planning • Successfully completing over 300 EDFs per month • Reduced generation time to 15-20 minutes per project • EDF generation will add 5-10% to analytical costs

  14. Assistance from Sequoia Analytical Paul Weber Sequoia Analytical (707) 792-7504, pweber@sequoialabs.com Kevin Calcagno Sequoia Analytical (916) 921-9600, kcalcagno@sequoialabs.com

More Related