Query NDC Trach Dx TISS

TISS28 - Check if TISS28 item 23 & item 47 if applicable is marked.

Trach TISS Items

• Trach Tube Present (TISS Item) 23
• Tracheostomy tube at 2300hrs (TISS Item) 47

ICD10 codes that have to be present when a tracheostomy is

Dxs in Category:Tracheostomy:

• Tracheostomy, has one

ICD10 codes that may only be present when a tracheostomy is

• Tracheostomy care
• Tracheostomy complication, hemorrhage from site
• Tracheostomy complication, malfunction
• Tracheostomy complication, NOS
• Tracheostomy complication, tracheo-esophageal fistula

Trach CCI Codes

• Tracheostomy creation

Checks

• Trach Tube Present (TISS Item) and Tracheostomy, has one - both or neither
• if Tracheostomy tube at 2300hrs (TISS Item), then must have Trach Tube Present (TISS Item)
• if any of #ICD10 codes that may only be present when a tracheostomy is, then must have

Tracheostomy, has one

• if Tracheostomy creation, then
  • must have Trach Tube Present (TISS Item)
  • must have Tracheostomy, has one

Data Integrity Checks
Summary:	ICD10 and CCI need to be consistent for tracheostomies (see Check trach vs TISS#Checks .
Related:	[[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]]
Firmness:	hard check
Timing:	always
App:	CCMDB.mdb
Coding:	how to find this in containing program, eg. SAS file, function name, query name...
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	date change was rolled out / first applied
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "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" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

Data Integrity Checks
Summary:	TISS, ICD10 and CCI need to be consistent for tracheostomies (see Check trach vs TISS#Checks .
Related:	[[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]]
Firmness:	hard check
Timing:	always
App:	CFE
Coding:	how to find this in containing program, eg. SAS file, function name, query name...
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	date change was rolled out / first applied
Backlogged:	true

• Cargo

• SMW

"CFE" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "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" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form: