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

Revision as of 22:45, 15 October 2020

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

	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 1: / Line 1: @@
 {{Data Integrity Check
 |DIC_summary=make sure there are sensibly dated entries
-|DIC_related_concepts=Service tmp entry; Transfer Ready DtTm tmp entry
+|DIC_related_concepts=Transfer Ready DtTm tmp entry
 |DIC_coding=none yet
 |DIC_status=needs review
@@ Line 9: / Line 9: @@
 *  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 ==
+{{Discuss |
+* 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)
+}}
 {{Data Integrity Check List}}