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

(56 intermediate revisions by the same user not shown)

Line 4:

== Log ==

=== 2023 ===

See [[Centralized data front end.accdb Change Log 2023]]

=== 2022-11-29 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 11:35, 2022 November 29 (CST)

* updated [[Created_APACHE_Chronic query]] (which is used by [[Created Variables CC maker 2021 query]]) to not look at CCIs any longer, ie to not reference query L_CCI_Component_APACHE_Comorbids or query L_CCI_Picklist_APACHE_Comorbids any longer

* updated [[created_AdmitDtTm query]] so it won't crash when there are nulls in all three dates

=== 2022-11-15 ===

copied to server (with same version, forgot to change it) [[User:Ttenbergen|Ttenbergen]] 12:15, 2022 November 17 (CST)

* updated [[S ICD10 APACHE Comorbids query]] to properly exclude the ends of pattern ranges, they were included before.

=== 2022-11-15 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 08:52, 2022 November 15 (CST)

* changed [[Created TransferReady query]] to exclude null dates

* updated [[Patient Viewer]] to include [[Dispo DtTm]] on top row

* re-did Sub populate_created_transferDelay() entirely to fix contents of [[Created transferDelay table]]

* [[Change for Apache Chronic to ICD10 from separate variable]]: updated [[Created_Variables_CC_maker_2021 query]] - it was using [[created_APACHE_Chronic query]] for [hasChronic] and [chronic_pts], but not for [ApTotal_Chronic] and [ApTotal]. It now uses the combined definition from created_APACHE_Chronic for all four fields.

=== 2022-09-29 ===

copied to server

* Reverted update to [[Created_Variables_CC_2021 table]] / [[Created Variables CC maker 2021 query]] to use the profile-based transfer delay calculation again rather than the [[Level of care]] based calculation, after finding exceptions to that model for CC. [[User:Ttenbergen|Ttenbergen]] 16:36, 2022 September 28 (CDT)

=== 2022-08-31 ===

copied to server[[User:Ttenbergen|Ttenbergen]] 13:40, 2022 September 22 (CDT)

* deleted ''Created_transferDelay_int'' query because it's done different now to not require the combiner

* added [[created_BoardingLoc_plus_historical query]] to generate the [[Level of care hierarchy|level of care]]

* updated [[Sub populate created transferDelay()]] to use [[created_BoardingLoc_plus_historical query]]

* deleted mystery tables after confirming with Julie: 1_MOST_bands, 1_MOST_gt3, 1_MOST_lept1

* updated [[created_FirstTransferReady query]] to use [[created_TransferReady query]]

* updated [[Created_TransferReady_cc query]] to use [[created_FirstTransferReady query]]

* updated [[Created Variables CC 2021 table]] to use the transfer delay from [[Created transferDelay table]] instead of calculating its own

* updated [[Query created PatientFollow]] to use [[Created AdmitDtTm query]] rather than use its own calculation

=== 2022-08-23 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 16:39, 2022 August 29 (CDT)

* tweak to [[PL_SameCHART_Site_Diff_PHIN]] to remove some unneeded columns

* tweak to code that runs the queries for the patient viewer form, it was using an old name for the admit dttm column

* tweak to [[Created TransferReady cc query]] which had somehow lost its D_ID column

=== 2022-08-16 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 11:33, 2022 August 16 (CDT)

* updated query ''L_Log_PHI'' to exclude the defunct fields. [[User:Ttenbergen|Ttenbergen]] 09:40, 2022 August 16 (CDT)

* updated query ''Patient_List'' to exclude fields that aren't needed [[User:Ttenbergen|Ttenbergen]] 10:44, 2022 August 16 (CDT)

* simplified how Sub cbo_QuerySelector_Click() works

* adjusted column widths on form ''PatientList''

=== 2022-08-15 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 22:49, 2022 August 15 (CDT)

* updated query Patientlist to remove defunct FinalCheck field [[User:Ttenbergen|Ttenbergen]] 22:49, 2022 August 15 (CDT)

=== 2022-08-03 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 16:22, 2022 August 15 (CDT)

* updated [[created_TransferReady_cc query]] to remove a subquery that wasn't actually used.

* updated Function confirm_files_and_links() to connect [[L Dxs table]] and [[L Como table]] to [[Legacy TMS Data.mdb]] instead

=== 2022-07-29 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 10:24, 2022 July 28 (CDT)

* changed "I27.81" to "I27.8*" in [[S ICD10 APACHE Como patterns table]]

=== 2022-07-26 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 14:05, 2022 July 26 (CDT)

* updated [[Link suspect negative transit time query]] to only show if diff is > 30min

* updated [[Created Variables CC maker 2021 query]] because it was showing duplicates for records where more than one [[Transfer Ready DtTm tmp entry]] had a date

=== 2022-07-06 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 10:35, 2022 July 6 (CDT)

* fix to [[Created APACHE Chronic query]] (used testing name for a variable still) and [[Created_Variables_CC_maker_2021 query]] (had duplicate RecordStatus output)

=== 2022-06-30 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 10:49, 2022 June 30 (CDT)

* updated [[Created_APACHE_Chronic query]] to start using ICD10 derived Chronic Health scoring for values >= 2019-01-01

* confirmed that [[Created_Variables_CC_maker_2021 query]] already lists the value from [[Created_APACHE_Chronic query]] [[User:Ttenbergen|Ttenbergen]] 10:44, 2022 June 30 (CDT)

=== 2022-06-29 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 15:30, 2022 June 29 (CDT)

* updated [[Transfer Delay (Critical Care)]]/[[Created _Variables_CC maker_2021 query]] to use [[Created_TransferReady query]], and to start populating field [[Transfer_Delay_CC]].

* updated [[Transfer Delay (Medicine)]]

===2022-06-28 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 13:25, 2022 June 28 (CDT)

* removed old code in ''2016-07_dispo_convert''

* updated [[Created_Variables_Common_2021 table]] / [[Created_Variables_Common_maker_2021 query]] with new coding for [[ER Delay]]

===2022-06-16 ===

copied to server [[User:Ttenbergen|Ttenbergen]] 14:44, 2022 June 16 (CDT)

* added several recordset .close statements to see if this will fix [["cannot open any more tables" in Access]]

===2022-06-15 ===

copied to server

Line 56:

Line 145:

* updated [[Created_Variables_Common_maker_2021 query]] (documented in [[Created Variables Common 2021 table]]) to properly calculate LOS and to confirm it is now using the new [[Admit DtTm]] where appropriate, and to remove [[Transfer Delay]] since there can be more than one now. [[User:Ttenbergen|Ttenbergen]] 16:59, 2022 April 27 (CDT)

* updated [[Function LOS()]]

* updated [[~~Created_Variables_Common_maker~~ query]] to stop using Accept and Arrive DtTm as it was breaking the query. We still need to move to the new queries to make sure we get reasonable results.

* updated Created_Variables_Common_maker query (see [[Created_Variables_Common_maker_2021 query]]) to stop using Accept and Arrive DtTm as it was breaking the query. We still need to move to the new queries to make sure we get reasonable results.

* updated [[Link_suspect_not_same_visitAdmitDtTm query]] to also check that the earlier and later record are at the same site

Line 95:

Line 184:

===2022-02-16===

rolled out [[User:Ttenbergen|Ttenbergen]] 15:45, 2022 March 2 (CST)

* fields "ward" and "activeLocation" were missing from [[Created_Variables_CC table]] for some reason, which was causing errors in running [[~~Created_Variables_CC_maker~~ query]]; restored field [[User:Ttenbergen|Ttenbergen]] 13:53, 2022 March 2 (CST)

* fields "ward" and "activeLocation" were missing from Created_Variables_CC table (see [[Created_Variables_CC 2021 table]]) for some reason, which was causing errors in running Created_Variables_CC_maker query (see [[Created_Variables_CC_maker_2021 query]]); restored field [[User:Ttenbergen|Ttenbergen]] 13:53, 2022 March 2 (CST)

===2022-01-05===

@@ Line 4: / Line 4: @@
 == Log ==
