Centralized data front end.accdb Change Log 2021: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 12: | Line 12: | ||
** [[Link suspect transfer ready before arrive date]] and then stopped when I realized that will go away with the old [[Transfer Ready DtTm field]]. | ** [[Link suspect transfer ready before arrive date]] and then stopped when I realized that will go away with the old [[Transfer Ready DtTm field]]. | ||
** Sub likely_match_finder so that just matching DOB and Chart will match a pt, without also requiring the first name to match; this is so that both first and last names being wrong won't lose the match as it did with one pt Pagasa pointed out [[User:Ttenbergen|Ttenbergen]] 19:46, 2021 January 26 (CST) | ** Sub likely_match_finder so that just matching DOB and Chart will match a pt, without also requiring the first name to match; this is so that both first and last names being wrong won't lose the match as it did with one pt Pagasa pointed out [[User:Ttenbergen|Ttenbergen]] 19:46, 2021 January 26 (CST) | ||
** [[query link_suspect_mismatch_to_ours__incomplete]] to only consider the last 365 days to make it faster | |||
** [[query NDC_CLI_vs_DX_but_no_TISS17_CentralLine]] - removed old dx schema component | |||
* removed | * removed | ||
** defunct ''query NDC_CLI_unacceptable_date_old'' - CLI tmp has been legacy for some time; there was no wiki page for this | ** defunct ''query NDC_CLI_unacceptable_date_old'' - CLI tmp has been legacy for some time; there was no wiki page for this | ||
| Line 24: | Line 26: | ||
** old unused table "linking_location_var_pairs" | ** old unused table "linking_location_var_pairs" | ||
** undocumented table "z_known_problem_D_IDs" - put the contents into the [[L_Problem table]] | ** undocumented table "z_known_problem_D_IDs" - put the contents into the [[L_Problem table]] | ||
** old likely single use and empty queries: encounter_err_twin_phin_foo1, encounter_err_twin_phin_foo, L_tmp_SepticSet, Labs_requester | |||
=== 2021-01-20 === | === 2021-01-20 === | ||