Query check TISS each day

From CCMDB Wiki
Revision as of 11:33, 8 September 2021 by Ttenbergen (talk | contribs) (Text replacement - "TISS28 checks" to "TISS28 check")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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, 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: