Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm

From CCMDB Wiki
Revision as of 11:31, 30 July 2025 by Ttenbergen (talk | contribs) (Text replacement - "[[Category: " to "[[Category:")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Data Integrity Checks
Summary: If an ICD10 code in Category:Awaiting/delayed transfer is Primary Admit Diagnosis/Dx Primary then Transfer Ready DtTm must equal "Arrive DtTm"
Related: Boarding Loc, Primary Admit Diagnosis, Dx Primary, Admit Diagnosis
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check_ICD10_PrDx_Awaiting_but_not_transferReady
Uses L Problem table: not relevant for this app
Status: declined
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:
  • Panelling_admit_transfer_same(Pat_ID): a record is an error if both

Declined

  • new check should likely go against Boarding Loc entries instead of "Arrive DtTm"s, but now that there may be several Transfer Ready DtTm tmp entry entries, is that check still the right logic? Should it instead check every awaiting code against a TR date entry? Or does the whole thing become so messy that we shouldn't do it at all?
    • Discussed at AJTT: Allan suggested we not chck this, and Julie agreed to not have this check.
Related articles: