CCMDB.accdb Change Log 2025: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 10: | Line 10: | ||
===2025-01-08=== | ===2025-01-08=== | ||
rolled out [[User:Ttenbergen|Ttenbergen]] 15:06, 8 January 2025 (CST) | |||
Changes collectors '''don't''' need to know about: | 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: | {{#cargo_query: | ||
tables=DataIntegrityChecks | tables=DataIntegrityChecks | ||
| Line 21: | Line 23: | ||
and DataIntegrityChecks.Status in ("implemented", "needs review") | and DataIntegrityChecks.Status in ("implemented", "needs review") | ||
}} | }} | ||
=== 2024-... === | === 2024-... === | ||
Revision as of 15:06, 8 January 2025
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.
2025-...
not rolled out yet
Changes collectors need to know about:
2025-01-08
rolled out Ttenbergen 15:06, 8 January 2025 (CST)
Changes collectors don't need to know about:
- updated query check_tmp_BedHeld to also flag if record has Dispo="AMA (left against medical advice)" but no BedHeldEnd DtTm entry
- 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)
| _pageName | Status | Firmness |
|---|---|---|
| Function long LOS() | needs review | soft check |
| Link suspect mismatch pre inpt ours incomplete query | implemented | soft check |
| Link suspect not same visitAdmitDtTm query | implemented | soft check |
| PL DiffPhin SameLN FN DOB | implemented | soft check |
| PL SamePHIN Site Diff chart | implemented | soft check |
| Query check CCI each count vs LOS | needs review | soft check |
| Query check CCI TISS discontinuous ETT | implemented | soft check |
| Query check ICD10 ESRD and AKI only if transplant | implemented | soft check |
| Query check ICD10 trach has trach but no TISS | implemented | soft check |
| Query check long transfer delay | needs review | soft check |
| Query check pt from ER | implemented | soft check |
| Query Check VADT too close to first boarding loc | needs review | soft check |
| Query s tmp Boarding Loc ER delay reasonable | implemented | soft check |