Query check has transfer ready date or checkbox

Data Integrity Checks
Summary:	make sure there are sensibly dated entries
Related:	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

Needs review

	On a first read I am not sure how we would make sure this exists for each level of care; it would be a complicated query; how badly do we want this? Is there a simplified version that only makes sure a first entry exists, and that any entry that does exist is internally consistent (no time checkbox vs having a time vs presence of acceptable comment entry)

none found