+=== 2023 ===
+See [[Centralized data front end.accdb Change Log 2023]]
+=== 2022-11-29 ===
+copied to server [[User:Ttenbergen|Ttenbergen]] 11:35, 2022 November 29 (CST)
+* updated [[Created_APACHE_Chronic query]] (which is used by [[Created Variables CC maker 2021 query]]) to not look at CCIs any longer, ie to not reference query L_CCI_Component_APACHE_Comorbids or query L_CCI_Picklist_APACHE_Comorbids any longer
+* updated [[created_AdmitDtTm query]] so it won't crash when there are nulls in all three dates
+=== 2022-11-15 ===
+copied to server (with same version, forgot to change it) [[User:Ttenbergen|Ttenbergen]] 12:15, 2022 November 17 (CST)
+* updated [[S ICD10 APACHE Comorbids query]] to properly exclude the ends of pattern ranges, they were included before.
+=== 2022-11-15 ===
+copied to server [[User:Ttenbergen|Ttenbergen]] 08:52, 2022 November 15 (CST)
+* changed [[Created TransferReady query]] to exclude null dates
+* updated [[Patient Viewer]] to include [[Dispo DtTm]] on top row
+* re-did Sub populate_created_transferDelay() entirely to fix contents of [[Created transferDelay table]]
+* [[Change for Apache Chronic to ICD10 from separate variable]]: updated [[Created_Variables_CC_maker_2021 query]] - it was using [[created_APACHE_Chronic query]] for [hasChronic] and [chronic_pts], but not for [ApTotal_Chronic] and [ApTotal]. It now uses the combined definition from created_APACHE_Chronic for all four fields.
+=== 2022-09-29 ===
+copied to server
+* Reverted update to [[Created_Variables_CC_2021 table]] / [[Created Variables CC maker 2021 query]] to use the profile-based transfer delay calculation again rather than the [[Level of care]] based calculation, after finding exceptions to that model for CC. [[User:Ttenbergen|Ttenbergen]] 16:36, 2022 September 28 (CDT)
+=== 2022-08-31 ===
+copied to server[[User:Ttenbergen|Ttenbergen]] 13:40, 2022 September 22 (CDT)
+* deleted ''Created_transferDelay_int'' query because it's done different now to not require the combiner
+* added [[created_BoardingLoc_plus_historical query]] to generate the [[Level of care hierarchy|level of care]]
+* updated [[Sub populate created transferDelay()]] to use  [[created_BoardingLoc_plus_historical query]]
+* deleted mystery tables after confirming with Julie: 1_MOST_bands, 1_MOST_gt3, 1_MOST_lept1
+* updated [[created_FirstTransferReady query]] to use [[created_TransferReady query]]
+* updated [[Created_TransferReady_cc query]] to use [[created_FirstTransferReady query]]
+* updated [[Created Variables CC 2021 table]] to use the transfer delay from [[Created transferDelay table]] instead of calculating its own
+* updated [[Query created PatientFollow]] to use [[Created AdmitDtTm query]] rather than use its own calculation
+=== 2022-08-23 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 16:39, 2022 August 29 (CDT)
+* tweak to [[PL_SameCHART_Site_Diff_PHIN]] to remove some unneeded columns
+* tweak to code that runs the queries for the patient viewer form, it was using an old name for the admit dttm column
+* tweak to [[Created TransferReady cc query]] which had somehow lost its D_ID column
+=== 2022-08-16 ===
+copied to server [[User:Ttenbergen|Ttenbergen]] 11:33, 2022 August 16 (CDT)
+* updated query ''L_Log_PHI'' to exclude the defunct fields. [[User:Ttenbergen|Ttenbergen]] 09:40, 2022 August 16 (CDT)
+* updated query ''Patient_List'' to exclude fields that aren't needed [[User:Ttenbergen|Ttenbergen]] 10:44, 2022 August 16 (CDT)
+* simplified how Sub cbo_QuerySelector_Click() works
+* adjusted column widths on form ''PatientList''
+=== 2022-08-15 ===
+copied to server [[User:Ttenbergen|Ttenbergen]] 22:49, 2022 August 15 (CDT)
+* updated query Patientlist to remove defunct FinalCheck field [[User:Ttenbergen|Ttenbergen]] 22:49, 2022 August 15 (CDT)
+=== 2022-08-03 ===
+copied to server [[User:Ttenbergen|Ttenbergen]] 16:22, 2022 August 15 (CDT)
+* updated [[created_TransferReady_cc query]] to remove a subquery that wasn't actually used.
+* updated Function confirm_files_and_links() to connect [[L Dxs table]] and [[L Como table]] to [[Legacy TMS Data.mdb]] instead
+=== 2022-07-29 ===
+copied to server [[User:Ttenbergen|Ttenbergen]] 10:24, 2022 July 28 (CDT)
+* changed "I27.81" to "I27.8*" in [[S ICD10 APACHE Como patterns table]]
+=== 2022-07-26 ===
+copied to server [[User:Ttenbergen|Ttenbergen]] 14:05, 2022 July 26 (CDT)
+* updated [[Link suspect negative transit time query]] to only show if diff is > 30min
+* updated [[Created Variables CC maker 2021 query]] because it was showing duplicates for records where more than one [[Transfer Ready DtTm tmp entry]] had a date
+=== 2022-07-06 ===
+copied to server [[User:Ttenbergen|Ttenbergen]] 10:35, 2022 July 6 (CDT)
+* fix to [[Created APACHE Chronic query]] (used testing name for a variable still) and [[Created_Variables_CC_maker_2021 query]] (had duplicate RecordStatus output)
+=== 2022-06-30 ===
+copied to server [[User:Ttenbergen|Ttenbergen]] 10:49, 2022 June 30 (CDT)
+* updated [[Created_APACHE_Chronic query]] to start using ICD10 derived Chronic Health scoring for values >= 2019-01-01
+* confirmed that [[Created_Variables_CC_maker_2021 query]] already lists the value from [[Created_APACHE_Chronic query]] [[User:Ttenbergen|Ttenbergen]] 10:44, 2022 June 30 (CDT)
+=== 2022-06-29 ===
+copied to server [[User:Ttenbergen|Ttenbergen]] 15:30, 2022 June 29 (CDT)
+* updated [[Transfer Delay (Critical Care)]]/[[Created _Variables_CC maker_2021 query]] to use [[Created_TransferReady query]], and to start populating field [[Transfer_Delay_CC]].
+* updated [[Transfer Delay (Medicine)]]
+===2022-06-28 ===
+copied to server [[User:Ttenbergen|Ttenbergen]] 13:25, 2022 June 28 (CDT)
+* removed old code in ''2016-07_dispo_convert''
+* updated [[Created_Variables_Common_2021 table]] / [[Created_Variables_Common_maker_2021 query]] with new coding for [[ER Delay]]
+===2022-06-16 ===
+copied to server [[User:Ttenbergen|Ttenbergen]] 14:44, 2022 June 16 (CDT)
+* added several recordset .close statements to see if this will fix [["cannot open any more tables" in Access]]
 ===2022-06-15 ===
 copied to server
@@ Line 56: / Line 145: @@
 * updated [[Created_Variables_Common_maker_2021 query]] (documented in [[Created Variables Common 2021 table]]) to properly calculate LOS and to confirm it is now using the new [[Admit DtTm]] where appropriate, and to remove [[Transfer Delay]] since there can be more than one now. [[User:Ttenbergen|Ttenbergen]] 16:59, 2022 April 27 (CDT)
 * updated [[Function LOS()]]
-* updated [[Created_Variables_Common_maker query]] to stop using Accept and Arrive DtTm as it was breaking the query. We still need to move to the new queries to make sure we get reasonable results.
+* updated Created_Variables_Common_maker query (see [[Created_Variables_Common_maker_2021 query]]) to stop using Accept and Arrive DtTm as it was breaking the query. We still need to move to the new queries to make sure we get reasonable results.
 * updated [[Link_suspect_not_same_visitAdmitDtTm query]] to also check that the earlier and later record are at the same site
@@ Line 95: / Line 184: @@
 ===2022-02-16===
 rolled out [[User:Ttenbergen|Ttenbergen]] 15:45, 2022 March 2 (CST)
-* fields "ward" and "activeLocation" were missing from [[Created_Variables_CC table]] for some reason, which was causing errors in running [[Created_Variables_CC_maker query]]; restored field [[User:Ttenbergen|Ttenbergen]] 13:53, 2022 March 2 (CST)
+* fields "ward" and "activeLocation" were missing from Created_Variables_CC table (see [[Created_Variables_CC 2021 table]]) for some reason, which was causing errors in running Created_Variables_CC_maker query (see [[Created_Variables_CC_maker_2021 query]]); restored field [[User:Ttenbergen|Ttenbergen]] 13:53, 2022 March 2 (CST)
 ===2022-01-05===