CCMDB.accdb Change Log 2023: Difference between revisions

Line 12: Line 12:
* deleted old queries we never turned to regular use ''COV_L_ICD10_Twinner, COV_L_Pharm_Flowsheet_Twinner''
* 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 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" that aren't used any more
* 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]]:  
* confirmed that queries will work after [[Change to having each collector collect both programs on the same laptop]]:  
** '''changed'''
** '''changed'''
Line 32: Line 32:
*** 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/loc


=== 2023-11-23 ===
=== 2023-11-23 ===