L TmpV2 table: Difference between revisions

Line 1:

The '''L_TmpV2''' table (also know as '''Tmp file''')in the [[CCMDB.mdb]] contains data 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]] (some data is sent every time, some only when the patient is sent, see [[S Tmp Complete_send]] for more.)

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

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

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.

@@ Line 1: / Line 1: @@
 The '''L_TmpV2''' table (also know as '''Tmp file''')in the [[CCMDB.mdb]] contains data 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]] (some data is sent every time, some only when the patient is sent, see [[S Tmp Complete_send]] for more.)
-Usually the data in L_TmpV2 will be data generated by [[:Category:Special Short Term Projects | Special Short Term Projects]] but some other data such as [[ER Wait]] is stored here as well.
+Usually the data in L_TmpV2 will be data generated by [[:Category:Special Short Term Projects | Special Short Term Projects]] but some other data such as [[ER Wait]] & [[Postal code collection]] is stored here as well.
 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.