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
• 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. 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
  • 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

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