CCMDB.accdb Change Log 2020: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 15: Line 15:
*** renamed "HSC_D5" to [[HSC_D5_Pre_COVID]]
*** renamed "HSC_D5" to [[HSC_D5_Pre_COVID]]
*** added [[HSC_D5]]
*** added [[HSC_D5]]
** edited [[s_locations_allowed_collection table]] to allow the new locations to be collected
** added ''Sub Covid_Twinner()'' and some ''COV_*'' queries to automatically twin records


=== 2020-03-17 ===
=== 2020-03-17 ===

Revision as of 21:46, 2020 March 18

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

2020-03-18

not rolled yet

2020-03-17

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

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)

2020-03-12

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

2020-03-11

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

2020-03-05

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

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)

2020-01-31

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

2020-01-28

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

2020-01-23

rolled out Ttenbergen

2020-01-15

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

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