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:
2020-03-03
not rolled yet Ttenbergen 15:04, 2020 March 3 (CST) CHANGE SEND DIRECTORY BACK BEFORE ROLLING
- 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
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)