Query check tmp BedHeld: Difference between revisions
Ttenbergen (talk | contribs) Created page with "{{Data Integrity Check |DIC_summary=Validates that the DtTm for the first Service tmp entry is the same as that for the first Boarding Loc entry |DIC_related_concepts=BedHeldEnd DtTm; Dispo DtTm |DIC_firmness=hard check |DIC_timing=complete |DIC_coding= query ''XXXXX'' |DIC_implementation_date= |DIC_status= |DIC_app=CCMDB.accdb }} Required checks as per Julie: # for AMA AWOL or procedure, bed held end dttm must always be after dispo dttm. # if bed held end dt..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 14: | Line 14: | ||
# if bed held end dttm = dispo dttm and AMA, should be AMA protocol. | # if bed held end dttm = dispo dttm and AMA, should be AMA protocol. | ||
# If item= AMA protocol , the dttm entry is still required. | # If item= AMA protocol , the dttm entry is still required. | ||
Also: | |||
* | * For the two AMA entries, [[Dispo]] needs to be "AMA" | ||
== Log == | == Log == | ||
* 2023-01-11 Discussed at Task and decided to not have a cross check for "procedure" against "[[Dispo]]" | |||
* 2023-01-10 Julie identified needed checks | * 2023-01-10 Julie identified needed checks | ||