Query check has transfer ready date or checkbox

Data Integrity Checks
Summary:	make sure there are sensibly dated entries
Related:	Service tmp entry, Transfer Ready DtTm tmp entry
Firmness:	not entered
Timing:	always
App:	CCMDB.accdb
Coding:	none yet
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	not entered
Backlogged:	No

make sure there either is an TR entry for each Level of care hierarchy component of the stay, or the "no entry" rules are followed correctly

Data Integrity Checks (automatic list)

none found