CCMDB.accdb Change Log 2022: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "S Tmp" to "s_tmp table" |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
Change for next version: | Change for next version: | ||
=== 2022-12- | === 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 12: | Line 12: | ||
'''<mark>Changes collectors need to know about:</mark>''' | '''<mark>Changes collectors need to know about:</mark>''' | ||
* | * | ||
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 20: | Line 18: | ||
--> | --> | ||
=== 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 === | === 2022-12-08 === | ||
| Line 165: | 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 213: | 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 219: | 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 513: | 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 550: | 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 641: | 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]] | ||