CCMDB.accdb Change Log 2023: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(21 intermediate revisions by the same user not shown)
Line 2: Line 2:
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]]'''.  


=== 2023-03-01 ===
=== 2023-05-30 ===
not rolled yet [[User:Ttenbergen|Ttenbergen]] 10:33, 2023 March 1 (CST)
not rolled yet [[User:Ttenbergen|Ttenbergen]] 13:29, 2023 May 24 (CDT)
<!----------------------------
<!----------------------------
not rolled yet ~~~~
not rolled yet ~~~~
Line 9: Line 9:


'''<mark>Changes collectors need to know about:</mark>'''
'''<mark>Changes collectors need to know about:</mark>'''
*  
* Added "MICU under ACCU service" to [[ICUotherService]]


Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
*  
* turned off [[query check_CCI_TISS_time_means_must_be_two]] because it caused too many false positives


-->
-->
=== 2023-05-24-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:29, 2023 May 24 (CDT)
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* tweak to [[Query check ICD10 ESRD and AKI only if transplant]]
=== 2023-05-23 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:58, 2023 May 24 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* implemented [[Query check_ICD10_ESRD_and_AKI_only_if_transplant]]
=== 2023-05-04 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:17, 2023 May 4 (CDT)
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* correction to [[s_ICD10_Charlson_Como_patterns table]] to use ranges that exclude the end
* rolling out to make sure Julie and I are working off the same version of this
=== 2023-05-03-3 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:10, 2023 May 3 (CDT)
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* tweak to [[Query check tmp BedHeld]], it was looking for [[dispo]] = "AWOL" but needed "AMA (left against medical advice)"
=== 2023-05-03-2 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:50, 2023 May 3 (CDT)
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* tweaked [[Query check_ICD10_trach_dxs_consistent]] as per old request
* tweaked [[query check_ICD10_CLI_vs_CCI_CentralLine]] to only check cc patients
=== 2023-05-03 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 09:38, 2023 May 3 (CDT)
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* tweak to [[query check_ICD10_CLI_vs_CCI_CentralLine]]
=== 2023-05-02 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 07:56, 2023 May 3 (CDT)
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* re-imported [[s_CCI_Categories_Collection_Mode table]] since the update I rolled out was actually missing things, see [[s_CCI_Categories_Collection_Mode table]]
* correction to [[query check_tmp_BedHeld]], which wasn't working right for "AMA (Protocol)"
=== 2023-04-27 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 12:05, 2023 May 2 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* added [[query check_tmp_BedHeld]]
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* removed query "z_ComoAdmAcqu_Primary_List" that had been built for [[Controlling Dx Type for ICD10 codes]]
=== 2023-04-18 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 12:03, 2023 April 18 (CDT)
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated functions that import Cognos data to give option to import from desktop file if import from email fails
=== 2023-04-05-2 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 21:22, 2023 April 5 (CDT)
'''<mark>Changes collectors need to know about:</mark>'''
* Changed the name of "Transfusion of FFP" to [[Transfusion of plasma products]] in [[S CCI Picklist table]]
=== 2023-04-05-1 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 17:31, 2023 April 5 (CDT)
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* updated code for [[(T) Brain's Meninges, Dura, Subarachnoid, Ventricles]]: it was "1.AA  " with two spaces, and is now just "1.AA" as it should be.
=== 2023-04-05 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:47, 2023 April 5 (CDT)
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* [[S dispo table]]: edited record for [[GH-Recovery Room]] to remove the categorizations and change it from RR to ICU
=== 2023-03-02 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:24, 2023 March 2 (CST)
'''<mark>Changes collectors need to know about:</mark>'''
* in [[s_dispo table]], changed "GH-ER" to " GH - ER" which makes it consistent with how it's named at other locations, and which moves it to the top of how these are sorted in the previous location and other fields.


=== 2023-02-09-1 ===
=== 2023-02-09-1 ===

Revision as of 13:56, 2023 May 30

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.

2023-05-30

not rolled yet Ttenbergen 13:29, 2023 May 24 (CDT)

2023-05-24-1

rolled out Ttenbergen 13:29, 2023 May 24 (CDT) Changes collectors probably don't care about (incl. bug fixes that should just make things work now):

2023-05-23

rolled out Ttenbergen 09:58, 2023 May 24 (CDT)

Changes collectors need to know about:

2023-05-04

rolled out Ttenbergen 10:17, 2023 May 4 (CDT)

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

2023-05-03-3

rolled out Ttenbergen 13:10, 2023 May 3 (CDT)

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

2023-05-03-2

rolled out Ttenbergen 11:50, 2023 May 3 (CDT)

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

2023-05-03

rolled out Ttenbergen 09:38, 2023 May 3 (CDT)

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

2023-05-02

rolled out Ttenbergen 07:56, 2023 May 3 (CDT)

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

2023-04-27

rolled out Ttenbergen 12:05, 2023 May 2 (CDT)

Changes collectors need to know about:

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

2023-04-18

rolled out Ttenbergen 12:03, 2023 April 18 (CDT)

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

  • updated functions that import Cognos data to give option to import from desktop file if import from email fails

2023-04-05-2

rolled out Ttenbergen 21:22, 2023 April 5 (CDT)

Changes collectors need to know about:

2023-04-05-1

rolled out Ttenbergen 17:31, 2023 April 5 (CDT)

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

2023-04-05

rolled out Ttenbergen 13:47, 2023 April 5 (CDT)

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

2023-03-02

rolled out Ttenbergen 16:24, 2023 March 2 (CST)

Changes collectors need to know about:

  • in s_dispo table, changed "GH-ER" to " GH - ER" which makes it consistent with how it's named at other locations, and which moves it to the top of how these are sorted in the previous location and other fields.

2023-02-09-1

rolled out Ttenbergen 10:33, 2023 March 1 (CST)

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

2023-02-09

rolled out Ttenbergen 18:04, 2023 February 9 (CST)

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

2023-02-08

rolled out Ttenbergen 15:58, 2023 February 9 (CST)

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

2023-02-02

rolled out Ttenbergen 14:52, 2023 February 2 (CST)

Changes collectors need to know about:

2023-01-26

rolled out Ttenbergen 11:17, 2023 January 26 (CST)

Changes collectors need to know about:

  • re-activated the HSC Critical Care Service entries for Service tmp entry that had been inactivated in the past since we will now collect these verbatim

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

  • updated Charlson Comorbidities in ICD10 codes according to Allan's email from Dec 1; this should have been identical to what I have but somehow still had differences; the specific changes are a bit messy and there will likely be further updates since the list was incomplete.

2023-01-25

rolled out Ttenbergen 17:13, 2023 January 25 (CST)

Changes collectors need to know about:

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

2023-01-11

rolled out Ttenbergen 11:26, 2023 January 25 (CST)

Changes collectors need to know about:

  • added HSC ICU related Cognos services to s_tmp table to allow entry as it is in Cognos, rather than changed version; more may need to be added, let me know

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

  • updated S_laptops table to not allow duplicate entries. Three lines had accidentally been added that were causing records to not show up in CSS. Ttenbergen 11:26, 2023 January 25 (CST)
  • changed the dropdown for the Previous Location to list the local entries first.
  • updated entry for Selkirk Mental Hospital in s_dispo table to replace the nulls in its site etc fields with empty strings like all the other entries have
  • updated the GH-ambulatory care to GH ambulatory care (- to space) so it sorts below the options collectors actually use
  • updated created_AdmitDtTm query so it won't crash when there are nulls in all three dates
  • disabled query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER

2023-01-05

rolled out Ttenbergen 11:04, 2023 January 5 (CST)

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

  • updated S laptops table to not allow duplicate entries. Three lines had accidentally been added that were causing records to not show up in CSS. Ttenbergen 11:04, 2023 January 5 (CST)

2022-...