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

(23 intermediate revisions by the same user not shown)

Line 4:

== 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 ===

~~not rolled out yet~~ [[User:Ttenbergen|Ttenbergen]] 12:40, 2021 ~~August 25~~ (CDT)

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_2021''~~ query to use the new field names.

* 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''

Line 30:

Line 55:

** [[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 ===

Line 54:

Line 79:

=== 2021-08-04 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 14:46, 2021 August 5 (CDT)

* updated query [[~~PL missing L Tables content~~]] to no longer look at old [[L Labs Flowsheet table]]

* 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

Line 69:

Line 94:

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)

* removed query ~~PL_missing_L_Tables_content_L_Problems~~; it was used by [[~~PL_missing_L_Tables_content~~]] but I integrated it there instead

* 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]]

** 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 "LSusp" button to Patient List (counterpart to NDCs and PLs)

* added [[query ~~NCD_dx_implying_death_across_encounters~~]]

* added [[query NDC_dx_implying_death_across_encounters]]

* finished work on [[Created_AdmitDtTm query]], [[Created_FirstLocation query]], [[Created_FirstService query]]

=== 2021-04-21 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 15:20, 2021 June 3 (CDT)

* started update for [[Created_Variables_Common_maker query~~]],~~ see [[~~Created Variables Common table#Log~~]] ~~for details~~; for now I created a second query Created_Variables_Common_maker'''_2021'''

* 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 ~~for[[Created_Variables_CC_maker~~ query~~]],~~ see [[~~Created Variables CC table#Log~~]] ~~for details~~; for now I created a second query ~~Created_Variables_CC_maker'''_2021'''~~

* 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_FirstService query]]

Line 124:

Line 149:

=== 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.

* updated [[CT_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''

@@ Line 4: / Line 4: @@
 == 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 ===
-not rolled out yet [[User:Ttenbergen|Ttenbergen]] 12:40, 2021 August 25 (CDT)
+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_2021'' query to use the new field names.
+* 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''
@@ Line 30: / Line 55: @@
 ** [[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 ===
@@ Line 54: / Line 79: @@
 === 2021-08-04 ===
 copied to server [[User:Ttenbergen|Ttenbergen]] 14:46, 2021 August 5 (CDT)
-* updated query [[PL missing L Tables content]] to no longer look at old [[L Labs Flowsheet table]]
+* 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
@@ Line 69: / Line 94: @@
 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)
-* removed query PL_missing_L_Tables_content_L_Problems; it was used by [[PL_missing_L_Tables_content]] but I integrated it there instead
+* 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]]
 ** 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 "LSusp" button to Patient List (counterpart to NDCs and PLs)
-* added [[query NCD_dx_implying_death_across_encounters]]
+* added [[query NDC_dx_implying_death_across_encounters]]
 * finished work on [[Created_AdmitDtTm query]], [[Created_FirstLocation query]], [[Created_FirstService query]]
 === 2021-04-21 ===
 copied to server [[User:Ttenbergen|Ttenbergen]] 15:20, 2021 June 3 (CDT)
-* started update for [[Created_Variables_Common_maker query]], see [[Created Variables Common table#Log]] for details; for now I created a second query Created_Variables_Common_maker'''_2021'''
+* 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 for[[Created_Variables_CC_maker query]], see [[Created Variables CC table#Log]] for details; for now I created a second query Created_Variables_CC_maker'''_2021'''
+* 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_FirstService query]]
@@ Line 124: / Line 149: @@
 === 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.
+* updated [[CT_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''