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

From CCMDB Wiki
Jump to navigation Jump to search
m PL queries were discussed with Pagasa and I have a task to remind me to discuss them with her again. no specific change request currently open, so deleting.
Line 2: Line 2:


This article contains requested changes for [[Centralized data front end.mdb]]. See [[Centralized data front end.mdb Change Log]] for it's change log.
This article contains requested changes for [[Centralized data front end.mdb]]. See [[Centralized data front end.mdb Change Log]] for it's change log.
=== PL queries ===
* 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  PL query where early and late have short transit times but locations don’t correspond.
* 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


=== L_Log BirthMY ===
=== L_Log BirthMY ===

Revision as of 14:04, 17 August 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.

L_Log BirthMY

  • BirthMY
    • why are there blank BirthMYs?
    • what happens to BirthMY when Pagasa updates Birth?
  • Template:Discussion emailed Trish and Julie to see if we can pitch this Ttenbergen 14:02, 2015 August 17 (CDT)

Preventing inappropriate edits by data processor

After go-live