Query NDC Trach Dx TISS: Difference between revisions

Revision as of 20:54, 2019 January 6

Data Integrity Checks
Summary:	Tracheostomy ICD10s and CCIs must be consistent with Trach TISS.
Related:	Trach Tube Present (TISS Item), Tracheostomy tube at 2300hrs (TISS Item), Tracheostomy, has one, Tracheostomy care, Tracheostomy creation
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	query NDC_Trach
Uses L Problem table:	Yes
Status:	needs review
Implementation Date:	date change was rolled out / first applied
Backlogged:	true

CCI: if there is a Acquired Procedure of Tracheostomy creation, there must be at least one Trach Tube Present (TISS Item).
- but not vice versa, they could have arrived with trach in place

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
 |DIC_summary=Tracheostomy ICD10s and CCIs must be consistent with Trach TISS.
-|DIC_related_concepts=Trach Tube Present (TISS Item);Tracheostomy tube at 2300hrs (TISS Item);Tracheostomy, has one;Tracheostomy care;Tracheostomy complication, hemorrhage from site;Tracheostomy complication, malfunction;Tracheostomy complication, NOS;Tracheostomy complication, tracheo-esophageal fistula;Tracheostomy creation
+|DIC_related_concepts=Trach Tube Present (TISS Item);Tracheostomy tube at 2300hrs (TISS Item);Tracheostomy, has one;Tracheostomy care; Tracheostomy creation
 |DIC_firmness=hard check
 |DIC_coding=query ''NDC_Trach''
@@ Line 10: / Line 10: @@
 }}
-* [[Trach Tube Present (TISS Item)]] and [[Tracheostomy, has one]] - both or neither
+* at least one [[Trach Tube Present (TISS Item)]] and [[Tracheostomy, has one]] - both or neither
-*CCI: if there is a [[Acquired Procedure]] of [[Tracheostomy creation]],  there must be at least one [[Trach Tube Present (TISS Item)]].
+* CCI: if there is a [[Acquired Procedure]] of [[Tracheostomy creation]],  there must be at least one [[Trach Tube Present (TISS Item)]].
 ** but not vice versa, they could have arrived with trach in place