CCMDB.accdb Change Log 2021: Difference between revisions

Line 27:

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

* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an [[Accept DtTm]], changed it to use first [[Service tmp entry]] instead.

* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an "Accept DtTm", changed it to use first [[Service tmp entry]] instead.

=== 2021-12-02 ===

Line 36:

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

* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an [[Accept DtTm]], changed it to use first [[Service tmp entry]] instead.

* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an "Accept DtTm", changed it to use first [[Service tmp entry]] instead.

=== 2021-11-17 ===

Line 219:

** HSC Critical Care – SICU

* updated ''query check_ER_Delay_not_too_big'' to use [[Boarding Loc]] instead of [[Accept DtTm]] vs [[Arrive DtTm]], and increased warning delay for CC from 2hrs to 8hrs (which it should have been already)

* updated ''query check_ER_Delay_not_too_big'' to use [[Boarding Loc]] instead of "Accept DtTm" vs "Arrive DtTm", and increased warning delay for CC from 2hrs to 8hrs (which it should have been already)

=== 2021-09-07 ===

Line 307:

rolled out [[User:Ttenbergen|Ttenbergen]] 10:41, 2021 July 23 (CDT)

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

* further tweaking on [[query check_minimal_data_set_incomplete]]; this must not check for [[Arrive DtTm]] since that may be empty for pt who is still in ER [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 July 22 (CDT)

* further tweaking on [[query check_minimal_data_set_incomplete]]; this must not check for "Arrive DtTm" since that may be empty for pt who is still in ER [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 July 22 (CDT)

=== 2021-07-21-2 ===

Line 383:

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

* updated [[query check_minimal_data_set_incomplete]] to fix false positive on missing [[Arrive DtTm]] that had been accidentally introduced in [[#2021-06-17]].

* updated [[query check_minimal_data_set_incomplete]] to fix false positive on missing "Arrive DtTm" that had been accidentally introduced in [[#2021-06-17]].

=== 2021-06-20 ===

Line 413:

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

* updated [[query check_CCI_Date]] which was failing with uninformative error when [[Arrive DtTm]] blank

* updated [[query check_CCI_Date]] which was failing with uninformative error when "Arrive DtTm" blank

* updated [[query check_minimal_data_set_incomplete]] to properly trigger for blank [[Arrive DtTm]]

* updated [[query check_minimal_data_set_incomplete]] to properly trigger for blank "Arrive DtTm"

* updated [[query check_ICD10_awaiting_has_Transfer_Ready_DtTm]] to fix scenario where multiple [[Transfer Ready DtTm tmp entry]] would cause false positive

Line 634:

Changes collectors need to know about:

* added [[Drug-induced immunosuppression]] to [[S ICD10 table]]

* tweaked [[query check_CCI_TISS_Pharm_Vasoactive]] to only include profiles with [[Accept DtTm]] after 2020-12-07 ([[Change_to_collect_TISS_data_in_CCI_Picklist#Change_date]]

* tweaked [[query check_CCI_TISS_Pharm_Vasoactive]] to only include profiles with "Accept DtTm" after 2020-12-07 ([[Change_to_collect_TISS_data_in_CCI_Picklist#Change_date]]

=== 2021-04-01 ===

@@ Line 27: / Line 27: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an [[Accept DtTm]], changed it to use first [[Service tmp entry]] instead.
+* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an "Accept DtTm", changed it to use first [[Service tmp entry]] instead.
 === 2021-12-02 ===
@@ Line 36: / Line 36: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an [[Accept DtTm]], changed it to use first [[Service tmp entry]] instead.
+* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an "Accept DtTm", changed it to use first [[Service tmp entry]] instead.
 === 2021-11-17 ===
@@ Line 219: / Line 219: @@
 ** HSC Critical Care – SICU
-* updated ''query check_ER_Delay_not_too_big'' to use [[Boarding Loc]] instead of [[Accept DtTm]] vs [[Arrive DtTm]], and increased warning delay for CC from 2hrs to 8hrs (which it should have been already)
+* updated ''query check_ER_Delay_not_too_big'' to use [[Boarding Loc]] instead of "Accept DtTm" vs "Arrive DtTm", and increased warning delay for CC from 2hrs to 8hrs (which it should have been already)
 === 2021-09-07 ===
@@ Line 307: / Line 307: @@
 rolled out [[User:Ttenbergen|Ttenbergen]] 10:41, 2021 July 23 (CDT)
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* further tweaking on [[query check_minimal_data_set_incomplete]]; this must not check for [[Arrive DtTm]] since that may be empty for pt who is still in ER [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 July 22 (CDT)
+* further tweaking on [[query check_minimal_data_set_incomplete]]; this must not check for "Arrive DtTm" since that may be empty for pt who is still in ER [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 July 22 (CDT)
 === 2021-07-21-2 ===
@@ Line 383: / Line 383: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* updated [[query check_minimal_data_set_incomplete]] to fix false positive on missing [[Arrive DtTm]] that had been accidentally introduced in [[#2021-06-17]].
+* updated [[query check_minimal_data_set_incomplete]] to fix false positive on missing "Arrive DtTm" that had been accidentally introduced in [[#2021-06-17]].
 === 2021-06-20 ===
@@ Line 413: / Line 413: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* updated [[query check_CCI_Date]] which was failing with uninformative error when [[Arrive DtTm]] blank
+* updated [[query check_CCI_Date]] which was failing with uninformative error when "Arrive DtTm" blank
-* updated [[query check_minimal_data_set_incomplete]] to properly trigger for blank [[Arrive DtTm]]
+* updated [[query check_minimal_data_set_incomplete]] to properly trigger for blank "Arrive DtTm"
 * updated [[query check_ICD10_awaiting_has_Transfer_Ready_DtTm]] to fix scenario where multiple [[Transfer Ready DtTm tmp entry]] would cause false positive
@@ Line 634: / Line 634: @@
 Changes collectors need to know about:
 * added [[Drug-induced immunosuppression]] to [[S ICD10 table]]
-* tweaked [[query check_CCI_TISS_Pharm_Vasoactive]] to only include profiles with [[Accept DtTm]] after 2020-12-07 ([[Change_to_collect_TISS_data_in_CCI_Picklist#Change_date]]
+* tweaked [[query check_CCI_TISS_Pharm_Vasoactive]] to only include profiles with "Accept DtTm" after 2020-12-07 ([[Change_to_collect_TISS_data_in_CCI_Picklist#Change_date]]
 === 2021-04-01 ===