Centralized data front end.accdb Change Log 2021: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "[[Centralized_data.accdb]]" to "Centralized_data.accdb" |
||
| (52 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
== Log == | == Log == | ||
=== 2022 === | |||
See [[Centralized data front end.accdb Change Log 2022]] | |||
===2021-12-29=== | |||
not rolled out yet [[User:Ttenbergen|Ttenbergen]] 16:47, 2021 December 29 (CST) | |||
* updated [[Created_Variables_Common_maker_2021 query]] to eliminate dupliactes [[User:Ttenbergen|Ttenbergen]] 16:47, 2021 December 29 (CST) | |||
===2021-12-09=== | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 11:57, 2021 December 23 (CST) | |||
* Updated the listing/dropdown for ICD10s to list all codes, ie not filtered for ones we currently use. This was so retired codes don't show as blanks. In CFE we need to be able to see all, and even enter all (as in retired codes into old records). [[User:Ttenbergen|Ttenbergen]] 14:18, 2021 December 9 (CST) | |||
* updated the compact-repair code to also compact the PHI data [[User:Ttenbergen|Ttenbergen]] 11:50, 2021 December 23 (CST) | |||
===2021-11-17=== | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 00:17, 2021 November 18 (CST) | |||
* removed [[L_Problems_D_ID table]] that had been moved to [[Centralized_data.accdb]] | |||
* added code to link in [[L_Problems_D_ID table]] from [[Centralized_data.accdb]] | |||
===2021-11-02=== | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 16:01, 2021 November 4 (CDT) | |||
* added [[Query z s dispo inactivatable]] and [[Query z s dispo lastUsed]] [[User:Ttenbergen|Ttenbergen]] 12:36, 2021 November 2 (CDT) | |||
=== 2021-10-28 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 15:11, 2021 October 28 (CDT) | |||
* updated Sub populate_linking_pairs() to first empty the [[linking_pairs table]] before populating it; populating was going wrong for some scenarios otherwise. | |||
=== 2021-08-26 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 15:52, 2021 October 7 (CDT) | |||
* made query structure for [[Created_FirstLocation query]] in [[CFE]] the same as counterpart in [[CCMDB.accdb]], and updated [[Created Variables Common maker 2021 query]] to use the new field names. | |||
* deleted retired query ''NDC_Dxs_vs_TISS_Dialysis'' | |||
* deleted declined query ''Query NDC_Dialysis_TISS_CCI'' | |||
* updated [[link_suspect_negative_transit_time query ]] to eliminate false positives due to different level of precision/resolution of arrive dttm and dispo dttm from Cognos | |||
* deleted queries that were retired as part of [[Change to collect TISS data in CCI Picklist]]: | |||
** [[Query NDC TISS CCI endoscopic]] | |||
** ''NDC_TISS_Spontaneous_vs_ETT_Trach'' which wasn't documented anywhere | |||
** [[query NDC_Trach_Dx_TISS]] | |||
** [[Query NDC Pacemaker acquired vs TISS]] | |||
** NDC_CLI_vs_DX_but_no_TISS17_CentralLine - counterpart in CCMDB.accdb will be [[Query check ICD10 CLI vs CCI CentralLine]] | |||
** [[Query NDC_cardioversion_dx_vs_TISS]] | |||
** QUEST_TISS_Errors_DID_inconsistent_w_location (undocumented) | |||
** QUEST_TISS_Errors_duplicate_D_IDs_in_patient (undocumented) | |||
** QUEST_TISS_Errors_orphan_patient_entries (undocumented) | |||
** [[Query TISS Errors duplicate Items]] | |||
** [[Query TISS Errors_missing_days]] | |||
** [[query TISS_Errors_duplicate_Items]] | |||
** TISS_Errors_No_Tiss_blank (undocumented) | |||
** [[query TISS_Errors_NrTISSDays_NE_LOS]] | |||
** [[query TISS_Errors_TISS_date_out_of_admission]] | |||
** TISS_Errors_Vent_vs_mechanism (undocumented) | |||
** [[query TISS_Errors_vent_vs_vent2300]] | |||
** TISS_admitted_date_range (undocumented) | |||
** helper queries that are now no longer used: has_TISS_19_spont_breath_ETT_trach, has_TISS_22_ETT_present, has_TISS_23_trach_present, has_TISS_32_33_34_Dialysis, has_TISS_32_Hemodialysis, has_TISS_33_CRRT, has_TISS_34_peritoneal_dialysis, has_TISS_42_tmp_pacemaker, has_TISS_43_endoscopic_px, ND_sub_CLI_has_TISS17_CentralLine, has_TISS_18_vent, has_TISS_22_ETT_OR_23_trach_present, has_TISS_48_vent_2300 | |||
* renamed query ''P_Count_of_Sent'' to [[CT Count of sent query]] and confirmed it was updated to work as a crosstab rather than a pivot. | |||
=== 2021-08-25 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 11:54, 2021 August 26 (CDT) | |||
* created crosstab queries to replace pivot tables since 2019 doesnt' support them any more: | |||
** [[CT_Summary_Discharges query]] to replace old ''P_Summary_Discharges query'' | |||
** [[CT_Summary_Discharges_FiscalYear query]] to replace old ''P_Summary_Discharges_FiscalYear query'' | |||
=== 2021-08-24 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 12:40, 2021 August 25 (CDT) | |||
* fixed [[created_AdmitDtTm query]] to explicitly turn the date into date data type; somehow the query turned it into something else that was being sorted differently on Pagasa's computer than on Tina's. [[User:Ttenbergen|Ttenbergen]] 14:06, 2021 August 24 (CDT) | |||
* created crosstab queries to replace pivot tables since 2019 doesnt' support them any more: | |||
** [[CT_Count_of_Admissions query]] to replace old ''P_Count_of_Admissions query'' | |||
** [[CT_Outstandings_Dispo query]] confirmed, replaces old ''P_Outstandings_Dispo'' | |||
** [[CT_Outstandings query]] (though not a crosstab because not needed) to replace ''P_Outstandings'' | |||
=== 2021-08-05 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 11:20, 2021 August 24 (CDT) | |||
* updated algorithm behind [[Populate linking pairs]] which had been generating twin pairs. | |||
* updated [[Link suspect mismatch pre inpt ours incomplete query]] to only look a the last three years | |||
=== 2021-08-04 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 14:46, 2021 August 5 (CDT) | |||
* updated query [[Reconnect_check_missing_L Tables_content query]] to no longer look at old [[L Labs Flowsheet table]] | |||
* updated Sub Encounter_processor which was requiring assent after accidental changes in last round | |||
=== 2021-07-27 === | === 2021-07-27 === | ||
copied to server [[User:Ttenbergen|Ttenbergen]] 22:31, 2021 August 3 (CDT) | copied to server [[User:Ttenbergen|Ttenbergen]] 22:31, 2021 August 3 (CDT) | ||
| Line 11: | Line 89: | ||
=== 2021-07-20 === | === 2021-07-20 === | ||
copied to server [[User:Ttenbergen|Ttenbergen]] 17:00, 2021 July 20 (CDT) | copied to server [[User:Ttenbergen|Ttenbergen]] 17:00, 2021 July 20 (CDT) | ||
* made a crosstab query ''P_Outstandings_Dispo'' to replace | * made a crosstab query ''P_Outstandings_Dispo'' to replace ''Query P_Outstandings_Dispo'' to test as replacement for Pivot Tables, since those no longer work in Access 2019 [[User:Ttenbergen|Ttenbergen]] 16:55, 2021 July 20 (CDT) | ||
=== 2021-07-15 === | === 2021-07-15 === | ||
copied to server [[User:Ttenbergen|Ttenbergen]] 17:25, 2021 July 15 (CDT) | copied to server [[User:Ttenbergen|Ttenbergen]] 17:25, 2021 July 15 (CDT) | ||
* updated [[PL_SamePHIN_Site_Diff_chart]] to get past 2GB limit [[User:Ttenbergen|Ttenbergen]] 12:08, 2021 July 15 (CDT) | * updated [[PL_SamePHIN_Site_Diff_chart]] to get past 2GB limit [[User:Ttenbergen|Ttenbergen]] 12:08, 2021 July 15 (CDT) | ||
* removed query | * removed query Reconnect_check_missing_L Tables_content query_L_Problems; it was used by [[Reconnect_check_missing_L Tables_content query]] but I integrated it there instead | ||
* per requests from [[Centralized data front end.accdb Change Request]] | * per requests from [[Centralized data front end.accdb Change Request]] | ||
** changed order of columns in ICD10 tab to be more like they are in [[CCMDB.accdb]] | ** changed order of columns in ICD10 tab to be more like they are in [[CCMDB.accdb]] | ||
** added column "TDI" to list [[CCI Categories]] to [[Query L_CCI_Combined]] | ** added column "TDI" to list [[CCI Categories]] to [[Query L_CCI_Combined]] | ||
** added "LSusp" button to Patient List (counterpart to NDCs and PLs) | ** added "LSusp" button to Patient List (counterpart to NDCs and PLs) | ||
* added [[query | * added [[query NDC_dx_implying_death_across_encounters]] | ||
* finished work on [[Created_AdmitDtTm query]], [[Created_FirstLocation query]], [[Created_FirstService query]] | * finished work on [[Created_AdmitDtTm query]], [[Created_FirstLocation query]], [[Created_FirstService query]] | ||
=== 2021-04-21 === | === 2021-04-21 === | ||
copied to server [[User:Ttenbergen|Ttenbergen]] 15:20, 2021 June 3 (CDT) | copied to server [[User:Ttenbergen|Ttenbergen]] 15:20, 2021 June 3 (CDT) | ||
* started update for | * started update for Created_Variables_Common_maker query (see [[Created_Variables_Common_maker_2021 query]]); for now I created a second query Created_Variables_Common_maker'''_2021''' | ||
* started update | * started update forCreated_Variables_CC_maker query (see [[Created_Variables_CC_maker_2021 query]]); for now I created a second [[Created_Variables_CC_maker_2021 query]] | ||
* started [[Created_FirstLocation query]] | * started [[Created_FirstLocation query]] | ||
* started [[Created_FirstService query]] | * started [[Created_FirstService query]] | ||
| Line 43: | Line 121: | ||
Copied to server | Copied to server | ||
* updated to list by laptop: | * updated to list by laptop: | ||
** | ** ''query P_Outstandings'' | ||
** | ** ''query P_Outstandings_Dispo'' | ||
* tweaked | * 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]]. | ** [[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) | ||
** [[Link suspect mismatch to ours incomplete query]] to only consider the last 365 days to make it faster | ** [[Link suspect mismatch to ours incomplete query]] to only consider the last 365 days to make it faster | ||
** [[query | ** [[query check_ICD10_CLI_vs_CCI_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 | ** [[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 | * removed | ||
| Line 71: | Line 149: | ||
=== 2021-01-20 === | === 2021-01-20 === | ||
Pagasa has copied to server | Pagasa has copied to server | ||
* updated [[ | * updated [[CT_Count_of_sent query]] to be laptop based and to more closely show Pagasa what she actually needs. | ||
* removed defunct queries | * removed defunct queries | ||
** ''Query NDC CLI AcqDX but NoCLI DateinTMPV2'' | ** ''Query NDC CLI AcqDX but NoCLI DateinTMPV2'' | ||