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
Change comment: There is no comment for this version
To version 38.1
edited by Robin Huisman
on 2024/08/01 00:13
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/]] **
... ... @@ -51,51 +51,169 @@
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 +(% class="wikigeneratedid" %)
83 +
84 +
85 +=== LabAssignmentStatus ===
86 +
87 +|**Attribute Name**|**Description**
88 +|(((
89 +**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.
91 +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.
93 +Use the value '5' for final reported results.
94 +Use other values, or '4', for conceptual values.
73 73  
74 -Domain table: Value Processing Method
96 +Domain table: [[Labassignment Status>>https://codes.sikb.nl/tablet/domain-table-details/5c6ab373-693e-4039-af8d-93206ce4ebb4]]
75 75  )))
98 +|(((
99 +**dateExpected **DateTime
100 +)))|(((
101 +The date the results can be expected, in case of conceptual results.
76 76  
103 +If final, fill with datetime.now.
104 +)))
105 +
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.
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.
83 83  |(((
84 -**valueProcessingMethod** GenericName
113 +**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.
115 +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.
117 +Domain table: [[Certification Coding>>https://codes.sikb.nl/tablet/domain-table-details/df7ffd7c-192c-44f7-ae9f-0461d9266b30]]
118 +)))
89 89  
90 -Domain table: Value Processing Method
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]]
91 91  )))
92 92  
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
93 93  
94 -==== AnalyticResult (inherited from MeasureResult ====
165 + [0..1]
166 +)))|Name given to the sample
167 +|(((
168 +**specimenType** GenericName
95 95  
170 + [0..1]
171 +)))|(((
172 +Type of Sample- Fieldsample, Analysissample
96 96  
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 +
97 97  |**Attribute Name**|**Description**
98 98  |(((
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 +|(((
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,75 +143,38 @@
143 143  **alphanumericValue** CharacterString
144 144  )))|Textual value associated with an analysis result
145 145  
146 -==== ====
264 +==== ====
147 147  
148 -==== ====
266 +==== ====
149 149  
150 -=== Structure projectgegevens ===
268 +(% class="wikigeneratedid" %)
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**
271 +(% class="wikigeneratedid" %)
272 +=== AnalysisProcess ===
166 166  
274 +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" %)-
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.
170 170  
171 -== Structure analysemonsters ==
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.
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
288 +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" %)-
290 +|**valuationMethod **GenericName|(((
291 +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
293 +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 215  
216 216  = What to exchange to bind the right results to the right sample? =
217 217  
... ... @@ -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