CCMDB.accdb Change Log 2021: Difference between revisions

(95 intermediate revisions by the same user not shown)

Line 3:

== 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)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* 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)

'''Changes collectors need to know about:'''

* 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 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 23:02, 2021 November 10 (CST)

'''Changes collectors need to know about:'''

* 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):

* started implementing [[query check_CCI_TISS_discontinuous_ETT]] but not applied to general collection yet

=== 2021-11-04 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 00:46, 2021 November 5 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* updated query ''send_set_oLog_to_sent'' because it wasn't setting the right patients to "sent" after a recent change.

=== 2021-11-02 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 14:27, 2021 November 4 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* updated the dropdown for [[Px Type]] to only allow listed items to prevent accidental entry of manually typed things

* updated code for [["set MRSA Colonized" button]]; it had entered the [[Dx Type]] comorbid as lowercase when it is uppercase everywhere else; will now enter it uppercase

=== 2021-10-27 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 19:20, 2021 November 2 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* cleanup of [[Transitional Care]]: inactivated "STB - Transitional care" and "River Ridge Transition Care Environment" in [[s_dispo table]]

* changed the error handling in sending, it would have brushed right past some errors before without notifying user

* updated query 'send_set_oLog_to_sent' that runs as part of sending so it wont re-set previously sent records from "vetted" to "sent" in [[Centralized data.mdb]]

=== 2021-10-20 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 16:35, 2021 October 27 (CDT)

'''Changes collectors need to know about:'''

* Added "Other MB Nursing Station" to [[S dispo table]] at Julie's request so collectors have an option if a new one shows up

* added [[query check_CCI_ICD10_Dialysis_no_Dx]] - will flag if there is a dialysis entry but no dx that would require it

* made time visible and available for [[Dx Date]] - there are now circumstances where you will need to enter that, pls see that page for instructions

* changed wording for all GRA entries in [[S dispo table]] to GH; this will affect entries in [[Pre-admit Inpatient Institution]], [[Previous Location]], [[Service/Location]] and [[Dispo]]; all current entries will update to the new wording automatically.

=== 2021-10-14 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 11:10, 2021 October 20 (CDT)

'''Changes collectors need to know about:'''

* Added "Pauingassi Nursing Station" to [[S_dispo table]] after people had entered this as "Known but not listed" - if you come across a "Known but not listed" location, talk to Pagasa. [[User:Ttenbergen|Ttenbergen]] 09:31, 2021 October 20 (CDT)

=== 2021-10-13 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 14:21, 2021 October 14 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* set "GH-Recovery Room" in [[s_dispo table]] to not be an inpatient location; it was triggering a cross check.

=== 2021-10-07-1 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 16:29, 2021 October 13 (CDT)

Changes collectors need to know about:

* added functionality in [[CSS]] so clicking on the MRN will list any exclusions that have previously been entered for that MRN (aka query Cognos2_Service_Starter_Exclusion_per_MRN)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* removed the ""CC" entry from the "program" colum for "GH-Recovery Room" in [[S dispo table]]

=== 2021-10-07 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 09:57, 2021 October 7 (CDT)

Changes collectors need to know about:

* Changed [[query check_tmp_Boarding_Loc_Service_first_same]] to also run for incomplete patients during pre-sent check

* disabled locations that should no longer be used in [[S dispo table]]: [[HSC_HOBS]], [[GRA_N3]]

=== 2021-10-06 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 10:01, 2021 October 6 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* updated ''active_start'' dates in [[S CCI 1 table]], [[S CCI 2 table]], [[S CCI Picklist table]] to use #2019-01-01# unless they had a specific other date that was later

* updated s_CCI_Picklist for t* codes that had active_start date #2020-11-20# to #2020-12-07#

* replaced some additional calls to [[query check_tmp_Transfer_Ready_not_before_Boarding_Loc]] that were in other places with calls to [[query check_transfer_DtTm_during_admission]].

=== 2021-10-05 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 12:40, 2021 October 5 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* inactivated options we decided not to use after all in [[Transfer Ready DtTm tmp entry]], so they should no longer show up in dropdown:

**Home

**LTC/PCH

**Palliative / hospice

**ward outside WRHA

**WRHA non-Medicine ward

**WRHA Medicine ward

**WRHA non-Medicine HOB/stepdown

**WRHA HOB Medicine Ward

**IICU

**ICU outside of WRHA

