<
From version < 22.1 >
edited by Robin Huisman
on 2022/04/21 12:00
To version < 25.3 >
edited by Martijn Spaan
on 2024/08/27 12:57
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RobinHuisman
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 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 -== Changes and 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**"}}
TerraIndex
asd