CCMDB.accdb Change Log 2025: Difference between revisions

← Older edit Newer edit →

@@ Line 5: / Line 5: @@
 <!--Changes collectors '''don't''' need to know about:-->
 -->
+=== 2025-04-16 ===
+not rolled out yet [[User:Ttenbergen|Ttenbergen]] 01:18, 19 April 2025 (CDT)
+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 ===
-not rolled yet but emailed Lisa that it's ready to roll
+rolled out [[User:Lkaita|Lisa Kaita]] 11:37, 14 March 2025 (CDT)
 Changes collectors '''don't''' need to know about: