CCMDB Wiki

CCMDB.accdb Change Log 2023: Difference between revisions

← Older editNewer edit →
mNo edit summary
(42 intermediate revisions by the same user not shown)
Line 2: Line 2:
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]]'''.  


=== 2023-01-11 ===
=== 2023-05-30 ===
not rolled yet [[User:Ttenbergen|Ttenbergen]] 11:04, 2023 January 5 (CST)
not rolled yet [[User:Ttenbergen|Ttenbergen]] 13:29, 2023 May 24 (CDT)
<!----------------------------
<!----------------------------
not rolled yet ~~~~
not rolled yet ~~~~
Line 9: Line 9:


'''<mark>Changes collectors need to know about:</mark>'''
'''<mark>Changes collectors need to know about:</mark>'''
*  
* Added "MICU under ACCU service" to [[ICUotherService]]
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* turned off [[query check_CCI_TISS_time_means_must_be_two]] because it caused too many false positives
 
-->
 
=== 2023-05-24-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:29, 2023 May 24 (CDT)
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* tweak to [[Query check ICD10 ESRD and AKI only if transplant]]
 
=== 2023-05-23 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:58, 2023 May 24 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* implemented [[Query check_ICD10_ESRD_and_AKI_only_if_transplant]]
 
=== 2023-05-04 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:17, 2023 May 4 (CDT)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* correction to [[s_ICD10_Charlson_Como_patterns table]] to use ranges that exclude the end
* rolling out to make sure Julie and I are working off the same version of this
 
=== 2023-05-03-3 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:10, 2023 May 3 (CDT)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* tweak to [[Query check tmp BedHeld]], it was looking for [[dispo]] = "AWOL" but needed "AMA (left against medical advice)"
 
=== 2023-05-03-2 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:50, 2023 May 3 (CDT)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* tweaked [[Query check_ICD10_trach_dxs_consistent]] as per old request
* tweaked [[query check_ICD10_CLI_vs_CCI_CentralLine]] to only check cc patients
 
=== 2023-05-03 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:38, 2023 May 3 (CDT)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* tweak to [[query check_ICD10_CLI_vs_CCI_CentralLine]]
 
=== 2023-05-02 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 07:56, 2023 May 3 (CDT)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* re-imported [[s_CCI_Categories_Collection_Mode table]] since the update I rolled out was actually missing things, see [[s_CCI_Categories_Collection_Mode table]]
* correction to [[query check_tmp_BedHeld]], which wasn't working right for "AMA (Protocol)"
 
=== 2023-04-27 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 12:05, 2023 May 2 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* added [[query check_tmp_BedHeld]]
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* removed query "z_ComoAdmAcqu_Primary_List" that had been built for [[Controlling Dx Type for ICD10 codes]]
 
=== 2023-04-18 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 12:03, 2023 April 18 (CDT)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated functions that import Cognos data to give option to import from desktop file if import from email fails
 
=== 2023-04-05-2 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 21:22, 2023 April 5 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* Changed the name of "Transfusion of FFP" to [[Transfusion of plasma products]] in [[S CCI Picklist table]]
 
=== 2023-04-05-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 17:31, 2023 April 5 (CDT)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated code for [[(T) Brain's Meninges, Dura, Subarachnoid, Ventricles]]: it was "1.AA  " with two spaces, and is now just "1.AA" as it should be.
 
=== 2023-04-05 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:47, 2023 April 5 (CDT)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* [[S dispo table]]: edited record for [[GH-Recovery Room]] to remove the categorizations and change it from RR to ICU
 
=== 2023-03-02 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:24, 2023 March 2 (CST)
 
'''<mark>Changes collectors need to know about:</mark>'''
* in [[s_dispo table]], changed "GH-ER" to " GH - ER" which makes it consistent with how it's named at other locations, and which moves it to the top of how these are sorted in the previous location and other fields.
 
=== 2023-02-09-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:33, 2023 March 1 (CST)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated function ApScore_pH() to return 0 rather than Null when receiving a Null input [[User:Ttenbergen|Ttenbergen]] 10:33, 2023 March 1 (CST)
* changed '''Primary Biliary Cirrhosis (PBC)''' to [[Primary Biliary Cholangitis (PBC)]] in [[s_ICD10 table]] [[User:Ttenbergen|Ttenbergen]] 09:52, 2023 March 1 (CST)
 
=== 2023-02-09 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 18:04, 2023 February 9 (CST)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* added send dttm to logging to troubleshoot [[Error "Invalid SQL statment..." when sending]] [[User:Ttenbergen|Ttenbergen]] 18:04, 2023 February 9 (CST)
 
=== 2023-02-08 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:58, 2023 February 9 (CST)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* deleted query ''check_CCI_if_no_admin_entries'' and replaced it with [[query check_CCI_Picklist_no_admin_entries]] and [[query check_CCI_Component_no_admin_entries]]
* ran a re-compile and removed code that is no longer required because of previous changes
* updated [[query check_Transfer_DtTm_after_paired_BL_and_before_later_BL]] so it will not allow transfer ready to be equal to ''next'' boarding loc start
* updated options for [[Pre acute living situation field]] in [[S pre acute living situation table]] to no longer allow "Assisted Living" and "Supportive Housing" which have been replaced by "Community Facility with support"
 
=== 2023-02-02 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 14:52, 2023 February 2 (CST)
 
'''<mark>Changes collectors need to know about:</mark>'''
* re-allocated some STB Med, see [[Processes_around_changing_a_PatientFollow_assignment#2023-02-02]] [[User:Ttenbergen|Ttenbergen]] 14:52, 2023 February 2 (CST)
 
=== 2023-01-26 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:17, 2023 January 26 (CST)
 
'''<mark>Changes collectors need to know about:</mark>'''
* re-activated the HSC Critical Care Service entries for [[Service tmp entry]] that had been inactivated in the past since we will now collect these verbatim
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[Charlson Comorbidities in ICD10 codes]] according to Allan's email from Dec 1; this should have been identical to what I have but somehow still had differences; the specific changes are a bit messy and there will likely be further updates since the list was incomplete.
 
=== 2023-01-25 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 17:13, 2023 January 25 (CST)
 
'''<mark>Changes collectors need to know about:</mark>'''
* added "Weird reason" to [[BedHeldEnd DtTm]]


Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[S laptops table]] to not allow duplicate entries. Three lines had accidentally been added that were causing records to not show up in CSS. ~~~~
* retired [[Sudden cardiac death (and died)]] as per [[Task Team Meeting - Rolling Agenda and Minutes 2023#ICU Database Task Group Meeting – Jan 11, 2023]]
* Changed the dropdown for the [[Previous Location]] to list the local entries first.  
 
=== 2023-01-11 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:26, 2023 January 25 (CST)
 
'''<mark>Changes collectors need to know about:</mark>'''
* added HSC ICU related Cognos services to [[s_tmp table]] to allow entry as it is in Cognos, rather than changed version; '''more may need to be added, let me know'''
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[S_laptops table]] to not allow duplicate entries. Three lines had accidentally been added that were causing records to not show up in CSS. [[User:Ttenbergen|Ttenbergen]] 11:26, 2023 January 25 (CST)
* changed the dropdown for the [[Previous Location]] to list the local entries first.  
* updated entry for Selkirk Mental Hospital in s_dispo table to replace the nulls in its site etc fields with empty strings like all the other entries have
* updated entry for Selkirk Mental Hospital in s_dispo table to replace the nulls in its site etc fields with empty strings like all the other entries have
* updated the GH-ambulatory care to GH ambulatory care (- to space) so it sorts below the options collectors actually use  
* updated the GH-ambulatory care to GH ambulatory care (- to space) so it sorts below the options collectors actually use  
* updated [[created_AdmitDtTm query]] so it won't crash when there are nulls in all three dates
* updated [[created_AdmitDtTm query]] so it won't crash when there are nulls in all three dates
-->
* disabled [[query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER]]


=== 2023-01-05 ===
=== 2023-01-05 ===
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Change_Log_2023"