Changes for page 2. TerraIndex Export format - dsFieldProject.xsd

Summary

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

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.RichardDyer
	1	+XWiki.Martijn

Content

...	...	@@ -10,9 +10,9 @@
10	10
11	11	**[[Field database description>>attach:20150224 Field Database Description (3).docx]]**
12	12
13		-[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]
	13	+[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]
14	14
15		-[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]]
	15	+[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]]
16	16	)))
17	17	)))
18	18
...	...	@@ -29,6 +29,11 @@
29	29
30	30	Small XML example, full example can be found as an attachment:
31	31
	32	+(% class="box infomessage" %)
	33	+(((
	34	+'dsFieldProject' root tag, is also named: 'VeldData'. This is the same export formatting inside.
	35	+)))
	36	+
32	32	{{code language="XML" layout="LINENUMBERS" width="100%"}}
33	33
34	34	<dsFieldProject
...	...	@@ -88,17 +88,53 @@
88	88
89	89	(% class="box infomessage" %)
90	90	(((
91		-When you need help with detailed mappings, please request help at: service@terraindex.com
	96	+(% class="box infomessage" %)
	97	+(((
	98	+When you need help with detailed mappings, please request help at: [[service@terraindex.com>>mailto:service@terraindex.com]]
92	92	)))
93	93
	101	+- DateLastChanged fields containing DateTime values, should be send to the server in +2 Timezone (Amsterdam).
	102	+
	103	+- ID’s in the XML should be valid internally, as Primary- and Foreign-Keys. Once getting pushed into the database, the database will provice new ID’s.
	104	+
	105	+
	106	+)))
	107	+
	108	+== ==
	109	+
94	94	== Changes and updates: ==
95	95
	112	+**27 augustus 2024:**
96	96
	114	+|(% rowspan="4" %)**Labeltext in English**|(% rowspan="4" %)**Remarks**|(% rowspan="4" %)**Definition and process how this field will be used and when it will be filled.**|(% rowspan="4" %)**Change/Add/Delete**|(% rowspan="4" %)**DB Type (String (length) / Float / Lookupvalue / Integer / DateTime)**|(% rowspan="4" %)**DBTable in dsFieldProject**|(% rowspan="4" %)**DBFieldname in dsFieldProject**
	115	+|
	116	+|
	117	+|
	118	+|BRO-ID| |The BRO-ID of the project. Used for specific deliveries to the BRO-loket after the project has been officially registered within the BRO.|Add|Varchar(50)|tblProjects|BroId
	119	+|Report date| |The reporting date of this project towards the 'Bronhouder'. Used for specific deliveries to the BRO-loket, keep in mind this is the date the BRO will check 'Bronhouders' for their legal tasks.|Add|datetime|tblProjects|ReportDate
	120	+|BRO Bronhouder objectId| |The objectId for the 'Bronhouder' to find this project in the BRO Portal.|Add|Varchar(200)|tblProjects|BroAccountableParty
97	97
	122	+**27 juli 2022:**
	123	+
	124	+Nieuwe database unieke GUIDs toegevoegd, die in Streamline als ID gaan gelden.
	125	+
	126	+
	127	+|dsFieldProject.tblAnalysisSamplesDataTable.AnStreamlineGUID
	128	+|dsFieldProject.tblLabassignmentsDataTable.LbStreamlineGUID
	129	+|dsFieldProject.tblAnalysisRequestsDataTable.ArStreamlineGUID
	130	+|dsFieldProject.tblAnalysisResultsDataTable.AsStreamlineGUID
	131	+|dsFieldProject.tblAssessmentPropertiesDataTable.ApStreamlineGUID
	132	+|dsFieldProject.tblAssessmentResultsDataTable.ArStreamlineGUID
	133	+|dsFieldProject.tblAssessmentResultStandards.ArsStreamlineGUID
	134	+|dsFieldProject.tblWaterSamples.AnStreamlineGUID
	135	+|dsFieldProject.tblConcernedCompanies.CcStreamlineGUID
	136	+
	137	+**14 maart 2022:**
	138	+
