CCMDB Wiki

CCMDB.accdb Change Log 2025: Difference between revisions

← Older edit
 
(81 intermediate revisions by 2 users not shown)
Line 1: Line 1:
__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
See [[Log (disambiguation)]] for other uses of the term "Log". See the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''. See [[Rolling out changes]] for the process of rolling out changes. See also '''[[requested CCMDB changes for the next version]]''' and '''[[CCMDB.accdb Data Integrity Checks]]'''.  
See [[Log (disambiguation)]] for other uses of the term "Log". See the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''. See [[Rolling out changes]] for the process of rolling out changes. See also '''[[requested CCMDB changes for the next version]]''' and '''[[CCMDB.accdb Data Integrity Checks]]'''.  
===next===
<!--not rolled out yet -->
<!--=== 2025-xx ===
<!--=== 2025-xx ===
<!--'''<mark>Changes collectors need to know about:</mark>'''-->
<!--'''<mark>Changes collectors need to know about:</mark>'''-->
<!--Changes collectors '''don't''' need to know about:-->
<!--Changes collectors '''don't''' need to know about:-->
=== 2025-11-27 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 22:38, 27 November 2025 (CST)
'''<mark>Changes collectors need to know about:</mark>'''
* added new dx [[Transfer for bed management]] to [[s_ICD10 table]]
=== 2025-11-24-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:06, 26 November 2025 (CST)
Changes collectors '''don't''' need to know about:
* consolidated unrolled [[#2025-11-18]] with [[#2025-11-24]]
=== 2025-11-24 ===
rolled out [[User:Lkaita|Lisa Kaita]] 10:19, 24 November 2025 (CST)
'''<mark>Changes collectors need to know about:</mark>'''
* changed work distribution for GGH, G7 laptop will now be 00-19, and G8 will be 20-69
=== 2025-11-18 ===
not rolled out yet 12:31, 18 November 2025 (CST)
Changes collectors '''don't''' need to know about:
* updated COGNOS_Report_Processor.email_missing_services() and COGNOS_Report_Processor.email_missing_units(): added link to [[New unit or service encountered during Cognos data import]]
=== 2025-11-16 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 23:01, 16 November 2025 (CST)
* accidentally rolled out with version 2025-11-'''2'''6
'''<mark>Changes collectors need to know about:</mark>'''
* added options for [[Project NonTradLoc]] to [[s_tmp table]] [[User:Ttenbergen|Ttenbergen]] 22:49, 16 November 2025 (CST)
Changes collectors '''don't''' need to know about:
* inactivated a bunch of entries related to completed [[LAU Collection Project]] that were still active in [[s_tmp table]]
* changed sorting order to ''by project, item, order'' and set filter to hide inactive by default in table view for [[s_tmp table]]
=== 2025-10-24 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 01:04, 24 October 2025 (CDT)
Changes collectors don't need to know about:
* removed a reminder msg intended for myself that slipped out into production. ("still need to deal with... ") [[User:Ttenbergen|Ttenbergen]] 01:04, 24 October 2025 (CDT)
=== 2025-10-16 ===
rolled out 2025-10-22 without change to version number on program [[User:Ttenbergen|Ttenbergen]] 01:04, 24 October 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* GGH [[Project AHC]] - inactivated the "Addressed" options as well in  [[s_tmp table]]
* [[EuroSCORE II]] - added "Dr. Zelentsov" to "EuroSCORE II Phy" Study in [[s_tmp table]]
* added module z_segregated_constants to consolidate content that should not be part of version control
** moved all db connection constants and functionality into that module
* updated the version control content in [[_Global module]] to help with quicker, more comprehensive version control in [[Git repository]]
* replaced all calls to Left with Left$, Mid with Mid$, Right with Right$, Ucase to Ucase$, Format to Format$ for slight performance improvement
=== 2025-10-09 ===
rolled out [[User:Lkaita|Lisa Kaita]] 19:56, 9 October 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* GGH [[Project AHC]] - removed the "extra" options from [[S tmp table]]
=== 2025-09-28 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 22:12, 28 September 2025 (CDT)
Changes collectors don't need to know about:
* fixed [[Function long LOS()]]
* updated [[s_dispo.meanLOS3STD]]
* [[HSC Virtual Ward]]: confirmed ''"HSC Internal Med / Virtual Ward"'' in [[S Cognos Services table]] and ''"HSC-Virtual Ward MED1"'' in [[S Cognos Units table]]
=== 2025-09-27 ===
rolled out [[User:Lkaita|Lisa Kaita]] 21:06, 27 September 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* [[HSC Virtual Ward]]: added ''"HSC Internal Med / Virtual Ward"'' to the [[S Cognos Services table]] and ''"HSC-Virtual Ward MED1"'' to the [[S Cognos Units table]]
=== 2025-09-25 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 00:51, 26 September 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* added [["Teams Chat" button]]
=== 2025-09-23-1 ===
rolled out [[User:Lkaita|Lisa Kaita]] 13:08, 23 September 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* [[HSC Virtual Ward]]: added HSC-Virtual Ward MED1 to the [[S Cognos Units table]] and HSC Internal Med / Virtual Ward to the [[S Cognos Services table]]
=== 2025-09-23 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:56, 23 September 2025 (CDT)
Changes collectors '''don't''' need to know about:
* fix to error when clicking "?" button in CCIs
=== 2025-09-22 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:20, 22 September 2025 (CDT)
Changes collectors '''don't''' need to know about:
* tried to replicate error flagged by LK when "+" button is pressed on [[CSS]], was not getting the error in my version
* rolling out this version because I think Lisa may have had a different one somehow
* imported today's Cognos into my version before rolling so it should be good to test
=== 2025-09-22-1 ===
rolled out [[User:Lkaita|Lisa Kaita]] 14:46, 22 September 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* rolled out new version of CCMDB Microsoft office O365 which did not work
* changed the version of CCMDB to 2025-09-22-1 instead of 2025-08-22
=== 2025-09-22 ===
rolled out [[User:Lkaita|Lisa Kaita]] 14:18, 22 September 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* rolled out new version of CCMDB Microsoft office O365
=== 2025-09-19-1 ===
<mark>not rolled out yet [[User:Ttenbergen|Ttenbergen]] 09:49, 19 September 2025 (CDT)</mark>
'''Changes <mark>Grace collectors</mark> need to know about:'''
* [[Project Overstay2]] entries for continued admissions: <!-- https://github.com/squirrelslair/CCMDB/commit/cbf212a0950c6e30c1d45228f76d2633cae6298f -->
** added "continued" with sort order 40 to [[s_tmp table]]
** [[Overstay2 module]]; colour, colourname, score neutral
** confirmed [[query check_tmp_Overstay2]] not implemented yet, so nothing to check/fix there
Changes collectors '''don't''' need to know about:
* integrated Lisa's [[#2025-09-19]] into my in-progress [[#2025-09-18]]
* updated [[Overstay2 module]] to handle the new options "green-problem" and "continued"
=== 2025-09-19 ===
rolled out [[User:Lkaita|Lisa Kaita]] 09:07, 19 September 2025 (CDT)
'''Changes <mark>Grace collectors</mark> need to know about:'''
* [[Project Overstay2]] entries for green-problem admissions:
** added "green-problem" with sort order 50 to [[s_tmp table]]
=== 2025-09-18 ===
not rolled yet [[User:Ttenbergen|Ttenbergen]] 23:58, 18 September 2025 (CDT)
Changes collectors don't need to know about; these changes were being made as part of code review leading up to conversion to O365:
* replaced all "DoCmd.RunCommand acCmdSaveRecord" with "If Me.Dirty Then Me.Dirty = False" or equivalent
* added sub dump_all_VBA to module _global   
* removed call to handle_err from handle_err to prevent possible infinite loop
* added code to remove trailing blanks from column headers in Sub import_new_Cognos; our standard data contains these trailing blanks, Access 2019 stripped them implicitly, O365 requires explicit stripping
* changed "DoCmd.RunSQL ..." to "currentdb.execute ... , dbFailOnError" and removed corresponding docmd.setwarnings
setwarnings
=== 2025-09-16 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 00:54, 17 September 2025 (CDT)
'''Changes <mark>Grace collectors</mark> need to know about:'''
* [[Project Overstay2]] entries for continued admissions: <!-- https://github.com/squirrelslair/CCMDB/commit/cbf212a0950c6e30c1d45228f76d2633cae6298f -->
** added "continued" with sort order 40 to [[s_tmp table]]
** [[Overstay2 module]]; colour, colourname, score neutral
** confirmed [[query check_tmp_Overstay2]] not implemented yet, so nothing to check/fix there
=== 2025-09-08 ===
rolled out [[User:Lkaita|Lisa Kaita]] 10:57, 8 September 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* added GH Emergency / General, HSC Critical Care / HSC Adult Emergency, and HSC Emergency / HSC Adult Emergency to the [[S Cognos Services table]] and [[Service tmp entry]]
=== 2025-09-05 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 02:27, 5 September 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* removed automatic email generation for [[Project Overstay2]]
=== 2025-09-03 ===
rolled out [[User:Lkaita|Lisa Kaita]] 12:44, 3 September 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* added GH Surgery / Panel Appr Other, SBGH Emergency / General, SBGH Cardiac / Cardiac Cath Lab, to the [[S Cognos Services table]]
=== 2025-08-12 ===
rolled out [[User:Lkaita|Lisa Kaita]] 16:08, 12 August 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* added Dr. Michael Troncone to the Cardiac Surgeon [[EuroSCORE II]] dropdown list in [[S tmp]]
=== 2025-08-08 ===
rolled out [[User:Lkaita|Lisa Kaita]] 21:39, 8 August 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* added GH Surgery / Rehab Bed, HSC Surgery / Housing Other,  to the [[S Cognos Services table]] and SBGH Internal Med / Neurology to both [[S Cognos Services table]] and the [[Service tmp entry]]
=== 2025-07-09 ===
rolled out [[User:Lkaita|Lisa Kaita]] 14:44, 17 July 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* added [[Deer Lodge (DLC)]] as an [[Pre-admit Inpatient Institution]] in the [[S dispo table]]
<mark>Next update:
* check for duplicate and Overstay2 DPST not yet entered before generating overstay colour
</mark>
=== 2025-07-09 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 02:34, 12 July 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
Changes collectors '''don't''' need to know about:
* pulled in as changed for CFE validation: [[Global module]], [[Overstay2 module]]
* 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 [https://ccmdb.kuality.ca/index.php?title=Overstay2_scoring_model_for_Grace_Hospital&diff=164992&oldid=164664 this edit] to [[Overstay2 scoring model for Grace Hospital]]
* updated sub handle_err to show the collector-relevant content first, and the troubleshooting details only later
* [[Project AHC]] - added conditional formatting per allied health team: PT blue, OT yellow, SW green, HC red
=== 2025-07-08 ===
rollled out [[User:Ttenbergen|Ttenbergen]] 09:00, 9 July 2025 (CDT)
Changes collectors '''don't''' need to know about:
* function ward that had been used to pull location from [[Settings (CCMBD.mdb)]] before [[PatientFollow Project]] was still available but would now give wrong result, so removed functionality and set it to raise an error in case any queries use it. [[User:Ttenbergen|Ttenbergen]] 23:59, 8 July 2025 (CDT)
* added Function hosp_ID () since its counterpart Function Hosp() would only work on CCMDB by pulling from [[Settings (CCMBD.mdb)]]. To unify code in [[_Global module]], the same function must work in [[CCMDB.accdb]] and [[CFE]].
=== 2025-07-07 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 22:57, 7 July 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
Changes collectors '''don't''' need to know about:
* [[Project AHC]]
** cleaned up "active" and "auto" columns for the entries in [[s_tmp table]]
* [[Project Overstay2]]
** email and Notes field were still being populated with values used before the changes this weekend, so both said "not entered" and now say the colour that was scored [[User:Ttenbergen|Ttenbergen]] 22:42, 7 July 2025 (CDT)
** After problem report from collector, tested colour generation for a patient w green DPST form, and id worked as it should by returning a green record. [[User:Ttenbergen|Ttenbergen]] 22:46, 7 July 2025 (CDT)
=== 2025-07-04 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 04:41, 7 July 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* [[Project AHC]] updates to [[s_tmp table]]
** fixed spelling for item "addressed" for the AH_C_<allied health team>_A entries
*** one of them would have been available at all sites, limited that one to GRA
* retired the options AH_C_<allied health team> - not consulted, and created new ones for AH_C_<allied health team>_s
* [[Project Overstay2]]
** updated so green DPST form is reflected
Changes collectors '''don't''' need to know about:
* [[Project AHC]]
* Functions GCS_Eye_pts, GCS_Motor_pts, GCS_Verbal_pts: changed parameter type to variant to allow processing of null values with meaningful error
* changed error value constants Very_high_number -> 32767, Very_low_number -> –32768 so they won't overflow integer data types
* [[Project Overstay2]]
** substantial changes to make it possible to reflect the green form, had to change how parameters are handled for most functions for this project
=== 2025-07-03-2 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 22:44, 3 July 2025 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* [[Project AHC]]
** added entry "AH_C_<the allied health team>_s" and item "Referral sent" to [[s_tmp table]]
Changes collectors '''don't''' need to know about:
* [[Project AHC]]
** deleted duplicate option entry from [[s_tmp table]]


=== 2025-07-03-1 ===
=== 2025-07-03-1 ===
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Change_Log_2025"