Query NDC Trach Dx TISS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
No edit summary |
||
| Line 9: | Line 9: | ||
|DIC_app=Centralized data front end.accdb | |DIC_app=Centralized data front end.accdb | ||
}} | }} | ||
* | *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 | |||
* | *#{{TISS w Nr | 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 == | == Related == | ||
Revision as of 10:55, 24 September 2019
| 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: | implemented |
| 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
Related articles
| Related articles: |