CCMDB.accdb Change Log 2024: Difference between revisions

(27 intermediate revisions by 2 users not shown)

Line 1:

__NOTOC__

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-09-17-1===

===2024-12-18===

rolled out [[User:Lkaita|Lisa Kaita]] 10:38, 2024 ~~September 17~~ (CDT)

rolled out [[User:Lkaita|Lisa Kaita]] 20:10, 2024 December 12 (CST)

'''Changes collectors need to know about:'''

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

'''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 [[User:Lkaita|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 [[User:Ttenbergen|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 [[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)

'''Changes collectors need to know about:'''

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

'''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 [[User:Lkaita|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 [[User:Lkaita|Lisa Kaita]] 15:45, 2024 October 24 (CDT)

'''Changes collectors need to know about:'''

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

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

'''Changes collectors need to know about:'''

* [[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)

'''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-09-17===

===2024-10-7-2===

rolled out [[User:Lkaita|Lisa Kaita]] 06:21, 2024 ~~September 17~~ (CDT)

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!

'''Changes collectors need to know about:'''

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

* 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

'''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 [[User:Lkaita|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 [[User:Lkaita|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===

Line 26:

Line 109:

'''Changes collectors need to know about:'''

* added Isavuconazole to the azoles pharm (hover feature)

===2024-09-10===

Line 33:

Line 115:

'''Changes collectors need to know about:'''

* added SBGH-A6ME to the s_COGNOS_units

===2024-09-06===

Line 42:

Line 121:

'''Changes collectors need to know about:'''

* added SBGH-A6ME to the s_Level_of_care table

===2024-09-05===

Line 51:

Line 127:

'''Changes collectors need to know about:'''

* added SBGH-A6ME for new medicine unit

===2024-08-22===

@@ 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-09-17-1===
+===2024-12-18===
-rolled out [[User:Lkaita|Lisa Kaita]] 10:38, 2024 September 17 (CDT)
+rolled out [[User:Lkaita|Lisa Kaita]] 20:10, 2024 December 12 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+*  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>'''
-* added SBGH Palliative Care / B Non Teaching Med to the S_Cognos_services table
+*  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-09-17===
+===2024-10-7-2===
-rolled out [[User:Lkaita|Lisa Kaita]] 06:21, 2024 September 17 (CDT)
+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 Deer lodge to the S_dispo table as a pre-admit patient institution option
+* 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===
@@ Line 26: / Line 109: @@
 '''<mark>Changes collectors need to know about:</mark>'''
 * added Isavuconazole to the azoles pharm (hover feature)
 ===2024-09-10===
@@ Line 33: / Line 115: @@
 '''<mark>Changes collectors need to know about:</mark>'''
 * added SBGH-A6ME to the s_COGNOS_units
 ===2024-09-06===
@@ Line 42: / Line 121: @@
 '''<mark>Changes collectors need to know about:</mark>'''
 * added SBGH-A6ME to the s_Level_of_care table
 ===2024-09-05===
@@ Line 51: / Line 127: @@
 '''<mark>Changes collectors need to know about:</mark>'''
 * added SBGH-A6ME for new medicine unit
 ===2024-08-22===