CCMDB.accdb Change Log 2024

From CCMDB Wiki
Revision as of 12:08, 22 October 2024 by Lkaita (talk | contribs)
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.

2024-10-22

rolled out Lisa Kaita 13:08, 2024 October 22 (CDT)


Changes collectors need to know about:

  • changed work assignment for HSC H4 and H7 laptops

Moved 42,43,44 to H7 laptop beginning Oct 24, 2024



2024-10-21

rolled out Lisa Kaita 06:37, 2024 October 21 (CDT)


Changes collectors need to know about:

  • added HSC Critical Care / Radiation and HSC Surgery / Home Care to the S_Cognos_services table and the Service tmp



2024-10-7-2

rolled out Lisa Kaita 18:18, 2024 October 7 (CDT)

  • reverted to a previous version Sept 12, 2024, applied the change below, as CFE and collectors had ++error messages
  • version 10-7-1 forgot to change the version and the service change did not work so reapplied!

Changes collectors need to know about:

  • added SBGH Palliative Care / B Non Teaching Med to the S_Cognos_services table



2024-10-7

rolled out Lisa Kaita 18:05, 2024 October 7 (CDT)

  • reverted to a previous version Sept 17, 2024, applied the change below, as CFE and collectors had ++error messages

Changes collectors need to know about:

  • added SBGH Palliative Care / B Non Teaching Med to the S_Cognos_services table



2024-09-17-1

rolled out Lisa Kaita 10:38, 2024 September 17 (CDT)

Changes collectors need to know about:

  • added SBGH Palliative Care / B Non Teaching Med to the S_Cognos_services table



2024-09-17

rolled out Lisa Kaita 06:21, 2024 September 17 (CDT)

Changes collectors need to know about:

  • added Deer lodge to the S_dispo table as a pre-admit patient institution option




2024-09-12

rolled out Lisa Kaita 14:24, 2024 September 12 (CDT)

Changes collectors need to know about:

  • added Isavuconazole to the azoles pharm (hover feature)


2024-09-10

rolled out Lisa Kaita 10:31, 2024 September 10 (CDT)

Changes collectors need to know about:

  • added SBGH-A6ME to the s_COGNOS_units



2024-09-06

rolled out Lisa Kaita 09:19, 2024 September 6 (CDT)

Changes collectors need to know about:

  • added SBGH-A6ME to the s_Level_of_care table



2024-09-05

rolled out Lisa Kaita 07:45, 2024 September 5 (CDT)

Changes collectors need to know about:

  • added SBGH-A6ME for new medicine unit


2024-08-22

rolled out Lisa Kaita 10:09, 2024 August 22 (CDT)

Changes collectors need to know about:

  • pulled old pre_2024-07-02 version and re-applied changes since

2024-08-21

rolled out Lisa Kaita 10:00, 2024 August 21 (CDT)

Changes collectors need to know about:

  • added SBGH Palliative Care / C Non Teaching Med

2024-08-12

rolled out Lisa Kaita 15:18, 2024 August 12 (CDT)

Changes collectors need to know about:

  • Added pre admit Inpatient Institution option to Riverview

2024-07-03

rolled out Lisa Kaita 12:09, 2024 July 2 (CDT)

  • test to see if H3 laptop updates

2024-07-02

rolled out Lisa Kaita 12:09, 2024 July 2 (CDT)

Changes collectors need to know about:

  • added the following new service
    • SBGH Critical Care / Endocrinology

2024-05-31

rolled out Lisa Kaita 14:14, 2024 May 31 (CDT)

Changes collectors need to know about:

  • added the following new services
    • HSC Medicine-ClinAs / Other ALC
    • HSC Child Health / Oncology

2024-05-23

rolled out Lisa Kaita 10:42, 2024 May 23 (CDT)

Changes collectors need to know about:

  • retired ICD 10 diagnosis Sepsis (SIRS due to infection, without acute organ failure) as per TASK May 22, 2024

2024-05-22

rolled out Lisa Kaita 20:42, 2024 May 22 (CDT)

Changes collectors need to know about:

  • retired HSC med boarding locations for temp boarding locations bronchoscopy, endoscopy, central lines CS 104 adlt surgery etc
  • deactivated s_dispo entires for Lac Du Bonnet ER, OR, recovery, ward as they do not have a hospital, kept Lac du bonnet unknown/other
  • added new HSC service HSC Mental Health / Addictions Centre

2024-05-15-1

rolled out Lisa Kaita 15:55, 2024 May 15 (CDT)

Changes collectors need to know about:

  • retired HSC med boarding locations with old labels ie HSC_H4 if this causes problems with COGNOS will reverse this

2024-05-15

rolled out Lisa Kaita 15:34, 2024 May 15 (CDT)

Changes collectors need to know about:

  • retired VIC TCU from pre-admit inpt institution, prev location and dispo
  • retired HSC boarding locations children's options, psychiatry options, women's wards if this causes problems with COGNOS will reverse this
  • retired boarding location SBGH IMCU and E4CAU- no longer active units per Stephanie

2024-05-08

rolled out 10:53, 2024 May 8 (CDT) Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

2024-05-02

rolled out Lisa Kaita 10:42, 2024 May 2 (CDT)

Changes collectors need to know about:

  • added HSC Medicine/ community other service
  • added Misericordia ward for dispo location

2024-05-01-1

rolled out Ttenbergen 14:34, 2024 May 1 (CDT)

Changes collectors need to know about:

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

2024-05-01

Rolled out Lisa Kaita 09:22, 2024 May 1 (CDT)

Changes collectors need to know about:

  • added HSC Medicine/ community other service
  • added Misericordia ward for dispo location

2024-04-29

Rolled out Lisa Kaita 09:54, 2024 April 29 (CDT)

Changes collectors need to know about:

2024-04-25-1

rolled out Ttenbergen 15:08, 2024 April 25 (CDT)

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

2024-04-25

rolled out Ttenbergen 13:28, 2024 April 25 (CDT)

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

2024-04-24-1

rolled out Ttenbergen 16:51, 2024 April 24 (CDT)

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

2024-04-24

Rolled out by Lisa

Changes collectors need to know about:

2024-04-23-1

rolled out Ttenbergen 09:55, 2024 April 24 (CDT)

Changes collectors need to know about:

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

2024-04-23

rolled out Lisa Kaita 08:14, 2024 April 23 (CDT)

Changes collectors need to know about:

  • added service SBGH Critical care Nephrology

2024-04-19

rolled out Lisa Kaita 09:36, 2024 April 19 (CDT)

Changes collectors need to know about:

  • Changed patient follow numbers 88 and 89 from H8 laptop to H5 laptop

2024-04-17

rolled out Lisa Kaita 14:30, 2024 April 17 (CDT)

Changes collectors need to know about:

  • added
    • category potential infection to disorder of salivary glands
    • HSC service- HSC Critical Care / Panel in Process

2024-04-09

rolled out Lisa Kaita 10:14, 2024 April 9 (CDT)

Changes collectors need to know about:

  • added new boarding loc
    • SBGH-A6CM for ICU as there was pt that boarded there while waiting for an ACCU bed

2024-03-14

rolled out Lisa Kaita 06:56, 2024 March 14 (CDT)

Changes collectors need to know about:

  • added new services
    • SBGH Critical Care / Rheumatology
    • SBGH Internal Med / Rheumatology
    • HSC Medicine/Panel Appr CC

2024-03-11

(was rolled out)

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

2024-03-05

rolled outLisa Kaita 11:51, 2024 March 5 (CST)

Changes collectors need to know about:

  • added the following new services for SBGH
  • SBGH01304422 SBGH Critical Care / GAP
  • SBGH0994630 SBGH Critical Care / C Non Teaching Med

2024-02-28

rolled outLisa Kaita 11:52, 2024 February 28 (CST)

Changes collectors need to know about:

  • Starting March 1, 2024 HSC work assignment H3 is now 00-11 and H4 is 30-44, 12,13,14

2024-02-23-1

rolled out Lisa Kaita 13:40, 2024 February 23 (CST)

Changes collectors need to know about:

  • changed SBGH work assignment S4 is now 02-16 and S9 is 87-99, 00, 01
  • changed S_PatientFollow_distribution table to correct end date

2024-02-23

rolled out Lisa Kaita 13:16, 2024 February 23 (CST)

Changes collectors need to know about:

  • changed SBGH work assignment S4 is now 02-16 and S9 is 87-99, 00, 01

2024-02-20-2

rolled out Ttenbergen 20:31, 2024 February 20 (CST)

