CCMDB.accdb Change Log 2021

See Log (disambiguation) for other uses of the term "Log". See the Development Documentation Category for other development logs. See Rolling out changes for the process of rolling out changes. See also requested CCMDB changes for the next version and CCMDB.accdb Data Integrity Checks.

Versions

2022

See CCMDB.accdb Change Log 2022

2021-12-30

rolled out 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 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. Ttenbergen 11:11, 2021 December 13 (CST)

2021-12-08

rolled out Ttenbergen 10:58, 2021 December 8 (CST)

Changes collectors need to know about:

• re-enabled STB_IMCU in S dispo table - wiki instructions to followTtenbergen 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 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 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 followTtenbergen 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 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. 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. Ttenbergen 14:23, 2021 December 2 (CST)

2021-11-12

rolled out 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 Ttenbergen 09:54, 2021 November 12 (CST)

Changes collectors need to know about:

• added HSC ALC Medicine Services to s_tmp table so they can be entered as Service tmp entry without Query s tmp project item consistent error [1]

2021-11-05

rolled out Ttenbergen 23:02, 2021 November 10 (CST)

Changes collectors need to know about:

• set Myocarditis, chronic to be a 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 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 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 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 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 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. Ttenbergen 09:31, 2021 October 20 (CDT)

2021-10-13

rolled out 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 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 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 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 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 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 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 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 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 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 Ttenbergen 10:01, 2021 September 21 (CDT)

2021-09-20

rolled out 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 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 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 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 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 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 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 Ttenbergen 11:45, 2021 September 1 (CDT)

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

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

not rolled yet Ttenbergen 16:03, 2021 August 24 (CDT)

Changes collectors need to know about:

• GRA PACU was duplicated in S dispo table:
  • inactivated the old entry "GRA – recovery" - if it is currently used in an incomplete patient there may be an error, so please check that and change it to GH-Recovery Room before you do news and backup on the laptop (Tina emailed GRA about this)
  • changed the name "GRA_PACU" to "GH-Recovery Room" – if it is currently used on an incomplete patient the listing should simply change to the new word

2021-08-06

rolled out Ttenbergen 16:03, 2021 August 24 (CDT)

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

• updated S_PatientFollow_distribution table to reflect the revival of the STB laptops S4 and S9:
  • re-assigned numbers ending in 36-63 to S9 laptop from S7, S8
  • re-assigned numbers ending in 00-29 to S4 laptop from S5, S6

2021-08-05

rolled out Ttenbergen 11:45, 2021 August 6 (CDT)

Changes collectors need to know about:

• added Stevens-Johnson Syndrome (Bullous erythema multiforme) to S ICD10 table

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

• updated query check_tmp_2_BL_TR_S_same_tm to only list completes and incompletes (ie not deleteds).
• updated query check_tmp_Transfer_Ready_not_before_Boarding_Loc to only list completes and incompletes (ie not deleteds).

2021-08-04

rolled out Ttenbergen 17:06, 2021 August 4 (CDT)

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

• fixed Sending Patients: if a tmp entry was deleted, query Send_Centralized_L_TmpV2_delete would only delete the entry if RecordStatus was "incomplete", but it should also have deleted the entry if it was "complete". Also checked the other send delete queries, and the tmp one was the only one where this was wrong. Ttenbergen 15:11, 2021 August 4 (CDT)
• some cleanup, removed unused queries check_eliminated_CCI_Comp1 and check_eliminated_CCI_Comp11
• implemented query check_tmp_Transfer_Ready_not_before_Boarding_Loc
• implemented query check_tmp_2_BL_TR_S_same_tm

2021-07-22

rolled out 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 Ttenbergen 14:11, 2021 July 22 (CDT)

2021-07-21-2

rolled out Ttenbergen 15:05, 2021 July 21 (CDT)

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

• query L_CCI_Combined_ComponentSubQ suddenly threw error because it was using D_ID instead of Pat_ID. That query had not been changed in ages, and the error should have broken it then. I wonder if some part of the upgrade to 2019 shook it up. In any case, fixed now. Ttenbergen 15:05, 2021 July 21 (CDT)

2021-07-21-1

rolled out Ttenbergen 13:16, 2021 July 21 (CDT)

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

• more tweaking for query check_minimal_data_set_incomplete

2021-07-21

rolled out Ttenbergen 13:16, 2021 July 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 wasn't finding missing admit dttm

2021-07-13

rolled out Ttenbergen 10:01, 2021 July 13 (CDT)

Changes collectors need to know about:

• updated "set COVID and isolation" button and "set COVID and isolation" button so the Isolation, infectious entry is entered without date and as Admit Procedure Ttenbergen 09:30, 2021 July 13 (CDT)

2021-07-08-1

rolled out Ttenbergen

Changes collectors need to know about:

• don't use Change from Awaiting/delayed dx codes to Transfer Ready DtTm yet
  • but added the "WRHA Medicine ward" and "Palliative" items (wasn't on initial list but is needed) for Transfer Ready DtTm tmp entry to implement Change from Awaiting/delayed dx codes to Transfer Ready DtTm. Ttenbergen 09:42, 2021 July 8 (CDT)
• removed EPR Reports Integrator
  • updated Main Form to remove buttons
  • removed references to EPR reports components from VBA, incl Sub CognosExcluder which had not been used since we moved to exclusion by unit and service
• removed "eyes" button

2021-07-08

rolled out Ttenbergen 10:58, 2021 July 8 (CDT)

Changes collectors need to know about:

• added the new items for Transfer Ready DtTm tmp entry to implement Change from Awaiting/delayed dx codes to Transfer Ready DtTm. Ttenbergen 09:42, 2021 July 8 (CDT)

2021-07-05

rolled out Ttenbergen 13:18, 2021 July 5 (CDT)

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

• changed patient distribution at HSC CC after data review; reassigned MRN endings 00, 01 and 02 from H7 to H9

2021-06-29-1

rolled out Ttenbergen 16:53, 2021 June 29 (CDT)

Changes collectors need to know about:

• made services and units visible in some profiles where they would have previously been hidden
  • this would be second or later profiles for the same patient under the same admission
  • (updated Query Cognos2_sub_Services_FormQuery and Query Cognos2_sub_Units_FormQuery to compensate for the fact that the program sometimes (wrongly) uses the HospAdmitDtm rather than the IPAdmitDtm)

2021-06-29

rolled out Ttenbergen 09:36, 2021 June 29 (CDT)

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

• fix to problem with "set COVID and isolation" button and "set MRSA Colonized" button that was introduced in last update.

2021-06-28

rolled out Ttenbergen 17:11, 2021 June 28 (CDT)

Changes collectors need to know about:

• added "set COVID and isolation" button

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

• fixed the "hiding" for the TISS items for medicine laptops so the buttons are no longer visible on med laptops.

2021-06-23

rolled out Ttenbergen 19:55, 2021 June 23 (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 to fix false positive on missing Arrive DtTm that had been accidentally introduced in #2021-06-17.

2021-06-20

rolled out Ttenbergen 22:21, 2021 June 20 (CDT)

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

• changed sub Convert_DB to properly bring across sL_Cognos2_Service_exclusions table and sL_Cognos2_Unit_exclusions table

2021-06-17

rolled out Ttenbergen 14:20, 2021 June 17 (CDT)

Changes collectors need to know about:

• updated Minimal Data Set to also require at least one Boarding Loc and one Service tmp entry (updated query check_minimal_data_set_incomplete) Ttenbergen 10:54, 2021 June 17 (CDT)

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

• updated sub Convert_DB() to download CCMDB data.mdb Change Log#2021-06-17; nothing to import or wrangle since we are just adding a field, and not adding the field to sending until fully rolled and also added to CFE; this will be a behind-the-scenes field, not visible from front end, and just used to facilitate working with multiple encounters and cognos data.

2021-06-15

rolled out Ttenbergen 17:06, 2021 June 15 (CDT)

Changes collectors need to know about:

• removed GCS sedated field

2021-06-10

rolled out Ttenbergen 16:24, 2021 June 11 (CDT)

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

• cleaned Boarding Loc entries for GRA that are no longer used out of S tmp table; a question remains, so not rolled yet

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

2021-06-09

rolled out Ttenbergen 12:05, 2021 June 9 (CDT)

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

• changed how the VisitAdmit DtTm is generated when the copy button is pressed in Patient Viewer Tab Cognos ADT2 (now uses query Cognos2_sub_Services_VADT_finder; I had initially assumed this would always be a copy of the previous record, but of course it could be a new admission. Ttenbergen 11:53, 2021 June 9 (CDT)

2021-06-07

rolled out Ttenbergen 09:31, 2021 June 9 (CDT)

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

• updated wording of some error messages for converting a new version of the master data file

2021-06-02-3

rolled out Ttenbergen 15:10, 2021 June 3 (CDT)

Changes collectors need to know about:

• retired code Not an Infection (ICD10 pathogen alternative) - it was only used to satisfy Query check ICD10 Inf Potential Infection must have pathogen or alt and since that's retired, it's no longer needed. Ttenbergen 14:06, 2021 June 3 (CDT)

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

• tweaked the S ICD10 Categories table entries for Infectious disease NOS and Aspergillus to prevent wrong firing of query Check Inf Pathogens must have Infection requiring pathogen or Potential Infection
• updated errbox in Patient Viewer to be norm_gray by default, as it was supposed to be, and only to turn yellow if there is an error in there.
• removed "Reset Err" button at bottom of screen, since Yellow Fields don't turn white when values are corrected doesn't seem to be an issue any longer and the button clutters things up. Ttenbergen 14:43, 2021 June 3 (CDT)
• removed "reset" button from Main Form

2021-06-02-2

not rolled yet Ttenbergen 10:25, 2021 June 2 (CDT)

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

• updated S CCI Categories Collection Mode table for Prone positioning to be consistent with wiki instructions.

2021-06-02

rolled out Ttenbergen 10:25, 2021 June 2 (CDT)

Changes collectors need to know about:

• updated Patient Viewer Tab Cognos ADT2:
  • show which records are excluded via red backdrop behind "exclude" button for Services and Units

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

• updated query Cognos2_sub_Services_FormQuery to de-duplicate records that are excluded repeatedly

2021-06-01

rolled out Ttenbergen 14:31, 2021 June 1 (CDT)

Changes collectors need to know about:

• re-implemented the #2021-05-20 change: updated Patient Viewer Tab Cognos ADT2 to list excluded Service entries for Cognos; this is to allow excluding things from CE via exclude button in this tab, even if they had previously been excluded from CSS (updated query Cognos2_sub_Services_FormQuery)

2021-05-18

reverted to 5-18 because something got corrupted in 5-20. will review and re-roll Ttenbergen 13:20, 2021 June 1 (CDT)

2021-05-20

rolled out Ttenbergen 11:24, 2021 May 31 (CDT)

Changes collectors need to know about:

• updated Patient Viewer Tab Cognos ADT2 to list excluded Service entries for Cognos; this is to allow excluding things from CE via exclude button in this tab, even if they had previously been excluded from CSS (updated query Cognos2_sub_Services_FormQuery)

2021-05-18

rolled out Ttenbergen 15:22, 2021 May 20 (CDT)

Changes collectors need to know about:

• We used to collect the initial ER Boarding Loc with the start DtTm of the of the ER as per Cognos. Our cross checks worked in this scenario:

query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER requires the ER entry if prev location is ER

query check_tmp_service_or_location_duplicate doesn't allow two service lines to have same dttms

• Now we changed to using the same start dttm for the first service and the first boarding loc, even in the ER where this clearly is not true; in any case, we added a cross check to ensure this is entered correctly: query check_tmp_Boarding_Loc_Service_first_same
• This made it impossible to enter a patient who came from ER but didn't spend time there. Could not enter the date and times the same, but also could not omit the ER entry. Discussed with Julie, and we decided to update query check_tmp_service_or_location_duplicate to exclude ER

2021-05-04

rolled out Ttenbergen 11:00, 2021 May 5 (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 catch a scenario it was missing
• 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

2021-05-03-1

rolled out Ttenbergen 12:11, 2021 May 4 (CDT)

Changes collectors need to know about:

• made the time component of Px Date available in Patient Viewer Tab CCI Comp to be able to comply with new collection instructions for that field

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

• deactivated "GRA_CAU" in S dispo table

2021-05-03

rolled out Ttenbergen 14:24, 2021 May 3 (CDT)

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

• fixed query check_tmp_Boarding_Loc_Service_first_same

2021-04-23

rolled out Ttenbergen 21:01, 2021 April 29 (CDT)

Changes collectors need to know about:

• implemented query check_tmp_Boarding_Loc_Service_first_same; please review this because it may cause many errors when it runs since we changed the rules about this.
• 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

2021-04-22

rolled outTtenbergen 16:06, 2021 April 23 (CDT)

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

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

2021-04-21-1

rolled out Ttenbergen 13:53, 2021 April 21 (CDT)

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

• Changed New Pt Serial helper form to be blank for S7 laptop as well, which was forgotten in earlier change
• updated Px Type dropdown in Patient Viewer Tab CCI Pick to limit to available options, it had allowed manually typed options that led to misleading errors

2021-04-21

rolled out Ttenbergen 10:03, 2021 April 21 (CDT)

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

2021-04-20

rolled out Ttenbergen 09:08, 2021 April 21 (CDT)

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

• Changed New Pt Serial helper form to be blank for STB CC laptops, since ACCU is not an appropriate default and a complete blank is actually more helpful.

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

• Finished updating the re-classification of ICD10 codes that qualify as Apache Comorbid codes

2021-04-09

rolled out Ttenbergen 09:48, 2021 April 19 (CDT)

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

2021-04-08-4

rolled out Ttenbergen 16:40, 2021 April 8 (CDT)

Changes collectors need to know about:

• reverted the changes made to CCI and TISS codes in #2021-04-07

2021-04-08-3

rolled out Ttenbergen

Changes collectors need to know about:

• re-hid the TISS buttons for the retired items that I had restored to troubleshoot and forgot to re-hide, oi.

2021-04-08-2

rolled out Ttenbergen 10:02, 2021 April 8 (CDT)

Changes collectors need to know about:

• changed the "end dates" for the CCI codes recently retired to May 7 instead of Apr 7. That way they will remain visible for now, making it easier to change them over. There is ongoing debate about this change, stay tuned.

2021-04-08-1

rolled out Ttenbergen 09:54, 2021 April 8 (CDT)

Changes collectors need to know about:

• restored some TISS items to dropdown list that I had accidentally removed.

2021-04-08

rolled out Ttenbergen 09:39, 2021 April 8 (CDT)

Changes collectors need to know about:

• had accidentally hidden the button for Invasive Mechanical Ventilation (TISS Item), restored it

2021-04-07

rolled out Ttenbergen 21:39, 2021 April 7 (CDT)

Changes collectors need to know about:

• changes to remove duplication between CCI and TISS (you will receive an email about this):
  • retired CCIs:
    • ICP monitor (Placement of implanted, invasive intracranial pressure monitoring device)
    • Swan-Ganz (Pulmonary Artery Flotation) Catheter placement
    • Arterial catheterization, any location
  • retired TISSs and disabled the corresponding buttons:
    • CPR within past 24 hrs (TISS Item)
    • Non-invasive CPAP or BIPAP (TISS Item)
    • Central venous catheter (TISS Item)
    • Trach Tube Present (TISS Item)
    • Intermittent hemodialysis (TISS Item)
    • CRRT (TISS Item)
    • Peritoneal dialysis (TISS Item)
    • IV hyperalimentation (TISS Item)
    • Patient is on isolation (TISS Item)
  • CCIs changed to CCI Collection Mode "CCI collect each day"
    • CPR, cardiac resuscitation
    • BiPAP, CPAP, NIV, own ventilator (Mechanical ventilation, noninvasive)
    • "CVC placement, any location" and name changed to "CVC presence, any location"
    • "Tracheostomy creation" and name changed to "Tracheostomy, presence"
    • HD (Hemodialysis)
    • CRRT (incl volume removal via PRISMA device)
    • PD (Peritoneal dialysis)
    • TPN (Total parenteral nutrition)
    • Isolation, infectious

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

• implemented query s_tmp_check_Boarding_Loc_and_TransferReadyDtTm_pairs
• tweaked query s_tmp_check_combined_Boarding_Loc_and_TransferReadyDtTm and how it is called so that it will be triggered when Tmp Complete checkbox is set rather than on Pre-send Checker

2021-04-06-1

rolled out Ttenbergen 17:14, 2021 April 6 (CDT)

Changes collectors need to know about:

• added options to Service tmp entry:
  • "HSC Critical Care - MICU"
  • "HSC Critical Care - SICU"
• increased threshold for Cognos2_No_Service_or_Loc_in_some_time query from 14 to 28 weeks since I am told it's not uncommon for a pt to be on a med ward without changes for that long.

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

• updated the "MISI" listings in s_Cognos_Services table as per email request from Julie
• updated the s_level_of_care table as per email from Julie
• added Julie to the automatically generated notifications about new units or services in Cognos

2021-04-06

rolled out Ttenbergen 10:37, 2021 April 6 (CDT)

Changes collectors need to know about:

• 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

2021-04-01

rolled out Ttenbergen 09:58, 2021 April 1 (CDT)

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

• updated query check_ICD10_dx_implying_death_must_have_appropriate_dispo which was still using the old "died..." entries in S dispo table
• renamed query check_ICD10_Inf_Potential_Infection_must_have_pathogen_or_alt, previous name was too long and breaking MS Access

2021-03-31

rolled out Ttenbergen 09:12, 2021 April 1 (CDT)

Changes collectors need to know about:

• correction to query s_tmp_check_combined_Boarding_Loc_and_TransferReadyDtTm, it had tons of false positives

2021-03-29

rolled out Ttenbergen 14:58, 2021 March 31 (CDT)

Changes collectors need to know about:

• added query check_ICD10_Inf_Potential_Infection_must_have_pathogen_or_alt; this means you will need to enter a Not an Infection (ICD10 pathogen alternative) for potential infections when they are not infections
• added query s_tmp_check_combined_Boarding_Loc_and_TransferReadyDtTm and removed query check_transfer_ready_tmp_for_each_Boarding_Loc; this means you will need to add combining numbers for complete profiles' Boarding Loc and Transfer Ready DtTm field entries
• added query check_CCI_TISS_Pharm_Vasoactive; this means you will need to have a TISS vasoactive entry if you enter a vasoactive drug

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

• changed Transfer Ready DtTm tmp entry so a line is no longer automatically added when a new record is added. Since this a line is now added automatically when a new Boarding Loc is added, the line from adding the record had to be deleted. Ttenbergen 10:43, 2021 March 31 (CDT)

2021-03-18

rolled out Ttenbergen 10:13, 2021 March 29 (CDT)

Changes collectors need to know about:

• changes to make it possible to link Boarding Loc and Service tmp entry using a number...
  • added combiner field and sorter to Patient Viewer Tab Cognos ADT2
  • built but not yet activated query s_tmp_check_combined_Boarding_Loc_and_TransferReadyDtTm

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

• updated s_level_of_care table with data provided by Julie via email 2021-02-26
• updated S locations allowed collection table to properly list HSC_IICU

2021-03-17

rolled out Ttenbergen 15:26, 2021 March 18 (CDT)

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

• Housekeeping
  • to finish off Change of GRA location names from "our" names to EPR/Cognos names: inactivated GRA_N5, GRA_S3
    • waiting to hear about GRA_N3, not inactivated yet...
  • after PatientFollow Project:
    • EMIP no longer used as entry so inactivated GRA_EMIP, HSC_EMIP, STB_EMIP, STB_EMIPa, STB_EMIPd
    • no longer coding individual med wards in pre-admit, previous, service location and dispo, so inactivated those that are no longer currently used:
      • HSC: HSC_A4, HSC_B2, HSC_B3, HSC_B3S, HSC_CAU, HSC_D4, HSC_D5, HSC_H4, HSC_IICa, HSC_IICb, HSC_IICd, HSC_MICb, HSC_MICd, HSC_SICa, HSC_SICb, HSC_SICd, HSC_WRS3
      • STB: STB_B5, STB_CAU, STB_E5, STB_E5a, STB_E6_B
  • updated s_locations_allowed_collection table to reflect the above and other changes (ie deleted entries that are no longer needed)
• added wiki link buttons to the buttons on teh top right corner of Patient Viewer

2021-03-10

was somehow rolled out as part of Cognos I think...

Changes collectors need to know about:

• updated "make loc" button to also add the item for Transfer Ready DtTm tmp entry

2021-03-04

was rolled out at some point as part of rolling out new Cognos data Ttenbergen 09:27, 2021 March 10 (CST)

Changes collectors need to know about:

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

• fixed control tip (hover tip) for ♻️ button
• changed Sub CognosImport to Function CognosImport so it can return a string to LoadCognos.vbs

2021-02-12

rolled out Ttenbergen 12:03, 2021 February 12 (CST)

• added Herman to new service/unit emails

2021-02-10

rolled out Ttenbergen 15:31, 2021 February 11 (CST)

Changes collectors need to know about:

• changed query check_CCI_TISS_Vented_without_mechanism to only check TISS entries with dt >= 2020-12-07, and only if record complete
• updated Eyes button to populate the email address if known, and the subject line
• Added ♻️ button to Patient Viewer (primarily to smooth out Using Cognos2 to keep track of patients process, more details to come)

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

• tweak to query check_CCI_TISS_NrDays_LT_LOS which wasn't connecting to its trigger right

2021-02-09

rolled out Ttenbergen 08:59, 2021 February 10 (CST)

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

• updated Cognos Service list in Patient Viewer Tab Cognos ADT2 to be sorted by Service Start DtTm
• updated query check_ICD10_dx_implying_death_must_have_appropriate_dispo, had false positive for "Died - to morgue"
• updated query check_transfer_ready_tmp_for_each_Boarding_Loc, it was still going on the assumption of no TRDT for ER Boarding Loc.

2021-02-04-1

rolled out Ttenbergen 09:41, 2021 February 9 (CST)

Changes collectors need to know about:

• implemented query check_transfer_ready_tmp_for_each_Boarding_Loc
• query check_CCI_TISS_Vented_without_mechanism - query wasn't being called but it is now.

2021-02-04

rolled out Ttenbergen 09:21, 2021 February 4 (CST)

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

• updated query check_has_transfer_ready_date_or_checkbox which was giving false positives

2021-02-03

rolled out Ttenbergen 17:28, 2021 February 3 (CST)

Changes collectors need to know about:

• added functionality to the Inpatient Disposition field in Patient Viewer Tab Cognos ADT2 to automatically populate the Dispo field if the field states pt is deceased, AMA or gone home.

2021-02-03

rolled out Ttenbergen 14:59, 2021 February 3 (CST)

Changes collectors need to know about:

• updated Patient Viewer Tab Cognos ADT2 to list Services even if the service is excluded as a service; this is to more easily see where patients come from or go to, of course you'd only enter services we follow
• tweaked query check transfer DtTm during admission
• added query check_has_transfer_ready_date_or_checkbox

2021-01-28-1

rolled out Ttenbergen 09:33, 2021 February 3 (CST)

Changes collectors need to know about:

• Implemented
  • query check_CCI_TISS_Intubation_vs_Intubated
  • query check_CCI_TISS_Vented_without_mechanism
• updated and reinstated
  • query check_ICD10_awaiting_has_Transfer_Ready_DtTm

Changes collectors need to know about:

• updated Gastrointestinal infection (gastroenteritis, colitis), bug NOS to not require a pathogen
• query check_minimal_data_set_incomplete wasn't checking for DOB, fixed

2021-01-28

rolled out Ttenbergen 15:26, 2021 January 28 (CST)

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

• tweaked CSS so that peach + would actually enter the Service Location chosen in the wizard
• fixed query check_ICD10_dx_implying_death_must_have_appropriate_dispo - was implemented long ago, but nothing was set up to trigger the check
• inactivated Boarding Locs "GRA - Home medicine ward" and "HSC - Home medicine ward"; there is one left for "STB - Home medicine ward" so left that for now
• updated query check_CCI_if_no_then_none which was triggering for TISS entries

2021-01-27

rolled out Ttenbergen 16:00, 2021 January 27 (CST)

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

• changed Cognos2_matcher query so match on end date is not required; necessary since the end date of services where the patient still is always list as today, ie always keep changing.
• added logging for the automated Congos import on Pagasa's PC

2021-01-26-1

rolled out Ttenbergen 08:54, 2021 January 27 (CST)

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

• added CCMDB version to "generate email" button

2021-01-26

rolled out Ttenbergen 15:41, 2021 January 26 (CST)

Changes collectors need to know about:

• 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

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

• updated Function getReportFileFromMail to look for an email at most 6 hours old; previoulsy looked for email at most 1 day old, but that would import yesterday's email if both today and yesterday were delayed by a few minutes.
• updated query check_CCI_TISS_if_no_then_none which wasn't linking by dates

2021-01-22-1

rolled out Ttenbergen 16:42, 2021 January 22 (CST)

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

• tweaked query check_CCI_TISS_NrDays_LT_LOS to only consider data after 2020-12-06
• added GH-OR to Boarding Loc
• made Check duplicate patient easier to use by adding labels to columns and actually listing the dates of both records to more easily see overlaps

2021-01-22

rolled out Ttenbergen 13:56, 2021 January 22 (CST) Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

• tweak to query check_CCI_TISS_NrDays_GT_LOS, was giving false positives for days with multiple TISS or multiple service dates, fixed.

2021-01-21-4

rolled out Ttenbergen 13:32, 2021 January 22 (CST)

Changes collectors need to know about:

• finally added Post COVID-19 condition, had forgotten all about that Ttenbergen 10:17, 2021 January 22 (CST)
• STB_CC: updated query s_tmp_ABO_TEE_checks so it will only check profiles that have a Service tmp entry "SBGH Cardiac / Cardiac Surgery" Or "SBGH Critical Care / Cardiac Surgery"

2021-01-21-3

rolled out Ttenbergen 14:51, 2021 January 21 (CST)

• fix to pre-send checker

2021-01-21-2

rolled out Ttenbergen 12:41, 2021 January 21 (CST) Changes collectors need to know about:

• added query check_CCI_TISS_NrDays_GT_LOS to pre-sent cheker
• added query check_CCI_TISS_NrDays_LT_LOS to dx checker on completion
• removed the old "C" and "L" checkboxes that used to check for comorbids and Labs - they had not been hooked up to any functionality since we moved to the new diagnosis schema and started getting most labs from DSM

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

• update to code in query check_CCI_TISS_if_no_then_none that was causing error in pre-send checker.

2021-01-21-1

rolled out because we needed to test Cognos import on Pagasa's PC Ttenbergen 11:05, 2021 January 21 (CST)

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

• updated more to work with Cognos3 data:
  • s_Cognos_Services_additions_needed query
  • s_Cognos_Units_additions_needed query
  • Sub CognosImport

2021-01-21

rolled out Ttenbergen 09:30, 2021 January 21 (CST)

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

• corrected the error when using a peach + in CSS

2021-01-20-1

rolled out Ttenbergen 09:07, 2021 January 21 (CST)

Changes collectors need to know about:

• added cross-checks:
  • query check_CCI_TISS_if_no_then_none
• fixed problems with cross-checks:
  • query check_CCI_if_no_then_none - this query would have never found anything before, since it was not matching on Pat_ID correctly
  • query check_CCI_must_have_entry - updated so it will not be satisfied by TISS items

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

• updated Cognos2 No Service or Loc in some time query to also exclude records that have been opened in the last 2 weeks; should have been like that in the first place
• confirmed that Query check CCI Date catches dates before admit and after dispo; so how did the records Julie found get through?
• confirmed and tweaked names for
  • query check_CCI_Picklist_unfilled

2021-01-20

rolled out Ttenbergen 09:40, 2021 January 20 (CST)

• change to fix run-time error when starting a new pt from CSS (it was referencing a defunct form that had been cleared out)
• updated query check_tmp_service_or_location_duplicate to only check incomplete records

2021-01-19-2

rolled out Ttenbergen 09:23, 2021 January 20 (CST)

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

• deleted defunct Cognos_processed table
• fixed Sub import_new_Cognos() to work with the newest automated Cognos data

2021-01-19-1

rolled out Ttenbergen 12:22, 2021 January 19 (CST)

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

• updated Cognos2_Ender_Service_formQuery query to make CE work when a new Cognos import is not available
• deleted defunct Cognos import table, Cognos_import_processor query and Cognos integrator query

2021-01-19

rolled out Ttenbergen 11:33, 2021 January 19 (CST)

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

• updated query check_tmp_service_or_location_duplicate to only apply if RecordStatus = incomplete, and to only trigger for Service tmp entry and Boarding Loc (had false positives for Transfer Ready DtTm tmp entry

2021-01-18

rolled out Ttenbergen 16:48, 2021 January 18 (CST) Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

• Fixed problem when a profile is opened from CE
• updated query check_tmp_Service_and_Boarding_Loc_during_admission_timeframe to only check incomplete records
• updated query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER that was not accepting the STB and HSC ERs as Boarding Loc entries

2021-01-15

rolled out Ttenbergen 10:54, 2021 January 18 (CST)

Changes collectors need to know about:

• added Query check_tmp_service_or_location_duplicate
• added query check_tmp_service_and_program_consistency
• added query check_tmp_Service_and_Boarding_Loc_during_admission_timeframe
• added Query check tmp ER Boarding Loc should exist if from ER

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

• removed some remnants of the old ADT tab that were causing errors

2021-01-14-2

rolled out Ttenbergen 21:34, 2021 January 14 (CST)

Changes collectors need to know about:

• Postal Code data is now included in Cognos and will now auto-populate when a record is created from CSS

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

• fixed import routine for the new Cognos2 data to make Cognos2 OneTime table populate from the new data (it was still pulling from the old)

2021-01-14

rolled out Ttenbergen 12:22, 2021 January 14 (CST)

Changes collectors need to know about:

• fixed problem in Patient Viewer Tab Cognos ADT2 where the copy button in the service area would give an error for the Visit Admit Dttm.

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

• Cleaned out and deleted
  • Patient Viewer Tab Cognos ADT', deleted subform Cognos_sub_Cognos
  • forms and queries related to the old Cognos Admitter and Cognos Discharger: form Cognos Admitter, Cognos_Admitter_FormQuery query, Cognos_Admit_filter table, Cognos_Discharger_FormQuery, Cognos Discharger
  • Stopped import of original Cognos Data

2021-01-13

rolled out Ttenbergen 22:21, 2021 January 13 (CST)

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

• updated query check_previous_location_vs_service_inconsistent to deal with new possible combinations of Previous Location ICU and Previous Service at STB that would have previously not been allowed.
• changed how CSS determines which previous record to copy in certain peach + scenarios; if there was a record without an arrive dttm, and also an older record with an arrive dttm, then it would previously copy the older record even if that had been logically deleted and therefore had no names/PHIN etc
• updated Cognos2 UnitStarter query which wasn't listing any records; had excluded things wrong
• updated S ICD10 APACHE Dx patterns table; some edge cases were not listing in correctly but now do

2021-01-12

rolled out Ttenbergen 10:11, 2021 January 12 (CST)

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

• updated query check_previous_location_vs_service_inconsistent to deal with new possible combinations of Previous Location ICU and Previous Service at STB that would have previously not been allowed.

2021-01-07

rolled out Ttenbergen

Changes collectors need to know about:

• Changed L_CCI_Picklist_subform#Duplicator_.28the_.222x.22_button.29 x2 button on Patient Viewer Tab CCI Pick to set new date = old date + 1 instead of blank. This is primarily to simplify serial TISS entries
• reduced how often the ADL checker runs, so it doesn't run all the time but only when the checkbox is checked.

2021-01-06-3

rolled out Ttenbergen 22:12, 2021 January 6 (CST)

Changes collectors need to know about:

• Patient Viewer
  • updated the "Close - With updates" button to properly update LastOpened DtTm field and LastChanged DtTm field
  • updated the "Close - no updates" button to properly update LastOpened DtTm field
• updated Cognos2 No Service or Loc in some time query to also list LastOpened DtTm field

2021-01-06-2

rolled out Ttenbergen 12:09, 2021 January 6 (CST)

Changes collectors need to know about:

• updated CUS (Cognos2_UnitStarter query), it was not excluding it was not excluding records that had been excluded via exclude button, or units excluded via S Cognos Services table

2021-01-06

rolled out Ttenbergen 10:07, 2021 January 6 (CST)

Changes collectors need to know about:

• updated CUS (Cognos2_UnitStarter query), it was not excluding units before or after current profile

2021-01-05

rolled out Ttenbergen 11:22, 2021 January 5 (CST)

Changes collectors need to know about:

• updated CUS (Cognos2_UnitStarter query), it was not excluding locations already entered
• added "Cardiac Sciences" to S previous service table and updated query check_previous_location_vs_service_inconsistent

2021-01-02

rolled out Ttenbergen 20:46, 2021 January 2 (CST)

Changes collectors need to know about:

• added Cognos2_No_Service_or_Loc_in_some_time query (clock button on Main Form to make sure nothing gets lost in Cognos2

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

• NONE

2020-...

• see CCMDB.accdb Change Log 2020