CCMDB.accdb Change Log 2023

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.

2023-11-25

NOT ROLLED OUT YET Ttenbergen 09:29, 2023 November 25 (CST)

Changes collectors need to know about:

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

• deleted old temp queries 2022_08_04_L_Log_Convert, 0_tmp_Cognos_combiner, 0_tmp_Cognos_units_vs_BoardingLoc, 0_tmp_Cognos_units_vs_dispo, 1_delete, 1_infDisease_mess, 1test
• deleted old queries we never turned to regular use COV_L_ICD10_Twinner, COV_L_Pharm_Flowsheet_Twinner
• deleted old query "check_ER_Delay_not_too_big" that has not been used since 2022-04-14
• deleted old queries "form_new_pt_helper_list", "S_AdmitDischarge_to_wiki", "s_tmp_comfort_care_gt_one", "s_tmp_QAInf__dx", "s_tmp_QAInf__tmp", "COV_0_PatID_negative" that aren't used any more
• confirmed that queries will work after Change to having each collector collect both programs on the same laptop:
  • changed
    • query check_CCI_Component_duplicates - incidental finding that this didn't use the usual column names, fixed
    • query check_CCI_from_OR_no_CCI - incidentally found this to have "*" selected and to not be properly editable, fixed
    • query check_CCI_Picklist_duplicates - incidental finding that this didn't use the usual column names, fixed
    • query check_CCI_TISS_if_no_then_none - was checking for program but doesn't need to since Med shouldn't collect T1 - No TISS Item (TISS Item) in the first place
    • updated to use new function admission_program([L_Log.Pat_ID]): query check_CCI_TISS_NrDays_GT_LOS, query check_CCI_TISS_NrDays_LT_LOS, query check_ICD10_CLI_vs_CCI_CentralLine, Query check_ICD10_trach_has_trach_but_no_TISS, [[

• left off at Cognos2 matcher query which will need a change

• • no change needed
    • confirmed query check_AIDS_vs_HIV , query Check_BL_TR_combiner_null, query check_CCI_component_1_and_2_compatible, query check CCI Component no admin entries, query check_CCI_Component_unfilled, query check_CCI_Date, query check_CCI_ICD10_Dialysis_no_Dx, query check_CCI_if_no_then_none, query check_CCI_must_have_entry, query check_CCI_Picklist_if_no_admin_entries, query check_CCI_Picklist_unfilled, query check_CCI_TISS_CAM_positive_vs_Dx, query check_CCI_TISS_discontinuous_ETT, query check_CCI_TISS_Intubation_vs_Intubated, query check_CCI_TISS_matching_BoardingLoc_time, query check_CCI_TISS_Pharm_Vasoactive, query check_CCI_TISS_time_means_must_be_two, query check_CCI_TISS_Vented_without_mechanism, query check_CCI_vs_LOS_count_days_component, query check_CCI_vs_LOS_count_days_picklist, query check_cooling_vs_arrest, query check_dx_primary_lowest_priority, query check_dx_primary_not_exactly_one
    • then decided to only confirm queries that are likely to have a change...
    • confirmed query s_tmp_Boarding_Loc_ER_delay_reasonable doesn't need change because it already draws from service/loc

2023-11-23

Not rolled out yet Ttenbergen 17:28, 2023 November 5 (CST)

NOT ROLLED OUT YET - but copied up for Lisa to test.

Changes collectors need to know about:

• Change to having each collector collect both programs on the same laptop:
  • Changed the drop-downs for Patient Viewer and New Pt Serial helper form to list all Service/Locations for sites; make sure you use only appropriate program locations as per current directions, which may vary by site and collector during the roll-out.

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

• This update rolls up several previous changes that made the program unusable
• added function Default_Service_Location()
• added query admission_program to supply dropdowns for Patient Viewer and New Pt Serial helper form
• changed s_dispo.s_location to "true" for HSC_IICU, HSC_MICU, HSC_SICU - should have been all along but somehow wasn't
• Change to having each collector collect both programs on the same laptop:
  • y Changed Sub Patient_Adder(ID) to also add Location, and early, since it is needed to do hiding.
  • y Added Legacy_Hider to Sub form_view.service_location_AfterUpdate() to be able to change view mode after a change to Service_Location.
  • y updated sub Legacy_Hider (which hides or shows CCMDB parts based on program) to get the record's program using new function admission_program
  • y added function admission_program() which determines the program per admission rather than per laptop; it gets its program from a given record's Service/Location rather than from Settings
  • y updated Query s_serviceLocation_local to no longer use S locations allowed collection table and consider only site and S dispo table.s_location instead
  • y deleted s_locations_allowed_collection table

2023-11-01

rolled out Lisa Kaita 10:56, 2023 November 1 (CDT)

Changes collectors need to know about:

• Changed Progressive Multifocal Leukoencephalopathy (PML) to no longer be an infection with implied pathogen and to be a potential infection instead

2023-09-28

rolled out Haubel 12:25, 2023 September 28 (CDT)

Changes collectors need to know about:

• Added "EuroSCORE II Phy" to EuroSCORE II

2023-09-27

rolled out Lisa Kaita 15:28, 2023 September 27 (CDT)

Changes collectors need to know about:

• updated Bronchitis, chronic, infectious or noninfectious to be a Category:Potential infection. Lisa Kaita 15:28, 2023 September 27 (CDT)

2023-08-31

rolled out Ttenbergen 11:14, 2023 August 31 (CDT)

Changes collectors need to know about:

• updated s_PatientFollow_distribution table to reflect change in allocation for for STB Med 11:14, 2023 August 31 (CDT)

2023-08-16-1

rolled out Ttenbergen 15:27, 2023 August 16 (CDT)

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

• updated query s_tmp_EuroSCORE_II_checks to allow scores up to 100

2023-08-16

rolled out Ttenbergen 09:49, 2023 August 16 (CDT)

Changes collectors need to know about:

• added "HSC-NDWRS2" to Boarding Loc values in s_tmp table

2023-08-09

rolled out Ttenbergen 11:37, 2023 August 9 (CDT)

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

• Changed category of Lightning injury from Category:Trauma to Category:Potential trauma to allow coding without a mechanism without triggering Query check ICD10 mechanism vs trauma.

2023-08-07

rolled out Ttenbergen 09:00, 2023 August 7 (CDT)

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

• made updates to allow for Change to having each collector collect both programs on the same laptop:
• program will now check for command line parameter to designate data file that should be used.
• added display of data file to the laptop line at the top of the main window.
• added H9 locations for H6C in s_locations_allowed_collection table to make them available in the dropdown

2023-07-27

rolled out Ttenbergen 11:42, 2023 July 27 (CDT)

Changes collectors need to know about:

• changed name of diagnosis "Heart, coronary arteries, diagnostic imaging, abnormal" to Heart and/or coronary arteries, diagnostic imaging, abnormal

2023-07-26

rolled out Ttenbergen 14:19, 2023 July 26 (CDT)

Changes collectors need to know about:

• EuroSCORE II: added "excluded" entry; see instruction page for use

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

• inactivated entry "HSC_CC" in s_dispo table
• query s_tmp_EuroSCORE_II_checks: added exception to score requirement for Value = "excluded"

2023-07-12

rolled out Ttenbergen 11:32, 2023 July 12 (CDT)

Changes collectors need to know about:

• changed EuroSCORE II so it doesn't auto-populate, and implemented query s_tmp_EuroSCORE_II_checks

2023-07-06

rolled out Ttenbergen 14:57, 2023 July 6 (CDT)

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

• added to s_tmp table the values for legacy project data Project Legacy Co-managed and Project Legacy HSC CCU Loc

2023-06-28

rolled out Ttenbergen 15:43, 2023 June 28 (CDT)

Changes collectors need to know about:

• set up new project EuroSCORE II (added record to s_tmp table)

2023-06-27

rolled out Ttenbergen 11:10, 2023 June 27 (CDT)

Changes collectors need to know about:

• updated ERCP (endoscopic retrograde cholangiopancreatography) to be CCI Collection Mode "Collect each"

2023-05-31

rolled out Ttenbergen 14:11, 2023 June 5 (CDT)

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

• inactivated the HSC options for ICUotherService since we have not entered this there since we decided to break those records apart by service, not just program.

2023-05-30

rolled out Ttenbergen 10:52, 2023 May 31 (CDT)

Changes collectors need to know about:

• Added "MICU under ACCU service" to ICUotherService

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

• turned off query check_CCI_TISS_time_means_must_be_two because it caused too many false positives

2023-05-24-1

rolled out Ttenbergen 13:29, 2023 May 24 (CDT) Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

• tweak to Query check ICD10 ESRD and AKI only if transplant

2023-05-23

rolled out Ttenbergen 09:58, 2023 May 24 (CDT)

Changes collectors need to know about:

• implemented Query check_ICD10_ESRD_and_AKI_only_if_transplant

2023-05-04

rolled out Ttenbergen 10:17, 2023 May 4 (CDT)

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

• correction to s_ICD10_Charlson_Como_patterns table to use ranges that exclude the end
• rolling out to make sure Julie and I are working off the same version of this

2023-05-03-3

rolled out Ttenbergen 13:10, 2023 May 3 (CDT)

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

• tweak to Query check tmp BedHeld, it was looking for dispo = "AWOL" but needed "AMA (left against medical advice)"

2023-05-03-2

rolled out Ttenbergen 11:50, 2023 May 3 (CDT)

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

• tweaked Query check_ICD10_trach_dxs_consistent as per old request
• tweaked query check_ICD10_CLI_vs_CCI_CentralLine to only check cc patients

2023-05-03

rolled out Ttenbergen 09:38, 2023 May 3 (CDT)

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

• tweak to query check_ICD10_CLI_vs_CCI_CentralLine

2023-05-02

rolled out Ttenbergen 07:56, 2023 May 3 (CDT)

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

• re-imported s_CCI_Categories_Collection_Mode table since the update I rolled out was actually missing things, see s_CCI_Categories_Collection_Mode table
• correction to query check_tmp_BedHeld, which wasn't working right for "AMA (Protocol)"

2023-04-27

rolled out Ttenbergen 12:05, 2023 May 2 (CDT)

Changes collectors need to know about:

• added query check_tmp_BedHeld

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

• removed query "z_ComoAdmAcqu_Primary_List" that had been built for Controlling Dx Type for ICD10 codes

2023-04-18

rolled out Ttenbergen 12:03, 2023 April 18 (CDT)

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

• updated functions that import Cognos data to give option to import from desktop file if import from email fails

2023-04-05-2

rolled out Ttenbergen 21:22, 2023 April 5 (CDT)

Changes collectors need to know about:

• Changed the name of "Transfusion of FFP" to Transfusion of plasma products in S CCI Picklist table

2023-04-05-1

rolled out Ttenbergen 17:31, 2023 April 5 (CDT)

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

• updated code for (T) Brain's Meninges, Dura, Subarachnoid, Ventricles: it was "1.AA " with two spaces, and is now just "1.AA" as it should be.

2023-04-05

rolled out Ttenbergen 13:47, 2023 April 5 (CDT)

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

• S dispo table: edited record for GH-Recovery Room to remove the categorizations and change it from RR to ICU

2023-03-02

rolled out Ttenbergen 16:24, 2023 March 2 (CST)

Changes collectors need to know about:

• in s_dispo table, changed "GH-ER" to " GH - ER" which makes it consistent with how it's named at other locations, and which moves it to the top of how these are sorted in the previous location and other fields.

2023-02-09-1

rolled out Ttenbergen 10:33, 2023 March 1 (CST)

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

• updated function ApScore_pH() to return 0 rather than Null when receiving a Null input Ttenbergen 10:33, 2023 March 1 (CST)
• changed Primary Biliary Cirrhosis (PBC) to Primary Biliary Cholangitis (PBC) in s_ICD10 table Ttenbergen 09:52, 2023 March 1 (CST)

2023-02-09

rolled out Ttenbergen 18:04, 2023 February 9 (CST)

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

• added send dttm to logging to troubleshoot Error "Invalid SQL statment..." when sending Ttenbergen 18:04, 2023 February 9 (CST)

2023-02-08

rolled out Ttenbergen 15:58, 2023 February 9 (CST)

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

• deleted query check_CCI_if_no_admin_entries and replaced it with query check_CCI_Picklist_no_admin_entries and query check_CCI_Component_no_admin_entries
• ran a re-compile and removed code that is no longer required because of previous changes
• updated query check_Transfer_DtTm_after_paired_BL_and_before_later_BL so it will not allow transfer ready to be equal to next boarding loc start
• updated options for Pre acute living situation field in S pre acute living situation table to no longer allow "Assisted Living" and "Supportive Housing" which have been replaced by "Community Facility with support"

2023-02-02

rolled out Ttenbergen 14:52, 2023 February 2 (CST)

Changes collectors need to know about:

• re-allocated some STB Med, see Processes_around_changing_a_PatientFollow_assignment#2023-02-02 Ttenbergen 14:52, 2023 February 2 (CST)

2023-01-26

rolled out Ttenbergen 11:17, 2023 January 26 (CST)

Changes collectors need to know about:

• re-activated the HSC Critical Care Service entries for Service tmp entry that had been inactivated in the past since we will now collect these verbatim

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

• updated Charlson Comorbidities in ICD10 codes according to Allan's email from Dec 1; this should have been identical to what I have but somehow still had differences; the specific changes are a bit messy and there will likely be further updates since the list was incomplete.

2023-01-25

rolled out Ttenbergen 17:13, 2023 January 25 (CST)

Changes collectors need to know about:

• added "Weird reason" to BedHeldEnd DtTm

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

• retired Sudden cardiac death (and died) as per Task Team Meeting - Rolling Agenda and Minutes 2023#ICU Database Task Group Meeting – Jan 11, 2023

2023-01-11

rolled out Ttenbergen 11:26, 2023 January 25 (CST)

Changes collectors need to know about:

• added HSC ICU related Cognos services to s_tmp table to allow entry as it is in Cognos, rather than changed version; more may need to be added, let me know

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

• updated S_laptops table to not allow duplicate entries. Three lines had accidentally been added that were causing records to not show up in CSS. Ttenbergen 11:26, 2023 January 25 (CST)
• changed the dropdown for the Previous Location to list the local entries first.
• updated entry for Selkirk Mental Hospital in s_dispo table to replace the nulls in its site etc fields with empty strings like all the other entries have
• updated the GH-ambulatory care to GH ambulatory care (- to space) so it sorts below the options collectors actually use
• updated created_AdmitDtTm query so it won't crash when there are nulls in all three dates
• disabled query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER

2023-01-05

rolled out Ttenbergen 11:04, 2023 January 5 (CST)

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

• updated S laptops table to not allow duplicate entries. Three lines had accidentally been added that were causing records to not show up in CSS. Ttenbergen 11:04, 2023 January 5 (CST)

2022-...

• see CCMDB.accdb Change Log 2022