Reporting lab results to TerraIndex for a customer

Returning the labresults to the client, that requested the analysis on samples.

• Reporting lab results to TerraIndex for a customer
  • What is a Lab result file?
  • Model Structure
    • Metadata
    • Labassignment
    • LabAssignmentStatus
    • LabAssignmentCertificate
    • LabAssignmentRequest
    • Project
    • Sample (AnalysisSample)
    • Analysis
    • AnalyticResult (inherited from MeasureResult)
    • AnalysisProcess
• What to exchange to bind the results to the correct sample?
• SIKB 14 Parameter result combinations
• Samples with their Types

What is a Lab result file?

A lab result file is an XML file contains all the lab results. The results are mapped tot their analyses samples. A lab result will be matched to the corresponding analyses sample based on the: “Labassignment Guid/SIKB-ID, projectCode, AnalysisSample Guid/SIKB-ID”

Example files: labresult_IndividualGw.xml, labresult_IndividualGr.xml, labresult_MixedSampleGr.xml

XSD: Ask or SIKB Members can download from: https://www.sikb.nl/datastandaarden/richtlijnen/sikb0101

Controle XSLT: Labresult_Controle.xsl

Domaintable files: immetingen lookup v14.8.0.xml   imsikb0101 lookup v14.8.0.xml
extracted from: https://codes.sikb.nl 

• Reporting lab results to TerraIndex for a customer
  • What is a Lab result file?
  • Model Structure
    • Metadata
    • Labassignment
    • LabAssignmentStatus
    • LabAssignmentCertificate
    • LabAssignmentRequest
    • Project
    • Sample (AnalysisSample)
    • Analysis
    • AnalyticResult (inherited from MeasureResult)
    • AnalysisProcess
• What to exchange to bind the results to the correct sample?
• SIKB 14 Parameter result combinations
• Samples with their Types

Model Structure

Metadata

Labassignment

The labassignment is the same as in the labassignment file: Lab assignment file - SIKB0101 v14 

With 3 differences/additions:

• Status on the labassignment itself
• Status on the labassignment.sample link
• The labassignment Report number can be send in: LabAssignmentCertificate

LabAssignmentStatus

LabAssignmentCertificate

LabAssignmentRequest

The connection between the labassignment and the samples with analysisrequests, as send in the labassignment.

If not retreived in a labassignment, make it yourself so we can import is as new samples.
Just fill what you can fill, otherwise leave field empty, based on documentation here: Labassignment file - SIKB0101 v14
 

Project

Activity that leads to the collection of soil data, as send in the labassignment.
It will be used to search the correct project/investiation to bind or create the samples.

Sample (AnalysisSample)

The analysissamples with analysisrequests, as send in the labassignment. The fieldsamples form the labassignment can be skipped in the results file.

If not retreived in a labassignment, make it yourself so we can import is as new analysissamples.
Just fill what you can fill, based on documentation here: Labassignment file - SIKB0101 v14

Analysis

The measured parameter with it's value and process.

AnalyticResult (inherited from MeasureResult)

The actual reported value, result of detection limit.

AnalysisProcess

The process that has been used to detemine the measured value or result.

What to exchange to bind the results to the correct sample?

The data stream ‘Lab Result’ is the feedback of analysis results on the requested lab assignment at a laboratory. At import we need to bind it onto the correct sample.

This requires importand field to match the samples in the xml to the samples in our database.

Important fields:

Remarks:

• The entity ‘Analysis Result’ does not yet have a fixed lokaalID (GUID), connected laboratories cannot yet guarantee that a unique ID will be generated.
• For Asbestos and Asphalt, new samples are also created at the Lab, which are therefore fed back with a reference to the sample from which they are derived.
• There is still a desire to feedback from a lab whether an analysis sample has been modified at the lab in terms of sub-samples. For example, if a jar has broken and been replaced with another jar. This has not yet been included in current practices.

Importing the data will be done based on the following steps:

• Search Project with Project.lokaalID (as placed in the Lab assignment XML).
• Search Project with Project.ProjectCode (as placed in the Lab assignment XML) if searching on Project.LokaalID yields no results.
• Search Project and Lab assignment with Labassignment.LokaalID (as placed in the Lab assignment XML) if the Project has not yet been found.
• Search Project (if Project not yet found) and Analysis Sample with Sample.LokaalID as GUID (as placed in the Lab assignment XML, version 11 and higher).
• Search Project (if Project not yet found) and Analysis Sample with Sample.LokaalID as BISNR (as placed in the Lab assignment XML, versions lower than 11, 'old' idanlmons/BISNR).
• Search Analysis Sample with Sample.Name within the project, if the Analysis Sample has not been found but the project has.

What can be imported?

• If an Analysis Sample is found, the Analysis Results are always updated or added.
• If Project is found, but the analysis sample is not; then this analysis sample is imported as a new analysis sample with all results.
• (If it concerns water samples, a new fictional/temporary measuring point and filter could be created.)

SIKB 14 Parameter result combinations

In the SIKB0101 version 14 exchange of labresults is combination needed for exchanging the result parameters of the Lab analysis.
It's based on PhysicalProperty, the combination of Quantity, Parameter and Condition.


*small remark, condition will be used as: [0..1] 

Domaintables bound to these fields:

• Quantity - Parameter, but only group/groep: Grootheid (Quantity)
• Parameter - Parameter, but mainly group/groep: Chemische Stof (Chemical substance)
• Condition - Condition, but not group/groeps that refer to Chemical substance.

The combinations are defined for different compartiments like soil/ground, groundwater, wastewater.
Below are some examples, and some attachments included to support all combinations.

2 Examples for Soil:

2 Examples for Groundwater:

2 Examples for Wastewater:

We can help you with the right combinations and mappings to your own codes.

Samples with their Types

For different compartments, the links between samples and analysisResults can differ a little bit.
Below the way the enitity Sample can be filled in the xml.