Centralized data front end.accdb Change Log 2022: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "Created_Variables_Common_maker query" to "Created_Variables_Common_maker query (see Created_Variables_Common_maker_2021 query)" |
||
| (18 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
== Log == | == 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 === | === 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 | * 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]] | * added [[created_BoardingLoc_plus_historical query]] to generate the [[Level of care hierarchy|level of care]] | ||
| Line 12: | Line 36: | ||
* updated [[created_FirstTransferReady query]] to use [[created_TransferReady query]] | * updated [[created_FirstTransferReady query]] to use [[created_TransferReady query]] | ||
* updated [[Created_TransferReady_cc query]] to use [[created_FirstTransferReady query]] | * updated [[Created_TransferReady_cc query]] to use [[created_FirstTransferReady query]] | ||
* updated [[ | * 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 === | === 2022-08-23 === | ||
| Line 120: | 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 [[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 [[Function LOS()]] | ||
* updated [[ | * 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 | * updated [[Link_suspect_not_same_visitAdmitDtTm query]] to also check that the earlier and later record are at the same site | ||
| Line 159: | Line 184: | ||
===2022-02-16=== | ===2022-02-16=== | ||
rolled out [[User:Ttenbergen|Ttenbergen]] 15:45, 2022 March 2 (CST) | 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 [[ | * 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=== | ===2022-01-05=== | ||