Centralized data front end.accdb Change Log 2021
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-04-21
not rolled yet Ttenbergen 14:24, 2021 April 21 (CDT)
- updated created_variables_CC_maker query:
2021-02-11
copied to server Ttenbergen 14:39, 2021 February 11 (CST)
- updated query L_ICD10_primary to include records even if their ICD10 code is in a gap in S ICD10 Chapter block pattern table.
2021-02-04
copied to server Ttenbergen 14:30, 2021 February 4 (CST)
- added automatic linking to s_level_of_care table on re-connectTtenbergen 13:05, 2021 February 4 (CST)
2021-01-21
Copied to server
- updated to list by laptop:
- tweaked
- 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 Ttenbergen 19:46, 2021 January 26 (CST)
- Link suspect mismatch to ours incomplete query 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
- Query NDC_Bad_Postal_Code - changed query to only look at the last year of data to make it faster; any older records were already fixed
- removed
- defunct query NDC_CLI_unacceptable_date_old - CLI tmp has been legacy for some time; there was no wiki page for this
- query ND_sub_CLI_DateinTMPV2, ND_sub_CLI_has_CLI_TmpV2
- query PL_1orphans_old
- query NDC_VAP_unacceptable_date
- query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2
- accessory queries ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component1, ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component, ND_sub_NO_VAPin ACqDX_VAP_dateinTMPV2_sub_had_VAP_acqDX1, ND_sub_NO_VAPin ACqDX_VAP_dateinTMPV2_sub_had_VAP_acqDX
- Link_suspect_transfer_ready_greater_than_dispo
- Link_suspect_transfer_ready_before_arrive_date
- old single-use tables "2016-09-19_random100" and "1tmp"
- old unused table "linking_location_var_pairs"
- 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
- Query NDC zCRRT TISS no tmp and Query NDC zCRRT TISS no tmp_old
- Query NDC zCRRT tmp no TISS and Query NDC zCRRT tmp no TISS_old
- query Patient_List_twek
- query tmp_2020-04-21_sample_for_chastity
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: |