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

(9 intermediate revisions by the same user not shown)

Line 8:

* 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. [[User:Ttenbergen|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]]

Line 25:

Line 22:

** 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 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 8: / Line 8: @@
 * 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. [[User:Ttenbergen|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]]
@@ Line 25: / Line 22: @@
 ** 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 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 ===