Centralized data front end.accdb Change Log 2025: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 4: | Line 4: | ||
== Log == | == Log == | ||
=== 2025- | === 2025-09-28 === | ||
not rolled yet | not rolled yet | ||
* added Sub ListModuleEntities(moduleName As String) to [[_Global module]] to help document code | * added Sub ListModuleEntities(moduleName As String) and dump_all_vba to [[_Global module]] to help document code | ||
* added | * added 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. [[User:Ttenbergen|Ttenbergen]] 13:23, 9 July 2025 (CDT) | * added some code for data modelling: | ||
** also added the queries for this: | ** 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. [[User:Ttenbergen|Ttenbergen]] 13:23, 9 July 2025 (CDT) | ||
* updated confirm_files_and_links() to behave if the old LMS or Tiss28 files are not present | ** also added the queries for this: manifest_BoardingLoc, manifest_BoardingLoc_firstTemp, manifest_BoardingLoc_firstTemp | ||
* updated connector.confirm_files_and_links() to behave if the old LMS or Tiss28 files are not present (ie re-connect only if present) | |||
* updated [[Overstay2 module]] | * 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]]. | ** 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]] | ** 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]] | ||
* some code updates in preparation for [[O365 upgrade]] | |||
** removed the old forms ComoChooser and DxChooser because they used deprecated functionality; they were used to add old style diagnosis codes after collection is complete; in the unlikely case we ever need to do this again we can do it manually in the data | |||
* additional clean-up | |||
** removed forms CCI_Chooser and ICD10Chooser; they had never been used in CFE because they would not generate the L_CCI_ID used to handle unique identifiers in a setting where CFE wouldn't know the value CCMDB would use; in the unlikely event Pagasa needs to do this she handles it as per [[Adding a CCI or ICD10 entry in CFE]]; these had been imported to CFE at some point from CCMDB but never connected | |||
** removed module "updaters" that contained some old one-time code from a data update in 2016 | |||
** removed module "Check_Forms" that was empty anyway... | |||
=== 2025-06-23 === | === 2025-06-23 === | ||
Revision as of 23:05, 28 September 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-09-28
not rolled yet
- added Sub ListModuleEntities(moduleName As String) and dump_all_vba to _Global module to help document code
- added Sub DumpAllQueries_UTF8() to _Global module to help document queries
- added some code for data modelling:
- 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_BoardingLoc, manifest_BoardingLoc_firstTemp, manifest_BoardingLoc_firstTemp
- updated connector.confirm_files_and_links() to behave if the old LMS or Tiss28 files are not present (ie re-connect only if 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
- some code updates in preparation for O365 upgrade
- removed the old forms ComoChooser and DxChooser because they used deprecated functionality; they were used to add old style diagnosis codes after collection is complete; in the unlikely case we ever need to do this again we can do it manually in the data
- additional clean-up
- removed forms CCI_Chooser and ICD10Chooser; they had never been used in CFE because they would not generate the L_CCI_ID used to handle unique identifiers in a setting where CFE wouldn't know the value CCMDB would use; in the unlikely event Pagasa needs to do this she handles it as per Adding a CCI or ICD10 entry in CFE; these had been imported to CFE at some point from CCMDB but never connected
- removed module "updaters" that contained some old one-time code from a data update in 2016
- removed module "Check_Forms" that was empty anyway...
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: |
|