Centralized data front end.accdb Change Request: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
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''


* Links suspect Med from med (and med to med as well) - Not everyone from *W needs to come from a ward where we collect; need acceptable delay and var1/2 etc
* fix query ''link_suspect_medicine_*_partner'' - have false positives
 
** Not everyone from *W needs to come from a ward where we collect;  
* The copy and paste in CFE is broken
** need acceptable delay  
 
** var1/2 etc
* fix query ''link_suspect_medicine_to_med_no_partner'' - has false positives


* 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."
* collapse autopsy...
* make query to set time part of tmp dateVar to nothing


* 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 ===

Revision as of 16:58, 27 November 2014

see the Development Documentation Category for other development logs

This article contains requested changes for Centralized data front end.mdb. See Centralized data front end.mdb Change Log for it's change log.

Other change requests

  • St B 5B vs B5 in var1/2
    • 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
  • "Tina will work to implement this new “HASH” system."
  • BirthMY
    • why are there blank BirthMYs?
    • 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

other spot that might contain requirements...

TMSX MedTMS to Centralized go-live

After go-live