CCMDB.accdb Change Log 2021: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 4: Line 4:
== Versions ==
== Versions ==
Change for next version:  
Change for next version:  
=== 2021-09-02 ===
not rolled yet [[User:Ttenbergen|Ttenbergen]] 16:49, 2021 September 1 (CDT)
<!----------------------------
Changes collectors need to know about:
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
------------------------------>


=== 2021-09-01-1 ===
=== 2021-09-01-1 ===
not rolled yet [[User:Ttenbergen|Ttenbergen]] 11:45, 2021 September 1 (CDT)
rolled out [[User:Ttenbergen|Ttenbergen]] 16:49, 2021 September 1 (CDT)


Changes collectors need to know about:
Changes collectors need to know about:
Line 14: Line 22:
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
* updated [[query check_CCI_TISS_NrDays_LT_LOS]] - query had been limited to complete patients but is triggered when “D” is checked, so it never triggered at all
* 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
<!----------------------------
Changes collectors need to know about:
Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
------------------------------>


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

Revision as of 16:49, 2021 September 1

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-09-02

not rolled yet Ttenbergen 16:49, 2021 September 1 (CDT)

2021-09-01-1

rolled out Ttenbergen 16:49, 2021 September 1 (CDT)

Changes collectors need to know about:

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

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:

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

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:

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

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

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

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

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

2021-07-13

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

Changes collectors need to know about:

2021-07-08-1

rolled out Ttenbergen

Changes collectors need to know about:

2021-07-08

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

Changes collectors need to know about:

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

2021-06-28

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

Changes collectors need to know about:

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

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

2021-06-17

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

Changes collectors need to know about:

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:

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

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

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:

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

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

2021-06-02

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

Changes collectors need to know about:

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

2021-05-03-1

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

Changes collectors need to know about:

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

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

2021-04-23

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

Changes collectors need to know about:

2021-04-22

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

Changes collectors need to know about:

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

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

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

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:

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:

2021-04-07

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

Changes collectors need to know about:

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

2021-04-06-1

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

Changes collectors need to know about:

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:

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

2021-03-31

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

Changes collectors need to know about:

2021-03-29

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

Changes collectors need to know about:

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 collectors probably don't care about (incl. bug fixes that should just make things work now):

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:

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:

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:

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

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

2021-02-04-1

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

Changes collectors need to know about:

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

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:

2021-01-28-1

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

Changes collectors need to know about:

Changes collectors need to know about:

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

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

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

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

2021-01-21-4

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

Changes collectors need to know about:

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

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

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:

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

2021-01-20

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

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

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

2021-01-15

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

Changes collectors need to know about:

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:


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

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

2021-01-07

rolled out Ttenbergen

Changes collectors need to know about:

2021-01-06-3

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

Changes collectors need to know about:

2021-01-06-2

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

Changes collectors need to know about:

2021-01-06

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

Changes collectors need to know about:

2021-01-05

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

Changes collectors need to know about:

2021-01-02

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

Changes collectors need to know about:

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

  • NONE

2020-...