Query check has transfer ready date or checkbox

Data Integrity Checks
Summary:	each record should have transfer ready entry and any entry needs to be internally consistent
Related:	Transfer Ready DtTm tmp entry
Firmness:	not entered
Timing:	always
App:	CCMDB.accdb
Coding:	query check_has_transfer_ready_entry_or_checkbox
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	not entered
Backlogged:	No

• Cargo

• SMW

• Categories: 

• form:

• 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)

• SMW

• Cargo

• Categories

Data Integrity Checks (automatic list)

none found