Centralized data front end.accdb Change Request: Difference between revisions
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? | ||