CCMDB.accdb Change Log 2022: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "S Tmp" to "s_tmp table")
 
(71 intermediate revisions by the same user not shown)
Line 5: Line 5:
Change for next version:  
Change for next version:  


=== 2022-08-15 ===
=== 2022-12-29-1 ===
not rolled yet [[User:Ttenbergen|Ttenbergen]] 09:28, 2022 August 11 (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):
* updated query ''send_set_oLog_to_sent'' used in [[sending]] to no longer reference [[FinalCheck]] field. ~~~~
*  
 
-->
-->
=== 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 ===
=== 2022-08-11 ===
Line 62: Line 221:


Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* Udpated sending, it was still referring the [[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 ===
=== 2022-08-04-1 ===
Line 68: Line 227:


Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* update to query patient_list, which was still referring to [[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 ===
=== 2022-08-04 ===
Line 362: 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 399: 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 490: 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]]

Latest revision as of 09:41, 2023 May 18

See Log (disambiguation) for other uses of the term "Log". See the 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-12-29-1

not rolled yet Ttenbergen 12:46, 2022 December 29 (CST)

2022-12-29

rolled out Ttenbergen 12:46, 2022 December 29 (CST)

Changes collectors need to know about:

2022-12-08

rolled out Ttenbergen 17:16, 2022 December 8 (CST)

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

2022-12-02-1

rolled out Ttenbergen 09:26, 2022 December 2 (CST)

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

2022-12-02

rolled out Ttenbergen 08:20, 2022 December 2 (CST)

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

2022-11-30

rolled out Ttenbergen 17:34, 2022 December 1 (CST)

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

2022-11-23

rolled out Ttenbergen 16:57, 2022 November 24 (CST)

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

2022-11-16

rolled out Ttenbergen 15:29, 2022 November 16 (CST)

Changes collectors need to know about:

2022-11-02

rolled out 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 Ttenbergen 16:22, 2022 October 27 (CDT)

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

2022-10-27

rolled out 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 Ttenbergen 15:36, 2022 October 26 (CDT)

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

2022-10-06

rolled out Ttenbergen 12:02, 2022 October 26 (CDT)

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

2022-09-28

rolled out Ttenbergen 15:16, 2022 September 28 (CDT)

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

2022-09-13

rolled out 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 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. Ttenbergen 19:33, 2022 September 8 (CDT)

2022-09-08

rolled out 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) Ttenbergen 14:35, 2022 September 8 (CDT)

2022-09-07

rolled out Ttenbergen 10:12, 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):

2022-09-01

rolled out Ttenbergen 16:14, 2022 September 1 (CDT)

Changes collectors need to know about:

2022-08-25

rolled out Ttenbergen 15:33, 2022 August 25 (CDT)

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

2022-08-15

rolled out 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. 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 Ttenbergen 09:28, 2022 August 11 (CDT)

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

2022-08-09-1

rolled out Ttenbergen 15:52, 2022 August 9 (CDT)

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

2022-08-09

rolled out 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. Ttenbergen 10:26, 2022 August 9 (CDT)

2022-08-05-1

rolled out Ttenbergen 11:07, 2022 August 5 (CDT)

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

2022-08-05

rolled out Ttenbergen 10:42, 2022 August 5 (CDT)

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

2022-08-04-2

rolled out 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 Ttenbergen 16:18, 2022 August 4 (CDT)

2022-08-04-1

rolled out 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 Ttenbergen 16:09, 2022 August 4 (CDT)

2022-08-04

rolled out 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 Ttenbergen 09:37, 2022 July 22 (CDT)

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

2022-07-12

rolled out Ttenbergen 16:22, 2022 July 12 (CDT)

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

2022-06-30

rolled out Ttenbergen 10:30, 2022 July 12 (CDT)

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

  • 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 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 Ttenbergen 10:52, 2022 June 15 (CDT)

Changes collectors need to know about:

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

2022-06-01

rolled out 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 Ttenbergen 15:53, 2022 May 31 (CDT)

Changes collectors need to know about:

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

2022-05-25

rolled out 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 Ttenbergen 17:15, 2022 May 19 (CDT)

Changes collectors need to know about:

2022-05-19

rolled out 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 Ttenbergen 17:12, 2022 May 18 (CDT)

Changes collectors need to know about:

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

2022-05-17

rolled out Ttenbergen 09:45, 2022 May 18 (CDT)

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

2022-05-11

rolled out 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 Ttenbergen 10:32, 2022 May 11 (CDT) Changes collectors need to know about:

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

2022-05-03-2

