Query check tmp BedHeld: Difference between revisions

Revision as of 09:19, 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 XXXXX
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	not entered
Backlogged:	No

for item = AMA (AWOL) or item = Procedure, BedHeldEnd DtTm must always be after Dispo DtTm
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 = AMA (AWOL) AMA entries, Dispo needs to be "AMA"

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 9: / Line 9: @@
 |DIC_backlogged=No
 }}
-Required checks as per Julie:
-# for AMA AWOL or procedure, bed held end dttm must always be after dispo dttm.
-# if bed held end dttm = dispo dttm and AMA, should be AMA protocol.
-# If item= AMA protocol , the dttm entry is still required.
-Also:
+* for item = '''AMA (AWOL)''' or item = '''Procedure''', [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]]
-* For the two AMA entries, [[Dispo]] needs to be "AMA"
+* 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 = '''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]]"
-{{Discuss | JALT
-* Checked [[JALT_Meeting_-_Rolling_Agenda_and_Minutes_2023#JALT_Meeting_–_January_11/12,_2023]] and there are no details there... did we decline this check? [[User:Ttenbergen|Ttenbergen]] 16:02, 2023 February 2 (CST)
-}}
 * 2023-01-10 Julie identified needed checks