CCMDB.accdb Change Log 2023: Difference between revisions

(52 intermediate revisions by 2 users not shown)

Line 1:

__NOTOC__

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-12-31===

not rolled out yet [[User:Ttenbergen|Ttenbergen]] 10:30, 2023 December 31 (CST)

=== 2023-11-03 ===

'''Changes collectors need to know about:'''

not rolled yet [[User:Ttenbergen|Ttenbergen]] 10:45, 2023 ~~November 3~~ (~~CDT~~) 10:57, 2023 ~~November 1~~ (~~CDT~~)

* updated [[Cognos2 matcher query]] again, fix had somehow got lost.

<~~!---~~-------------------------

* updated ''Cognos2_Ender_Service_formQuery query'' to no longer use old program function

~~not~~ rolled yet ~~~~~~~~

~~rolled out ~~~~~~

===2023-12-30===

rolled out [[User:Lkaita|Lisa Kaita]] 07:59, 2023 December 30 (CST)

'''Changes collectors need to know about:'''

*redistributed chart ending 97,98,99 from HSC H6C to HSC H9 laptop

===2023-12-27-3===

rolled out [[User:Ttenbergen|Ttenbergen]] 19:27, 2023 December 27 (CST)

* changed [[Gastrointestinal infection (gastroenteritis, colitis), bug NOS]] from "Infection with implied pathogen" to "Infection requiring pathogen"

* tweaks to [[Cognos2_matcher query]] to make it more readable and to fix how the obsolete program filtering is dealt with.

===2023-12-27-2===

not rolled out yet but copied to server for testing [[User:Ttenbergen|Ttenbergen]] 18:34, 2023 December 27 (CST)

* more [[Change to having each collector collect both programs on the same laptop]]:

** updated [[query check_ICD10_CLI_vs_CCI_CentralLine]] which had bad bracketing after update to make it work wifor

** updated [[query check_CCI_TISS_NrDays_LT_LOS]] which had

===2023-12-27===

not rolled out yet but copied to server for testing [[User:Ttenbergen|Ttenbergen]] 15:02, 2023 December 27 (CST)

'''Changes collectors need to know about:'''

* more [[Change to having each collector collect both programs on the same laptop]]:

** added the new distribution to [[S PatientFollow distribution table]] with test switch date of 2023-12-26 to test Cognos. [[User:Ttenbergen|Ttenbergen]] 15:02, 2023 December 27 (CST)

** updated [[Cognos2 matcher query]] to no longer filter by program. [[User:Ttenbergen|Ttenbergen]] 15:02, 2023 December 27 (CST)

===2023-12-18===

not rolled out yet [[User:Ttenbergen|Ttenbergen]] 10:05, 2023 December 18 (CST)

NOT ROLLED OUT YET - but copied up to test location for testing.

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

* integrated Lisa's changes from [[#2023-12-14]] into test version. [[User:Ttenbergen|Ttenbergen]] 10:05, 2023 December 18 (CST)

* changed validation functions to use new admission_program function instead of program function

* removed program filter from service_location field dropdown

* commented out all the Apache total functions that don't seem to be used anywhere but require program parameter.

* changed dropdown in CCI_Picklist form to use admission_program instead of program.

* changed dropdowns in tmp tab to use admission_program instead of program.

===2023-12-14===

'''ROLLED OUT ''' [[User:Lkaita|Lisa Kaita]] 12:48, 2023 December 14 (CST)

Changes collectors probably don't care about:

* New "HSC Critical Care / Pain" service added

=== 2023-12-05 ===

'''NOT ROLLED OUT YET''' [[User:Ttenbergen|Ttenbergen]] 22:05, 2023 December 5 (CST)

'''NOT ROLLED OUT YET''' - but copied up to test location for testing.

'''Changes collectors need to know about:'''

* Sending will now process all tables for all laptops, regardless of program. This may make sending take slightly longer and you will see additional text in the timing log form that were blank before.

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

* remembered to check VBA for other instances where program() instead of admission_program() is used; also changed the following:

** Sub PharmCheck()

** Sub Apache_Yellower()

** BP_CrossCheck()

** Function Validate_Creat()

** Validate_ADL_generic

** Sub completeness_validation()

** Sub add_automatic_tmp_entries()

** Sub Patient_Adder(ID)

** Sub tb_IPDischargeDisposition_Click()

** Send_Data() - this one isn't a simple change, will need to review further...

** updated function program() to throw an error if it is called; it should no longer be called from anywhere, but if it does, this will find it. - then reverted this because the Cognos functions must use this until we change to combined coding.

=== 2023-11-25 ===

'''NOT ROLLED OUT YET''' [[User:Ttenbergen|Ttenbergen]] 09:29, 2023 November 25 (CST)

'''NOT ROLLED OUT YET''' - but copied up to test location for testing.

'''Changes collectors need to know about:'''

* Nothing specific but let me know if you get false positives with [[cross check]]s.

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.

'''Changes collectors need to know about:'''

* [[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]]:

** updated sub Legacy_Hider (which hides or shows CCMDB parts based on program) to get ** its program using new function admission_program, which gets its program from a given record's [[Service/Location]] rather than from [[Settings (CCMBD.mdb)|]]

** y Changed Sub Patient_Adder(ID) to also add Location, and early, since it is needed to do hiding.

* 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 Added Legacy_Hider to Sub form_view.service_location_AfterUpdate() to be able to change view mode after a change to Service_Location.

* deleted [[s_locations_allowed_collection table]]

** 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 ===

Line 226:

Line 331:

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]]

* deleted query ''check_CCI_if_no_admin_entries'' and replaced it with [[query check_CCI_Picklist_if_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

Line 264:

Line 369:

* 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 Health Centre]] 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

