Query check TISS each day
Jump to navigation
Jump to search
| 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