CCMDB.accdb Change Log 2026
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.
next
2026-05-29
rolled out Lisa Kaita 21:57, 29 May 2026 (CDT)
- added the following services to S_Cognos_Services_table GH Palliative Care / Panel Appr Other
- HSC Mental Health / Housing Other, HSC Critical Care / Panel Appr PCH
- SBGH patient follow assignment changes as follows (to accommodate EFT changes)
- S4 02-16 new 0-11
- S5 17-33 new 12-23
- S6 34-50 new 24-41
- S7 51-68 new 42-64
- S8 69-86 new 65-87
- S9 001, 87-99 new 88-99
2026-05-11
rolled out yet Lisa Kaita 08:35, 11 May 2026 (CDT)
Changes collectors don't need to know about:
- found out that isNumeric() doesn't prevent leading whitespaces or leading 0s so implemented IsReallyNumeric()
- updated Function Validate Chart, Function Validate_GCS_Eye, Function Validate_GCS_Motor, Function Validate_GCS_Verbal to use the new IsRealNumeric()
2026-05-08-2
not rolled out yet Ttenbergen 10:46, 8 May 2026 (CDT) copied to server for Lisa to test...
Integrating changes from #2026-05-08 and #2026-05-07
2026-05-08
- rolled out Lisa Kaita 09:54, 8 May 2026 (CDT)
Changes collectors need to know about:
- added chart 12,13,14 to the s_PatientFollow_distribution table table for H3 laptop, deleted same from the H4 laptop, this will begin may 11, 2026
- added GH Sugery/other ALC to the s_Cognos_Services table
- added HSC RR RR132 Physio to the s_Cognos_Units table
2026-05-07
not rolled out yet Ttenbergen 22:54, 7 May 2026 (CDT)
Changes collectors don't need to know about:
- found out that isNumeric() doesn't prevent leading whitespaces or leading 0s so implemented IsReallyNumeric()
- updated Function Validate Chart, Function Validate_GCS_Eye, Function Validate_GCS_Motor, Function Validate_GCS_Verbal to use the new IsRealNumeric()
2026-04-14
(was actually rolled out I think..) Ttenbergen 10:04, 20 April 2026 (CDT)
Changes collectors need to know about:
- updated MR Organizer form sort buttons for the new "program" field to actually sort that field
- updated query Patient_List used by the sort buttons to contain the Program field.
2026-04-10
Rolled out Ttenbergen 18:17, 10 April 2026 (CDT)
Changes collectors need to know about:
- updated MR Organizer form (and underlying query Query form MR organizer) to include Program to make it easier for collectors to prioritize finishing charts for a program as requested by the Statistician.
2026-03-10
Rolled out Lisa Kaita 09:53, 10 March 2026 (CDT) Changes collectors need to know about:
- added Eden health centre to s_dispo table , and added new location type to s_dispo table Mental Health
2026-03-04
Rolled out Lisa Kaita 19:04, 4 March 2026 (CST) Changes collectors need to know about:
- added HSC-RR RR445 Plastics to the s_Cognos Units table
2026-02-02
Rolled out Ttenbergen 00:34, 2 February 2026 (CST) Changes collectors need to know about:
- inactivated s_tmp table entries for Project NonTradLoc
Changed collectors don't need to know about:
- tried to download the 01-28 version and it was corrupted, requiring close on exit. It was also huge, so I am reverting to 2025-12-22, which is the last one that works.
- reapplied the inactivation of s_tmp table entries for #2026-01-23:
- STB - ER
- STB - recovery
- STB_ACCU
- STB_B5
- STB_CICU
- STB_E5
- STB_Med
- STB_Med
- STB_MICU
- Added "GH Medicine/Other ALC" to Service tmp entry
2026-01-28
rolled out Lisa Kaita 09:48, 28 January 2026 (CST)
Changes collectors need to know about:
- corrected Start date Tm for GH Medicine/Other ALC to the Service tmp entry
2026-01-27
rolled out Lisa Kaita 14:19, 27 January 2026 (CST)
Changes collectors need to know about:
- corrected uppercase letter for GH Medicine/Other ALC to the Service tmp entry
2026-01-26
rolled out Lisa Kaita 13:53, 23 January 2026 (CST)
Changes collectors need to know about:
- added GH Medicine/other ALC to the Service tmp entry
2026-01-23
rolled out Lisa Kaita 13:53, 23 January 2026 (CST)
Changes collectors need to know about:
- inactivated boarding locs beginning with STB in s_tmp that are no longer used