CCMDB.accdb Change Log 2024

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-03-11

not rolled out yet Ttenbergen 16:52, 2024 March 11 (CDT)

Changes collectors need to know about:

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

• updated Created AdmitDtTm query to show only distinct records. It was showing duplicates when two Service tmp entry records with the same earliest date_var-time_var combination were entered. That's not allowed, but can happen pre-check, and was leading to a duplicate listing in the Patient List Ttenbergen 16:52, 2024 March 11 (CDT)
• confirmed that the bad entry would be caught by query check_tmp_service_or_location_duplicate even for incompletes Ttenbergen 16:59, 2024 March 11 (CDT)

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

• update to query L_ICD10_Charlson_component_points - the query had only considered comorbid and acquired dxs, and ignored admit diagnoses; it now considers all types of diagnoses, consistent with Charlson Comorbidities in ICD10 codes

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:

• changed the default Service/Location in New Pt Serial helper form to blank, since it no longer makes sense to have a default after Change to having each collector collect both programs on the same laptop

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

• deleted Function Default_Service_Location() and eliminated call from form.open for New Pt Serial helper form

2023-...

• see CCMDB.accdb Change Log 2023