Query NDC Trach Dx TISS
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 |
- at least one T23 - Trach Tube Present (TISS Item) and Tracheostomy, has one - both or neither
- CCI: if there is a Acquired Procedure of Tracheostomy creation, there must be at least one T23 - Trach Tube Present (TISS Item).
- but not vice versa, they could have arrived with trach in place
At our cross check meeting you wrote: "we need to fine-tune this query later" - what was that about? |
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