Query NDC Trach Dx TISS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Text replacement - "Trach Tube Present (TISS Item)" to "{{TISS w Nr | Trach Tube Present (TISS Item)}}") |
Ttenbergen (talk | contribs) m (Text replacement - "Tracheostomy tube at 2300hrs (TISS Item)" to "{{TISS w Nr | Tracheostomy tube at 2300hrs (TISS Item)}}") |
||
| Line 15: | Line 15: | ||
== Related == | == Related == | ||
* [[TISS Errors Vent vs mechanism]] deals with | * [[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)}} | ||
* in [[CCMDB.mdb]], [[Query check ICD10 trach dxs consistent]] checks for consistent dxs and procedures | * in [[CCMDB.mdb]], [[Query check ICD10 trach dxs consistent]] checks for consistent dxs and procedures | ||
Revision as of 22:00, 2019 April 28
| 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
Related
- TISS Errors Vent vs mechanism deals with T - Tracheostomy tube at 2300hrs (TISS Item) vs T23 - Trach Tube Present (TISS Item)
- in CCMDB.mdb, 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