CCMDB.accdb Change Log 2024: Difference between revisions
No edit summary |
No edit summary |
||
| (46 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. --> | __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]]'''. | 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) | |||
'''<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>''' | |||
* 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=== | ===2024-05-23=== | ||
rolled out [[User:Lkaita|Lisa Kaita]] 10:42, 2024 May 23 (CDT) | rolled out [[User:Lkaita|Lisa Kaita]] 10:42, 2024 May 23 (CDT) | ||
| Line 6: | Line 176: | ||
'''<mark>Changes collectors need to know about:</mark>''' | '''<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 | * retired ICD 10 diagnosis Sepsis (SIRS due to infection, without acute organ failure) as per TASK May 22, 2024 | ||
===2024-05-22=== | ===2024-05-22=== | ||
| Line 17: | Line 184: | ||
* 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 | * 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 | * added new HSC service HSC Mental Health / Addictions Centre | ||
===2024-05-15-1=== | ===2024-05-15-1=== | ||
| Line 24: | Line 190: | ||
'''<mark>Changes collectors need to know about:</mark>''' | '''<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 | * retired HSC med boarding locations with old labels ie HSC_H4 if this causes problems with COGNOS will reverse this | ||
===2024-05-15=== | ===2024-05-15=== | ||
| Line 37: | Line 198: | ||
* retired HSC boarding locations children's options, psychiatry options, women's wards if this causes problems with COGNOS will reverse this | * 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 | * retired boarding location SBGH IMCU and E4CAU- no longer active units per Stephanie | ||
===2024-05-08=== | ===2024-05-08=== | ||