ESdat Header File

The ESdat Laboratory Report header file is a small xml file that contains information about the Laboratory Report, and the key related data on the request.  It allows Laboratory Reports automatically consolidated into Projects or to be matched to a eRequest (eCoC) sent from LSPECS. Laboratories can choose to auto-generate the Header file from their LIMS (Laboratory Information Management System).

The “Project_ID” and “SDG/COC Number” will need to match the values provided by the client when submitting their paper Chain or Custody or electronic Laboratory Request (eCoC).

Populating the Header file without a LIMS

EScIS has a tool allowing laboratories to enter the required information, which will generate the Header file for them. This is available at http://www.esdat.net/Lab_Report_Header.aspx.

Generating the Header file from a LIMS

Laboratories can choose to auto-generate the Header file from their LIMS (Laboratory Information Management System).

A xsd file “eLabReport.xsd” is available here.

A sample xml file "eLabReport_sample.xml" is available here.

A validation tool for the xml files can be downloaded here.

The content of an xml file with example data is as below. 

Values in yellow will vary by laboratory report. Attributes in orange are optional, and are only applicable if the laboratory report is to be matched against an eCoC request from LSPECS:

        
            <?xml version="1.0" encoding="utf-8"?> 
            <ESdat generated="2013-08-16T08:09:51.278+10:00"
                fileType="eLabResultsHeader"
                schemaVersion="1.0.1"
                xmlns="http://www.escis.com.au/2013/XML">
		<LabReport Lab_Report_Number="LR04927" 
                    Date_Reported="2011-05-16" 
                    Project_ID="ClientsProjectNumber" 
                    Project_Number="LabProjectNumber" 
                    Lab_Name="Lab1" 
                    Lab_Signatory="John Brown">
                    <Associated_Files xmlns="http://www.escis.com.au/2013/XML/LabReport"/>
                    <Copies_Sent_To xmlns="http://www.escis.com.au/2013/XML/LabReport"/>
                    <eCoCs xmlns="http://www.escis.com.au/2013/XML/LabReport">
                        <eCoC SDG_ID="489" CoC_Number="Test MR 1 for_Lab1_22/10/2012">
                            <Lab_Requests> 
                                <Lab_Request ID="414" Number="1" Version="1"/>
                            </Lab_Requests>
                        </eCoC>
                    </eCoCs>
                </LabReport>
            </ESdat>
        
    

Definitions

Date Reported The date the Laboratory report was issued.
Project_ID A Client Project ID as indicated on the electronic Request..
Project_Number A Laboratory Project Number.
Lab_Name Free text, the name of the laboratory.
Lab_Signatory The Laboratory contact who has signed off on the results.
Associated Files A list of all the files that accompany this file. Optional.
Copies_Sent_To A list of people who have been sent these results. Optional.
SDG_ID A unique ID as provided in the Request XML. Optional but preferred.
COC_Number The SDG/COC Number indicated on the electronic Request.
Laboratory Request ID A unique ID as provided in the Request XML. Optional but preferred.
Laboratory Request Number As indicated on the electronic Request. The Laboratory Request Number will typically be 1, unless a client makes a request for additional analyses against the same Samples.
Laboratory Request Version As indicated on the electronic Request. The Laboratory Request Version will typically be 1, unless a client has made a mistake and wishes to alter the request.

XML Schema Documentation

View XSD file schema reference

  • 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