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

(17 intermediate revisions by the same user not shown)

Line 4:

== Log ==

=== 2025-06-~~23-1~~ ===

=== 2025-09-28 ===

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 ~~Sub~~ Sub DumpAllQueries_UTF8() to [[_Global module]] to help document queries

* 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)~~

* updated connector.confirm_files_and_links() to behave if the old LMS or Tiss28 files are not present (ie re-connect only if present)

** ~~also~~ added ~~the queries~~ for ~~this: manifest_BoardkingLoc, manifest_BoardingLoc_firstTemp, manifest_BoardingLoc_firstTemp~~

* 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]]

* some code updates in preparation for [[O365 Testing]]

** 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 code from L_ICD10_subform which was imported from CCMDB but can't be used here, the spot just uses data sheet view

** removed module "updaters" that contained some old one-time code from a data update in 2016

** removed module "Check_Forms" that was empty anyway...

** removed module "global_old", a copy of module "_global" before global was unified with the ccmdb version

** replaced a bunch of old DoCmd.RunSQL with runQuery

** replaced all "As Recordset" with "As DAO.Recordset"

** removed a bunch of tables that had been added as part of analysis over time

** removed ancient legacy table [[Check_ORDx]] that was used by a cross check in pre-ICD10 diagnoses

** removed query "COV_Pat_ID_matcher" that had been used for [[2020-03 HSC COVID unit transition]]

** removed query "tmp2_convert_timeless_TRs" that is not referenced on wiki

* found duplicate functionality in function connector.Table_exists and _global.ExistsTable ; consolidated to _global.ExistsTable

* found duplicate functionality in function connector.relink_table and _global.Refresh_table; consolidated to _global.Refresh_table

* moved connector.file_exists to _global.ExistsFile and consolidated

* consolidated table dropping in _global.DropTable

* moved function CCMDB_Age straight into SQL in [[Created_Variables_CC_maker_2021 query]] and [[Created_Variables_Common_maker_2021 query]]

=== 2025-06-23 ===

@@ Line 4: / Line 4: @@
 == Log ==
-=== 2025-06-23-1 ===
+=== 2025-09-28 ===
 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 Sub Sub DumpAllQueries_UTF8() to [[_Global module]] to help document queries
+* 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)
+* updated connector.confirm_files_and_links() to behave if the old LMS or Tiss28 files are not present (ie re-connect only if present)
-** also added the queries for this: manifest_BoardkingLoc, manifest_BoardingLoc_firstTemp, manifest_BoardingLoc_firstTemp
+* 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]]
+* some code updates in preparation for [[O365 Testing]]
+** 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 code from L_ICD10_subform which was imported from CCMDB but can't be used here, the spot just uses data sheet view
+** removed module "updaters" that contained some old one-time code from a data update in 2016
+** removed module "Check_Forms" that was empty anyway...
+** removed module "global_old", a copy of module "_global" before global was unified with the ccmdb version
+** replaced a bunch of old DoCmd.RunSQL with runQuery
+** replaced all "As Recordset" with "As DAO.Recordset"
+** removed a bunch of tables that had been added as part of analysis over time
+** removed ancient legacy table [[Check_ORDx]] that was used by a cross check in pre-ICD10 diagnoses
+** removed query "COV_Pat_ID_matcher" that had been used for [[2020-03 HSC COVID unit transition]]
+** removed query "tmp2_convert_timeless_TRs" that is not referenced on wiki
+* found duplicate functionality in function connector.Table_exists and _global.ExistsTable ; consolidated to _global.ExistsTable
+* found duplicate functionality in function connector.relink_table and _global.Refresh_table; consolidated to _global.Refresh_table
+* moved connector.file_exists to _global.ExistsFile and consolidated
+* consolidated table dropping in _global.DropTable
+* moved function CCMDB_Age straight into SQL in [[Created_Variables_CC_maker_2021 query]] and [[Created_Variables_Common_maker_2021 query]]
 === 2025-06-23 ===