CCMDB.accdb Change Log 2023

From CCMDB Wiki
Jump to navigation Jump to search

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.

2023-12-18

not rolled out yet Ttenbergen 10:05, 2023 December 18 (CST)

  • the CCI Picklist form appears to be where the some of the program calls come from...
  • checks might be as well...

Changes collectors need to know about:

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

  • integrated Lisa's changes from #2023-12-14 into test version. Ttenbergen 10:05, 2023 December 18 (CST)
  • changed validation functions to use new admission_program function instead of program function
  • removed program filter from service_location field dropdown
  • commented out all the Apache total functions that don't seem to be used anywhere but require program parameter.
  • changed dropdown in CCI_Picklist form to use admission_program instead of program.

2023-12-14

ROLLED OUT Lisa Kaita 12:48, 2023 December 14 (CST)

Changes collectors probably don't care about:

  • New "HSC Critical Care / Pain" service added

2023-12-05

NOT ROLLED OUT YET Ttenbergen 22:05, 2023 December 5 (CST)

NOT ROLLED OUT YET - but copied up to test location for testing.

Changes collectors need to know about:

  • Sending will now process all tables for all laptops, regardless of program. This may make sending take slightly longer and you will see additional text in the timing log form that were blank before.

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

  • remembered to check VBA for other instances where program() instead of admission_program() is used; also changed the following:
    • Sub PharmCheck()
    • Sub Apache_Yellower()
    • BP_CrossCheck()
    • Function Validate_Creat()
    • Validate_ADL_generic
    • Sub completeness_validation()
    • Sub add_automatic_tmp_entries()
    • Sub Patient_Adder(ID)
    • Sub tb_IPDischargeDisposition_Click()
    • Send_Data() - this one isn't a simple change, will need to review further...
    • updated function program() to throw an error if it is called; it should no longer be called from anywhere, but if it does, this will find it. - then reverted this because the Cognos functions must use this until we change to combined coding.

2023-11-25

NOT ROLLED OUT YET Ttenbergen 09:29, 2023 November 25 (CST)

NOT ROLLED OUT YET - but copied up to test location for testing.

Changes collectors need to know about:

  • Nothing specific but let me know if you get false positives with cross checks.

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

2023-11-23

Not rolled out yet Ttenbergen 17:28, 2023 November 5 (CST)

NOT ROLLED OUT YET - but copied up for Lisa to test.

Changes collectors need to know about:

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

2023-11-01

rolled out Lisa Kaita 10:56, 2023 November 1 (CDT)

Changes collectors need to know about:

2023-09-28

rolled out Haubel 12:25, 2023 September 28 (CDT)

Changes collectors need to know about:

2023-09-27

rolled out Lisa Kaita 15:28, 2023 September 27 (CDT)

Changes collectors need to know about:

2023-08-31

rolled out Ttenbergen 11:14, 2023 August 31 (CDT)

Changes collectors need to know about:

2023-08-16-1

rolled out Ttenbergen 15:27, 2023 August 16 (CDT)

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

2023-08-16

rolled out Ttenbergen 09:49, 2023 August 16 (CDT)

Changes collectors need to know about:

2023-08-09

rolled out Ttenbergen 11:37, 2023 August 9 (CDT)

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

2023-08-07

rolled out Ttenbergen 09:00, 2023 August 7 (CDT)

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

2023-07-27

rolled out Ttenbergen 11:42, 2023 July 27 (CDT)

Changes collectors need to know about:

2023-07-26

rolled out Ttenbergen 14:19, 2023 July 26 (CDT)

Changes collectors need to know about:

  • EuroSCORE II: added "excluded" entry; see instruction page for use

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

2023-07-12

rolled out Ttenbergen 11:32, 2023 July 12 (CDT)

Changes collectors need to know about:

2023-07-06

rolled out Ttenbergen 14:57, 2023 July 6 (CDT)

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

2023-06-28

rolled out Ttenbergen 15:43, 2023 June 28 (CDT)

Changes collectors need to know about:

2023-06-27

rolled out Ttenbergen 11:10, 2023 June 27 (CDT)

Changes collectors need to know about:

