Query check ICD10 trach has trach but no TISS

From CCMDB Wiki
Jump to navigation Jump to search
Data Integrity Checks
Summary: If there is a Tracheostomy, has one (Z93.0) ICD10, there should likely be a T23 - Trach Tube Present (TISS Item)
Related: Tracheostomy, has one, Trach Tube Present (TISS Item)
Firmness: soft check
Timing: always
App: CCMDB.accdb
Coding: Query check_ICD10_trach_has_trach_but_no_TISS
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2022-09-28
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

This can actually happen since there could be an ostomy without a tube in it; however, it is more likely to be an error, so we are flagging it with a soft check.

Log

  • 2023-11-25 - updated to use new function admission_program([L_Log.Pat_ID])
  • 2022-11-31 - updated to only include critical care patients
  • 2022-09-28 - created query

Related articles

Related articles: