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

(12 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 19:

Line 16:

* 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 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 19: / Line 16: @@
 * 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 ===