Changes for page 2. TerraIndex Export format - dsFieldProject.xsd
Last modified by Robert Jan Daams on 2025/02/04 11:52
Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. RobinHuisman1 +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 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 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 ... ... @@ -93,13 +93,49 @@ 93 93 94 94 (% class="box infomessage" %) 95 95 ((( 96 -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]] 97 97 ))) 98 98 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 + 99 99 == Changes and updates: == 100 100 112 +**27 augustus 2024:** 101 101 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 102 102 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 + 103 103 |(% 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** 104 104 | 105 105 | ... ... @@ -179,7 +179,7 @@ 179 179 Totaal gewicht monster (kg) 180 180 )))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample 181 181 182 -== Changesand updates:==218 +== == 183 183 184 184 **27-01-2022:** 185 185 ... ... @@ -914,6 +914,8 @@ 914 914 ))) 915 915 916 916 953 + 954 + 917 917 (% class="col-xs-12 col-sm-4" %) 918 918 ((( 919 919 {{box title="**Contents**"}}