Query check TISS each day

From CCMDB Wiki
Revision as of 10:40, 2021 September 2 by Ttenbergen (talk | contribs)
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
  • Cargo


  • SMW


  • Categories: 
  • form:

. 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

Related articles

Related articles: