Query check has transfer ready date or checkbox: Difference between revisions

Revision as of 15:19, 2021 February 3

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:	complete
App:	CCMDB.accdb
Coding:	query check_has_transfer_ready_entry_or_checkbox
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2021-02-03
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

	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

@@ Line 2: / Line 2: @@
 |DIC_summary=each record should have transfer ready entry and any entry needs to be internally consistent
 |DIC_related_concepts=Transfer Ready DtTm tmp entry
+|DIC_timing=complete
 |DIC_coding=query check_has_transfer_ready_entry_or_checkbox
-|DIC_status=needs review
+|DIC_implementation_date=2021-02-03
+|DIC_status=implemented
 |DIC_app=CCMDB.accdb
 |DIC_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