CCMDB Wiki

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

← Older editNewer edit →
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 ===
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Request"