CCMDB.accdb Change Log 2023: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 83: | Line 83: | ||
'''<mark>Changes collectors need to know about:</mark>''' | '''<mark>Changes collectors need to know about:</mark>''' | ||
* Nothing specific but let me know if you get false positives with cross | * 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): | Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | ||
| Line 98: | 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]], [[ | *** 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 331: | 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 | * 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 | ||
| Line 369: | 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) | * 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. | * changed the dropdown for the [[Previous Location]] to list the local entries first. | ||
* updated entry for Selkirk Mental | * 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 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 | * updated [[created_AdmitDtTm query]] so it won't crash when there are nulls in all three dates | ||