Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -1,191 +1,5 @@
1	1	== Changes and updates: ==
2	2
3		-**05-04-2023**
4		-
5		-(% class="table-hover" %)
6		-|**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
7		-**Change/Add/**
8		-
9		-**Delete**
10		-)))|**DB Type
11		-(String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
12		-|HDOP| |Precision value for the GPS coordinates.|Add|Float|tblMeasurementPoints|(((
13		-MpHDOP
14		-)))
15		-|VDOP| |Precision value for the GPS coordinates.|Add|Float|tblMeasurementPoints|(((
16		-MpVDOP
17		-)))
18		-|PDOP| |Precision value for the GPS coordinates.|Add|Float|tblMeasurementPoints|(((
19		-MpPDOP
20		-)))
21		-|Number of satellites used| |Field to note the amount of sattelites that where used for the GPS measurement in this measurement point.|Add|Integer|tblMeasurementPoints|(((
22		-MpNumberOfSatellites
23		-)))
24		-|HRMS| |Precision value for the GPS coordinates.|Add|Float|tblMeasurementPoints|(((
25		-MpHRMS
26		-)))
27		-|VRMS| |Precision value for the GPS coordinates.|Add|Float|tblMeasurementPoints|(((
28		-MpVRMS
29		-)))
30		-|(((
31		-Gps pole height (m)
32		-)))| |(((
33		-Field to fill in the height of the GPS pole
34		-)))|Add|Float|tblMeasurementPoints|(((
35		-MpGPSPoleHeight
36		-)))
37		-|(((
38		-Antenna height (cm)
39		-)))| |(((
40		-Field to fill in the height of the antenna on the GPS machine
41		-)))|Add|Float|tblMeasurementPoints|(((
42		-MpAntennaHeight
43		-)))
44		-|Weather conditions| |(((
45		-Field to fill in the weather conditions during the drilling process
46		-)))|Add|Float|tblMeasurementPoints|MPWeatherConditions
47		-|Ambient temperature (°C) | |(((
48		-Outside temperature during the drilling process
49		-)))|Add|Float|tblMeasurementPoints|(((
50		-MpAmbientTemperature
51		-)))
52		-|(((
53		-CO (ppm)
54		-)))| |(((
55		-Field to save the measurement of carbon monoxide in the layer
56		-)))|Add|Float|tblLayers|LaCO
57		-|(((
58		-Oxygen ~(%)
59		-)))| |(((
60		-Field to save the measurement of oxygen in the layer
61		-)))|Add|Float|tblLayers|(((
62		-LaOxygenPercentage
63		-)))
64		-|(((
65		-H2S (ppm)
66		-)))| |Field to save the measurement of hydrogen sulfide in the layer|Add|Float|tblLayers|(((
67		-LaH2S
68		-)))
69		-|(((
70		-LEL ~(%)
71		-)))| |(((
72		-Field the save the lower explosive level measurement in the layer
73		-)))|Add|Float|tblLayers|(((
74		-LaLEL
75		-)))
76		-|Inspectie efficiency ~(%)| |The amount of soil in the layer that was able to be inspected properly for the purpose of asbestos research.|Add|Float|tblLayers|(((
77		-LaInspectionEfficiencyPercentage
78		-)))
79		-|Mixing of soil| |(((
80		-Field to denote the amount of mixing in this soil layer
81		-)))|Add|Integer (codelist 291)|tblLayers|(((
82		-LaDegreeOfSoilMixingCode
83		-)))
84		-|(((
85		-CO (ppm)
86		-)))| |(((
87		-Field to save the measurement of carbon monoxide in the air sample
88		-)))|Add|Float|tblObservations|METINGCODE 161
89		-|Jar type| |Soil sample ring added to the codelist|Add codelist value| | |
90		-
91		-**25-11-2022:**
92		-
93		-(% class="table-hover" %)
94		-|**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
95		-**Change/Add/**
96		-
97		-**Delete**
98		-)))|**DB Type
99		-(String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
100		-|Status| |(((
101		-This field is for planned measurement points, and can be used to determine the status (to be done, done, removed etc)
102		-)))|Add|Lookup value (codelist 289)|tblMeasurementPoints|(((
103		-MpStatusCode
104		-)))
105		-|(((
106		-Penetrometer compaction strength (kg/cm2)
107		-)))| |(((
108		-This field is a numeric field for field tests to determine the compaction strength of the soil
109		-)))|Add|numberfield|tblMeasurementPoints|MpPenetrometerCompaction
110		-|(((
111		-Accreditation number
112		-)))| |(((
113		-This field can be used to fill in the accreditation number of the fieldworker, which needs to be filled in by walloon customers
114		-)))|Add|text field (30)|tblMeasurementPoints|(((
115		-MpAccreditationNumber
116		-)))
117		-|Moisture Class Soil| |(((
118		-This field is for giving moisture classes in soil, these are present in the NEN 6693 and also used for french research.
119		-)))|Add|Lookup value (codelist 290)|tblLayers|(((
120		-LaMoistureClass
121		-)))
122		-|Sediment Sump Length (cm)| |(((
123		-Field to input the length within the tube that is used as a sand / silt catchment below the filter
124		-)))|Add|numberfield|tblFilterTubes|FtSedimentSumpLength
125		-|Length / Width|Multi edit turned on in grid vierw| |Change|numberfield|tblMeasurementPoints|(((
126		-MpTrialPitLength & MpTrialPitWidth
127		-)))
128		-|Length / Width|Multi edit turned on in grid vierw| |Change|numberfield|tblLayers|(((
129		-LaTrialPitLength & LaTrialPitWidth
130		-)))
131		-|Initial function| |(((
132		-Field to input the function of the filtertube when it was installed
133		-)))|Add|Lookup value (codelist 288)|tblFilterTubes|FtInitialFiltertubeFunction
134		-|Weather conditions| |(((
135		-Remarkable weather conditions can be noted here as part of a location inspection
136		-)))|Add|String|tblSublocations|(((
137		-SlCoverRatePostRemoval
138		-)))
139		-|Sampling procedure| |Field to fill in the used sampling procedure|Add|Lookup value (codelist 287)|tblWatersamples|WsSamplingProcedure
140		-|Starttime & Endtime sampling|Already existed for airsamples, no as well for watersamples| |Change|Datetime|tblWatersamples|(((
141		-WsStartSampleTime & WsPostSampleTime
142		-)))
143		-|Radioactive ionisation (cps)| |(((
144		-Numberfield to input the cps (counts per second) of a meter that reacts to ionisation (like a geiger counter)
145		-)))|Add|numberfield|tblJars|(((
146		-JrIonisationCount
147		-)))
148		-|Sample water content ~(%)| |(((
149		-Percentage field for sample humidity
150		-)))|Add|numberfield|tblJars|JrHumidityPercentage
151		-|(((
152		-Volume weight dry Yd (Kn/M3)
153		-)))| |(((
154		-Geotechnical field for the dry weight of the sample, different unit than the other weight sample fields which are more simplistic
155		-)))|Add|numberfield|tblJars|JrDryVolumeWeight
156		-|Liquit limit water content ~(%)| |The liquid limit used within the attenbergs limits|Add|numberfield|tblJars|JrLiquidLimit
157		-|Plasticity index ~(%)| |(((
158		-Geotechnical field for the plasticity index
159		-)))|Add|numberfield|tblJars|JrPlasticityIndex
160		-|(((
161		-Semi-Solid limit (water content %)
162		-)))| |The semi-solid limit used within the attenbergs limits|Add|numberfield|tblJars|JrSemiSolidLimit
163		-|(((
164		-Plastic limit (water content %)
165		-)))| |The plastic limit used within the attenbergs limits|Add|numberfield|tblJars|JrPlasticLimit
166		-|(((
167		-Undrained shear strength (kPa)
168		-)))| |The shear strength of the soil|Add|numberfield|tblJars|JrUndrainedShearStrength
169		-|Void ratio ~(%)| |The ratio of void (air) in the soil|Add|numberfield|tblJars|JrVoidRatio
170		-|Saturation ~(%)| |The percentage of moisture saturation in the soil|Add|numberfield|tblJars|JrSaturationPercentage
171		-|Soil sampes (several fields)|Multi edit turned on| |Change| |tblJars|Several
172		-|Destination Type| |Field for destination type for the OVAM|Add|Lookup value (codelist 49)|tblProjects|PrDestinationType
173		-|Groundwater vulnerability| |Field for groundwater vulnerability for the OVAM|Add|Lookup value (codelist 92)|tblProjects|PrGroundwaterVulnerability
174		-|Percentage Fractrion >20mm| |Asbestos fields now als on layer level|Add|numberfield|tblLayers|LaCourseFractionPercentage
175		-|Weight fraction >20 mm| |Asbestos fields now als on layer level|Add|numberfield|tblLayers|LaCourseFractionWeight
176		-|Weight fraction <20 mm| |Asbestos fields now als on layer level|Add|numberfield|tblLayers|LaFineFractionWeight
177		-|Type plate material| |Asbestos fields now als on layer level|Add|Lookup value (281)|tblLayers|LaPlateMaterialTypeCode
178		-|Number of pieces plate material| |Asbestos fields now als on layer level|Add|numberfield|tbLLayers|LaPlateMaterialPieces
179		-|Weight plate material (g)| |Asbestos fields now als on layer level|Add|numberfield|tblLayers|LaPlateMaterialWeight
180		-|Special component gradation|Add codelist "A little (bit of)"| |Add Codelist value| | |
181		-|Sand sorting codes|Add extra sand and gravel sorting codes| |Add Codelist value| | |
182		-|Geological interpretation|All new belgium geological interpretation options added| |Add Codelist value| | |
183		-|End prepump citeria|New prepump ending condition added| |Add Codelist value| | |
184		-|Finishing Type|Type 'Asfalt' added| |Add Codelist value| | |
185		-|Project Type|New French Project types added| |Add Codelist value| | |
186		-|Colour Type|Colour 'Pink' added| |Add Codelist value| | |
187		-|Use of location|Additional location uses added| |Add Codelist value| | |
188		-
189	189	**03-08-2022:**
190	190
191	191	(% class="table-hover" %)
...	...	@@ -196,7 +196,7 @@
196	196	)))|**DB Type
197	197	(String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
198	198	|Special or invasive vegetation(1, 2, 3)| |Field to note invasive species found on the release location. New codelist with species from the dutch invasive species list added.|Add|Lookup value (codelist 285)|tblSublocations|(((
199		-SlSpecialVegetationCode
	13	+SlVegetationCode
200	200	)))
201	201	|Sieved material inspection hole| |Field to note the total amount of sieved material at the measurementpoint level of an asbestos inspection hole|Add|Float|tblMeasurementPoints|MpSievedMaterial
202	202	|Water depth (cm-gl)| |Field to describe the column of water above the waterbed, if chosen not to add a water layer as the first layer.|Add|Float|tblMeasurementPoints|MpWaterDepth
...	...	@@ -204,20 +204,19 @@
204	204	|Suspected Asbestos pollution| |Field by which a fieldworker can remark if a layer is suspect of containing asbestos|Add|Lookup value (codelist 73)|tblLayers|LaSuspectedAsbestosCode
205	205	|Measurement point type|New codelist options added|Canister, Ambient air measurement added|Change|Lookup value (codelist 24)|tblMeasurementpoints|MpTypeCode
206	206	|Reference plane|New codelist options added|Sea level added|Change|Lookup value (codelist 15)|tblMeasurementpoints|MpReferencePointTypeCode
207		-|Finishing Type|New codelist options added|Surface box plasic, Surface box stainless steel added|Change|Lookup value (codelist 32)|tblFinishings|FiTypeCode
208		-|Horizon|New codelist options added|Unit R0, Unit R1, Unit R2 added|Change|Lookup value (codelist 109)|tblLayers|LaHorizonCode
209		-|Soil / Rock Type|New codelist options added|Granodiorite added|Change|Lookup value (codelist 163 and 35)|tblLayers|LaRockTypeCode
210		-|Special component type|New codelist options added|(((
211		-Construction and demolition waste, Calcium nodules, calcium crusts, Stones >50MM added
212		-)))|Change|Lookup value (codelist 11)|tblLayers|LaSc1TypeCode
213		-|Drilling System|New codelist options added|Tubed edelman, tubed pulse drill, tubed percussion gouge added|Change|Lookup value (codelist 23)|tblLayers|LaDrillingSystemTypeCode
214		-|Clarity|New codelist options added|None, Low, medium, high clarity codes added|Change|Lookup value (codelist 252)|tblWatersamples|LaClarityCode
215		-|Stop prepumping|New codelist options added|1x volume of drilling well + parameters stabilisation added|Change|Lookup value (codelist 200)|tblWatersamples|WsPrepumpingEndedTypeCode
216		-|Sampling method|New codelist options added|multi support active sampling|Change|Lookup value (codelist 259)|tblWatersamples|WsSamplingMethodCode
217		-|Placed in serie|New codelist options added|New codelist: Unique, in paralel, in series added|Change|Lookup value (codelist 284)|WsPackagings|BoPlacedInSerie
218		-|Air sample Type|New codelist options added|Impregnated filter added|Change|Lookup value (codelist 272)|WsPackagings|BoSampleTypeCode
219		-|Field matrix|New codelist options added|Waterbed (solid part) added|Change|Lookup value (codelist 6)|WsAnalysisSamples|MatrixTypeCode
	21	+|Finishing Type|New codelist options added| |Change|Lookup value (codelist 32)|tblFinishings|FiTypeCode
	22	+|Horizon|New codelist options added| |Change|Lookup value (codelist 109)|tblLayers|LaHorizonCode
	23	+|Soil / Rock Type|New codelist options added| |Change|Lookup value (codelist 163 and 35)|tblLayers|LaRockTypeCode
	24	+|Special component type|New codelist options added| |Change|Lookup value (codelist 11)|tblLayers|LaSc1TypeCode
	25	+|Drilling System|New codelist options added| |Change|Lookup value (codelist 23)|tblLayers|LaDrillingSystemTypeCode
	26	+|Clarity|New codelist options added| |Change|Lookup value (codelist 252)|tblWatersamples|LaClarityCode
	27	+|Stop prepumping|New codelist options added| |Change|Lookup value (codelist 200)|tblWatersamples|WsPrepumpingEndedTypeCode
	28	+|Sampling method|New codelist options added| |Change|Lookup value (codelist 259)|tblWatersamples|WsSamplingMethodCode
	29	+|Placed in serie|New codelist options added| |Change|Lookup value (codelist 284)|WsPackagings|BoPlacedInSerie
	30	+|Air sample Type|New codelist options added| |Change|Lookup value (codelist 272)|WsPackagings|BoSampleTypeCode
	31	+|Field matrix|New codelist options added| |Change|Lookup value (codelist 6)|WsAnalysisSamples|MatrixTypeCode
220	220
	33	+
221	221	**27-01-2022:**
222	222
223	223	(% class="table-hover" %)
...	...	@@ -242,6 +242,7 @@
242	242	|Measurement duration| |Field for the duration of a series of a measurements, mostly used to estimate the time when a tube is dry|Add|Float|tblObservations|METINGCODE 154 (Series), METINGCODE 153 (Stable value)
243	243	|Pumped volume series| |Field for the total pumped volume during a single series|Add|Float|tblObservations|METINGCODE 152 (Series), METINGCODE 151 (Stable value)
244	244
	58	+
245	245	**22-11-2021:**
246	246
247	247	|**Screen to add the extra field**|**Labeltext of field in English**|**Labeltext in Dutch**|**Examples of values and how it should be printed in a report.**|**Definition and process how this field will be used and when it will be filled.**|**Codelist CategoryID**|**Change/Add/Delete**|**DB Type**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**