CCMDB.accdb Change Log 2022: Difference between revisions
Ttenbergen (talk | contribs) m Drug-induced immunosuppression no more |
Ttenbergen (talk | contribs) |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 97: | Line 97: | ||
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): | ||
* changed trigger for [[query s_tmp_check_Boarding_Loc_and_TransferReadyDtTm_pairs]] from pre-sent checker to tmp box since it's not part of minimal data set | * changed trigger for [[query s_tmp_check_Boarding_Loc_and_TransferReadyDtTm_pairs]] from pre-sent checker to tmp box since it's not part of minimal data set | ||
* did a [[Recreate CCMDB.accdb]] to fix | * did a [[Recreate CCMDB.accdb]] to fix [[CCMDB.accdb requires password when closing]] on previous version | ||
=== 2022-10-06 === | === 2022-10-06 === | ||
| Line 193: | Line 193: | ||
** added tb_ClientGUID hidden element to [[Cognos2 Service Starter]] to contain field | ** added tb_ClientGUID hidden element to [[Cognos2 Service Starter]] to contain field | ||
** updated [[Cognos2_matcher query]] to include field | ** updated [[Cognos2_matcher query]] to include field | ||
* made [[HSC ALC Medicine Service]] entries available in [[S tmp table]] | * made [[HSC and GRA ALC Medicine Service]] entries available in [[S tmp table]] | ||
=== 2022-08-09 === | === 2022-08-09 === | ||
| Line 306: | Line 306: | ||
** SBGH Cardiac / Cardiology C Service | ** SBGH Cardiac / Cardiology C Service | ||
* changed [[query s_tmp_Boarding_Loc_date_item]] and [[query check_tmp_Boarding_Loc_Service_first_same]] to be checked when record is complete, not for incomplete records | * changed [[query s_tmp_Boarding_Loc_date_item]] and [[query check_tmp_Boarding_Loc_Service_first_same]] to be checked when record is complete, not for incomplete records | ||
* updated tmp cross | * updated tmp [[cross check]]s to change the [[Record field]] to "Problem" when they trigger; they previously would set the recordstatus to incomplete but leave record as whatever it was, possibly "C". | ||
=== 2022-05-19-1 === | === 2022-05-19-1 === | ||
| Line 427: | Line 427: | ||
'''<mark>Changes collectors need to know about:</mark>''' | '''<mark>Changes collectors need to know about:</mark>''' | ||
* added [[Selkirk Mental Health Centre]] to [[s_dispo table]] as dropdown similar to St Amant | * added [[Selkirk Mental Health Centre]] to [[s_dispo table]] as dropdown similar to [[St.Amant]] | ||
* removed the Accept and Arrive DtTm from the [[Patient Viewer Tab APACHE]] - the time is listed above, no to show it repeatedly. | * removed the Accept and Arrive DtTm from the [[Patient Viewer Tab APACHE]] - the time is listed above, no to show it repeatedly. | ||
| Line 558: | Line 558: | ||
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): | ||
* removed field ''complete_send''' from [[ | * removed field ''complete_send''' from [[s_tmp table]] since it has not been used in a long time. [[User:Ttenbergen|Ttenbergen]] 09:45, 2022 March 31 (CDT) | ||
* Added 87 locations to [[s_tmp table]] from [[s_Cognos_Units table]] so they can be entered following new process. [[User:Ttenbergen|Ttenbergen]] 09:45, 2022 March 31 (CDT) | * Added 87 locations to [[s_tmp table]] from [[s_Cognos_Units table]] so they can be entered following new process. [[User:Ttenbergen|Ttenbergen]] 09:45, 2022 March 31 (CDT) | ||
| Line 588: | Line 588: | ||
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): | ||
* updated all entries containing ALC ([[HSC ALC Medicine Service]]) in [[s_Cognos_Services table]] to only show on medicine laptops | * updated all entries containing ALC ([[HSC and GRA ALC Medicine Service]]) in [[s_Cognos_Services table]] to only show on medicine laptops | ||
* updated "SBGH Womens Health / General" in [[s_Cognos_Services table]] to be automatically excluded | * updated "SBGH Womens Health / General" in [[s_Cognos_Services table]] to be automatically excluded | ||
* updating [[Query check minimal data set incomplete]] to detect missing times | * updating [[Query check minimal data set incomplete]] to detect missing times | ||
| Line 649: | Line 649: | ||
* 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 send queries "query Send_Centralized_1L_Log_update", "query send_Centralized_1L_Log__intermediate", "query Send_Centralized_1L_Log_append" to remove ''FinalCheck field'', | * 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]] | ||