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

Change for next version:

2021-01-28-1

not rolled out yet

Changes collectors need to know about:

• updated Gastrointestinal infection (gastroenteritis, colitis), bug NOS to not require a pathogen

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