CCMDB.accdb Change Log 2022: Difference between revisions

Line 27: Line 27:
* updated [[query check_tmp_Boarding_Loc_Service_first_same]] to also flag if [[Accept DtTm]] is different  
* updated [[query check_tmp_Boarding_Loc_Service_first_same]] to also flag if [[Accept DtTm]] is different  
* update to [[query check_CCI_TISS_discontinuous_ETT]] to catch two more scenarios
* update to [[query check_CCI_TISS_discontinuous_ETT]] to catch two more scenarios
* updated [[query Send_Centralized_1L_Log_update]], [[query send_Centralized_1L_Log__intermediate]], [[query Send_Centralized_1L_Log_append]] to remove [[FinalCheck field]], [[Pharm_Flow_Complete]], [[R_Filter]] and [[Room_nr ]] from sending
* updated send queries "query Send_Centralized_1L_Log_update", "query send_Centralized_1L_Log__intermediate", "query Send_Centralized_1L_Log_append" to remove [[FinalCheck field]], [[Pharm_Flow_Complete]], [[R_Filter]] and [[Room_nr ]] from sending
* updated the Cognos unit import process emails to show the MRNs for new units or services, to include a better explanations, and to include Lisa in the email automatically
* updated the Cognos unit import process emails to show the MRNs for new units or services, to include a better explanations, and to include Lisa in the email automatically
* added [[s_LocationData table]]
* added [[s_LocationData table]]