98	98	|(% rowspan="4" %)**Labeltext in English**|(% rowspan="4" %)**Remarks**|(% rowspan="4" %)**Definition and process how this field will be used and when it will be filled.**|(% rowspan="4" %)**Change/Add/Delete**|(% rowspan="4" %)**DB Type (String (length) / Float / Lookupvalue / Integer / DateTime)**|(% rowspan="4" %)**DBTable in dsFieldProject**|(% rowspan="4" %)**DBFieldname in dsFieldProject**
99		-|
100		-|
101		-|
	140	+|
	141	+|
	142	+|
102	102	|Smoketube test|CodeID: 157|A test done to determine wether no air is escaping the suction system of the filtration unit. This is important because if this is the case, dangerous gases might escape and affect the health of people nearby|Add|Lookupvalue|tblObservations|METINGCODE 157
103	103	|Discontinuity cause| |This describes the cause of a discontinuity among rock layers for a rock classification. This is not a description of the discontinuity, merely how it came to exist|Add|Lookupvalue|tblLayers|LaDiscontinuityCauseCode
104	104	|BroID| |Field for the BroID at filltertube level|Add|Varchar(50)|tblFilterTubes|BroID
...	...	@@ -109,9 +109,9 @@
109	109	|Recommended prepump volume|CodeID: 158|Needed to register for french users|Add|Float|tblObservations|METINGCODE 158
110	110	|Tube flushing volume|CodeID: 159|Needed to register for french users|Add|Float|tblObservations|METINGCODE 159
111	111	|Filtertube leaktest| |Wether or not a leaking test was performed on the filtertube (for air sampling)|Add|codelist (Yes / no)|tblFilterTubes|FtLeakingtestCode
112		-|Precense of water|CodeID: 160|Check to see whetherthe tube is dry when sampling an air sample|Add|codelist (Yes / no)|tblObservations|METINGCODE 160
	153	+|Presence of water|CodeID: 160|Check to see whetherthe tube is dry when sampling an air sample|Add|codelist (Yes / no)|tblObservations|METINGCODE 160
113	113	|Grondwaterstand aangetroffen?| |Veld om aan te geven dat de grondwaterstand niet is bereikt bij deze boring|Add|codelist (Yes / no)|tblMeasurementPoints|MpGWSFoundCode
114		-|Benzeen PID |CodeID: 156|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 156
	155	+|Benzene PID|CodeID: 156|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 156
115	115	|Lager explosief gehalte (vol %)|CodeID: 155|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 155
116	116	|Number of soil grabs| |Aantal grepen veld voor partijkeuring|Add|Integer|tblMeasurementpoints|MpGrabNumber
117	117	|Koolstofdioxine/CO2 ppm|(((
...	...	@@ -124,7 +124,17 @@
124	124
125	125	CO2 (ppm) einde monstername
126	126	)))|CHANGE LABEL|Change|Float|tblObservations|METING CODE: 113
127		-|Weight debris (kg)| |Change label to conform norm|Change|Float|tblJars|JrWeightDebris
	168	+|Weight debris (kg)|(((
	169	+new label
	170	+
	171	+english:
	172	+
	173	+Weight coarse fraction (kg)
	174	+
	175	+dutch:
	176	+
	177	+Gewicht grove fractie (kg)
	178	+)))|Change label to conform norm|Change|Float|tblJars|JrWeightDebris
128	128	|Pieces of Asbestos|(((
129	129	new label
130	130
...	...	@@ -157,14 +157,14 @@
157	157
158	158	english:
159	159
160		-Weight coarse fraction (kg)
	211	+Total sample weight (kg)
161	161
162	162	dutch:
163	163
164		-Gewicht grove fractie (kg)
	215	+Totaal gewicht monster (kg)
165	165	)))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample
166	166
167		-== Changes and updates: ==
	218	+== ==
168	168
169	169	**27-01-2022:**
170	170
...	...	@@ -899,6 +899,8 @@
899	899	)))
900	900
901	901
	953	+
	954	+
902	902	(% class="col-xs-12 col-sm-4" %)
903	903	(((
904	904	{{box title="**Contents**"}}