Last modified by Robin Huisman on 2025/02/27 09:44
<
From version < 38.1 >
edited by Robin Huisman
on 2024/08/01 00:13
To version < 36.2 >
edited by Robin Huisman
on 2024/07/31 23:33
>
Change comment: There is no comment for this version

Summary

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/]] **
... ... @@ -49,198 +49,76 @@
49 49  ===
50 50  Labassignment ===
51 51  
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/#]]
52 +The labassignmentpart is the same as in the labassignment: [[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.
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
62 +==== MeasureResult ====
81 81  
82 -(% class="wikigeneratedid" %)
83 83  
84 -
85 -=== LabAssignmentStatus ===
86 -
87 87  |**Attribute Name**|**Description**
88 88  |(((
89 -**statusType **GenericName
67 +**numericValue** Measure
68 +)))|Numeric Value - the numerical value of the observation. When no unit for the measurement is known, the unit 'Dimensionless' should be used.
69 +|(((
70 +**valueProcessingMethod** GenericName
90 90  )))|(((
91 -The status of the lab assignment.
72 +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.
74 +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: [[Labassignment Status>>https://codes.sikb.nl/tablet/domain-table-details/5c6ab373-693e-4039-af8d-93206ce4ebb4]]
76 +Domain table: Value Processing Method
97 97  )))
98 98  |(((
99 -**dateExpected **DateTime
79 +**qualityIndicatorType** GenericName
100 100  )))|(((
101 -The date the results can be expected, in case of conceptual results.
81 +Quality Indicator/Judgement -> Detection limit, etc.
102 102  
103 -If final, fill with datetime.now.
83 +Domain table: Quality Judgement
104 104  )))
105 105  
106 -=== LabAssignmentCertificate ===
86 +==== Accuracy ====
107 107  
108 -|**Attribute Name**|**Description**
88 +
89 +|**Attribute Name**|**Description**|**Unit**
109 109  |(((
110 -**labCertificateNumber **CharacterString
111 -)))|The number of the certificate that will be send to the user/client, and what is used in the PDF file as order or report number of the laboratory.
112 -|(((
113 -**certification **GenericName
91 +**recovery** Float
114 114  )))|(((
115 -Under which certificate the analyses has been done. If you do not find you code leave this field empty
116 -
117 -Domain table: [[Certification Coding>>https://codes.sikb.nl/tablet/domain-table-details/df7ffd7c-192c-44f7-ae9f-0461d9266b30]]
118 -)))
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**
93 +The part (percentage) of material that is recovered in an analysis.
94 +)))|Percentage [%]
134 134  |(((
135 -**identification** NEN3610ID
136 -)))|The unique identifier of the Project in TerraIndex and in the whole Exchange Chain, as send in the labassignment
96 +**spread** Float
97 +)))|Spread = the error measured (in %) in multiple repeated measurements of the same sample/situation (and by the same laboratory technician/measuring device).|Percentage [%]
137 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
99 +**measurementUncertainty** Float
100 +)))|Measurement uncertainty = the total error in the analysis (in %), considering sample collection, variation in measuring equipment/lab technician, and repeated measurements. It practically represents the value indicating the uncertainty of the measurement result.|Percentage [%]
142 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]]
156 -)))
157 -
158 -|**Attribute**|**Notes**
102 +**zScore** Float
103 +)))|This is an optional value that indicates how the measurement value scores in relation to other techniques or laboratories. This could be from interlaboratory comparisons or comparisons between different measuring equipment.|
159 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
105 +**drift** Float
106 +)))|This is the degree of sensor drift over time (in %/year). Sensors will age over time and experience more or less drift depending on the conditions. This drift can be quantified and depends partly on age. This is especially true for online sensors.|Percentage [%]
164 164  
165 - [0..1]
166 -)))|Name given to the sample
167 -|(((
168 -**specimenType** GenericName
108 +==== ====
169 169  
170 - [0..1]
171 -)))|(((
172 -Type of Sample- Fieldsample, Analysissample
110 +==== ====
173 173  
174 -For analysissamples fill with value '10'.
112 +==== ====
175 175  
176 -Domaintable: [[MonsterType / SampleType>>url:https://codes.sikb.nl/tablet/domain-table-details/9f956093-baad-4adb-b74d-20c00cef6ab4]]
177 -)))
178 -|(((
179 -**materialClass** GenericName
114 +==== AnalyticResult ====
180 180  
181 -
182 -)))|(((
183 -An SIKB code for the matrix type. Soil, Groundwater etc..
184 184  
185 -Domaintable: [[Compartiment / Matrix>>url:https://codes.sikb.nl/tablet/domain-table-details/6134f3bb-6048-431d-a130-01290d84172c]]
186 -)))
117 +The analyzed result of an observation, typically originating from a laboratory.
187 187  
188 -== Analysis ==
189 189  
190 -The measured parameter with it's value and process.
191 -
192 -|**Attribute Name**|**Description**
120 +|=**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 -**numericValue** Measure
218 -)))|(((
219 -Numeric Value - the numerical value of the observation. When no unit for the measurement is known, the unit 'Dimensionless' should be used.
220 -
221 -Domaintable for Units: [[Eenheid>>https://codes.sikb.nl/tablet/domain-table-details/04f4f467-021b-4218-baa8-9742ed977c61]]
222 -)))
223 -|(((
224 -**valueProcessingMethod** GenericName
225 -)))|(((
226 -Value Processing Method - a mathematical/statistical operation that is applied while the method of value determination/analysis standard remains unchanged.
227 -
228 -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.
229 -\\Default the value '5' meaning 'Not available' can and should be used, besides leaving it empty.
230 -
231 -Domain table: [[Value Processing Method>>https://codes.sikb.nl/tablet/domain-table-details/a2310c26-065f-4aec-9440-74892ec77753]]
232 -)))
233 -|(((
234 -**qualityIndicatorType** GenericName
235 -)))|(((
236 -Quality Indicator/Judgement -> Detection limit, etc.
237 -\\Default the value '0' meaning 'Not available' can and should be used, besides leaving it empty.
238 -If there is a detectionlimit/reportinglimit, use: '4', meaning 'determenated with full detection limit'
239 -
240 -Domain table: [[Quality Judgement>>https://codes.sikb.nl/tablet/domain-table-details/1e17d9e6-4e0e-4f88-8fe5-c71f6a7931db]]
241 -)))
242 -
243 -|(((
244 244  **limitSymbol** CharacterString
245 245  )))|(((
246 246  LimietSymbool, allowed values: '&lt;' en '&gt;'.
... ... @@ -254,45 +254,88 @@
254 254  1) as a CData block: <![CDATA[<]]> or <![CDATA[>]]>
255 255  
256 256  2) as HTML code: '&amp; lt;' or '&amp; gt;'
257 -\\Default the value is leaving it empty.
258 -If there is a detectionlimit/reportinglimit, use: '<'
259 259  )))
260 260  |(((
261 261  **alphanumericValue** CharacterString
262 262  )))|Textual value associated with an analysis result
263 263  
264 -==== ====
140 +==== ====
265 265  
266 -==== ====
142 +==== ====
267 267  
268 -(% class="wikigeneratedid" %)
144 +==== ====
269 269  
146 +====
147 + ====
270 270  
271 -(% class="wikigeneratedid" %)
272 -=== AnalysisProcess ===
149 +=== Structure projectgegevens ===
273 273  
274 -The process that has been used to detemine the measured value or result.
151 +(% style="text-align:center" %)
152 +[[image:1637656734277-997.png]]
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.
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.
155 +(% class="table-hover" %)
156 +|(% colspan="1" rowspan="1" %)**Attribute name**|(% colspan="1" rowspan="1" %)**Description**|(% colspan="1" rowspan="1" %)**Unit**
157 +|(% colspan="1" rowspan="1" %)**idopdracht**|(% colspan="1" rowspan="1" %)The TerraIndex id of the lab assignment the result belongs to.|(% colspan="1" rowspan="1" %)-
158 +|(% 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
159 +|(% 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
160 +|(% 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
161 +|(% 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
162 +|(% 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
163 +|(% 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
164 +yyyy-mm-dd
165 +|(% 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
166 +|(% colspan="1" rowspan="1" %)(((
167 +**analysemonsters**
287 287  
288 -Domain table: [[CertificationCode>>https://codes.sikb.nl/tablet/domain-table-details/04be2365-3d05-4903-a53e-edafef7111e8]]
169 +
170 +
171 +)))|(% colspan="1" rowspan="1" %)A table containing all the analysis sample with their corresponding results|(% colspan="1" rowspan="1" %)-
172 +
173 +== Structure analysemonsters ==
174 +
175 +(% style="text-align:center" %)
176 +[[image:1637656914799-534.png]]
177 +
178 +(% class="table-hover" %)
179 +|(% colspan="1" rowspan="1" %)**Attribute name**|(% colspan="1" rowspan="1" %)**Description**|(% colspan="1" rowspan="1" %)**Unit**
180 +|(% 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
181 +|(% 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
182 +|(% 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
183 +|(% 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
184 +|(% 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
185 +|(% colspan="1" rowspan="1" %)**Datumverwacht**|(% colspan="1" rowspan="1" %)The date on which the results for the sample are expected|(% colspan="1" rowspan="1" %)(((
186 +date
187 +
188 +yyyy-mm-dd
289 289  )))
290 -|**valuationMethod **GenericName|(((
291 -The used valuation method to detemine the result.
190 +|(% colspan="1" rowspan="1" %)**Volgorde**|(% colspan="1" rowspan="1" %)Is a unused field in TerraIndex|(% colspan="1" rowspan="1" %)integer
191 +|(% 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]]
193 +== Structure analyseresultaten ==
194 +
195 +(% style="text-align:center" %)
196 +[[image:1637657248973-790.png]]
197 +
198 +(% class="table-hover" %)
199 +|(% colspan="1" rowspan="1" %)**Attribute name**|(% colspan="1" rowspan="1" %)**Description**|(% colspan="1" rowspan="1" %)**Unit**
200 +|(% 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
201 +|(% colspan="1" rowspan="1" %)**meetwaarde**|(% colspan="1" rowspan="1" %)What the measured value is for the analyses|(% colspan="1" rowspan="1" %)float
202 +|(% colspan="1" rowspan="1" %)**meetwaardeomschrijving**|(% colspan="1" rowspan="1" %)Alpha numerical description of the result|(% colspan="1" rowspan="1" %)string
203 +|(% 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
204 +|(% 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
205 +|(% 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
206 +|(% 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" %)(((
207 +date
208 +
209 +yyyy-mm-dd
294 294  )))
211 +|(% colspan="1" rowspan="1" %)**opmerking**|(% colspan="1" rowspan="1" %)A remark for this result|(% colspan="1" rowspan="1" %)string
212 +|(% 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
213 +|(% 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
214 +|(% colspan="1" rowspan="1" %)**datumverwacht**|(% colspan="1" rowspan="1" %)Date on which the analyses results are expected.|(% colspan="1" rowspan="1" %)date
295 295  
216 += =
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.)
256 +*
335 335  
336 336  = SIKB 14 Parameter result combinations =
337 337  

Navigation

TerraIndex
asd