CCMDB Wiki

CCMDB.accdb Change Log 2025: Difference between revisions

← Older editNewer edit →
(69 intermediate revisions by 2 users not shown)
Line 1: Line 1:
__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
__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]]'''.  
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]]'''.  
<!--=== 2025-xx ===
<!--'''<mark>Changes collectors need to know about:</mark>'''-->
<!--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 ===
copied to server, asking Lisa to roll out after re-importing Cognos [[User:Ttenbergen|Ttenbergen]] 09:40, 5 March 2025 (CST)
Changes collectors '''don't''' need to know about:
* added data items for [[LAU Collection Project]] to [[s_tmp table]]:
** [[Project Consults data]]
** [[LAU collection readmission data]]
* updated "Hosp" dropdown in [[s_tmp table]] to current official values for Oaks, Conc and Vic: "COH";"SOH";"VGH"


<!--
=== 2025-03-03 ===
=== 2025-xx ===
rolled out [[User:Ttenbergen|Ttenbergen]] 02:00, 4 March 2025 (CST)
 
Changes collectors '''don't''' need to know about:
* further prep for [[Project Overstay2]]: updated modules overstay2 and _Global with same changes as in CFE after update to ensure same overstay score as Julie
* added data items for [[LAU Collection Project]]
** to [[S dispo table]]: VGH_LAU, SOH_LAU, COH_LAU
** to [[S tmp table]]: the specific units listed on [[LAU Collection Project]]
 
=== 2025-02-28-1 ===
[[User:Lkaita|Lisa Kaita]] 12:22, 28 February 2025 (CST)
'''<mark>Changes collectors need to know about:</mark>'''
'''<mark>Changes collectors need to know about:</mark>'''
* retired ICD 10 [[Past history of Covid-19 infection]] from [[S ICD10 table]]
* corrected my mistake reactivated COVID 19 infection and retired the appropriate one
=== 2025-02-28 ===
rolled out [[User:Lkaita|Lisa Kaita]] 09:12, 28 February 2025 (CST)
'''<mark>Changes collectors need to know about:</mark>'''
* retired ICD 10 [[Past history of Covid-19 infection]] from [[S ICD10 table]]
=== 2025-02-20 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:55, 20 February 2025 (CST)
Changes collectors '''don't''' need to know about:
* Prep for [[Project Overstay2]]
** changed the test entry in [[s_tmp table]] to match what the button generates; the previous value it entered was generating errors on sending because there was no corresponding value in s_tmp
=== 2025-02-11 ===
(Tina copied to server, Pagasa rolled it out) [[User:Ttenbergen|Ttenbergen]] 15:25, 12 February 2025 (CST)
'''<mark>Changes collectors need to know about:</mark>'''
* added OS button to patient viewer form; it will eventually be used to generate colours for [[Project Overstay2]]; instructions to follow.
Changes collectors '''don't''' need to know about:
Changes collectors '''don't''' need to know about:
-->
* changed to restore .dirty instead of DoCmd.RunCommand acCmdSaveRecord
** Function uncheck_reg() x2
* Prep for [[Project Overstay2]]
** added Overstay2, Overstay result to [[s_tmp table]]
** added OS button
*** added code to colour the button
** added code to run when the button is clicked to Module Overstay2
* updated Sub GenerUpdate_tmp_entry to use Function runQuery instead of runsql
* changed to form_Current to run later, once pat_ID is initialized
* removed [[Function adl_sc]] - appears not to be used; use query adl_scores as needed
* moved function db_local from _global to _unique_cfe, only used there to open with parameter
* updated functions GCS_*_pts() to return integer with very high number if there is an error; improved error handling
* merged in [[#2025-02-09]]
* update all s_tmp entries for Boarding Loc to have MCHP=true (were inconsistent before)
 
=== 2025-02-09 ===
'''<mark>Changes collectors need to know about:</mark>'''
* added HSC-JK3 as a new boarding loc in [[S Cognos Units table]] and [[S tmp table]]
 
=== 2025-02-06 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 12:56, 6 February 2025 (CST)
 
Changes collectors '''don't''' need to know about:
* Sub Dx_Checker() - 2x changed ''DoCmd.RunCommand acCmdSaveRecord'' back to ''Form_View.Dirty = False''
 
=== 2025-02-05 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:02, 5 February 2025 (CST)
 
Changes collectors '''don't''' need to know about:
* reverted a change to form CCI_Component_Chooser that caused error when picking a component
* reverted a change to function CADT_populate that caused error when clicking "Unit End DtTm" to populate Dispo_DtTm.


===2025-01-28===
===2025-01-28===
'''not rolled out yet[[User:Ttenbergen|Ttenbergen]] 10:07, 28 January 2025 (CST)'''
rolled out [[User:Ttenbergen|Ttenbergen]] 13:19, 4 February 2025 (CST)
 
'''<mark>Changes collectors need to know about:</mark>'''
* added new Cognos entry for '''SBGH-L2CC'''


Changes collectors '''don't''' need to know about:
Changes collectors '''don't''' need to know about:
Line 16: Line 275:
* updated query ''L_ICD10_Charlson_agepts'' - it was still using [[Arrive DtTm]] and now uses [[created_AdmitDtTm query]]. [[User:Ttenbergen|Ttenbergen]] 10:39, 28 January 2025 (CST)
* updated query ''L_ICD10_Charlson_agepts'' - it was still using [[Arrive DtTm]] and now uses [[created_AdmitDtTm query]]. [[User:Ttenbergen|Ttenbergen]] 10:39, 28 January 2025 (CST)
* updated ''Charlson_score_function'' to use a variant for ID, and updated it so it will work with either D_ID or Pat_ID (ie will work for CCMDB or CFE). [[User:Ttenbergen|Ttenbergen]] 12:15, 28 January 2025 (CST)
* updated ''Charlson_score_function'' to use a variant for ID, and updated it so it will work with either D_ID or Pat_ID (ie will work for CCMDB or CFE). [[User:Ttenbergen|Ttenbergen]] 12:15, 28 January 2025 (CST)
* added some functionality to be able to use code and queries in both CCMDB and CFE:
** Module ''Global_''
*** Const DB_ID to set CFE / CCMDB
*** Function ID_name() to give "Pat_ID" for CCMDB and "D_ID" for CFE
*** Function ID_query(ID) to expand into appropriate query strings for the two DBs based on DB_ID
*** Function Charlson_score_function() to use ID_query()
*** updated ExistsTable() with cleaner code
*** added sub handle_err()
*** added public constants minage and maxage to make sure we are always using the same
* updated Function Validate_DOB() to use same minage/maxage and CCMDB_Age()
* replaced all "<form name>.Dirty = False" with "DoCmd.RunCommand acCmdSaveRecord" since that is more reliable
* found that after_update events had got disconnected for fields DOB, Sex, Record on form_view; this means that it would have been possible to run the complete check, pass it, then enter a value that should fail, and not have the complete unchecked; re-connected them
* added new Cognos entries:
** [[s_Cognos_Services table]]:
*** GH Palliative Care / Home Care
*** GH Medicine / Other ALC
*** GH Surgery / Home Care
*** GH Surgery / Panel Appr PCH
*** GH Surgery / Panel in Process
** [[s_Cognos_Units table]]:
*** SBGH-Outpt-B2IP
*** SBGH-L2CC
*** SBGH-zB2IP-Closed
** [[s_tmp table]]:
*** SBGH-L2CC


===2025-01-20===
===2025-01-20===
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Change_Log_2025"