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

(5 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 29:

Line 26:

** 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 29: / Line 26: @@
 ** 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 ===