CCMDB.accdb Change Log 2025: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
 
(65 intermediate revisions by 2 users not shown)
Line 4: Line 4:
<!--'''<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-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 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:11, 3 July 2025 (CDT)
 
<!--<mark>Changes collectors need to know about:</mark>'''-->
Changes collectors '''don't''' need to know about:
* [[Project Overstay2]] - reinstated the "Overstay2 DPST" - "not yet entered" entry and made it automatic for new patients.
 
=== 2025-07-03 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 14:10, 3 July 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* [[Project AHC]]:
** added Item "not ready for AH assessment" for all AH disciplines' "O" entries [[User:Ttenbergen|Ttenbergen]] 13:59, 3 July 2025 (CDT)
<!--Changes collectors '''don't''' need to know about:-->
 
=== 2025-07-02 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 00:23, 3 July 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
<!--Changes collectors '''don't''' need to know about:-->
* added tmp entries for [[Project AHC]] [[User:Ttenbergen|Ttenbergen]] 00:23, 3 July 2025 (CDT)
 
=== 2025-07-01-1===
rolled out[[User:Lkaita|Lisa Kaita]] 17:04, 2 July 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* added  HSC Critical Care / Panel Appr Other to [[S tmp]] and [[S Cognos Services table]]
 
=== 2025-07-01 ===
rolled out[[User:Ttenbergen|Ttenbergen]] 00:24, 2 July 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* [[Project Overstay2]] - added [[Project Overstay2#Overstay2 Screening Reports | automatic email]] automatic email generation to the end of [[Overstay2 colour]] making.
 
=== 2025-06-23 ===
rolled out [[User:Ttenbergen|Ttenbergen]] ~2025-06-30 late night
 
'''<mark>Changes collectors need to know about:</mark>'''
* [[Change to coding locations for Decubitus Ulcers]]
** added location specific codes
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage I (surface reddening), of sacral area}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage I (surface reddening), of heel}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage I (surface reddening), of other area}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage II (to fascia, just under skin), of sacral area}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage II (to fascia, just under skin), of heel}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage II (to fascia, just under skin), of other area}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage III (deep, to but not including muscle), of sacral area}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage III (deep, to but not including muscle), of heel}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage III (deep, to but not including muscle), of other area}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage IV (involves bone), of sacral area}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage IV (involves bone), of heel}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage IV (involves bone), of other area}}
***{{ICD10WithCode|Pressure-induced deep tissue damage, of sacral area}}
***{{ICD10WithCode|Pressure-induced deep tissue damage, of heel}}
***{{ICD10WithCode|Pressure-induced deep tissue damage, of other area}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, stage not indicated, of sacral area}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, stage not indicated, of heel}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, stage not indicated, of other area}}
** retired non-location-specific codes
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage I (surface reddening)}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage II (to fascia, just under skin)}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage III (deep, to but not including muscle)}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, Stage IV (involves muscle, tendon, or bone)}}
***{{ICD10WithCode|Decubitus (pressure) ulcer, stage not indicated}}
 
Changes collectors '''don't''' need to know about:
* added "HSC-CMS3S Ped Surgery Day Unit" to [[S Cognos Units table]]
* changes for [[Project Overstay2]]
** updated [[Overstay2 module]]
*** changes to [[Overstay2 scoring model for Grace Hospital]]
***
** added rows to [[s_tmp table]]:
*** Project "Overstay2" with items "Overstay Colour", "Overstay Score" to [[s_tmp table]]
*** Project "Overstay2 DPST" with items green, non-green, problem
** updated query check_tmp_generate_allowed that is used by [[Function GenerUpdate_tmp_entry]] to test that an auto entry is allowed; it would not have worked since we did our location changes
* pulled in updated unified [[_Global module]] with added Sub ListModuleEntities
* added Sub DumpAllQueries_UTF8() to [[_Global module]] to document queries in git
 
=== 2025-06-20 ===
=== 2025-06-20 ===
rolled out [[User:Lkaita|Lisa Kaita]] 12:25, 20 June 2025 (CDT)
rolled out [[User:Lkaita|Lisa Kaita]] 12:25, 20 June 2025 (CDT)
Line 353: Line 574:


