Download
a technical overview of staged electronic data deliverable sedd n.
Skip this Video
Loading SlideShow in 5 Seconds..
A Technical Overview of Staged Electronic Data Deliverable (SEDD) PowerPoint Presentation
Download Presentation
A Technical Overview of Staged Electronic Data Deliverable (SEDD)

A Technical Overview of Staged Electronic Data Deliverable (SEDD)

425 Vues Download Presentation
Télécharger la présentation

A Technical Overview of Staged Electronic Data Deliverable (SEDD)

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  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 Today’s 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. A Technical Overview of SEDD/ Joseph F. Solsky

  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 A Technical Overview of SEDD/ Joseph F. Solsky

  4. XML eXtensible Mark-up Language Standard devised by the World Wide Web Consortium. 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 A Technical Overview of SEDD/ Joseph F. Solsky

  5. Example XML File <ReportedResult> <AnalyteName>Benzene</AnalyteName> <CASRegistryNumber>71-43- 2</CASRegistryNumber> <Result>24.2</Result> <ResultUnits>ug/L</ResultUnits> </ReportedResult> A Technical Overview of SEDD/ Joseph F. Solsky

  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. A Technical Overview of SEDD/ Joseph F. Solsky

  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)]. A Technical Overview of SEDD/ Joseph F. Solsky

  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. A Technical Overview of SEDD/ Joseph F. Solsky

  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. A Technical Overview of SEDD/ Joseph F. Solsky

  10. Example XML File (As Viewed in XML Notepad) A Technical Overview of SEDD/ Joseph F. Solsky

  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. A Technical Overview of SEDD/ Joseph F. Solsky

  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. A Technical Overview of SEDD/ Joseph F. Solsky

  13. SEDD Stage 1 Structure A Technical Overview of SEDD/ Joseph F. Solsky

  14. SEDD Stage 2a Structure A Technical Overview of SEDD/ Joseph F. Solsky

  15. SEDD Stage 2b Structure A Technical Overview of SEDD/ Joseph F. Solsky

  16. SEDD Stage 3 Structure A Technical Overview of SEDD/ Joseph F. Solsky

  17. Contact Information Contact information for SEDD: Anand Mudambi Phone: 703-603-8796 Email: mudambi.anand@epa.gov Contact information for SEDD: Joseph Solsky Phone: 402-697-2573 Email: Joseph.F.Solsky@usace.army.mil CLP SEDD Web Page: www.epa.gov/superfund/programs/clp/sedd.htm A Technical Overview of SEDD/ Joseph F. Solsky