Query NDC Trach Dx TISS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Text replacement - "TISS28 checks" to "TISS28 check") |
Ttenbergen (talk | contribs) No edit summary |
||
Line 4: | Line 4: | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_coding=query ''NDC_Trach_Dx_TISS'' | |DIC_coding=query ''NDC_Trach_Dx_TISS'' | ||
|DIC_implementation_date=2019 | |DIC_implementation_date=2019-01-06 | ||
|DIC_status= | |DIC_status=implemented | ||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
|DIC_backlogged=No | |||
}} | }} | ||
* if there is a [[Tracheostomy, has one]] ICD10, there needs to be a {{TISS w Nr | Trach Tube Present (TISS Item)}} for at least the first day | * if there is a [[Tracheostomy, has one]] ICD10, there needs to be a {{TISS w Nr | 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 {{TISS w Nr | Trach Tube Present (TISS Item)}} for at least the [[Px Date]] | * if there is an [[Acquired Procedure]] of [[Tracheostomy creation]], there has to be a {{TISS w Nr | Trach Tube Present (TISS Item)}} for at least the [[Px Date]] |
Revision as of 16:16, 2021 September 16
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: | CCMDB.accdb |
Coding: | query NDC_Trach_Dx_TISS |
Uses L Problem table: | not relevant for this app |
Status: | implemented |
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