* disabled [[Boarding Loc]] dropdown entry "no borrow", which should no longer be used under current instructions (and confirmed not used on any incompletes currently)

* retired and deleted [[query s_tmp_Boarding_Loc_no_borrow_but_entry]]

* retired and deleted [[query check_tmp_Transfer_Ready_not_before_Boarding_Loc]] since it is a subset of [[query check_transfer_DtTm_during_admission]], no need to run both

=== 2021-09-29 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 11:52, 2021 September 29 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* 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''

=== 2021-09-23-1 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 15:25, 2021 September 23 (CDT)

~~=== 2021-09-08 ===~~

~~not rolled yet [[User:Ttenbergen|Ttenbergen]] 17:44, 2021 September 7 (CDT)~~

~~<!----------------------------~~

Changes collectors need to know about:

* Retired the following [[ICD10 Diagnoses]] as part of rolling back [[Change from Awaiting/delayed dx codes to Transfer Ready DtTm]]:

** [[Awaiting/delayed transfer to any other care facility outside Winnipeg other than home or LTC/PCH]]

** [[Awaiting/delayed transfer to home]]

** [[Awaiting/delayed transfer to lower acuity site in Winnipeg other than home or LTC/PCH]]

** [[Awaiting/delayed transfer to other acute care facility in Winnipeg]]

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* updated [[query check_tmp_Service_and_Boarding_Loc_during_admission_timeframe]] to only check completes, and to only flag gt dispo, not = dispo

=== 2021-09-23 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 09:32, 2021 September 23 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* updated [[query check_tmp_Service_and_Boarding_Loc_during_admission_timeframe]] from TR >= Dispo to TR > Dispo

=== 2021-09-22 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 16:58, 2021 September 22 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* changed spelling from "Cardiac arrhythmia, NOS" to [[Cardiac arrhythmia, NOS]]

* added utility queries from CFE: [[created_AdmitDtTm query]], [[created_FirstService query]]

* updated [[query check_tmp_Service_and_Boarding_Loc_during_admission_timeframe]] to check for blank date_var / time_var, to also check [[Boarding Loc]] that had been omitted so far, and to use new Admit Time aggregate definition.

* [[query check_CCI_TISS_Vented_without_mechanism]] was only triggering on re-opened complete patients, now triggers on any pt when dx checkbox is checked

=== 2021-09-21 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 10:07, 2021 September 21 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* updated [[query check_minimal_data_set_incomplete]] which had been broken by rename of [[Created FirstLocation query]] [[User:Ttenbergen|Ttenbergen]] 10:01, 2021 September 21 (CDT)

=== 2021-09-20 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 12:33, 2021 September 20 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* renamed ''query L_First_Boarding_loc'' to [[Created_FirstLocation query]] so we use the same structure in CCMDB.accdb and CFE

* updated [[query check_CCI_TISS_matching_BoardingLoc_time]] to exclude deleted and sent records

=== 2021-09-16 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 14:35, 2021 September 16 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

---~~--------------------------->~~

* fixed [[created_FirstLocation query]] - had tweaked it for previous version and it broke [[query check_tmp_Boarding_Loc_Service_first_same]]

=== 2021-09-08 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 09:48, 2021 September 16 (CDT)

'''Changes collectors need to know about:'''

* added [[query check_CCI_TISS_matching_BoardingLoc_time]]

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* Added the following as [[S Cognos Services table#Exceptional entries]]:

Line 17:

Line 219:

** HSC Critical Care – SICU

* ''~~'started fixing~~ check_ER_Delay_not_too_big ~~but not complete yet!'~~''

* 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 ===

Line 42:

Line 244:

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

Line 105:

Line 307:

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):

* 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 ===

Line 181:

Line 383:

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

Line 211:

Line 413:

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

Line 285:

Line 487:

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

* 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

Line 310:

Line 512:

* 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"

* retired briefly available ICD10 version of [[Drug-induced immunosuppression]]

* retired briefly available ICD10 version of ''Drug-induced immunosuppression''

=== 2021-04-22 ===

Line 316:

Line 518:

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):

* 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 ===

Line 332:

Line 534:

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

Line 347:

Line 549:

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

Line 431:

Line 633:

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

Line 489:

Line 691:

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

Line 495:

Line 697:

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):

Line 591:

Line 793:

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

@@ Line 3: / Line 3: @@
 == 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 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 23:02, 2021 November 10 (CST)
