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

Revision as of 15:44, 2021 February 3

Data Integrity Checks
Summary:	Each Transfer Ready DtTm tmp entry has to have either a dttm, or its checkbox checked.
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

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
-|DIC_summary=each record should have transfer ready entry and any entry needs to be internally consistent
+|DIC_summary=Each [[Transfer Ready DtTm tmp entry]] has to have either a dttm, or its checkbox checked.
 |DIC_related_concepts=Transfer Ready DtTm tmp entry
 |DIC_timing=complete
@@ Line 9: / Line 9: @@
 |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
-== 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}}
+== Log ==
+* 2021-02-03 - implemented
 == Related articles ==