CCMDB.accdb Change Log 2022: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "HSC ALC Medicine Service" to "HSC and GRA ALC Medicine Service" |
||
| (26 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
Change for next version: | Change for next version: | ||
=== 2022- | === 2022-12-29-1 === | ||
not rolled yet [[User:Ttenbergen|Ttenbergen]] | not rolled yet [[User:Ttenbergen|Ttenbergen]] 12:46, 2022 December 29 (CST) | ||
<!---------------------------- | <!---------------------------- | ||
not rolled yet ~~~~ | not rolled yet ~~~~ | ||
| Line 16: | Line 16: | ||
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): | ||
* | * | ||
--> | --> | ||
=== 2022-12-29 === | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 12:46, 2022 December 29 (CST) | |||
'''<mark>Changes collectors need to know about:</mark>''' | |||
* added '''[[BedHeldEnd DtTm]]''' | |||
* change to [[s_pre_acute_living_situation table]] that drives dropdown for [[pre_acute_living_situation field]]: | |||
** added option '''"Community Facility with support"''' | |||
** did not inactivate options "Supportive Housing" and "Assisted Living" since they will need to still be filled in for [[Dispo DtTm]]s up to 2023-01-01; set reminder to inactivate them 2023-01-31 | |||
** re-sorted the list in order of how common an entry is | |||
=== 2022-12-08 === | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 17:16, 2022 December 8 (CST) | |||
Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | |||
* updated [[s_PatientFollow_distribution table]] as discussed with Lisa and Julie, see [[Processes_around_changing_a_PatientFollow_assignment#2022-12-08]] | |||
=== 2022-12-02-1 === | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 09:26, 2022 December 2 (CST) | |||
Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | |||
* removed false positives in [[query check_no_consecutive_same_BL_or_Service]], wasn't checking consecutive dates properly | |||
=== 2022-12-02=== | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 08:20, 2022 December 2 (CST) | |||
Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | |||
* removed false positives in [[query check_no_consecutive_same_BL_or_Service]] for recordstatus deleted | |||
=== 2022-11-30=== | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 17:34, 2022 December 1 (CST) | |||
Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | |||
* updated [[query check_ICD10_trach_has_trach_but_no_TISS]] to only include critical care patients | |||
* deactivated remaining "*boarding" locations and "STB - COVID unit" for [[Boarding Loc]] | |||
* updated Function getReportFileFromMail() which is part of Cognos import to provide notification if newest report email is more than 12 hrs old | |||
* implemented [[query check_no_consecutive_same_BL_or_Service]] | |||
* updated [[query check_Transfer_DtTm_after_paired_BL_and_before_later_BL]] | |||
* updated [[s_PatientFollow_distribution table]] as discussed with Lisa and Julie, see [[Processes_around_changing_a_PatientFollow_assignment#2022-12-02]] | |||
=== 2022-11-23=== | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 16:57, 2022 November 24 (CST) | |||
Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | |||
* added "geoRegion" to [[S dispo table]] | |||
* updated [[S ICD10 APACHE Como patterns table]] in meeting with Allan | |||
=== 2022-11-16 === | === 2022-11-16 === | ||
| Line 126: | 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 146: | 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 174: | 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 180: | 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 259: | 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 380: | 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 474: | 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 511: | 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 541: | 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 602: | 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]] | ||