View source for CCMDB.accdb Change Log 2022

__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
See [[Log (disambiguation)]] for other uses of the term "Log". See the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''. See [[Rolling out changes]] for the process of rolling out changes. See also '''[[requested CCMDB changes for the next version]]''' and '''[[CCMDB.accdb Data Integrity Checks]]'''. 

== Versions ==
Change for next version: 

=== 2022-09-28-1 ===
not rolled yet [[User:Ttenbergen|Ttenbergen]] 15:16, 2022 September 28 (CDT)
<!----------------------------
not rolled yet ~~~~
rolled out ~~~~

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

=== 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]] 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 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:10, 2022 August 15 (CDT)

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

=== 2022-08-11 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:28, 2022 August 11 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* fixed error in [[query check_CCI_TISS_discontinuous_ETT]] for long-LOS patients

=== 2022-08-09-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:52, 2022 August 9 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updates to bring in [[ClientGUID field]]
** updated [[Cognos2_OneTime table]] to include field
** updated [[Cognos2_import_Cognos2_OneTime query]] to take field from Cognos_import3 table, where we already had it 
** updated Sub AddPt and Sub Patient_Copier to include field
** added tb_ClientGUID hidden element to [[Cognos2 Service Starter]] to contain field
** updated [[Cognos2_matcher query]] to include field
* made [[HSC ALC Medicine Service]] entries available in [[S tmp table]]

=== 2022-08-09 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:26, 2022 August 9 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* Updated [[Delete button]] code in Sub cb_Delete_Sent_Patients_Click() to no longer update the fields that were recently deleted. [[User:Ttenbergen|Ttenbergen]] 10:26, 2022 August 9 (CDT)

=== 2022-08-05-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:07, 2022 August 5 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* [[Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm]] still had a call, removed it

=== 2022-08-05 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:42, 2022 August 5 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated things which still contained the old fields. 
** [[L_Log+ query]] 
** Sub PatientCopier
** [[query check_ICD10_awaiting_has_Transfer_Ready_DtTm]]
* deleted query [[query check_ICD10_needs_awaiting_if_TR_Dt_and_Dispo_Dt_on_diff_days]] and [[Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm]] that had been incomplete and declined, but contained the old [[Transfer_Ready_DtTm]]

=== 2022-08-04-2 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:18, 2022 August 4 (CDT)

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)

=== 2022-08-04-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:09, 2022 August 4 (CDT)

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)

