CCMDB.accdb Change Log 2022: Difference between revisions

(18 intermediate revisions by the same user not shown)

Line 5:

Change for next version:

=== 2022-11-30===

=== 2022-12-29-1 ===

not rolled yet [[User:Ttenbergen|Ttenbergen]] 16:57, 2022 ~~November 24~~ (CST)

not rolled yet [[User:Ttenbergen|Ttenbergen]] 12:46, 2022 December 29 (CST)

<!----------------------------

not rolled yet ~~~~

Line 15:

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]] ~~~~

-->

=== 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===

Line 134:

Line 173:

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 [[FinalCheck field]]. [[User:Ttenbergen|Ttenbergen]] 16:10, 2022 August 15 (CDT)

* 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_append'' to no longer filter on complete and incomplete since it's now taken care of in the int query

Line 182:

Line 221:

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

* Udpated sending, it was still referring the [[FinalCheck field]] [[User:Ttenbergen|Ttenbergen]] 16:18, 2022 August 4 (CDT)

* Udpated sending, it was still referring the ''FinalCheck field'' [[User:Ttenbergen|Ttenbergen]] 16:18, 2022 August 4 (CDT)

=== 2022-08-04-1 ===

Line 188:

Line 227:

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 [[FinalCheck field]]; was causing error when opening [[Patient List]] [[User:Ttenbergen|Ttenbergen]] 16:09, 2022 August 4 (CDT)

* 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 ===

Line 482:

Line 521:

'''<mark>Changes collectors need to know about:</mark>'''

* retired [[Drug-induced immunosuppression]]

* retired ''Drug-induced immunosuppression''

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

Line 519:

Line 558:

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

* removed field ''complete_send''' from [[~~S Tmp~~]] since it has not been used in a long time. [[User:Ttenbergen|Ttenbergen]] 09:45, 2022 March 31 (CDT)

* 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)

Line 610:

Line 649:

* 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

* 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 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

* added [[s_LocationData table]]

@@ Line 5: / Line 5: @@
 Change for next version:
-=== 2022-11-30===
+=== 2022-12-29-1 ===
-not rolled yet [[User:Ttenbergen|Ttenbergen]] 16:57, 2022 November 24 (CST)
+not rolled yet [[User:Ttenbergen|Ttenbergen]] 12:46, 2022 December 29 (CST)
 <!----------------------------
 not rolled yet ~~~~
@@ Line 15: / Line 15: @@
 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]] ~~~~
 -->
+=== 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===
@@ Line 134: / Line 173: @@
 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 [[FinalCheck field]]. [[User:Ttenbergen|Ttenbergen]] 16:10, 2022 August 15 (CDT)
+* 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_append'' to no longer filter on complete and incomplete since it's now taken care of in the int query
@@ Line 182: / Line 221: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
-* Udpated sending, it was still referring the [[FinalCheck field]] [[User:Ttenbergen|Ttenbergen]] 16:18, 2022 August 4 (CDT)
+* Udpated sending, it was still referring the ''FinalCheck field'' [[User:Ttenbergen|Ttenbergen]] 16:18, 2022 August 4 (CDT)
 === 2022-08-04-1 ===
@@ Line 188: / Line 227: @@
 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 [[FinalCheck field]]; was causing error when opening [[Patient List]] [[User:Ttenbergen|Ttenbergen]] 16:09, 2022 August 4 (CDT)
+* 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 ===
@@ Line 482: / Line 521: @@
 '''<mark>Changes collectors need to know about:</mark>'''
-* retired [[Drug-induced immunosuppression]]
+* retired ''Drug-induced immunosuppression''
 Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
@@ Line 519: / Line 558: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
-* removed field ''complete_send''' from [[S Tmp]] since it has not been used in a long time. [[User:Ttenbergen|Ttenbergen]] 09:45, 2022 March 31 (CDT)
+* 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)
@@ Line 610: / Line 649: @@
 * 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
-* 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 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
 * added [[s_LocationData table]]