L TmpV2 table: Difference between revisions

mNo edit summary
Line 1: Line 1:
The '''L_TmpV2''' table contains the data for [[Temporary Studies]] we collect on the PDA and in the [[CCMDB.mdb]].
The '''L_TmpV2''' table contains data on the PDA and in the [[CCMDB.mdb]] that is either intermittent or just not currently accomodated in the rest of the database. When the data collector sends, the data gets dumped to [[Regional Server]]\Output\TmpV2_1.mdb


The table has fields to accomodate dates, integers, reals/floating point variables, text or booleans. It can accomodate one of each of these per line, such that if two variables of the same data type are needed, two lines need to be entered. The table was set up this way to accomodate any possible combination of data, but this flexibility comes at the expense of some inefficiencies in data-entry.
The table has fields to accomodate dates, integers, reals/floating point variables, text or booleans. It can accomodate one of each of these per line, such that if two variables of the same data type are needed, two lines need to be entered. The table was set up this way to accomodate any possible combination of data, but this flexibility comes at the expense of some inefficiencies in data-entry.
For details about the dropdown options for various projects, and their actual project identifier, see the corresponding project's article. For a list of these projects, see  [[:category:L_TmpV2 Data|Category:L_TmpV2 Data]].


==Data Structure==
==Data Structure==
Line 76: Line 78:


|}
|}
== to do before de-stubbing ==
* explain data structure




{{stub}}
{{stub}}
[[Category: Data structure]]
[[Category: Data structure]]
[[Category: L_TmpV2 Data]]