A Technical Overview of Staged Electronic Data Deliverable SEDD

1
A Technical Overview of Staged Electronic Data
Deliverable (SEDD)

• PITTCON 2006
• Joseph F. Solsky
• US Army Corps of Engineers (USACE)
• March 14, 2006

2
The Problem with Todays EDDs

• Laboratories produce more than 300 different
  Electronic Data Deliverables (EDDs).
• Most EDDs to date are customer-specific.
• Most EDDs are proprietary.
• No stand-alone, self-defining EDD present - a
  must in case of another national emergency.
• No EDD present that meets diverse customer needs
  for detailed analytical chemistry reporting.

3
The Solution - SEDD

• SEDD - Staged Electronic Data Deliverable
• Staged Approach Allows for Meeting Diverse
  Reporting Requirements
• Eases Data Exchange between Various Parties
• Analytical Data Delivered in eXtensible Markup
  Language (XML) Format (Non-Proprietary)
• XML Is Designed for the Creation of Complex
  Documents and for Input into Various Databases

4
XML A Self-Defining Data Format

• XML - eXtensible Mark-up Language
• Final Recommended Standard by the World Wide Web
  Consortium
• Each Piece of Data in XML Has a Tag (or Is
  Tagged) so the Data Set (EDD) is Self-Defined
• Under SEDD, the EDD from the Laboratory Is
  Transmitted as an XML Document Based on a DTD or
  Schema

5
Example XML File

• ltReportedResultgt
• ltAnalyteNamegtBenzenelt/AnalyteNamegt
• ltCASRegistryNumbergt71-43- 2lt/CASRegistryNumbergt
• ltResultgt24.2lt/Resultgt
• ltResultUnitsgtug/Llt/ResultUnitsgt
• lt/ReportedResultgt

6
What Is SEDD?

• Uses a common syntax to describe diverse
  laboratory activities and report analytical data
  electronically.
• Allows users to link analytical data to
  underlying laboratory activities and processes to
  provide full traceability.
• Provides a means for reporting complex analytical
  relationships.

7
The Stages of SEDD

• Stage 1 - Contains the minimum number of
  analytical data elements required to transmit
  results-only data.
• Stage 2 - Data content builds on Stage 1 by
  adding method (Stage 2a) and instrument (Stage
  2b) Quality Control (QC) data.
• Stage 3 - Data content builds on Stage 2 by
  adding additional measurement data to allow for
  independent recalculation of the reported results
  e.g., Contract Laboratory Program (CLP).

8
Stage 3 SEDD Files

• A SEDD Stage 3 file contains enough data to allow
  for the independent recalculation of the reported
  results.
• Raw instrument data would generally not be used.
  Corrected instrument data, such as peak areas or
  corrected intensity readings, would normally be
  captured.
• This file contains all of the linkages to relate
  all calibration data and other data to each
  reported result.
• This file contains information to associate all
  standards used to their original vendors and lot
  numbers.

9
The Future SEDD Stage 4

• A Stage 4 file uses the same structure as Stage 3
  but includes all instrument raw data files that
  were generated during the analysis of the sample.
  Other supporting files could also be included.
• These instrument raw data files are stored in a
  non-proprietary XML format.
• Significant advantages can be realized when data
  is delivered at this level.

10
Example XML File (As Viewed in XML Notepad)
11
What Are Document Type Definitions (DTDs)?

• Would specify what parts of the SEDD structure
  (nodes) are required.
• Would specify what data elements are required for
  each node.
• Three stages have now been defined. Data can be
  delivered based on the amount and complexity of
  the data required by the user. Generic DTDs are
  developed for Stage 2a, 2b and 3.
• Schemas can also be used in place of DTDs.

12
The Valid Value Issue

• SEDD now includes a set of valid values.
• Whenever possible, all valid values were tied to
  an existing standard or recognized database of
  values. When valid values are reported, they are
  reported with the appropriate source identified.
• All critical data, such as analyte and method
  IDs, can be identified using laboratory, client,
  and referenced values.

13
SEDD Stage 1 Structure
14
SEDD Stage 2a Structure
15
SEDD Stage 2b Structure
16
SEDD Stage 3 Structure
17
Contact Information

• Contact information for SEDD
• Anand Mudambi
• Phone [phone]
• Email mudambi.anand_at_epa.gov
• Contact information for SEDD
• Joseph Solsky
• Phone [phone]
• Email Joseph.F.Solsky_at_usace.army.mil
• CLP SEDD Web Page
• www.epa.gov/superfund/programs/clp/sedd.htm