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

Summary

Details

Page properties
Content
... ... @@ -1,4 +1,4 @@
1 -= Exporting lab results to TerraIndex for a customer =
1 += Reporting 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,51 +51,167 @@
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:
54 +With 3 differences/additions:
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
60 60  
61 -=== Status ===
69 +
70 +)))|(((
71 +Code of the laboratory to which the assignment is assigned.
62 62  
63 -|**Attribute Name**|**Description**
73 +Domaintable: [[Meetinstantie / Measuring Company>>url:https://codes.sikb.nl/tablet/domain-table-details/4e270f0a-cefe-446e-9d4d-6666c91180a8]]
74 +)))
64 64  |(((
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.
76 +**startTime** DateTime
77 +)))|Dispatch date of the lab assignment
67 67  |(((
68 -**valueProcessingMethod** GenericName
79 +**customerCode** CharacterString
80 +)))|Client code or debtor number of the client as known by the laboratory
81 +
82 +
83 +
84 +=== LabAssignmentStatus ===
85 +
86 +|**Attribute Name**|**Description**
87 +|(((
88 +**statusType **GenericName
69 69  )))|(((
70 -Value Processing Method - a mathematical/statistical operation that is applied while the method of value determination/analysis standard remains unchanged.
90 +The status of the lab assignment.
71 71  
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.
92 +Use the value '5' for final reported results.
93 +Use other values, or '4', for conceptual values.
73 73  
74 -Domain table: Value Processing Method
95 +Domain table: [[Labassignment Status>>https://codes.sikb.nl/tablet/domain-table-details/5c6ab373-693e-4039-af8d-93206ce4ebb4]]
75 75  )))
97 +|(((
98 +**dateExpected **DateTime
99 +)))|(((
100 +The date the results can be expected, in case of conceptual results.
76 76  
102 +If final, fill with datetime.now.
103 +)))
104 +
77 77  === LabAssignmentCertificate ===
78 78  
79 79  |**Attribute Name**|**Description**
80 80  |(((
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.
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.
83 83  |(((
84 -**valueProcessingMethod** GenericName
112 +**certification **GenericName
85 85  )))|(((
86 -Value Processing Method - a mathematical/statistical operation that is applied while the method of value determination/analysis standard remains unchanged.
114 +Under which certificate the analyses has been done. If you do not find you code leave this field empty
87 87  
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.
116 +Domain table: [[Certification Coding>>https://codes.sikb.nl/tablet/domain-table-details/df7ffd7c-192c-44f7-ae9f-0461d9266b30]]
117 +)))
89 89  
90 -Domain table: Value Processing Method
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]]
91 91  )))
92 92  
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
93 93  
94 -==== AnalyticResult (inherited from MeasureResult ====
164 + [0..1]
165 +)))|Name given to the sample
166 +|(((
167 +**specimenType** GenericName
95 95  
169 + [0..1]
170 +)))|(((
171 +Type of Sample- Fieldsample, Analysissample
96 96  
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 +
97 97  |**Attribute Name**|**Description**
98 98  |(((
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 +|(((
99 99  **numericValue** Measure
100 100  )))|(((
101 101  Numeric Value - the numerical value of the observation. When no unit for the measurement is known, the unit 'Dimensionless' should be used.
... ... @@ -143,76 +143,36 @@
143 143  **alphanumericValue** CharacterString
144 144  )))|Textual value associated with an analysis result
145 145  
146 -==== ====
262 +==== ====
147 147  
148 -==== ====
264 +==== ====
149 149  
150 -=== Structure projectgegevens ===
151 151  
152 152  
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**
268 +=== AnalysisProcess ===
166 166  
270 +The process that has been used to detemine the measured value or result.
167 167  
168 -
169 -)))|(% colspan="1" rowspan="1" %)A table containing all the analysis sample with their corresponding results|(% colspan="1" rowspan="1" %)-
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.
170 170  
171 -== Structure analysemonsters ==
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.
172 172  
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
284 +Domain table: [[CertificationCode>>https://codes.sikb.nl/tablet/domain-table-details/04be2365-3d05-4903-a53e-edafef7111e8]]
187 187  )))
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" %)-
286 +|**valuationMethod **GenericName|(((
287 +The used valuation method to detemine the result.
190 190  
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
289 +Domain table: [[ValuationMethod>>https://codes.sikb.nl/tablet/domain-table-details/04be2365-3d05-4903-a53e-edafef7111e8]]
208 208  )))
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
213 213  
214 -= =
215 -
216 216  = What to exchange to bind the right results to the right sample? =
217 217  
218 218  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.
... ... @@ -251,7 +251,6 @@
251 251  * If an Analysis Sample is found, the Analysis Results are always updated or added.
252 252  * If Project is found, but the analysis sample is not; then this analysis sample is imported as a new analysis sample with all results.
253 253  * (If it concerns water samples, a new fictional/temporary measuring point and filter could be created.)
254 -*
255 255  
256 256  = SIKB 14 Parameter result combinations =
257 257  

Navigation

TerraIndex
asd