CCMDB.accdb Change Log 2023: Difference between revisions

(18 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)

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

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

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

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

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

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

Line 12:

Line 44:

* 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

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

Line 49:

Line 83:

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

* Nothing specific but let me know if you get false positives with cross ~~checks~~.

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

Line 64:

Line 98:

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

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

Line 297:

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 335:

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)
+'''<mark>Changes collectors need to know about:</mark>'''
+* updated [[Cognos2 matcher query]] again, fix had somehow got lost.
+* updated ''Cognos2_Ender_Service_formQuery query'' to no longer use old program function
+===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)
-'''<mark>Changes collectors need to know about:</mark>'''
+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):
@@ Line 12: / Line 44: @@
 * 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
+* 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===
@@ Line 49: / Line 83: @@
 '''<mark>Changes collectors need to know about:</mark>'''
-* Nothing specific but let me know if you get false positives with cross checks.
+* 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):
@@ Line 64: / Line 98: @@
 *** 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]]
+*** 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]]
@@ Line 297: / 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 335: / 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