Centralized_data_front_end.accdb Change Log 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
• 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 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

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