SEDD Report and Data Interface

The Staged Electronic Data Deliverable (SEDD) report is available on the EarthSoft Community Center (ECC). After the report has been placed in the Professional installation, it can be opened via the SEDD button in the Plus licensing section of the Data ribbon in EQuIS Professional.

If the SEDD report file (EarthSoft.Reports.Library.d40828.dll) is not in the Professional installation but has been published to the database, it may be opened via the Reports interface.

The SEDD is a uniform format for electronic delivery of analytical data for environmental programs developed by the United State Environmental Protection Agency, Superfund Contract Laboratory Program. Learn more about the SEDD format here.

EQuIS does not support a traditional SEDD import format, but there is a recommended workflow that leverages standard EQuIS formats to import SEDD data and an EQuIS SEDD report that subsequently exports a deliverable adhering to the SEDD specifications.

EQuIS SEDD Report

Report Name: EQuIS SEDD Report

File Name: EarthSoft.Reports.Library.d40828.dll

Dependencies: Not Applicable

Source: Available on the Downloads Dashboard on the ECC under All Items > Formats > SEDD_ReportingPackage.zip

Language: English

Output Type: XML

Description: The EQuIS SEDD Report can be used to export data from an EQuIS database into an XML file that complies with the organizational structure required of a Staged Electronic Data Deliverable (SEDD). Learn more about SEDD requirements here.

Installation Instructions: Download the SEDD_ReportingPackage.zip file from the ECC, unblock the *.zip file and extract the contents. Copy the EarthSoft.Reports.Library.d40828.dll file to the EQuIS Professional installation folder. For default installations, this directory is C:\Program Files\EarthSoft\EQuIS or (for per-user installation) %localappdata%\Programs\EarthSoft\EQuIS\. The report will be available for selection once Professional has been relaunched. Alternatively, the report can be published to the database to be made available to all users regardless of its presence or absence in their Professional installations.

Overview: The SEDD 5.2 format delineates several stages that dictate the breadth of data that an EDD may contain. The EQuIS SEDD Report creates a SEDD file in which the following sections from Stage 1 and Stage 2a are populated:

•Header

•Contact Information

•Sample Plus Method

•Analysis

•Preparation Plus Cleanup

•Analyte

•Reported Result

Report Parameters

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Sample
Type(s)	Select one or more sample types.
Date Range
Start	Section to select the start date.
End	Section to select the end date.
Matrix(es)	Select one or more matrices.
Test
Method(s)	Select one or more test methods.
Type(s)	Select one or more test types.
Lab SDG(s)	Select one or more Lab SDGs.
Lab ID	Select the lab name.
Result
Analyte
Individual(s):	Section for selecting individual analytes.
Group(s):	Section for selecting analytes groups.
Unit	Selection for report result units.
Type(s)	Select one or more result types.
Detect Flag(s)	Select one or more options for detect flags.
EDDImplementationID:	Text field parameter allowing users to specify the implementation ID.
EDDImplementationVersion:	Text field parameter allowing users to specify the implementation version.
EDDVersion:	Text field parameter allowing users to specify the EDD version.