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:	needs review
Implementation Date:	not entered
Backlogged:	No

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 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"
2023-01-10 Julie identified needed checks