CCMDB Wiki

CCMDB.accdb Change Log 2023: Difference between revisions

← Older editNewer edit →
(114 intermediate revisions by 3 users 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-05 ===
=== 2023-11-25 ===
not rolled yet [[User:Ttenbergen|Ttenbergen]] 10:15, 2023 January 4 (CST)
'''NOT ROLLED OUT YET''' [[User:Ttenbergen|Ttenbergen]] 09:29, 2023 November 25 (CST)
<!----------------------------
 
not rolled yet ~~~~
'''NOT ROLLED OUT YET''' - but copied up to test location for testing.
rolled out ~~~~
 
'''<mark>Changes collectors need to know about:</mark>'''
* Nothing specific but let me know if you get false positives with cross checks.
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* deleted old temp queries ''2022_08_04_L_Log_Convert, 0_tmp_Cognos_combiner, 0_tmp_Cognos_units_vs_BoardingLoc, 0_tmp_Cognos_units_vs_dispo, 1_delete, 1_infDisease_mess, 1test''
* deleted old queries we never turned to regular use ''COV_L_ICD10_Twinner, COV_L_Pharm_Flowsheet_Twinner''
* deleted old query "check_ER_Delay_not_too_big" that has not been used since 2022-04-14
* deleted old queries "form_new_pt_helper_list", "S_AdmitDischarge_to_wiki", "s_tmp_comfort_care_gt_one", "s_tmp_QAInf__dx", "s_tmp_QAInf__tmp", "COV_0_PatID_negative" that aren't used any more
* confirmed that queries will work after [[Change to having each collector collect both programs on the same laptop]]:
** '''changed'''
*** [[query check_CCI_Component_duplicates]] - incidental finding that this didn't use the usual column names, fixed
*** [[query check_CCI_from_OR_no_CCI]] - incidentally found this to have "*" selected and to not be properly editable, fixed
*** [[query check_CCI_Picklist_duplicates]] - incidental finding that this didn't use the usual column names, fixed
*** [[query check_CCI_TISS_if_no_then_none]] - was checking for program but doesn't need to since Med shouldn't collect {{TISS w Nr|No TISS Item (TISS Item)}} in the first place
*** updated to use new function admission_program([L_Log.Pat_ID]): [[query check_CCI_TISS_NrDays_GT_LOS]], [[query check_CCI_TISS_NrDays_LT_LOS]], [[query check_ICD10_CLI_vs_CCI_CentralLine]], [[Query check_ICD10_trach_has_trach_but_no_TISS]], [[
** no change needed
*** confirmed [[query check_AIDS_vs_HIV ]], [[query Check_BL_TR_combiner_null]], [[query check_CCI_component_1_and_2_compatible]], [[query check CCI Component no admin entries]], [[query check_CCI_Component_unfilled]], [[query check_CCI_Date]], [[query check_CCI_ICD10_Dialysis_no_Dx]], [[query check_CCI_if_no_then_none]], [[query check_CCI_must_have_entry]], [[query check_CCI_Picklist_if_no_admin_entries]], [[query check_CCI_Picklist_unfilled]], [[query check_CCI_TISS_CAM_positive_vs_Dx]], [[query check_CCI_TISS_discontinuous_ETT]], [[query check_CCI_TISS_Intubation_vs_Intubated]], [[query check_CCI_TISS_matching_BoardingLoc_time]], [[query check_CCI_TISS_Pharm_Vasoactive]], [[query check_CCI_TISS_time_means_must_be_two]], [[query check_CCI_TISS_Vented_without_mechanism]], [[query check_CCI_vs_LOS_count_days_component]], [[query check_CCI_vs_LOS_count_days_picklist]], [[query check_cooling_vs_arrest]], [[query check_dx_primary_lowest_priority]], [[query check_dx_primary_not_exactly_one]]
*** then decided to only confirm queries that are likely to have a change...
*** confirmed [[query s_tmp_Boarding_Loc_ER_delay_reasonable]] doesn't need change because it already draws from [[Service/Location field]]
 
=== 2023-11-23 ===
Not rolled out yet [[User:Ttenbergen|Ttenbergen]] 17:28, 2023 November 5 (CST)
 
'''NOT ROLLED OUT YET''' - but copied up for Lisa to test.
 
'''<mark>Changes collectors need to know about:</mark>'''
* [[Change to having each collector collect both programs on the same laptop]]:
** Changed the drop-downs for [[Patient Viewer]] and [[New Pt Serial helper form]] to list all [[Service/Location]]s for sites; '''make sure you use only appropriate program locations as per current directions, which may vary by site and collector during the roll-out.
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* This update rolls up several previous changes that made the program unusable
* added function Default_Service_Location()
* added [[query admission_program]] to supply dropdowns for [[Patient Viewer]] and [[New Pt Serial helper form]]
* changed [[s_dispo table|s_dispo]].s_location to "true" for HSC_IICU, HSC_MICU, HSC_SICU - should have been all along but somehow wasn't
* [[Change to having each collector collect both programs on the same laptop]]:
** y Changed Sub Patient_Adder(ID) to also add Location, and early, since it is needed to do hiding.
** y Added Legacy_Hider to Sub form_view.service_location_AfterUpdate() to be able to change view mode after a change to Service_Location.
** y updated sub Legacy_Hider (which hides or shows CCMDB parts based on program) to get the record's program using new function admission_program
** y added function admission_program() which determines the program per admission rather than per laptop; it gets its program from a given record's [[Service/Location]] rather than from [[Settings (CCMBD.mdb)|Settings]]
** y updated [[Query s_serviceLocation_local]] to no longer use [[S locations allowed collection table]] and consider only site and [[S dispo table]].s_location instead
** y deleted [[s_locations_allowed_collection table]]
 
=== 2023-11-01 ===
rolled out [[User:Lkaita|Lisa Kaita]] 10:56, 2023 November 1 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
 
*Changed [[Progressive Multifocal Leukoencephalopathy (PML)]] to no longer be an infection with implied pathogen and to be a potential infection instead
 
=== 2023-09-28 ===
rolled out [[User:Haubel|Haubel]] 12:25, 2023 September 28 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* Added "EuroSCORE II Phy" to [[EuroSCORE II]]
 
=== 2023-09-27===
rolled out [[User:Lkaita|Lisa Kaita]] 15:28, 2023 September 27 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* updated [[Bronchitis, chronic, infectious or noninfectious]] to be a [[:Category:Potential infection]]. [[User:Lkaita|Lisa Kaita]] 15:28, 2023 September 27 (CDT)
 
=== 2023-08-31 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:14, 2023 August 31 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* updated [[s_PatientFollow_distribution table]] to reflect change in allocation for  for STB Med 11:14, 2023 August 31 (CDT)
 
=== 2023-08-16-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:27, 2023 August 16 (CDT)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[query s_tmp_EuroSCORE_II_checks]] to allow scores up to 100
 
=== 2023-08-16 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:49, 2023 August 16 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* added "HSC-NDWRS2" to [[Boarding Loc]] values in [[s_tmp table]]
 
=== 2023-08-09 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:37, 2023 August 9 (CDT)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* Changed category of [[Lightning injury]] from [[:Category:Trauma]] to [[:Category:Potential trauma]] to allow coding without a mechanism without triggering [[Query check ICD10 mechanism vs trauma]].
 
=== 2023-08-07 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:00, 2023 August 7 (CDT)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* made updates to allow for [[Change to having each collector collect both programs on the same laptop]]:
* program will now check for command line parameter to designate data file that should be used.
* added display of data file to the laptop line at the top of the main window.
* added H9 locations for H6C in [[s_locations_allowed_collection table]] to make them available in the dropdown
 
=== 2023-07-27 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:42, 2023 July 27 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* changed name of diagnosis "''Heart, coronary arteries, diagnostic imaging, abnormal''" to [[Heart and/or coronary arteries, diagnostic imaging, abnormal]]
 
=== 2023-07-26 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 14:19, 2023 July 26 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* [[EuroSCORE II]]: added "excluded" entry; see instruction page for use
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* inactivated entry "HSC_CC" in [[s_dispo table]]
* [[query s_tmp_EuroSCORE_II_checks]]: added exception to score requirement for Value = "excluded"
 
=== 2023-07-12 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:32, 2023 July 12 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* changed [[EuroSCORE II]] so it doesn't auto-populate, and implemented [[query s_tmp_EuroSCORE_II_checks]]
 
=== 2023-07-06 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 14:57, 2023 July 6 (CDT)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* added to [[s_tmp table]] the values for '''legacy''' project data [[Project Legacy Co-managed]] and [[ Project Legacy HSC CCU Loc]]
 
=== 2023-06-28 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:43, 2023 June 28 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* set up new project [[EuroSCORE II]] (added record to [[s_tmp table]])
 
=== 2023-06-27 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:10, 2023 June 27 (CDT)
 
'''<mark>Changes collectors need to know about:</mark>'''
* updated [[ERCP (endoscopic retrograde cholangiopancreatography)]] to be [[CCI Collection Mode]] "Collect each"
 
=== 2023-05-31 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 14:11, 2023 June 5 (CDT)
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* inactivated the HSC options for [[ICUotherService]] since we have not entered this there since we decided to break those records apart by service, not just program.
 
=== 2023-05-30 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:52, 2023 May 31 (CDT)
 
'''<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):
* retired [[Sudden cardiac death (and died)]] as per [[Task Team Meeting - Rolling Agenda and Minutes 2023#ICU Database Task Group Meeting – Jan 11, 2023]]
 
=== 2023-01-11 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:26, 2023 January 25 (CST)


'''<mark>Changes collectors need to know about:</mark>'''
'''<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):
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. ~~~~
* 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 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
* disabled [[query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER]]
 
=== 2023-01-05 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:04, 2023 January 5 (CST)


-->
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:04, 2023 January 5 (CST)


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