=== 2022-08-04 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:02, 2022 August 4 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated Sub Convert_DB to work for [[CCMDB data.mdb Change Log#2022-08-04]]
* removed call to compact_runner from Sub oneLastOldDB_Connect() - wasn't working anyway because that db is already and still connected at this point so this was just trowing error; we run compact_runner all the time so it's not really needed here.

=== 2022-07-13 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:37, 2022 July 22 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* changed ICD10 code for [[Gallbladder or bile ducts, traumatic laceration/rupture]] from S36.11 to S36.18 at Allan's request and updated wiki

=== 2022-07-12 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:22, 2022 July 12 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[query check_tmp_Service_and_Boarding_Loc_during_admission_timeframe]] to also flag if the entry is inactive.

=== 2022-06-30 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:30, 2022 July 12 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* deleted ''Cognos2_Hospital_Discharge'' query and corresponding wiki pages [[User:Ttenbergen|Ttenbergen]] 10:30, 2022 July 12 (CDT)
* updated [[Cognos2_matcher query]] to make it clearer that it uses [[S PatientFollow distribution table]] correctly [[User:Ttenbergen|Ttenbergen]] 10:30, 2022 July 12 (CDT)
* removed the following fields  
:::* [[DC Treatment]]; [[Off ward field]]; [[Transfer Ready DtTm field]]
::* from sending queries 
:::* Send_Centralized_1L_Log_update, Send_Centralized_1L_Log_append, 
* removed old single-use queries: COV_1L_Log_twinner; patientFollow_copy_L_Log; COV_L_Log_orig_dispo_updater;

=== 2022-06-15===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:35, 2022 June 15 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* re-did the 2022-06-14 changes because that version required a password on close, ie was corrupted.

=== 2022-06-14===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:52, 2022 June 15 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* Added the [[blue button in CCI Picklist]]

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* disabled "GH-MICU" in [[s_dispo table]]; "GH-CC" should have been used instead for some time now. 
* excluded "HSC Addictions / Addictions" in [[S Cognos Services table]]

=== 2022-06-01===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:52, 2022 June 8 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* removed exclusion from a number of STB cardiac services that had recently been excluded
* added automation to purge old Cognos exclusions so those files don't grow indefinitely
** added query sL_Cognos2_Service_exclusions_purger  and query sL_Cognos2_Unit_exclusions_purger which delete records with service/unit enddttm more than 365 days ago, and added running of these queries to Function Database_Starter()
* corrected problem where CSS would not enter demographics if a logically deleted record was the most recent record (edited query ''query Form_Cognos2_Service_Starter_latest_previous_entry_finder'') 
* updated hover hint for [[Supp O2 through any device, delivered via nose, mouth, ETT or trach (TISS Item)]]

=== 2022-05-31 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:53, 2022 May 31 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* updated [[CSS]] to list all IICU service patients for all HSC CC laptops, ie exempt this from PatientFollow; this means collectors will now have to exclude the ones they don't collect, but they will no longer need to manually enter IICU patients whose chart endings don't assign them to their laptops. 

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* update to fix [[Run-time error when closing the Notes field]]
* update to [[query check_minimal_data_set_incomplete]] to catch an empty [[Service/Location]] scenario not previously accounted for.

=== 2022-05-25 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:46, 2022 May 25 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* excluded the following from listing in CSS: 
** SBGH Cardiac / Cardiology
** SBGH Cardiac / Cardiology A Service
** SBGH Cardiac / Cardiology B 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
* updated tmp cross checks 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 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 17:15, 2022 May 19 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* added error message to scrolling in [[Patient Viewer Tab Cognos ADT2]] Cognos Service and Unit subforms, since using scroll bar in there was causing errors (see [[The "make loc" button will sometimes enter a different record than the line that it is clicked on.]]). Still hoping for a more long-term solution, but this should prevent errors in the short run. [[User:Ttenbergen|Ttenbergen]] 17:15, 2022 May 19 (CDT)

=== 2022-05-19 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:07, 2022 May 19 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* change to the [[MR Organizer form]] - only lists MR records now, and shows Dispo_DtTm properly. Not sure why it was rolled out without those before, the version on my desktop had them when I logged in this morning, so this is essentially just a re-roll.

=== 2022-05-18 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 17:12, 2022 May 18 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* Created the [[MR Organizer form]]

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updating [[query s_tmp_Boarding_Loc_date_item]] to show Pat_ID again, it had been accidentally removed

=== 2022-05-17 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:45, 2022 May 18 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* made [[Vagina or vulva, inflammatory or infectious disorder NOS]] into a [[:Category:Potential infection|Potential infection]] so it can satisfy the need for a pathogen to have an infection dx 
* Updated the data integrity check form to not grab the Patient ID when called from pre-send checker (where it will need to run for all records, not just one)

=== 2022-05-11 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:42, 2022 May 11 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated query ''Cognos2_Ender_Service_formQuery'' to no longer use accept and arrive dttm to fix missing entries in [[CE]]

=== 2022-05-05 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:32, 2022 May 11 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* removed [[DC Treatment]] field from [[Patient Viewer Tab Dispo]]
* made "Other Procedure Location" available in [[Dispo]] dropdown [[User:Ttenbergen|Ttenbergen]] 10:32, 2022 May 11 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated Function Ap_Chronic and made a test function for it
* added [[Function LOS int()]] and updated [[query check_CCI_vs_LOS_count_days_picklist]] and [[query check_CCI_vs_LOS_count_days_component]] to use it to fix error were giving false positives (also for validating pharmacy entry)
* updated ''Sub PharmCheck()'' to also use LOS_int

=== 2022-05-03-2 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:21, 2022 May 5 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[S_ICD10_APACHE_Como_patterns table]] as per email exchange "RE: APACHE Dx and Chronic, and Charlson and chapter patterns and NOT KEEPING MULTIPLE COPIES OF INFORMATION" and "RE: updated APACHE 2 comorbid conditions coding"

=== 2022-05-03-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 14:44, 2022 May 3 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* retired [[Query s tmp check combined BL and TRDtTm nonsequential]] and replaced it with [[query check_Transfer_DtTm_after_paired_BL_and_before_later_BL]]

