CCMDB Data cleaner.mdb general information: Difference between revisions
Ttenbergen (talk | contribs) What is the next step with this tool? |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 19: | Line 19: | ||
For use, Pagasa copies the file to her C:\ drive. The file can grow to >1GB in size during use so working with it on the network would be too slow. | For use, Pagasa copies the file to her C:\ drive. The file can grow to >1GB in size during use so working with it on the network would be too slow. | ||
== L_Aux == | |||
The table L_Aux contains some calculated values that are exported by TMSX. They are: | |||
* Apache | |||
* Inits - Collector initials | |||
* Age - based on what date? | |||
* LOS | |||
* Enc | |||
* Index | |||
* Serial - serial number during collection | |||
* HMORT | |||
* apspts | |||
* agepts | |||
* chempts | |||
* totApache (how is this different from "Apache" above?) | |||
===Discussion === | |||
{{discussion}} | |||
* How are these calculated, or where are they derived from? [[User:Ttenbergen|Ttenbergen]] 13:54, 8 December 2009 (CST) | |||
== History == | == History == | ||
| Line 25: | Line 44: | ||
*Pagasa was running the queries and distributing problem ID, by email, fax or phone to data collectors. | *Pagasa was running the queries and distributing problem ID, by email, fax or phone to data collectors. | ||
*data cleaner.mdb was outputting many false +ve's, and collectors were complaining about the number of items they were being required to check that were not errors. | *data cleaner.mdb was outputting many false +ve's, and collectors were complaining about the number of items they were being required to check that were not errors. | ||
*The data cleaner.mdb was reviewed by Trish with Pagasa. The problems found and also the original items in the data cleaning.mdb list from Julie is posted below. The list of checks for this program that were are X drive were also transcribed to this list. | *The data cleaner.mdb was reviewed by Trish with Pagasa. The problems found and also the original items in the data cleaning.mdb list from Julie is posted below. The list of checks for this program that were are X drive were also transcribed to this list. | ||
== Related articles == | == Related articles == | ||