ESDAT Electronic Lab Data Format v2e:

The purpose of the ESDAT Electronic Lab Data Format (ELDF) is to enable transfer of data from a laboratory to ESDAT users in a format which allows checking and direct import into ESDAT.

This version 2e format is compatible with all current implementations of ESdat.

The files contain batch receipt, lab report, sample and chemistry information, including comprehensive quality assurance data. The ELDF consists of three files.

Files:

  • Header File

  • Sample File

  • Chemistry Results File (which contains the results).

Previous optional files (SDG and Lab Report) have now been replaced with the above header file.

The file names are of the format: Project Name as provided by the users; a full stop; a laboratory file identifier; a full stop; the text "Chemistry2e" or "Sample2e" etc.. (For the Chemistry or Sample ELDF respectively) and the suffix ".csv".

An example of a file set would be

Project1.LabFile01.Header.xml
Project1.LabFile01.Sample2e.csv
Project1.LabFile01.Chemistry2e.csv
+ any PDF files usually provided by the laboratory.

Header File:

See Header File Specifications

Sample File:

Within the csv export files Line 1 lists the data fields, line 2 and onwards contains the data for those fields:

One record for each field and laboratory sample.

Primary Key

Field

Description

Req'd

Data Type

*

SampleCode

Unique Identifier for each sample *

Y

Text(40)

Sampled_Date_Time

From COC

Date with optional time

Field_ID

From COC (Normal samples only)

Text(40)

Blank1**

Empty

Depth

From COC

Number or Number - (dash) Number

Blank2

Empty

Matrix_Type

Y

List of Soil, Water, Gas, SoilGas, Other

Sample_Type

Description of sample as from the field, spike, surrogate.

Y

List of :
Normal,
MS, (Matrix Spike)
MS_D, (Matrix Spike Duplicate)
Trip_B, (Trip Blank)
MB, (Method Blank)
SB, (Storage Blank)
LCS, (Lab Control Sample)
LCS_D, (LCS Duplicate)
SRM, (Standard Reference Material)
CRM, (Certified Reference Material)
LAB_D (Duplicate)
LAB_T (Triplicate)
NCP (Non-Client Parent - for duplicates or spikes from another client in the same sample analysis batch)

Parent_Sample

For duplicates, give the SampleCode of the original

Text(40)

Blank3

Empty

N

SDG

Sample Delivery Group, From COC, or if not available use "Lab Name Date Received".

Lab QA Samples should be given the same SDG as the field Samples, or the value should be left blank.

Y

Text(20)

Lab_Name

Y

Text(20)

Lab_SampleID

Laboratory Sample ID

Y

Text(20)

Lab_Comments

Comments regarding the sample

N

Text(255)

Lab_Report_Number

Y

Text(20)

*The SampleCode should be constructed using the following method. Field Samples to be coded SDG_FieldID. Laboratory Samples (all non client samples) to be coded Lab Report Number_LabSampleID

**Fields Blank1, Blank2 etc.. are to maintain consistency with the current v2.7 export. They do not need to be populated as this data is now provided in the Lab Report and SDG files. They will eventually be removed from the export when all ESdat users can support v4 of the ELDF. When they are removed the alterated files will be v4 compatible.

*** The records in the file should be sorted by Sample_Type DESC.  This means the "Normal" samples will appear first.  A secondary sort should be by Field_ID ASC.  This makes it easy for users to identify their QA Samples.

Chemistry File:

Within the csv export files Line 1 lists the data fields, line 2 and onwards contains the data for those fields:

One record for each result.

Primary Key Field

Description

Req'd

Data Type

*

SampleCode

Unique Identifier for each sample (as per Sample File)

Y

Text(40)

*

ChemCode

Unique Identifier for each analyte (eg. CAS number)

Y

Text(20)

OriginalChemName

Common name for the analyte

Y

Text(50)

Prefix

if below detection limit

"<" or ">"

Result

Y

Number

Result_Unit

Y

Text(10)

*

Total_or_Filtered

Either Total or Filtered, if blank will default to T.

Y

List of
T (Total)
F (Filtered)

*

Result_Type

Y

Restricted to:
REG (regular result)
leached_REG (regular leached results)
SUR (Surrogate)
SC (Spike Compound)

Method_Type

Y

Text(50):
PAH
Pesticides
Inorganic
Metals...

Etc as indicated on the CoC.

If a suitable value isn’t available then the name of the Method is most suitable, ie for the method “EG005T: Total Metals by ICP-AES”, the Name “Total Metals by ICP-AES” or similar would be most suitable.

 

Method_Name

Method or Test Code.

Y

Text(70)

Extraction_Date

Date extracted

if possible

Date

Analysed_Date

Date analyzed

if possible

Date

EQL

Quantitation Limit

Y

Number

EQL_Units

Quantitation Limit Units

Y

Text(15)

Comments

Lab Comments specific to a result.

N

Text(255)

Lab_Qualifier*

N

Text **

UCL

Upper Confidence Limit used for surrogate recoveries

N

Number

LCL

Lower Confidence Limit used for surrogate recoveries

N

Number

*The Lab_Qualifier may be populated with a data qualifier (U,J,J+,J-,R,UJ) as described in various USEPA documents, for example: http://www.epa.gov/superfund/programs/clp/download/inorgfg10-08-04.pdf , / Data Qualifier Definitions

** Multiple Lab Qualifiers to be separated with a semi colon ";"

File Format

The fields and data in the csv files may optionally be surrounded by quotation marks.

Duplicates

Lab duplicates and triplicates should have a different sample code to the original sample, (typically the same code ending in _D, _T or similar, ie each sample code is unique). The Sample_Type field should indicate whether it is a duplicate or triplicate. The original sample code for duplicates or triplicates should go in the field "Parent_Sample".

Leachate Tests

Leaching test results are not given a separate SampleCode, (ie are not treated as a separate sample). Results are indicated in the chemistry file, and are identified in the Result_Type field.

Date Formats

Dates should be in the format dd mmm yyyy (eg 3 Jan 2007). This avoids confusion between users with different regional settings. If time is included it should be hh:mm AM/PM.

Tentatively Identified Compounds

Tentatively Identified Compounds should be identified as such in the Comments field of the chemistry file.

Asbestos

As the result value requires a number, and asbestos is often reported as text the following convention is adopted.

For a non detect the result has a value of 0. For a detect the result has a value of 1. The Result_Unit should be "Detect". The text is inserted into the Comments field.

The EQL and the EQL Unit should remain as normal for an EQL, for example: 1 g/kg.

Aborted Analysis

Aborted analyses can be reported, a value of -999 should be entered as a result, and a comment entered into the Comments field in the Results file.

  • Contact
  • 100% of environmental professionals saved time when using Esdat Environmental Data Software. Over 50% of professionals achieved time savings of at least 40%.
  • © 2017