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

From CCMDB Wiki
Jump to navigation Jump to search
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 ===

Revision as of 20:01, 2021 January 27

see the Development Documentation Category for other development logs This article is the change log for Centralized data front end.accdb. Also see Centralized data front end.accdb Change Request and CFE Data Integrity Checks.

Log

2021-01-21

not rolled out yet

2021-01-20

Pagasa has copied to server

  • updated P_Count_of_sent query to be laptop based and to more closely show Pagasa what she actually needs.
  • removed defunct queries
    • Query NDC CLI AcqDX but NoCLI DateinTMPV2
    • Query NDC CLI No AcqDX but CLI DateinTMPV2

Earlier changes

See Centralized data front end.accdb Change Log 2020

Related articles

Related articles: