Converting ELDF 2e to ELDF 4

Home / Converting ELDF 2e to ELDF 4

Description

ELDF files:

ELDF 4 comprises the same files as used by ELDF 2e, namely:

Header File

Sample File

Chemistry File (which contains the results).

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 “Header”, “Sample2e” or “Chemistry2e” as appropriate and the file extension (“.xml”or “.csv” as appropriate). An example of a file set would be

Project1.LabFile01.Header.xml

Project1.LabFile01.Sample2e.csv

Project1.LabFile01.Chemistry2e.csv

COC and COA in PDF Format as well as other files usually provided by the laboratory.

Laboratories can provide a comment that applies to the entire lab report in the Header file. Some laboratories had previously reported this comment against samples; it should be verified that this isn't being done.

A “Primary Recipient Org” can be reported with the lab report, for use where reports are issued by to a site holder and also a consultant (or similar scenario).

A lab report can be explicitly specified as “Preliminary” or “Final”.

Definitions for Laboratory Qualifiers can be entered.

Chemistry File:

Within the csv export files Line 1 lists the data fields, line 2 and onwards contains the data for those fields:
Additional Columns have been added after the last column (LCL) in ELDF 2e:

*MDL (Method Detection Limit)

*RDL (Reporting Detection Limit)

ODL (Other Detection Limit, for example a Defense or Contractual specified Detection Limit. Leave blank if not applicable)

*Lab_Preperation_Batch_ID (A unique value per sample preparation batch.)

*Lab_Analysis_Batch_ID (A unique value per analysis batch)

*Lab_Analysis_ID (A unique value per analysis run included in the report.)

*Dilution_Factor

Spike_Concentration (The applied concentration of the spike or surrogate.)

Spike_Measurement (The measured concentration of the spike or surrogate.)

Spike_Units (Units used for Spike Concentration and Measurement)

The columns marked with a * are required and cannot contain blank values. The remaining columns are able to be left blank or contain blank values as applicable.

The spike columns should be populated for a Sample_Type of MS (Matrix Type) and for all samples where the Result_Type is one of Sur, leached_Sur, MS (ie it’s a Surrogate or Matrix Spike result)

If implementing ELDF 4 it is recommended the laboratory retire ELDF 2e, so that only one ESdat format is being issued from the laboratory. If the laboratory elects to retain both formats they should be fully consistent for columns that are common to both, and particularly the ChemCodes should reference a single common list that is used in both exports.

Have questions?

Helping YOU do, what YOU want, with YOUR data

Data Analysis and Reporting

Converting ESdat Electronic Lab Data Format (ELDF) 2e to 4:

QA information