Centralized data front end.accdb Change Log 2021: Difference between revisions

Line 8: Line 8:
* tweak to query ''encounter_clean_3_del_pers_where_no_L_Person'' which is part of [[Person ID field]] generate person ids; it was failing, but because of how we run these queries that was not visible.
* tweak to query ''encounter_clean_3_del_pers_where_no_L_Person'' which is part of [[Person ID field]] generate person ids; it was failing, but because of how we run these queries that was not visible.
* updated algorithm behind [[Populate linking pairs]] which was impracticably slow under Access 2019
* updated algorithm behind [[Populate linking pairs]] which was impracticably slow under Access 2019
{{Todo
| who = Tina
| todo_added = 2021-08-03
| todo_action = 2021-08-03
| question = I still need to document this properly, e.g. [[Query linking_pairs_preList]], [[Query linking_pairs_LatestLinkedPHINAdmit]]
[[Query linking_pairs_multis]]
[[Query linking_pairs_out_of_sequence/linking_pairs_out_of_sequence_deleter]]
[[Query linking_pairs_unlinkeds]]
}}


=== 2021-07-20 ===
=== 2021-07-20 ===