CCMDB.accdb Change Log 2020

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:

future update

pop-up hints on Pharmacy screen - need to deal with, emailing ICU Task Team

• SMW

• Cargo

• Categories

• • need to do: delete the last row after import; or if not last the one that has empty service group.

2020-04-28

not rolled yet Ttenbergen 12:45, 2020 April 28 (CDT)

• in s_locations_allowed_collection table
  • for s4, removed STB_E6dB, STB_B5d, STB_IMCd
  • for s4/s5/s6, added/confirmed presence of STB_IMCU

2020-04-27

rolled out Ttenbergen 16:36, 2020 April 27 (CDT)

• added ability to enter as Pre-admit Inpatient Institution for a bunch of the new COVID locations, I forgot when I first set them up Ttenbergen 16:14, 2020 April 27 (CDT)

2020-04-26

rolled out Ttenbergen 20:56, 2020 April 26 (CDT) Changes collectors will want to know about:

• The following change should make sending a lot quicker, so if you notice that there is probably nothing wrong:
  • updated Query send_check_centralized_is_owner and its component query L_Log_ownerCheck_maker

2020-04-17-1

rolled out Ttenbergen 13:48, 2020 April 24 (CDT)

• set the MCHP field to true for Boarding Loc, Project Borrow arrive and H1N1 in s_tmp table.
• set Previous Location field to allowed in S_dispo table for a bunch of the new locations that were added recently; missed it because those fields in the table were set to hidden.

2020-04-17

rolled out Ttenbergen 10:23, 2020 April 17 (CDT)

• for 2020-03 GRA COVID unit transition:
  • fixed availability of GRA_5N in S tmp table

2020-04-16-1

rolled out Ttenbergen 23:30, 2020 April 16 (CDT)

• for 2020-04 HSC COVID unit transition:
  • to S tmp table for Boarding Loc, HSC_H4H_P to HSC_H4H
• more work on Cognos Report Integrator; there is some test data in there from the morning of Apr 16, so whoever wants to play with it a bit to test it is welcome to. Please provide any feedback at Cognos Report Integrator.

2020-04-16

rolled out Ttenbergen 12:47, 2020 April 16 (CDT)

• for 2020-04 HSC COVID unit transition:
  • to S tmp table for Boarding Loc, added:
    • HSC_H4H_P

2020-04-15-1

rolled out Ttenbergen 12:28, 2020 April 16 (CDT)

• for 2020-03 GRA COVID unit transition:
  • to s_dispo table / S locations allowed collection table, added:
    • GRA_PACU
  • to S tmp table for Boarding Loc, added:
    • GRA_5N

2020-04-15

rolled out Ttenbergen 11:27, 2020 April 15 (CDT)

• fixed number generator for "Add Patient with Serial Helper" button
• tweaked wording for question during sending that asks if you are connected to a network cable to "Is your laptop or docking station physically connected to a network cable?"; hopefully it's clear now, if not please suggest further wording change.
• tweaked availability of service locations

2020-04-14

rolled out Ttenbergen 21:20, 2020 April 14 (CDT)

• tweaked Function Regional_server_connected() to work right when trying to send while disconnected from regional server
• 2020-03 GRA COVID unit transition:
  • added GRA_2S to S dispo table
  • added GRA 5S C and GRA_2S to s_locations_allowed_collection table

2020-04-09-1

rolled out Ttenbergen 14:24, 2020 April 14 (CDT)

Changes collectors probably won't care about:

• cleaned out all use of query check_dispo_lower_acuity_than_location and function Transfer_Ready_DtTm_vs_Location_vs_Dispo since we agreed that there would no longer be distinctions between CTUs and NTUs in how we collect and report.
• fixed fall-out from spring cleaning
  • restored query check_pt_from_ER

2020-04-09

rolled out Ttenbergen 13:47, 2020 April 9 (CDT)

Changes collectors probably don't need to know:

• removed Overstay button and code relating to it; this got rid of a lot of code, queries etc but should have no effect on collectors
• another tweak to STB_E6_C in S dispo table
• fixed an overflow bug when adding a new patient that was introduced by the send changes in recent updateTtenbergen 13:45, 2020 April 9 (CDT)

2020-04-08

rolled out Ttenbergen 21:33, 2020 April 8 (CDT)

• tweaked s_dispo table re COVID ward moves as per email from Julie, just naming tweaks for columns not visible to collectors.

2020-04-06

rolled out Ttenbergen 12:02, 2020 April 8 (CDT)

Things collectors should know about:

• added to s_dispo table to accommodate COVID ward moves:
  • 2020-04 HSC COVID unit transition - please discuss questions about this there
    • HSC_D2_C
    • HSC_B2
    • HSC_MS3
    • HSC_A7_MI
    • HSC_A7_SI
    • HSC_H7_MI
    • HSC_H7_SI
  • 2020-03 GRA COVID unit transition - please discuss questions about this there
    • GRA 5S C
• tons of tweaking to the routines that make a new record to clean up an old mess I came across that stopped some changes we are working on; should not have any visible effect but if making new records acts up, let me know. Ttenbergen 23:33, 2020 April 7 (CDT)

Things collectors don't need to know:

• work on Cognos Report Integrator Ttenbergen 14:11, 2020 April 3 (CDT)
• changed s_dispo table
  • STB_E6_C Center = from 221 to 226 (only affects Julie's reports)

2020-04-06

rolled out Ttenbergen 23:51, 2020 April 6 (CDT)

• added all HSC Med locations to all HSC Med laptop in S locations allowed collection table to allow following of patients as they are moved around. Ttenbergen 15:19, 2020 April 7 (CDT)

2020-04-05

rolled out Ttenbergen 23:51, 2020 April 6 (CDT)

• added STB_IMCU to S5 laptop in S locations allowed collection table

2020-04-03-2

rolled out Ttenbergen 23:24, 2020 April 5 (CDT)

• work on Cognos Report Integrator Ttenbergen 14:11, 2020 April 3 (CDT)
  • added Cognos_import table and Cognos_import_processor query Ttenbergen 15:02, 2020 April 3 (CDT)
  • added several other Cognos* components that are not working or documented yet. Ttenbergen 23:26, 2020 April 5 (CDT)
• Made changes for ICUotherService in s_tmp table
  • added (for HSC)
    • SICU under MICU
    • MICU under SICU
  • removed (from STB)
    • CICU under MICU
    • CICU under ACCU

2020-04-03-1

only provided to specific people for testing for now

• starting work on Cognos Report Integrator Ttenbergen 14:11, 2020 April 3 (CDT)
• added Cognos_import table and Cognos_import_processor query Ttenbergen 15:02, 2020 April 3 (CDT)
• tweak to fix spelling problem in prev version Ttenbergen 15:03, 2020 April 3 (CDT)

2020-04-03

only provided to specific people for testing for now

• added a step to sending where user confirms whether they are connected to LAN cable or docking station; wifi will no longer be disabled during sending unless people are docked or tethered. Ttenbergen 10:09, 2020 April 3 (CDT)

2020-04-01

rolled out Ttenbergen 16:05, 2020 April 1 (CDT)

• renamed "" to COVID-19 (SARS-COV-2) in S ICD10 table

2020-03-29

rolled out Ttenbergen 12:21, 2020 March 30 (CDT)

• In s_tmp table changed Boarding Loc entry "STB_E6_P" to "STB_E6_B" for consistency

2020-03-29

rolled out Ttenbergen 23:54, 2020 March 29 (CDT)

• changes required for 2020-03 STB COVID unit transition
  • renamed "STB_E6" to STB_E6_B
    • STB_E6a --> STB_E6aB
    • STB_E6b --> STB_E6bB
    • STB_E6d --> STB_E6dB
  • added
    • STB_E6_C
    • STB_A7_B
  • in s_locations_allowed_collection table, added entries for STB Laptop identifiers for new and changed locations
  • In s_tmp table:
    • we add Boarding Loc entry "STB_E6_P" that will stay active only during this transition.

2020-03-24

rolled out Ttenbergen 14:40, 2020 March 24 (CDT)

• added the following to S tmp table for Boarding Loc for 2020-03 HSC COVID unit transition:
  • HSC_D5_P
  • HSC_D4_P

2020-03-23

was rolled

• re-did name changes as per 2020-03-20 since I overwrote them with what Julie sent.

2020-03-20

rolled out Ttenbergen 14:55, 2020 March 22 (CDT)

• added link to Drugs Collected to the Pharmacy screen Ttenbergen 09:34, 2020 March 20 (CDT)
• changed names of the following in s_dispo table because the longer version was breaking sending:
  • HSC_D4_pre_COVID to HSC_D4_P
  • HSC_D5_Pre_COVID to HSC_D5_P
  • HSC_D4_COVID to HSC_D4_C
• updated various columns in S_dispo table as per email from Julie

2020-03-19

rolled out Ttenbergen 22:33, 2020 March 19 (CDT)

• Changes Collectors will want to know about:
  • changes for 2020-03 HSC COVID unit transition
    • in s_dispo table:
      • renamed "HSC_D4" to HSC_D4_pre_COVID
      • added HSC_D4_COVID

• Behind the scenes changes that are probably not interesting to collectors:
  • changes for 2020-03 HSC COVID unit transition
    • edited s_locations_allowed_collection table to allow the new locations to be collected
    • edited queries for use on H4 laptop
      • COV_L_Log_int (use H4 laptop locations)
      • COV_1L_Log_twinner (blank the Accept and Arrive DtTms)
      • ran on H4 laptop Sub Location_Twinner()

2020-03-18

rolled out Ttenbergen 00:37, 2020 March 19 (CDT)

• Changes Collectors will want to know about:
  • Facilitated Management of Serial numbers - added "Add Patient with Serial Helper" button
  • changes for 2020-03 HSC COVID unit transition
    • in s_dispo table:
      • added HSC_WRS3
      • renamed "HSC_D5" to HSC_D5_Pre_COVID
      • added HSC_D5

• Behind the scenes changes that are probably not interesting to collectors:
  • changes for 2020-03 HSC COVID unit transition
    • edited s_locations_allowed_collection table to allow the new locations to be collected
    • added Sub Location_Twinner() and some COV_* queries to automatically twin records

2020-03-17

rolled out Ttenbergen 11:49, 2020 March 18 (CDT)

• Changes collectors probably want to know about
  • added SARS-CoV-2 to S ICD10 table (don't use Coronavirus for current outbreak)
  • changed "Resistance to antimicrobials, anti-mycobacterial agent" to Resistance to antimicrobials, classic anti-mycobacterial agent in S ICD10 table
  • retired Imprisonment/incarceration in S ICD10 table

2020-03-16

rolled out Ttenbergen 09:45, 2020 March 16 (CDT)

• reset testing sending

2020-03-15

rolled out Ttenbergen 23:49, 2020 March 15 (CDT)

• updated delete queries to work properly with new Laptop identifier

2020-03-12

Rolled out Ttenbergen 10:05, 2020 March 12 (CDT)

• removed Gastrointestinal (GI) tract, chemical burn and Electrical injury from since we would not want to enforce mechanisms on these.
• did a Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb Ttenbergen 10:04, 2020 March 12 (CDT)

2020-03-11

rolled out Ttenbergen 10:02, 2020 March 11 (CDT)

• updated Query check_ICD10_only_1_stage_of_renal_failure to allow collection of different stages of CKD into different Dx Types Ttenbergen 09:59, 2020 March 11 (CDT)

2020-03-05

rolled out Ttenbergen 14:03, 2020 March 5 (CST)

• updated more tables for Laptop identifier
  • s_laptops table
  • S PatientFollow distribution table
• in S dispo table, deactivated CON_MICU, OAK_MICU

2020-03-03

not rolled yet Ttenbergen 15:04, 2020 March 3 (CST)

Partial roll-out to only Michelle (H4) and Iris (H5) Ttenbergen 12:57, 2020 March 4 (CST)

• deleted ancient s_locations_local table that would have been unused since the 2016 location changes
• in Main Form (CCMDB.accdb), changed the entry at the top right to show the laptop identifier rather than the old laptop location
• deleted old query 111
• Update of D ID to include a laptop identifier - added Laptop identifier to D_ID:
  • query Send_Centralized_1L_Log_update - no update needed or done
  • query send_Centralized_1L_Log__intermediate - new D_ID format
  • query Send_Centralized_L_Pharm_Flowsheet__intermediate - new D_ID format
  • query Send_Centralized_L_TmpV2__intermediate - new D_ID format
  • query Send_Centralized_L_ICD10__intermediate - new D_ID format
  • query Send_Centralized_1L_Log_append - now draws from ...intermediate
  • queries Send_Centralized_*_delete - confirmed no update needed or done
  • queries Send_Centralized_*_update - confirmed no update needed or done
  • queries Send_Centralized_*_append - confirmed no update needed or done
  • query send_PHI - new D_ID format
• cleanup
  • deleted query Send_Centralized_L_CCI__intermediate that was remnant from early CCI setup
  • deleted query Send_Centralized_L_Labs_Flowsheet__intermediate
  • deleted query Send_Centralized_L_Labs_Flowsheet_append
  • deleted query Send_Centralized_L_Labs_Flowsheet_delete
  • deleted query Send_Centralized_L_Labs_Flowsheet_update
  • deleted query L Labs total
  • deleted query Send_Centralized_L_Dxs__intermediate
  • deleted query Send_Centralized_L_Como__intermediate
  • deleted query Send_Centralized_L_CCI_deleteSend_Centralized_L_Como_delete
  • deleted query Send_Centralized_L_Como_delete
  • deleted query Send_Centralized_L_Dxs_delete
  • deleted query Send_Centralized_L_CCI_update
  • deleted query Send_Centralized_L_Como_update
  • deleted query Send_Centralized_L_Dxs_update
  • deleted query Send_Centralized_L_CCI_append
  • deleted query Send_Centralized_L_Como_append
  • deleted query Send_Centralized_L_Dxs_append

2020-03-01

rolled out Ttenbergen 15:03, 2020 March 3 (CST)

• changes to s_locations_allowed_collection table to accommodate new Laptop identifier
• updated query s_serviceLocation_local to use the new function Laptop_identifier() instead of the old Hosp() Loc() combination
• deleted form "s_locations_allowed_collection" which was likely automatically and accidentally added at some point, but isn't used
• changed sending function to start using laptop location for PHI file names
• changed function Global.LaptopLocation to Global.Laptop_identifier for consistency with new setup and to make sure things break loudly if something is forgotten. Ttenbergen 17:06, 2020 March 1 (CST)
• upsdated S laptops table Ttenbergen 14:12, 2020 March 2 (CST)
• removed button to access s_dispo chooser - it was never fully implemented, and isn't working, and no one has complained about it since it was set up in 2016, so I guess the functionality is not needed.

2020-02-27

This wasn't rolled out so much as it will be introduced as I change laptops to the new Laptop identifier. Done by Fri 2020-02-28

• changed sending functionality to use A Info table field_name "Laptop_Identifier" for file path for sending. Ttenbergen 09:35, 2020 February 27 (CST)

2020-02-23

rolled out Ttenbergen 20:37, 2020 February 23 (CST)

• in S_ICD10 table
  • changed "Gastritis, hemorragic" to Gastritis, hemorrhagic 16:19, 2020 February 23 (CST)
  • added Cognitive impairment, NOS Ttenbergen 17:10, 2020 February 23 (CST)

2020-01-31

rolled out Ttenbergen 16:58, 2020 February 3 (CST)

• added entry for Nephrostomy placement to s_CCI_Categories_Collection_Mode table (forgot on original addition)
• deleted query check_ICD10_ESRD_vs_ARF and code calling it since it's no longer feasible - some ESRD can have AKI

2020-01-28

Rolled out. Ttenbergen 13:05, 2020 January 30 (CST)

• Added Other and unspecified symptoms and signs involving the nervous and musculoskeletal systems to S ICD10 table
• Since we moved to Boarding Loc, disabling the following fields we are no longer using.
  • Project Borrow arrive - no longer automatically entered or available in drop-downs from S tmp table
  • Off ward field - field made invisible in Dispo tab

2020-01-23

rolled out Ttenbergen

• added Nephrostomy placement to s_CCI_Picklist table and s_CCI_Categories table
• added (D) Pericardium to s_CCI 1 table

2020-01-15

rolled out Ttenbergen 09:43, 2020 January 16 (CST)

• removed trauma categories from Rib fracture(s) due to CPR - it's iatrogenic, so not a trauma and no mechanism required.
• added Resistance to carbapenem antibiotics
• tweaks to EPR Reports Integrator as discussed with Michelle

2020-01-02

rolled out Ttenbergen 09:57, 2020 January 2 (CST)

• removed the temporary query that changes lowercase incompletes to uppercase Ttenbergen 09:57, 2020 January 2 (CST)

2019-...

• see CCMDB.accdb Change Log 2019