CCMDB.accdb Change Log 2022: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (removed links to accept and arrive dttm)
Line 78: Line 78:


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


Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated [[Query send_check_centralized_is_owner]] to display link to wiki, and updated that wiki page to address a possible cause.  
* updated [[Query send_check_centralized_is_owner]] to display link to wiki, and updated that wiki page to address a possible cause.  
* [[query check_tmp_Boarding_Loc_Service_first_same]] - removed [[Accept DtTm]] in preparation for retiring this concept
* [[query check_tmp_Boarding_Loc_Service_first_same]] - removed Accept DtTm in preparation for retiring this concept
* replaced "query check_ER_Delay_not_too_big" and "query s_tmp_Boarding_Loc_ER_plus_LT_30" with [[query s_tmp_Boarding_Loc_ER_delay_reasonable]]
* replaced "query check_ER_Delay_not_too_big" and "query s_tmp_Boarding_Loc_ER_plus_LT_30" with [[query s_tmp_Boarding_Loc_ER_delay_reasonable]]
* deleted "L_First_Boarding_Loc_Non_ER" because it wasn't really doing what we need it to
* deleted "L_First_Boarding_Loc_Non_ER" because it wasn't really doing what we need it to
Line 118: Line 118:


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 the following queries to use first [[service tmp entry]] dt instead of [[Accept DtTm]] in preparation for [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]:  
* updated the following queries to use first [[service tmp entry]] dt instead of Accept DtTm in preparation for [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]:  
** [[query check_ICD10_date]]
** [[query check_ICD10_date]]
** [[query check_CCI_Date]]
** [[query check_CCI_Date]]
Line 227: 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):
* 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]]
* updated [[Function LOS()]] to use [[Created_AdmitDtTm query]] as input instead of [[Arrive DtTm]]
* updated [[Function LOS()]] to use [[Created_AdmitDtTm query]] as input instead of Arrive DtTm
* implemented [query check_CCI_vs_LOS_count_days_picklist]] and [[query check_CCI_vs_LOS_count_days_component]]
* implemented [query check_CCI_vs_LOS_count_days_picklist]] and [[query check_CCI_vs_LOS_count_days_component]]
* finally fixed and reinstated [[query check_ICD10_duplicates]]
* finally fixed and reinstated [[query check_ICD10_duplicates]]

Revision as of 13:44, 2022 April 21

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-04-21-1

not rolled yet Ttenbergen 09:16, 2022 April 21 (CDT)

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