@@ Line 1: / Line 1: @@
 __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]]'''.
+===2023-12-31===
+not rolled out yet [[User:Ttenbergen|Ttenbergen]] 10:30, 2023 December 31 (CST)
-=== 2023-11-03 ===
+'''<mark>Changes collectors need to know about:</mark>'''
-not rolled yet [[User:Ttenbergen|Ttenbergen]] 10:45, 2023 November 3 (CDT) 10:57, 2023 November 1 (CDT)
+* updated [[Cognos2 matcher query]] again, fix had somehow got lost.
-<!----------------------------
+* updated ''Cognos2_Ender_Service_formQuery query'' to no longer use old program function
-not rolled yet ~~~~
-rolled out ~~~~
+===2023-12-30===
+rolled out [[User:Lkaita|Lisa Kaita]] 07:59, 2023 December 30 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+*redistributed chart ending 97,98,99 from HSC H6C to HSC H9 laptop
+===2023-12-27-3===
+rolled out  [[User:Ttenbergen|Ttenbergen]] 19:27, 2023 December 27 (CST)
+* changed [[Gastrointestinal infection (gastroenteritis, colitis), bug NOS]] from "Infection with implied pathogen" to "Infection requiring pathogen"
+* tweaks to [[Cognos2_matcher query]] to make it more readable and to fix how the obsolete program filtering is dealt with.
+===2023-12-27-2===
+not rolled out yet but copied to server for testing [[User:Ttenbergen|Ttenbergen]] 18:34, 2023 December 27 (CST)
+* more [[Change to having each collector collect both programs on the same laptop]]:
+** updated [[query check_ICD10_CLI_vs_CCI_CentralLine]] which had bad bracketing after update to make it work wifor
+** updated [[query check_CCI_TISS_NrDays_LT_LOS]] which had
+===2023-12-27===
+not rolled out yet but copied to server for testing [[User:Ttenbergen|Ttenbergen]] 15:02, 2023 December 27 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+* more [[Change to having each collector collect both programs on the same laptop]]:
+** added the new distribution to [[S PatientFollow distribution table]] with test switch date of 2023-12-26 to test Cognos. [[User:Ttenbergen|Ttenbergen]] 15:02, 2023 December 27 (CST)
+** updated [[Cognos2 matcher query]] to no longer filter by program. [[User:Ttenbergen|Ttenbergen]] 15:02, 2023 December 27 (CST)
+===2023-12-18===
+not rolled out yet [[User:Ttenbergen|Ttenbergen]] 10:05, 2023 December 18 (CST)
+NOT ROLLED OUT YET - but copied up to test location for testing.
+Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
+* integrated Lisa's changes from [[#2023-12-14]] into test version. [[User:Ttenbergen|Ttenbergen]] 10:05, 2023 December 18 (CST)
+* changed validation functions to use new admission_program function instead of program function
+* removed program filter from service_location field dropdown
+* commented out all the Apache total functions that don't seem to be used anywhere but require program parameter.
+* changed dropdown in CCI_Picklist form to use admission_program instead of program.
+* changed dropdowns in tmp tab to use admission_program instead of program.
+===2023-12-14===
+'''ROLLED OUT ''' [[User:Lkaita|Lisa Kaita]] 12:48, 2023 December 14 (CST)
+Changes collectors probably don't care about:
+* New "HSC Critical Care / Pain" service added
+=== 2023-12-05 ===
+'''NOT ROLLED OUT YET''' [[User:Ttenbergen|Ttenbergen]] 22:05, 2023 December 5 (CST)
+'''NOT ROLLED OUT YET''' - but copied up to test location for testing.
+'''<mark>Changes collectors need to know about:</mark>'''
+* Sending will now process all tables for all laptops, regardless of program. This may make sending take slightly longer and you will see additional text in the timing log form that were blank before.
+Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
+*  remembered to check VBA for other instances where program() instead of admission_program() is used; also changed the following:
+** Sub PharmCheck()
+** Sub Apache_Yellower()
+** BP_CrossCheck()
+** Function Validate_Creat()
+** Validate_ADL_generic
+** Sub completeness_validation()
+** Sub add_automatic_tmp_entries()
+** Sub Patient_Adder(ID)
+** Sub tb_IPDischargeDisposition_Click()
+** Send_Data() -  this one isn't a simple change, will need to review further...
+** updated function program() to throw an error if it is called; it should no longer be called from anywhere, but if it does, this will find it. - then reverted this because the Cognos functions must use this until we change to combined coding.
+=== 2023-11-25 ===
+'''NOT ROLLED OUT YET''' [[User:Ttenbergen|Ttenbergen]] 09:29, 2023 November 25 (CST)
+'''NOT ROLLED OUT YET''' - but copied up to test location for testing.
+'''<mark>Changes collectors need to know about:</mark>'''
+* Nothing specific but let me know if you get false positives with [[cross check]]s.
+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]]:
-** updated sub Legacy_Hider (which hides or shows CCMDB parts based on program) to get ** its program using new function admission_program, which gets its program from a given record's [[Service/Location]] rather than from [[Settings (CCMBD.mdb)|]]
+** y Changed Sub Patient_Adder(ID) to also add Location, and early, since it is needed to do hiding.
-* 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 Added Legacy_Hider to Sub form_view.service_location_AfterUpdate() to be able to change view mode after a change to Service_Location.
-* deleted [[s_locations_allowed_collection table]]
+** 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 ===
@@ Line 226: / Line 331: @@
 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]]
+* deleted query ''check_CCI_if_no_admin_entries'' and replaced it with [[query check_CCI_Picklist_if_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
@@ Line 264: / Line 369: @@
 * 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 Health Centre]] 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