|
<< Click to Display Table of Contents >> Navigation: Professional > Interfaces > Data Interfaces > SEDD > SEDD Data and Workflow |
The original EQuIS SEDD format has been deprecated and replaced with the workflow outlined below. The SEDD format is still available by request on the EarthSoft Community Center (ECC) but does not include mappings to the tables from which the EQuIS SEDD Report pulls its data.
The SEDD file that is exported by the EQuIS SEDD Report can be parsed by EDP into the different sections of the SEDD format. However, the report was not designed specifically to work in tandem with the format, so the viability of this workflow cannot be spoken for.
The mappings of the EQEDD_v2 and Refvals formats can be leveraged to take full advantage of the mappings enumerated below. The table below provides an outline of where each SEDD field listed in the Exporting Data table can be populated in either an EQEDD_v2 or Refvals EDD such that after the data are committed, data can be pulled out into an XML file by the EQuIS SEDD Report.
It is not required that these specific formats are used to load data. So long as the database tables/fields in question are populated with the correct data, the report will pull the data out properly. However, the EQuIS SEDD Report was designed based on the mappings of these two formats. Users may choose to use other formats to load SEDD data, but it is not guaranteed that the format will map to every database field from which the report will look to pull data.
Note: All required fields in a format must be populated before an EDD can be committed to the database successfully, but not all required fields will be exported by the EQuIS SEDD Report. |
Format Section |
Field |
SEDD Field |
|---|---|---|
rt_analyte |
cas_rn |
CASRegistryNumber |
chemical_name |
ClientAnalyteID |
|
remark |
Comment |
|
rt_company |
company_code |
LabID |
company_name |
LabName |
|
contact_name |
LabPointOfContact |
|
address_1 |
LabAddress1 |
|
address_2 |
LabAddress2 |
|
city |
LabCity |
|
state |
LabState |
|
country |
LabCountry |
|
postal_code |
LabZipCode |
|
phone_number |
LabTelephoneNumber |
|
email_address |
LabPointOfContactElectronicAddress |
|
rt_sample_type |
sample_type_code |
QCType |
remark |
QCCategory |
Format Section |
Field |
SEDD Field |
|---|---|---|
Location_v2 |
sys_loc_code |
LocationID |
loc_name |
LocationName |
|
LabSample_v2 |
sys_sample_code |
ClientSampleID |
sample_name |
LabSampleID |
|
sample_matrix_code |
MatrixID |
|
sample_type_code |
QCType |
|
sample_delivery_group |
LabReportingBatch |
|
sample_date |
CollectedDate |
|
sys_loc_code |
LocationID |
|
chain_of_custody |
CustodyID |
|
sampling_method |
ClientMethodID |
|
comment |
Comment |
|
TestResults_v2 |
sys_sample_code |
ClientSampleID |
lab_anl_method_name |
MethodID |
|
analysis_date |
AnalyzedDate |
|
test_type |
AnalysisType |
|
container_id |
BottleID |
|
dilution_factor |
DilutionFactor |
|
lab_name_code |
LabID |
|
test_comment |
Comment |
|
cas_rn |
CASRegistryNumber |
|
result_value |
Result |
|
result_type_code |
AnalyteType |
|
detect_flag |
ResultType |
|
lab_qualifiers |
LabQualifiers |
|
method_detection_limit |
DetectionLimit |
|
result_unit |
ResultUnits |
|
detection_limit_unit |
DetectionLimitUnits |
|
result_comment |
Comment |
|
TestResultsQC_v2 |
sys_sample_code |
ClientSampleID |
lab_anl_method_name |
MethodID |
|
analysis_date |
AnalyzedDate |
|
test_type |
AnalysisType |
|
container_id |
BottleID |
|
dilution_factor |
DilutionFactor |
|
lab_name_code |
LabID |
|
comment |
Comment |
|
cas_rn |
CASRegistryNumber |
|
result_value |
Result |
|
result_type_code |
AnalyteType |
|
detect_flag |
ResultType |
|
lab_qualifiers |
LabQualifiers |
|
method_detection_limit |
DetectionLimit |
|
result_unit |
ResultUnits |
|
detection_limit_unit |
DetectionLimitUnits |
|
result_comment |
Comment |
|
TestBatch_v2 |
sys_sample_code |
ClientSampleID |
lab_anl_method_name |
MethodID |
|
analysis_date |
AnalyzedDate |
|
test_type |
AnalysisType |
|
test_batch_id |
LabAnalysisID |
The table below outlines the database fields from which the EQuIS SEDD Report will pull data to map into the corresponding SEDD fields.
Note: When making report parameter selections, it is recommended that a Lab ID is specified. The report is only capable of exporting Contact Information for a single Lab ID. If more than one lab was involved in the analysis, the report should be run once for each lab involved. |
SEDD Section |
SEDD Field |
Report Source |
|---|---|---|
Header |
EDDID |
‘SEDD’ |
EDDImplementationID |
Report Parameter text box |
|
EDDImplementationVersion |
Report Parameter text box |
|
EDDVersion |
Report Parameter text box |
|
LabID |
DT_TEST.LAB_NAME_CODE |
|
Contact Information |
LabAddress1 |
RT_COMPANY.ADDRESS_1 |
LabAddress2 |
RT_COMPANY.ADDRESS_2 |
|
LabCity |
RT_COMPANY.CITY |
|
LabState |
RT_COMPANY.STATE |
|
LabCountry |
RT_COMPANY.COUNTRY |
|
LabID |
DT_TEST.LAB_NAME_CODE |
|
LabName |
RT_COMPANY.COMPANY_NAME |
|
LabPointOfContact |
RT_COMPANY.CONTACT_NAME |
|
LabPointOfContactElectronicAddress |
RT_COMPANY.EMAIL_ADDRESS |
|
LabTelephoneNumber |
RT_COMPANY.PHONE_NUMBER |
|
LabZipCode |
RT_COMPANY.POSTAL_CODE |
|
Sample Plus Method |
BottleID |
DT_TEST.CONTAINER_ID |
ClientMethodID |
DT_SAMPLE.SAMPLE_METHOD |
|
ClientSampleID |
DT_SAMPLE.SYS_SAMPLE_CODE |
|
CollectedDate |
DT_SAMPLE.SAMPLE_DATE |
|
Comment |
DT_SAMPLE.REMARK |
|
CustodyID |
DT_FIELD_SAMPLE.CHAIN_OF_CUSTODY |
|
LabID |
DT_TEST.LAB_NAME_CODE |
|
LabReportingBatch |
DT_TEST.LAB_SDG |
|
LabSampleID |
DT_SAMPLE.SAMPLE_NAME |
|
LocationID |
DT_SAMPLE.SYS_LOC_CODE |
|
LocationName |
DT_LOCATION.LOC_NAME |
|
MatrixID |
DT_SAMPLE.MATRIX_CODE |
|
MethodID |
DT_TEST.ANALYTIC_METHOD |
|
QCCategory |
RT_SAMPLE_TYPE.REMARK |
|
QCType |
DT_SAMPLE.SAMPLE_TYPE_CODE |
|
Analysis |
AnalysisType |
DT_TEST.TEST_TYPE |
AnalyzedDate |
DT_TEST.ANALYSIS_DATE |
|
BottleID |
DT_TEST.CONTAINER_ID |
|
ClientMethodID |
DT_SAMPLE.SAMPLE_METHOD |
|
Comment |
DT_TEST.REMARK |
|
DilutionFactor |
DT_TEST.DILLUTION_FACTOR |
|
LabAnalysisID |
DT_TEST_BATCH.TEST_BATCH_ID |
|
LabID |
DT_TEST.LAB_NAME_CODE |
|
MethodID |
DT_TEST.ANALYTIC_METHOD |
|
Preparation Plus Cleanup |
BottleID |
DT_TEST.CONTAINER_ID |
ClientMethodID |
DT_SAMPLE.SAMPLE_METHOD |
|
LabID |
DT_TEST.LAB_NAME_CODE |
|
MethodID |
DT_TEST.ANALYTIC_METHOD |
|
Analyte |
AnalyteType |
DT_RESULT.RESULT_TYPE_CODE |
CASRegistryNumber |
DT_RESULT.CAS_RN |
|
ClientAnalyteID |
RT_ANALYTE.CHEMICAL_NAME |
|
Comment |
RT_ANALYTE.REMARK |
|
DetectionLimit |
DT_RESULT.METHOD_DETECTION_LIMIT |
|
DetectionLimitUnits |
DT_RESULT.DETECTION_LIMIT_UNIT |
|
Result |
DT_RESULT.RESULT_TEXT |
|
ResultType |
DT_RESULT.DETECT_FLAG |
|
Reported Result |
AnalyteType |
DT_RESULT.RESULT_TYPE_CODE |
CASRegistryNumber |
DT_RESULT.CAS_RN |
|
ClientAnalyteID |
RT_ANALYTE.CHEMICAL_NAME |
|
Comment |
DT_RESULT.REMARK |
|
DetectionLimit |
DT_RESULT.METHOD_DETECTION_LIMIT |
|
DetectionLimitUnits |
DT_RESULT.DETECTION_LIMIT_UNIT |
|
LabAnalysisID |
DT_TEST_BATCH.TEST_BATCH_ID |
|
Result |
DT_RESULT.RESULT_TEXT |
|
ResultType |
DT_RESULT.DETECT_FLAG |
|
ResultUnits |
DT_RESULT.RESULT_UNIT |
|
LabQualifiers |
DT_RESULT.LAB_QUALIFIER |
Copyright © 2025 EarthSoft, Inc. • Modified: 23 May 2025