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

m Other change requests: person_ID was already in L_Log_PHI_time_hm
m Other change requests: SHA256 removed
Line 4: Line 4:


== Other change requests ==
== Other change requests ==
* remove module SHA256 , we will do this differently now


* 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.