CCMDB.accdb Change Log 2021: Difference between revisions

 
(32 intermediate revisions by the same user not shown)
Line 3: Line 3:


== Versions ==
== Versions ==
Change for next version:  
=== 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 ===
not rolled yet [[User:Ttenbergen|Ttenbergen]] 00:46, 2021 November 5 (CDT)
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 [[Cognos2_Hospital_Discharge query]]
* created ''Cognos2_Hospital_Discharge'' query
* updated [[L_First_Boarding_Loc_Non_ER query]], which was causing false positives in [[query check_ER_Delay_not_too_big]]
* 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 [[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)
* 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 [[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 "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 [[Arrive DtTm]] since that may be empty for pt who is still in ER [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 July 22 (CDT)
* 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 [[Arrive DtTm]] that had been accidentally introduced in [[#2021-06-17]].
* 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 [[Arrive DtTm]] blank
* 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 [[Arrive DtTm]]
* 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 [[Drug-induced immunosuppression]] from [[S ICD10 table]]
* 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 [[Drug-induced immunosuppression]]
* 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 [[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...
* 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 [[Drug-induced immunosuppression]]
* 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 [[Drug-induced immunosuppression]]
* 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 [[Drug-induced immunosuppression]] as CCI Picklist / TISS code, '''see instructions on that page on how the usage of this code is changing'''
* 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 [[Drug-induced immunosuppression]] to [[S ICD10 table]]
* added ''Drug-induced immunosuppression'' to [[S ICD10 table]]
* 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]]
* 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 [["Make loc" button]] to also add the item for [[Transfer Ready DtTm tmp entry]]
* 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 [["Make loc" button]] to also add a [[Transfer Ready DtTm tmp entry]]
* 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 [[Process for bad data in Cognos]]
* 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