'''<mark>Changes collectors need to know about:</mark>'''
'''<mark>Changes collectors need to know about:</mark>'''
* deactivated the [[Project AHC|allied health care project]] in the [[S tmp]]
* deactivated the [[Project AHC (LAU)|allied health care project]] in the [[S tmp]]


===2025-01-08===
===2025-01-08===
Line 361: Line 582:
* updated [[query check_tmp_BedHeld]] to also flag if record has [[Dispo]]="AMA (left against medical advice)" but no [[BedHeldEnd DtTm]] entry
* updated [[query check_tmp_BedHeld]] to also flag if record has [[Dispo]]="AMA (left against medical advice)" but no [[BedHeldEnd DtTm]] entry
* soft checks like [[query check_CCI_each_count_vs_LOS]] were being triggered last in the error checks, meaning that they would overrule hard checks that also triggered.
* soft checks like [[query check_CCI_each_count_vs_LOS]] were being triggered last in the error checks, meaning that they would overrule hard checks that also triggered.
** changed the order of cross checks in Public Sub Dx_Checker() to do soft ones first so that hard ones would not be overwritten by soft ones  
** changed the order of [[cross check]]s in Public Sub Dx_Checker() to do soft ones first so that hard ones would not be overwritten by soft ones  
** this would have affected queries that, on this date, matched the query underlying the following list (data on wiki changes so if you look in the future this might be different)
** this would have affected queries that, on this date, matched the query underlying the following list (data on wiki changes so if you look in the future this might be different)
{{#cargo_query:
{{#cargo_query:

Latest revision as of 11:51, 19 September 2025

See Log (disambiguation) for other uses of the term "Log". See the 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.

2025-09-19-1

not rolled out yet Ttenbergen 09:49, 19 September 2025 (CDT)

Changes Grace collectors need to know about:

Changes collectors don't need to know about:

2025-09-19

rolled out Lisa Kaita 09:07, 19 September 2025 (CDT)

Changes Grace collectors need to know about:

2025-09-18

not rolled yet 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 Ttenbergen 00:54, 17 September 2025 (CDT)

Changes Grace collectors need to know about:

2025-09-08

rolled out Lisa Kaita 10:57, 8 September 2025 (CDT)

Changes collectors need to know about:

2025-09-05

rolled out Ttenbergen 02:27, 5 September 2025 (CDT)

Changes collectors need to know about:

2025-09-03

rolled out Lisa Kaita 12:44, 3 September 2025 (CDT)

Changes collectors need to know about:

  • 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 Lisa Kaita 16:08, 12 August 2025 (CDT)

Changes collectors need to know about:

  • added Dr. Michael Troncone to the Cardiac Surgeon EuroSCORE II dropdown list in S tmp

2025-08-08

rolled out Lisa Kaita 21:39, 8 August 2025 (CDT)

Changes collectors need to know about:

2025-07-09

rolled out Lisa Kaita 14:44, 17 July 2025 (CDT)

Changes collectors need to know about:


Next update:

  • check for duplicate and Overstay2 DPST not yet entered before generating overstay colour

2025-07-09

rolled out Ttenbergen 02:34, 12 July 2025 (CDT)

Changes collectors need to know about:

Changes collectors don't need to know about:

  • pulled in as changed for CFE validation: Global module, Overstay2 module
  • updated Overstay2 module
  • 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 Ttenbergen 09:00, 9 July 2025 (CDT)

Changes collectors don't need to know about:

2025-07-07

rolled out Ttenbergen 22:57, 7 July 2025 (CDT)

Changes collectors need to know about:

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 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. Ttenbergen 22:46, 7 July 2025 (CDT)

2025-07-04

rolled out Ttenbergen 04:41, 7 July 2025 (CDT)

Changes collectors need to know about:

  • 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 Ttenbergen 22:44, 3 July 2025 (CDT)

Changes collectors need to know about:

Changes collectors don't need to know about:

2025-07-03-1

rolled out Ttenbergen 15:11, 3 July 2025 (CDT)

Changes collectors don't need to know about:

  • Project Overstay2 - reinstated the "Overstay2 DPST" - "not yet entered" entry and made it automatic for new patients.

2025-07-03

rolled out Ttenbergen 14:10, 3 July 2025 (CDT)

Changes collectors need to know about:

  • Project AHC:
    • added Item "not ready for AH assessment" for all AH disciplines' "O" entries Ttenbergen 13:59, 3 July 2025 (CDT)

2025-07-02

rolled out Ttenbergen 00:23, 3 July 2025 (CDT)

Changes collectors need to know about:

2025-07-01-1

rolled outLisa Kaita 17:04, 2 July 2025 (CDT)

Changes collectors need to know about:

2025-07-01

rolled outTtenbergen 00:24, 2 July 2025 (CDT)

Changes collectors need to know about:

2025-06-23

rolled out Ttenbergen ~2025-06-30 late night

Changes collectors need to know about:

Changes collectors don't need to know about:

2025-06-20

rolled out Lisa Kaita 12:25, 20 June 2025 (CDT)

Changes collectors need to know about:

2025-06-17

rolled out Ttenbergen 16:53, 17 June 2025 (CDT)

Changes collectors need to know about:

2025-06-16

rolled out Lisa Kaita 14:14, 16 June 2025 (CDT)

Changes collectors need to know about:

2025-06-11-1

rolled out Lisa Kaita 10:48, 11 June 2025 (CDT)

Changes collectors need to know about:

  • added auto add for ACP Last for all sites in S tmp table

2025-06-11

rolled out Lisa Kaita 09:37, 11 June 2025 (CDT)

Changes collectors need to know about:

  • added ACP last- ACP C in dropdown for HSC in the S tmp table, had two STB the first time

2025-06-10

rolled out Lisa Kaita 21:54, 10 June 2025 (CDT)

Changes collectors need to know about:

2025-05-05

rolled out Ttenbergen 12:54, 5 May 2025 (CDT)

2025-04-29

rolled out Ttenbergen 12:00, 29 April 2025 (CDT)

Changes collectors don't need to know about:

2025-04-16

rolled out Ttenbergen 09:05, 22 April 2025 (CDT) ( may not have the right version stamp in file, but I did roll out)

Changes collectors don't need to know about:

click expand to see content   
  • COH-N1N - 40
  • COH-N3E - 40
  • COH-N3W - 40
  • COH-UC - 80
  • HSC-GA3 - 50
  • HSC-GH6B - 50
  • HSC-NDWRS2 - 50
  • SBGH_L2CC - 90
  • SOH-3A10 - 40
  • SOH-3A11 - 40
  • SOH-3A12 - 40
  • SOH-3BU1 - 40
  • SOH-3BU2 - 40
  • SOH-3BU3 - 40
  • SOH-3BU4 - 40
  • SOH-3BU5 - 40
  • SOH-3BU6 - 40
  • SOH-3BU7 - 40
  • SOH-4AU11 - 40
  • SOH-4AU12 - 40
  • SOH-4AU8 - 40
  • SOH-4AU9 - 40
  • SOH-4BU4 - 40
  • SOH-4BU5 - 40
  • SOH-4BU6 - 40
  • SOH-4BU7 - 40
  • SOH-5BU1 - 40
  • SOH-5BU2 - 40
  • SOH-5BU3 - 40
  • SOH-5BU4 - 40
  • SOH-5BU5 - 40
  • SOH-5BU6 - 40
  • SOH-5BU7 - 40
  • SOH-UC - 80
  • STB_A7S - 50
  • VGH-NU4N - 40
  • VGH-NU4S - 40
  • VGH-NU5N - 40
  • VGH-NU5S - 40
  • VGH-UC - 80

2025-04-16

rolled out Lisa Kaita 09:40, 16 April 2025 (CDT)

Changes collectors need to know about:

2025-04-10

rolled out Ttenbergen 15:08, 10 April 2025 (CDT)

Changes collectors don't need to know about:

2025-04-09-1

rolled out Ttenbergen 18:46, 9 April 2025 (CDT)

Changes collectors need to know about:

2025-04-09

rolled out Lisa Kaita 05:58, 9 April 2025 (CDT)

Changes collectors need to know about:

2025-03-22

rolled out Lisa Kaita 20:45, 23 March 2025 (CDT)

Changes collectors need to know about:

2025-03-17

rolled out Ttenbergen 12:20, 17 March 2025 (CDT)

Changes collectors don't need to know about:

2025-03-15

rolled out Lisa Kaita 19:48, 15 March 2025 (CDT)

Changes collectors need to know about:

Changes collectors don't need to know about:

2025-03-14-1

Copied to Server Ttenbergen 17:09, 14 March 2025 (CDT) Only Lisa needs this fix, so it doesn't need a full roll-out as long as Lisa is the next to push Cognos when we get that working. Ttenbergen 17:09, 14 March 2025 (CDT)

2025-03-14

rolled out Lisa Kaita 11:37, 14 March 2025 (CDT)

Changes collectors don't need to know about:

  • fixed typo in module converter that was giving an error when generating an Overstay2 colour

2025-03-11-1

rolled out Ttenbergen 01:32, 12 March 2025 (CDT)

Changes collectors need to know about:

Changes collectors don't need to know about:

  • disabled Function program() which used to get its value from the a_info settings table; superseded by Function admission_program(Pat ID) but had left it with a meaningful error in case it gets triggered somewhere I had not found. Ttenbergen 16:11, 11 March 2025 (CDT)

2025-03-11

Rolled out Ttenbergen 01:21, 11 March 2025 (CDT)

Changes collectors need to know about:

2025-03-09

rolled out Ttenbergen 22:37, 9 March 2025 (CDT)

Changes collectors don't need to know about:

2025-03-07-2

rolled out Ttenbergen 22:02, 7 March 2025 (CST)

Changes collectors don't need to know about:

2025-03-07-1

rolled out Ttenbergen 14:43, 7 March 2025 (CST)

Changes collectors don't need to know about:

2025-03-07

rolled out Ttenbergen 09:27, 7 March 2025 (CST)

Changes collectors don't need to know about:

2025-03-06

rolled out Ttenbergen 23:29, 6 March 2025 (CST)

Changes collectors don't need to know about:

2025-03-04

copied to server, asking Lisa to roll out after re-importing Cognos Ttenbergen 09:40, 5 March 2025 (CST)

Changes collectors don't need to know about:

2025-03-03

rolled out Ttenbergen 02:00, 4 March 2025 (CST)

Changes collectors don't need to know about:

2025-02-28-1

Lisa Kaita 12:22, 28 February 2025 (CST) Changes collectors need to know about:

2025-02-28

rolled out Lisa Kaita 09:12, 28 February 2025 (CST) Changes collectors need to know about:

2025-02-20

rolled out Ttenbergen 15:55, 20 February 2025 (CST)

Changes collectors don't need to know about:

  • Prep for Project Overstay2
    • changed the test entry in s_tmp table to match what the button generates; the previous value it entered was generating errors on sending because there was no corresponding value in s_tmp

2025-02-11

(Tina copied to server, Pagasa rolled it out) Ttenbergen 15:25, 12 February 2025 (CST) Changes collectors need to know about:

  • added OS button to patient viewer form; it will eventually be used to generate colours for Project Overstay2; instructions to follow.

Changes collectors don't need to know about:

  • changed to restore .dirty instead of DoCmd.RunCommand acCmdSaveRecord
    • Function uncheck_reg() x2
  • Prep for Project Overstay2
    • added Overstay2, Overstay result to s_tmp table
    • added OS button
      • added code to colour the button
    • added code to run when the button is clicked to Module Overstay2
  • updated Sub GenerUpdate_tmp_entry to use Function runQuery instead of runsql
  • changed to form_Current to run later, once pat_ID is initialized
  • removed Function adl_sc - appears not to be used; use query adl_scores as needed
  • moved function db_local from _global to _unique_cfe, only used there to open with parameter
  • updated functions GCS_*_pts() to return integer with very high number if there is an error; improved error handling
  • merged in #2025-02-09
  • update all s_tmp entries for Boarding Loc to have MCHP=true (were inconsistent before)

2025-02-09

Changes collectors need to know about:

2025-02-06

rolled out Ttenbergen 12:56, 6 February 2025 (CST)

Changes collectors don't need to know about:

  • Sub Dx_Checker() - 2x changed DoCmd.RunCommand acCmdSaveRecord back to Form_View.Dirty = False

2025-02-05

rolled out Ttenbergen 10:02, 5 February 2025 (CST)

Changes collectors don't need to know about:

  • reverted a change to form CCI_Component_Chooser that caused error when picking a component
  • reverted a change to function CADT_populate that caused error when clicking "Unit End DtTm" to populate Dispo_DtTm.

2025-01-28

rolled out Ttenbergen 13:19, 4 February 2025 (CST)

Changes collectors need to know about:

  • added new Cognos entry for SBGH-L2CC

Changes collectors don't need to know about:

  • Adding background functionality for Project Overstay2
    • Module Overstay2 - code to generate the score with current dataset
  • updated query L_ICD10_Charlson_agepts - it was still using Arrive DtTm and now uses created_AdmitDtTm query. Ttenbergen 10:39, 28 January 2025 (CST)
  • updated Charlson_score_function to use a variant for ID, and updated it so it will work with either D_ID or Pat_ID (ie will work for CCMDB or CFE). Ttenbergen 12:15, 28 January 2025 (CST)
  • added some functionality to be able to use code and queries in both CCMDB and CFE:
    • Module Global_
      • Const DB_ID to set CFE / CCMDB
      • Function ID_name() to give "Pat_ID" for CCMDB and "D_ID" for CFE
      • Function ID_query(ID) to expand into appropriate query strings for the two DBs based on DB_ID
      • Function Charlson_score_function() to use ID_query()
      • updated ExistsTable() with cleaner code
      • added sub handle_err()
      • added public constants minage and maxage to make sure we are always using the same
  • updated Function Validate_DOB() to use same minage/maxage and CCMDB_Age()
  • replaced all "<form name>.Dirty = False" with "DoCmd.RunCommand acCmdSaveRecord" since that is more reliable
  • found that after_update events had got disconnected for fields DOB, Sex, Record on form_view; this means that it would have been possible to run the complete check, pass it, then enter a value that should fail, and not have the complete unchecked; re-connected them
  • added new Cognos entries:

2025-01-20

rolled out Lisa Kaita 19:38, 20 January 2025 (CST)

Changes collectors need to know about:

2025-01-08

rolled out Ttenbergen 15:06, 8 January 2025 (CST)

Changes collectors don't need to know about:

  • updated query check_tmp_BedHeld to also flag if record has Dispo="AMA (left against medical advice)" but no BedHeldEnd DtTm entry
  • soft checks like query check_CCI_each_count_vs_LOS were being triggered last in the error checks, meaning that they would overrule hard checks that also triggered.
    • changed the order of cross checks in Public Sub Dx_Checker() to do soft ones first so that hard ones would not be overwritten by soft ones
    • this would have affected queries that, on this date, matched the query underlying the following list (data on wiki changes so if you look in the future this might be different)
_pageName Status Firmness
Function long LOS() needs review soft check
Link suspect mismatch pre inpt ours incomplete query implemented soft check
Link suspect not same visitAdmitDtTm query implemented soft check
PL DiffPhin SameLN FN DOB implemented soft check
PL SamePHIN Site Diff chart implemented soft check
Query check CCI each count vs LOS needs review soft check
Query check CCI TISS discontinuous ETT implemented soft check
Query check ICD10 ESRD and AKI only if transplant implemented soft check
Query check ICD10 trach has trach but no TISS implemented soft check
Query check long transfer delay needs review soft check
Query check pt from ER implemented soft check
Query Check VADT too close to first boarding loc needs review soft check
Query s tmp Boarding Loc ER delay reasonable implemented soft check

2024-...

Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Change_Log_2025&oldid=167593"