Query NDC Trach Dx TISS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "Tracheostomy tube at 2300hrs (TISS Item)" to "{{TISS w Nr | Tracheostomy tube at 2300hrs (TISS Item)}}")
mNo edit summary
 
(14 intermediate revisions by 2 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=Tracheostomy ICD10s and CCIs must be consistent with Trach TISS.
|DIC_summary=Tracheostomy ICD10s and CCIs must be consistent with Trach TISS.
Line 4: Line 9:
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_coding=query ''NDC_Trach_Dx_TISS''
|DIC_coding=query ''NDC_Trach_Dx_TISS''
|DIC_implementation_date=2019/01/06
|DIC_implementation_date=2019-01-06
|DIC_status=implemented
|DIC_status=retired
|DIC_LProblem=Yes
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
}}
}}
* at least one {{TISS w Nr | Trach Tube Present (TISS Item)}} and [[Tracheostomy, has one]] - both or neither
* 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]]
* CCI: if there is a [[Acquired Procedure]] of [[Tracheostomy creation]], there must be at least one {{TISS w Nr | Trach Tube Present (TISS Item)}}
** but not vice versa, they could have arrived with trach in place


== Related ==
== Related ==
* [[TISS Errors Vent vs mechanism]] deals with {{TISS w Nr | Tracheostomy tube at 2300hrs (TISS Item)}} vs  {{TISS w Nr | Trach Tube Present (TISS Item)}}  
* [[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.mdb]], [[Query check ICD10 trach dxs consistent]] checks for consistent dxs and procedures
* in [[CCMDB.accdb]], [[Query check ICD10 trach dxs consistent]] checks for consistent dxs and procedures


== Log ==
== Log ==
Line 27: Line 30:
[[Category:Tracheostomy]]
[[Category:Tracheostomy]]
[[Category:ICD10 Dx check]]
[[Category:ICD10 Dx check]]
[[Category:CCI Px check]]
[[Category:Legacy CCI Px check]]
[[Category:TISS28 checks]]
[[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: