<
From version < 22.1 >
edited by Robin Huisman
on 2022/04/21 12:00
To version < 25.2 >
edited by Martijn Spaan
on 2024/08/27 11:44
>
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 +|BroId| |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|Varchar(50)|tblProjects|BroId
119 +|ReportDate| |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|datetime|tblProjects|ReportDate
120 +|BroAccountableParty| |Field for the BroID at filltertube level|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