Query check TISS each day

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

. 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