Centralized data front end.accdb Change Log 2025: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 11: | Line 11: | ||
** also added the queries for this: manifest_BoardkingLoc, manifest_BoardingLoc_firstTemp, manifest_BoardingLoc_firstTemp | ** also added the queries for this: manifest_BoardkingLoc, manifest_BoardingLoc_firstTemp, manifest_BoardingLoc_firstTemp | ||
* updated confirm_files_and_links() to behave if the old LMS or Tiss28 files are not present | * updated confirm_files_and_links() to behave if the old LMS or Tiss28 files are not present | ||
* updated [[Overstay2 module]] | |||
** portion that reads the DPST value to abort colour generation with error if there are duplicate DPST entries or there is a DPST entry with [[Overstay2 module]]. | |||
** updated Function Generate_Overstay_Score_Grace with updated more exact coefficients as provided by Julie in [https://ccmdb.kuality.ca/index.php?title=Overstay2_scoring_model_for_Grace_Hospital&diff=164992&oldid=164664 this edit] to [[Overstay2 scoring model for Grace Hospital]] | |||
=== 2025-06-23 === | === 2025-06-23 === | ||
Revision as of 00:12, 12 July 2025
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
2025-06-23-1
not rolled yet
- added Sub ListModuleEntities(moduleName As String) to _Global module to help document code
- added Sub Sub DumpAllQueries_UTF8() to _Global module to help document queries
- added Function wrangle_Boarding_Loc() to module _Unique_CFE to generate a derived table with is_first_ER and is_first_non_ER columns; those were very expensive to calculate on the fly, running this is much faster. Ttenbergen 13:23, 9 July 2025 (CDT)
- also added the queries for this: manifest_BoardkingLoc, manifest_BoardingLoc_firstTemp, manifest_BoardingLoc_firstTemp
- updated confirm_files_and_links() to behave if the old LMS or Tiss28 files are not present
- updated Overstay2 module
- portion that reads the DPST value to abort colour generation with error if there are duplicate DPST entries or there is a DPST entry with Overstay2 module.
- updated Function Generate_Overstay_Score_Grace with updated more exact coefficients as provided by Julie in this edit to Overstay2 scoring model for Grace Hospital
2025-06-23
rolled out Ttenbergen 11:49, 23 June 2025 (CDT)
- updated Overstay2 module with model changes; updated git repository
2025-02-23
never rolled out
- updated Overstay2 module to unify the code in CCMDB.accdb and Centralized data front end.accdb; updated git repository
2025-01-29
also never rolled out
- Added module Overstay2
- split Module Global_ into _global and _Unique_CFE to make it easier to share code between CCMDB and CFE
- updated query L_ICD10_Charlson_dxs to list unique values, it would have counted a dx twice if it was listed in both admit and comorbid
2025-06-08
not rolled out yet
- re-imported the modules _Global, _Unique_CFE, Overstay2; compiled successfully
- confirmed updated query L_ICD10_Charlson_dxs
Earlier changes
See Centralized data front end.accdb Change Log 2024
Related articles
| Related articles: |
|