CCMDB.accdb Change Log 2021: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Drug-induced immunosuppression no more |
||
(32 intermediate revisions by the same user not shown) | |||
Line 3: | Line 3: | ||
== Versions == | == Versions == | ||
Change for | === 2022 === | ||
See [[CCMDB.accdb Change Log 2022]] | |||
=== 2021-12-30 === | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 16:55, 2021 December 30 (CST) | |||
'''<mark>Changes collectors need to know about:</mark>''' | |||
* added [[Past history of Covid-19 infection]] | |||
=== 2021-12-09 === | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 11:11, 2021 December 13 (CST) | |||
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | |||
* inactivated "STB_IMCU" in s_dispo again, instructions are changing and currently only in emails, we need to get these back onto the wiki. | |||
* updated some details in the "GH-CC" record in [[S dispo table]] at Julie's request. [[User:Ttenbergen|Ttenbergen]] 11:11, 2021 December 13 (CST) | |||
=== 2021-12-08 === | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 10:58, 2021 December 8 (CST) | |||
'''<mark>Changes collectors need to know about:</mark>''' | |||
* re-enabled [[STB_IMCU]] in [[S dispo table]] - wiki instructions to follow[[User:Ttenbergen|Ttenbergen]] 10:58, 2021 December 8 (CST) | |||
* made "HSC_SICU" and "HSC_MICU" available in [[Service/Location]] by re-includng it in [[s_locations_allowed_collection table]] [[User:Ttenbergen|Ttenbergen]] 10:58, 2021 December 8 (CST) | |||
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | |||
* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an "Accept DtTm", changed it to use first [[Service tmp entry]] instead. | |||
=== 2021-12-02 === | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 08:35, 2021 December 8 (CST) | |||
'''<mark>Changes collectors need to know about:</mark>''' | |||
* re-enabled [[HSC_MICU]] and [[HSC_SICU]] as [[Service/Location]] - wiki instructions to follow[[User:Ttenbergen|Ttenbergen]] 08:35, 2021 December 8 (CST) | |||
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | |||
* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an "Accept DtTm", changed it to use first [[Service tmp entry]] instead. | |||
=== 2021-11-17 === | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 14:23, 2021 December 2 (CST) | |||
'''<mark>Changes collectors need to know about:</mark>''' | |||
* changed 'STB - boarding' entry for [[Boarding Loc]] so it will only display on medicine laptops going forward. | |||
* removed hover hints for Pharmacy checkboxes; info was out-of-date compared to wiki, and there is a link to a summarizing wiki page right on that tab, so no sense duplicating the info. [[User:Ttenbergen|Ttenbergen]] 14:23, 2021 December 2 (CST) | |||
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | |||
* temporarily removed cross checks that ensure that [[Pre-admit Inpatient Institution]] , [[Previous Location]] and [[Dispo]] are not the same as [[Service/Location]] while we figure out how this should be collected for HSC CC. [[User:Ttenbergen|Ttenbergen]] 14:23, 2021 December 2 (CST) | |||
=== 2021-11-12 === | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 17:04, 2021 November 17 (CST) | |||
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | |||
* cleaned out "Cognos3_Services_not_used" table and "Cognos3_Units_not used" table; these were not actually used because they were replaced early on with [[SL Cognos2 Service exclusions table]] and [[SL Cognos2 Unit exclusions table]]. | |||
=== 2021-11-10 === | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 09:54, 2021 November 12 (CST) | |||
'''<mark>Changes collectors need to know about:</mark>''' | |||
* added [[HSC ALC Medicine Service]]s to [[s_tmp table]] so they can be entered as [[Service tmp entry]] without [[Query s tmp project item consistent]] error [https://ccmdb.kuality.ca/index.php?title=HSC_ALC_Medicine_Service&action=history] | |||
=== 2021-11-05 === | === 2021-11-05 === | ||
rolled out [[User:Ttenbergen|Ttenbergen]] 23:02, 2021 November 10 (CST) | |||
'''<mark>Changes collectors need to know about:</mark>''' | '''<mark>Changes collectors need to know about:</mark>''' | ||
* set [[Myocarditis, chronic]] to be a [[:Category:Potential infection|Potential infection]] | |||
* inactivated [[Viral carditis]]; see [[Template:ICD10 Guideline Myocarditis]] about how this should be coded | |||
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | ||
* started implementing [[query check_CCI_TISS_discontinuous_ETT]] but not applied to general collection yet | |||
=== 2021-11-04 === | === 2021-11-04 === | ||
Line 103: | Line 159: | ||
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | ||
* created | * created ''Cognos2_Hospital_Discharge'' query | ||
* updated | * updated ''L_First_Boarding_Loc_Non_ER query'', which was causing false positives in ''query check_ER_Delay_not_too_big'' | ||
=== 2021-09-23-1 === | === 2021-09-23-1 === | ||
Line 163: | Line 219: | ||
** HSC Critical Care – SICU | ** HSC Critical Care – SICU | ||
* updated | * updated ''query check_ER_Delay_not_too_big'' to use [[Boarding Loc]] instead of "Accept DtTm" vs "Arrive DtTm", and increased warning delay for CC from 2hrs to 8hrs (which it should have been already) | ||
=== 2021-09-07 === | === 2021-09-07 === | ||
Line 188: | Line 244: | ||
Changes collectors need to know about: | Changes collectors need to know about: | ||
* changed wording for | * changed wording for "Supp O2 though any device, delivered via nose, mouth, ETT or trach (TISS Item)" from "Supp O2 No ETT No Trach (TISS Item)" | ||
* changed wording for [[Spontaneous breathing via ETT without PEEP/CPAP, with or without supplemental O2 (TISS Item)]] from "Spontaneous breathing via ETT or Trach (TISS Item)", '''however the item is not actually being collected right now, flagged for Task meeting''' | * changed wording for [[Spontaneous breathing via ETT without PEEP/CPAP, with or without supplemental O2 (TISS Item)]] from "Spontaneous breathing via ETT or Trach (TISS Item)", '''however the item is not actually being collected right now, flagged for Task meeting''' | ||
Line 251: | Line 307: | ||
rolled out [[User:Ttenbergen|Ttenbergen]] 10:41, 2021 July 23 (CDT) | rolled out [[User:Ttenbergen|Ttenbergen]] 10:41, 2021 July 23 (CDT) | ||
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | ||
* further tweaking on [[query check_minimal_data_set_incomplete]]; this must not check for | * further tweaking on [[query check_minimal_data_set_incomplete]]; this must not check for "Arrive DtTm" since that may be empty for pt who is still in ER [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 July 22 (CDT) | ||
=== 2021-07-21-2 === | === 2021-07-21-2 === | ||
Line 327: | Line 383: | ||
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | ||
* updated [[query check_minimal_data_set_incomplete]] to fix false positive on missing | * updated [[query check_minimal_data_set_incomplete]] to fix false positive on missing "Arrive DtTm" that had been accidentally introduced in [[#2021-06-17]]. | ||
=== 2021-06-20 === | === 2021-06-20 === | ||
Line 357: | Line 413: | ||
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | ||
* updated [[query check_CCI_Date]] which was failing with uninformative error when | * updated [[query check_CCI_Date]] which was failing with uninformative error when "Arrive DtTm" blank | ||
* updated [[query check_minimal_data_set_incomplete]] to properly trigger for blank | * updated [[query check_minimal_data_set_incomplete]] to properly trigger for blank "Arrive DtTm" | ||
* updated [[query check_ICD10_awaiting_has_Transfer_Ready_DtTm]] to fix scenario where multiple [[Transfer Ready DtTm tmp entry]] would cause false positive | * updated [[query check_ICD10_awaiting_has_Transfer_Ready_DtTm]] to fix scenario where multiple [[Transfer Ready DtTm tmp entry]] would cause false positive | ||
Line 431: | Line 487: | ||
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | ||
* updated [[query check_tmp_service_or_location_duplicate]] to catch a scenario it was missing | * updated [[query check_tmp_service_or_location_duplicate]] to catch a scenario it was missing | ||
* removed the initial ICD10 version of | * removed the initial ICD10 version of ''Drug-induced immunosuppression'' from [[S ICD10 table]] | ||
* re-enabled "HSC Critical Care / Intermediate" in [[Service tmp entry]]; had accidentally disabled it | * re-enabled "HSC Critical Care / Intermediate" in [[Service tmp entry]]; had accidentally disabled it | ||
Line 456: | Line 512: | ||
* disabled [[query check_ICD10_Inf_Potential_Infection_must_have_pathogen_or_alt]] as discussed at Task meeting | * disabled [[query check_ICD10_Inf_Potential_Infection_must_have_pathogen_or_alt]] as discussed at Task meeting | ||
* inactivated any HSC CC [[Service tmp entry]] other than "HSC Critical Care - MICU", "HSC Critical Care - SICU" and "HSC Critical Care / Intermediate" | * inactivated any HSC CC [[Service tmp entry]] other than "HSC Critical Care - MICU", "HSC Critical Care - SICU" and "HSC Critical Care / Intermediate" | ||
* retired briefly available ICD10 version of | * retired briefly available ICD10 version of ''Drug-induced immunosuppression'' | ||
=== 2021-04-22 === | === 2021-04-22 === | ||
Line 462: | Line 518: | ||
Changes collectors need to know about: | Changes collectors need to know about: | ||
* changed the "99" button on [[Patient Viewer Tab CCI Pick]] to add the record for | * changed the "99" button on [[Patient Viewer Tab CCI Pick]] to add the record for ''Drug-induced immunosuppression'' as [[Px Type]] "Admit" rather than "Acquired" like all the other TISS records; this is assuming that the question on the page will be answered that way... | ||
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | ||
* changed [[query check_CCI_TISS_NrDays_GT_LOS]] and [[query check_CCI_TISS_NrDays_LT_LOS]] to exclude T99 | * changed [[query check_CCI_TISS_NrDays_GT_LOS]] and [[query check_CCI_TISS_NrDays_LT_LOS]] to exclude T99 ''Drug-induced immunosuppression'' | ||
=== 2021-04-21-1 === | === 2021-04-21-1 === | ||
Line 478: | Line 534: | ||
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | Changes collectors probably don't care about (incl. bug fixes that should just make hings work now): | ||
* added [[CCI Collection Mode]] "[[CCI collect first]]" and "[[:Category:Pharmacotherapy]]" first to | * added [[CCI Collection Mode]] "[[CCI collect first]]" and "[[:Category:Pharmacotherapy]]" first to ''Drug-induced immunosuppression'' | ||
=== 2021-04-20 === | === 2021-04-20 === | ||
Line 493: | Line 549: | ||
Changes collectors need to know about: | Changes collectors need to know about: | ||
* Added | * Added ''Drug-induced immunosuppression'' as CCI Picklist / TISS code, '''see instructions on that page on how the usage of this code is changing''' | ||
=== 2021-04-08-4 === | === 2021-04-08-4 === | ||
Line 577: | Line 633: | ||
Changes collectors need to know about: | Changes collectors need to know about: | ||
* added | * added ''Drug-induced immunosuppression'' to [[S ICD10 table]] | ||
* tweaked [[query check_CCI_TISS_Pharm_Vasoactive]] to only include profiles with | * tweaked [[query check_CCI_TISS_Pharm_Vasoactive]] to only include profiles with "Accept DtTm" after 2020-12-07 ([[Change_to_collect_TISS_data_in_CCI_Picklist#Change_date]] | ||
=== 2021-04-01 === | === 2021-04-01 === | ||
Line 635: | Line 691: | ||
Changes collectors need to know about: | Changes collectors need to know about: | ||
* updated [[" | * updated [["make loc" button]] to also add the item for [[Transfer Ready DtTm tmp entry]] | ||
=== 2021-03-04 === | === 2021-03-04 === | ||
Line 641: | Line 697: | ||
Changes collectors need to know about: | Changes collectors need to know about: | ||
* updated [[" | * updated [["make loc" button]] to also add a [[Transfer Ready DtTm tmp entry]] | ||
Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | ||
Line 737: | Line 793: | ||
Changes collectors need to know about: | Changes collectors need to know about: | ||
* added ''Eyes button'' to facilitate | * added ''Eyes button'' to facilitate ''Process for bad data in Cognos'' | ||
** for now this will only do anything for STB, since we still need to find out the contacts for HSC and GRA | ** for now this will only do anything for STB, since we still need to find out the contacts for HSC and GRA | ||