CCMDB Wiki

CCMDB.accdb Change Log 2022: Difference between revisions

← Older edit
m Text replacement - "S Tmp" to "s_tmp table"
 
(106 intermediate revisions by the same user not shown)
Line 5: Line 5:
Change for next version:  
Change for next version:  


=== 2022-06-15-1===
=== 2022-12-29-1 ===
not rolled yet [[User:Ttenbergen|Ttenbergen]] 10:52, 2022 June 15 (CDT)
not rolled yet [[User:Ttenbergen|Ttenbergen]] 12:46, 2022 December 29 (CST)
<!----------------------------
<!----------------------------
not rolled yet ~~~~
not rolled yet ~~~~
Line 15: Line 15:


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 ===
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]] 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===
=== 2022-06-15===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:35, 2022 June 15 (CDT)
rolled out [[User:Ttenbergen|Ttenbergen]] 13:35, 2022 June 15 (CDT)
Line 278: Line 521:


'''<mark>Changes collectors need to know about:</mark>'''
'''<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):
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
Line 315: 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 [[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)
* 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 345: 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 in [[s_Cognos_Services table]] to only show on medicine laptops
* 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
* 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 406: 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 [[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
* 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]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Change_Log_2022"