CCMDB.accdb Change Log 2022

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-20-1

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

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:

• 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
• added Boarding Loc drop-down options "GRA_Med", "HSC_Med" and "STB_Med", see [[]] for use

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.
• 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
• deleted "L_First_Boarding_Loc_Non_ER" because it wasn't really doing what we need it to
• updated Patient_List query to use new Admit DtTm concept rather than old accept/arrive
• added Boarding Loc drop-down options "GRA_Med", "HSC_Med" and "STB_Med", see Boarding_Loc#Special_Case_-_cross-program_boarding for use
• retired query s_tmp_IICU_consult_DtTm

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

• un-excluded "GH Critical Care / General" in S Cognos Services table since it was hiding some GRA ICU admissions

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

• updated Cognos email importer to give better error message if file with the right subject line doesn't have an attachment. Ttenbergen 12:10, 2022 April 13 (CDT)
• added Past history of immunosuppressive drugs or corticosteroids to S ICD10 APACHE Como patterns table.
• added Capsule Endoscopy to S CCI Categories Collection Mode table as "each"

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

• correction to Check duplicate patient, was giving false positives

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

• 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_CCI_Date
  • query s_tmp_Boarding_Loc_date_item
  • Check duplicate patient - specifically, query Check_pt_multiples
  • Check Sub PharmCheck
  • Function long_LOS()
• tweaked "query s_tmp_Boarding_Loc_ER_plus_LT_30" which was flagging all records if anything was wrong with one record

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

• removed field complete_send' from S Tmp since it has not been used in a long time. 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. Ttenbergen 09:45, 2022 March 31 (CDT)

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

• false-positive in Query Check Inf Pathogens must have Infection requiring pathogen or Potential Infection: removed "pathogen" category from Botulism (due to Clostridium botulinum toxin) because it should only be listed as "Infection with implied pathogen"

2022-03-24

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

Changes collectors need to know about:

• updated Query check minimal data set incomplete flag any blank times in Service tmp entry or Boarding Loc; if you have the entry there should be no reason to have the time blank.

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

• added field ClientGUID field to Cognos_import3 table
• removed field "service_Type" from s_dispo table since it's no longer used. Ttenbergen 14:31, 2022 March 24 (CDT)
• updated Query check minimal data set incomplete flag any blank times in Service tmp entry or Boarding Loc; if you have the entry there should be no reason to have the time blank; use what Cognos gives you and update it later if needed.

2022-03-23

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

Changes collectors need to know about:

• Added Capsule Endoscopy

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

• updated all entries containing ALC 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
• updating Query check minimal data set incomplete to detect missing times

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

• added Neoplasm of uncertain behavior (i.e. not clear if benign or malignant), NOS to allowed duplicates to allowed duplicates in query check_ICD10_duplicates

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

• added Iatrogenic problem NOS, related to a surgery or procedure, NOS to allowed duplicates to allowed duplicates in query check_ICD10_duplicates
• updating Query check minimal data set incomplete to detect missing times

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

• added Past history, removal of organ NOS, Nosocomial infection, NOS and Sexually transmitted (venereal) infections, NOS to allowed duplicates to allowed duplicates in query check_ICD10_duplicates

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

• fixed S_previous_service table that had got corrupted Ttenbergen 09:18, 2022 March 1 (CST)

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

• fixed spelling for Supp O2 through any device, delivered via nose, mouth, ETT or trach (TISS Item) (was though instead of through)
• tweak query check_ICD10_duplicates#log

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

• updated Query Cognos2_sub_Services_VADT_finder#Log, to fix how the Patient copier button in Patient Viewer Tab Cognos ADT2 was setting a different Visit Admit DtTm

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

• updated query check_tmp_Boarding_Loc_Service_first_same to exclude RecordStatus "sent" and "deleted"
• updated query check_ICD10_duplicates which wasn't excluding allowed duplications properly

2022-02-09

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

Changes collectors need to know about:

• changed name of Fournier's gangrene (removed "in a male") - use this also for women
• added the "VA" button to more easily enter the Visit Admit DtTm into these fields when appropriate as per instructions.

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
• 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 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
• 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
• finally fixed and reinstated query check_ICD10_duplicates
• removed "S dispo chooser" functionality that had never been fully implemented

2022-02-22-2

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

Changes collectors need to know about:

• re-sorted the Boarding Loc entries so the new ones are at the top before the services, and the ones we will eventually no longer use are at the bottom after the services.
• updated "make loc" button to populate the Boarding Loc entry from Cognos Unit listing in Patient Viewer Tab Cognos ADT2

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

• updated s_Cognos_Units_additions_needed query and s_Cognos_Services_additions_needed query to include the MRN that has the not-seen-before unit or service
• fixed spelling for Anti-arrhythmic, overdose/toxicity and Anti-arrhythmic, adverse effect
• removed "GH-IP-Surgical Day Care" from Boarding Loc dropdown Ttenbergen 16:47, 2022 February 2 (CST)

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

• updated Boarding Loc "SBGH-L2HA" in s_tmp table to be visible for CC laptops as well Ttenbergen 09:42, 2022 February 2 (CST)

2022-01-27

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

Changes collectors need to know about:

• updated s_tmp table Boarding Loc entries for Change of remaining location names from "our" names to EPR/Cognos names:
  • changed old ones to sort order 1 so they show up in top of dropdown list; this is because most new entries should come from Cognos directly during Using Cognos2 to keep track of patients, so the old ones are more likely to be manually entered until we get rid of them altogether.
  • added new Boarding Loc options as sort order 99
  • updated [s_Cognos_Units table]] with column "dispo" entries we identified in Excel table during conversation with Julie, Lisa and Tina Ttenbergen 16:35, 2022 January 27 (CST)
• removed old Boarding Loc from S tmp table: HSC_Med

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

• had set the default sort order to "general" from "general - legacy" while working on something else; this caused Pre-send Checker to crash on Query s tmp apostrophe in comment. Changed the setting back to "general - legacy".

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

• updated Query check CCI ICD10 Dialysis no Dx to use param so it can be triggered from checkbox

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

• tweak to fix Query check CCI TISS discontinuous ETT

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

• tweak to fix Query check CCI TISS discontinuous ETT

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:

• retired "HSC_CC" from s_dispo table
• changed default entry for service location for HSC Critical Care laptops to blank; this will still need to be entered as part of starting the record (edit in s_locations_allowed_collection table) Ttenbergen 08:36, 2022 January 6 (CST)

2021-...

• see CCMDB.accdb Change Log 2021