CCMDB.accdb Change Log 2021: Difference between revisions

(117 intermediate revisions by the same user not shown)

Line 3:

== Versions ==

Change ~~for next version:~~

=== 2022 ===

See [[CCMDB.accdb Change Log 2022]]

=== 2021-08-25 ===

=== 2021-12-30 ===

not rolled yet [[User:Ttenbergen|Ttenbergen]] 17:00, 2021 ~~August 24~~ (CDT)

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)

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

** HSC Critical Care – MICU

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

=== 2021-09-07 ===

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

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 no longer exclude ER records, and to check for duplication even if the item is different.

* changed [[query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER]] to a soft check

=== 2021-09-02-1 ===

Rolled out [[User:Ttenbergen|Ttenbergen]] 14:32, 2021 September 2 (CDT)

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

* removed old, unused entry "STB_E5a" from [[s_dispo table]] as part of [[2020-06 s dispo table cleanup]]

* updated Sub CB_recycle_Click() ([[♻️ button]]) which was broken by recent update

=== 2021-09-02 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 09:17, 2021 September 2 (CDT)

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

* restored accidental edit to [[query check_CCI_TISS_NrDays_GT_LOS]]

=== 2021-09-01-1 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 16:49, 2021 September 1 (CDT)

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

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

* updated [[query check_CCI_TISS_NrDays_LT_LOS]] - query had been limited to complete patients but is triggered when “D” is checked, so it never triggered at all

=== 2021-09-01 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 11:45, 2021 September 1 (CDT)

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

* ~~changed [[Check function location NE dispo]]~~, [[~~Check function preAdmit NE Location~~]] ~~and~~ [[~~Check function location NE dispo~~]] ~~since changes to [[Processes around changing a PatientFollow assignment]] mean these can no longer be correct~~

* updated Function Data_Version() to set to 2999-12-31 if version not found so it doesn't wipe out data with new data.

* updated how update/delete/etc queries are run in VBA to start showing errors if there are any, but continue to hide having to OK each update; affected code:

** Sub cb_make_B_Loc_Click(); Sub add_tmp_service_Click(); Sub cb_Delete_Sent_Patients_Click(); form Mainform Form_Load(); Sub import_new_Cognos(); Sub Cognos2_Service_Excluder(); Sub Cognos2_Unit_Excluder(); Convert_DB(); Sub CB_recycle_Click()

* fix for [[query s_tmp_check_combined_BL_and_TRDtTm_nonsequential]]

=== 2021-08-25 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 11:57, 2021 August 26 (CDT)

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

Changes collectors need to know about:

* implemented [[query s_tmp_check_combined_BL_and_TRDtTm_nonsequential]]

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

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

* changed [[Check function location NE dispo]], [[Check function preAdmit NE Location]] and [[Check function location NE dispo]] since changes to [[Processes around changing a PatientFollow assignment]] mean these can no longer be correct

* disabled "STB_ICMU" in [[s_dispo table]]

=== 2021-08-24 ===

Line 55:

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

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

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

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

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

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

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

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

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

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

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

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-08-25 ===
+=== 2021-12-30 ===
-not rolled yet [[User:Ttenbergen|Ttenbergen]] 17:00, 2021 August 24 (CDT)
+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)
+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]]:
+** HSC Critical Care – MICU
+** 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)
+=== 2021-09-07 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 17:44, 2021 September 7 (CDT)
+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 no longer exclude ER records, and to check for duplication even if the item is different.
+* changed [[query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER]] to a soft check
+=== 2021-09-02-1 ===
+Rolled out [[User:Ttenbergen|Ttenbergen]] 14:32, 2021 September 2 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* removed old, unused entry "STB_E5a" from [[s_dispo table]] as part of [[2020-06 s dispo table cleanup]]
+* updated Sub CB_recycle_Click() ([[♻️ button]]) which was broken by recent update
+=== 2021-09-02 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 09:17, 2021 September 2 (CDT)
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* restored accidental edit to [[query check_CCI_TISS_NrDays_GT_LOS]]
+=== 2021-09-01-1 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 16:49, 2021 September 1 (CDT)
+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 [[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'''
+Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
+* updated [[query check_CCI_TISS_NrDays_LT_LOS]] - query had been limited to complete patients but is triggered when “D” is checked, so it never triggered at all
+=== 2021-09-01 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 11:45, 2021 September 1 (CDT)
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* changed [[Check function location NE dispo]], [[Check function preAdmit NE Location]] and [[Check function location NE dispo]] since changes to [[Processes around changing a PatientFollow assignment]] mean these can no longer be correct
+* updated Function Data_Version() to set to 2999-12-31 if version not found so it doesn't wipe out data with new data.
+* updated how update/delete/etc queries are run in VBA to start showing errors if there are any, but continue to hide having to OK each update; affected code:
+** Sub cb_make_B_Loc_Click(); Sub add_tmp_service_Click(); Sub cb_Delete_Sent_Patients_Click(); form Mainform Form_Load(); Sub import_new_Cognos(); Sub Cognos2_Service_Excluder(); Sub Cognos2_Unit_Excluder(); Convert_DB(); Sub CB_recycle_Click()
+* fix for [[query s_tmp_check_combined_BL_and_TRDtTm_nonsequential]]
+=== 2021-08-25 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 11:57, 2021 August 26 (CDT)
-<!----------------------------
 Changes collectors need to know about:
+* implemented [[query s_tmp_check_combined_BL_and_TRDtTm_nonsequential]]
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
------------------------------->
+* changed [[Check function location NE dispo]], [[Check function preAdmit NE Location]] and [[Check function location NE dispo]] since changes to [[Processes around changing a PatientFollow assignment]] mean these can no longer be correct
+* disabled "STB_ICMU" in [[s_dispo table]]
 === 2021-08-24 ===
@@ Line 55: / 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 131: / 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 161: / 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 235: / 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 260: / 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 266: / 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 282: / 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 297: / 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 381: / 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 439: / 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 445: / 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 541: / 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