Query NDC Trach Dx TISS

Data Integrity Checks
Summary:	Tracheostomy ICD10s and CCIs must be consistent with Trach TISS.
Related:	Trach Tube Present (TISS Item), Tracheostomy, has one, Tracheostomy creation
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	query NDC_Trach_Dx_TISS
Uses L Problem table:	Yes
Status:	ready to implement
Implementation Date:	2019/01/06
Backlogged:	true

• Cargo

• SMW

• Categories: 

• form:

_DEV_CFE ready to implement

added: no added date action: no action date

• Cargo

• Categories

• There are 3 potential trach-related items:
  1. Tracheostomy, has one -- a ICD10 dx code that's only allowed to be used as a comorbid diagnosis
  2. T23 - Trach Tube Present (TISS Item) -- a TISS code that's only coded in ICUs
  3. Acquired Procedure of Tracheostomy creation -- a CCI procedure code
• The crosschecks, only done for ICU admits should be:
  • if you have #3 in ICU then you must have #2 for at least one day after the trach creation
  • if you have #1 in ICU then you must have #2 for at least one day on or after admit date

Related

• Query TISS Errors Vent vs mechanism deals with T - Tracheostomy tube at 2300hrs (TISS Item) vs T23 - Trach Tube Present (TISS Item)
• in CCMDB.accdb, Query check ICD10 trach dxs consistent checks for consistent dxs and procedures

Log

2019-03-13 - first round of use, fixed query to remove a bunch of false positives and false negatives