2023-05-31

rolled out Ttenbergen 14:11, 2023 June 5 (CDT)

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

  • inactivated the HSC options for ICUotherService since we have not entered this there since we decided to break those records apart by service, not just program.

2023-05-30

rolled out Ttenbergen 10:52, 2023 May 31 (CDT)

Changes collectors need to know about:

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

2023-05-24-1

rolled out Ttenbergen 13:29, 2023 May 24 (CDT) Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

2023-05-23

rolled out Ttenbergen 09:58, 2023 May 24 (CDT)

Changes collectors need to know about:

2023-05-04

rolled out Ttenbergen 10:17, 2023 May 4 (CDT)

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

2023-05-03-3

rolled out Ttenbergen 13:10, 2023 May 3 (CDT)

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

2023-05-03-2

rolled out Ttenbergen 11:50, 2023 May 3 (CDT)

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

2023-05-03

rolled out Ttenbergen 09:38, 2023 May 3 (CDT)

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

2023-05-02

rolled out Ttenbergen 07:56, 2023 May 3 (CDT)

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

2023-04-27

rolled out Ttenbergen 12:05, 2023 May 2 (CDT)

Changes collectors need to know about:

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

2023-04-18

rolled out Ttenbergen 12:03, 2023 April 18 (CDT)

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

  • updated functions that import Cognos data to give option to import from desktop file if import from email fails

2023-04-05-2

rolled out Ttenbergen 21:22, 2023 April 5 (CDT)

Changes collectors need to know about:

2023-04-05-1

rolled out Ttenbergen 17:31, 2023 April 5 (CDT)

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

2023-04-05

rolled out Ttenbergen 13:47, 2023 April 5 (CDT)

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

2023-03-02

rolled out Ttenbergen 16:24, 2023 March 2 (CST)

Changes collectors need to know about:

  • in s_dispo table, changed "GH-ER" to " GH - ER" which makes it consistent with how it's named at other locations, and which moves it to the top of how these are sorted in the previous location and other fields.

2023-02-09-1

rolled out Ttenbergen 10:33, 2023 March 1 (CST)

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

2023-02-09

rolled out Ttenbergen 18:04, 2023 February 9 (CST)

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

2023-02-08

rolled out Ttenbergen 15:58, 2023 February 9 (CST)

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

2023-02-02

rolled out Ttenbergen 14:52, 2023 February 2 (CST)

Changes collectors need to know about:

2023-01-26

rolled out Ttenbergen 11:17, 2023 January 26 (CST)

Changes collectors need to know about:

  • re-activated the HSC Critical Care Service entries for Service tmp entry that had been inactivated in the past since we will now collect these verbatim

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

  • updated Charlson Comorbidities in ICD10 codes according to Allan's email from Dec 1; this should have been identical to what I have but somehow still had differences; the specific changes are a bit messy and there will likely be further updates since the list was incomplete.

2023-01-25

rolled out Ttenbergen 17:13, 2023 January 25 (CST)

Changes collectors need to know about:

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

2023-01-11

rolled out Ttenbergen 11:26, 2023 January 25 (CST)

Changes collectors need to know about:

  • added HSC ICU related Cognos services to s_tmp table to allow entry as it is in Cognos, rather than changed version; more may need to be added, let me know

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

  • updated S_laptops table to not allow duplicate entries. Three lines had accidentally been added that were causing records to not show up in CSS. Ttenbergen 11:26, 2023 January 25 (CST)
  • changed the dropdown for the Previous Location to list the local entries first.
  • updated entry for Selkirk Mental Hospital in s_dispo table to replace the nulls in its site etc fields with empty strings like all the other entries have
  • updated the GH-ambulatory care to GH ambulatory care (- to space) so it sorts below the options collectors actually use
  • updated created_AdmitDtTm query so it won't crash when there are nulls in all three dates
  • disabled query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER

2023-01-05

rolled out Ttenbergen 11:04, 2023 January 5 (CST)

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

  • updated S laptops table to not allow duplicate entries. Three lines had accidentally been added that were causing records to not show up in CSS. Ttenbergen 11:04, 2023 January 5 (CST)

2022-...