CCMDB.accdb Change Log 2023: Difference between revisions

(45 intermediate revisions by 3 users not shown)

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

=== 2023-08-~~09-1~~ ===

=== 2023-11-25 ===

~~not rolled yet~~ [[User:Ttenbergen|Ttenbergen]] 09:49, 2023 ~~August 16~~ (~~CDT~~)

'''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 ~~~~~~~~

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

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

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

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

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

*

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

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

* Added "EuroSCORE II Phy" to [[EuroSCORE II]]

=== 2023-09-27===

rolled out [[User:Lkaita|Lisa Kaita]] 15:28, 2023 September 27 (CDT)

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

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

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

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

Line 26:

Line 91:

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

@@ 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]]'''.
-=== 2023-08-09-1 ===
+=== 2023-11-25 ===
-not rolled yet [[User:Ttenbergen|Ttenbergen]] 09:49, 2023 August 16 (CDT)
+'''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 ===
@@ Line 26: / Line 91: @@
 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 ===