Centralized data front end.accdb Change Request: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 7: | Line 7: | ||
** not sure what this means, will confirm with Trish; query ''1tmp_var12_b5_5b'' | ** not sure what this means, will confirm with Trish; query ''1tmp_var12_b5_5b'' | ||
* | * fix query ''link_suspect_medicine_*_partner'' - have false positives | ||
** Not everyone from *W needs to come from a ward where we collect; | |||
** need acceptable delay | |||
** var1/2 etc | |||
* Highest pseudo is used to check “bad PHIN” for incompletes - better solution? | * Highest pseudo is used to check “bad PHIN” for incompletes - better solution? | ||
| Line 17: | Line 16: | ||
* "Tina will work to implement this new “HASH” system." | * "Tina will work to implement this new “HASH” system." | ||
* BirthMY | * BirthMY | ||
** why are there blank BirthMYs? | ** why are there blank BirthMYs? | ||
** what happens to BirthMY when Pagasa updates Birth? | ** what happens to BirthMY when Pagasa updates Birth? | ||
* data issues? | |||
** collapse autopsy... | |||
** make query to set time part of tmp dateVar to nothing | |||
=== Preventing inappropriate edits by data processor === | === Preventing inappropriate edits by data processor === | ||