Changes collectors need to know about:

  • applied conditional formatting to px date one more time, three time's a charm... 🙄

changes collectors probably don't care about:

  • fixed "HSC Womens Health / Acute Gynecology" entry

2024-02-20

rolled out Lisa Kaita 13:57, 2024 February 20 (CST)

Changes collectors need to know about:

  • Added following new services and unit
  • SBGH0324949 SBGH Critical Care / B Non Teaching Med
  • SBGH0691170 SBGH Palliative Care / A Non Teaching Med
  • HSC-RR RS105 Resp

2024-02-15

not rolled out yet Ttenbergen 23:21, 2024 February 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):

2024-02-14-2

rolled out Ttenbergen 23:21, 2024 February 14 (CST)

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

2024-02-14

rolled out Ttenbergen 22:13, 2024 February 14 (CST) Changes collectors need to know about:

  • formatting change to Picklist tab to make date continuity or duplication more easily visible

2024-01-26

rolled out Lisa Kaita 08:23, 2024 January 26 (CST)[

Changes collectors need to know about:

  • added new services
  • HSC Mental Health / ASU
  • HSC Womens Health / Acute Gynecology
  • SBGH Critical Care / A Non Teaching Med
  • SBGH Palliative Care / GAP

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

2024-01-25-2

rolled out Ttenbergen 11:03, 2024 January 25 (CST)

Changes collectors need to know about:

  • tweaked the alignment of checkboxes for tabs completion so they line up better with the tabs Ttenbergen 11:03, 2024 January 25 (CST)

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

2024-01-25-1

rolled out Lisa Kaita 10:09, 2024 January 25 (CST)

Changes collectors need to know about:

  • went back to version 2024-01-15 to eliminate the password on exit problem; re-applied changes

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

  • confirmed that the new services and the CCI change for Prone positioning were present. emailed Lisa to confirm new setting
  • added function GetSQLFromQuery to help find code in queries
  • changed all entries in s_CCI_Categories_Collection_Mode table that were "CCI collect TISS" to "CCI collect each day"

2024-01-19 and 3

rolled out Lisa Kaita 13:06, 2024 January 19 (CST)

Changes collectors need to know about:

  • Added new services for SBGH Critical Care / A Non Teaching Med and HSC Womens Health / Acute Gynecology

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

2024-01-15-2 and 3

rolled out Lisa Kaita 14:14, 2024 January 15 (CST)

Changes collectors need to know about:

  • Changed the CCI collection mode for Prone positioning from collect count days to collect each day

2024-01-15-1

rolled out Ttenbergen 11:07, 2024 January 15 (CST)

Changes collectors need to know about:

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

  • Updated function Patient_Adder(ID) to set RecordStatus "Incomplete" uppercase rather than lowercase.

2024-01-15

rolled out Lisa Kaita 08:42, 2024 January 15 (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 duplicate SBGH internal medicine / B Non Teaching Med in S_Service

2024-01-12

rolled out Lisa Kaita 08:42, 2024 January 12 (CST)

Changes collectors need to know about:

  • Added new internal medicine non teaching services:
  • SBGH Internal Med / A Non Teaching Med
  • SBGH Internal Med / B Non Teaching Med
  • SBGH Internal Med / C Non Teaching Med
  • SBGH Internal Med / GAP

2024-01-11

rolled out Lisa Kaita 10:34, 2024 January 11 (CST)

Changes collectors need to know about:

  • Added new options for TMP ICUotherService for SBGH
  • MICU under MICU service
  • CICU under CICU service
  • ACCU under ACCU service

2023-01-07

rolled out Ttenbergen 10:58, 2024 January 8 (CST)

Changes collectors need to know about:

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

  • updated Sub email_data_available() and Sub email_noReport() to no longer send to DC Med
  • updated the record copier from ADT2 tab to properly refresh hiding/showing of CC vs Med interface elements

2023-01-06

rolled out Lisa Kaita 20:47, 2024 January 6 (CST)

Changes collectors need to know about:

  • added color for service locations HSC_MICU, HSC_SICU,HSC_IICU, GGH_MICU, GGH_CC, SBGH_ACCU, SBGH_MICU, SBGH_CICU in patient list

2024-01-02

rolled out Ttenbergen 10:49, 2024 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):

2023-...

Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Change_Log_2024&oldid=161908"