Query NDC Trach Dx TISS

Legacy Content

This page contains Legacy Content.

• Explanation: etired when we stopped TISS forms, see
• Successor: Query check_ICD10_trach_dxs_consistent

Expand

Click Expand to show legacy content.

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:	not entered
Status:	retired
Implementation Date:	2019-01-06
Backlogged:	No

• Cargo

• SMW

• Categories:  

• form:

• if there is a Tracheostomy, has one ICD10, there needs to be a T23 - Trach Tube Present (TISS Item) for at least the first day
• if there is an Acquired Procedure of Tracheostomy creation, there has to be a T23 - Trach Tube Present (TISS Item) for at least the Px Date

Related

• query check_CCI_TISS_Intubation_vs_Intubated 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

Related articles