Centralized data front end.accdb Change Request: Difference between revisions
Ttenbergen (talk | contribs) m →Other change requests: unique patient IDs are now implemented see L_Person |
Ttenbergen (talk | contribs) m →Other change requests: highest_pseudo was already gone, and confirmed with Pagasa that no longer needed. |
||
| Line 5: | Line 5: | ||
== Other change requests == | == Other change requests == | ||
=== 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. | * 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. | ||
| Line 14: | Line 15: | ||
** var1/2 etc | ** var1/2 etc | ||
=== L_Log BirthMY === | |||
* 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? | * data issues? | ||
** collapse autopsy... | ** collapse autopsy... | ||
=== Preventing inappropriate edits by data processor === | === Preventing inappropriate edits by data processor === | ||