CCMDB Wiki

CCMDB.accdb Change Log 2023: Difference between revisions

← Older edit
No edit summary
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
__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]]'''.  
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===
===2023-12-30===
rolled out [[User:Lkaita|Lisa Kaita]] 07:59, 2023 December 30 (CST)
rolled out [[User:Lkaita|Lisa Kaita]] 07:59, 2023 December 30 (CST)
Line 91: 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]], [[
*** 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
** 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...
*** 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]]
*** confirmed [[query s_tmp_Boarding_Loc_ER_delay_reasonable]] doesn't need change because it already draws from [[Service/Location field]]
Line 324: Line 331:


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):
* 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
* 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 [[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
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Change_Log_2023"