Query NDC Trach Dx TISS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(35 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{LegacyContent
|explanation=etired when we stopped TISS forms, see
|successor=[[Query check_ICD10_trach_dxs_consistent]]
|content= 
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = * [[Trach Tube Present (TISS Item)]] and [[Tracheostomy, has one]] - both or neither
|DIC_summary=Tracheostomy ICD10s and CCIs must be consistent with Trach TISS.
* if [[Tracheostomy tube at 2300hrs (TISS Item)]], then must have [[Trach Tube Present (TISS Item)]]
|DIC_related_concepts=Trach Tube Present (TISS Item); Tracheostomy, has one; Tracheostomy creation
* if [[Tracheostomy creation]], then must have [[Trach Tube Present (TISS Item)]]
|DIC_firmness=hard check
| 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]]
|DIC_coding=query ''NDC_Trach_Dx_TISS''
| DIC_firmness = hard check  
|DIC_implementation_date=2019-01-06
| DIC_app = Centralized data front end.accdb
|DIC_status=retired
| DIC_coding = how to find this in containing program, eg. SAS file, function name, query name...
|DIC_app=Centralized data front end.accdb
| DIC_status = needs review
|DIC_backlogged=No
| DIC_implementation_date = date change was rolled out / first applied
}}
}}
* if there is a [[Tracheostomy, has one]] ICD10, there needs to be a {{TISS w Nr | 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 {{TISS w Nr | Trach Tube Present (TISS Item)}} for at least the [[Px Date]]
== Related ==
* [[query check_CCI_TISS_Intubation_vs_Intubated]] deals with {{TISS w Nr | Tracheostomy tube at 2300hrs (TISS Item)}} vs  {{TISS w Nr | 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 ==
{{Related Articles}}


[[Category:Tracheostomy]]
[[Category:Tracheostomy]]
[[Category:ICD10 Dx check]]
[[Category:ICD10 Dx check]]
[[Category:Legacy CCI Px check]]
[[Category:TISS28 Legacy]]
}}

Latest revision as of 16:34, 2021 September 16

Legacy Content

This page contains Legacy Content.

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:

Related

Log

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

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_NDC_Trach_Dx_TISS&oldid=152065"