CCMDB.accdb Change Log 2022: Difference between revisions
Ttenbergen (talk | contribs) m (→2022-02-09) |
Ttenbergen (talk | contribs) m (→2022-02-09) |
||
Line 26: | Line 26: | ||
* 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 | * 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]] | * added [[s_LocationData table]] | ||
* updated [[Function LOS()]] to use [[Created_AdmitDtTm query]] as input instead of [[Arrive DtTm]] | |||
--> | --> | ||
Revision as of 15:52, 2022 February 10
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-02-09
not rolled yet Ttenbergen 16:47, 2022 February 2 (CST)
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)