Query check tmp BedHeld: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) No edit summary |
||
| Line 4: | Line 4: | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |DIC_timing=complete | ||
|DIC_coding= query ''XXXXX'' | |DIC_coding=query ''XXXXX'' | ||
|DIC_status=needs review | |||
|DIC_status= | |||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
|DIC_backlogged=No | |||
}} | }} | ||
Required checks as per Julie: | Required checks as per Julie: | ||
# for AMA AWOL or procedure, bed held end dttm must always be after dispo dttm. | # for AMA AWOL or procedure, bed held end dttm must always be after dispo dttm. | ||
| Line 19: | Line 18: | ||
== Log == | == Log == | ||
* 2023-01-11 Discussed at | * 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 | * 2023-01-10 Julie identified needed checks | ||
Revision as of 16:02, 2 February 2023
| 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 |
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 JALT and decided to not have a cross check for "procedure" against "Dispo"
|
JALT
|
- 2023-01-10 Julie identified needed checks
Related articles
| Related articles: |
