Function Dispo Chronological()
| Data Integrity Checks | |
| Summary: | Checks that the registry times are in a sensible chronological order. |
| Related: | Arrive DtTm, Accept DtTm, Transfer Ready DtTm, Dispo DtTm |
| Firmness: | hard check |
| Timing: | always |
| App: | CCMDB.accdb |
| Coding: | Function Dispo_Chronological() |
| Uses L Problem table: | not relevant for this app |
| Status: | implemented |
| Implementation Date: | 2016-05-25 |
| Backlogged: | true |
The check will generate an error if:
- Arrive DtTm has to be before or equal to Accept DtTm
- Arrive DtTm has to be before or equal Transfer Ready DtTm
- Arrive DtTm has to be before Dispo DtTm
- Transfer Ready DtTm has to be before Dispo DtTm
- Dispo DtTm has to be before Now() / today
No checks on Visit Admit DtTm field since taken direct from EPR, so it is what it is.
Transfer vs (accept vs arrive)
In the real world, the Transfer Ready DtTm could well be between Accept DtTm and Arrive DtTm. Our check would flag this as an error. As per ICU Database Task Group Meeting – January 24, 2019 | Task Meeting 209-01-24 point 8 it was decided to continue to only allow a transfer date after arrival date. The rationale was that we don't care about time wasted outside of our units/wards, only on our units.
Related checks
Log
2020-10-15: removed checks against Transfer Ready DtTm since that field is being retired, see Transfer Ready DtTm tmp entry for any replacements