CCMDB.accdb Change Log 2023: Difference between revisions

(37 intermediate revisions by the same user not shown)

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]]'''.

=== 2023-01-25 ===

=== 2023-05-30 ===

not rolled yet [[User:Ttenbergen|Ttenbergen]] 11:26, 2023 ~~January 25~~ (~~CST~~)

not rolled yet [[User:Ttenbergen|Ttenbergen]] 13:29, 2023 May 24 (CDT)

<!----------------------------

not rolled yet ~~~~

Line 9:

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

*

* Added "MICU under ACCU service" to [[ICUotherService]]

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)

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

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

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

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

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

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

'''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 [[User:Ttenbergen|Ttenbergen]] 10:33, 2023 March 1 (CST)

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

* updated function ApScore_pH() to return 0 rather than Null when receiving a Null input [[User:Ttenbergen|Ttenbergen]] 10:33, 2023 March 1 (CST)

* changed '''Primary Biliary Cirrhosis (PBC)''' to [[Primary Biliary Cholangitis (PBC)]] in [[s_ICD10 table]] [[User:Ttenbergen|Ttenbergen]] 09:52, 2023 March 1 (CST)

=== 2023-02-09 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 18:04, 2023 February 9 (CST)

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

* added send dttm to logging to troubleshoot [[Error "Invalid SQL statment..." when sending]] [[User:Ttenbergen|Ttenbergen]] 18:04, 2023 February 9 (CST)

=== 2023-02-08 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 15:58, 2023 February 9 (CST)

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

* deleted query ''check_CCI_if_no_admin_entries'' and replaced it with [[query check_CCI_Picklist_no_admin_entries]] and [[query check_CCI_Component_no_admin_entries]]

* ran a re-compile and removed code that is no longer required because of previous changes

* updated [[query check_Transfer_DtTm_after_paired_BL_and_before_later_BL]] so it will not allow transfer ready to be equal to ''next'' boarding loc start

* updated options for [[Pre acute living situation field]] in [[S pre acute living situation table]] to no longer allow "Assisted Living" and "Supportive Housing" which have been replaced by "Community Facility with support"

=== 2023-02-02 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 14:52, 2023 February 2 (CST)

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

* re-allocated some STB Med, see [[Processes_around_changing_a_PatientFollow_assignment#2023-02-02]] [[User:Ttenbergen|Ttenbergen]] 14:52, 2023 February 2 (CST)

=== 2023-01-26 ===

rolled out [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 17:13, 2023 January 25 (CST)

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

* added "Weird reason" to [[BedHeldEnd DtTm]]

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

* retired [[Sudden cardiac death (and died)]] as per [[Task Team Meeting - Rolling Agenda and Minutes 2023#ICU Database Task Group Meeting – Jan 11, 2023]]

~~-->~~

=== 2023-01-11 ===

@@ 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]]'''.
-=== 2023-01-25 ===
+=== 2023-05-30 ===
-not rolled yet [[User:Ttenbergen|Ttenbergen]] 11:26, 2023 January 25 (CST)
+not rolled yet [[User:Ttenbergen|Ttenbergen]] 13:29, 2023 May 24 (CDT)
 <!----------------------------
 not rolled yet ~~~~
@@ Line 9: / Line 9: @@
 '''<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):
+* 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 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 10:33, 2023 March 1 (CST)
+Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
+* updated function ApScore_pH() to return 0 rather than Null when receiving a Null input [[User:Ttenbergen|Ttenbergen]] 10:33, 2023 March 1 (CST)
+* changed '''Primary Biliary Cirrhosis (PBC)''' to [[Primary Biliary Cholangitis (PBC)]] in [[s_ICD10 table]] [[User:Ttenbergen|Ttenbergen]] 09:52, 2023 March 1 (CST)
+=== 2023-02-09 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 18:04, 2023 February 9 (CST)
+Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
+* added send dttm to logging to troubleshoot [[Error "Invalid SQL statment..." when sending]] [[User:Ttenbergen|Ttenbergen]] 18:04, 2023 February 9 (CST)
+=== 2023-02-08 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 15:58, 2023 February 9 (CST)
+Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
+* deleted query ''check_CCI_if_no_admin_entries'' and replaced it with [[query check_CCI_Picklist_no_admin_entries]] and [[query check_CCI_Component_no_admin_entries]]
+* ran a re-compile and removed code that is no longer required because of previous changes
+* updated [[query check_Transfer_DtTm_after_paired_BL_and_before_later_BL]] so it will not allow transfer ready to be equal to ''next'' boarding loc start
+* updated options for [[Pre acute living situation field]] in [[S pre acute living situation table]] to no longer allow "Assisted Living" and "Supportive Housing" which have been replaced by "Community Facility with support"
+=== 2023-02-02 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 14:52, 2023 February 2 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+* re-allocated some STB Med, see [[Processes_around_changing_a_PatientFollow_assignment#2023-02-02]] [[User:Ttenbergen|Ttenbergen]] 14:52, 2023 February 2 (CST)
+=== 2023-01-26 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 11:17, 2023 January 26 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+* 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 [[User:Ttenbergen|Ttenbergen]] 17:13, 2023 January 25 (CST)
+'''<mark>Changes collectors need to know about:</mark>'''
+* added "Weird reason" to [[BedHeldEnd DtTm]]
 Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
 * retired [[Sudden cardiac death (and died)]] as per [[Task Team Meeting - Rolling Agenda and Minutes 2023#ICU Database Task Group Meeting – Jan 11, 2023]]
--->
 === 2023-01-11 ===