Query NDC Trach Dx TISS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m (Text replacement - "CCMDB.mdb" to "CCMDB.accdb") |
||
Line 18: | Line 18: | ||
== Related == | == Related == | ||
* [[Query 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 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. | * in [[CCMDB.accdb]], [[Query check ICD10 trach dxs consistent]] checks for consistent dxs and procedures | ||
== Log == | == Log == |
Revision as of 11:45, 2019 September 22
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