CCMDB Wiki

CCMDB.accdb Change Log 2025: Difference between revisions

← Older edit
No edit summary
 
(141 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===
<!--=== 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-02-23 ===
=== 2025-09-28 ===
not rolled out yet [[User:Ttenbergen|Ttenbergen]] 10:56, 23 February 2025 (CST)
rolled out [[User:Ttenbergen|Ttenbergen]] 22:12, 28 September 2025 (CDT)
<!--'''<mark>Changes collectors need to know about:</mark>'''-->
 
Changes collectors don't need to know about:
* fixed [[Function long LOS()]]
* updated [[s_dispo.meanLOS3STD]]
* 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>'''
* 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>'''
 
*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 ===
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 ===
rolled out [[User:Lkaita|Lisa Kaita]] 12:25, 20 June 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* changed last digits 42, 43 from H7 laptop back to H4 laptop in the [[S PatientFollow distribution table]]
 
=== 2025-06-17 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:53, 17 June 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* changed the short for [[Province field]] in the [[S Provinces table]] for Quebec from "PQ" to '''"QC"''' as official; updated the Province dropdown in [[Patient Viewer Tab Dispo]] of [[Patient viewer]].
 
=== 2025-06-16 ===
rolled out [[User:Lkaita|Lisa Kaita]] 14:14, 16 June 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* suspended [[ACP Status Collection]] made inactive in [[S tmp table]] until we resolve collection items
 
=== 2025-06-11-1 ===
rolled out [[User:Lkaita|Lisa Kaita]] 10:48, 11 June 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* added auto add for ACP Last for all sites in [[S tmp table]]
 
=== 2025-06-11 ===
rolled out [[User:Lkaita|Lisa Kaita]] 09:37, 11 June 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* 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 [[User:Lkaita|Lisa Kaita]] 21:54, 10 June 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* added new tmp project [[ACP Status Collection]] in the [[S tmp table]]
 
=== 2025-05-05 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 12:54, 5 May 2025 (CDT)
 
* removed [[Liver dialysis]] from [[s_CCI_Picklist table]], was never used and caused confusion in data analysis.
* added "GH Surgery / Community Other" to [[s_Cognos_Services table]]
 
=== 2025-04-29 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 12:00, 29 April 2025 (CDT)
 
Changes collectors '''don't''' need to know about:
* added "GH Surgery / Housing Other" service to the [[s_Cognos_Services table]]
* added "HSC-JK3CHI" to the [[s_Cognos_Units table]]
 
=== 2025-04-16 ===
rolled out [[User:Ttenbergen|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:
{{Collapsable | * added LAU and GR entries at COH, SOH, VGH to [[s_level_of_care table]] | full=
* 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 [[User:Lkaita|Lisa Kaita]] 09:40, 16 April 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* added GH Surgery / Housing Other to the [[S Cognos Services table]] and HSC-JK3CHI to the [[S Cognos Units table]]
 
=== 2025-04-10 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:08, 10 April 2025 (CDT)
 
Changes collectors '''don't''' need to know about:
* updated [[Function Validate_DOB]] to generate meaningful error when tabbing out of [[Date of Birth]] if [[Visit Admit DtTm field]] has not been populated yet. [[User:Ttenbergen|Ttenbergen]] 15:06, 10 April 2025 (CDT)
 
=== 2025-04-09-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 18:46, 9 April 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* as per [[Task Team Meeting - Rolling Agenda and Minutes 2025#ICU Database Task Group Meeting – April 8, 2025 | Task]], changed names of dxs in [[:Category:Electrolyte disturbance]] to remove the "severe or symptomatic", making them:
**[[Hyponatremia / hypoosmolarity]] 
**[[Hypernatremia / hyperosmolarity]]
**[[Hypokalemia]]
**[[Hyperkalemia]]
**[[Hypocalcemia]]
**[[Hypercalcemia]]
**[[Hypomagnesemia]]
**[[Hypermagnesemia]]
**[[Hypophosphatemia]]
* tested that import of corrected Cognos data works
 
=== 2025-04-09 ===
rolled out [[User:Lkaita|Lisa Kaita]] 05:58, 9 April 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* retired [[Hypoalbuminemia, severe]] as per [[Task Team Meeting - Rolling Agenda and Minutes 2025#ICU Database Task Group Meeting – April 8, 2025 | Task]]
 
=== 2025-03-22 ===
rolled out [[User:Lkaita|Lisa Kaita]] 20:45, 23 March 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* added SBGH Palliative Care / Cardiac Surgery service to the [[S Cognos Services table]]
 
=== 2025-03-17 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 12:20, 17 March 2025 (CDT)
 
Changes collectors '''don't''' need to know about:
* [[Service/Location_field#Adding_a_new_service/location_entry]] - Shortened the "xxx_Geriatrics" entries in [[Service/Location]] to "xxx_Geri" to avoid one cause for [[Error "Invalid SQL statment..." when sending]]
 
=== 2025-03-15 ===
rolled out [[User:Lkaita|Lisa Kaita]] 19:48, 15 March 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* added the following new services to [[S Cognos Services table]] and the [[Service tmp entry]]
**GH Medicine / Addictions Centre
**HSC Medicine-ClinAs / Panel Appr CC
 
Changes collectors '''don't''' need to know about:
* [[LAU Collection Project]]:
** added [[s_tmp table]] entries for [[LAU Public Trustee]] and [[LAU LTC consult]]
 
=== 2025-03-14-1 ===
Copied to Server [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 17:09, 14 March 2025 (CDT)
* [[query check_Project_Consults_data]] - tweak to allow blank date and time when there is no consult
 
=== 2025-03-14 ===
rolled out [[User:Lkaita|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 [[User:Ttenbergen|Ttenbergen]] 01:32, 12 March 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* [[dispo]] [[s_dispo table]] - granularity [[Discharged to community]]:
**  added "TRSF Group/Supportive housing", "TRSF to Correctional Facility", "Home with Support Services"
* [[LAU Collection Project]]:
** [[dispo]] [[s_dispo table]] - VGH_LAU, VGH_Geriatrics, COH_LAU, SOH_LAU, SOH_Geriatrics
** [[LAU OT/PT consults]]
 
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. [[User:Ttenbergen|Ttenbergen]] 16:11, 11 March 2025 (CDT)
 
=== 2025-03-11 ===
Rolled out [[User:Ttenbergen|Ttenbergen]] 01:21, 11 March 2025 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* Changed to [[:Category:Potential trauma]] since they can be non-traumatic diagnoses as well; updated in [[s_ICD10_Categories table]] as well:
** {{ICD10WithCode|Eye, foreign body in}}
** {{ICD10WithCode|Ear, foreign body in}}
** {{ICD10WithCode|Genitorurinary tract, foreign body in}}
** {{ICD10WithCode|Gastrointestinal (GI) tract, foreign body in}}
* confirmed already in that category
** {{ICD10WithCode|Respiratory tract, foreign body in}} - was already
 
=== 2025-03-09 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 22:37, 9 March 2025 (CDT)
 
Changes collectors '''don't''' need to know about:
* [[LAU_collection_readmission_data]] - added no-record cross-check
 
=== 2025-03-07-2 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 22:02, 7 March 2025 (CST)
 
Changes collectors '''don't''' need to know about:
* [[Project Consults data]] - added “no consult” to [[s_tmp table]] for SOH-UC, COH-UC and VGH-UC to satisfy [[Query check Project Consults data]]
 
=== 2025-03-07-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 14:43, 7 March 2025 (CST)
 
Changes collectors '''don't''' need to know about:
* added [[Boarding Loc]] entries to [[s_tmp table]] for SOH-UC, COH-UC and VGH-UC
 
=== 2025-03-07 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:27, 7 March 2025 (CST)
 
Changes collectors '''don't''' need to know about:
* fixed call to [[query check_LAU_collection_readmission_data]] that generated error that the db can't find the input table "LAU_collection_readmission_data"
 
=== 2025-03-06 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 23:29, 6 March 2025 (CST)
 
Changes collectors '''don't''' need to know about:
* in preparation for [[LAU Collection Project]]:
** updated Sub Legacy_Hider() so it will treat ''Program = "LAU"'' the same as ''Program = "LAU"''; without this, forms that are visible for only either CC or Med would not be visible for LAU records.
*** '''this was reverted pending the outcome of [[LAU_Collection_Project#possible_problems_using_program_=_"LAU"]]'''
** [[Project Consults data]]
*** added automatic "not entered" record to [[s_tmp table]]
*** added [[Query check Project Consults data]]
** [[ACP Status Collection]]
*** added options to [[s_tmp table]]
*** added [[query check ACP Status Collection]]
** [[LAU collection readmission data]]
*** added [[query check_LAU_collection_readmission_data ]]
* added as a mostly-twin of "home" to [[s_dispo table]], but making it available only for [[dispo]].
** TRSF Group/Supportive housing
** TRSF to Correctional Facility
** Home with supports
 
=== 2025-03-04 ===
copied to server, asking Lisa to roll out after re-importing Cognos [[User:Ttenbergen|Ttenbergen]] 09:40, 5 March 2025 (CST)
 
Changes collectors '''don't''' need to know about:
* added data items for [[LAU Collection Project]] to [[s_tmp table]]:
** [[Project Consults data]]
** [[LAU collection readmission data]]
* updated "Hosp" dropdown in [[s_tmp table]] to current official values for Oaks, Conc and Vic: "COH";"SOH";"VGH"
 
=== 2025-03-03 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 02:00, 4 March 2025 (CST)


Changes collectors '''don't''' need to know about:
Changes collectors '''don't''' need to know about:
* updated module Overstay2 to unify the code in [[CCMDB.accdb]] and [[Centralized data front end.accdb]]; updated [[git repository]]
* further prep for [[Project Overstay2]]: updated modules overstay2 and _Global with same changes as in CFE after update to ensure same overstay score as Julie
* added data items for [[LAU Collection Project]]
** to [[S dispo table]]: VGH_LAU, SOH_LAU, COH_LAU
** to [[S tmp table]]: the specific units listed on [[LAU Collection Project]]
 
=== 2025-02-28-1 ===
[[User:Lkaita|Lisa Kaita]] 12:22, 28 February 2025 (CST)
'''<mark>Changes collectors need to know about:</mark>'''
* retired ICD 10 [[Past history of Covid-19 infection]] from [[S ICD10 table]]  
* corrected my mistake reactivated COVID 19 infection and retired the appropriate one
 
=== 2025-02-28 ===
rolled out [[User:Lkaita|Lisa Kaita]] 09:12, 28 February 2025 (CST)
'''<mark>Changes collectors need to know about:</mark>'''
* retired ICD 10 [[Past history of Covid-19 infection]] from [[S ICD10 table]]


=== 2025-02-20 ===
=== 2025-02-20 ===
Line 98: Line 632:


'''<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 106: Line 640:
* 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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Change_Log_2025"