CCMDB.accdb Change Log 2025: Difference between revisions

Line 10:

===2025-01-08===

~~not~~ rolled out ~~yet~~

rolled out [[User:Ttenbergen|Ttenbergen]] 15:06, 8 January 2025 (CST)

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

* soft checks like [[query check_CCI_each_count_vs_LOS]] were being triggered last in the error checks, meaning that they would overrule hard checks that also triggered.

* updated [[query check_tmp_BedHeld]] to also flag if record has [[Dispo]]="AMA (left against medical advice)" but no [[BedHeldEnd DtTm]] entry

* this would have affected queries that, on this date, matched the query underlying the following list (data on wiki changes so if you look in the future this might be different)

* soft checks like [[query check_CCI_each_count_vs_LOS]] were being triggered last in the error checks, meaning that they would overrule hard checks that also triggered.

** changed the order of cross checks in Public Sub Dx_Checker() to do soft ones first so that hard ones would not be overwritten by soft ones

** this would have affected queries that, on this date, matched the query underlying the following list (data on wiki changes so if you look in the future this might be different)

{{#cargo_query:

tables=DataIntegrityChecks

Line 21:

Line 23:

and DataIntegrityChecks.Status in ("implemented", "needs review")

}}

* changed the order of cross checks in Public Sub Dx_Checker() to do soft ones first so that hard ones would not be overwritten by soft ones

=== 2024-... ===

@@ Line 10: / Line 10: @@
 ===2025-01-08===
-not rolled out yet
+rolled out [[User:Ttenbergen|Ttenbergen]] 15:06, 8 January 2025 (CST)
 Changes collectors '''don't''' need to know about:
-* soft checks like [[query check_CCI_each_count_vs_LOS]] were being triggered last in the error checks, meaning that they would overrule hard checks that also triggered.
+* updated [[query check_tmp_BedHeld]] to also flag if record has [[Dispo]]="AMA (left against medical advice)" but no [[BedHeldEnd DtTm]] entry
-* this would have affected queries that, on this date, matched the query underlying the following list (data on wiki changes so if you look in the future this might be different)
+* soft checks like [[query check_CCI_each_count_vs_LOS]] were being triggered last in the error checks, meaning that they would overrule hard checks that also triggered.
+** changed the order of cross checks in Public Sub Dx_Checker() to do soft ones first so that hard ones would not be overwritten by soft ones
+** this would have affected queries that, on this date, matched the query underlying the following list (data on wiki changes so if you look in the future this might be different)
 {{#cargo_query:
 tables=DataIntegrityChecks
@@ Line 21: / Line 23: @@
 and DataIntegrityChecks.Status in ("implemented", "needs review")
 }}
-* changed the order of cross checks in Public Sub Dx_Checker() to do soft ones first so that hard ones would not be overwritten by soft ones
 === 2024-... ===