Query check TISS each day: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 5: | Line 5: | ||
|DIC_timing=complete | |DIC_timing=complete | ||
|DIC_coding=Query ''check_TISS_each_day'' | |DIC_coding=Query ''check_TISS_each_day'' | ||
|DIC_status= | |DIC_status=declined | ||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
}} | }} | ||
. | . | ||
This check is not actually needed. [[ query check_CCI_TISS_NrDays_LT_LOS]] and [[query check_CCI_TISS_NrDays_GT_LOS]] should cover it? There was confusion because Julie had found errors in old data that was entered before these checks were implemented. | |||
== Log == | == Log == | ||
Revision as of 16:57, 2021 August 25
| Data Integrity Checks | |
| Summary: | There needs to be at least one TISS entry in CCI Picklist for each day for each ICU profile. |
| Related: | TISS28, Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg, Change from Awaiting/delayed dx codes to Transfer Ready DtTm, Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm, Template:ICD10 Guideline AwaitingTransfer, Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days, Task Team Meeting - Rolling Agenda and Minutes 2021, Transfer Ready DtTm tmp entry |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.accdb |
| Coding: | Query check_TISS_each_day |
| Uses L Problem table: | not relevant for this app |
| Status: | declined |
| Implementation Date: | not entered |
| Backlogged: | true |
. This check is not actually needed. query check_CCI_TISS_NrDays_LT_LOS and query check_CCI_TISS_NrDays_GT_LOS should cover it? There was confusion because Julie had found errors in old data that was entered before these checks were implemented.
Log
- 2021-08-25 - identified need for replacement for Query TISS_Errors_missing_days