CCMDB Wiki

CCMDB.accdb Change Log 2025: Difference between revisions

← Older editNewer edit →
(36 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-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 ===
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 for LAU]]
*** added options to [[s_tmp table]]
*** added [[query check ACP Status Collection for LAU]]
** [[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 ===
=== 2025-03-04 ===
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Change_Log_2025"