CCMDB.accdb Change Log 2025: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 14: | Line 14: | ||
* Adding background functionality for [[Project Overstay2]] | * Adding background functionality for [[Project Overstay2]] | ||
** Module Overstay2 - code to generate the score with current dataset | ** Module Overstay2 - code to generate the score with current dataset | ||
* updated query ''L_ICD10_Charlson_agepts'' - it was still using [[ | * updated query ''L_ICD10_Charlson_agepts'' - it was still using [[Arrive DtTm]] and now uses [[created_AdmitDtTm query]]. [[User:Ttenbergen|Ttenbergen]] 10:39, 28 January 2025 (CST) | ||
===2025-01-20=== | ===2025-01-20=== | ||
Revision as of 12:06, 28 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-01-28
not rolled out yetTtenbergen 10:07, 28 January 2025 (CST)
Changes collectors don't need to know about:
- Adding background functionality for Project Overstay2
- Module Overstay2 - code to generate the score with current dataset
- updated query L_ICD10_Charlson_agepts - it was still using Arrive DtTm and now uses created_AdmitDtTm query. Ttenbergen 10:39, 28 January 2025 (CST)
2025-01-20
rolled out Lisa Kaita 19:38, 20 January 2025 (CST)
Changes collectors need to know about:
- deactivated the allied health care project in the S tmp
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 Diff Phin 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 s tmp Boarding Loc ER delay reasonable | implemented | soft check |