+'''<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):
+* started implementing [[query check_CCI_TISS_discontinuous_ETT]] but not applied to general collection yet
+=== 2021-11-04 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 00:46, 2021 November 5 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* updated  query ''send_set_oLog_to_sent'' because it wasn't setting the right patients to "sent" after a recent change.
+=== 2021-11-02 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 14:27, 2021 November 4 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* updated the dropdown for [[Px Type]] to only allow listed items to prevent accidental entry of manually typed things
+* updated code for [["set MRSA Colonized" button]]; it had entered the [[Dx Type]] comorbid as lowercase when it is uppercase everywhere else; will now enter it uppercase
+=== 2021-10-27 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 19:20, 2021 November 2 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* cleanup of [[Transitional Care]]: inactivated "STB - Transitional care" and "River Ridge Transition Care Environment" in [[s_dispo table]]
+* changed the error handling in sending, it would have brushed right past some errors before without notifying user
+* updated query 'send_set_oLog_to_sent' that runs as part of sending so it wont re-set previously sent records from "vetted" to "sent" in [[Centralized data.mdb]]
+=== 2021-10-20 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 16:35, 2021 October 27 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* Added "Other MB Nursing Station" to [[S dispo table]] at Julie's request so collectors have an option if a new one shows up
+* added [[query check_CCI_ICD10_Dialysis_no_Dx]] - will flag if there is a dialysis entry but no dx that would require it
+* made time visible and available for [[Dx Date]] - there are now circumstances where you will need to enter that, pls see that page for instructions
+* changed wording for all GRA entries in [[S dispo table]] to GH; this will affect entries in [[Pre-admit Inpatient Institution]], [[Previous Location]], [[Service/Location]] and [[Dispo]]; all current entries will update to the new wording automatically.
+=== 2021-10-14 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 11:10, 2021 October 20 (CDT)
+'''Changes collectors need to know about:'''
+* Added "Pauingassi Nursing Station" to [[S_dispo table]] after people had entered this as "Known but not listed" - if you come across a "Known but not listed" location, talk to Pagasa. [[User:Ttenbergen|Ttenbergen]] 09:31, 2021 October 20 (CDT)
+=== 2021-10-13 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 14:21, 2021 October 14 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* set "GH-Recovery Room" in [[s_dispo table]] to not be an inpatient location; it was triggering a cross check.
+=== 2021-10-07-1 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 16:29, 2021 October 13 (CDT)
+Changes collectors need to know about:
+* added functionality in [[CSS]] so clicking on the MRN will list any exclusions that have previously been entered for that MRN (aka query Cognos2_Service_Starter_Exclusion_per_MRN)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* removed the ""CC" entry from the "program" colum for "GH-Recovery Room" in [[S dispo table]]
+=== 2021-10-07 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 09:57, 2021 October 7 (CDT)
+Changes collectors need to know about:
+* Changed [[query check_tmp_Boarding_Loc_Service_first_same]] to also run for incomplete patients during pre-sent check
+* disabled locations that should no longer be used in [[S dispo table]]: [[HSC_HOBS]], [[GRA_N3]]
+=== 2021-10-06 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 10:01, 2021 October 6 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* updated ''active_start'' dates in [[S CCI 1 table]], [[S CCI 2 table]], [[S CCI Picklist table]] to use #2019-01-01# unless they had a specific other date that was later
+* updated s_CCI_Picklist for t* codes that had active_start date #2020-11-20# to #2020-12-07#
+* replaced some additional calls to [[query check_tmp_Transfer_Ready_not_before_Boarding_Loc]] that were in other places with calls to [[query check_transfer_DtTm_during_admission]].
+=== 2021-10-05 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 12:40, 2021 October 5 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* inactivated options we decided not to use after all in [[Transfer Ready DtTm tmp entry]], so they should no longer show up in dropdown:
+**Home
+**LTC/PCH
+**Palliative / hospice
+**ward outside WRHA
+**WRHA non-Medicine ward
+**WRHA Medicine ward
+**WRHA non-Medicine HOB/stepdown
+**WRHA HOB Medicine Ward
+**IICU
+**ICU outside of WRHA
+* disabled [[Boarding Loc]] dropdown entry "no borrow", which should no longer be used under current instructions (and confirmed not used on any incompletes currently)
+* retired and deleted [[query s_tmp_Boarding_Loc_no_borrow_but_entry]]
+* retired and deleted [[query check_tmp_Transfer_Ready_not_before_Boarding_Loc]] since it is a subset of [[query check_transfer_DtTm_during_admission]], no need to run both
+=== 2021-09-29 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 11:52, 2021 September 29 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* 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''
+=== 2021-09-23-1 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 15:25, 2021 September 23 (CDT)
-=== 2021-09-08 ===
-not rolled yet [[User:Ttenbergen|Ttenbergen]] 17:44, 2021 September 7 (CDT)
-<!----------------------------
 Changes collectors need to know about:
+* Retired the following [[ICD10 Diagnoses]] as part of rolling back [[Change from Awaiting/delayed dx codes to Transfer Ready DtTm]]:
+** [[Awaiting/delayed transfer to any other care facility outside Winnipeg other than home or LTC/PCH]]
+** [[Awaiting/delayed transfer to home]]
+** [[Awaiting/delayed transfer to lower acuity site in Winnipeg other than home or LTC/PCH]]
+** [[Awaiting/delayed transfer to other acute care facility in Winnipeg]]
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* updated [[query check_tmp_Service_and_Boarding_Loc_during_admission_timeframe]] to only check completes, and to only flag gt dispo, not = dispo
+=== 2021-09-23 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 09:32, 2021 September 23 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* updated [[query check_tmp_Service_and_Boarding_Loc_during_admission_timeframe]] from TR >= Dispo to TR > Dispo
+=== 2021-09-22 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 16:58, 2021 September 22 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* changed spelling from "Cardiac arrhythmia, NOS" to [[Cardiac arrhythmia, NOS]]
+* added utility queries from CFE: [[created_AdmitDtTm query]], [[created_FirstService query]]
+* updated [[query check_tmp_Service_and_Boarding_Loc_during_admission_timeframe]] to check for blank date_var / time_var, to also check [[Boarding Loc]] that had been omitted so far, and to use new Admit Time aggregate definition.
+* [[query check_CCI_TISS_Vented_without_mechanism]] was only triggering on re-opened complete patients, now triggers on any pt when dx checkbox is checked
+=== 2021-09-21 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 10:07, 2021 September 21 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* updated [[query check_minimal_data_set_incomplete]] which had been broken by rename of [[Created FirstLocation query]] [[User:Ttenbergen|Ttenbergen]] 10:01, 2021 September 21 (CDT)
+=== 2021-09-20 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 12:33, 2021 September 20 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* renamed ''query L_First_Boarding_loc'' to [[Created_FirstLocation query]] so we use the same structure in CCMDB.accdb and CFE
+* updated [[query check_CCI_TISS_matching_BoardingLoc_time]] to exclude deleted and sent records
+=== 2021-09-16 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 14:35, 2021 September 16 (CDT)
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
------------------------------->
+* fixed [[created_FirstLocation query]] - had tweaked it for previous version and it broke [[query check_tmp_Boarding_Loc_Service_first_same]]
+=== 2021-09-08 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 09:48, 2021 September 16 (CDT)
+'''Changes collectors need to know about:'''
+* added [[query check_CCI_TISS_matching_BoardingLoc_time]]
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
 * Added the following as [[S Cognos Services table#Exceptional entries]]:
@@ Line 17: / Line 219: @@
 ** HSC Critical Care – SICU
-* '''started fixing check_ER_Delay_not_too_big but not complete yet!'''
+* 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 ===
@@ Line 42: / Line 244: @@
 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'''
@@ Line 105: / Line 307: @@
 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):
-* 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 ===
@@ Line 181: / Line 383: @@
 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 ===
@@ Line 211: / Line 413: @@
 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
@@ Line 285: / Line 487: @@
 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
-* 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
@@ Line 310: / Line 512: @@
 * 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"
-* retired briefly available ICD10 version of [[Drug-induced immunosuppression]]
+* retired briefly available ICD10 version of ''Drug-induced immunosuppression''
 === 2021-04-22 ===
@@ Line 316: / Line 518: @@
 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):
-* 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 ===
@@ Line 332: / Line 534: @@
 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 ===
@@ Line 347: / Line 549: @@
 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 ===
@@ Line 431: / Line 633: @@
 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 ===
@@ Line 489: / Line 691: @@
 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 ===
@@ Line 495: / Line 697: @@
 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):
@@ Line 591: / Line 793: @@
 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