Query NDC Trach Dx TISS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 25: | Line 25: | ||
[[Category:Tracheostomy]] | [[Category:Tracheostomy]] | ||
[[Category:ICD10 Dx check]] | [[Category:ICD10 Dx check]] | ||
[[Category:CCI Px check]] | [[Category:Legacy CCI Px check]] | ||
[[Category:TISS28 | [[Category:TISS28 Legacy]] | ||
Revision as of 15:32, 16 September 2021
| 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: | not entered |
| Status: | retired |
| Implementation Date: | 2019-01-06 |
| Backlogged: | No |
- if there is a Tracheostomy, has one ICD10, there needs to be a T23 - Trach Tube Present (TISS Item) for at least the first day
- if there is an Acquired Procedure of Tracheostomy creation, there has to be a T23 - Trach Tube Present (TISS Item) for at least the Px Date
Related
- query check_CCI_TISS_Intubation_vs_Intubated 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