Query check tmp BedHeld: Difference between revisions
Jump to navigation
Jump to search
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 | ||
Revision as of 10:35, 2023 January 11
| 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.
Also:
- For the two AMA entries, Dispo needs to be "AMA"
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
Related articles
| Related articles: |