CCMDB.accdb Change Log 2022: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| (7 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 173: | Line 173: | ||
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 query ''send_set_oLog_to_sent'' used in [[sending]] to no longer reference | * updated query ''send_set_oLog_to_sent'' used in [[sending]] to no longer reference ''FinalCheck field''. [[User:Ttenbergen|Ttenbergen]] 16:10, 2022 August 15 (CDT) | ||
* update query ''send_Centralized_1L_Log__intermediate'' to only contain records with [[RecordStatus]] eq "complete" or "incomplete". (ie exclude deleteds and sents - before they were only excluded correctly if sending went as expected) | * update query ''send_Centralized_1L_Log__intermediate'' to only contain records with [[RecordStatus]] eq "complete" or "incomplete". (ie exclude deleteds and sents - before they were only excluded correctly if sending went as expected) | ||
* update query ''Send_Centralized_1L_Log_append'' to no longer filter on complete and incomplete since it's now taken care of in the int query | * update query ''Send_Centralized_1L_Log_append'' to no longer filter on complete and incomplete since it's now taken care of in the int query | ||
| 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 221: | Line 221: | ||
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): | ||
* Udpated sending, it was still referring the | * Udpated sending, it was still referring the ''FinalCheck field'' [[User:Ttenbergen|Ttenbergen]] 16:18, 2022 August 4 (CDT) | ||
=== 2022-08-04-1 === | === 2022-08-04-1 === | ||
| Line 227: | Line 227: | ||
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): | ||
* update to query patient_list, which was still referring to | * update to query patient_list, which was still referring to ''FinalCheck field''; was causing error when opening [[Patient List]] [[User:Ttenbergen|Ttenbergen]] 16:09, 2022 August 4 (CDT) | ||
=== 2022-08-04 === | === 2022-08-04 === | ||
| 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 521: | Line 521: | ||
'''<mark>Changes collectors need to know about:</mark>''' | '''<mark>Changes collectors need to know about:</mark>''' | ||
* retired | * retired ''Drug-induced immunosuppression'' | ||
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 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 | * 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]] | ||