@@ Line 1: / Line 1: @@
 __NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
 See [[Log (disambiguation)]] for other uses of the term "Log". See the [[:Category: Development Documentation | 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-18===
+rolled out [[User:Lkaita|Lisa Kaita]] 20:10, 2024 December 12 (CST)
-===2024-02-14-2===
+'''<mark>Changes collectors need to know about:</mark>'''
-not rolled out yet [[User:Ttenbergen|Ttenbergen]] 22:13, 2024 February 14 (CST)
+*  added new GH Medicine / Special Training service to the [[S Cognos Services table]] and the [[S tmp table]]
+===2024-12-12===
+rolled out [[User:Lkaita|Lisa Kaita]] 20:10, 2024 December 12 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+*  added new GH Medicine / Homeless Evicted service to the [[S Cognos Services table]] and the [[S tmp table]]
+===2024-12-03===
+rolled out [[User:Lkaita|Lisa Kaita]] 20:20, 2024 December 3 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+*  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 [[User:Ttenbergen|Ttenbergen]] 13:58, 2024 December 2 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+* updated entries for [[s_tmp table]] for [[Project AHC]] so "not entered" can be added manually [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 21:52, 2024 December 1 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added entries for [[s_tmp table]] to start [[Project AHC]] [[User:Ttenbergen|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. [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 14:18, 2024 November 28 (CST)
+** working on [[Query s tmp AHC consistent]] [[User:Ttenbergen|Ttenbergen]] 14:20, 2024 November 28 (CST)
+===2024-11-04===
+rolled out [[User:Lkaita|Lisa Kaita]] 07:15, 2024 November 4 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+*  added new GH Medicine / Community Other service to the [[S Cognos Services table]] and the [[S tmp table]]
+===2024-11-27===
+rolled out [[User:Lkaita|Lisa Kaita]] 14:45, 2024 November 27 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+*  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 [[User:Lkaita|Lisa Kaita]] 15:45, 2024 October 24 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+*  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 [[User:Lkaita|Lisa Kaita]] 13:08, 2024 October 22 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* [[Processes around changing a PatientFollow assignment | 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 [[User:Lkaita|Lisa Kaita]] 06:37, 2024 October 21 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* 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 [[User:Lkaita|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!
+'''<mark>Changes collectors need to know about:</mark>'''
+* added SBGH Palliative Care / B Non Teaching Med to the S_Cognos_services table
+===2024-10-7===
+rolled out [[User:Lkaita|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
+'''<mark>Changes collectors need to know about:</mark>'''
+* added SBGH Palliative Care / B Non Teaching Med to the S_Cognos_services table
+===2024-09-17-1===
+rolled out [[User:Lkaita|Lisa Kaita]] 10:38, 2024 September 17 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added SBGH Palliative Care / B Non Teaching Med to the S_Cognos_services table
+===2024-09-17===
+rolled out [[User:Lkaita|Lisa Kaita]] 06:21, 2024 September 17 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added Deer lodge to the S_dispo table as a pre-admit patient institution option
+===2024-09-12===
+rolled out [[User:Lkaita|Lisa Kaita]] 14:24, 2024 September 12 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added Isavuconazole to the azoles pharm (hover feature)
+===2024-09-10===
+rolled out [[User:Lkaita|Lisa Kaita]] 10:31, 2024 September 10 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added SBGH-A6ME to the s_COGNOS_units
+===2024-09-06===
+rolled out [[User:Lkaita|Lisa Kaita]] 09:19, 2024 September 6 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added SBGH-A6ME to the s_Level_of_care table
+===2024-09-05===
+rolled out [[User:Lkaita|Lisa Kaita]] 07:45, 2024 September 5 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added SBGH-A6ME for new medicine unit
+===2024-08-22===
+rolled out [[User:Lkaita|Lisa Kaita]] 10:09, 2024 August 22 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* 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 [[User:Lkaita|Lisa Kaita]] 10:00, 2024 August 21 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added SBGH Palliative Care / C Non Teaching Med
+===2024-08-12===
+rolled out [[User:Lkaita|Lisa Kaita]] 15:18, 2024 August 12 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+*Added pre admit Inpatient Institution option to Riverview
+===2024-07-03===
+rolled out [[User:Lkaita|Lisa Kaita]] 12:09, 2024 July 2 (CDT)
+*test to see if H3 laptop updates
+===2024-07-02===
+rolled out [[User:Lkaita|Lisa Kaita]] 12:09, 2024 July 2 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added the following new service
+** SBGH Critical Care / Endocrinology
+===2024-05-31===
+rolled out [[User:Lkaita|Lisa Kaita]] 14:14, 2024 May 31 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added the following new services
+** HSC Medicine-ClinAs / Other ALC
+** HSC Child Health / Oncology
+===2024-05-23===
+rolled out [[User:Lkaita|Lisa Kaita]] 10:42, 2024 May 23 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* retired ICD 10 diagnosis Sepsis (SIRS due to infection, without acute organ failure) as per TASK May 22, 2024
+===2024-05-22===
+rolled out [[User:Lkaita|Lisa Kaita]] 20:42, 2024 May 22 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* 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 [[User:Lkaita|Lisa Kaita]] 15:55, 2024 May 15 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* 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 [[User:Lkaita|Lisa Kaita]] 15:34, 2024 May 15 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* 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 [[User:Lkaita|Lisa Kaita]] 10:42, 2024 May 2 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added HSC Medicine/ community other service
+* added Misericordia ward for dispo location
+===2024-05-01-1===
+rolled out [[User:Ttenbergen|Ttenbergen]] 14:34, 2024 May 1 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* 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 [[User:Lkaita|Lisa Kaita]] 09:22, 2024 May 1 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added HSC Medicine/ community other service
+* added Misericordia ward for dispo location
+===2024-04-29===
+Rolled out [[User:Lkaita|Lisa Kaita]] 09:54, 2024 April 29 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+* 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 [[User:Ttenbergen|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 [[User:Ttenbergen|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 [[User:Ttenbergen|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
+'''<mark>Changes collectors need to know about:</mark>'''
+* 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 [[User:Ttenbergen|Ttenbergen]] 09:55, 2024 April 24 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+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 [[User:Lkaita|Lisa Kaita]] 08:14, 2024 April 23 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+*added service SBGH Critical care Nephrology
+===2024-04-19===
+rolled out [[User:Lkaita|Lisa Kaita]] 09:36, 2024 April 19 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+*Changed patient follow numbers 88 and 89 from H8 laptop to H5 laptop
+===2024-04-17===
+rolled out [[User:Lkaita|Lisa Kaita]] 14:30, 2024 April 17 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+*added
+**category potential infection to disorder of salivary glands
+**HSC service- HSC Critical Care / Panel in Process
+===2024-04-09===
+rolled out [[User:Lkaita|Lisa Kaita]] 10:14, 2024 April 9 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+*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 [[User:Lkaita|Lisa Kaita]] 06:56, 2024 March 14 (CDT)
+'''<mark>Changes collectors need to know about:</mark>'''
+*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]] [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 16:59, 2024 March 11 (CDT)
+===2024-03-05===
+rolled out[[User:Lkaita|Lisa Kaita]] 11:51, 2024 March 5 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added the following new services for SBGH
+* SBGH01304422	SBGH Critical Care / GAP
+* SBGH0994630	SBGH Critical Care / C Non Teaching Med
+===2024-02-28===
+rolled out[[User:Lkaita|Lisa Kaita]] 11:52, 2024 February 28 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+* 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 [[User:Lkaita|Lisa Kaita]] 13:40, 2024 February 23 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+* 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 [[User:Lkaita|Lisa Kaita]] 13:16, 2024 February 23 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+* changed SBGH work assignment S4 is now 02-16 and S9 is 87-99, 00, 01
+===2024-02-20-2===
+rolled out [[User:Ttenbergen|Ttenbergen]] 20:31, 2024 February 20 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+* 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 [[User:Lkaita|Lisa Kaita]] 13:57, 2024 February 20 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+* 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 [[User:Ttenbergen|Ttenbergen]] 23:21, 2024 February 14 (CST)
 '''<mark>Changes collectors need to know about:</mark>'''
 *
 Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
-* update to [[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-2===
+rolled out [[User:Ttenbergen|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===

CCMDB.accdb Change Log 2024: Difference between revisions