Query check tmp BedHeld: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 4: | Line 4: | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |DIC_timing=complete | ||
|DIC_coding=query '' | |DIC_coding=query ''check_tmp_BedHeld'' | ||
|DIC_status=needs review | |DIC_status=needs review | ||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
Revision as of 08:28, 2 May 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 check_tmp_BedHeld |
| 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
Related articles
| Related articles: |