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
-
... ... @@ -18,7 +18,7 @@ 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 21 -**Controle XSLT**: [[attach:Labresult_Controle.xsl||rel="noopener noreferrer" target="_blank"]] 21 +**Controle XSLT**: [[attach:Labresult_Controle.xsl||rel=" noopener noreferrer" target="_blank"]] 22 22 23 23 **Domaintable files**: [[immetingen lookup v14.8.0.xml>>url:https://wiki.terraindex.com/bin/download/Implementation%20documentation/Setting%20up%20Lab%20communication%20by%20REST%20services%20with%20TerraIndex/Lab%20assignment%20file/WebHome/immetingen%20lookup%20v14.8.0.xml?rev=1.2]] [[imsikb0101 lookup v14.8.0.xml>>url:https://wiki.terraindex.com/bin/download/Implementation%20documentation/Setting%20up%20Lab%20communication%20by%20REST%20services%20with%20TerraIndex/Lab%20assignment%20file/WebHome/imsikb0101%20lookup%20v14.8.0.xml?rev=1.1]] 24 24 extracted from: **[[https:~~/~~/codes.sikb.nl>>url:https://codes.sikb.nl/]] ** ... ... @@ -51,169 +51,51 @@ 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 54 -With 3 differences /additions:54 +With 3 differences: 55 55 56 56 * Status on the labassignment itself 57 57 * Status on the labassignment.sample link 58 58 * The labassignment Report number can be send in: LabAssignmentCertificate 59 59 60 -|**Attribute**|**Notes** 61 -|((( 62 -**identification** NEN3610ID 63 -)))|((( 64 -A unique code that is created when the object is created for the first time. 65 -))) 66 -|((( 67 -**operatingLab** GenericName 68 68 69 - 70 -)))|((( 71 -Code of the laboratory to which the assignment is assigned. 61 +=== Status === 72 72 73 -Domaintable: [[Meetinstantie / Measuring Company>>url:https://codes.sikb.nl/tablet/domain-table-details/4e270f0a-cefe-446e-9d4d-6666c91180a8]] 74 -))) 75 -|((( 76 -**startTime** DateTime 77 -)))|Dispatch date of the lab assignment 78 -|((( 79 -**customerCode** CharacterString 80 -)))|Client code or debtor number of the client as known by the laboratory 81 - 82 -(% class="wikigeneratedid" %) 83 - 84 - 85 -=== LabAssignmentStatus === 86 - 87 87 |**Attribute Name**|**Description** 88 88 |((( 89 -**statusType **GenericName 65 +**numericValue** Measure 66 +)))|Numeric Value - the numerical value of the observation. When no unit for the measurement is known, the unit 'Dimensionless' should be used. 67 +|((( 68 +**valueProcessingMethod** GenericName 90 90 )))|((( 91 - The status ofthe labassignment.70 +Value Processing Method - a mathematical/statistical operation that is applied while the method of value determination/analysis standard remains unchanged. 92 92 93 -Use the value '5' for final reported results. 94 -Use other values, or '4', for conceptual values. 72 +The operation can be applied to a series of measurement values with the same parameter (quantity/component or typing or taxon or object) or to a series of measurement values with the same analysis method that are summed up to a sum parameter. 95 95 96 -Domain table: [[LabassignmentStatus>>https://codes.sikb.nl/tablet/domain-table-details/5c6ab373-693e-4039-af8d-93206ce4ebb4]]74 +Domain table: Value Processing Method 97 97 ))) 98 -|((( 99 -**dateExpected **DateTime 100 -)))|((( 101 -The date the results can be expected, in case of conceptual results. 102 102 103 -If final, fill with datetime.now. 104 -))) 105 - 106 106 === LabAssignmentCertificate === 107 107 108 108 |**Attribute Name**|**Description** 109 109 |((( 110 -** labCertificateNumber**CharacterString111 -)))| The numberofthecertificate thatwillbesendto theuser/client,and whatisused in thePDFfileas orderor reportnumber of the laboratory.81 +**numericValue** Measure 82 +)))|Numeric Value - the numerical value of the observation. When no unit for the measurement is known, the unit 'Dimensionless' should be used. 112 112 |((( 113 -** certification84 +**valueProcessingMethod** GenericName 114 114 )))|((( 115 - Underwhichcertificatethenalyses hasbeendone.If youdonotfindyoucodeleavethisfield empty86 +Value Processing Method - a mathematical/statistical operation that is applied while the method of value determination/analysis standard remains unchanged. 116 116 117 -Domain table: [[Certification Coding>>https://codes.sikb.nl/tablet/domain-table-details/df7ffd7c-192c-44f7-ae9f-0461d9266b30]] 118 -))) 88 +The operation can be applied to a series of measurement values with the same parameter (quantity/component or typing or taxon or object) or to a series of measurement values with the same analysis method that are summed up to a sum parameter. 119 119 120 -== LabAssignmentRequest == 121 - 122 -The connection between the labassignment and the samples with analysisrequests, as send in the labassignment. 123 - 124 -If not retreived in a labassignment, make it yourself so we can import is as new samples. 125 -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/#]] 126 - 127 - 128 -== Project == 129 - 130 -Activity that leads to the collection of soil data, as send in the labassignment. 131 -It will be used to search the correct project/investiation to bind or create the samples. 132 - 133 -|**Attribute**|**Notes** 134 -|((( 135 -**identification** NEN3610ID 136 -)))|The unique identifier of the Project in TerraIndex and in the whole Exchange Chain, as send in the labassignment 137 -|((( 138 -**name** CharacterString 139 - 140 - [0..1] 141 -)))|The name of the project where the lab results are for, as send in the labassignment 142 -|((( 143 -**projectCode** CharacterString 144 -)))|The project code of the project where the lab results are for, as send in the labassignment 145 - 146 -== Sample (AnalysisSample) == 147 - 148 -The analysissamples with analysisrequests, as send in the labassignment. The fieldsamples form the labassignment can be skipped in the results file. 149 - 150 -If not retreived in a labassignment, make it yourself so we can import is as new analysissamples. 151 -Just fill what you can fill, 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/#]] 152 - 153 -(% class="box infomessage" %) 154 -((( 155 -Please keep these scenario's in mind: [[Analysissample scenario's>>https://wiki.terraindex.com/bin/view/Implementation%20documentation/Setting%20up%20Lab%20communication%20by%20REST%20services%20with%20TerraIndex/Lab%20assignment%20file/#HWhatsamplescenario27sareexchanged3F]] 90 +Domain table: Value Processing Method 156 156 ))) 157 157 158 -|**Attribute**|**Notes** 159 -|((( 160 -**identification** NEN3610ID 161 -)))|The unique identifier of TerraIndex for the analyses sample, to keep this value unique forever in the whole exchange chain. 162 -|((( 163 -**name** CharacterString 164 164 165 - [0..1] 166 -)))|Name given to the sample 167 -|((( 168 -**specimenType** GenericName 94 +==== AnalyticResult (inherited from MeasureResult ==== 169 169 170 - [0..1] 171 -)))|((( 172 -Type of Sample- Fieldsample, Analysissample 173 173 174 -For analysissamples fill with value '10'. 175 - 176 -Domaintable: [[MonsterType / SampleType>>url:https://codes.sikb.nl/tablet/domain-table-details/9f956093-baad-4adb-b74d-20c00cef6ab4]] 177 -))) 178 -|((( 179 -**materialClass** GenericName 180 - 181 - 182 -)))|((( 183 -An SIKB code for the matrix type. Soil, Groundwater etc.. 184 - 185 -Domaintable: [[Compartiment / Matrix>>url:https://codes.sikb.nl/tablet/domain-table-details/6134f3bb-6048-431d-a130-01290d84172c]] 186 -))) 187 - 188 -== Analysis == 189 - 190 -The measured parameter with it's value and process. 191 - 192 192 |**Attribute Name**|**Description** 193 193 |((( 194 -**identification** NEN3610ID 195 -)))|The unique identifier of the AnalysisResult, to keep this value unique forever in the whole exchange chain. 196 -If not possible to store this in the Lims, generate on the fly. 197 -(% class="info" %)|((( 198 -**physicalProperty **PhysicalProperty 199 -)))|((( 200 -The combination of Quantity, Parameter and Condition to provide the parameter that has been measured. 201 -**[[See this chapter for the combinations, and the CAS-NR's. >>https://wiki.terraindex.com/bin/view/Implementation%20documentation/Setting%20up%20Lab%20communication%20by%20REST%20services%20with%20TerraIndex/Lab%20result%20file/#HSIKB14Parameterresultcombinations]]** 202 - 203 - 204 -))) 205 -|**result **AnalyticResult|The result of the analysis, see next chapter. 206 -|**procedure **AnalysisProcess|The process that has been used to measure/determine the result, see next chapter. 207 - 208 -(% class="wikigeneratedid" %) 209 - 210 - 211 -=== AnalyticResult (inherited from MeasureResult) === 212 - 213 -The actual reported value, result of detection limit. 214 - 215 -|**Attribute Name**|**Description** 216 -|((( 217 217 **numericValue** Measure 218 218 )))|((( 219 219 Numeric Value - the numerical value of the observation. When no unit for the measurement is known, the unit 'Dimensionless' should be used. ... ... @@ -261,38 +261,75 @@ 261 261 **alphanumericValue** CharacterString 262 262 )))|Textual value associated with an analysis result 263 263 264 -==== ==== 146 +==== ==== 265 265 266 -==== ==== 148 +==== ==== 267 267 268 - (%class="wikigeneratedid"%)150 +=== Structure projectgegevens === 269 269 270 270 271 -(% class="wikigeneratedid" %) 272 -=== AnalysisProcess === 153 +(% class="table-hover" %) 154 +|(% colspan="1" rowspan="1" %)**Attribute name**|(% colspan="1" rowspan="1" %)**Description**|(% colspan="1" rowspan="1" %)**Unit** 155 +|(% colspan="1" rowspan="1" %)**idopdracht**|(% colspan="1" rowspan="1" %)The TerraIndex id of the lab assignment the result belongs to.|(% colspan="1" rowspan="1" %)- 156 +|(% colspan="1" rowspan="1" %)**projectcode**|(% colspan="1" rowspan="1" %)The project code of the project as it was delivered in the lab assignment|(% colspan="1" rowspan="1" %)string 157 +|(% colspan="1" rowspan="1" %)**projectnaam**|(% colspan="1" rowspan="1" %)The name of the project as it was delivered in the lab assignment.|(% colspan="1" rowspan="1" %)string 158 +|(% colspan="1" rowspan="1" %)**ordernummer**|(% colspan="1" rowspan="1" %)Not relevant. The order in which the lab result could be shown|(% colspan="1" rowspan="1" %)string 159 +|(% colspan="1" rowspan="1" %)**projectleider**|(% colspan="1" rowspan="1" %)The project leader of the customer. This needs the be the “contactpersoon” from the lab assignment with the code PL|(% colspan="1" rowspan="1" %)string 160 +|(% colspan="1" rowspan="1" %)**status**|(% colspan="1" rowspan="1" %)The status of the lab assignment. See Labstatus Codegroup 76 in the attachments for all the options.|(% colspan="1" rowspan="1" %)integer 161 +|(% colspan="1" rowspan="1" %)**datumverwacht**|(% colspan="1" rowspan="1" %)The date on which the lab expects the certificate to be available|(% colspan="1" rowspan="1" %)Date 162 +yyyy-mm-dd 163 +|(% colspan="1" rowspan="1" %)**certificaatnummer**|(% colspan="1" rowspan="1" %)The number of the certificate that will be send to the user.|(% colspan="1" rowspan="1" %)string 164 +|(% colspan="1" rowspan="1" %)((( 165 +**analysemonsters** 273 273 274 -The process that has been used to detemine the measured value or result. 275 275 276 -|**Attribute Name**|**Description** 277 -|((( 278 -**identification** NEN3610ID 279 -)))|The unique identifier of the AnalysisProcess, it can be bound to multiple results at once. 280 -|**analyticalTechnique **GenericName|((( 281 -The used analytical technique to detemine the result. 168 + 169 +)))|(% colspan="1" rowspan="1" %)A table containing all the analysis sample with their corresponding results|(% colspan="1" rowspan="1" %)- 282 282 283 -Domain table: [[AnalyticalTechnique>>https://codes.sikb.nl/tablet/domain-table-details/04be2365-3d05-4903-a53e-edafef7111e8]] 284 -))) 285 -|**certification **GenericName|((( 286 -The used certification to detemine the result. 171 +== Structure analysemonsters == 287 287 288 -Domain table: [[CertificationCode>>https://codes.sikb.nl/tablet/domain-table-details/04be2365-3d05-4903-a53e-edafef7111e8]] 173 +(% style="text-align:center" %) 174 +[[image:1637656914799-534.png]] 175 + 176 +(% class="table-hover" %) 177 +|(% colspan="1" rowspan="1" %)**Attribute name**|(% colspan="1" rowspan="1" %)**Description**|(% colspan="1" rowspan="1" %)**Unit** 178 +|(% colspan="1" rowspan="1" %)**Idanlmons**|(% colspan="1" rowspan="1" %)The unique identification code of the analyses sample as given in the lab assignment file|(% colspan="1" rowspan="1" %)string 179 +|(% colspan="1" rowspan="1" %)**Anlmons**|(% colspan="1" rowspan="1" %)The name of the analyses sample as given in the lab assignment file|(% colspan="1" rowspan="1" %)string 180 +|(% colspan="1" rowspan="1" %)**Certificaat**|(% colspan="1" rowspan="1" %)The way the name of the sample should be on the certificate. This is also given in the lab assignment|(% colspan="1" rowspan="1" %)string 181 +|(% colspan="1" rowspan="1" %)**Monstersoort**|(% colspan="1" rowspan="1" %)The code referencing the type the sample is. Check the attachment: Sample type codegroup 51 for all the options|(% colspan="1" rowspan="1" %)integer 182 +|(% colspan="1" rowspan="1" %)**Status**|(% colspan="1" rowspan="1" %)The status of the sample. See Labstatus Codegroup 76 in the attachments.|(% colspan="1" rowspan="1" %)integer 183 +|(% colspan="1" rowspan="1" %)**Datumverwacht**|(% colspan="1" rowspan="1" %)The date on which the results for the sample are expected|(% colspan="1" rowspan="1" %)((( 184 +date 185 + 186 +yyyy-mm-dd 289 289 ))) 290 -|** valuationMethod**GenericName|(((291 - Theusedvaluationmethodtodeteminetheresult.188 +|(% colspan="1" rowspan="1" %)**Volgorde**|(% colspan="1" rowspan="1" %)Is a unused field in TerraIndex|(% colspan="1" rowspan="1" %)integer 189 +|(% colspan="1" rowspan="1" %)**analyseresultaten**|(% colspan="1" rowspan="1" %)A table containing all the measurement values of the analysis samples.|(% colspan="1" rowspan="1" %)- 292 292 293 -Domain table: [[ValuationMethod>>https://codes.sikb.nl/tablet/domain-table-details/04be2365-3d05-4903-a53e-edafef7111e8]] 191 +== Structure analyseresultaten == 192 + 193 +(% style="text-align:center" %) 194 +[[image:1637657248973-790.png]] 195 + 196 +(% class="table-hover" %) 197 +|(% colspan="1" rowspan="1" %)**Attribute name**|(% colspan="1" rowspan="1" %)**Description**|(% colspan="1" rowspan="1" %)**Unit** 198 +|(% colspan="1" rowspan="1" %)**componentcode**|(% colspan="1" rowspan="1" %)The SIKB component code. See ComponentCode Codegroup 52 in the attachements for all possible options.|(% colspan="1" rowspan="1" %)integer 199 +|(% colspan="1" rowspan="1" %)**meetwaarde**|(% colspan="1" rowspan="1" %)What the measured value is for the analyses|(% colspan="1" rowspan="1" %)float 200 +|(% colspan="1" rowspan="1" %)**meetwaardeomschrijving**|(% colspan="1" rowspan="1" %)Alpha numerical description of the result|(% colspan="1" rowspan="1" %)string 201 +|(% colspan="1" rowspan="1" %)**eenheidcode**|(% colspan="1" rowspan="1" %)The unit of the measured value. See Unit CodeGroup 40 in the attachements for all possible options|(% colspan="1" rowspan="1" %)integer 202 +|(% colspan="1" rowspan="1" %)**referentiecode**|(% colspan="1" rowspan="1" %)This defines what the reference for the measurement value is. See ReferenceType CodeGroup 41 for all the possible options|(% colspan="1" rowspan="1" %)integer 203 +|(% colspan="1" rowspan="1" %)**analysenorm**|(% colspan="1" rowspan="1" %)Against which standard the analysis has been tested. See Laboratory method Codegroup 57 in the attachments for all the option. I your standard is not in the list leave this empty|(% colspan="1" rowspan="1" %)integer 204 +|(% colspan="1" rowspan="1" %)**datummonstervoorbehandeling**|(% colspan="1" rowspan="1" %)The date on which the sample was pre-treated. We don’t do anything with this value|(% colspan="1" rowspan="1" %)((( 205 +date 206 + 207 +yyyy-mm-dd 294 294 ))) 209 +|(% colspan="1" rowspan="1" %)**opmerking**|(% colspan="1" rowspan="1" %)A remark for this result|(% colspan="1" rowspan="1" %)string 210 +|(% colspan="1" rowspan="1" %)**certificering**|(% colspan="1" rowspan="1" %)Under which certificate the analyses has been done. See CertificateCode Codegroup 48 for all the possible options. If you do not find you code leave this field empty|(% colspan="1" rowspan="1" %)integer 211 +|(% colspan="1" rowspan="1" %)**status**|(% colspan="1" rowspan="1" %)The status of the labresult in the labassignemnt. See Labstatus Codegroep 76 in the attachments|(% colspan="1" rowspan="1" %)integer 212 +|(% colspan="1" rowspan="1" %)**datumverwacht**|(% colspan="1" rowspan="1" %)Date on which the analyses results are expected.|(% colspan="1" rowspan="1" %)date 295 295 214 += = 296 296 297 297 = What to exchange to bind the right results to the right sample? = 298 298 ... ... @@ -332,6 +332,7 @@ 332 332 * If an Analysis Sample is found, the Analysis Results are always updated or added. 333 333 * If Project is found, but the analysis sample is not; then this analysis sample is imported as a new analysis sample with all results. 334 334 * (If it concerns water samples, a new fictional/temporary measuring point and filter could be created.) 254 +* 335 335 336 336 = SIKB 14 Parameter result combinations = 337 337