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

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

~~not rolled out yet~~ [[User:Ttenbergen|Ttenbergen]] 11:08, 2022 ~~August 31~~ (CDT)

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

* updated [[~~Created_transferDelay_int~~ query]] to ~~make level_of_care_imp equal~~ to ~~program standard level~~ of ~~care.~~

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

Line 114:

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 153:

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 ===
-not rolled out yet [[User:Ttenbergen|Ttenbergen]] 11:08, 2022 August 31 (CDT)
+copied to server[[User:Ttenbergen|Ttenbergen]] 13:40, 2022 September 22 (CDT)
-* updated [[Created_transferDelay_int query]] to make level_of_care_imp equal to program standard level of care.
+* 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 ===
@@ Line 114: / 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 153: / 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===