CCMDB.accdb Change Log 2023: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 11: | Line 11: | ||
* 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 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 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 | |||
* 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 16: | Line 17: | ||
*** [[query check_CCI_from_OR_no_CCI]] - incidentally found this to have "*" selected and to not be properly editable, 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_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 | |||
*** [[query check_CCI_TISS_NrDays_GT_LOS]] - updated to use new function admission_program([L_Log.Pat_ID]) | |||
*** [[query check_CCI_TISS_NrDays_LT_LOS]] - updated to use new function admission_program([L_Log.Pat_ID]) | |||
** no change needed | ** no change needed | ||
*** [[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]] | *** 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: | |||
=== 2023-11-23 === | === 2023-11-23 === | ||