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

(3 intermediate revisions by the same user not shown)

Line 10:

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

Line 144:

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

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 10: / Line 10: @@
 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 ===
@@ Line 144: / 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 183: / 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===