Query NDC Trach Dx TISS: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 5: | Line 5: | ||
|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= | |DIC_status=ready to implement | ||
|DIC_LProblem=Yes | |DIC_LProblem=Yes | ||
|DIC_app=Centralized data front end.accdb | |DIC_app=Centralized data front end.accdb |
Revision as of 21:54, 2019 October 2
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: | Yes |
Status: | ready to implement |
Implementation Date: | 2019/01/06 |
Backlogged: | true |
- There are 3 potential trach-related items:
- Tracheostomy, has one -- a ICD10 dx code that's only allowed to be used as a comorbid diagnosis
- T23 - Trach Tube Present (TISS Item) -- a TISS code that's only coded in ICUs
- Acquired Procedure of Tracheostomy creation -- a CCI procedure code
- The crosschecks, only done for ICU admits should be:
- if you have #3 in ICU then you must have #2 for at least one day after the trach creation
- if you have #1 in ICU then you must have #2 for at least one day on or after admit date
Related
- Query TISS Errors Vent vs mechanism 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