CCMDB.accdb Change Log 2022

From CCMDB Wiki
Jump to navigation Jump to search

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