CCMDB.accdb Change Log 2025: Difference between revisions

No edit summary
 
(14 intermediate revisions by 2 users not shown)
Line 5: Line 5:
<!--Changes collectors '''don't''' need to know about:-->
<!--Changes collectors '''don't''' need to know about:-->
-->
-->
=== 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 ===
=== 2025-03-11 ===
Rolled out [[User:Ttenbergen|Ttenbergen]] 01:21, 11 March 2025 (CDT)
Rolled out [[User:Ttenbergen|Ttenbergen]] 01:21, 11 March 2025 (CDT)


Changes collectors '''don't''' need to know about:
'''<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:  
* 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|Eye, foreign body in}}