=== 2022-05-03 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:20, 2022 May 3 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* updated the "view excluded" buttons on [[Patient Viewer Tab Cognos ADT2]] to filter to the current MRN (finally found a way to do this, yay) [[User:Ttenbergen|Ttenbergen]] 10:28, 2022 May 3 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* imported update to [[S dispo table]] from Julie's email from 04-29 10:59
* updated when the data is refreshed after an update in the tmp subform of the [[Patient Viewer Tab Cognos ADT2]] - it used to be updated immediately after editing and will now only update after leaving that subform; hopefully this will make it less glitchy for collectors.

=== 2022-04-28-2 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:05, 2022 May 2 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* updated [[Cognos2_UnitStarter query]] so that once you exclude a unit once in [[CUS]] you won't have to exclude it each day while the pt is still on that unit.

=== 2022-04-28 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:28, 2022 May 2 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* in [[Patient Viewer Tab Cognos ADT2]], made the listings for Cognos units and services less tall, and the listing for what has been entered taller, in order to reduce the jumping around of the screen when editing data that has been entered. 

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[Function LOS()]]
* updated [[query check_tmp_Service_and_Boarding_Loc_during_admission_timeframe]] and [[Cognos2 UnitStarter query]] to stop using Accept and Arrive DtTm

=== 2022-04-27 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:26, 2022 April 27 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[query s_tmp_Boarding_Loc_ER_delay_reasonable]] to use a threshold of 144hrs for med instead of the previous 77 
* fixed [[Created_FirstLocation query]] where I had renamed a field during troubleshooting and not named it back...

=== 2022-04-26-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:05, 2022 April 27 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* fixed date format for [[Admit DtTm]] in [[Patient List]] and [[MR List]] to "yyyymmmdd hh:nn"
* fixed code that sets focus to the [[Patient Viewer Tab Cognos ADT2]]

=== 2022-04-26 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:06, 2022 April 26 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* more [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]: 
** removed fields form [[Patient Viewer Tab Dispo]] 
** removed fields from [[Patient Viewer Tab Cognos ADT2]]

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* more [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]: 
** removed event handlers that auto-fill these fields and other functions

* removed other old fields form [[Patient Viewer Tab Dispo]] 
** [[Transfer Ready DtTm]]
** [[Off ward field]]

* Added "No" option for opening a sent record

=== 2022-04-21-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 17:41, 2022 April 21 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* 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.

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* further tweaks to Cognos Unit adder to allow it to add Transfer Ready dates automatically again
* fixed sorting by [[Admit DtTm]] in [[Patient List]]
* updated [[Query Form_Cognos2_Service_Starter_latest_previous_entry_finder]] to use [[Admit DtTm]] instead of "Arrive DtTm", "Accept DtTm" and [[Visit_Admit DtTm]]
* updated [[s_dispo table]].meanLOS3STD with data from Julie
* updated [[query s_tmp_Boarding_Loc_ER_delay_reasonable]] threshold to new mean+3sd as provided by Julie: 73hrs for Med and 67hrs for CC
* removed leftovers from long ago [[Check Accept Loc Park]]
* removed functions Validate_Accept_DtTm() and Validate_Arrive_DtTm() and all calls to them
* removed [[Function Dispo_Chronological()]]
* updated [[Query check minimal data set incomplete]] to no longer check Accept and Arrived DtTm and old Transfer Ready DtTm field

=== 2022-04-21 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:16, 2022 April 21 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* update to re-enable entering records into tmp from Cognos tab, broke through some weird regression error

=== 2022-04-20-2 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 21:47, 2022 April 20 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* suspended showing apache scores for now because it was causing errors; may reinstate later
* made "Other Procedure Location" available as [[Dispo]] in [[s_dispo table]] to deal with special cases in [[Medical Assistance In Dying]] resp [[Visits to temporary locations]]
* made the apache score frames solid to make them more visible to collectors; clicking in these fields will provide you with the score ranges for the field
* updated date format for Admit DtTm in [[Patient List]], it got broken in a recent update
* added [[♻️ button]] button to [[Patient List]] since the old way of selecting the line will no longer work with the new query-based setup

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[Created AdmitDtTm query]] to return an "empty" rather than a "null" if there is no first service yet; this difference was breaking new patient creation
* made invisible the plain "Add patient" button to see if anyone will notice, ie if still used
* fixed how the [[Patient Viewer]] form is opened to fix strange regression where it wouldn't open it with new record 
* removed [[query check_ICD10_duplicates]]
* added requery calls to Cognos ADT2 tab to update the new first service lister at the top of [[Patient List]] when a line is changed
* finished replacing "query s_tmp_Boarding_Loc_ER_plus_LT_30" with [[query s_tmp_Boarding_Loc_ER_delay_reasonable]], and fixed [[query s_tmp_Boarding_Loc_ER_delay_reasonable]]
* updated [[CUS]] to open [[Patient Viewer]] with parameter ''acFormEdit'', which is now necessary for some reason
* removed references to the APACHE age and score from [[Patient Viewer Tab APACHE]] - they were causing problems after replacing Accept Dttm with  first service dttm

