CCMDB.accdb Change Log 2022: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 12: Line 12:


'''<mark>Changes collectors need to know about:</mark>'''
'''<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):
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 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.  
* update to [[query check_minimal_data_set_incomplete]] to catch an empty [[Service/Location]] scenario not previously accounted for.  
{{Todo
* updated [[CSS]] to list all IICU service patients for all HSC CC laptops, ie exempt this from PatientFollow.
| who =  Tina
| todo_added = 2022-05-31
| todo_action = 2022-05-31
| question = 
* change CSS so HSC ICU sees all IICU }}
-->
-->



Revision as of 15:47, 2022 May 31

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-05-31

not rolled yet Ttenbergen 13:46, 2022 May 25 (CDT)

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:

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