Query check tmp BedHeld
| Data Integrity Checks | |
| Summary: | Sanity check for BedHeldEnd DtTm |
| 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: | implemented |
| Implementation Date: | 2023-05-02 |
| Backlogged: | No |
- dttm entry is always required
- for item in ("AMA (AWOL)", "Procedure"), BedHeldEnd DtTm must always be after Dispo DtTm
- if BedHeldEnd DtTm = Dispo DtTm and Dispo = "AMA (left against medical advice)", should be "AMA protocol" and vice versa
- for item in ("AMA (AWOL)", "AMA (Protocol)"), Dispo needs to be "AMA" and vice versa
- if record has [[Dispo]="AMA (left against medical advice)" there must be a BedHeldEnd DtTm entry
Log
- 2025-01-08 - updated query check_tmp_BedHeld to also flag if record has [[Dispo]="AMA (left against medical advice)" but no BedHeldEnd DtTm entry
- 2023-07-06 - the query is being called out of tmp checker, so it must be running now, considering question dealt with
- 2023-05-02 - query defined and written but waiting to find out if this can be before complete or only after (emailed)
- 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: |