CCMDB.accdb Change Log 2025: Difference between revisions

(119 intermediate revisions by 2 users not shown)

Line 1:

__NOTOC__

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-11-27 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 22:38, 27 November 2025 (CST)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* 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

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* [[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)

'''Changes collectors need to know about:'''

* added [["Teams Chat" button]]

=== 2025-09-23-1 ===

rolled out [[User:Lkaita|Lisa Kaita]] 13:08, 23 September 2025 (CDT)

'''Changes collectors need to know about:'''

* [[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)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* rolled out new version of CCMDB Microsoft office O365

=== 2025-09-19-1 ===

not rolled out yet [[User:Ttenbergen|Ttenbergen]] 09:49, 19 September 2025 (CDT)

'''Changes Grace collectors need to know about:'''

* [[Project Overstay2]] entries for continued admissions:

** 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 Grace collectors 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 Grace collectors need to know about:'''

* [[Project Overstay2]] entries for continued admissions:

** 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)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* removed automatic email generation for [[Project Overstay2]]

=== 2025-09-03 ===

rolled out [[User:Lkaita|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 [[User:Lkaita|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 [[User:Lkaita|Lisa Kaita]] 21:39, 8 August 2025 (CDT)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* added [[Deer Lodge (DLC)]] as an [[Pre-admit Inpatient Institution]] in the [[S dispo table]]

Next update:

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

=== 2025-07-09 ===

rolled out [[User:Ttenbergen|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]]

** 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)

'''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 [[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)

'''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 [[User:Ttenbergen|Ttenbergen]] 22:44, 3 July 2025 (CDT)

'''Changes collectors need to know about:'''

* [[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)

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)

'''Changes collectors need to know about:'''

* [[Project AHC]]:

** added Item "not ready for AH assessment" for all AH disciplines' "O" entries [[User:Ttenbergen|Ttenbergen]] 13:59, 3 July 2025 (CDT)

=== 2025-07-02 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 00:23, 3 July 2025 (CDT)

'''Changes collectors 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)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* [[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

'''Changes collectors need to know about:'''

* [[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)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* 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)

'''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 [[User:Lkaita|Lisa Kaita]] 21:54, 10 June 2025 (CDT)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* 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 ===

~~not~~ rolled out ~~yet~~ [[User:Ttenbergen|Ttenbergen]] 18:28, 9 April 2025 (CDT)

rolled out [[User:Ttenbergen|Ttenbergen]] 18:46, 9 April 2025 (CDT)

'''Changes collectors need to know about:'''

Line 18:

Line 463:

**[[Hypomagnesemia]]

**[[Hypermagnesemia]]

**[[~~Hypophosphotemia~~]]

**[[Hypophosphatemia]]

* tested that import of corrected Cognos data works

=== 2025-04-09 ===

Line 120:

Line 566:

*** added automatic "not entered" record to [[s_tmp table]]

*** added [[Query check Project Consults data]]

** [[ACP Status Collection ~~for LAU~~]]

** [[ACP Status Collection]]

*** added options to [[s_tmp table]]

*** added [[query check ACP Status Collection ~~for LAU~~]]

*** added [[query check ACP Status Collection]]

** [[LAU collection readmission data]]

*** added [[query check_LAU_collection_readmission_data ]]

Line 245:

Line 691:

'''Changes collectors need to know about:'''

* 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===

Line 253:

Line 699:

* 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

** 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)

{{#cargo_query:

@@ Line 1: / Line 1: @@
 __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]]'''.
+===next===
+<!--not rolled out yet -->
 <!--=== 2025-xx ===
 <!--'''<mark>Changes collectors need to know about:</mark>'''-->
 <!--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 ===
+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 ===
-not rolled out yet [[User:Ttenbergen|Ttenbergen]] 18:28, 9 April 2025 (CDT)
+rolled out [[User:Ttenbergen|Ttenbergen]] 18:46, 9 April 2025 (CDT)
 '''<mark>Changes collectors need to know about:</mark>'''
@@ Line 18: / Line 463: @@
 **[[Hypomagnesemia]]
 **[[Hypermagnesemia]]
-**[[Hypophosphotemia]]
+**[[Hypophosphatemia]]
+* tested that import of corrected Cognos data works
 === 2025-04-09 ===
@@ Line 120: / Line 566: @@
 *** added automatic "not entered" record to [[s_tmp table]]
 *** added [[Query check Project Consults data]]
-** [[ACP Status Collection for LAU]]
+** [[ACP Status Collection]]
 *** added options to [[s_tmp table]]
-*** added [[query check ACP Status Collection for LAU]]
+*** added [[query check ACP Status Collection]]
 ** [[LAU collection readmission data]]
 *** added [[query check_LAU_collection_readmission_data ]]
@@ Line 245: / Line 691: @@
 '''<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===
@@ Line 253: / Line 699: @@
 * 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
+** 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)
 {{#cargo_query: