Query check tmp BedHeld: Difference between revisions

Revision as of 08:44, 2023 May 2

Data Integrity Checks
Summary:	Validates that the DtTm for the first Service tmp entry is the same as that for the first Boarding Loc entry
Related:	BedHeldEnd DtTm, Dispo DtTm
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_tmp_BedHeld
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	not entered
Backlogged:	No

dttm entry is always required
for item in ("AMA (AWOL)", "Procedure"), BedHeldEnd DtTm must always be after Dispo DtTm
if BedHeldEnd DtTm = Dispo DtTm and Dispo = AMA, should be "AMA protocol"
for item in ("AMA (AWOL)", "AMA (Protocol)"), Dispo needs to be "AMA" and vice versa

2023-05-02 - query started
2023-01-11 - Discussed at JALT and decided to not have a cross check for "procedure" against "Dispo"
2023-01-10 - Julie identified needed checks

@@ Line 10: / Line 10: @@
 }}
+* dttm entry is always required
 * for item in ("'''AMA (AWOL)'''", "'''Procedure'''"), [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]]
-* if [[BedHeldEnd DtTm]] = [[Dispo DtTm]] and [[Dispo]] = ''AMA'', should be '''AMA protocol'''
+* if [[BedHeldEnd DtTm]] = [[Dispo DtTm]] and [[Dispo]] = ''AMA'', should be "'''AMA protocol'''"
-* if item = '''AMA protocol''' or '''AMA (Protocol)''' the dttm entry is still required
+* for item in ("'''AMA (AWOL)'''",  "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa
-* for item = '''AMA (AWOL)''' AMA entries, [[Dispo]] needs to be "AMA"
 == Log ==
-* 2023-01-11 Discussed at JALT and decided to not have a cross check for "procedure" against "[[Dispo]]"
+* 2023-05-02 - query started
-* 2023-01-10 Julie identified needed checks
+* 2023-01-11 - Discussed at JALT and decided to not have a cross check for "procedure" against "[[Dispo]]"
+* 2023-01-10 - Julie identified needed checks
 == Related articles ==