rolled out 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 Ttenbergen 14:44, 2022 May 3 (CDT)

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

2022-05-03

rolled out Ttenbergen 11:20, 2022 May 3 (CDT)

Changes collectors need to know about:

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 Ttenbergen 16:05, 2022 May 2 (CDT)

Changes collectors need to know about:

  • 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 Ttenbergen 15:28, 2022 May 2 (CDT)

Changes collectors need to know about:

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

2022-04-27

rolled out Ttenbergen 13:26, 2022 April 27 (CDT)

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

2022-04-26-1

rolled out Ttenbergen 10:05, 2022 April 27 (CDT)

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

2022-04-26

rolled out Ttenbergen 11:06, 2022 April 26 (CDT)

Changes collectors need to know about:

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

  • Added "No" option for opening a sent record

2022-04-21-1

rolled out Ttenbergen 17:41, 2022 April 21 (CDT)

Changes collectors need to know about:

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

2022-04-21

rolled out 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 Ttenbergen 21:47, 2022 April 20 (CDT)

Changes collectors need to know about:

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

2022-04-20-1

rolled out Ttenbergen 10:51, 2022 April 20 (CDT)

Changes collectors need to know about:

  • suspended showing apache scores for now because it was causing errors; may reinstate later

2022-04-20

rolled out Ttenbergen 10:33, 2022 April 20 (CDT)

Changes collectors need to know about:

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 Ttenbergen 16:07, 2022 April 19 (CDT)

Changes collectors need to know about:

  • 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 Ttenbergen 10:48, 2022 April 19 (CDT)

Changes collectors need to know about:

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

2022-04-13

rolled out Ttenbergen 14:58, 2022 April 13 (CDT)

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

2022-04-05

rolled out Ttenbergen 12:10, 2022 April 13 (CDT)

Changes collectors need to know about:

  • retired Drug-induced immunosuppression

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

2022-04-04-1

rolled out Ttenbergen 16:43, 2022 April 4 (CDT)

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

2022-04-04

rolled out Ttenbergen 15:24, 2022 April 4 (CDT)

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

2022-03-31-1

rolled out 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 Ttenbergen 09:45, 2022 March 31 (CDT)


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

2022-03-30

rolled out Ttenbergen 11:47, 2022 March 30 (CDT)

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

2022-03-24

rolled out Ttenbergen 14:31, 2022 March 24 (CDT)

Changes collectors need to know about:

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

2022-03-23

rolled out Ttenbergen 17:10, 2022 March 23 (CDT)

Changes collectors need to know about:

2022-03-22

rolled out Ttenbergen 14:07, 2022 March 22 (CDT)

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

2022-03-17

rolled out Ttenbergen 10:58, 2022 March 17 (CDT)

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

2022-03-09

rolled out Ttenbergen 15:16, 2022 March 10 (CST)

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

2022-03-02

rolled out Ttenbergen 13:48, 2022 March 2 (CST)

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

2022-03-01

rolled out Ttenbergen 09:18, 2022 March 1 (CST)

Changes collectors need to know about:

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

2022-02-17

rolled out Ttenbergen 09:05, 2022 March 1 (CST)

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

2022-02-16

rolled out Ttenbergen 09:15, 2022 February 17 (CST)

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

2022-02-14

rolled out Ttenbergen 11:46, 2022 February 16 (CST)

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

2022-02-09

rolled out Ttenbergen 11:35, 2022 February 14 (CST)

Changes collectors need to know about:

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

2022-02-22-2

rolled out Ttenbergen 16:47, 2022 February 2 (CST)

Changes collectors need to know about:

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

2022-02-22

rolled out Ttenbergen 09:42, 2022 February 2 (CST)

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

2022-01-27

rolled out Ttenbergen 16:35, 2022 January 27 (CST)

Changes collectors need to know about:

2022-01-26

rolled out Ttenbergen 09:58, 2022 January 26 (CST)

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

2022-01-25

rolled out Ttenbergen 09:43, 2022 January 25 (CST)

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

2022-01-11

rolled out Ttenbergen 10:03, 2022 January 11 (CST)

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

2022-01-10

rolled out Ttenbergen 11:56, 2022 January 10 (CST)

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

2022-01-07

rolled out 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 Ttenbergen 16:57, 2022 January 6 (CST)

Changes collectors need to know about:

  • 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. 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. Ttenbergen 16:57, 2022 January 6 (CST)

2022-01-05

rolled out Ttenbergen 08:36, 2022 January 6 (CST)

Changes collectors need to know about:

2021-...