Centralized data front end.accdb Change Log 2022: Difference between revisions
Ttenbergen (talk | contribs) m (→2022-04-27) |
Ttenbergen (talk | contribs) m (→2022-04-27) |
||
Line 10: | Line 10: | ||
* 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 [[Created_Variables_Common_maker query]] to stop using Accept and Arrive DtTm | |||
===2022-04-07=== | ===2022-04-07=== |
Revision as of 09:10, 2022 May 4
see the Development Documentation Category for other development logs This article is the change log for Centralized data front end.accdb. Also see Centralized data front end.accdb Change Request and CFE Data Integrity Checks.
Log
2022-04-27
not rolled out yet Ttenbergen 09:42, 2022 April 14 (CDT)
- removed "Form Covid rept" wiki page, and all associated parts in CFE
- 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. Ttenbergen 16:59, 2022 April 27 (CDT)
- updated Function LOS()
- updated Created_Variables_Common_maker query to stop using Accept and Arrive DtTm
2022-04-07
copied to server Ttenbergen 09:42, 2022 April 14 (CDT)
- updated sort order used in PatientList when query is "PL_SameCHART_Site_Diff_PHIN"
- updated query PL_SamePHIN_Site_Diff_chart - it didn't have an explicit D_ID field so would not have worked with PatientList. Wonder if it has been working at all.
2022-04-06
rolled out Ttenbergen 00:06, 2022 April 7 (CDT)
- updated L_ICD10_APACHE_Comorbids query to only include Comorbid Diagnoses
- updated likely_match form (Cat button) to sort by Admit DtTm DESC
2022-04-05
copied to server
- fixed Link_suspect_not_same_visitAdmitDtTm query
- updated Patient_List query / Patient List form to show new Admit DtTm
2022-03-24
copied to server Ttenbergen 16:12, 2022 April 5 (CDT)
- updated link_suspect_negative_transit_time query to use Admit DtTm
- updated code behind Cat button to not initially load all records, and to open with only likely match records instead.
- updated likely_match query to use Created AdmitDtTm query
- streamlining of re-connect activities:
- added Reconnect_check_Completes query and set it so it is run when the "Re-connect Data" button is pressed
- made steps/checks in Reconnect CFE and initial error checks run automatically
- added process to facilitate changing "completes" to "incompletes"
2022-03-09
copied to server Ttenbergen 23:13, 2022 March 9 (CST)
something went wrong with the original copy to server, so re-copied it from my desktop. Ttenbergen 17:02, 2022 March 10 (CST)
2022-02-16
rolled out 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 Ttenbergen 13:53, 2022 March 2 (CST)
2022-01-05
rolled out Ttenbergen 16:49, 2022 February 16 (CST)
- updated Created_Variables_Common_maker_2021 query to eliminate duplicates Ttenbergen 16:47, 2021 December 29 (CST)
- updated Created Variables CC 2021 table to eliminate fields we no longer need Ttenbergen 16:02, 2022 January 11 (CST)
- updated Link_suspect_not_same_visitAdmitDtTm query #Log Ttenbergen 16:14, 2022 February 16 (CST)
Earlier changes
See Centralized data front end.accdb Change Log 2021
Related articles
Related articles: |