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" %)**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" %)**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,13 +88,130 @@
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
94		-== Changes and updates: ==
	101	+- DateLastChanged fields containing DateTime values, should be send to the server in +2 Timezone (Amsterdam).
95	95
	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	+
96	96	== Changes and updates: ==
97	97
	112	+**27 augustus 2024:**
	113	+
	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
	121	+
	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	+
	139	+|(% 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**
	140	+|
	141	+|
	142	+|
	143	+|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
	144	+|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
	145	+|BroID| |Field for the BroID at filltertube level|Add|Varchar(50)|tblFilterTubes|BroID
	146	+|Weight fine fraction (kg)| |This concerns the weight of the sieved fraction, which is distinct from the coarse fraction|Add|Float|tblJars|JrWeightFractionFine
	147	+|Determination method of moisture| |Describes how the soil was kept at a safe mositure level to work with asbestos|Add|Codelist|tblLayers|LaFieldworkMoistureMethodCode
	148	+|Type of asbestos containing material| |Describes how the soil was kept at a safe mositure level to work with asbestos|Add|Codelist|tblJars|JrPlateMaterialTypeCode
	149	+|Thickness asbestos containing material (mm)| |Thickness of the plate material in mm, needed to make the distinction of types of plate material|Add|Float|tblJars|JrPlateMaterialThickness
	150	+|Recommended prepump volume|CodeID: 158|Needed to register for french users|Add|Float|tblObservations|METINGCODE 158
	151	+|Tube flushing volume|CodeID: 159|Needed to register for french users|Add|Float|tblObservations|METINGCODE 159
	152	+|Filtertube leaktest| |Wether or not a leaking test was performed on the filtertube (for air sampling)|Add|codelist (Yes / no)|tblFilterTubes|FtLeakingtestCode
	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
	154	+|Grondwaterstand aangetroffen?| |Veld om aan te geven dat de grondwaterstand niet is bereikt bij deze boring|Add|codelist (Yes / no)|tblMeasurementPoints|MpGWSFoundCode
	155	+|Benzene PID|CodeID: 156|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 156
	156	+|Lager explosief gehalte (vol %)|CodeID: 155|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 155
	157	+|Number of soil grabs| |Aantal grepen veld voor partijkeuring|Add|Integer|tblMeasurementpoints|MpGrabNumber
	158	+|Koolstofdioxine/CO2 ppm|(((
	159	+New label
	160	+
	161	+CO2 (ppm)
	162	+)))|CHANGE LABEL|Change|Float|tblObservations|METING CODE: 113
	163	+|Koolstofdioxine/CO2 einde monstername (ppm)|(((
	164	+New label
	165	+
	166	+CO2 (ppm) einde monstername
	167	+)))|CHANGE LABEL|Change|Float|tblObservations|METING CODE: 113
	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
	179	+|Pieces of Asbestos|(((
	180	+new label
	181	+
	182	+english:
	183	+
	184	+Pieces of asbestos-containing material
	185	+
	186	+
	187	+dutch:
	188	+
	189	+Aantal stukjes asbestverdacht materiaal
	190	+
	191	+
	192	+
	193	+)))|Change label to conform norm|Change|Integer |tblJars|JrNoPiecesAsbestos
	194	+|Weight asbestos|(((
	195	+new label
	196	+
	197	+english:
	198	+
	199	+Weight asbestos-containing material
	200	+
	201	+
	202	+dutch:
	203	+
	204	+Gewicht asbestverdacht materiaal
	205	+)))|Change label to conform norm|Change|Float|tblJars|JrWeightAsbestos
	206	+|Weight sample (kg)|(((
	207	+new label
	208	+
	209	+english:
	210	+
	211	+Total sample weight (kg)
	212	+
	213	+dutch:
	214	+
	215	+Totaal gewicht monster (kg)
	216	+)))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample
	217	+
	218	+== ==
	219	+
98	98	**27-01-2022:**
99	99
100	100	|**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
...	...	@@ -828,6 +828,8 @@
828	828	)))
829	829
830	830
	953	+
	954	+
831	831	(% class="col-xs-12 col-sm-4" %)
832	832	(((
833	833	{{box title="**Contents**"}}