Query check tmp BedHeld

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:
Implementation Date:
Backlogged:	true

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.
If bed held due to a procedure, what entry in the dispo field is expected? Here the entry is HOME and not where the procedure was done (e.g. STB/HSC Cath Lab, etc.).

	JALT If bed held due to a procedure, what entry in the dispo field is expected? Here the entry is HOME and not where the procedure was done (e.g. STB/HSC Cath Lab, etc.). (Julie)

Log