CCMDB.accdb Change Log 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-20

rolled out Lisa Kaita 19:38, 20 January 2025 (CST)

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

2024-...