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-12-12

rolled out Lisa Kaita 20:10, 2024 December 12 (CST)

Changes collectors need to know about:

• added new GH Medicine / Homeless Evicted service to the S Cognos Services table and the S tmp table

2024-12-03

rolled out Lisa Kaita 20:20, 2024 December 3 (CST)

Changes collectors need to know about:

• added new GH Medicine / Panel Appr PCH and GH Medicine / Rehab Bed services to the S Cognos Services table and the S tmp table

2024-12-02-1

rolled out Ttenbergen 13:58, 2024 December 2 (CST)

Changes collectors need to know about:

• updated entries for s_tmp table for Project AHC so "not entered" can be added manually Ttenbergen 08:54, 2024 December 2 (CST)
• more work on Query s_tmp_AHC_consistent
  • Medicine records admitted after the start and before the end of project have lines required for the project
  • The lines must not be ""not entered"
  • If there is a date it has to be after or at admission and before discharge.

2024-12-01

rolled out Ttenbergen 21:52, 2024 December 1 (CST)

Changes collectors need to know about:

• added entries for s_tmp table to start Project AHC Ttenbergen 21:52, 2024 December 1 (CST)

2024-11-29-TEST

uploaded as ccmdb_test.accdb; for those who are testing, pls copy it down manually to test. Ttenbergen 16:39, 2024 November 28 (CST)

• adding a test version for now for testing Project AHC

• added Project AHC
  • records will be added for new medicine admissions, data can be entered, Lisa agreed to organize some testing Ttenbergen 14:18, 2024 November 28 (CST)
  • working on Query s tmp AHC consistent Ttenbergen 14:20, 2024 November 28 (CST)

2024-11-04

rolled out Lisa Kaita 07:15, 2024 November 4 (CST)

Changes collectors need to know about:

• added new GH Medicine / Community Other service to the S Cognos Services table and the S tmp table

2024-11-27

rolled out Lisa Kaita 14:45, 2024 November 27 (CST)

Changes collectors need to know about:

• added new GH Medicine /Panel Appr other, GH medicine/Panel in Process, GH medicine /Home care, GH medicine/Panel Appr CC, GH medicine/Housing other S Cognos Services table and the S tmp table
• added HSC Womens Health/CIVP service to S Cognos Services table but excluded it as this is a service for Women's only

2024-10-24

rolled out Lisa Kaita 15:45, 2024 October 24 (CDT)

Changes collectors need to know about:

• A28.9 Zoonotic bacterial disease (directly transmitted from animal) removed category Infection with implied pathogen as it can have many diseases with different pathogens linked with this, update s_ICD10_Categories table in CCMDB

• For EuroSCORE II added Dr Moran Muller to dropdown

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
  • added to S Cognos Services table:
    • SBGH Palliative Care / C Non Teaching Med
    • SBGH Critical Care / Endocrinology
  • updated s_dispo table
    • Riverview "inpatient" column to "checked"

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

• fixed STEMI annotation in s_ICD10 table, had wrongly added it to Myocardial infarction, acute (AMI), NOS, moved it to Myocardial infarction (STEMI), acute (AMI), transmural (Q-wave) instead.

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:

• updated hover for carbapenems to be consistent with Template:Carbapenems
• did not re-apply #2024-05-01 because those changes appeared to already be there

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

• went back to #2024-04-25 because newer versions had login-on-exit error
• re-applied:
  • change to query check_ICD10_trach_create_but_no_TISS
  • changed (added STEMI):
    • "Myocardial infarction, acute (AMI), transmural (Q-wave)" to Myocardial infarction (STEMI), acute (AMI), transmural (Q-wave)
    • "Myocardial infarction (NSTEMI), acute (AMI), subendocardial/non-transmural (non-Q-wave)" to Myocardial infarction (NSTEMI), acute (AMI), subendocardial/non-transmural (non-Q-wave)

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:

• changed (added STEMI):
  • "Myocardial infarction, acute (AMI), transmural (Q-wave)" to Myocardial infarction (STEMI), acute (AMI), transmural (Q-wave)
  • "Myocardial infarction (NSTEMI), acute (AMI), subendocardial/non-transmural (non-Q-wave)" to Myocardial infarction (NSTEMI), acute (AMI), subendocardial/non-transmural (non-Q-wave)

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

• query check_ICD10_trach_create_but_no_TISS - updated so this runs only for CC

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

• query check_CCI_each_count_vs_LOS - fixed typo in VBA that calls this query, and which was causing errors for collectors

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

• query check_CCI_each_count_vs_LOS
  • renamed from the started but not implemented query "check_CCI_CXR_vs_LOS"
  • implemented the list of CCI codes Julie provided

2024-04-24

Rolled out by Lisa

Changes collectors need to know about:

• changed (added STEMI):
  • "Myocardial infarction, acute (AMI), transmural (Q-wave)" to Myocardial infarction (STEMI), acute (AMI), transmural (Q-wave)
  • "Myocardial infarction (NSTEMI), acute (AMI), subendocardial/non-transmural (non-Q-wave)" to Myocardial infarction (NSTEMI), acute (AMI), subendocardial/non-transmural (non-Q-wave)

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

• updated query check_CCI_ICD10_Dialysis_no_Dx - changed from Psychiatric drug NOS, adverse effect to Psychiatric drug NOS, overdose/toxicity

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

• 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