L TmpV2 table: Difference between revisions

Line 1:

L_TmpV2 table in [[CCMDB.mdb]] and [[Centralized_data.mdb]] contains data that is either intermittent or just not currently accommodated in the rest of the database. ~~When the data collector sends, the data gets dumped into [[Centralized_data.mdb]].~~

L_TmpV2 table in [[CCMDB.mdb]] and [[Centralized_data.mdb]] contains data that is either intermittent or just not currently accommodated in the rest of the database. Collection projects that generate data for this table are categorized in [[:Category:All Projects]] / [[:Category:L TmpV2 Data | Category:L TmpV2 Data]].

~~Usually the~~ data in ~~L_TmpV2 will be data generated by~~ [[:Category:~~Special Short Term~~ Projects ~~| Special Short Term Projects]~~] ~~but some other permanently collected data such as [[ER Wait~~]~~] &~~ [[~~Postal code collection~~]] ~~is stored here as well~~.

The table has fields to accommodate dates, integers, reals/floating point variables, text or booleans. It can accommodate 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 accommodate 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 (see [[:[[Category: All Projects]]]]). For a list of any projects that have been stored in L_TmpV2, see [[:Category:L TmpV2 Data | Category:L TmpV2 Data]].

==Data Structure==

@@ Line 1: / Line 1: @@
-L_TmpV2 table in [[CCMDB.mdb]] and [[Centralized_data.mdb]] contains data that is either intermittent or just not currently accommodated in the rest of the database. When the data collector sends, the data gets dumped into [[Centralized_data.mdb]].
+L_TmpV2 table in [[CCMDB.mdb]] and [[Centralized_data.mdb]] contains data that is either intermittent or just not currently accommodated in the rest of the database. Collection projects that generate data for this table are categorized in [[:Category:All Projects]] / [[:Category:L TmpV2 Data | Category:L TmpV2 Data]].
-Usually the data in L_TmpV2 will be data generated by [[:Category:Special Short Term Projects | Special Short Term Projects]] but some other permanently collected data such as [[ER Wait]] & [[Postal code collection]] is stored here as well.
 The table has fields to accommodate dates, integers, reals/floating point variables, text or booleans. It can accommodate 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 accommodate 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 (see [[:[[Category: All Projects]]]]). For a list of any projects that have been stored in L_TmpV2, see  [[:Category:L TmpV2 Data | Category:L TmpV2 Data]].
 ==Data Structure==