=== 2022-04-20-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:51, 2022 April 20 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* suspended showing apache scores for now because it was causing errors; may reinstate later

=== 2022-04-20 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:33, 2022 April 20 (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):
* updated [[Created AdmitDtTm query]] to no longer try to cast the dates into dates, they are dates and don't need casting
* fixed Sub ApScr_age_caller() that would throw error if a proper admit dttm not yet available due to entry sequence

=== 2022-04-19 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:07, 2022 April 19 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* fixed a problem with [[MR List]] that had been introduces with last update (asks for parameters)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* removed "MR copy-paste" button after confirmation that it is not used 
* removed the wifi disconnect from [[sending]] - it was causing problems for some collectors; hopefully whatever problems it was supposed to address when first set up are no longer an issue. 
* updated [[MR List]] to use [[Admit DtTm]] rather than ''Arrive DtTm''
* updated function ApScr_age_caller() that calculates the apache age to use [[Admit DtTm]] vs accept dttm.

=== 2022-04-14 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:48, 2022 April 19 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* updated [[Patient Viewer]] to eliminate the Accept DtTm and Arrive DtTm listings at the top and replace it with the first [[Service tmp entry]] DtTm
* updated [[Patient List]] form to use [[Admit DtTm]] instead of Arrive DtTm
* added [[Boarding Loc]] drop-down options "GRA_Med", "HSC_Med" and "STB_Med", see [[Visits to temporary locations]] for use

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[Query send_check_centralized_is_owner]] to display link to wiki, and updated that wiki page to address a possible cause. 
* [[query check_tmp_Boarding_Loc_Service_first_same]] - removed Accept DtTm in preparation for retiring this concept
* replaced "query check_ER_Delay_not_too_big" and "query s_tmp_Boarding_Loc_ER_plus_LT_30" with [[query s_tmp_Boarding_Loc_ER_delay_reasonable]]
* deleted "L_First_Boarding_Loc_Non_ER" because it wasn't really doing what we need it to
* updated ''Patient_List'' query to use new [[Admit DtTm]] concept rather than old accept/arrive
* added [[Boarding Loc]] drop-down options "GRA_Med", "HSC_Med" and "STB_Med", see [[Boarding_Loc#Special_Case_-_cross-program_boarding]] for use
* retired [[query s_tmp_IICU_consult_DtTm]]

=== 2022-04-13 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 14:58, 2022 April 13 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* un-excluded "GH Critical Care / General" in [[S Cognos Services table]] since it was hiding some GRA ICU admissions

=== 2022-04-05 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 12:10, 2022 April 13 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* retired [[Drug-induced immunosuppression]]

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated Cognos email importer to give better error message if file with the right subject line doesn't have an attachment. [[User:Ttenbergen|Ttenbergen]] 12:10, 2022 April 13 (CDT)
* added [[Past history of immunosuppressive drugs or corticosteroids]] to [[S ICD10 APACHE Como patterns table]].
* added [[Capsule Endoscopy]] to [[S CCI Categories Collection Mode table]] as "each"

=== 2022-04-04-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:43, 2022 April 4 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* correction to [[Check duplicate patient]], was giving false positives

=== 2022-04-04 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:24, 2022 April 4 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated the following queries to use first [[service tmp entry]] dt instead of Accept DtTm in preparation for [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]: 
** [[query check_ICD10_date]]
** [[query check_CCI_Date]]
** [[query s_tmp_Boarding_Loc_date_item]]
** [[Check duplicate patient]] - specifically, query Check_pt_multiples
** [[Check Sub PharmCheck]]
** [[Function long_LOS()]]
* tweaked "query s_tmp_Boarding_Loc_ER_plus_LT_30" which was flagging all records if anything was wrong with one record

=== 2022-03-31-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:38, 2022 March 31 (CDT)

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

=== 2022-03-31 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:45, 2022 March 31 (CDT)


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

=== 2022-03-30 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:47, 2022 March 30 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* false-positive in [[Query Check Inf Pathogens must have Infection requiring pathogen or Potential Infection]]: removed "pathogen" category from [[Botulism (due to Clostridium botulinum toxin)]] because it should only be listed as "Infection with implied pathogen"

=== 2022-03-24 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 14:31, 2022 March 24 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* updated [[Query check minimal data set incomplete]] flag any blank times in [[Service tmp entry]] or [[Boarding Loc]]; if you have the entry there should be no reason to have the time blank.

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* added field [[ClientGUID field]] to [[Cognos_import3 table]]
* removed field "service_Type" from [[s_dispo table]] since it's no longer used. [[User:Ttenbergen|Ttenbergen]] 14:31, 2022 March 24 (CDT)
* updated [[Query check minimal data set incomplete]] flag any blank times in [[Service tmp entry]] or [[Boarding Loc]]; if you have the entry there should be no reason to have the time blank; use what Cognos gives you and update it later if needed.

=== 2022-03-23 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 17:10, 2022 March 23 (CDT)

'''<mark>Changes collectors need to know about:</mark>'''
* Added [[Capsule Endoscopy]]

=== 2022-03-22 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 14:07, 2022 March 22 (CDT)

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 "SBGH Womens Health / General" in [[s_Cognos_Services table]] to be automatically excluded
* updating [[Query check minimal data set incomplete]] to detect missing times

=== 2022-03-17 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:58, 2022 March 17 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* added [[Neoplasm of uncertain behavior (i.e. not clear if benign or malignant), NOS]] to allowed duplicates to allowed duplicates in [[query check_ICD10_duplicates]]

=== 2022-03-09 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:16, 2022 March 10 (CST)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* added [[Iatrogenic problem NOS, related to a surgery or procedure, NOS]] to allowed duplicates to allowed duplicates in [[query check_ICD10_duplicates]]
* updating [[Query check minimal data set incomplete]] to detect missing times

=== 2022-03-02 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:48, 2022 March 2 (CST)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* added [[Past history, removal of organ NOS]], [[Nosocomial infection, NOS]] and [[Sexually transmitted (venereal) infections, NOS]] to allowed duplicates to allowed duplicates in [[query check_ICD10_duplicates]]

=== 2022-03-01 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:18, 2022 March 1 (CST)

'''<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):
* fixed [[S_previous_service table]] that had got corrupted [[User:Ttenbergen|Ttenbergen]] 09:18, 2022 March 1 (CST)

=== 2022-02-17 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:05, 2022 March 1 (CST)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* fixed spelling for [[Supp O2 through any device, delivered via nose, mouth, ETT or trach (TISS Item)]] (was though instead of through)
* tweak [[query check_ICD10_duplicates#log]]

=== 2022-02-16 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:15, 2022 February 17 (CST)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[Query Cognos2_sub_Services_VADT_finder#Log]], to fix how the [[Patient copier button]] [[image:Patient Copy button.png]] in [[Patient Viewer Tab Cognos ADT2]] was setting a different [[Visit Admit DtTm]]

=== 2022-02-14 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:46, 2022 February 16 (CST)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[query check_tmp_Boarding_Loc_Service_first_same]] to exclude [[RecordStatus]] "sent" and "deleted"
* updated [[query check_ICD10_duplicates]] which wasn't excluding allowed duplications properly

=== 2022-02-09 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:35, 2022 February 14 (CST)

'''<mark>Changes collectors need to know about:</mark>'''
* changed name of [[Fournier's gangrene]] (removed "in a male") - use this also for women 
* added the [["VA" button]] to more easily enter the [[Visit Admit DtTm]] into these fields when appropriate as per instructions. 

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* 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 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]]
* updated [[Function LOS()]] to use [[Created_AdmitDtTm query]] as input instead of Arrive DtTm
* implemented [query check_CCI_vs_LOS_count_days_picklist]] and [[query check_CCI_vs_LOS_count_days_component]]
* finally fixed and reinstated [[query check_ICD10_duplicates]]
* removed "S dispo chooser" functionality that had never been fully implemented

=== 2022-02-22-2 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:47, 2022 February 2 (CST)

'''<mark>Changes collectors need to know about:</mark>'''
* re-sorted the [[Boarding Loc]] entries so the new ones are at the top before the services, and the ones we will eventually no longer use are at the bottom after the services. 
* updated [["make loc" button]] to populate the [[Boarding Loc]] entry from Cognos Unit listing in [[Patient Viewer Tab Cognos ADT2]]

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[s_Cognos_Units_additions_needed query]] and [[s_Cognos_Services_additions_needed query]] to include the MRN that has the not-seen-before unit or service
* fixed spelling for [[Anti-arrhythmic, overdose/toxicity]] and [[Anti-arrhythmic, adverse effect]]
* removed "GH-IP-Surgical Day Care" from [[Boarding Loc]] dropdown [[User:Ttenbergen|Ttenbergen]] 16:47, 2022 February 2 (CST)

=== 2022-02-22 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:42, 2022 February 2 (CST)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[Boarding Loc]] "SBGH-L2HA" in [[s_tmp table]] to be visible for CC laptops as well [[User:Ttenbergen|Ttenbergen]] 09:42, 2022 February 2 (CST)

=== 2022-01-27 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:35, 2022 January 27 (CST)

'''<mark>Changes collectors need to know about:</mark>'''
* updated [[s_tmp table]] [[Boarding Loc]] entries for [[Change of remaining location names from "our" names to EPR/Cognos names]]:
** changed old ones to sort order 1 so they show up in top of dropdown list; this is because most new entries should come from Cognos directly during [[Using Cognos2 to keep track of patients]], so the old ones are more likely to be manually entered until we get rid of them altogether. 
** added new [[Boarding Loc]] options as sort order 99
** updated [s_Cognos_Units table]] with column "dispo" entries we identified in Excel table during conversation with Julie, Lisa and Tina [[User:Ttenbergen|Ttenbergen]] 16:35, 2022 January 27 (CST)
* removed old [[Boarding Loc]] from [[S tmp table]]: HSC_Med

=== 2022-01-26 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:58, 2022 January 26 (CST)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* had set the default sort order to "general" from "general - legacy" while working on something else; this caused [[Pre-send Checker]] to crash on [[Query s tmp apostrophe in comment]]. Changed the setting back to "general - legacy".

=== 2022-01-25 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:43, 2022 January 25 (CST)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[Query check CCI ICD10 Dialysis no Dx]] to use param so it can be triggered from checkbox

=== 2022-01-11 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:03, 2022 January 11 (CST)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* tweak to fix [[Query check CCI TISS discontinuous ETT]]

=== 2022-01-10 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:56, 2022 January 10 (CST)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* tweak to fix [[Query check CCI TISS discontinuous ETT]]

=== 2022-01-07 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:47, 2022 January 7 (CST)

Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated the error window to work properly from Pre-sent checker as well; most recent version had contained an update that broke this.

=== 2022-01-06 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:57, 2022 January 6 (CST)

'''<mark>Changes collectors need to know about:</mark>'''
* added cross-check [[query check_CCI_TISS_discontinuous_ETT]]; this is a soft check so you can still send a patient where this triggers, but please let me know about false positives so we can fine tune it. [[User:Ttenbergen|Ttenbergen]] 16:57, 2022 January 6 (CST)
* added button "Open Triggering Query" to the form that displays errors and URLs; if the query is not clear on what causes the problem, collectors can click this button to open the query that raised the error, and hopefully that query will provide more info about exactly what is wrong. [[User:Ttenbergen|Ttenbergen]] 16:57, 2022 January 6 (CST)

=== 2022-01-05 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 08:36, 2022 January 6 (CST)

'''<mark>Changes collectors need to know about:</mark>'''
* retired "HSC_CC" from [[s_dispo table]]
* changed default entry for service location for HSC Critical Care laptops to blank; this will still need to be entered as part of starting the record (edit in [[s_locations_allowed_collection table]]) [[User:Ttenbergen|Ttenbergen]] 08:36, 2022 January 6 (CST)

=== 2021-... ===
* see [[CCMDB.accdb Change Log 2021]]

[[Category:CCMDB.accdb]]
[[Category:Change Logs CCMDB]]