CCMDB.accdb Change Log 2022: Difference between revisions

(63 intermediate revisions by the same user not shown)

Line 5:

Change for next version:

=== 2022-08-25 ===

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

not rolled yet [[User:Ttenbergen|Ttenbergen]] 16:10, 2022 ~~August 15~~ (~~CDT~~)

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

* Get [[ClientVisitGUID]] field in [[L_Log table]] populated from Cognos:

*

-->

=== 2022-12-29 ===

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

'''Changes collectors need to know about:'''

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

rolled out [[User:Ttenbergen|Ttenbergen]] 15:29, 2022 November 16 (CST)

'''Changes collectors need to know about:'''

* removed [[Chronic Health APACHE]] - the field is no longer needed as per [[Change for Apache Chronic to ICD10 from separate variable]], and we confirmed during [[JALT_Meeting_-_Rolling_Agenda_and_Minutes_2022#JALT_Meeting_–_November_16,_2022]] that this can be removed

=== 2022-11-02 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 10:08, 2022 November 10 (CST)

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

* recreated db relationships that were still not restored after most recent [[Recreate CCMDB.accdb]]

* added Sub SQL_relations_restorer and Function CreateRelation

* changed all all tabs in [[Patient Viewer]] to not yellow, some had been saved while yellow

* updated [[Created_FirstService query]] to prevent duplication of records when the same service is entered twice

=== 2022-10-27-1 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 16:22, 2022 October 27 (CDT)

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

* fixed [[query L_Log_ownercheck_maker]] that has somehow messed up its column names and was breaking sending. [[User:Ttenbergen|Ttenbergen]] 16:22, 2022 October 27 (CDT)

=== 2022-10-27 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 10:00, 2022 October 27 (CDT)

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

* Fixed several problems that came up after re-import: VBA library references, and there were inconsistencies in s_CCI_... tables. Refrenced libraries and re-imported old tables.

=== 2022-10-26 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 15:36, 2022 October 26 (CDT)

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

* did a [[Recreate CCMDB.accdb]] to fix pw on exit on previous version

=== 2022-10-06 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 12:02, 2022 October 26 (CDT)

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

* updated Sub completeness_validation() which was not re-running Dx_Checker, which could let through records with Diag_Coomplete checked but the data later changed so it wouldn't qualified as checked any more.

* updated [[query check_Transfer_DtTm_after_paired_BL_and_before_later_BL]] which had a D_ID stuck in it from testing [[User:Ttenbergen|Ttenbergen]] 12:02, 2022 October 26 (CDT)

* updated [["set previous location to pre-admit" button]] to first check that the current [[Pre-admit Inpatient Institution]] value is allowed as a [[Previous Location]] entry

* un-yellowed the "D" checkbox label when form is newly opened (it will turn yellow only if there is a problem now.

* fixed triggering for [[query s_tmp_check_Boarding_Loc_and_TransferReadyDtTm_pairs]]

=== 2022-09-28 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 15:16, 2022 September 28 (CDT)

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

* added [[Query check_ICD10_trach_create_but_no_TISS]]

* added [[Query check_ICD10_trach_has_trach_but_no_TISS]]

=== 2022-09-13 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 09:15, 2022 September 21 (CDT)

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

* in [[Patient Viewer Tab Dispo]], moved the links to the wiki to the front of the window stack so they are clickable again - they somehow moved to the back in recent updates.

=== 2022-09-08r ===

rolled out [[User:Ttenbergen|Ttenbergen]] 19:33, 2022 September 8 (CDT)

'''Changes collectors need to know about:'''

*

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

* re-applied the changes of 2022-09-08 to 2022-09-07 after there was some corruption in that version that prevented sending and caused other strange errors. [[User:Ttenbergen|Ttenbergen]] 19:33, 2022 September 8 (CDT)

=== 2022-09-08 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 14:35, 2022 September 8 (CDT)

'''Changes collectors need to know about:'''

* changed the arrangement of fields and the tab order in [[Patient Viewer Tab Dispo]] as per collector request (they got messed up in the last update) [[User:Ttenbergen|Ttenbergen]] 14:35, 2022 September 8 (CDT)

=== 2022-09-07 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 10:12, 2022 September 8 (CDT)

'''Changes collectors need to know about:'''

* retired ICD10 code [[Gender identity disorder]] [[User:Ttenbergen|Ttenbergen]] 10:12, 2022 September 8 (CDT)

* retired [[Previous_Service field]]:

** removed from [[Patient Viewer Tab Dispo]], and re-arranged that tab since the complexity that led to that tree shaped layout is no longer applicable

** removed from [[Patient Viewer Tab Cognos ADT2]], and re-arranged all the registry boxes at the top of that form on one row and used the space to display more lines of tmp data on that page

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

* as part of retiring [[Previous_Service field]], eliminated [[function Validate_previous_service]] and [[Query check previous location vs service inconsistent]]

=== 2022-09-01 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 16:14, 2022 September 1 (CDT)

'''Changes collectors need to know about:'''

* [[Processes around changing a PatientFollow assignment]]: moved charts ending 01 and 02 from H9 to H7 laptop as of 2022-09-02 in [[S PatientFollow distribution table]] [[User:Ttenbergen|Ttenbergen]] 16:14, 2022 September 1 (CDT)

* fixed the [["View exclusions" button]] for unit starts and service starts in [[Patient Viewer]] - it will now show only the lines for the current record [[User:Ttenbergen|Ttenbergen]] 16:14, 2022 September 1 (CDT)

=== 2022-08-25 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 15:33, 2022 August 25 (CDT)

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

* Get [[ClientVisitGUID field]] field in [[L_Log table]] populated from Cognos:

** added field to [[Cognos2 Service Starter]]

** updated [[Cognos2_matcher query]] to include field

** updated sub AddPt to add field to [[L_Log table]]

* start sending [[ClientVisitGUID]] field, ie add it to the following queries:

* start sending [[ClientVisitGUID field]] field, ie add it to the following queries:

** ''send_Centralized_1L_Log__intermediate'' query

** ''Send_Centralized_1L_Log_append'' query

** ''Send_Centralized_1L_Log_update'' query

~~-->~~

=== 2022-08-15 ===

Line 29:

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 77:

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 83:

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 377:

Line 521:

'''Changes collectors need to know about:'''

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

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 505:

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-08-25 ===
+=== 2022-12-29-1 ===
-not rolled yet [[User:Ttenbergen|Ttenbergen]] 16:10, 2022 August 15 (CDT)
+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):
-* Get [[ClientVisitGUID]] field in [[L_Log table]] populated from Cognos:
+*
+-->
+=== 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 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 15:29, 2022 November 16 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+* removed [[Chronic Health APACHE]] - the field is no longer needed as per [[Change for Apache Chronic to ICD10 from separate variable]], and we confirmed during [[JALT_Meeting_-_Rolling_Agenda_and_Minutes_2022#JALT_Meeting_–_November_16,_2022]] that this can be removed
+=== 2022-11-02 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 10:08, 2022 November 10 (CST)
+Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
+* recreated db relationships that were still not restored after most recent [[Recreate CCMDB.accdb]]
+* added Sub SQL_relations_restorer and  Function CreateRelation
+* changed all all tabs in [[Patient Viewer]] to not yellow, some had been saved while yellow
+* updated [[Created_FirstService query]] to prevent duplication of records when the same service is entered twice
+=== 2022-10-27-1 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 16:22, 2022 October 27 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
+*  fixed [[query L_Log_ownercheck_maker]] that has somehow messed up its column names and was breaking sending. [[User:Ttenbergen|Ttenbergen]] 16:22, 2022 October 27 (CDT)
+=== 2022-10-27 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 10:00, 2022 October 27 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
+* Fixed several problems that came up after re-import: VBA library references, and there were inconsistencies in s_CCI_... tables. Refrenced libraries and re-imported old tables.
+=== 2022-10-26 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 15:36, 2022 October 26 (CDT)
+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
+* did a [[Recreate CCMDB.accdb]] to fix pw on exit on previous version
+=== 2022-10-06 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 12:02, 2022 October 26 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
+* updated Sub completeness_validation() which was not re-running Dx_Checker, which could let through records with Diag_Coomplete checked but the data later changed so it wouldn't qualified as checked any more.
+* updated [[query check_Transfer_DtTm_after_paired_BL_and_before_later_BL]] which had a D_ID stuck in it from testing [[User:Ttenbergen|Ttenbergen]] 12:02, 2022 October 26 (CDT)
+* updated [["set previous location to pre-admit" button]] to first check that the current [[Pre-admit Inpatient Institution]] value is allowed as a [[Previous Location]] entry
+* un-yellowed the "D" checkbox label when form is newly opened (it will turn yellow only if there is a problem now.
+* fixed triggering for [[query s_tmp_check_Boarding_Loc_and_TransferReadyDtTm_pairs]]
+=== 2022-09-28 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 15:16, 2022 September 28 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
+* added [[Query check_ICD10_trach_create_but_no_TISS]]
+* added [[Query check_ICD10_trach_has_trach_but_no_TISS]]
+=== 2022-09-13 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 09:15, 2022 September 21 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
+* in [[Patient Viewer Tab Dispo]], moved the links to the wiki to the front of the window stack so they are clickable again - they somehow moved to the back in recent updates.
+=== 2022-09-08r ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 19:33, 2022 September 8 (CDT)
+'''<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):
+* re-applied the changes of 2022-09-08 to 2022-09-07 after there was some corruption in that version that prevented sending and caused other strange errors. [[User:Ttenbergen|Ttenbergen]] 19:33, 2022 September 8 (CDT)
+=== 2022-09-08 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 14:35, 2022 September 8 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* changed the arrangement of fields and the tab order in [[Patient Viewer Tab Dispo]] as per collector request (they got messed up in the last update) [[User:Ttenbergen|Ttenbergen]] 14:35, 2022 September 8 (CDT)
+=== 2022-09-07 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 10:12, 2022 September 8 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* retired ICD10 code [[Gender identity disorder]] [[User:Ttenbergen|Ttenbergen]] 10:12, 2022 September 8 (CDT)
+* retired [[Previous_Service field]]:
+** removed from [[Patient Viewer Tab Dispo]], and re-arranged that tab since the complexity that led to that tree shaped layout is no longer applicable
+** removed from [[Patient Viewer Tab Cognos ADT2]], and re-arranged all the registry boxes at the top of that form on one row and used the space to display more lines of tmp data on that page
+Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
+* as part of retiring [[Previous_Service field]], eliminated [[function Validate_previous_service]] and [[Query check previous location vs service inconsistent]]
+=== 2022-09-01 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 16:14, 2022 September 1 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* [[Processes around changing a PatientFollow assignment]]: moved charts ending 01 and 02 from H9 to H7 laptop as of 2022-09-02 in [[S PatientFollow distribution table]] [[User:Ttenbergen|Ttenbergen]] 16:14, 2022 September 1 (CDT)
+* fixed the [["View exclusions" button]] for unit starts and service starts in [[Patient Viewer]] - it will now show only the lines for the current record [[User:Ttenbergen|Ttenbergen]] 16:14, 2022 September 1 (CDT)
+=== 2022-08-25 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 15:33, 2022 August 25 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
+* Get [[ClientVisitGUID field]] field in [[L_Log table]] populated from Cognos:
 ** added field to [[Cognos2 Service Starter]]
 ** updated [[Cognos2_matcher query]] to include field
 ** updated sub AddPt to add field to [[L_Log table]]
-* start sending [[ClientVisitGUID]] field, ie add it to the following queries:
+* start sending [[ClientVisitGUID field]] field, ie add it to the following queries:
 ** ''send_Centralized_1L_Log__intermediate'' query
 ** ''Send_Centralized_1L_Log_append'' query
 ** ''Send_Centralized_1L_Log_update'' query
--->
 === 2022-08-15 ===
@@ Line 29: / 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 77: / 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 83: / 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 377: / 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 414: / 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 505: / 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]]