Centralized data front end.accdb Change Request: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 4: | Line 4: | ||
== Other change requests == | == Other change requests == | ||
* I have replaced the med_from query with one called “link_suspect_from_partner_no_match”; now that we are using var1/2 elsewhere it only makes sense. I still need to make the counterpart *to query. This query finds pts where the second record says they should be from a partner site and there is no partner. I also need to make queries for prev encounter comes from a partner site and Var is not marked. | * I have replaced the med_from query with one called “link_suspect_from_partner_no_match”; now that we are using var1/2 elsewhere it only makes sense. I still need to make the counterpart *to query. This query finds pts where the second record says they should be from a partner site and there is no partner. I also need to make queries for prev encounter comes from a partner site and Var is not marked. | ||
* need to make | * need to make an NDC where early and late have short transit times but locations don’t correspond. | ||
* St B 5B vs B5 in var1/2 | * St B 5B vs B5 in var1/2 | ||
| Line 29: | Line 25: | ||
** 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? | * data issues? | ||
Revision as of 19:38, 19 January 2015
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
- I have replaced the med_from query with one called “link_suspect_from_partner_no_match”; now that we are using var1/2 elsewhere it only makes sense. I still need to make the counterpart *to query. This query finds pts where the second record says they should be from a partner site and there is no partner. I also need to make queries for prev encounter comes from a partner site and Var is not marked.
- need to make an NDC where early and late have short transit times but locations don’t correspond.
- 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
- Highest pseudo is used to check “bad PHIN” for incompletes - better solution?
- this should be done in CCMDB instead, see Requested_CCMDB_changes_for_the_next_version#Important_change_request
- "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