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

Summary

Details

Page properties
Content
... ... @@ -1,4 +1,4 @@
1 -= Reporting lab results to TerraIndex for a customer =
1 += Exporting lab results to TerraIndex for a customer =
2 2  
3 3  Returning the labresults to the client, that requested the analysis on samples.
4 4  
... ... @@ -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,167 +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 -
83 -
84 -=== LabAssignmentStatus ===
85 -
86 86  |**Attribute Name**|**Description**
87 87  |(((
88 -**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
89 89  )))|(((
90 -The status of the lab assignment.
70 +Value Processing Method - a mathematical/statistical operation that is applied while the method of value determination/analysis standard remains unchanged.
91 91  
92 -Use the value '5' for final reported results.
93 -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.
94 94  
95 -Domain table: [[Labassignment Status>>https://codes.sikb.nl/tablet/domain-table-details/5c6ab373-693e-4039-af8d-93206ce4ebb4]]
74 +Domain table: Value Processing Method
96 96  )))
97 -|(((
98 -**dateExpected **DateTime
99 -)))|(((
100 -The date the results can be expected, in case of conceptual results.
101 101  
102 -If final, fill with datetime.now.
103 -)))
104 -
105 105  === LabAssignmentCertificate ===
106 106  
107 107  |**Attribute Name**|**Description**
108 108  |(((
109 -**labCertificateNumber **CharacterString
110 -)))|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.
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.
111 111  |(((
112 -**certification **GenericName
84 +**valueProcessingMethod** GenericName
113 113  )))|(((
114 -Under which certificate the analyses has been done. If you do not find you code leave this field empty
86 +Value Processing Method - a mathematical/statistical operation that is applied while the method of value determination/analysis standard remains unchanged.
115 115  
116 -Domain table: [[Certification Coding>>https://codes.sikb.nl/tablet/domain-table-details/df7ffd7c-192c-44f7-ae9f-0461d9266b30]]
117 -)))
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.
118 118  
119 -== LabAssignmentRequest ==
120 -
121 -The connection between the labassignment and the samples with analysisrequests, as send in the labassignment.
122 -
123 -If not retreived in a labassignment, make it yourself so we can import is as new samples.
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 -
126 -
127 -== Project ==
128 -
129 -Activity that leads to the collection of soil data, as send in the labassignment.
130 -It will be used to search the correct project/investiation to bind or create the samples.
131 -
132 -|**Attribute**|**Notes**
133 -|(((
134 -**identification** NEN3610ID
135 -)))|The unique identifier of the Project in TerraIndex and in the whole Exchange Chain, as send in the labassignment
136 -|(((
137 -**name** CharacterString
138 -
139 - [0..1]
140 -)))|The name of the project where the lab results are for, as send in the labassignment
141 -|(((
142 -**projectCode** CharacterString
143 -)))|The project code of the project where the lab results are for, as send in the labassignment
144 -
145 -== Sample (AnalysisSample) ==
146 -
147 -The analysissamples with analysisrequests, as send in the labassignment. The fieldsamples form the labassignment can be skipped in the results file.
148 -
149 -If not retreived in a labassignment, make it yourself so we can import is as new analysissamples.
150 -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/#]]
151 -
152 -(% class="box infomessage" %)
153 -(((
154 -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
155 155  )))
156 156  
157 -|**Attribute**|**Notes**
158 -|(((
159 -**identification** NEN3610ID
160 -)))|The unique identifier of TerraIndex for the analyses sample, to keep this value unique forever in the whole exchange chain.
161 -|(((
162 -**name** CharacterString
163 163  
164 - [0..1]
165 -)))|Name given to the sample
166 -|(((
167 -**specimenType** GenericName
94 +==== AnalyticResult (inherited from MeasureResult ====
168 168  
169 - [0..1]
170 -)))|(((
171 -Type of Sample- Fieldsample, Analysissample
172 172  
173 -For analysissamples fill with value '10'.
174 -
175 -Domaintable: [[MonsterType / SampleType>>url:https://codes.sikb.nl/tablet/domain-table-details/9f956093-baad-4adb-b74d-20c00cef6ab4]]
176 -)))
177 -|(((
178 -**materialClass** GenericName
179 -
180 -
181 -)))|(((
182 -An SIKB code for the matrix type. Soil, Groundwater etc..
183 -
184 -Domaintable: [[Compartiment / Matrix>>url:https://codes.sikb.nl/tablet/domain-table-details/6134f3bb-6048-431d-a130-01290d84172c]]
185 -)))
186 -
187 -== Analysis ==
188 -
189 -The measured parameter with it's value and process.
190 -
191 191  |**Attribute Name**|**Description**
192 192  |(((
193 -**identification** NEN3610ID
194 -)))|The unique identifier of the AnalysisResult, to keep this value unique forever in the whole exchange chain.
195 -If not possible to store this in the Lims, generate on the fly.
196 -(% class="info" %)|(((
197 -**physicalProperty **PhysicalProperty
198 -)))|(((
199 -The combination of Quantity, Parameter and Condition to provide the parameter that has been measured.
200 -**[[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]]**
201 -
202 -
203 -)))
204 -|**result **AnalyticResult|The result of the analysis, see next chapter.
205 -|**procedure **AnalysisProcess|The process that has been used to measure/determine the result, see next chapter.
206 -
207 -
208 -
209 -=== AnalyticResult (inherited from MeasureResult) ===
210 -
211 -The actual reported value, result of detection limit.
212 -
213 -|**Attribute Name**|**Description**
214 -|(((
215 215  **numericValue** Measure
216 216  )))|(((
217 217  Numeric Value - the numerical value of the observation. When no unit for the measurement is known, the unit 'Dimensionless' should be used.
... ... @@ -259,36 +259,76 @@
259 259  **alphanumericValue** CharacterString
260 260  )))|Textual value associated with an analysis result
261 261  
262 -==== ====
146 +==== ====
263 263  
264 -==== ====
148 +==== ====
265 265  
150 +=== Structure projectgegevens ===
266 266  
267 267  
268 -=== 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**
269 269  
270 -The process that has been used to detemine the measured value or result.
271 271  
272 -|**Attribute Name**|**Description**
273 -|(((
274 -**identification** NEN3610ID
275 -)))|The unique identifier of the AnalysisProcess, it can be bound to multiple results at once.
276 -|**analyticalTechnique **GenericName|(((
277 -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" %)-
278 278  
279 -Domain table: [[AnalyticalTechnique>>https://codes.sikb.nl/tablet/domain-table-details/04be2365-3d05-4903-a53e-edafef7111e8]]
280 -)))
281 -|**certification **GenericName|(((
282 -The used certification to detemine the result.
171 +== Structure analysemonsters ==
283 283  
284 -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
285 285  )))
286 -|**valuationMethod **GenericName|(((
287 -The used valuation method to detemine the result.
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" %)-
288 288  
289 -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
290 290  )))
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
291 291  
214 += =
215 +
292 292  = What to exchange to bind the right results to the right 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.
... ... @@ -327,6 +327,7 @@
327 327  * If an Analysis Sample is found, the Analysis Results are always updated or added.
328 328  * If Project is found, but the analysis sample is not; then this analysis sample is imported as a new analysis sample with all results.
329 329  * (If it concerns water samples, a new fictional/temporary measuring point and filter could be created.)
254 +*
330 330  
331 331  = SIKB 14 Parameter result combinations =
332 332  

Navigation

TerraIndex
asd