4th Annual CALIFORNIA CUPA CONFERENCE February 4-8, 2002 Santa Clara, California Electronic Reporting of UST Data Kevin Calcagno Sequoia Analytical

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 labs 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 [phone],
pweber_at_sequoialabs.com Kevin Calcagno Sequoia
Analytical [phone], kcalcagno_at_sequoialabs.c
om