Changes for page Lab result file - SIKB0101 v14
Last modified by Robin Huisman on 2025/02/27 09:44
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -8,6 +8,7 @@ 8 8 ))) 9 9 10 10 11 +{{toc/}} 11 11 12 12 == What is a Lab result file? == 13 13 ... ... @@ -14,7 +14,7 @@ 14 14 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” 15 15 16 16 17 -**Example files**: [[attach:labresult aat_MengmonsterGr.xml||rel="noopener noreferrer" target="_blank"]], [[attach:labresultaat_IndividueelGr.xml||rel="noopener noreferrer" target="_blank"]], [[attach:labresultaat_IndividueelGw.xml||rel="noopener noreferrer" target="_blank"]]18 +**Example files**: [[attach:labresult_IndividualGw.xml||rel="noopener noreferrer" target="_blank"]], [[attach:labresult_IndividualGr.xml||rel="noopener noreferrer" target="_blank"]], [[attach:labresult_MixedSampleGr.xml||rel="noopener noreferrer" target="_blank"]] 18 18 19 19 **XSD**: Ask or SIKB Members can download from: [[https:~~/~~/www.sikb.nl/datastandaarden/richtlijnen/sikb0101>>url:https://www.sikb.nl/datastandaarden/richtlijnen/sikb0101]] 20 20 ... ... @@ -46,8 +46,7 @@ 46 46 |(% colspan="1" rowspan="1" %)**supplier**|(% colspan="1" rowspan="1" %)The number you get from TerraIndex. This needs to be the same as the laboratorium number in the lab delivery file. Your supplier code can be requested of found here: [[https:~~/~~/codes.sikb.nl/tablet/domain-table-details/dc2ad4df-f958-4146-aee8-31f8c2f1c74b>>https://codes.sikb.nl/tablet/domain-table-details/dc2ad4df-f958-4146-aee8-31f8c2f1c74b]]|(% colspan="1" rowspan="1" %)string 47 47 |(% colspan="1" rowspan="1" %)**dataflow**|(% colspan="1" rowspan="1" %)Should be '1' in this case, what stands voor 'AnalysisResults'. Other option can be found here: [[https:~~/~~/codes.sikb.nl/tablet/domain-table-details/79365ded-f56a-4f10-ba45-16bac69752d9>>https://codes.sikb.nl/tablet/domain-table-details/79365ded-f56a-4f10-ba45-16bac69752d9]]|(% colspan="1" rowspan="1" %)integer 48 48 49 -=== 50 -Labassignment === 50 +=== Labassignment === 51 51 52 52 The labassignment is the same as in the labassignment file: [[Lab assignment file - SIKB0101 v14>>https://wiki.terraindex.com/bin/view/Implementation%20documentation/Setting%20up%20Lab%20communication%20by%20REST%20services%20with%20TerraIndex/Lab%20assignment%20file/#]] 53 53 ... ... @@ -79,8 +79,6 @@ 79 79 **customerCode** CharacterString 80 80 )))|Client code or debtor number of the client as known by the laboratory 81 81 82 - 83 - 84 84 === LabAssignmentStatus === 85 85 86 86 |**Attribute Name**|**Description** ... ... @@ -116,7 +116,7 @@ 116 116 Domain table: [[Certification Coding>>https://codes.sikb.nl/tablet/domain-table-details/df7ffd7c-192c-44f7-ae9f-0461d9266b30]] 117 117 ))) 118 118 119 -== LabAssignmentRequest == 117 +=== LabAssignmentRequest === 120 120 121 121 The connection between the labassignment and the samples with analysisrequests, as send in the labassignment. 122 122 ... ... @@ -124,7 +124,7 @@ 124 124 Just fill what you can fill, otherwise leave field empty, based on documentation here: [[Labassignment file - SIKB0101 v14>>https://wiki.terraindex.com/bin/view/Implementation%20documentation/Setting%20up%20Lab%20communication%20by%20REST%20services%20with%20TerraIndex/Lab%20assignment%20file/#]] 125 125 126 126 127 -== Project == 125 +=== Project === 128 128 129 129 Activity that leads to the collection of soil data, as send in the labassignment. 130 130 It will be used to search the correct project/investiation to bind or create the samples. ... ... @@ -142,7 +142,7 @@ 142 142 **projectCode** CharacterString 143 143 )))|The project code of the project where the lab results are for, as send in the labassignment 144 144 145 -== Sample (AnalysisSample) == 143 +=== Sample (AnalysisSample) === 146 146 147 147 The analysissamples with analysisrequests, as send in the labassignment. The fieldsamples form the labassignment can be skipped in the results file. 148 148 ... ... @@ -184,7 +184,7 @@ 184 184 Domaintable: [[Compartiment / Matrix>>url:https://codes.sikb.nl/tablet/domain-table-details/6134f3bb-6048-431d-a130-01290d84172c]] 185 185 ))) 186 186 187 -== Analysis == 185 +=== Analysis === 188 188 189 189 The measured parameter with it's value and process. 190 190 ... ... @@ -204,8 +204,6 @@ 204 204 |**result **AnalyticResult|The result of the analysis, see next chapter. 205 205 |**procedure **AnalysisProcess|The process that has been used to measure/determine the result, see next chapter. 206 206 207 - 208 - 209 209 === AnalyticResult (inherited from MeasureResult) === 210 210 211 211 The actual reported value, result of detection limit. ... ... @@ -259,12 +259,6 @@ 259 259 **alphanumericValue** CharacterString 260 260 )))|Textual value associated with an analysis result 261 261 262 -==== ==== 263 - 264 -==== ==== 265 - 266 - 267 - 268 268 === AnalysisProcess === 269 269 270 270 The process that has been used to detemine the measured value or result. ... ... @@ -289,7 +289,7 @@ 289 289 Domain table: [[ValuationMethod>>https://codes.sikb.nl/tablet/domain-table-details/04be2365-3d05-4903-a53e-edafef7111e8]] 290 290 ))) 291 291 292 -= What to exchange to bind the r ight results to the right sample? =282 += What to exchange to bind the results to the correct sample? = 293 293 294 294 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. 295 295 ... ... @@ -368,10 +368,37 @@ 368 368 |cyanide-complex|2595|2720|(massa)Concentratie|8|Niet van toepassing 369 369 |som 29 dioxines (TEQ)|2160|2720|(massa)Concentratie|10|uitgedrukt in Toxiciteit equivalenten 370 370 371 -__**Full combinations sheet: **__[[attach:Full List of AnalysisResult combinations 04-2024.xlsx||rel="noopener noreferrer" target="_blank"]] 361 +(% class="box successmessage" %) 362 +((( 372 372 364 +**DOWLOAD EXCELSHEET** 365 +\\Full combinations sheet:__** [[attach:Full List of AnalysisResult combinations 04-2024.xlsx||rel="noopener noreferrer" target="_blank"]]**__ 366 +))) 367 + 373 373 We can help you with the right combinations and mappings to your own codes. 374 374 375 375 371 += Samples with their Types = 376 376 377 - 373 +For different compartments, the links between samples and analysisResults can differ a little bit. 374 +Below the way the enitity Sample can be filled in the xml. 375 + 376 +|(% colspan="4" %)**Soil Samples**| | | | 377 +|(% colspan="8" %)- **FieldSample – BO01-1**, matrix = GR (SampleType = 1) 378 +|(% colspan="7" %)o Container – Jar BO01-1, barcode: fdmsakfds| 379 +|(% colspan="6" %)o Link to AnalysisSample: M1| | 380 +|(% colspan="8" %)- **AnalysisSample – M1**, matrix = GR (SampleType = 10) 381 +|(% colspan="6" %)o Link to SubSample: BO01-1| | 382 +|(% colspan="4" %)o Labanalysis Requests| | | | 383 +|(% colspan="4" %)o LabResults| | | | 384 +| | | | | | | | 385 +|(% colspan="5" %)**Water Samples (with multiple bottles) / Air Sample**| | | 386 +|(% colspan="8" %)- **FieldSample – WA1**, matrix = GW (SampleType = 1) 387 +|(% colspan="7" %)o Container – Bottle WA1-1, barcode: dfsfdslasd| 388 +|(% colspan="7" %)o Container – Bottle WA1-2, barcode: fdsvfdsvfs| 389 +|(% colspan="7" %)o Container – Bottle WA1-3, barcode: kjhgfvvxx| 390 +|(% colspan="7" %)o Link to AnalysisSample: WA1_Sample| 391 +|(% colspan="8" %)- **AnalysisSample – WA1_Sample**, matrix = GW (SampleType = 10) 392 +|(% colspan="6" %)o Link to SubSample: WA1| | 393 +|(% colspan="4" %)o Labanalysis Requests| | | | 394 +|(% colspan="4" %)o LabResults| | | |